Is gnis process currently working?

[kentwoodkrew]

I finally managed to get gnis process installed properly, I think, but it never creates a file. The error log says "dbf file (.dbf) can not be opened". Looking at pasted logs has me thinking that the data format has been changed again. Had some problems getting some needed files installed and registered but now GP does act like it is working yet without any end result. Just wondering if it is me or has the source has changed again. Thanks. Ken

[Seldom]

I've never used the GNIS process you refer to (I use GM), but the GNIS format has changed at least twice in the past two years.  I've dealt with it by entering the data in Excel and using Excel to reorganize the fields to a known good sequence.

[kentwoodkrew]

I've never used the GNIS process you refer to (I use GM), but the GNIS format has changed at least twice in the past two years.  I've dealt with it by entering the data in Excel and using Excel to reorganize the fields to a known good sequence.

Hi. Thanks for your reply to my post about the gnis process program.  I guess it is not working. Could you tell me how to get the data and process it for and with global mapper to get myself to the end of "How To Create Garmin Topo Maps - Part 5 - Points of Interest" of the map making tutorial. I have managed to finish the previous steps using global mapper though I am no expert user. Thanks.

[-Oz-]

I believe it isn't working.  I will try to work on it this weekend because I need to use it myself.

[kentwoodkrew]

I believe it isn't working.  I will try to work on it this weekend because I need to use it myself.

Wonderful. Many thanks. I have some questions about the process I would like to ask when my brain recovers from the latest  insane workweek 

[jbensman]

I emailed the GNIS people and pointed out the requirements of the Freedom of Infrmaiton Act on making data available in the format requested by the public.  They have just offered to create a dataset for me and want to know the specifics.  I tenatively plan to ask them to do a shapefile with elevation in feet for the entire country or maybe by state.  Or I could ask him to put them on thier website in the prepackaged csv files but in feet.  The way I process GNIS having them in shapefiles would be the best.  But before I respond, I would like to hear if anyone has any thoughts on this. 

I tried the GNIS tool on this site and it would not work.  So I do not know exactly what it does.  The way I make the GNIS is if I can find a shaefile I use MapWindow GIS to combine a field with the name and elevation and then export by type.  I can use ExpertGPS to convert the csv on thier site to a shapefile-but then it has the problem of meters not feet.

[maps4gps]

GNIS is in a standard format - simple ASCII using the 'pipe' character to seperate the fields.
I would expect it to be an automatic input for any spreadsheet program (like Excel); then convert the elevation field to feet.

[Indrid Cold]

GNIS is in a standard format - simple ASCII using the 'pipe' character to seperate the fields.
I would expect it to be an automatic input for any spreadsheet program (like Excel); then convert the elevation field to feet.

Sure is, and used my more than map makers so the current format is much better overall that shapefiles. Have to be able to see the forest, not just the trees, or something like that.

[-Oz-]

I think GNIS process is dead; I wrote a post GIS query so if you can get the data loaded into the database you can just run this query:

Code Select Expand

ALTER TABLE gnis_pts ADD COLUMN mp_type character varying(50);
ALTER TABLE gnis_pts ALTER COLUMN mp_type SET STORAGE EXTENDED;
UPDATE gnis_pts SET mp_type = '0x2F04' WHERE layer LIKE 'Airport';
UPDATE gnis_pts SET mp_type = '0x6601' WHERE layer LIKE 'Arch';
UPDATE gnis_pts SET mp_type = '0x6602' WHERE layer LIKE 'Area';
UPDATE gnis_pts SET mp_type = '0x6501' WHERE layer LIKE 'Arroyo';
UPDATE gnis_pts SET mp_type = '0x6502' WHERE layer LIKE 'Bar';
UPDATE gnis_pts SET mp_type = '0x6603' WHERE layer LIKE 'Basin';
UPDATE gnis_pts SET mp_type = '0x6503' WHERE layer LIKE 'Bay';
UPDATE gnis_pts SET mp_type = '0x6604' WHERE layer LIKE 'Beach';
UPDATE gnis_pts SET mp_type = '0x6605' WHERE layer LIKE 'Bench';
UPDATE gnis_pts SET mp_type = '0x6504' WHERE layer LIKE 'Bend';
UPDATE gnis_pts SET mp_type = '0x6401' WHERE layer LIKE 'Bridge';
UPDATE gnis_pts SET mp_type = '0x6505' WHERE layer LIKE 'Canal';
UPDATE gnis_pts SET mp_type = '0x6606' WHERE layer LIKE 'Cape';
UPDATE gnis_pts SET mp_type = '0x6403' WHERE layer LIKE 'Cemetery';
UPDATE gnis_pts SET mp_type = '0x6506' WHERE layer LIKE 'Channel';
UPDATE gnis_pts SET mp_type = '0x6404' WHERE layer LIKE 'Church';
UPDATE gnis_pts SET mp_type = '0x6607' WHERE layer LIKE 'Cliff';
UPDATE gnis_pts SET mp_type = '0x6406' WHERE layer LIKE 'Crossing';
UPDATE gnis_pts SET mp_type = '0x5500' WHERE layer LIKE 'Damn';
UPDATE gnis_pts SET mp_type = '0x6508' WHERE layer LIKE 'Falls';
UPDATE gnis_pts SET mp_type = '0x660B' WHERE layer LIKE 'Gap';
UPDATE gnis_pts SET mp_type = '0x650B' WHERE layer LIKE 'Harbor';
UPDATE gnis_pts SET mp_type = '0x3002' WHERE layer LIKE 'Hospital';
UPDATE gnis_pts SET mp_type = '0x650C' WHERE layer LIKE 'Island';
UPDATE gnis_pts SET mp_type = '0x650D' WHERE layer LIKE 'Lake';
UPDATE gnis_pts SET mp_type = '0x660E' WHERE layer LIKE 'Lava';
UPDATE gnis_pts SET mp_type = '0x640A' WHERE layer LIKE 'Locale';
UPDATE gnis_pts SET mp_type = '0x640C' WHERE layer LIKE 'Mine';
UPDATE gnis_pts SET mp_type = '0x640E' WHERE layer LIKE 'Park';
UPDATE gnis_pts SET mp_type = '0x6610' WHERE layer LIKE 'Plain';
UPDATE gnis_pts SET mp_type = '0x0D00' WHERE layer LIKE 'Populated Place';
UPDATE gnis_pts SET mp_type = '0x6611' WHERE layer LIKE 'Range';
UPDATE gnis_pts SET mp_type = '0x650E' WHERE layer LIKE 'Rapids';
UPDATE gnis_pts SET mp_type = '0x650F' WHERE layer LIKE 'Reservoir';
UPDATE gnis_pts SET mp_type = '0x6613' WHERE layer LIKE 'Ridge';
UPDATE gnis_pts SET mp_type = '0x2C05' WHERE layer LIKE 'School';
UPDATE gnis_pts SET mp_type = '0x6615' WHERE layer LIKE 'Slope';
UPDATE gnis_pts SET mp_type = '0x6511' WHERE layer LIKE 'Spring';
UPDATE gnis_pts SET mp_type = '0x6616' WHERE layer LIKE 'Summit';
UPDATE gnis_pts SET mp_type = '0x6513' WHERE layer LIKE 'Swamp';
UPDATE gnis_pts SET mp_type = '0x6411' WHERE layer LIKE 'Tower';
UPDATE gnis_pts SET mp_type = '0x6412' WHERE layer LIKE 'Trail';
UPDATE gnis_pts SET mp_type = '0x6413' WHERE layer LIKE 'Tunnel';
UPDATE gnis_pts SET mp_type = '0x6617' WHERE layer LIKE 'Valley';
UPDATE gnis_pts SET mp_type = '0x6414' WHERE layer LIKE 'Well';
DELETE FROM gnis_pts WHERE mp_type IS NULL;