Messages

I am going to play with this because I would like to learn this process. At this point I am not sure how you split them. But the TIGER files have the salt water bodies by going to all hydrology. If I get frustrated I may go that route.
Cheers-Marc

Yes I think this will do just what I need, thank you for your work. How did you select it in such a way that only the water is blue? I ended up with the land blue.
Cheers-Marc

Hmmm, I still need to find the shoreline (toss me a rope)  

I'll search around for the data and give it a go. I would have thought it to be in the nhd files since the water bodies are in the state.
Thanks again-Marc

I am getting ready to finish my Washington state map but am hoping to overcome something. If one stands at 48* o1. 086 122* 42. 064 you are standing on a causeway between salt water bays. The base map for Garmin will show the water bodies, but when one downloaded all the NHD files for the state and make a (non-transparent) map you do not see them. You do see (on the handheld) the small stream which flows between them. The NHD files have every fresh water body I checked on but none of the strait of Jaun De Fuca, hood canal or so on. So would it be best to make the map transparent or change the levels in the header to something like 24, 23, 22, 20, 19, 18, and 17 (1-7). The map I made (olympic peninsula only in this case) used 24, 22, 20, 19, 18, 17.
Thanks-Marc
 

OZ, I did not ever have a issue with the manual runs, I could not create the same tables.
SOOOO....
I completely deleted everything, cleaned registry both with jvtools and regedit.
re-installed everything and ran transportation today and everything is fine. Ended up with the MP_TYPE needed to go forward but interesting it took twice as long (7 hours) and file is twice as large.
One thing I did was to attempt to do things one stage at a time, ie: download, then come back and combine, then comeback  and process the current set up only  allows  combine at once, no return to operation.
But what the hey it is a great tool even if I had some issues getting it to work.

Which everything?  Topo Process or PostgreSQL?

Frankly I was going to delete and re-install everything. Something is corrupt somewhere. I was able to build a map manually but since then have just spun my wheels.
I'll wait to see the dos runs.
Cheers-Marc

I know I've asked this before; are you using a password for your postgresql username?

No password. I am going to delete everything. Thanks-Marc

I ran the transpotation with admin opened up. Made sure all the connections and settings where corrrect. While nothing ever did come up in the sql panel if one watched the statistics one saw postgise open and wait while the transfer happened (couple og hours) then when the shape file was being exported that postgise line had a dialog line (which I did not write down}
So then I opened up the new shape file and once again I di not come up with a MP_TYPE option.
Maybe I need to delete all previous sgl data?
Cheers-Marc

I have not watched it in admin, I will and let you know.
Thanks-Marc

Well deepspace, you are correct.  It appears that the area.sql file (should be located in the topo process directory) isn't being run.  If it were some of the items you have would have been deleted and there would have been an MP_TYPE column.  Do you have topo process in a completely separate directory from the map files? If not I'd suggest you redownload it and make it in a separate directory.

Secondly, in the topo_process directory can you open up area.sql in notepad and make sure it looks like this:

Code Select Expand

ALTER TABLE nhd_area ADD COLUMN mp_type character varying(50);
ALTER TABLE nhd_area ALTER COLUMN mp_type SET STORAGE EXTENDED;
ALTER TABLE nhd_area RENAME COLUMN gnis_name TO name;
DELETE FROM nhd_area WHERE fcode = '53700' or fcode = '30700' or fcode = '31800' or fcode = '34300' or fcode = '34305' or fcode = '34306' or fcode = '36400' or fcode = '37300' or fcode = '56800' or fcode = '43100' or fcode = '45400' or fcode = '45401' or fcode = '45402' or fcode = '45403' or fcode = '45404' or fcode = '46100' or fcode = '48500' or fcode = '40300' or fcode = '40307' or fcode = '40308' or fcode = '40309';
UPDATE nhd_area SET mp_type = '0x28' WHERE fcode = '31200' or fcode='44500';
UPDATE nhd_area SET mp_type = '0x49' WHERE fcode = '33600' or fcode = '33601' or fcode = '33602';
UPDATE nhd_area SET mp_type = '0x3b' WHERE fcode = '36200' or fcode='39800' or fcode='45500';
UPDATE nhd_area SET mp_type = '0x49' WHERE fcode = '46000' or fcode = '46006';
UPDATE nhd_area SET mp_type = '0x46' WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 15;
UPDATE nhd_area SET mp_type = '0x47' WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 10 and areasqkm < 15;
UPDATE nhd_area SET mp_type = '0x48' WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 2 and areasqkm < 10;
UPDATE nhd_area SET mp_type = '0x4c' WHERE fcode = '46003' or fcode='48400';
DELETE FROM nhd_area WHERE mp_type IS NULL;

Let me know if it does or doesn't look like that and we'll work from there.

Here is area sql un edited by me, looks fine:
ALTER TABLE nhd_area ADD COLUMN mp_type character varying(50);
ALTER TABLE nhd_area ALTER COLUMN mp_type SET STORAGE EXTENDED;
ALTER TABLE nhd_area RENAME COLUMN gnis_name TO name;
DELETE FROM nhd_area WHERE fcode = '53700' or fcode = '30700' or fcode = '31800' or fcode = '34300' or fcode = '34305' or fcode = '34306' or fcode = '36400' or fcode = '37300' or fcode = '56800' or fcode = '43100' or fcode = '45400' or fcode = '45401' or fcode = '45402' or fcode = '45403' or fcode = '45404' or fcode = '46100' or fcode = '48500' or fcode = '40300' or fcode = '40307' or fcode = '40308' or fcode = '40309';
UPDATE nhd_area SET mp_type = '0x28' WHERE fcode = '31200' or fcode='44500';
UPDATE nhd_area SET mp_type = '0x49' WHERE fcode = '33600' or fcode = '33601' or fcode = '33602';
UPDATE nhd_area SET mp_type = '0x3b' WHERE fcode = '36200' or fcode='39800' or fcode='45500';
UPDATE nhd_area SET mp_type = '0x49' WHERE fcode = '46000' or fcode = '46006';
UPDATE nhd_area SET mp_type = '0x46' WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 15;
UPDATE nhd_area SET mp_type = '0x47' WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 10 and areasqkm < 15;
UPDATE nhd_area SET mp_type = '0x48' WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 2 and areasqkm < 10;
UPDATE nhd_area SET mp_type = '0x4c' WHERE fcode = '46003' or fcode='48400';
DELETE FROM nhd_area WHERE mp_type IS NULL;

No transportation does not work either. With version 1.5 I still do not get all the counties. So I am still using v 1.3 which will get all the counties from the 2007 data base.
I am using v 8.3
Cheers-Marc

Oz, I ran it from the desktop going folder to export to being: C:\washington\water\ so I will make the other changes and try another run in the morning. So what are the changes I need to make to end up with a MP_type in transportation.
Cheers-Marc

Happy new year. Here is the dbf.
Cheers-marc

not sure what you mean by small, my areas is 66 megs, the dbf is 565 k for area.
Cheers-Marc