Messages

Thanks very much for your replies. I guess I didn't quite follow the instructions to the letter, as I didn't put quotation marks around the "C:\your_map_directory\nhd\NHDArea.shp" part in the command prompt. Doing that made all the difference. Although I guess there's really no need for me to continue with this Illinois map. (Nice map, by the way! It shows the 1 acre pond by my house!) But I think I'll go ahead with it just to make sure I can create a topographic map.

Thanks again for your help! I wouldn't be surprised if I have to post here again before I finish.

Hi. I am totally new to this map making stuff, but I just bought a Garmin GPSmap 60CSx and I want to load topographic maps on it, so I've been trying to make my Illinois topo map. I've followed the instructions in the tutorial to the letter, but I'm stating to have problems now with the water data.

I've made it through the steps just fine until I come to the "Processing the PostGIS Data" section. In that section I have downloaded the NHD queries, and I have extracted them to the PostgreSQL bin folder. The next step is where I start to have problems.

Here is what my DOS prompt looks like:
C:\Program Files\PostgreSQL\8.3\bin>psql -d postgis -h localhost -U postgres -f area_sql.txt

When I hit enter I get the following messages:
psql:area_sql.txt:1: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:2: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:3: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:4: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:5: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:6: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:7: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:8: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:9: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:10: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:11: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:12: ERROR: relation "nhd_area" does not exist
psql:area_sql.txt:13: ERROR: relation "nhd_area" does not exist

Does anyone have any idea what's going on? I wish I knew more about this. But I have no idea what I'm even trying to accomplish in this step. I'm just blindly following instructions, so I can't even begin to figure out how to make this work now. Thanks a lot for your help!

Mike