Re: [postgis-users] spatial index for topology?

2013-10-27 Thread Sandro Santilli
On Sat, Oct 26, 2013 at 06:27:41PM -0500, William Kyngesburye wrote: Is there any way to spatially index topogeometry? Nope, due to the fact that TopoGeometry spatial extent is not in the value itself but derived using a volatile function from external (referenced) data. This is a known

Re: [postgis-users] [HELP] Problem in PHP framework installation on Mavericks

2013-10-27 Thread Marcello Benigno
Sorry List, my bad. This email was for Willian as you can see. But still accepted that can help me. Regards, 2013/10/27 Marcello Benigno benigno.marce...@gmail.com Hi Willian, First sorry for contacting you directly, but I do not know if there is a specific forum for the KingChaos

[postgis-users] Check If Point Is In New Geometry

2013-10-27 Thread Tyler DeWitt
I have a table of geometries (with a geom column of type MultiPolygon Z). I collect real time location data (1 point a second) and store that in a tracked_points table (with a geom column of type PointZ, and user_id column of type int). I'd like to know when a user (tracked by their point)

Re: [postgis-users] Question about SDE on top of Postgres . . .

2013-10-27 Thread Paul Ramsey
Wow, that page really goes out of its way to make sure you don't want to use PostGIS! All those notes and caveats in the PostGIS boxes! Beginning with ArcGIS 10.1, all databases used with ArcGIS must be 64-bit WHAT?!?!? Client apps, by and large, don't give a damn about what platform the database

Re: [postgis-users] Check If Point Is In New Geometry

2013-10-27 Thread Brent Wood
Tyler, Convert your 24 hours worth of points to a linestring Clip the linestring by your polygons to generate separate lines per polygon per entry tinto the polygon Count the vertices in each linestring to determine how long each period in each polygon was. The following shell script might