Reputation
9,744
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
16 32
Newest
 Nice Answer
Impact
~149k people reached

Jul
24
awarded  Nice Answer
Jul
21
comment GeoJSON from PostGIS for Vector
Right, his "box" is spooling out to number,number,number,number when JS runs tostring on it, hence the funny signature it ends up trying to call in the db.
Jul
20
answered GeoJSON from PostGIS for Vector
Jul
17
awarded  Enlightened
Jul
17
awarded  Nice Answer
Jul
16
comment PostGIS ST_Intersects not returning values
"SELECT ST_AsEWKT(gis_stereo_shape) FROM cg_dxf_shapes LIMIT 1" and add that to the post.
Jul
15
comment Problem with ST_IsValid: Unknown geometry type: 9 - CompoundCurve
Oh, and if ST_GeometryType() returns an error then something is truly amiss in your database or your dataload. If you can bisect to find the particular geometry and provide the hex value, that would help debug.
Jul
15
comment Problem with ST_IsValid: Unknown geometry type: 9 - CompoundCurve
What version are you on? I run ST_GeomFromGML() on that GML and I get a plain old linestring and everyone is happy. (PostGIS 2.1 and trunk)
Jul
15
comment Problem with ST_IsValid: Unknown geometry type: 9 - CompoundCurve
ST_GeometryType() and then just look for 'CompoundCurve'
Jul
14
comment Use of constraints and Spatial indexes in Postgis
Yes, you're doing it right. For bulk changes it's better to not have indexes around. You speed up the process and the indexes you build at the end are cleaner and less bloated than if you had left the old indexes in place and updated.
Jul
13
answered Are State Plane Coordinates always derived from longitude and latitude?
Jul
8
comment How to compute equality of polygons in PostGIS independently of their orientation?
ST_NPoints(), ST_Area() and ST_Perimeter() taken together will provide a bit of a "signature" of particular shapes, though if you also allow scale to vary you're down to having to analyze angles, etc, which you'll have to write your own routines for.
Jul
7
comment Mapnik PGRaster Plugin creating 8x8 tiles with visible boundaries
I have seen the same effect, but only when doing a reprojection within Mapnik. If the source and destination are the same projection, the effect disappears. Another clue.
Jul
7
comment PostGIS - How to calculate linestring length from WGS84 after transforming from OSGB 36
Paste the WKT of the object itself (ST_AsEWKT(geom)) so others can verify.
Jul
6
comment Polygon area calculation in Ruby (on Rails, rgeo, PostGIS and GEOS) in sqare meters
Ellipsoidal math is required for "exact" results over large areas. Equal area projections just spread the error as evenly as possible over their area of validity. For most uses a planar projection is perfectly sufficient.
Jul
4
revised How to create a sequence for a table which was created by selecting data from another table?
added 4 characters in body
Jul
4
answered How to create a sequence for a table which was created by selecting data from another table?
Jul
3
comment Reprojecting in Postgis
You incorrectly loaded the data initially, so you have geometries that think their SRID is 4326 when actually they seem to be in some kind of UTM projection (judging by the coordinates). You'll have to go back and reload the data first.
Jul
3
answered Polygon area calculation in Ruby (on Rails, rgeo, PostGIS and GEOS) in sqare meters
Jul
1
answered How to obtain WGS84 or Projected Bounds for given EPSG in postgis?