Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with spatial-database
Search options answers only
not deleted
user 1264
Spatial database is a database that is optimized to store and query data that is related to objects in space, including points, lines and polygons.
3
votes
STDistance Unit in SQL Server 2008
Jason,
Steve is right. If you are going to be keeping your data in long lat, you really need to use the geography type. The planar calculation as you get further and further away will become more w …
- 10.6k
14
votes
Accepted
When should you NOT use a spatial index?
mapoholic,
Generally speaking, there isn't a reason to do a spatial query without a spatial index unless you are dealing with really small tables. Still though you would use the ST_ which don't use …
- 10.6k
2
votes
Accepted
DBScan with Convexhull
If you want to go by meters, it really depends on location of your data what is the best projection. some utm projection is generally preferred like for example this utmzone function https://trac.osg …
- 10.6k
28
votes
Accepted
Mixing geometry types in one PostGIS table
If you don't need third party support and don't forsee the need to query by type keeping them in the same table works just fine. Alternatively you could use an inheritance model as discussed in chapt …
- 10.6k
1
vote
Database standards for storing and analysing raster
No there is not. PostGIS raster does try to follow similar to OGC SF standard as much as possible by providing similar functions for raster as we have for geometry. E.g. ST_Intersects, ST_Covers, ST …
- 10.6k
1
vote
Accepted
Install Postgresql / Postgis with SFCGAL
If you can wait we are planning to release 2.2.0 today. It has SFCGAL extension.
If you want to give it a try now, download the postgis 2.2.0dev windows binaries.
You'll need to use postgis 2.2. Sin …
- 10.6k