[postgis-users] geometry column

[Ethan Alpert]

Look at the description of geometry_columns. Latitude should be a string
afaict. Same for public, circle and polygon
 
-e

	-----Original Message-----
	From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of w m
	Sent: Wednesday, March 09, 2005 9:17 PM
	To: postgis
	Subject: [postgis-users] geometry column
	
	
	Hi 
	Im tryin to populate my geometry column in my postgresql
database usin pgadmin
	 
	i get the following errors (i have also included a screen
snapshot)
	 
	 

	SQL error:
	
	ERROR:  column "latitude" does not exist

	

	In statement:
	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')

	 

	i have a column called latitude in my table hotspots.

	is it necessary to enter values in each field??

	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

	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

	-bash-2.05b$ pgsql2shp Montreal Hotspots 
	Initializing... No geometry column found.
	The DBF file will be created but not the shx or shp files.
	Done.
	Dumping: XX [4 rows]

	Thank You

	Nisa

	 

	__________________________________________________
	Do You Yahoo!?
	Tired of spam? Yahoo! Mail has the best spam protection around 
	http://mail.yahoo.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050310/984e964a/attachment.html>