Hot answers tagged postgresql
According to the documentation (chapter 7.3), there are several geometry accessors which might meet your criteria, depending on whether the geometry is a collection, a polygon, or a multi-polygon: ST_NumGeometries - If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, otherwise return NULL. ST_NumInteriorRings - Return the ...
Use the geometry accessor ST_NumGeometries. For example SELECT ID, ST_NumGeometries(shape) FROM myTable If your geometries contain geometry types other than polygons, you will need to break them up and keep only the polygons before counting. But from your question this would not be required.
Put your first query in the from clause of the 2nd: something like that should work: SELECT building.id building.address FROM building, (SELECT event_point.id, event_point.geom, st_buffer(event_point.geom, 100) AS buffergeom FROM public.event_point) buffer WHERE ST_within(building.geom, buffer.buffergeom)
From the ArcSDE Administration Command Reference: Beginning with ArcGIS 10.1, you must use a geoprocessing tool or Python script to create a geodatabase. For geodatabases in Oracle, SQL Server, and PostgreSQL, if you can use the default settings, use the Create Enterprise Geodatabase tool or a Python script that calls this tool. If you want to ...
Only top voted, non community-wiki answers of a minimum length are eligible