Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

US Cities Database?

Quote Reply
US Cities Database?
I'm thinking on getting LinksSQL to create a directory of service providers withinthe US with states as categories and cities as subcategories. My question is, is there an already made database for this structure (states/cities) available somehow for those (lucky Tongue) LinksSQL owners?? If not, does there's a workaround this... maybe importing a db from another vendor etc.

Another one... Let's say I want to take the directory to global dimensions. So that I don't have to manually create the categories for world cities etc., does there is a way of allowing a user to create(submit) a new category when submiting a link?

Thanks
Quote Reply
Re: [juaniquillo] US Cities Database? In reply to
I don't think there is anything available like this. If you had something like this for the USA;

country:state:city

Then you could translate that into country/state/city with a perl script. I'm working on a similar script at the moment. This could be adapted for global cities/areas too. The only downside, is that you need to find something that has a list of these cities already Tongue

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [juaniquillo] US Cities Database? In reply to
Just remembered I have this in one of my scripts;

Code:
my $states = q~AL|Alabama
AK|Alaska
AZ|Arizona
AR|Arkansas
CA|California
CO|Colorado
CT|Connecticut
DE|Delaware
DC|District of Columbia
FL|Florida
GA|Georgia
HI|Hawaii
ID|Idaho
IL|Illinois
IN|Indiana
IA|Iowa
KS|Kansas
KY|Kentucky
LA|Louisiana
ME|Maine
MD|Maryland
MA|Massachusetts
MI|Michigan
MN|Minnesota
MS|Mississippi
MO|Missouri
MT|Montana
NE|Nebraska
NV|Nevada
NH|New Hampshire
NJ|New Jersey
NM|New Mexico
NY|New York
NC|North Carolina
ND|North Dakota
OH|Ohio
OK|Oklahoma
OR|Oregon
PA|Pennsylvania
RI|Rhode Island
SC|South Carolina
SD|South Dakota
TN|Tennessee
TX|Texas
UT|Utah
VT|Vermont
VA|Virginia
WA|Washington
WV|West Virginia
WI|Wisconsin
WY|Wyoming
AB|Alberta
BC|British Columbia
MB|Manitoba
NB|New Brunswick
NF|Newfoundland
NT|Northwest Territory
NS|Nova Scotia
ON|Ontario
PE|Prince Edward Island
PQ|Quebec
SP|St. Pierre & Miguelon
SK|Saskatchewan
YU|Yukon Territory
AC|Australian Capital
NW|New South Wales
NO|Northern Territory
QL|Queensland
SA|South Australia
TS|Tasmania
VC|Victoria
WT|Western Australia
QC|Quebec City
CI|Chiapas
GU|Guanajuanto
PB|Puebla
QR|Quintana Roo~;

my @sliced = split /\|/, $states;

Not sure how accurate it is though.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [juaniquillo] US Cities Database? In reply to
Hi juaniquillo

I have what you want. READY. I can say LinksSQL ready. I can supply LinksSQL ready .sql files which you can important into your MYSQL database and build and your website with all states as categories and cities around 30k will be right here.

If you need, email me at nakul@nakulgoyal.com !!
>> Nakul Goyal (SEO, Link Building Expert)
Web Site Promotion
Tips 'n' Tricks
SEO News


Quote Reply
Re: [juaniquillo] US Cities Database? In reply to
Hi,

There is a program called hamweather

http://hamweather.com

It has loads of city/state information. It's a shareware/open source "odd" license with free/commercial provisions.

*BUT* if you are not reselling the data, and just using it on your own system, there is nothing that prevents you from downloading the program and using the data files. There is an SQL version, which I think has this data in sql format already.

It's a great program for adding weather to your site, and we've been running various versions for years.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] US Cities Database? In reply to
That was nice.

Nakul Goyal
www.nakulgoyal.com
SEO, SEP, SEM and Link Building Expert
>> Nakul Goyal (SEO, Link Building Expert)
Web Site Promotion
Tips 'n' Tricks
SEO News


Quote Reply
Re: [juaniquillo] US Cities Database? In reply to
Here are some goodies:
http://cvs.sourceforge.net/viewcvs.py/collective/CMFCommerce/data/#dirlist
you can find US cities and states, states abbreviations and countries also (all you have to do is to import them in your database). Hope that helps ;)

Marius
CISCO Instructor
Network Administrator
C, PHP & MySQL Programmer
Quote Reply
Re: [mciolacu] US Cities Database? In reply to
I saw that as well. What I have is a sql file. You go into PHPmyadmin, and click on importa sql, browse to the file and submit. You are done.

Just build your LinksSQL, do a staggered build and you see all the categories and sub categories. It took me 3 hrs for the build on my clients server. he was pretty happy. :-)
>> Nakul Goyal (SEO, Link Building Expert)
Web Site Promotion
Tips 'n' Tricks
SEO News


Quote Reply
Re: [nakulgoyal] US Cities Database? In reply to
I will be happy if you provide me a sql file
Megrisoft
Web Hosting Company
India Software Company
SEO Company


Quote Reply
Re: [megri] US Cities Database? In reply to
Contact me on IM or Email. Contact Info at nakulgoyal.com !!
>> Nakul Goyal (SEO, Link Building Expert)
Web Site Promotion
Tips 'n' Tricks
SEO News