Hello, and thanks for the replies!I'll try those suggestions.
Just curiuos though-- which geometry seems to be invalid? Is it the state
poly, or the smaller county/zone poly? If there was an invalid geometry,
wouldn't it always show up for that state or county? Here's what I observed
for the
hey list,
i have the following problem:
- i have overlapping geometries in one layer in my postgis (8.3) database.
- how could i find the overlapping geometries??
-i could not divide into two layers...
- if i have two layers i could use st_contain, but in one ??
- it will be over 6 million
Hello,
I’m not sure I understand your whole problem, but I can try to give you the
beginning of some answers :
- The use of ST_Overlaps seems more natural to me to find overlapping
geometries (it depends on what you’re looking for, and you may also have look
to ST_Intersects but
I ran the following against all 4 of my GeoJSON files:
SELECT ST_IsSimple(ST_GeomFromGeoJSON('@poly'))SELECT
ST_IsValid(ST_GeomFromGeoJSON('@poly'))SELECT
ST_IsValidDetail(ST_GeomFromGeoJSON('@poly'))SELECT
ST_IsValidReason(ST_GeomFromGeoJSON('@poly'))
where @poly contained each one of the
On 2/26/2015 1:40 PM, Joseph Spenner wrote:
I ran the following against all 4 of my GeoJSON files:
SELECT ST_IsSimple(ST_GeomFromGeoJSON('@poly'))
SELECT ST_IsValid(ST_GeomFromGeoJSON('@poly'))
SELECT ST_IsValidDetail(ST_GeomFromGeoJSON('@poly'))
SELECT
Roxanne: I think you're on to something here. I just did more tests, and
found the following:
This command fails with the error:
select ST_Asgeojson( geom ) from dynamic.polys where
ST_Intersects(ST_GeomFromGeoJSON('$jsonPoly'), geom)=TRUE and
On 2/26/2015 4:08 PM, Joseph Spenner wrote:
Roxanne:
I think you're on to something here. I just did more tests, and
found the following:
This command fails with the error:
select ST_Asgeojson( geom ) from dynamic.polys where
ST_Intersects(ST_GeomFromGeoJSON('$jsonPoly'), geom)=TRUE and
And also ST_IsSimple (that precisely check for self intersection).
Cheers,
Rémi-C
2015-02-26 8:32 GMT+01:00 BladeOfLight16 bladeofligh...@gmail.com:
On Wed, Feb 25, 2015 at 12:14 PM, Joseph Spenner joseph85...@yahoo.com
wrote:
DBD::Pg::st execute failed: ERROR: Error performing
John, I've got a variation in mind that works solely using lc_class32 - should
take same time as what I sent through earlier. I'm guessing 2 minutes!!! A
different SQL statement in the data prep stage - it is now becoming very clear
to me as to how to tile lc_class32 in the purest sense. Which