<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=725582920-10032005><FONT face=Arial color=#0000ff size=2>Look
at the description of geometry_columns. Latitude should be a string afaict. Same
for public, circle and polygon</FONT></SPAN></DIV>
<DIV><SPAN class=725582920-10032005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=725582920-10032005><FONT face=Arial color=#0000ff
size=2>-e</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>w
m<BR><B>Sent:</B> Wednesday, March 09, 2005 9:17 PM<BR><B>To:</B>
postgis<BR><B>Subject:</B> [postgis-users] geometry
column<BR><BR></FONT></DIV>
<DIV>
<DIV>
<DIV>Hi </DIV>
<DIV>Im tryin to populate my geometry column in my postgresql database usin
pgadmin</DIV>
<DIV> </DIV>
<DIV>i get the following errors (i have also included a screen snapshot)</DIV>
<DIV> </DIV>
<DIV> </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") VALUES (Latitude, public,
'Hotspots', circle, '45.5177', '1', polygon, '1', '1', '1')</P>
<P> </P>
<P>i have a column called latitude in my table hotspots.</P>
<P>is it necessary to enter values in each field??</P>
<P>in the coord_dimension field does i have to be x,y format or can it be any
value or does it have to be the latitudes</P>
<P>im doing all this because i would like to use this command pgsql2shp...but
first i need to fill the geometry column because otherwise i get the following
error</P>
<P>-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]</P>
<P>Thank You</P>
<P>Nisa</P>
<P> </P></DIV></DIV></DIV>
<P>__________________________________________________<BR>Do You
Yahoo!?<BR>Tired of spam? Yahoo! Mail has the best spam protection around
<BR>http://mail.yahoo.com </P></BLOCKQUOTE></BODY></HTML>