PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
1
vote
1answer
23 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
0answers
24 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 ...
0
votes
0answers
38 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
50 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
19 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
30 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 ...
1
vote
1answer
18 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
1answer
25 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
17 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
41 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
22 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
38 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
34 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
32 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
65 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
44 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
32 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
70 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
64 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
32 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
48 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
20 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
36 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
40 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
95 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
25 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
34 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
75 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
25 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
34 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 ...
1
vote
1answer
37 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
40 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
141 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 ...
-2
votes
0answers
51 views
Openlayers, geoserver and postGis
I checked many examples but i could not find one that does following.I need to select multiple parcels(polygons) by drawing lines.Selected parcels should have different color from the rest.After ...
1
vote
1answer
38 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
93 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
44 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
29 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
29 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
29 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
83 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
60 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
40 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
203 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: ...
2
votes
1answer
42 views
Is is possible to import PostGIS functions from another database?
Seeing that I can't find the question asked here before, I have a feeling that I'm doing something wrong!
However, here is my problem: I have one PostGIS database with 525 functions, and one with ...
1
vote
1answer
40 views
How to get polygons from PostGIS table to PHP array best?
Currently I fetch polygons from a database table using ST_AsText(). The results are in text format, like the following.
POLYGON((84 104,212 48,321 122,243 179,275 238,131 240,84 104))
I am not ...
0
votes
1answer
30 views
How can I find the SRID from the WKT out of a GRIB file?
I have a grib2 file which I'm trying to import into PostGIS 2.0 Raster and process. Trouble is, I can't figure out what the SRID is supposed to be, or one close enough for government work. Running ...
-1
votes
1answer
61 views
QGIS and Python - create line with multiple points in postgis
How can I create a line, with Python functions, with many points that are records in Postgis?
Thank you
2
votes
1answer
34 views
Raster Tile Merge Performance of PostGIS 2.0
I'm attempting to intersect Australian Census boundary polygons with the 1" SRTM DEM (10.5bn points across Australia), and output the result as a single raster image on the fly.
The DEM is stored in ...
