859 reputation
518
bio website
location
age
visits member for 2 years, 2 months
seen Jul 10 at 0:35

Hello!

I use PostgreSQL, PHP, Javascript, jQuery, HTML, XML, XSLT, and others.


Jul
9
awarded  Revival
Jul
2
awarded  Curious
May
14
comment PostGIS2 have automatic BBOX indexing?
Thanks, good example. What occurs with INSERT INTO pois_ny ( poi_name, geom ) values ( 'A', ST_SetSRID(ST_MakePoint(-70, 40),4326) ) , ( 'B', ST_SetSRID(ST_MakePoint(-71.1, 42.3),4326) ), ( 'C', ST_SetSRID(ST_MakePoint(-70, 40),4326) ) ; when comparing A&&B OR A&&C, it is a "optimized comparison", or no BBOX-index is used?
May
13
awarded  Yearling
May
12
revised PostGIS2 have automatic BBOX indexing?
added 119 characters in body
May
12
asked PostGIS2 have automatic BBOX indexing?
Apr
14
awarded  Benefactor
Apr
13
revised How to create non-overlapping street polygons from centerlines?
add link
Apr
13
revised How to create non-overlapping street polygons from centerlines?
added 128 characters in body
Apr
13
revised How to transform a set of street-segments into city-blocks, with PostGIS2?
uloading image
Apr
13
answered How to create non-overlapping street polygons from centerlines?
Apr
12
accepted How to transform a set of street-segments into city-blocks, with PostGIS2?
Apr
12
revised How to transform a set of street-segments into city-blocks, with PostGIS2?
add illustrations
Apr
3
comment ST_NumInteriorRings not returns zero, is a bug?
I am reviewing the problem, see answer below...
Apr
3
answered ST_NumInteriorRings not returns zero, is a bug?
Mar
27
comment ST_NumInteriorRings not returns zero, is a bug?
Thanks! good tips... Spliting the question into two subquestions: 1) there are a bug? because ST_NumInteriorRings "will work with both POLYGON and MULTIPOLYGON types" and "return NULL if there is no polygon"; 2) There are an easy way to check when the MultiPolygon is not a topologically-disjoint set, and its layout behaviour is like a "polygon with holes"?
Mar
26
comment ST_NumInteriorRings not returns zero, is a bug?
Thanks by the checking. Well, the problem is about the "NULL return", because guide say "Return NULL if there is no polygon in the geometry", and there are a polygon as you see.
Mar
25
revised ST_NumInteriorRings not returns zero, is a bug?
add ex
Mar
25
comment ST_NumInteriorRings not returns zero, is a bug?
Ok, I edit, is there... It works in your PostgreSQL?
Mar
25
revised ST_NumInteriorRings not returns zero, is a bug?
add ex.