Hello Jukka,

I'm using GeoServer 2.4.5.  Interesting that that the demo data behaves 
correctly.  My data is not from a shapefile.  Rather, we have a custom routine 
which loads a database from various files, and the layer is defined as a view 
in that database.

Raj

-----Original Message-----
From: Rahkonen Jukka (Tike) [mailto:jukka.rahko...@mmmtike.fi]
Sent: Monday, May 05, 2014 10:04 AM
To: Tanikella, Rajanikanth (SCR US); geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Why does GetFeature round my floating point 
numbers, but only for outputFormat=CSV?

Hi,

At least it seems that the demo layers do not behave like that.  The 
topp:states has plenty of double fields and values look the same with 
http://demo.opengeo.org/geoserver/wfs?service=wfs&version=1.0.0&request=getfeature&typename=topp:states&outputformat=JSON
and with
http://demo.opengeo.org/geoserver/wfs?service=wfs&version=1.0.0&request=getfeature&typename=topp:states&outputformat=csv.

Topp:states comes from shapefile, how about your data? Which Geoserver version 
do you run?

-Jukka Rahkonen-

Tanikella, Rajanikanth (SCR US) wrote:

> Hello All,
>
> I've looked about but I haven't found any thread discussing this, so
> forgive me if it has been covered and please point me to the post.
>
> When I use GetFeature I find floating point numbers are being rounded,
> but only when I have the parameter outputFormat=CSV. I am using
> GeoServer v2.4.5. I have documented this as a question on
> gis.stackexchange.com
> (http://gis.stackexchange.com/questions/93194/why-does-geoservers-
> getfeature-round-my-numbers-but-only-for-outputformat-csv) but I'll
> reiterate
> here:
>
> Here's my request as JSON:
> http://geothermal.smu.edu:9000/geoserver/gtda-
> contributions/ows?service=WFS&version=1.0.0&request=GetFeature&typeNam
> e=gtda-
> contributions:UNDRadiogenicHeat&maxFeatures=1&outputFormat=application
> /
> json
>
> ...and an excerpt from the response. Note the values for latitude and 
> longitude:
> {
> "type" : "FeatureCollection",
> "totalFeatures" : 343,
> "features" : [{
>         "type" : "Feature",
>         "id" : "UNDRadiogenicHeat.2540ea6b-f94a-3088-9b32-762c77a8e57f",
>         "geometry" : {
>             "type" : "Point",
>             "coordinates" : [-92.79726665, 47.90752513]
>         },
>         "geometry_name" : "shape",
>         "properties" : {
>             "latitude" : 47.90752513,
>             "longitude" : -92.79726665, ...
>
> Now the same request with outputFormat=cvs:
> http://geothermal.smu.edu:9000/geoserver/gtda-
> contributions/ows?service=WFS&version=1.0.0&request=GetFeature&typeNam
> e=gtda-contributions:UNDRadiogenicHeat&maxFeatures=1&outputFormat=csv
>
> ...and an except of the response. The same portion of the data has
> been rounded off (48 instead of 47.90752513, and -93 instead of
> -92.79726665). (I added the spaces for easy legibility):
>
>  FID,                                                     latitude,  
> longitude,...
>  UNDRadiogenicHeat.2540ea6b-f94a-3088-9b32-762c77a8e57f,  48,        -93,...
>
> I've looked for configurations that might cause this, but I see none.
> I know there are filters that could do this, but I get the impression
> that these need to be explicitly requested, and the above requests do not 
> include filters.
>
> Is there something I'm overlooking? Is there some way that GeoServer
> is treating the data so glaringly differently just because I'm requesting CSV?
>
> Thank you for any insights.
>
> Raj Tanikella
>
>
> This message and any attachments are solely for the use of intended 
> recipients.
> The information contained herein may include trade secrets, protected
> health or personal information, privileged or otherwise confidential 
> information.
> Unauthorized review, forwarding, printing, copying, distributing, or
> using such information is strictly prohibited and may be unlawful. If
> you are not an intended recipient, you are hereby notified that you
> received this email in error, and that any review, dissemination,
> distribution or copying of this email and any attachment is strictly
> prohibited. If you have received this email in error, please contact
> the sender and delete the message and any attachment from your system.
> Thank you for your cooperation
>
> ----------------------------------------------------------------------
> -------- Is your legacy SCM system holding you back? Join Perforce May
> 7 to find out:
> • 3 signs your SCM is hindering your productivity •
> Requirements for releasing software faster • Expert tips and
> advice for migrating your SCM now http://p.sf.net/sfu/perforce
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

This message and any attachments are solely for the use of intended recipients. 
The information contained herein may include trade secrets, protected health or 
personal information, privileged or otherwise confidential information. 
Unauthorized review, forwarding, printing, copying, distributing, or using such 
information is strictly prohibited and may be unlawful. If you are not an 
intended recipient, you are hereby notified that you received this email in 
error, and that any review, dissemination, distribution or copying of this 
email and any attachment is strictly prohibited. If you have received this 
email in error, please contact the sender and delete the message and any 
attachment from your system. Thank you for your cooperation

------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to