postgis
How to efficiently query large multi-polygons with PostGIS
I am working with radio maps that seem to be too fragmented to query efficiently. The response time is 20-40 seconds when I ask if a single point is within the multipolygon (I have tested \"within\"/\[详细]
2023-01-10 14:51 分类:问答Permissions required to allow arbitrary sql to be executed safely
I want to create an SQL sandbox that will allow users to execute arbitrary SELECT queries at a PostGIS database.Essentially, I want to allow users access to psql to play with.[详细]
2023-01-10 02:30 分类:问答PostGIS: Finding LineStrings that overlap a box
I want to specify a box (i.e. 2 points) and select all the linestrings that are either within or intersect the box.[详细]
2023-01-09 19:05 分类:问答Display Map like OpenStreetMap
I like the way OpenStreetMap display its map. It almost looks like Google Map. I have already installed GeoServer and PostGis on my notebook. I also got this cloudmade osm file for my country, Indones[详细]
2023-01-09 14:52 分类:问答Postgis random point inside a polygon
If i have a polygon in Postgis how can i fin开发者_StackOverflow社区d/calculate random points inside the polygon?The link cited by @Mike not have a code, but good clues from Dr.JTS:[详细]
2023-01-09 05:21 分类:问答how to proceed further this gis project?
For my开发者_Python百科 company in house use i want to develop a gis project with simple goals. To display all places with name wherever my company presents,over the normal country map.[详细]
2023-01-08 14:36 分类:问答html5 canvas: server or client fast transforms from longitude latitude to pixel values
I am working on some maps a开发者_运维百科nd animations using the html5 canvas element (example visible here.)I would like to be able to efficiently generate pixel-valued linestrings (x1, y1, x2, y2),[详细]
2023-01-07 18:51 分类:问答GIS: need to add data to a shape file
I tried posting this question earlier but was unsuccessful so I\'m trying again I imported a shape (set of points) file into postgres and have a table (hist_info) with additional data also in postgre[详细]
2023-01-06 05:35 分类:问答PostGIS intersection troubleshooting
I just started using PostGIS & Postgresql and everything is running smoothly for the most part.When I try to find which MULTIPOLYGON s a POINT lies in I\'m getting stuck.I have two separate points[详细]
2023-01-05 11:28 分类:问答Use GIS to get geographic info for a single point
I am not quite sure where to start with this. I only just started looking into this in the past week, but hopefully someone can help point me in the right direction.[详细]
2023-01-03 19:58 分类:问答