Messages

Thank you all for your help things appear to have worked except I still have no M_TYPE selections. In water I have length and area plus a few others in transportation.  I have area and length options in water. Best choices?
Thanks-Marc

Sorry for not replying in a timely fashion, I fell behind the 8 ball on something. It makes total sense and will post (I am sure) a mission accomplished Tuesday. Thank you all for bearing with me as I muddles through this!
Cheers-Marc

Changed the settings:
[Software]
fwtools=C:\Program Files\FWTools2.2.8\bin
postgis=C:\Program Files\PostgreSQL\8.3\bin
cgpsmapper=C:\washington\cgpsmapper.exe
[PostGIS]
host=localhost
database=postgis
user=postgis
[User]
trans=C:\Documents and Settings\Marc\Desktop\topo_process.1.0.15
nhd=C:\washington\water
ran it twice I still have nothing. I think its best to maybe give up.

here are the settings:
[Software]
fwtools=C:\Program Files\FWTools2.2.8\bin
postgis=C:\Program Files\PostgreSQL\8.3\bin
cgpsmapper=C:\washington\cgpsmapper.exe
[PostGIS]
host=localhost
database=postgis
[User]
trans=C:\Documents and Settings\Marc\Desktop\topo_process.1.0.15
nhd=C:\washington\water
I also unzipped it directly to the Washington folder to give it a try. Here are those settings:
[Software]
fwtools=C:\Program Files\FWTools2.2.8\bin
postgis=C:\Program Files\PostgreSQL\8.3\bin
cgpsmapper=C:\Program Files\cGPSmapper\cgpsmapper.exe
[User]
dem=C:\washington\dem\78523481
interval=50
nhd=C:\washington\water
trans=C:\washington\transport
gnis=C:\washington\gnis
mp=C:\washington\dem\62841820
[PostGIS]
host=localhost
database=postgis
Cheers-Marc

I'm confused, this program (at the start of this thread) is very much separate from the tutorial.  Are you using the program or following the tutorial; that would totally change how I answer your questions.

I have been using the beta program. I just decided to try it the old way since all I was doing was spinning my wheels. I have used the water and transport no less than a dozen times now only to always end up with just a prj file in each folder.
My question was since it did not work using the method from the tutorial yesterday (which had worked before) maybe the 2 issues are some what connected via possibly the txt files I mentioned or something else. Since the result of running the sql final yesterday afternoon after combing all the statewide  files resulted in a shape file that was the same one created from my Olympic peninsula map (not the whole state as I had combined) it seems there is some conflict some where.
After all if no one else is having a issue it must be my machine
Cheers-Marc

the nhd query's which are extracted to the bin folder as per the water data page of the tutorials. They remain in the bin folder:
area.sql.txt, waterbody ect.

Well, There must be something in the data base I need to work with. I manually ran them all, but when I did the final stage I ended up with shape files from only the Olympic peninsula map I finished. Even though I ran the current shape files. Maybe re-install the txt file in the bin folder or delete altogether?

C:\washington\water\nhdxxxxx
there are 52 folders with nhxxxx inside the water folder
I downloaded them 100 quad at a time

Does c:\washington\water\NHDWaterbody.shp exist?  Does that .sql file ever come into existence.

No, it never has shown up.

[tosql.bat:]

I just went through this:
re-started service, ran water again same thing, except when reading the tosql.bat I saw a error stating it could not fine //bin/shp2pgsql.exe.
Re-installed shp2pgsql.exe (patch) and ran it again. Here are the logs:
tosql.bat:
"C:\Program Files\PostgreSQL\8.3\bin\shp2pgsql.exe" -d "C:\washington\water\NHDWaterbody.shp" NHD_Waterbody postgis > "C:\washington\water\nhd_waterbody.sql" 2> "C:\Documents and Settings\Marc\Desktop\topo_process.1.0.15\error.log"
Error.log:
Shapefile type: PolygonZ
Postgis type: MULTIPOLYGON[4]
again all I have are prj files.
driving me to drink, at least I wasn't while I did all this.
Cheers-Marc

Oz, I did the trust thing. Enough passwords in my life as it is. Well check boxes, I only see the delete files check box for water and I did not check that since I am on bandwidth probation (I live in a very remote place and only have satellite connection) for a few days for hogging bandwidth I guess.
Oh yes shutle64, I haven't downloaded the north of cape flattery yet so I can not help you. But I will resume as soon as I am out of the bandwidth doghouse, I'll let you know then.
Cheers-Marc

Oz, here is a interesting tidbit
I previously (last post) mentioned when I did all the water all I got was a prj file. When I just ran the transportation download, combine and process at once I ended up again with just a prj file in the transport folder. So then I downloaded, and then combined, checked folder all-lines.shp and the rest are there.
Then
I process the files (Postgis) and end up with a empty folder except a prj file. My paths all look correct.
Any ideas? I could just run them the other way as place on the tutorials.
Cheers-Marc

Merry Christmas everyone.
Oz, I did them one at a time, Maybe that is the error, I will run again combine at once.
I used county once and by name another time different results as you would expect.
Newest query
I ran the water body program and only ended up with prj files (area, flowline and waterbody) did not end up with either shp files nor dbf.
I did it twice with both versions same thing.
I did end up with a error txt which read:
C:\washington\water\NHDWaterbody.shp: shape (.shp) or index files (.shx) can not be opened, will just import attribute data.
C:\washington\water\NHDWaterbody.shp: dbf file (.dbf) can not be opened.
Feel like I am being a pain the rear for asking for so much help.
Cheers-Marc

there are numbers in series but not the hex numbers you refer to. example of numbers on 1 line going from left to right:
STATEFP=53, COUNTYTP=001, TLID=181850066, TFIDL=206369161, TFIDR=206369159, MTFCC=S1500.
I re-opened the one that I did manually and it looks right.

Hmmmm, for some reason it does not have any of those either, my field set options are:
STATEFP,COUNTYFP,COUNTYYNS,TLID,TFIDL,TFIDR,MTFCC,FULLNAME,SMD,LFROMADD,LTOGDD,FRROMADD,
and a few at the end of the string which look to be associated with rail and such.
Thanks-