UPDATE gnis SET MP_TYPE = '0圆603' WHERE layer LIKE 'Basin' UPDATE gnis SET MP_TYPE = '0圆502' WHERE layer LIKE 'Bar' UPDATE gnis SET MP_TYPE = '0圆501' WHERE layer LIKE 'Arroyo' UPDATE gnis SET MP_TYPE = '0圆602' WHERE layer LIKE 'Area' UPDATE gnis SET MP_TYPE = '0圆601' WHERE layer LIKE 'Arch' UPDATE gnis SET MP_TYPE = '0x2F04' WHERE layer LIKE 'Airport' You should now see a new table: mergededgesĪLTER TABLE gnis ADD COLUMN MP_TYPE character varying(50) ĪLTER TABLE gnis ALTER COLUMN MP_TYPE SET STORAGE EXTENDED.Still in pgAdmin III right click on tables and select refresh.Close the PostGIS Shapefile Import/Export manager.I had to select options and change my type of LATIN1 for some of the files. If you run into an error follow the steps shown in the log window.Select the gnis.shp file and click Open.Now go to the Plugins menu and select "PostGIS Shapefile and DBF Loader 2.2".If you do, right click it and select Delete/Drop Make sure that you don't currently have a gnis table.Click on postgis to access/initialize that database.Double click the PostgreSQL database to connect to it.This step involves deleting the information we don't need and setting the MP_TYPE so that it can, in the future, be converted into a MP then img file. ![]() You can now exit Global Mapper the file is ready.Name the file gnis and put it in your gnis folder.Click OK if you get a projection message.Click File > Export > Export Vector Format.It will give you a message about how much GNIS data it imported.Select the GNIS features text file and click open.You can now exit QGIS the file is ready.This could take a long time so be patient. For output file hit Browse and call the file gnis.For the input layer select GNISnocut and for the clip layer select GU_StateOrTerritory.Go to Vector > Geoprocessing Tools > Clip.Add the vector layer GU_StateOrTerritory.shp file modified back in part 1 (Layer > Add Layer > Add Vector Layer.) Now some of the points will likely be outside the state even though they shouldn't be, we need to fix this.Select the following columns (hold CTRL to select them all at once): FEATURE_ID, STATE_ALPH, STATE_NUME, COUNTY_NAM, COUNTY_NUM, PRIMARY_LA, PRIM_LONG_, SOURCE_LAT, SOURCE_LON, SOURCE_L_1, SOURCE_L_2, ELEV_IN_M, MAP_NAME, DATE_CREAT, DATE_EDITE and click Delete.Select the feature_cl column and rename it layer.Select the feature_NA column and rename it NAME.Now click on the new gnis layer and then open the Table Manager.Hit Browse in the Save As box and save the file as GNISnocut.shp.In the Layers panel right click on GNIS and select Save As.For coordinate reference system select NAD83.With "Point coordinates" selected as the geometry definition set the X field to "PRIM_LONG_DEC" and the Y field to "PRIM_LAT_DEC".Make sure the "First record has field names" is checked.Uncheck the tab box and put a | in the other delimiters box.For file format select "Custom delimeters".For filename select the GNIS text file.Select Layer > Add Layer > Add Delimited Text Layer.This can be done with QGIS or Global Mapper. The ASCII text file must be converted into a shapefile so that we can process it. Click Download to download the GNIS file for your state.With the point drawn click Find Products in the left pane.Click the draw point button and draw a point inside the state.On the left click the box for "Names - Geographic Names Information System (GNIS)".Open the National Map Viewer (Download version).As with most of the other features this data has been rolled into the USGS National Map as well. ![]() Downloading The POI DataĪs time has passed the process for getting the GNIS data has changed. The data comes from the USGS Geographic Names Information System (GNIS). ![]() In this tutorial we will download thousands of points of interest that would normally be included on topographic maps. This includes airports, summits, towns, rapids, etc. The 4th part of this tutorial details where to get and how to process points of interest data. How To Create Garmin Topo Maps - Part 5 - Points of InterestĪuthor: Dan Blomberg | Last updated March 21st, 2016 at 01:01pm Introduction
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |