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 187
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.
12
votes
Accepted
QGIS supported databases?
QGIS supports
PostGIS - including a dedicated PostGIS Manager plugin for seamless work
Spatialite - there is also Spatialite Manager
MSSQL 2008 Spatial - also supported by default starting from versi …
- 1,096
13
votes
Accepted
Seeking tools for uploading GIS data to database
To import shapefiles into PostGIS, you can use QGIS PostGIS Manager Plugin. It's a GUI for for shp2pgsql command line function. If you want to load KML files, you'd first have to convert those to shap …
- 65.4k
13
votes
Accepted
How to create something similar to GDB in QGIS?
You can achieve this by preparing all those layers in one (or more) project files. Share these projects on the network and you can load them using Layer - Embed Layers and Groups.
If you want to chan …
- 84.5k
2
votes
Is the PostGIS Shapefile Import Manager able to upload to phpmyadmin or only pgadmin III?
It seems like your database is not PostGIS enabled. Make sure you created the database from your PostGIS template. You'll be able to tell by looking at the list of available functions. If you don't fi …
- 84.5k
4
votes
Accepted
How to fix "Error, query must return columns 'id', 'source', 'target' and 'cost'"?
You have to rename the columns. The names have to match exactly.
SELECT * FROM shortest_path('
SELECT "gid" as id,
"FNODE_"::integer as source,
" …
- 84.5k
6
votes
Accepted
Reduce Tracking Data Set
In PostGIS, you could use the 3DM concept. A 3DM point has four "dimension" X, Y, Z, and M where "M" stands for "measure" and can be any value you like, e.g. a timestamp in seconds.
Creating a line …
- 84.5k
3
votes
Given long, lat, x and y, how do I find the projection?
If I interpret Farsite Help correctly, it doesn't reproject your data. So you just need to check which coordinate system your input data is in.
- 84.5k
4
votes
assign unique id to point features
Follow up question: Is it best to create and maintain the unique id in the DBMS (SQL Server) or in the GIS software (ArcGIS)?
I'd strongly suggest checking for uniqueness inside the DBMS. That's …
- 84.5k
3
votes
Does ArcGIS for Desktop support SpatiaLite?
On Google Code, I found that Umbriel ArcGIS Desktop Tools have a project called Umbriel.ArcGIS.Spatialite but I haven't found any documentation on it yet.
- 84.5k
6
votes
Accepted
Writing a plugin for QGIS using Python to access PostGIS and write geometries
There are a lot of python plugins for QGIS that access PostGIS. Just download them and check the source code. Accessing PostGIS from Python is quite straight forward (same is true for SpatiaLite by th …
- 84.5k