Search Members Help

Welcome Guest
[ Log In :: Register ]


[ Track this topic :: Email this topic :: Print this topic ]

reply to topic new topic new poll
Topic: GNIS online, GNIS database in searchable form< Next Oldest | Next Newest >
jfitzpat Offline

Group: Members
Posts: 21
Joined: Nov. 2001
    Posted: Dec. 20 2001,2:41 pm QUOTE

OK, it took all week, but I have placed all 50 states, plus the District of Columbia from the USGS Geographic Names Information System online.

I have removed all entries with unknown or bogus locations. All coordinates have been converted to WGS-84, so they should be GPS ready (note, the USGS created the data manually from printed maps, so coordinates are often off by up to 1/360th of a degree).

The search page on the Map Maker is still very simple, but I have also exposed the database for text searching (to save others the grief of converting and cleaning up millions of coordinates).

Basically, you provide the 'Where' clause of an SQL statement and get back a comma delimited text file. Available fields are:

fstate - two letter state code
fname - feature name
ftype - feature type
fcounty - feature county
lat - latitude
lon - longitude
ftopo - USGS quad name feature resides in

The big difference (for you SQL literate) is that you should use * instead of ' or " for marking strings.

Returned text is basically:

[record count] Records Found.\n

Each record is:


If you view with a browser, the records will seem to run together, but if you "view source" you will see that it is one line per record.

Some sample searches (%20 below is just a , you might not even need it for your browser):

Or, "fstate = *CA* limit 100" would return the first 100 GNIS entries in California.*

Or "fname like *%National Park%*", would return all entries with the phrase "National Park" as part of their names.*

Would return all entries located in the USGS "Burbank" Quad. You can combine as well, for example, to find all entires located between 34.000,-117.1 and 34.003,-118, you would use:

(lat > 34 and lat < 34.3 and lon > -118 and lon < -117.1)

Feel free to use this in your own scripts and programs. Provided that your application is NOT COMMERCIAL! A 'thanks' note in your about box would be nice, but not required. Better still would be a good submission to our adventure database.


P.S. For those who have written, I'll try to fix an outstanding bug with the Netscape plugin this weekend and get it online right after our holiday break.
Back to top
Profile PM 
0 replies since Dec. 20 2001,2:41 pm < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

reply to topic new topic new poll

Quick Reply: GNIS online
iB Code Buttons
You are Posting as:
Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code