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 postgis
Search options not deleted
user 3438
PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
1
vote
Loading multipoint shapefiles into PostgreSQL
I am a bit confused. In your shp2pgsql command you define the parameters -p which:
Only produces the table creation SQL code, without adding any actual
data. This can be used if you need to com …
- 2,360
6
votes
Accepted
Error importing Shapefile to PostGIS using Importer GUI
The message you are getting is that 'type geography does not exist' This either means you did not install postgis correctly or you are using an older version? …
- 2,360
2
votes
0
answers
273
views
RT Sql Layer plugin giving an error [closed]
I am trying to use the aforementioned plugin with QGIS 1.7 and Postgres 9.0/PostGIS 1.5. … Added a PostGIS spatial layer w/out a problem and then clicked on the RT Sql layer button which displayed the main dialog. When I select Database-> , I got this error
BTW - the ...' …
- 2,360
2
votes
How to put 20K points on a map
I never used SQLite so I can't really comment, but I would have thought that for a db that can handle 6000 users Postgres/PostGIS would be a better choice. …
- 2,360
2
votes
Accepted
Mapscript - PostGis Error
Its basically telling you whats wrong- you have not 'opened' the layer
Try this:
if (resultado.numresults > 0)
{
// Open layer
layerUtbs.open();
…
- 2,360
19
votes
Accepted
Selecting only Spatial tables from PostgreSQL database?
All spatial table references are held in the geometry_columns metadata table. So try:
select * from geometry_columns
and you should get just the spatial tables
- 2,360
2
votes
Converting oracle geometry to PostGIS with 3d data (wkt?)
t.X, t.Y, t.id FROM cola_markets c,
TABLE(SDO_UTIL.GETVERTICES(c.shape)) t ORDER BY c.mkt_id, t.id;
You can then, within your procedure, 'flatten' these coordinates to a string and create 'postgis-ready …
- 2,360
32
votes
4
answers
7k
views
When should you NOT use a spatial index?
But as far as I understand, neither PostGIS not SQL Serve require this. PostGIS even seems to have functions (_* e.g. _STContains) that EXPLICITLY won't use the spatial index. … To me, the last sentence is a contradiction in terms but otherwise why PostGIS would provide these functions? …
- 2,360