Re: map polygon data for popular us cities

2011-04-02 Thread Alex Ksikes
you might be interested in this:

http://simplegeo.ksikes.net
https://github.com/alexksikes/simplegeo

On Mon, Feb 7, 2011 at 7:29 AM, Sander de Bruijne san...@debruijne.eu wrote:

 http://www.geonames.org/

 http://download.geonames.org/export/dump/?C=S;O=D


 On 02/02/2011 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?

 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


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:    http://lists.mysql.com/mysql?unsub=alex.ksi...@gmail.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: map polygon data for popular us cities

2011-02-07 Thread Sander de Bruijne


http://www.geonames.org/

http://download.geonames.org/export/dump/?C=S;O=D


On 02/02/2011 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?

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



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: map polygon data for popular us cities

2011-02-03 Thread Geert-Jan Brits
Besides the above,
I recall Flickr (you know the photo-sharing site)  being able to extract
(kind of rough) polygons from exif-data of photos (containing lat/longs) .
Since often these photo's are tagged by city they could extract city
boundaries.

See this old posts I dug up quickly, I'm not sure if development is still
active, etc.
http://code.flickr.com/blog/2008/10/30/the-shape-of-alpha/
http://biodivertido.blogspot.com/2008/11/flickr-creating-polygons-out-of-points.html

hth,
Geert-Jan

2011/2/3 viraj kali...@gmail.com

 thank you all for the links and notes.

 ~viraj

 On Thu, Feb 3, 2011 at 7:08 AM, Gavin Towey gto...@ffn.com 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 countries if I recall correctly.
 
  -Original Message-
  From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan
 De Meersman
  Sent: Wednesday, February 02, 2011 7:59 AM
  To: viraj
  Cc: mysql@lists.mysql.com
  Subject: Re: map polygon data for popular us cities
 
  On Wed, Feb 2, 2011 at 11:30 AM, viraj kali...@gmail.com 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 the nose. Have a look at the
  OpenStreetMap project, I suspect their database might be accessible under
  some open license.
 
  --
  Bier met grenadyn
  Is als mosterd by den wyn
  Sy die't drinkt, is eene kwezel
  Hy die't drinkt, is ras een ezel
 
  IMPORTANT: This email message is intended only for the use of the
 individual to whom, or entity to which, it is addressed and may contain
 information that is privileged, confidential and exempt from disclosure
 under applicable law. If you are NOT the intended recipient, you are hereby
 notified that any use, dissemination, distribution or copying of this
 communication is strictly prohibited.  If you have received this
 communication in error, please reply to the sender immediately and
 permanently delete this email. Thank you.
 

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql?unsub=gbr...@gmail.com




RE: map polygon data for popular us cities

2011-02-03 Thread Jerry Schwartz
I remember a few years back I was doing some terrain modeling, and I think 
there was a repository of files on a US government web site. It's been so long 
that I don't remember what the file format was, but I was importing them into 
a 3D graphics program. There might be flattened versions.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com

-Original Message-
From: Geert-Jan Brits [mailto:gbr...@gmail.com]
Sent: Thursday, February 03, 2011 3:44 AM
To: viraj
Cc: Gavin Towey; Johan De Meersman; mysql@lists.mysql.com
Subject: Re: map polygon data for popular us cities

Besides the above,
I recall Flickr (you know the photo-sharing site)  being able to extract
(kind of rough) polygons from exif-data of photos (containing lat/longs) .
Since often these photo's are tagged by city they could extract city
boundaries.

See this old posts I dug up quickly, I'm not sure if development is still
active, etc.
http://code.flickr.com/blog/2008/10/30/the-shape-of-alpha/
http://biodivertido.blogspot.com/2008/11/flickr-creating-polygons-out-of-
points.html

hth,
Geert-Jan

2011/2/3 viraj kali...@gmail.com

 thank you all for the links and notes.

 ~viraj

 On Thu, Feb 3, 2011 at 7:08 AM, Gavin Towey gto...@ffn.com 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 countries if I recall correctly.
 
  -Original Message-
  From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan
 De Meersman
  Sent: Wednesday, February 02, 2011 7:59 AM
  To: viraj
  Cc: mysql@lists.mysql.com
  Subject: Re: map polygon data for popular us cities
 
  On Wed, Feb 2, 2011 at 11:30 AM, viraj kali...@gmail.com 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 the nose. Have a look at the
  OpenStreetMap project, I suspect their database might be accessible under
  some open license.
 
  --
  Bier met grenadyn
  Is als mosterd by den wyn
  Sy die't drinkt, is eene kwezel
  Hy die't drinkt, is ras een ezel
 
  IMPORTANT: This email message is intended only for the use of the
 individual to whom, or entity to which, it is addressed and may contain
 information that is privileged, confidential and exempt from disclosure
 under applicable law. If you are NOT the intended recipient, you are hereby
 notified that any use, dissemination, distribution or copying of this
 communication is strictly prohibited.  If you have received this
 communication in error, please reply to the sender immediately and
 permanently delete this email. Thank you.
 

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql?unsub=gbr...@gmail.com






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



RE: map polygon data for popular us cities

2011-02-03 Thread Travis Ard
You might check here: http://www.census.gov/geo/www/tiger/

-Travis

-Original Message-
From: viraj [mailto:kali...@gmail.com] 
Sent: Wednesday, February 02, 2011 3:31 AM
To: mysql@lists.mysql.com
Subject: map polygon data for popular us cities

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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=travis_...@hotmail.com



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



map polygon data for popular us cities

2011-02-02 Thread viraj
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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: map polygon data for popular us cities

2011-02-02 Thread Johan De Meersman
On Wed, Feb 2, 2011 at 11:30 AM, viraj kali...@gmail.com 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 the nose. Have a look at the
OpenStreetMap project, I suspect their database might be accessible under
some open license.

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel


RE: map polygon data for popular us cities

2011-02-02 Thread Gavin Towey
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.com] On Behalf Of Johan De 
Meersman
Sent: Wednesday, February 02, 2011 7:59 AM
To: viraj
Cc: mysql@lists.mysql.com
Subject: Re: map polygon data for popular us cities

On Wed, Feb 2, 2011 at 11:30 AM, viraj kali...@gmail.com 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 the nose. Have a look at the
OpenStreetMap project, I suspect their database might be accessible under
some open license.

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

IMPORTANT: This email message is intended only for the use of the individual to 
whom, or entity to which, it is addressed and may contain information that is 
privileged, confidential and exempt from disclosure under applicable law. If 
you are NOT the intended recipient, you are hereby notified that any use, 
dissemination, distribution or copying of this communication is strictly 
prohibited.  If you have received this communication in error, please reply to 
the sender immediately and permanently delete this email. Thank you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: map polygon data for popular us cities

2011-02-02 Thread viraj
thank you all for the links and notes.

~viraj

On Thu, Feb 3, 2011 at 7:08 AM, Gavin Towey gto...@ffn.com 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 countries if I recall correctly.

 -Original Message-
 From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De 
 Meersman
 Sent: Wednesday, February 02, 2011 7:59 AM
 To: viraj
 Cc: mysql@lists.mysql.com
 Subject: Re: map polygon data for popular us cities

 On Wed, Feb 2, 2011 at 11:30 AM, viraj kali...@gmail.com 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 the nose. Have a look at the
 OpenStreetMap project, I suspect their database might be accessible under
 some open license.

 --
 Bier met grenadyn
 Is als mosterd by den wyn
 Sy die't drinkt, is eene kwezel
 Hy die't drinkt, is ras een ezel

 IMPORTANT: This email message is intended only for the use of the individual 
 to whom, or entity to which, it is addressed and may contain information that 
 is privileged, confidential and exempt from disclosure under applicable law. 
 If you are NOT the intended recipient, you are hereby notified that any use, 
 dissemination, distribution or copying of this communication is strictly 
 prohibited.  If you have received this communication in error, please reply 
 to the sender immediately and permanently delete this email. Thank you.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org