[GIS] How to limit decimal digit of GeoJSON

geojsonpostgis

I am using postGIS. I am using ST_AsGeoJSON(geom) function to get GeoJSON data of Geom field. Its returning a long lat value that have 13 digits after decimal point. Is there any way to reduce or limit the decimal digits?

Best Answer

Read the documentation of the method. You can pass a parameter to limit the number of decimal digits.

text ST_AsGeoJSON(geography geog, integer maxdecimaldigits=15, integer options=0);

Related Solutions

[GIS] How to find out whether a lat/long position resides within a Polygon

I think ST_Intersects would work better, it returns a true or false on whether or not two geometries intersect. So you'd want to do something like:

SELECT ST_Intersects(myPointGeo, myPolygonGeo);

or you can do:

SELECT a.id, b.id 
FROM pointTableName a, polygonTableName b 
WHERE ST_Intersects(a.myPointGeo, b.myPolygonGeo);

[GIS] ST_Intersects incorrectly returning false in PostGIS

You need to project your point into your polygon's CRS. You can use ST_Transform to do this.

                    SELECT 
                        cocname,
                        cocnum, 
                        geom,           
                        st_intersects(geom,
                            ST_Transform(
                                  ST_GeomFromText('point(-71.0636 42.3581)',4326), 3857))
                    FROM 
                        public.coc
                    WHERE cocnum like 'MA-500'

Specifically you're not intersecting because your polygons projection is in meters, so without re-projecting -71.06, 42.35 in meters is a point not far from the equator and prime meridian.

Best Answer

Related Solutions

[GIS] How to find out whether a lat/long position resides within a Polygon

[GIS] ST_Intersects incorrectly returning false in PostGIS

Related Question