PostgreSQL is an open source object-relational database system.
0
votes
0answers
30 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
23 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
39 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
17 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
13 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 ...
-1
votes
1answer
37 views
Getting error in replace() of postgresql [closed]
I am trying to use the replace() function to replace a character in a String column. My query is :
update table_name set name1 = replace(name1,'-',' ');
I am getting the following error :
...
1
vote
1answer
67 views
Win7 Senior users_Which pgRouting and postGIS versions are stable with postgreSQL8.4?
I'm working on a postgreSQL ,postGIS and pgRouting project on Windows 7
I need to work on a stable version (no time for risks), and I can see that many people are asking the same question many ...
1
vote
5answers
133 views
Unable to install the PostGIS extension to PostgreSQL on Ubuntu 12.04 LTS
I just installed Linux Ubuntu 12.04 LTS (on a virtual machine). I then successfully installed the PostgreSQL 8.4 database management system. I am now trying to install PostGIS, which is an extension ...
2
votes
1answer
37 views
How to install multiple versions of postgres in same os windows 7 64-bit?
I have already installed PostGIS along with opengeosuite and it is the latest version. Now I want to run pgrouting but the latest stable version does not compatible to the latest postgres versions. ...
1
vote
2answers
70 views
Public PostGIS Server available?
can anyone point me to a (if possible at all) list of public PostGIS Servers, where one can set up it's own database/tables ?
It's just that I would need a PostGIS 24h on, while dont having these ...
2
votes
0answers
226 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 ...
2
votes
3answers
71 views
Connnect to PostGIS db using QGIS - when not on localhost
I"m just getting started with PostgreSQL/PostGIS db (v9.2) and I'm wanting to connect to db while not on the localhost using QGIS. I've been able to connect successfully on localhost, however I'm not ...
0
votes
0answers
61 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 ...
5
votes
2answers
80 views
Which function for creating a POINT in PostGIS?
When defining a Point in PostGIS, when do you decide to use which of the following?
ST_SetSRID(ST_MakePoint(lon,lat),4326)
ST_SetSRID(ST_Point(long,lat),4326)
ST_SetSRID(ST_GeomFromText('POINT(lon ...
2
votes
1answer
54 views
point of intersection issues
I have a table containing a set of points of intersections.
Most of the roads intersects whith just one road BUT i have some roads which intersects with two, therefore three different point of ...
3
votes
1answer
116 views
How to import QGIS Raster into PostGIS
I have created a IDW heatmap using QGIS 1.8.0 and need to import the raster into PostGIS 2.0.1. QGIS saves the raster layer as a .asc file.
How do you import the raster into PostGIS as a Raster? What ...
5
votes
3answers
97 views
What is the easiest one click install method for PostGIS and it's entire dependencies?
For someone new to database servers and their dependencies, what is the easiest assured way of installing PostGIS on a machine with no other software beyond what comes with its operating system? I'd ...
1
vote
1answer
35 views
Postgis invalid geometry from shape file
I'm having trouble converting a Feature class (shape file) to a DB table (Postgresql 8.4/Postgis 1.5). This is the command in the pg log:
INSERT INTO "public"."distritos" ("Shape" , "DEPARTAMEN" , ...
2
votes
1answer
73 views
Get the lines between all points of a polygon in PostGis : avoid nested loop?
I am trying to get all the lines between the points of a polygon, by writing PostGreSQL functions. I have written the two following functions that do the job fine :
the first function to get all the ...
1
vote
1answer
70 views
How to visualize pgrouting query results in mapguide open source
I would like to make a spatial query using postgis 2.0 and pgrouting 1.05 then visualize results in Mapguide open source.Any suggestions?
1
vote
0answers
54 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 ...
0
votes
2answers
56 views
Is PostGIS doing a full table scan?
I am trying to retrieve all points p that are within polygons c. While building the query, I came across this strange behavior.
Question: Why does query 2 takes so long compared to query 1? Is it ...
2
votes
1answer
144 views
osm2pgsql Error: operator class “gist_geometry_ops” does not exist for access method “gist”
When using osm2pgsql to import massachusetts-latest.osm.bz2 into PostGIS 2.0.1 database osm (running on PostgreSQL 9.1 on an Ubuntu 12.04), I get the error failed: ERROR: operator class ...
1
vote
0answers
65 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 ...
-3
votes
1answer
43 views
What is the best way to develop mapping app for analysis and queries? [closed]
I would have some polygons and points data, and I want to develop api which will allow users to perform analysis and queries like demographic data buffered 20km around some address etc. So, those ...
0
votes
1answer
52 views
Creating the node ids：Is this SQL error related to geometry type？
I loaded a multilinestring layer into PostGIS Manager：
and use the SQL query, trying to get the table with the node ids：
ALTER TABLE split_4 ADD COLUMN source integer;
ALTER TABLE split_4 ADD ...
2
votes
0answers
51 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 ...
4
votes
2answers
130 views
Which spatial DBMS should I select?
I found there are a number of RDMS have the spatial capability e.g. mysql, postgreSQL
I considering which I should go forward!
I would like to store the lat lon coord from the tracker to the db ...
0
votes
1answer
38 views
Schema for offline map editing and pass to production environment
I'm working with QuantumGIs and PostgreSQL/Postgis. So when I edit the layers, the changes are reflected on the DB.
The thing is I want to do some "offline" editing before committing the changes to ...
3
votes
2answers
444 views
How to use pgRouting's dijkstra_sp_delta_directed with WHERE clause?
Right now I am using PgRouting for vehicle routing and I have problem with Dijkstra shortest path. My query is:
SELECT * FROM shortest_path('SELECT gid AS id,
source::int4 AS source,
...
1
vote
1answer
42 views
SQL Command to convert pgRouting result to GeoJSON
My goal is to produce a Web UI for pgRouting using this tutorial. I have already imported my data from an OSM pBF to PostGIS using osm2po. Using the pgRoutingLayer plugin for QGIS, I was able to ...
2
votes
1answer
42 views
Force dimensionality with shp2pgsql
After invoking:
shp2pgsql -W "latin1" theshape.shp > thesql.sql
My console responds with:
Shapefile type: PolygonZ
Postgis type: MULTIPOLYGON[2]
Note the shapefile type is PolygonZ. The result ...
0
votes
1answer
65 views
In QGIS can I show just the lines in a Postgis query? How can I do that?
I have three tables in Postgresql, each table with one layer of lines.
I want to show the path of an initial line to another final. Is it possible executing a SQL query?
Thanks
My three tables are ...
2
votes
0answers
49 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.
...
1
vote
2answers
40 views
Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)
I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
6
votes
1answer
830 views
Postgresql for Qgis and Arcgis - What to do/What not to do
Is it possible to use postgresql with QGIS and ArcGIS? One database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know that I ...
2
votes
2answers
112 views
What does 'DBMS table not found' message mean?
I have a plain postgressql table (version 8.2). I am trying to connect to it to it from ArcGIS desktop 10.0, and use as a query layer, as given in this document: ...
1
vote
1answer
36 views
Difference in raster size using raster2pgsql
I use the PostGIS-build-in raster2pgsql to load SAGA-raster into the db. I tried to grid them into 100x100-tiles, just as seen in the code:
/usr/lib/postgresql/9.2/bin/raster2pgsql -s 32632 -a -F ...
3
votes
2answers
73 views
group by timestamp interval 10 minutes postgresql
I need some help on this:
I need to group by a period of time spliting up by 10 minutes:
I have this query below that returns me a result set
SELECT timestamp
FROM table_1, ...
7
votes
2answers
182 views
Huge point cloud laser data in PostGIS - Storing and Processing it
I wonder, how it's possible to store huge sets of laser scanned point cloud data in PostGIS, with the time-aspect for processing it in mind. I know, there exists a geometry-object Point in PostGIS. ...
0
votes
2answers
44 views
How to create a function by passing polygon datatype as a parameter
I am getting stuck while executing the function,Function is getting created but while i am passing the values getting error.
CREATE OR REPLACE FUNCTION INS_CCX_ply(P_ID INTEGER,P_POLY_ID ...
2
votes
1answer
64 views
st_clip and gdal_translate: “Error browsing database for PostGIS Raster properties” - Why?
Im using shell-script, postgis2.0 and gdal for trying to clip raster apart, using an overlapping raster and a the_geom-object. At first I create a view to clip the overlapping part of the raster. It ...
0
votes
0answers
35 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, ...
2
votes
1answer
68 views
Cannot find my schemas in QGIS's “Add PostGIS layers”
When I connect to my PostGIS database using QGIS's Add PostGIS Layers, I see only
public
topology
pg_catalog
information_schema
My other schemas that I have created are not shown here. Anyone else ...
7
votes
3answers
195 views
Why doesn't pgRouting return the best path?
Let the next portion of a graph:
When I use the function shortest_path between the points A and B, I got the blue path. Why does this happen?
0
votes
1answer
157 views
How to store an image in PostgreSQL and display it in an openlayers popup?
This is question regarding storing of image in PostgreSQL and display in openlayers popup through geoserver(using wms service).
PostgreSQL is installed in my virtual machine.
I tried to store image ...
2
votes
1answer
3k views
How to install PostgreSQL 9.2 with PostGIS 2.0 on Ubuntu 11.10 (or higher)?
I have read this question: Install PostGIS v2 for PostgreSQL v9.2, but it didn't resolve my problem.
I added the PostgreSQL backports PPA and installed the postgresql-9.2 package, but there is no ...
8
votes
4answers
5k views
How can I enable Shapefile GUI Loader in pgadmin3?
I have installed PostgreSQL 9.1 with PostGIS 1.5.3 on Ubuntu 11.10.
I also installed pgadmin3 1.14.0-beta1, following this instructions.
If I remember correctly, when I installed PostGIS on Windows ...
3
votes
1answer
81 views
How to Find points in a Kilometre radius
I am new to PostGIS and GeoData.
I need to find where the lightning has stroke by a period of time and kilometre radius based on a given location.
I have given lon/lat and my table is:
latitude ...
1
vote
0answers
44 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 ...
