PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
4
votes
2answers
116 views
ST_Distance is not delivering right results
I want to calculate the distance between lat/lon points.
I tried the following queries:
Select
ST_DISTANCE(ST_GeomFromText('POINT(-73.97923 40.75571)', 4326), ST_GeomFromText('POINT(-73.974509 ...
4
votes
1answer
128 views
How to import GeoTIFF via postGIS into GeoServer?
As a simple test case, I'm trying to configure the software stack of OpenGeo such that I can display a GeoTIFF as an overlay to a normal map like OSM. So I perform the following steps:
Create a ...
0
votes
0answers
23 views
returned error of postgis manage for loading data
I installing QGis 1.8.0.-lisboa on windows 7. Using postgis manage for loading data (shp file) to postgis.
I have returned error: Something's wrong:
['"shp2pgsql" \xad\xa5 ...
0
votes
0answers
37 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 - ...
-1
votes
0answers
22 views
First time running PostGIS on OS X, need help [closed]
I'm trying to get familiar with PostGIS and wanted to install on my OS X 10.8.3;
I've been goggling around and found out about postgres.app, downloaded and run it, but, any time I open the psql ...
1
vote
0answers
58 views
How to get .csv file into postGIS
I am using this:
COPY data_table (col1,col2,col3) FROM 'datafile.csv' DELIMITERS ',' CSV HEADER;
to get csv data into my postGIS table. It works wonderfully, except I need to have a 'pk_id serial ...
1
vote
1answer
58 views
Pgrouting - Networking
my problem is regarding routing.
I have a network based on bicycle graph links (SRID: 4326), with bidirected and directed ways.
I want to give the user the functionality to draw a route (shortest ...
1
vote
1answer
63 views
How to merge connected lines with same direction (PostGis)
I am looking for a way to join all lines that are connected, have the same direction, i.e. start point of one is end point of the other, and share some common attributes. In fact, I want to connect ...
1
vote
1answer
120 views
Mapping latlng values to a point on a HRAP grid
I have a copy of some NWS rainfall data loaded into a PostGIS database. Given a lat lng point, I want to find the rainfall for that given day.
The original data are in XMRG format and projected ...
1
vote
1answer
151 views
Geoserver, OpenLayers so slow for WFS! Why?
I am displaying 100 000 points in a layer via WFS protocol. I need about 5 minutes. However, 100 000 does not seems so much...
My points are stored in PostGIS, in a column defined this way : ...
0
votes
1answer
34 views
What's regular blocking arrangement ? (GDAL)
I am using GDAL tools to retrieve PostGiS raster. The code(command line) I am using is as follows :
gdal_translate -of AAIGrid "PG:host=localhost dbname='database' user='postgres' password='admin' ...
1
vote
2answers
56 views
Start postgresql+postgis without installation on Windows
I have used Windows7x64 and want start PostgreSQL+POSTGIS without installation process. I copy PostgresSQl\9.1 folder from other laptop to c:\opt. I need create .bat file with enviroment variables and ...
2
votes
2answers
66 views
Use FME to delete records from PostGIS before loading new records
I have some shapefiles. Each shapefile contains the data on a topic for a county. I have data for 26 counties.
In the filename of the shapefile, the county ID is given.
I load these shapefiles into ...
2
votes
2answers
78 views
Install the Pgadmin3 shapefile importer plugin on a Mac(10.8)?
I'm new to GIS related things and I'm setting up a Postgre/Postgis database for geospatial queries. I'd like to import various shapefiles into the database and I found that Pgadmin3 has a shapefile ...
-2
votes
1answer
24 views
Render specific vector data from database with openlayer
I want to render some data on a map. They are stored as points in my database (postGiS), each one is associated with a name. I want to render points with the same place name in the same color.
...
1
vote
1answer
78 views
How to restore a back up file into pgadmin III
My backup file containing about 50-60 tables , but I am able to just load only 6 tables for a new db and 31 tables for postgis dbase . And this was the error when I restore a backup file.
pg_restore: ...
0
votes
1answer
41 views
MapServer SOS Example
We are trying to run the MapServer SOS example at this link. However, we don´t know how to configure the data parameter in the mapfile.
What do we have to set in mapfile´s data parameter?
We need to ...
1
vote
1answer
86 views
How to uninstall PostgreSQL Server on localhost and reinstall with new user and password?
On Windows 7, I'd like to install a brand new, fresh installation of PostgreSQL/PostGIS on a laptop, and wipe ALL the localhost servers, users, data and passwords clean, and then reinstall as if it ...
0
votes
0answers
44 views
polygon/raster intersection artifacts
I'm intesecting a polygon with a raster using PostGIS > 2.0. The outer boundary of the polygon is formed by the convex hull of polygons (building outlines plus safety margin) and the inner rings are ...
2
votes
0answers
44 views
How to create a topologically correct dataset in PostGIS (with GRASS)?
I have shapefiles which I have loaded in postgis and now i am trying to use geometric function in postgis like ST_intersect and they fail because the data is not topological correct.
I have tried to ...
3
votes
2answers
103 views
Is there any efficient way to convert Geojson to WKT?
I want to use ST_GeomFromText() to load vector data to PostGIS. However, I don't know how to convert from Geojson type to WKT.
N.B. I know I can use OGR2OGR to upload the geojson directly, but I just ...
0
votes
0answers
63 views
QGIS Plugin Development - Displaying Data from a feature
I want to display data based on the feature currently selected/clicked on.
I am following a tutorial from http://www.qgisworkshop.org/html/workshop/plugins_tutorial.html.
It initially shows you how ...
1
vote
0answers
38 views
An algorithm for locating candidate labelling boxes within a polygon
Has anyone implemented this algorithm In PostGIS? Quoting from the paper:
Vector-based geographic information systems usually require annotation, such as a polygon number or attribute data, in a ...
4
votes
2answers
103 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
80 views
PostGIS, create line from points
I have a PostGIS table with position data of numerous vehicles and want to create lines from these points. Data can be selected by vehicle id and ordered by timestamp but how to create lines from the ...
1
vote
0answers
51 views
Dynamic SLD styling based on min / max value in a PostGIS column
I have a PostGIS table that contains the GDP of countries together with their polygon boundaries. I am using GeoServer to display this data via OpenLayers.
When styling the data, I want to avoid ...
1
vote
1answer
57 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
0answers
34 views
Loading raster from PostGIS DB into QGIS: succeeded yesterday, fails now
I have a PostgreSQL(v.9.2)/Postgis(v.2.0.3) database which includes raster layers (added through raster2pgsql).
To open them in QGIS (v.1.8.0-Lisboa), the "Add Postgis layer" menu will not work; ...
2
votes
2answers
53 views
PostGIS - ST_Collect but only include POLYGONs not POINTs?
In PostGSI, is there anyway to turn a GEOMETRYCOLLECTION into a MULTIPOLYGON by dropping all non-POLYGONs/non-MULTIPOLYGONs?
I'm doing a query that cuts a bunch of geometries (using ST_Intersection) ...
0
votes
1answer
56 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.
{
...
5
votes
3answers
163 views
How to insert a GeoJSON polygon into a PostGIS table?
I need to insert a polygon from GeoJSON to my PostGIS table. This is how the SQL query looks like.
INSERT INTO tablename (name, polygon)
VALUES
(
'Name',
ST_GeomFromGeoJSON
(
{
...
1
vote
1answer
35 views
Loading shapefile to a specific table in postgis using ogr2ogr
I have already created a geometry table in postgis. I want to load several shapefiles into that table using ogr2ogr. But I didn't find the parameter which could specify that table.
ogr2ogr -append ...
0
votes
1answer
36 views
Force Geoserver SRID 0
I'm developing a gis solution which uses only geometry data.
I designed my spatial DB with PostGIS and now I'm performing some trials connecting the DB with GeoServer map server (using the ...
0
votes
1answer
99 views
How to store data for gis system?
I'm developing a GIS solution using Postgis database and geoserver as web map server. The solution to develop will analyzes the defects (as a polygon) and process parameters values (as a linestring) ...
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 ...
1
vote
1answer
46 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 ...
3
votes
1answer
59 views
PostGIS select by lat/long bounding box
I have a minLat, minLong, maxLat and maxLong from a box drawn on a map. Right now, my query to get all the points in the box looks like this:
SELECT *
FROM geomTable
WHERE (longitude BETWEEN minLon ...
1
vote
1answer
52 views
Polygon to fill gap
Using postgis I want to fill a gap between other polygons.
Can you help with some directions what functions to use ?
Thank you and sorry if the question is rather noobish.
Image to explain from ...
0
votes
0answers
16 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
3answers
154 views
How do I stop the map at just one world/globe?
I am working on a project to put google maps layer and adding our data layers on top of it. using openlayers and google maps layer with out layer of top of it
now the google layer has max resolution ...
1
vote
1answer
57 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 ...
3
votes
2answers
107 views
What Is The Ideal Workflow To Map (British) Postcode Territories
I'm looking for the best workflow for mapping postcodes and calculated territories, but being relatively new to mapping I'm struggling on a few details and also the best practices for displaying these ...
1
vote
1answer
51 views
How do I convert MultiLines to MultiPolygons using Postgis
In postgis I'm using the following query to buffer lines to polygons:
UPDATE rivers
SET poly = ST_Multi(ST_Buffer(lines, 0.01))
where id = 1;
The column 'lines' is a MultiLine and the column ...
1
vote
1answer
39 views
geoserver fail in publishing all data field [closed]
I am trying to load my data from postgis to geoserver, and when I try to publish them, I don't get all the fields from the database and when I click on reload field type it does nothing, also I have a ...
0
votes
1answer
31 views
mapnik verbose?
I've got a PostGIS NHD layer thats not rendering in mapnik (using toposm code scripts) and I don't know why.
I've confirmed that the table data is there, positioned correctly and has the proper ...
1
vote
0answers
38 views
Joining layers with respective elements with PostGIS Topology
Recently I have started using PostGIS topology extension, but I have some difficulties in understanding how the structure works:
One of the key points is the use of "layer"s: as of what I understand, ...
1
vote
2answers
126 views
How to add a polygon from GeoJson into Leaflet?
I try to use the following function to add polygons to my Leaflet map.
function polygon(geojson)
{
alert(geojson); // alert for testing
layer = L.geoJson(geojson);
layer.addTo(map);
}
...
1
vote
0answers
91 views
How to get Lon/Lat values from the postgis raster type column
I have a tiff raster in my PostGIS 2.0 database. I want to get the value lat/lon and extra data like temperature from the raster type column in postgis table.
I want the table with columns ...
0
votes
3answers
45 views
Query to find the Intersection coordinates of multiple Polyon
I am using the below Query to find out the intersection coordinates of 2 Polygon and its working fine,but how to use or modify the query to find the intersection area coordinates for multiple(or N ...
8
votes
6answers
231 views
Is there a way to connect to PostgreSQL in ArcCatalog without SDE? [duplicate]
Is there a way to connect to PostgreSQL in ArcCatalog without SDE? I came across this post from 2011 that suggested using zigGIS but I can’t find a working link to the program.
A little background: ...
