PostgreSQL is an open source object-relational database system.
3
votes
0answers
26 views
What is the correct syntax for using gdal_rasterize with a PostGIS datasource
I have a multipolygon layer in PostGIS and I would like to use gdal_rasterize to generate a raster. I cannot find the correct syntax to specify PostGIS as the data source.
$ gdal_rasterize -a ...
3
votes
0answers
57 views
Where can I find PostGIS error codes?
Using ST_Contains in where clause sometimes gives me error messages like
ERROR: GEOSContains: TopologyException: side location conflict at 37.3706 55.7882
For now I can't guarantee validity for ...
3
votes
0answers
186 views
How to save table from PostgreSQL to MapInfo File?
I have two tables:
1 with geometry in WGS
2 with geometry in Local System
I tried this:
ogr2ogr -f "MapInfo File" output2.tab PG:"host=localhost user=postgres password=123456 dbname=postgis" -sql ...
3
votes
0answers
286 views
How can I properly add PostGIS data into MapGuide Maestro?
I am having trouble connecting a PostGIS database to MapGuide Maestro. Actually, I have added the PostGIS data into Maestro, but when I click to validate the layer it shows an error message:
...
2
votes
0answers
53 views
Select features within a country or bounding box effectively using PostGIS
I imported the planet OSM file into a PostgreSQL 9.2/PostGIS 1.5 server using osm2pgsql. I now want to select certain map features which lie within the bounding box formed by a countries borders, e.g. ...
2
votes
0answers
33 views
Clustering table on geohash index and geohash ordered table
I wonder if there could be a performance gain to re organize the rows in a table by Geohash and then CLUSTER this table on the Geohash index of the geometries.
CREATE TEMPORARY TABLE tmptbl AS
SELECT ...
2
votes
0answers
55 views
Installing knn on PostgreSQL for windows
I am trying to install the extension KNN for clustering as an extension on my PostgreSQL database.
I have downloaded the file
http://www.pgxn.org/tag/analysis
I found instructions on how to ...
2
votes
0answers
53 views
assign_vertex_id：problems when creating the node ids
Before using pgrouting, I have to create the node ids.
I loaded my polyline layer into PostGIS Manager：
I type this in SQL query：
select assign_vertex_id('split_4', 800, 'geom', 'gid')
But as ...
2
votes
0answers
60 views
Get Multiple Shortest Path using PgRouting in One Query
I am trying to get multiple shortest path using A* Algorithm available in PgRouting.
I referred Solution given by UnderDark ( Link of the Stakoverflow Post ) . But it is not giving me proper Output.
...
2
votes
0answers
89 views
Adding polygon to existing database column
I've built a database with postgreSQL with a few geometry columns.
When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my DB using postgis. Now, I want to add ...
2
votes
0answers
56 views
Pgrouting can't find postgresql (on Mac)
I've installed both postgreSQL 9.0 and postgreSQL 9.1 on my mac, using binaries from http://www.kyngchaos.com. I also have postgis 1.5 installed.
I tried to install pgrouting, again using binaries ...
2
votes
0answers
128 views
Projecting PostGIS in Openlayers
I have a layer(base layer) with MultiLineString Geometries and now I need to project the layers(overlays) in the base layer from PostGIS using OpenLayers.
However, I got an idea how to project table ...
2
votes
0answers
113 views
Is there a way to start the route on pgrouting from a coordinate that is not a node?
After execute all steps from this pgRouting tutorial, now I have a map that creates and displays routes, but as the routing methods rely on parameters representing vertex Ids that was created using ...
2
votes
0answers
135 views
Postgresql Query Plugins Not Returning Results in QGIS
I'm using the Fishnet function as described here to create a grid.
If I use the following SQL to call the function to position a grid where I want it (I'm using NZGD2000 SRID = 2193) the query ...
2
votes
0answers
232 views
How to solve postgreSQL error when using QGIS Cloud plugin?
I created a qgis cloud account and installed the plugin. When I attempted to Upload Data using the plugin, I got the following error:
postgreSQL exception:
ERROR: "MD5" authentication with pgpool ...
1
vote
0answers
24 views
How to load a raster from in-memory bitmap (not from file) into PostgreSQL
I have a bitmap in memory that I would like to load as a raster to PostgreSQL.
An unfavorable option is saving the bitmap to file and then use raster2pgsql, but as we
have several cameras that ...
1
vote
0answers
24 views
error in loading raster tiles on postgreSQL
I am trying to import raster data from PostGIS to GeoServer.
I follow the instructions given on this link.
...
1
vote
0answers
94 views
QGIS SPIT errors loading shapefile into PostGIS
With QGIS 1.8 on Windows 7, I just installed PostgreSQL / PostGIS and tried to load my first data into it, a shapefile using SPIT, but failed:
ERROR: Geometry type (Polygon) does not match column ...
1
vote
0answers
67 views
Creating polygons for a choropleth map using PostGIS
I have a grid of points, each with a value to it as shown in the image below. The data was retrieved from PostGIS and rendered in Quantum GIS. The final result should be a polygons of a choropleth map ...
1
vote
0answers
72 views
I can't connect QGIS with postgresql
I can create a connection to the database in qgis and the test connection is successful. However when I actually connect to the database to export shape files I get the following error:
the ...
1
vote
0answers
48 views
New geographical point won't show on map
I did recently ask a question about how to add a new point to a PostGIS table. Now when I've got the new point in the table it should be visible on my map, but it isn't.
I'm using Mapnik together ...
1
vote
0answers
33 views
Do I need to deal with warnings about row count and spatial index to use pgRouting?
After read this nice post from underdark A Beginner’s Guide to pgRouting, although I still have some little problems, I think I can begin the "Creating a routable road network" stage right now.
I got ...
1
vote
0answers
128 views
Function for Selecting Points in a Polygon
I've been banging on this for a few hours, but since I'm relatively new to PostgreSQL and PostGIS, I can't find the solution. I'm trying to create a stored procedure (function) which will return all ...
1
vote
0answers
58 views
How can I snap 2 lines in QGIS so the st_distance between them is 0?
Sometimes when I snap the ends of 2 LineStrings together and I check the st_distance between those endpoints I get a value in the order of 1.1E-10 while at the same time when I check for equality of ...
1
vote
0answers
40 views
given sets of vehicle passing on each edge, how to get most used vehicle to avoid transition?
I have two tables: one, the resulting table from converting osm.xml via osm2po so I can use pgRouting, and another one that contains information on what edges each public vehicle passes through ...
1
vote
0answers
131 views
pgrouting shortest path result in wrong order
I am using the Dijkstra shortest path algorithm to plot a route between two points using the latest version of pgrouting in postgresql 9.1 with postGIS 2.0.1.
I am able to get a correct result ...
1
vote
0answers
77 views
Convert native box to geometry
I have an old table that contains bounding boxes of lat long coordinates in a "box" type.
How do I convert them to PostGIS geometry ?
I tried using ...
1
vote
0answers
125 views
How do I find the pgAdmin connection parameters?
I need to create a connection from arcmap to pgadmin using a python module because of an arcpy script, but I am unsure of how to get the pgadmin connection parameters. I think it may be some kind of ...
1
vote
0answers
83 views
Calculating spaces between roads from PostGIS database
Is it possible to calculate the spaces between the roads using a select statement in a PostGIS/PostGre Database? I tried using some combinations of the predefined functions as ST_Intersects & ...
1
vote
0answers
128 views
How to view error feedback in qgis when testing connection to postgres database?
Using qgis 1.8 on Ubuntu 10.04 with Postgres 8.4.13
I am creating a new (and my first) Postgresql connection in qgis.
I can connect to the user and the db using the pgsql client.
...
1
vote
0answers
143 views
Qgis Plugin development with postgres data
can someone help me with initial developing on qgis plugin that displays postgres data table on a QTTableView or QTTableWidget?
So far:
I can connect to database using psycopg2 or using ...
1
vote
0answers
58 views
Database has duplicate values after running pgrouting
I am a newbie with postgresql and sql statements so maybe it is a trivial question, I'm sorry for that.
I am working on a postgis database and try to use the pgrouting function. My goal is to store ...
1
vote
0answers
82 views
Is this pgRouting perfomance acceptable for my tiny server?
I'm testing pgrouting functions in a tiny server with 2GB of RAM and a dual core processor.
I wrote a program that create client process and they connect to the server in a specific hour to perform a ...
1
vote
0answers
198 views
add description to a new polygon and save -> postgres + geoserver + openlayers -> wfs-t insert
actually it is possible to draw a new polygon with openlayers and save it over WFS-T-insert (geoserver wfs-t 1.1.0) in my postgres-db:
var save = new OpenLayers.Control.Button({
title: "Save ...
1
vote
0answers
368 views
Geometry contains non-closed polygon: GeoServer output from PostGIS
I have imported a shp file using PostGIS shapefile loader plugin for pgAdmin3. The geometry type of the table created is MultiPolygon. I have cross checked the same using the following query.
SELECT ...
1
vote
0answers
207 views
Live KML Feeds - From the Ground Up, How Would You Build It and Why?
I found the "Live KML from PostGIS to Google Earth" post very informative but a bit daunting for someone new to the open source world of products like PostGIS and GeoServer.
If I am building the ...
1
vote
0answers
174 views
OSM Database created: now what happens?
I imported an OSM file into a Postgres DB using the Osmosis tool. Now, I need to extract some data but I can't find any schema description (I'm really a newbie in GIS). Where can I find it? Do you ...
1
vote
0answers
85 views
Getting started with storing LoST and GML searching
I am working on a logging and search database application.
The application will receive event records containing XML LoST values (RFC5222 Location-To-Service-Translation). These records will be ...
0
votes
0answers
20 views
How to write a point-in-polygon query for Postgis?
I'm trying to write a query in Postgis which will return all rows where a dynamically changing longitude/latitude point resides within the geometric polygon of that row (in the geom column). This is ...
0
votes
0answers
15 views
Fatal error: Call to undefined function pg_connect() in /var/www
I have seen this error online, I have followed the online instructions. However when i do this and restart wamp it wont load up, it stays amber, as soon as i recomment in the lines and restart wamp ...
0
votes
0answers
21 views
How can i enable PostGIS Shapefile and DBF Loader 2.0 plugin in PgAdmin III
First post here..
I am in windows and i want to download/enable the plugin "PostGIS Shapefile and DBF Loader 2.0"..
I installed postgis 2.0 using StackBuilder of postgresql installer
Thx in advance
...
0
votes
0answers
36 views
Is there any feature limit for Spatial data migration to Postgre SQL9.2…?
I am trying to migrate spatial data to Postgre SQL9.2 using 'Postgis Shapefile & DBF Loader 2.0'....Each time it returns a "Runtime error'.
Primary data extension - .shp ;
Data type - ...
0
votes
0answers
14 views
Which all columns should I add in postgresql table so that it stores elevation values and displays them in Geoserver?
I am using geoserver and postgresql. I imported raster (.tif) file to postgresql using raster2pgsql. The file thus imported creates a new table in postgresql. But when that file is previewed in ...
0
votes
0answers
34 views
Is QGIS OGR plug-in data provider (based on Postgres) limited to 500 features in layer?
I developed a plug-in based on OGR. It works fine but when I want to add a vector data (using my plug-in) I get 1449 features (with 76 columns) in my layer. Then I select this layer and load it.
...
0
votes
0answers
28 views
How to use for loop to make driving_distance more efficiently？
I use driving_distance function in pgRouting to work with my river network. There are 159 nodes in my river network, and I want to get the distance between all of the nodes. This is my code so far：
...
0
votes
0answers
46 views
Shooting star algorithm in postgres 8.4 and postgis1.4 showing fatal error and remaining are working fine
When I try to run this shooting star algorithm, the postgis suddenly loosing connection to postgres and showing error no connection to server
SELECT * FROM shortest_path_shooting_star('
SELECT gid ...
0
votes
0answers
15 views
Can driving_distance return all sets of distance from different starting points at one time？
I'm now using the extension of pgRouting, driving_distance, to search for the distance along the river system：
In the figure, the starting point is 3, but I want to get the distance starting from ...
0
votes
0answers
21 views
driving_distance does not return all sets of distance
As title, I am working with pgRouting, trying to get the distance matrix along the river system.
I use driving_distance function and it seems like I am getting what I want：
But when I check the ...
0
votes
0answers
41 views
tinyows failing to connect to postgresql - Ident authentication failed for user “postgres”
I'm getting the above error on a new and local tinyows installation on Centos 6. Postgresql 9.2, PostGIS 2.0.
I can connect to PostGreSQL locally and from my LAN using several other methods (psql, ...
0
votes
0answers
61 views
QGIS cannot view raster loaded to PostGIS through raster2pgsql
I tried to load a raster GeoTIFF image to a PostGIS database using "raster2pgsql" following the OpenGeo Suite Manual. The command I used is:
C:\>raster2pgsql -s 4283 -I -C -M "C:\Program ...
