<DIV>Thanks Paul:)</DIV>
<DIV>Okay everthing is installed and its up and running.</DIV>
<DIV>now the point that im stuck at is that im not sure what to put in my geometry column.</DIV>
<DIV>im not using sql commnads. im using the pgadmin interface</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>but at the top it gives me this error</DIV>
<DIV>
<P><B>SQL error:</B><BR><PRE class=data>ERROR: column "latitude" does not exist</PRE>
<P></P>
<P><B>In statement:</B><BR>INSERT INTO "geometry_columns" ("f_table_catalog", "f_table_schema", "f_table_name", "f_geometry_column", "coord_dimension", "srid", "type", "attrelid", "varattnum", "stats") </P>
<P>VALUES (Latitude, public, 'Hotspots', circle, '45.5177', '1', polygon, '1', '1', '1')</P>
<P> </P>
<P>so it says that insert failed</P>
<P>f_table_catlog is a clomun from my table??? If yea thats why i put latitude. the column latitude does exist in my table called hotspots</P>
<P>do i have to worry about entering values in every field?</P>
<P>and what exactly has to go in coord_dimension...can i put any values...or i have to put the real latitude ( or my values in the latitude?) is it supposed to be in the form of x, y coordiantes??</P>
<P> </P>
<P>Thanks</P>
<P> Wokar</P>
<P> </P></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><BR><B><I>Paul Spencer <pspencer@dmsolutions.ca></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">wokar,<BR><BR>pgsql2shp is distributed with the postgis extension to postgres. When <BR>you have a properly configured postgis database, you can create geometry <BR>columns in your tables and they represent real geometries. Your table <BR>has no 'geometry' column so the utility doesn't know how to create a <BR>shape file for it ... so it just created the attribute table.<BR><BR>I will assume you have two columns that represent the latitude and <BR>longitude. You need to review the postgis documentation on adding <BR>postgis support into your database. There are several steps, including <BR>(but not limited to) running the contents of postgis.sql and <BR>spatial_ref_sys.sql. If you haven't done this yet, you will have to.<BR><BR>Once you have spatial support installed, you can then create a new <BR>geometry column in your table (again, the postgis documentation has the <BR>necessary
steps).<BR><BR>Once you have created the geometry column, you can put real geometries <BR>in using an sql statement like:<BR><BR>update hotspots set the_geom=GeometryFromText( "POINT(" || <BR>longitude::STRING || " " || latitude::STRING || ")", -1);<BR><BR>which will create a POINT geometry from your lon/lat fields. Note the <BR>syntax may be wrong and you may have to change it depending on how you <BR>are storing the lon/lat values.<BR><BR>Once you have the_geom populated, you can run pgsql2shp :)<BR><BR>Cheers<BR><BR>Paul<BR><BR>w m wrote:<BR>> Hi,<BR>> Im trying to use the pgsql2shp command to convert a very small table from pgadmin<BR>> <BR>> My database is called montreal and the table is called hotspots<BR>> <BR>> in the root dierectory i do the following.<BR>> <BR>> i get the following error<BR>> <BR>> -bash-2.05b$ pgsql2shp Montreal Hotspots<BR>> Initializing... No geometry column found.<BR>> The DBF file will be created but not the shx or
shp files.<BR>> Done.<BR>> Dumping: XX [4 rows].<BR>> <BR>> What am I doing wrong????<BR>> where is the geometry column supposed to be?<BR>> and where does this newly created DBF file reside?<BR>> Thanks<BR>> <BR>> wokar<BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> __________________________________________________<BR>> Do You Yahoo!?<BR>> Tired of spam? Yahoo! Mail has the best spam protection around<BR>> http://mail.yahoo.com<BR><BR>-- <BR>+-----------------------------------------------------------------+<BR>|Paul Spencer pspencer@dmsolutions.ca |<BR>+-----------------------------------------------------------------+<BR>|Applications & Software Development |<BR>|DM Solutions Group Inc http://www.dmsolutions.ca/|<BR>+-----------------------------------------------------------------+<BR></BLOCKQUOTE><p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo!
Mail has the best spam protection around <br>http://mail.yahoo.com