Did you try ST_MakeValid, and compare the before/after? Might provide some
info.
http://postgis.org/documentation/manual-svn/ST_MakeValid.html If life gives you
lemons, keep them-- because hey.. free lemons. "~heart~ Sticker" fixer:
http://microflush.org/stuff/stickers/heartFix.html
why a query with a point from the lower polygon won't return
the MultiPolygon row? I've done this with other MultiPolygons and have not had
an issue like this.
Any help would be great.
Thanks!
Joseph Spenner
From: Joseph Spenner <joseph85...@yahoo.com>
To: PostGIS Users Discuss
Thanks for all the great replies!
I've got some good info now.
Appreciated!
Regards,Joseph Spenner If life gives you lemons, keep them-- because hey.. free
lemons.
~heart~ Sticker fixer: http://microflush.org/stuff/stickers/heartFix.html
From: David Haynes hayne...@gmail.com
Walter: Fabulous site! That's pretty impressive..
From: Walter Nordmann walter.nordm...@web.de
To: Joseph Spenner joseph85...@yahoo.com; PostGIS Users Discussion
postgis-users@lists.osgeo.org
Sent: Friday, April 10, 2015 2:46 PM
Subject: Re: [postgis-users] polygons/geometry
Nathan and Stephan: The Admin 1 – States, Provinces option at:
http://www.naturalearthdata.com/downloads/10m-cultural-vectors/
Is exactly what I needed!
Thanks for all the replies. I got some great, useful, interesting sites now!
Cheers..
Joseph Spenner If life gives you lemons, keep them
Roxanne: Thanks for the help! I was able to find a solution, but knowing it
was the ST_Area piece giving me the problem was a great help.I'll play around
with the suggestions you offered, too.
( Yes, free Beer, Tucson. :)
Cheers..Joseph Spenner
If life gives you lemons, keep them-- because
intersects it?
2) I was able to plot the offending county described above in the GeoJSONLint
validation page: http://geojsonlint.com/ There didn't appear to be any
issues.
Thanks!
Regards,Joseph Spenner
From: Rémi Cura remi.c...@gmail.com
To: PostGIS Users Discussion postgis-users
, and was able to get errors-- such as:
DBD::Pg::st execute failed: ERROR: geometry contains non-closed rings
So, it would seem my geoms are ok.
I've not yet tried the ST_MakeValid. But wouldn't the above indicate
they're already valid?
Thanks!
From: Joseph Spenner joseph85...@yahoo.com
, 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
ST_IsValidReason(ST_GeomFromGeoJSON('@poly'))
where @poly
California using
http://geojsonlint.com/
The state of Californina, which I got from NWS, can be found here:
http://microflush.org/stuff/json/CA.json
Can anyone see why this one nwsZone.json polygon is returning the error?
Any help would be great.
Thanks!
Regards,Joseph Spenner
task.
Any help would be great.
Thanks!
Regards,Joseph Spenner
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
.
--
Any help would be great.
Thanks!
From: Hugues François hugues.franc...@irstea.fr
To: Joseph Spenner joseph85...@yahoo.com; PostGIS Users Discussion
postgis-users@lists.osgeo.org
Sent: Wednesday, January 7, 2015 1:17 AM
Subject: Re: [postgis-users] ST_Intersects ST_GeomFromGeoJSON
string as the input
instead, and return all stored polys which intersect.
Is this possible?
Thanks!
Regards,Joseph Spenner
From: Hugues François hugues.franc...@irstea.fr
To: Joseph Spenner joseph85...@yahoo.com; PostGIS Users Discussion
postgis-users@lists.osgeo.org
Sent: Wednesday
that for the 2nd query
without too much difficulty.
Thanks again for the responses!
Regards,Joseph Spenner
If life gives you lemons, keep them-- because hey.. free lemons.
~heart~ Sticker fixer: http://microflush.org/stuff/stickers/heartFix.html
From: Rémi Cura remi.c...@gmail.com
mean they
intersect, but one does not completely contain another.
I do need the polygons which are completely contained as well. Can this be
done?
Thanks again for the help. I'm getting there!
Regards,Joseph Spenner
From: Joseph Spenner joseph85...@yahoo.com
To: Rémi Cura remi.c
://microflush.org/stuff/stickers/heartFix.html
From: Joseph Spenner joseph85...@yahoo.com
To: PostGIS Users Discussion postgis-users@lists.osgeo.org
Sent: Tuesday, November 18, 2014 8:44 AM
Subject: Re: [postgis-users] Returning polygons if any of a polygon input
points lie in the polygons
Hugues: Yes, you are quite right. The ST_Intersects does exactly what I need.
Good stuff here.
Thanks again everyone for your patience! I probably should have tried a few
more of these before posting.
Cheers!Joseph Spenner
If life gives you lemons, keep them-- because hey.. free lemons
,state,name,ST_Asgeojson( geom ) from polys where
ST_Intersects(ST_PointFromText('POINT(-109 42)', 4269), geom);
But now I have a need to use polygons as input.
Any help would be great.
Thanks!
Regards,Joseph Spenner
___
postgis-users mailing list
postgis
Hello, I've just got postgresql93-server installed, with postgis21-postgresql93
on a CentOS system.
I then used shp2pgsql to load in some shape files using this procedure:
http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/shp2pgsql.html
The shapefiles were obtained from NWS:
Doug:
That was it!
polydata=# select zone,gid,state,name,ST_AsKML( geom ) from polys where
ST_Intersects(ST_PointFromText('POINT(-109 42)', 4269), geom);
Thanks for the help and links!
Regards,
Joseph Spenner
From: Newcomb, Doug doug_newc...@fws.gov
20 matches
Mail list logo
