Tagged Questions
3
votes
1answer
18 views
What are the benefits of using ArcGIS with Postgresql over simply ArcSDE?
I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed ...
1
vote
1answer
36 views
Geometry has incorrect latitude-longitudes
SELECT ST_SRID(geom) AS s FROM zones GROUP BY s;
returns a single record: 4326
SELECT Find_SRID('public', 'zones', 'geom');
returns 4326
SELECT AsText(geom) FROM zones
returns geometry like:
...
0
votes
1answer
31 views
PostGIS error reads “Geometry has Z dimension but column does not” [duplicate]
I try to store a polygon in GeoJSON format into my PostGIS table. Both are using the CRS EPSG:3857. This is how the polygon is defined. Note that I put in some whitespace to make it more readable.
{
...
2
votes
0answers
16 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 ...
1
vote
1answer
30 views
PgAdmin cannot load postgis for a database
Postgis works fine on my other postgresql databases, but I can't load postgis and postgis_topology extensions on a new database. I get following error message:
ERROR: could not load library (path to ...
0
votes
0answers
15 views
How to find all possible paths by Postgis / Pgrout [duplicate]
There are functions available to find the shortest paths in Postgis / Pgrouting extension. But is it possible to find all the possible paths between two points/nodes ?
Is there any such function ...
0
votes
1answer
32 views
PostgreSQL: transform spatial column from PG_GEOMETRY to ST_GEOMETRY
I have spatial Data stored in my PostgreSQL database as PostGIS Geometry (PG_GEOMETRY). It looks for example like this: 010100002031BF0D0000000000F989264152B81E057E6D5841
Now I would like to move ...
0
votes
2answers
55 views
Cannot insert simple geometry data
I installed PostgreSQL 9.2.4 and PostGIS 2.0.3 on my Windows 8 machine. Then I created a table using phpPgAdmin and added a geometry column using the following statement.
SELECT ...
0
votes
1answer
36 views
Cant Instal psycopg2 on mac 10.8.2
I know there Have been a lot of similar questions asked but none address this issue as I far as I can tell. When I am trying to install the sextante plugin, or run PostGIS Manager in QGIS I receive ...
1
vote
1answer
67 views
PostGIS not converting GIS data into latitude/longitude values
I am running PostgreSQL and PostGIS. I am trying to do something mind-numbingly simple: determine the latitude and the longitude of a point.
Unfortunately, PostGIS stubbornly refuses to transform the ...
2
votes
0answers
46 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 ...
0
votes
1answer
29 views
ST_MakeEnvelope returning too many geos
I am using the following query in my db:
SELECT bg_id, ST_AsGeoJSON(the_geom)
FROM bg
WHERE bg.the_geom && ST_MakeEnvelope(xxx, xxx, xxx, xxx);
It seems to execute alright but when I draw ...
5
votes
1answer
116 views
How to implement Spatial Autocorrelation using QGIS or PostgreSQL (or any free application)?
I am a total newbie on the GIS scene so I hope this is not a stupid question.
I have two layers in a PostgreSQL database.
The first layer contains points where events happened in Europe.
The second ...
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 ...
1
vote
1answer
65 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
116 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
33 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. ...
-3
votes
0answers
49 views
What versions of Postgres, PostGIS and pgRouting shall I use on a 64bit windows os? [closed]
Please give me the links and stepwise instructions briefly for installing all the three.
Condition : There shouldn't be any bug in shooting star algorthm. So the comaptable stable versions of the ...
1
vote
2answers
69 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 ...
0
votes
1answer
32 views
How to install PostGIS 8.4 in windows 7 64 bit parallel to an existing PostGIS 9.2?
PostGIS 9.2 is installed along with OpenGeoSuite using one click setup. But 9.2 dont support pgRouting. So I need to install 8.4. I dont how to include binaries and all. So someone please tell me how ...
0
votes
0answers
56 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 ...
0
votes
1answer
43 views
raster2pgsql missing in Opengeo-suite installation
I installed opengeo-suite 3.0.2 on Ubuntu 12.04 and although the stack seems to be working fine, raster2pgsql is no where to be seen!
root@mywebsite:/usr/local/lib/postgresql/9.2# locate raster2pgsql
...
3
votes
1answer
106 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
2answers
73 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
66 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
0answers
52 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 ...
5
votes
3answers
90 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 ...
2
votes
3answers
66 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
2answers
54 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 ...
3
votes
2answers
79 views
Problem loading PostGIS (Postgres) View layer in QGIS
Why is Postgres user XX via command „Add PostGIS Layers“ in QGIS enabled upload only View tables which owns?
Or how to achieve it to the user XX via PostGIS can load View table which owns the user YY?
...
0
votes
1answer
48 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
49 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 ...
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.
...
1
vote
1answer
34 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 ...
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
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 ...
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 ...
2
votes
1answer
126 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 ...
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, ...
