[Featureserver] PostGIS insert statement question
    Jennifer Strahan 
    jennifer at greeninfo.org
       
    Fri May 15 16:33:50 EDT 2009
    
    
  
Hello Everyone,
I'm hoping someone can suggest how to solve an error I'm getting when 
trying to insert a record into a PostGIS datasource:
An error occurred: column "geometry" of relation "padus_v1_mn_edits" does not exist
LINE 1: ...T INTO "padus_v1_mn_edits" (comm_date, wdpa_name, geometry, ...
                                                             ^
  File "/var/www/featureserver-pine/web_request/handlers.py", line 219, in cgi
    accepts = accepts )
  File "/var/www/featureserver-pine/FeatureServer/Server.py", line 167, in dispatchRequest
    result = method(action)
  File "/var/www/featureserver-pine/FeatureServer/DataSource/PostGIS.py", line 116, in create
    cursor.execute(str(sql), self.feature_values(feature))
Looks like the insert statement uses the column name "geometry" when it 
should be "the_geom"
Below is my config for the layer.  Any help would be much appreciated.  
I guess I can just rename my geometry column.  But I was hoping to get 
it working with the current name. 
Thanks,
Jennifer
#Use this layer to submit and display user edits
[padus_v1_mn_edits]
type=PostGIS
dsn=dbname=db_pine password=xxxxxx user=pine
layer=padus_v1_mn_edits
geometry=the_geom
fid=gid
srid=900913
attribute_cols=us_id, manag_desc, wdpa_name, gis_acres, gap_status, 
gis_source, sourcedate, class_desc, owner_desc, comments, comm_name, 
comm_org, comm_email, comm_date
gaping_security_hole=yes
-- 
Jennifer Strahan, GIS Specialist
GreenInfo Network - www.greeninfo.org -
Information and Mapping in the Public Interest
**As of Oct. 13, 2008 we have a new address**
564 Market Street, Suite 510
San Francisco CA 94104
Phone: 651-917-0191
Fax: 415-979-0371
Email: jennifer at greeninfo.org 
    
    
More information about the Featureserver
mailing list