[Featureserver] curl usage issue

[Josh Livni]

Hi Yves,
Your geojson upload to featureserver does indeed include the geometry twice:
 Both described as 'Point' and in your the_geom column.  So you don't want
to include the_geom in your upload - remove it from your geojson and it
should work.
In general, featureserver shouldn't return your the_geom column in the first
place, but that's another story (an OT side note:  the FS docs should
explain, in the postgis section, how to have it return only a subset of
columns if you want -- although again, it shouldn't be returning your
the_geom column column at all assuming it's the only geometry column on the
table  )

  -Josh

On Thu, Dec 4, 2008 at 8:48 AM, Yves Moisan <yves.moisan at boreal-is.com>wrote:

> Hi All,
>
> I'm trying to upload a .json file
>
> {"features": [{"geometry": {"type": "Point", "coordinates":
> [[411869.733939, 8831369.48172]]}, "id": 99999, "properties":
> {"comment": "99999", "the_geom":
> "0101000080BCD28DEF5A23194199456ACF30D86041A78B461654CB9540"}}]}
>
> C:\temp>curl -d @fs-test.json  http://my.machine:8084/PGTEST/create.json
> An error occurred: column "the_geom" specified more than once
> LINE 1: ...SERT INTO "geo_survey_gps_pt" (comment, the_geom,
> the_geom) ...
>                                                             ^
>
>  File "C:\featureserver-1.12\FeatureServer\Server.py", line 242, in
> wsgiHandler
>    format, content = service.dispatchRequest( params, path_info, host,
> post_data, request_method, accepts )
>  File "C:\featureserver-1.12\FeatureServer\Server.py", line 145, in
> dispatchRequest
>    result = method(action)
>  File "C:\featureserver-1.12\FeatureServer\DataSource\PostGIS.py", line
> 142, in create
>    cursor.execute(str(sql), self.feature_values(feature))
>
> If I erase the "the_geom" property from my file :
>
> {"features": [{"geometry": {"type": "Point", "coordinates":
> [[411869.733939, 8831369.48172]]}, "id": 99999, "properties":
> {"comment": "99999"}}]}
>
> I get :
>
> C:\temp>curl -d @fs-test.json  http://my.machine:8084/PGTEST/create.json
> An error occurred: new row for relation "geo_survey_gps_pt" violates
> check constraint "enforce_srid_the_geom"
>
>  File "C:\featureserver-1.12\FeatureServer\Server.py", line 242, in
> wsgiHandler
>    format, content = service.dispatchRequest( params, path_info, host,
> post_data, request_method, accepts )
>  File "C:\featureserver-1.12\FeatureServer\Server.py", line 145, in
> dispatchRequest
>    result = method(action)
>  File "C:\featureserver-1.12\FeatureServer\DataSource\PostGIS.py", line
> 142, in create
>    cursor.execute(str(sql), self.feature_values(feature))
>
> because there is indeed a constraint in the table.
>
> Pointers appreciated.
>
> TIA,
>
> Yves Moisan
>
>
> _______________________________________________
> Featureserver mailing list
> Featureserver at openlayers.org
> http://featureserver.org/mailman/listinfo/featureserver
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/featureserver/attachments/20081204/eab4d741/attachment.html