Messages

sorry for being an idiot, let me know if it gets there

I do not have the current software for screen shots. When I hit enter to extract the .zip file from the subject site only, a Windows pop up box appears, it states (Windows has blocked the extraction of this file). Inside that small box is a more info button. Click on that button and all the information is in reply # 2 of this subject. I have 2 computers, 1 with Service pack 2, the other with Service pack 3 and they both block the .zip files from that site only.

Thanks Jim

Hope this is what you wanted, the state is PA, the county is Dauphin. However I downloaded all the counties .zip files there sitting on my desk top waiting to be extracted.
http://www2.census.gov/cgi-bin/shapefiles/county-files?county=42043


Thanks, Jim

Starting over...
I can unzip files from every other site, it is only the transpo files that Windows blocks. Windows is not blocking previously downloaded .zip files. I can zip a file then unzip it without issue. I tried several different options with blocking. I can unblock the transpo file from its property window and then try to unzip without rebooting. I can unblock it, reboot, and then try to unzip and Windows blocks either way. It does not revert to blocking after reboot. Unblock does not have any effect.

Thanks for helping, Jim

i down loaded 7-zip, extracted files and ran it. windows continues to block.


jim

I did not get this in an email, I been downloading zip files from several different sites without issue until the national/tiger/line shapefiles page. I select the state, select a county, check mark all lines, and select the download button. A down load file box pops up, and wants to know if I want to open or save the zip file. I can select either method it downloads to my desktop. I double click on the zip file and point it at the county folder, as soon as I hit enter a windows pop up box appears and blocks the extraction. In side the windows box is a more info button, which I copied and sent to you OZ.
I shut down both firewalls, minimized all security settings in IE7, followed the unblocking instructions from windows and they continue to block.

I like what was offered up, however I am not smart enough to know what that will do to my computer as far as security. I use the computer for business and this kind of thing.
Thank for all the effort,  Jim

here it is, thanks, jim

How blocking some attachments helps protect your computerSending and reading e-mail is one of the most popular activities on the Internet. The widespread use of this technology, however, makes it a primary way for computer viruses to spread. Because viruses and other security threats are often contained in e-mail attachments, Microsoft Windows XP Service Pack 2 (SP2) helps protect your computer by blocking e-mail attachments that might be harmful.

In most cases, Windows XP SP2 will block files that have the potential to harm your computer if they come to you through e-mail or other communication programs. Windows will block these files if your program is running in a strong security mode. Most files that contain script or code that could run without your permission will be blocked. Some common examples of this file type are those with file names that end in .exe, .bat, and .js.

Blocking these files is very important to do, since directly opening files of this type poses a risk to your computer and personal data.

Is there any way I can open files that have been blocked?

If you are certain that you trust this file and want to open it, follow the instructions below.

Save the file onto your computer.
Click Start, click My Computer, and navigate to the file that you saved.
Right-click the file that you saved, and then click Properties.
Click Unblock near the bottom of the dialog box.

Hope someone can help me on this one.  I just started down loading Transportation Data and windows blocked my first file. I have (Windows XP Home Edition) I opened the file properties and unblocked the file, rebooted and Windows still blocks it. Help, Jim

Dan, thanks to all of your help, it is working fine. I went back to where GM exports data to shape files and started fresh.

Thanks again,
Jim

After I drop/delete the Postgis table, I ran the commands to process the Postgis Data and I get no file or directory found.


Jim

I went into pgAdmin III and found my nhd table. Before I delete/dropped it, I copied the comment.


-Table: nhd_area
-- DROP TABLE nhd_area;
CREATE TABLE nhd_area
(  gid serial NOT NULL,  layer character varying(17),
comid integer,
fdate character varying(10),
resolution character varying(4),
gnis_id integer,
gnis_name character varying(31),
areasqkm double precision,
elevation double precision,
ftype character varying(16),
fcode integer,
shape_leng double precision,
shape_area double precision,
the_geom geometry,
CONSTRAINT nhd_area_pkey PRIMARY KEY (gid),
CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL),
CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = (-1)))
WITH (OIDS=FALSE);
ALTER TABLE nhd_area OWNER TO postgres;


Jim

All 3 water files (nhd_area.sql, nhd_flowline.sql and nhd_waterbody.sql are located in C:\Program Files\PostgreSQL\8.3\bin directory. In addition, I followed your tutorial to the letter, I do not use –p in my commands unless I am just trying another path.
When I run the following command, this is the response: note, The (ERROR) response runs from row16 to row 265 and the (Insert 0 1) row is approximately 200 rows.  If this step is done right, should I be looking for a file named (area_sql.txt) before I can move to Processing the PostGIS Data.

C:\Program Files\PostgreSQL\8.3\bin>
C:\Program Files\PostgreSQL\8.3\bin> psql -d postgis -h localhost -U postgres -f
NHD_area.sql
BEGIN
psql:NHD_area.sql:15: NOTICE:  CREATE TABLE will create implicit sequence "nhd_area_gid_seq1" for serial column "nhd_area.gid"
psql:NHD_area.sql:15: ERROR:  relation "nhd_area" already exists
psql:NHD_area.sql:16: ERROR:  current transaction is aborted, commands igno
red until end of transaction block
psql:NHD_area.sql:265: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK
Begin
Insert 0 1
Insert 0 1
Insert 0 1              This (Insert 0 1) is at least 200 rows long.
Insert 0 1
Insert 0 1
Commit
C:\Program Files\PostgreSQL\8.3\bin>

Thanks Jim

I finally converted the .shp files to .sql files using PostgresSQL 8.3. I am currently working on Step 4, loading the .sql files into the database without any luck. The following is the command and there response:
C:\Program Files\PostgreSQL\8.3\bin> psql -d postgis -h localhost -U postgres -p
-f nhd_flowline.sql
psql: warning: extra command-line argument "nhd_flowline.sql" ignored
psql: could not connect to server: Cannot assign requested address (0x00002741/1
0049)
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port -f?
Also what are the colors all about when you say "Make sure the part in blue points to your actual map directory and remove the red-p if your user name does not use a password.

Thanks Jim

Dan
I copied and pasted the code you suggested. (shp2pgsql "C\Penna_Topo\nhd\NHD_Area.shp" NHD_Area > nhd_area.sql) Attached is the response:

C:\Program Files\PostgreSQL\8.3bin>shp2pgsql "C\Penna_Topo\nhd\NHD_Area.shp" NHD_Area > nhd_area.sql
C\Penna_Topo\nhd\NHD_Area.shp: shape (.shp) or index files (.shx) can not be opened, will just import attribute data.
C\Penna_Topo\nhd\NHD_Area.shp: dbf file (.dbf) can not be opened.

C:\Program Files\PostgreSQL\8.3\bin
Thanks Jim

Below are some commands and responces: I tried many other commands but nothing seems to work. help please Jim

C:\Program Files\PostgreSQL\8.3\bin>Areas - shp2pgsql "C\Penna_Topo\nhd\NHD     _Area.shp"NHD_Area>nhd_area.sql
'Areas' is not recognized as an internal or external command, operable program or batch file.                                                           
C:\Program Files\PostgreSQL\8.3\bin>Areas -d shp2pgsql "C:\Penna_Topo\nhd\NHD   _Area>nhd_area.sql
'Areas' is not recognized as an internal or external command, operable program or batch file.                                                                     
C:\ProgramFiles\PostgreSQL\8.3\bin> shp2pgsql"C:\Penna_Topo\nhd\NHDArea.shp" NHD_area > nhd_area.sql
RCSID: $Id: shp2pgsql.c 2782 2008-05-27 02:59:06Z pramsey $ RELEASE: 1.3.5 USAGE: shp2pgsql [<options>] <shapefile> [<schema>.]<table>

OPTIONS:

-s <srid>  Set the SRID field. If not specified it defaults to -1.
      (-d|a|c|p) These are mutually exclusive options:
  -d  Drops the table, then recreates it and populates
        it with current shape file data.
  -a  Appends shape file into current table, must be
       exactly the same table schema.
  -c  Creates a new table and populates it, this is the
       default if you do not specify any options.
  -p  Prepare mode, only creates the table.
  -g  <geometry_column> Specify the name of the geometry column
       (mostly useful in append mode).
  -D  Use postgresql dump format (defaults to sql insert statements.
  -k  Keep postgresql identifiers case.
  -i  Use int4 type for all integer dbf fields.
  -I  Create a GiST index on the geometry column.
  -S  Generate simple geometries instead of MULTI geometries.
  -w  Use wkt format (for postgis-0.x support - drops M - drifts coordinates).
  -W <encoding> Specify the character encoding of Shape's
        attribute column. (default : "ASCII")
  -N <policy> Specify NULL geometries handling policy (insert,skip,abort)
  -n  Only import DBF file.
  -? Display this help screen

   C:\Program Files\PostgreSQL\8.3\bin>