PostgreSQL is an open source object-relational database system.
1
vote
1answer
41 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
37 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
36 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 ...
2
votes
0answers
47 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.
...
0
votes
1answer
62 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 ...
1
vote
1answer
33 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 ...
0
votes
1answer
42 views
Shp2pgsql - exec() not allowed on external server
Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise).
We put these commands in a php variable and use the exec() command to execute them. This ...
1
vote
0answers
127 views
Is there workaround for very slow ArcSDE 10.1 editing
I'm suffering from very slow editing in SDE from an Arcgis engine application, the SDE database is in local so there's no network issues. but i still ignore the reasons neither how to solve this ...
2
votes
2answers
101 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: ...
3
votes
2answers
66 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, ...
0
votes
2answers
42 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 ...
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, ...
0
votes
0answers
31 views
OGR shows no layers
I have an ESRI File Geodatabase (FileGDB) (size is 15+GB), which has over 10 layers, when I open it up in ArcGIS, everything seems to be working.
I want to move this database to postgreSQL with OGR ...
2
votes
1answer
66 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 ...
0
votes
1answer
143 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 ...
3
votes
1answer
80 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 ...
2
votes
1answer
125 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
43 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 ...
7
votes
2answers
171 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. ...
1
vote
2answers
76 views
Get Lon Lat values from a GEOGRAPHY data type in PostGIS
After storing lon lat values as a GEOGRAPHY data type, how do I retrieve the individual lat lon values?
Failed attempt:
SELECT id, geog, ST_X(geog), ST_Y(geog) FROM locations;
Error:
No function ...
1
vote
0answers
31 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 ...
0
votes
1answer
100 views
Unable to load Shapefile using pgShapeloader / shp2pgsql-gui (pgAdmin3's PostGIS Shapefile Import/Export Tool)
I am trying to load a shapefile (http://dds.cr.usgs.gov/pub/data/nationalatlas/statesp020_nt00032.tar.gz) into PostGIS 2.0.1 using pgAdmin3's PostGIS Shapefile Import/Export Tool.
However its not ...
1
vote
0answers
36 views
Determining the SRID of a dataset in PostGIS [duplicate]
Sometimes the dataset provides some information about its projection. For example, it can mention Horizontal_Datum_Name: North American Datum of 1983, Ellipsoid_Name: GRS1980, ...
2
votes
1answer
85 views
How to sum values of points inside polygons?
I have a polygon layer of territory and point layer with values from measurements.
I must to add sum values from points layer to polygon layer .
How to do this in PostGIS?
Supplemented:
Point layer ...
0
votes
1answer
39 views
Finding route contains Source and Destination points
I have a problem with finding routes that are near (in range X km) the passed points (for e.x. A and B) in PostgreSQL PostGIS.
Example:
The point A denotes Source point and The point B denotes the ...
0
votes
1answer
47 views
problems about setting pgrouting with QGIS under windows
I followed this website：A Beginner’s Guide to pgRouting and now facing some problems.
I finished steps before "Creating a routable road network", and open QGIS 1.8, click the PostGIS Manager plugin, ...
0
votes
1answer
59 views
How do I get the closest distance for each element within a point coordinate table from a polyline table?
Postgres: How do I get the closest distance for each element within a point coordinate table from a polyline table? And if this is possible what version of Postgres is this doable.
1
vote
2answers
155 views
What Spatial Reference System do I store Google Map's Lat/Lng in
I am new to PostGIS, Spatial Reference Systems and projections and want to store lat/lng coordinates retrieved from Google Maps and Openstreetmap and its services like the Geocoder/Nominatim. I'm ...
0
votes
1answer
93 views
What Spatial Reference System do I store Google Map's Lat/Lng in [duplicate]
I am new to PostGIS, Spatial Reference Systems and projections and want to store lat/lng coordinates retrieved from Google Maps and its services like the Geocoder. I'm working with data in America and ...
0
votes
1answer
47 views
ST_Box2D in PostGIS 2.0
I am getting an error trying to create a bounding box of a geometry using ST_Box2D(). Is the function deprecated? If so, what is the equivalent function?
SELECT ST_Box2D(ST_GeomFromText('LINESTRING(1 ...
0
votes
2answers
59 views
Manually add a new point to PostGIS table [duplicate]
I did accidently delete a table row - or well, in fact a whole subway station.
My attempt to solve the problem was this PostGIS function:
ST_GeomFromText('POINT(coordinates)')
But then PostgreSQL ...
4
votes
4answers
186 views
Unable to connect Postgis from QGIS 1.8.0
I have installed PostgreSQL and PostGIS on my laptop (Win 7 64 bit OS). I am running QGIS 1.8.0 on my machine .
When I am trying to connect Postgis I am getting connection failed error then I tried ...
3
votes
0answers
48 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 ...
-1
votes
1answer
36 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
2answers
121 views
imposm: Failing to import OSM data to PostgreSQL
Somehow I can't import OSM data to my database. I'm using Debian, PostgreSQL 9.1 and PostGIS 1.5. The user root has been granted all privileges for the database osm.
Input:
imposm -U root -d osm -m ...
3
votes
1answer
41 views
PostGIS: Merge multiple table with same GID
I just imported some shapefiles with the PostGIS importer. Because several errors and issues I had to split my shapefile in multiple parts. Then I imported them one by one. I thought I can easily ...
1
vote
1answer
59 views
pgsql2shp error when query is introduced
I'm trying to export a table from PostGIS using pgsql2shp. The basic query to export the entire table works fine using the following format:
"C:\Program Files\PostgreSQL\9.1\bin\pgsql2shp.exe" -f ...
0
votes
0answers
47 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 ...
7
votes
2answers
164 views
ArcGIS 10.1 edit PostgreSQL layer
I've been working with QuantumGIS/PostgreSQL/postGIS for a while now, without problems. But now I have to change QuantumGIS for ArcGIS 10.1.
I'm having trouble adding a layer from PostgreSQL and ...
0
votes
0answers
40 views
Table for feature layer in PostGIS database cannot be published and enabled on GeoServer
I have tried to publish a table for feature layer in a PostGIS database to GeoServer 2.2.5. The layer was added and published. However, the layer has got a yellow exclamation mark in the "Enabled?" ...
0
votes
0answers
62 views
geoserver PointStacker
I'm trying to implement a clustering solution using geoserver (version 2.3.0 ), for this I'm using the Rendering Transformation Point Stacker and the clustering itself works fine.
However I have ...
1
vote
1answer
69 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
2answers
70 views
geography_columns and geometry_columns purpose
Can anyone tell me what the purpose of the the geography_columns view and the geometry_columns table are used for in a PostGIS database?
My geography_columns view is empty so I can't see what the ...
0
votes
1answer
31 views
PostGIS: Querying a record table and explanatory table
Basically I have two tables one containing a collection of records and one table that contains extra info about features in the first. i.e
Records Table:
GID
SITE
SPECIES
GEOM
and the second table ...
2
votes
1answer
85 views
PostGIS ST_Contains question
Here's a quick summary about what I'm trying to do: Let's say I got two layers. One (A) with 10 polygons and one that is more granular with 100 polygons (B). Just to check if the behavior of PostGIS ...
1
vote
1answer
47 views
segment lines according to point using pgRouting?
I'm working on postgresql and I am trying to create table to generate graphs. I have a table that contains all the objects of a city (points) and another contains the city street. My goal now is to ...
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 ...
2
votes
1answer
63 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 ...
1
vote
2answers
191 views
Which version of pgRouting should I use with PostgreSQL 9.1 and PostGIS 2.0 (on win xp)?
I am new to GIS.
I want to install pgRouting on my system (win-xp 32-bit). I am trying to run routing_core.sql file and got the following error:
ERROR: incompatible library "C:/Program ...
4
votes
1answer
154 views
How to speed up an st_intersects() query?
I have a "huge" spatial database: 72GB, 200 millions documents with geometries (points)
I have a GIST index on the geometries
the database:
CREATE TABLE resources
(
id bigint NOT NULL,
accuracy ...
