Please go ahead and try use the svn trunk instead (r580). If that doesn't work, reply including the relevant layer of your featureserver.cfg, and the latest traceback<br><br>cheers,<br><br> -josh<br><br><div class="gmail_quote">
On Thu, Dec 4, 2008 at 9:09 AM, Yves Moisan <span dir="ltr"><<a href="mailto:yves.moisan@boreal-is.com">yves.moisan@boreal-is.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Josh,<br>
<div class="Ih2E3d"><br>
> Hi Yves,<br>
><br>
><br>
> Your geojson upload to featureserver does indeed include the geometry<br>
> twice: Both described as 'Point' and in your the_geom column.<br>
<br>
</div>Right<br>
<div class="Ih2E3d"><br>
> So you don't want to include the_geom in your upload - remove it from<br>
> your geojson and it should work.<br>
<br>
</div>Indeed I tried that before I posted to the list. I'm using FS 1.12 but<br>
at any rate I removed the_geom from my file and called with<br>
create.geojson this time :<br>
<div class="Ih2E3d"><br>
C:\temp>curl -d @fs-test.json<br>
</div><a href="http://my.server.com:8084/PGTEST/create.geojson" target="_blank">http://my.server.com:8084/PGTEST/create.geojson</a><br>
An error occurred: float argument required<br>
<div class="Ih2E3d"> File "C:\featureserver-1.12\FeatureServer\Server.py", line 242, in<br>
wsgiHandler<br>
format, content = service.dispatchRequest( params, path_info, host,<br>
post_data, request_method, accepts )<br>
File "C:\featureserver-1.12\FeatureServer\Server.py", line 145, in<br>
dispatchRequest<br>
result = method(action)<br>
File "C:\featureserver-1.12\FeatureServer\DataSource\PostGIS.py", line<br>
</div>138, in create<br>
values = ", ".join(self.value_formats(feature)+["SetSRID('%<br>
s'::geometry, %s) " % (self.to_wkt(feature.geometry), sel<br>
f.srid)])<br>
<div class="Ih2E3d"> File "C:\featureserver-1.12\FeatureServer\DataSource\PostGIS.py", line<br>
</div>90, in to_wkt<br>
return "POINT(%s)" % coords_to_wkt(coords)<br>
<div class="Ih2E3d"> File "C:\featureserver-1.12\FeatureServer\DataSource\PostGIS.py", line<br>
</div>87, in coords_to_wkt<br>
return ",".join(["%f %f" % tuple(c) for c in coords])<br>
<br>
I don't see what float argument is missing. Do I need to specify the<br>
SRID ?<br>
<br>
Cheers,<br>
<font color="#888888"><br>
Yves<br>
</font><div><div></div><div class="Wj3C7c"><br>
><br>
><br>
><br>
> In general, featureserver shouldn't return your the_geom column in the<br>
> first place, but that's another story (an OT side note: the FS docs<br>
> should explain, in the postgis section, how to have it return only a<br>
> subset of columns if you want -- although again, it shouldn't be<br>
> returning your the_geom column column at all assuming it's the only<br>
> geometry column on the table )<br>
><br>
><br>
> -Josh<br>
><br>
> On Thu, Dec 4, 2008 at 8:48 AM, Yves Moisan<br>
> <<a href="mailto:yves.moisan@boreal-is.com">yves.moisan@boreal-is.com</a>> wrote:<br>
> Hi All,<br>
><br>
> I'm trying to upload a .json file<br>
><br>
> {"features": [{"geometry": {"type": "Point", "coordinates":<br>
> [[411869.733939, 8831369.48172]]}, "id": 99999, "properties":<br>
> {"comment": "99999", "the_geom":<br>
> "0101000080BCD28DEF5A23194199456ACF30D86041A78B461654CB9540"}}]}<br>
><br>
> C:\temp>curl -d @fs-test.json<br>
> <a href="http://my.machine:8084/PGTEST/create.json" target="_blank">http://my.machine:8084/PGTEST/create.json</a><br>
> An error occurred: column "the_geom" specified more than once<br>
> LINE 1: ...SERT INTO "geo_survey_gps_pt" (comment, the_geom,<br>
> the_geom) ...<br>
> ^<br>
><br>
> File "C:\featureserver-1.12\FeatureServer\Server.py", line<br>
> 242, in<br>
> wsgiHandler<br>
> format, content = service.dispatchRequest( params,<br>
> path_info, host,<br>
> post_data, request_method, accepts )<br>
> File "C:\featureserver-1.12\FeatureServer\Server.py", line<br>
> 145, in<br>
> dispatchRequest<br>
> result = method(action)<br>
> File "C:\featureserver-1.12\FeatureServer\DataSource<br>
> \PostGIS.py", line<br>
> 142, in create<br>
> cursor.execute(str(sql), self.feature_values(feature))<br>
><br>
> If I erase the "the_geom" property from my file :<br>
><br>
> {"features": [{"geometry": {"type": "Point", "coordinates":<br>
> [[411869.733939, 8831369.48172]]}, "id": 99999, "properties":<br>
> {"comment": "99999"}}]}<br>
><br>
> I get :<br>
><br>
> C:\temp>curl -d @fs-test.json<br>
> <a href="http://my.machine:8084/PGTEST/create.json" target="_blank">http://my.machine:8084/PGTEST/create.json</a><br>
> An error occurred: new row for relation "geo_survey_gps_pt"<br>
> violates<br>
> check constraint "enforce_srid_the_geom"<br>
><br>
> File "C:\featureserver-1.12\FeatureServer\Server.py", line<br>
> 242, in<br>
> wsgiHandler<br>
> format, content = service.dispatchRequest( params,<br>
> path_info, host,<br>
> post_data, request_method, accepts )<br>
> File "C:\featureserver-1.12\FeatureServer\Server.py", line<br>
> 145, in<br>
> dispatchRequest<br>
> result = method(action)<br>
> File "C:\featureserver-1.12\FeatureServer\DataSource<br>
> \PostGIS.py", line<br>
> 142, in create<br>
> cursor.execute(str(sql), self.feature_values(feature))<br>
><br>
> because there is indeed a constraint in the table.<br>
><br>
> Pointers appreciated.<br>
><br>
> TIA,<br>
><br>
> Yves Moisan<br>
><br>
><br>
> _______________________________________________<br>
> Featureserver mailing list<br>
> <a href="mailto:Featureserver@openlayers.org">Featureserver@openlayers.org</a><br>
> <a href="http://featureserver.org/mailman/listinfo/featureserver" target="_blank">http://featureserver.org/mailman/listinfo/featureserver</a><br>
><br>
><br>
<br>
</div></div></blockquote></div><br>