PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

learn more… | top users | synonyms

2
votes
0answers
91 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?" ...
2
votes
0answers
312 views

working with multiple wfs-t layers

I am using multiple wfs layers and using editing tools in that like edit,draw,save etc. The code is shown here...... var district = new OpenLayers.Layer.Vector("district(wfs)", { ...
2
votes
0answers
33 views

Automatic insert of project name into database

For every layer I've a field in my postGIS database that should be filled with the name of the current project and today I do this manually. Is there a way to do this with the Commands that can be ...
2
votes
0answers
263 views

Different results given by PostGIS and MySQL?

I'm developing a spatial database of administrative areas. I started out with PostGIS, but as MySQL is being used in our other projects, I thought I would at least try to create a spatial-enabled ...
2
votes
0answers
184 views

Projecting PostGIS in Openlayers

I have a layer(base layer) with MultiLineString Geometries and now I need to project the layers(overlays) in the base layer from PostGIS using OpenLayers. However, I got an idea how to project table ...
2
votes
0answers
45 views

Is it possible to permanently save the Edit Widget for a Postgis layer?

Is there a way of configure the editing type for a POSTGIS layer through Edit Plugin and do not lose the changes after remove the layer or exit the program?
2
votes
0answers
586 views

why preview image is blank for ImageMosaicJDBC (postgis raster) layer?

I follow http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html to publish a ImageMosaicJDBC layer in geoserver. the layer seems published ok and saved, but the preview of this layer ...
2
votes
0answers
254 views

From pgRouting shortest_path back to osm node id

I'm successfully performing path finding queries like shortest_path on data imported with osm2pgrouting. The tables I have inside my pgrouting DB are the following: List of relations ...
2
votes
0answers
196 views

Error recognising password; importing OSM to PostGIS in QGIS

When selecting OSM Tools (Import into PostGIS) , attching my .osm file in the Input option, selecting my OSM Database, and then clicking run, I am prompted to enter a password for connection. "Enter ...
2
votes
0answers
269 views

Postgresql Query Plugins Not Returning Results in QGIS

I'm using the Fishnet function as described here to create a grid. If I use the following SQL to call the function to position a grid where I want it (I'm using NZGD2000 SRID = 2193) the query ...
2
votes
0answers
213 views

Displaying text from dxf in Openlayers

I managed to import .dxf into Postgis table, and now have, among others, rows with Point geometries and values in text column (which corespodent with Label values from ACAD .dxf). What is the best ...
2
votes
0answers
89 views

MultiPolygon from database

I would like to know how to create an instance of a Multipoint from a PostGIS database.. I do the query , then got the ResultSet named "area" , the column with MultiPolygon attributes is named "geom" ...
2
votes
0answers
308 views

Parcel ID Mapping (brainstorming)

In my project I have a table full of residential properties by Parcel_ID. Table 2 is a TIGER streets shapefile. I would like to build a query in MS Access displaying all properties within a mile ...
2
votes
0answers
97 views

network related issues arising when running an arcpy script

Essentially I wrote an arcpy script that is within a toolbox that I ported over to a different machine to test out after the script worked locally. The script essentially utilizes the psycopg module ...
2
votes
0answers
103 views

Symbolizing Layers from a PostGIS Database to many Client Computers

I was hoping someone could help with a symbolizing issue. I have a PostGIS database on a server with a number of layers. The layers of a series of polygons, lines and points that all share the same ...
2
votes
0answers
393 views

line segments using points

Is there a way to get line segments from a linestring using points with lat/lng coordinates? ST_Line_Substring is taking float8 start/end points. Is there a way to replace the float8 with lat/lng? I ...
2
votes
0answers
483 views

Arc by center point in PostGIS does not fit the circle

I'd like to store a GML ArcByCenterPoint in PostGIS. I can work out the start, middle and end points required by the CIRCULARSTRING type and all seems to be OK, except that when I visualise the arc it ...
1
vote
0answers
11 views

QGIS Plugin for PostGIS versioning

Does anyone of you know a QGIS-Plugin for Versioning PostGIS-Data? I know there was pgVersion of Horst Düster but as far as I know this was not updated for QGIS 2.x (at least not for the "normal" QGIS ...
1
vote
0answers
13 views

How to get changeset tag from .osm file into PostGIS enabled Postgres db

End goal: visualize geographic data from .osm file with QGIS by adding PostGIS layers which include changeset information. I have used osm2pgsql successfully to populate PostGIS and visualize the ...
1
vote
0answers
14 views

Spatially joining 2 point layers i.e. pole and customer points using spatial join of PostGIS/PostgreSQL?

I created a 20 meter buffer around pole then tried to intersect with customer layer, using the query below, but it was taking a huge time to process. SELECT ...
1
vote
0answers
28 views

Export DGN to shape or postgis with multiple mslinks

I need a command line tool to export DGN files to shapefile or PostGIS, I tried ogr2ogr but it only exports type, level, graphicgroup, colorindex, weight, style, entitynum, mslink and text. I need the ...
1
vote
0answers
41 views

Create polygons enclosing same number of points on PostGIS

I have a geodatabase on Postgis with points representing customers, what i need is give a number of customers, lets say 100 and it need to generate polygons enclosing 100 clients each one. I only ...
1
vote
0answers
76 views

Using ArcMap 10.3 with PostgreSQL 9.3.x database and PostGIS 2.1.1?

I have a PostGIS database that we use for data storage. I would like to open this data in ArcMap instead of storing it in another format. In previous versions of ArcMap it has been possible to open ...
1
vote
0answers
20 views

Searching a table within PostGIS using PyQGIS script

Morning all, I am looking for some guidance in trying to set up a script that will search a PostGIS database using a wildcard and then open a certain file directory that will be in one of the fields. ...
1
vote
0answers
27 views

How to correctly upload Shapefile into PostGIS on ubuntu?

I want to know how to use upload shape file via Postgis. Can u please help me? .com/nsVuQ.png
1
vote
0answers
18 views

From Openlayers 2 report generation

Can u suggest how a JasperReport can be geneated by an user accessing an point (say a wireless tower in map) on a active layer done in openlayers 3. Here the architecture uses openlayers 3 and is ...
1
vote
0answers
19 views

How do I step into the C++ functions from an external Python app I'm debugging?

I just wanted to see how to step into the C++ class QgsVectorLayer()'s methods from the python call to QgsVectorLayer(self.uri.uri(),'foo','postgres'). I'm trying to debug and it trying to step into ...
1
vote
0answers
83 views

How to create projects in Tilemill Ubuntu Web service?

I have set up Tilemill on a Ubuntu server and successfully accessed it from browser using TILEMILL_HOST:20009 I have already uploaded planet_osm data to postgresql/PostGIS DB in the same server ...
1
vote
0answers
73 views

PostGIS: snap latitude/longitude input to nearest OSM road point

I need a function to return the nearest OSM road point for any latitude/longitude. i.e. users input a latitude/longitude and postgis finds and uses the point on a road that is the nearest to it. ...
1
vote
0answers
30 views

Postgis routes diagram point-to-point

I have a set of centroids to which are related a set of points characterized by linename. The table with the points contains these fields: id ¦ linename ¦ lat ¦ lon¦ I would like to make a diagram ...
1
vote
0answers
58 views

Create GeoServer SQL View with variable number of arguments ( double precison [ ] )

I was trying to create a PostGIS procedural function which will perform a particular operation depending upon the user's provided coordinates. But since the user can provide any number of coordinates, ...
1
vote
0answers
35 views

create automatically temperature or isotherms map with PostGIS?

Is there any possibility to create automatically temperature or isotherms map through a points table stored in PostGIS? I need to serve this map on a web (Geoserver). The information is updated each ...
1
vote
0answers
24 views

How to Increase the length of column type geometry in postgres(pgAdminIII)

I am just wondering is there any way to increase the default length of column type geometry in postgres. Since we are trying to save large number of vertices polygon in to the geometry column geom in ...
1
vote
0answers
30 views

Import .gfs file into PostGIS?

Is it possible to import a .gfs file into PostGIS? I can open the .gfs file in QGis, so I assume it is a geographic file of some kind: but I'm not sure how to get it into PostGIS. I have Googled but ...
1
vote
0answers
77 views

Simplifying geometries and calculating non-spatial averages

I'm quite new to using proper spatial tools, and have a simple question that doesn't immediately show up on google. I have a table that contains multiple rows of empiric data (say, speed of a ...
1
vote
0answers
44 views

Create a “wide” table recording all overlaps between polygons in PostGIS

I have a set of overlapping polygons and would like to record which polygons are overlapping at each intersection. I have followed the instructions at: ...
1
vote
0answers
77 views

Postgis geocoder size and performance

I have installed Postgresql 9.3.5 and Postgis 2.1.2 on a 16Gb Ubuntu 14.04 system. (1) If I load all the states TIGER data, using the scripts provided in Postgis, how big will the database be for the ...
1
vote
0answers
40 views

Read and Write data with Open Layers3

I'am currently using postGIS/geoDjango/OL3 I need the capability for a user to drop a point on the map, and store that in my database. When any user returns, that point will be shown on the map. ...
1
vote
0answers
63 views

Issues with QGIS WFS editing/PostGIS rendering

I want to be able to view and edit spatial data within a postgis database. I have tried using a WFS with Geoserver - but constantly get 'Empty Response' error and the Network log says the request ...
1
vote
0answers
42 views

Error creating a spatial database. ERROR

I have been trying to get Postgis set up for a while now, I am stuck on one error and have not found a solutions yet. This is on Ubuntu 14.04.1. I am trying to run: CREATE EXTENSION postgis But am ...
1
vote
0answers
55 views

Invalid join selectivity error in postgis 2.1.3

I have 2 tables, one for points and one for polygons. I want to find points falling within theese polygons, so I quered: select p.id, l.id from points p inner join polys l on st_contains(l.geom, ...
1
vote
0answers
16 views

PostGIS 1.5 libstdc++ error

After some package updates on my Debian machine all my database queries involving postgis functions or types are returning: Error message from server: ERROR: could not load library ...
1
vote
0answers
45 views

Are there naming rules for direct connections from ArcGIS to PostgreSQL?

I don't have problem direct connecting arcgis to postgresql if my database name contains only letters, but when the name contains dashes or underscore e.g:"gisdb-dev", I receive an error when setting ...
1
vote
0answers
58 views

Postgis - Split linestring between point A and B

I need to find the different trajectories between point A and B. In the image is possible to see 2 differents trajectories. The way i use to calculate them is: Found the min time and the max time (in ...
1
vote
0answers
75 views

What is wrong with my WFS-T protocol setup?

So I want to transfer some Vector Layer Features from javascript code to my geoserver and then to postGIS, my code looks like this: saveStrategy = new OpenLayers.Strategy.Save(); ...
1
vote
0answers
40 views

Comparing and updating two large tables

I'm using CartoDB to sync the status from tables using a common ID on each one. The problem I found it's the tables are too large, over 29k rows. Here is the query I'm using and the gives me an ...
1
vote
0answers
26 views

Error in querying data

I have a mapserver file as below , I get blank page with no map executing this query: NAME var DATA xyz STATUS ON TYPE POINT DUMP TRUE ...
1
vote
0answers
53 views

Clustering the WGS84 point features (projection transformation aspects)

My question is quite trivial and was discussed many times before (like here) but in our case it has the confounding extra requirements... The list of sparsely distributed 2d point features is stored ...
1
vote
0answers
109 views

All map services display pink tiles

I have implemented mapserver in Ubuntu 14.04 with postgresql 9.3, postgis and imposm using GitHub tutorial. After completing the tutorial all map services display pink tiles not map info. i was not ...
1
vote
0answers
55 views

List of vector to one raster in PostGIS

Hi PostGIS developers! I need to rasterize a part of OSM map by coordinates. I found rather good algorithm, but can’t finish it. I have problems in STEP 3. I described all algorithm here – may be ...