thank you all for the links and notes.
~viraj
On Thu, Feb 3, 2011 at 7:08 AM, Gavin Towey wrote:
> Openstreetmap.org is as close as you'll get. I'd be surprised if they have
> shapes for cities beyond just lat/lon point data, but they should have shapes
> data for zips, counties, states and co
Openstreetmap.org is as close as you'll get. I'd be surprised if they have
shapes for cities beyond just lat/lon point data, but they should have shapes
data for zips, counties, states and countries if I recall correctly.
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail
On Wed, Feb 2, 2011 at 11:30 AM, viraj wrote:
> dear list,
> where can i find a list of map polygons for united states cities? any
> open database? or tool to obtain correct coordinates?
>
A bit offtopic here, but I suspect that most such databases will be
proprietary and thus payable through th
On Tue, 1 Feb 2011 14:46:39 -0400
Paul Halliday wrote:
> I have a query (thanks to this list) that uses a join to add country
> information to an IP. It looks like this:
>
> SELECT COUNT(signature) AS count, INET_NTOA(src_ip), map1.cc as
> src_cc, INET_NTOA(dst_ip), map2.cc as dst_cc
> FROM even
Hi Paul!
Paul Halliday wrote:
> I have a query (thanks to this list) that uses a join to add country
> information to an IP. It looks like this:
>
> SELECT COUNT(signature) AS count, INET_NTOA(src_ip), map1.cc as
> src_cc, INET_NTOA(dst_ip), map2.cc as dst_cc
> FROM event LEFT JOIN mappings AS m
dear list,
where can i find a list of map polygons for united states cities? any
open database? or tool to obtain correct coordinates?
i googled but couldn't find anything useful.. may be the terms i use
are not the correct keywords :(
any help or advice would be really appreciated.
~viraj
--
I'm using this query in a Perl program:
SELECT Distinct x.Search FROM $source.Searches AS x LEFT JOIN searching.Status
AS s
ON x.Search=s.Search AND s.Source='$source' WHERE x.RedoTime<'$now' AND
s.Search IS NULL
This program runs other programs that do internet searches. I have diffe
