Welcome, Guest. Please login or register.

Login with username, password and session length
Forums Search:  


Author Topic: Water Data processing trouble  (Read 5023 times)

Fenwick Hardly

  • Jr. Member
  • **
  • Posts: 3
  • Karma: 0
    • View Profile
Water Data processing trouble
« on: October 18, 2008, 05:54:18 AM »
Hello,
I am just getting started with the Garmin topo tutorial and have run into trouble processing the water data.  I have gone through the contours and water sections without trouble until the "Export Shapefiles from PostGIS" section.  When I run the commands, I get the error message shown in the attached screen shot.  Any ideas?

I'm running GlobalMapper 10 on Windows 2000 using VMWare Fusion on a MacBook Pro.

Thanks for your help.

masdangkolo

  • Jr. Member
  • **
  • Posts: 16
  • Karma: 0
    • View Profile
Re: Water Data processing trouble
« Reply #1 on: October 18, 2008, 09:24:19 AM »
Funny,
I get exactly the same thing (you beat me to the post).  Only difference is I am running Win2K natively.

I installed PostgreSQL 8.3 and PostGIS 1.3.3 for PostgreSQL 8.3

I'm guessing there are fields or values from the original shp files that pgsql2shp is not set up to handle.

Maybe if we can get some documentation on pgsql2shp we could help trouble shoot this.

Updated...
I have found some very good documentation on PostGIS.  Guess I should have looked around first.  No guarantees I can figure this out, but I'm going to give it a try.
« Last Edit: October 18, 2008, 10:40:16 AM by masdangkolo »

-Oz-

  • Map Maker!
  • Administrator
  • Expert Advisor
  • *****
  • Posts: 1580
  • Karma: 28
    • View Profile
    • GPSFileDepot
Re: Water Data processing trouble
« Reply #2 on: October 18, 2008, 10:39:50 AM »
Very very interesting.

It says an error log was created.  can you post that?  It should be in the directory with pgsql2shp.  That will really help narrow it down.

I have yet to run into any error like this which surprises me.  What state are you working with?

Here is the documentation: http://postgis.refractions.net/documentation/
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

masdangkolo

  • Jr. Member
  • **
  • Posts: 16
  • Karma: 0
    • View Profile
Re: Water Data processing trouble
« Reply #3 on: October 18, 2008, 11:05:24 AM »
I realize that Fenwick started this thread, but since I am having what seems to be the same problem, is it ok for me to post here also?  I don't want to violate any forum etiquette.  If this is not acceptable let me know and I'll start another thread.

My error info:
processing guam NHD from TIGER 2007 data
ftp://ftp2.census.gov/geo/tiger/TIGER2007FE/66_GUAM/66010_Guam/

Could not find the dump from pgsql2shp, but did locate a log in the ...\PostgreSQL\8.3\data\pg_log directory
2008-10-18 11:45:40 PDT LOG:  database system was shut down at 2008-10-18 11:45:22 PDT
2008-10-18 11:45:40 PDT LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2008-10-18 11:45:41 PDT FATAL:  the database system is starting up
2008-10-18 11:45:41 PDT LOG:  database system is ready to accept connections
2008-10-18 11:45:41 PDT LOG:  autovacuum launcher started
2008-10-18 11:45:42 PDT LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2008-10-18 11:47:25 PDT LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2008-10-18 11:47:25 PDT NOTICE:  CREATE TABLE will create implicit sequence "nhd_area_gid_seq" for serial column "nhd_area.gid"
2008-10-18 11:47:26 PDT NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "nhd_area_pkey" for table "nhd_area"
2008-10-18 11:47:35 PDT LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2008-10-18 11:47:45 PDT LOG:  loaded library "$libdir/plugins/plugin_debugger.dll"
2008-10-18 11:48:02 PDT LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

   
2008-10-18 11:48:02 PDT LOG:  unexpected EOF on client connection

I don't think this is what we need. Will try to figure out why there is no error file even though windows says it's creating one.

masdangkolo

  • Jr. Member
  • **
  • Posts: 16
  • Karma: 0
    • View Profile
Re: Water Data processing trouble
« Reply #4 on: October 18, 2008, 01:10:43 PM »
Here's the Dr Watson log from the crash.  Made a new one with less stuff running in Windows.

Fenwick Hardly

  • Jr. Member
  • **
  • Posts: 3
  • Karma: 0
    • View Profile
Re: Water Data processing trouble
« Reply #5 on: October 18, 2008, 01:41:42 PM »
Forgive me but I am new to windows.  Where should I look for the log file?
It is not in C:\Program Files\PostgreSQL\8.3\bin.

I am working with NHD data for Arizona.

Fenwick Hardly

  • Jr. Member
  • **
  • Posts: 3
  • Karma: 0
    • View Profile
Re: Water Data processing trouble
« Reply #6 on: October 18, 2008, 02:20:13 PM »
There must be something wrong with my PostgreSQL setup or some other operator error.  I got the same error processing my transportation data.  I even tried using just Yavapai County instead of the entire state.

-Oz-

  • Map Maker!
  • Administrator
  • Expert Advisor
  • *****
  • Posts: 1580
  • Karma: 28
    • View Profile
    • GPSFileDepot
Re: Water Data processing trouble
« Reply #7 on: October 18, 2008, 06:10:20 PM »
Regretably the log doesn't help me very much.  Its all binary or something.

Forgive me but I am new to windows.  Where should I look for the log file?
It is not in C:\Program Files\PostgreSQL\8.3\bin.

I am working with NHD data for Arizona.

I am betting its Windows 2000 because I already made a topo map of Arizona and handled the water data for Yavapai county and all the others without a problem.

Why are you working with Arizona?

I would say the best bet is to email the discussion list; I've gotten instant answers from them.
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

 

anything