Re: [PHP] countries,states and cities

2003-09-09 Thread Kevin Stone 

"Chris W. Parker" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Augusto Cesar Castoldi 
on Monday, September 08, 2003 4:16 PM said:

> where can I download a database with all countries and
> states and cities?

I don't know but I would also be interested in this!!

> like:
> http://www.datingplace.com/servlet/NewRegistration

What? No North Korea? ;)

Chris.

--

The world is a big place.  To get you started here's the 2000 US Census
data.  The file you want is the one labled 'Places.zip'.  The schema is
available on the page but I've posted it below for convenience sake..
http://www.census.gov/geo/www/gazetteer/places2k.html

  a.. Columns 1-2: United States Postal Service State Abbreviation
  b.. Columns 3-4: State Federal Information Processing Standard (FIPS) code
  c.. Columns 5-9: Place FIPS Code
  d.. Columns 10-73: Name
  e.. Columns 74-82: Total Population (2000)
  f.. Columns 83-91: Total Housing Units (2000)
  g.. Columns 92-105: Land Area (square meters) - Created for statistical
purposes only.
  h.. Columns 106-119: Water Area(square meters) - Created for statistical
purposes only.
  i.. Columns 120-131: Land Area (square miles) - Created for statistical
purposes only.
  j.. Columns 132-143: Water Area (square miles) - Created for statistical
purposes only.
  k.. Columns 144-153: Latitude (decimal degrees) First character is blank
or "-" denoting North or South latitude respectively
  l.. Columns 154-164: Longitude (decimal degrees) First character is blank
or "-" denoting East or West longitude respectively
Enjoy!

Kevin

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] countries,states and cities

2003-09-09 Thread Chris Shiflett 
> where can I download a database with all countries and
> states and cities?

http://www.maxmind.com/

That's a good open source one with APIs for just about everything, including an
Apache module that you can use for real-time queries even under significant
load.

Hope that helps.

Chris

=
Become a better Web developer with the HTTP Developer's Handbook
http://httphandbook.org/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] countries,states and cities

2003-09-09 Thread Chris W. Parker 
Augusto Cesar Castoldi 
on Monday, September 08, 2003 4:16 PM said:

> where can I download a database with all countries and
> states and cities?

I don't know but I would also be interested in this!!

> like:
> http://www.datingplace.com/servlet/NewRegistration

What? No North Korea? ;)



Chris.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php