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

learn more… | top users | synonyms

1
vote
0answers
31 views

ST_Split and looping problems PostGIS

I am a total PostGIS noob, and am having trouble understanding the finer points of SQL syntax. I am trying to take a large set of line data and clip it with a polygon. I then want to create a new ...
1
vote
0answers
28 views

Tool, API of or code samples for calculating spatial similarity between Lines

I am migrating a database with a road network to an other external data provider. We have joined our own data about roadworks, temporary speed-limits, etc., using ID and linear referencing on this ...
1
vote
0answers
26 views

pgRouting. pgr_ksp() returns -1 as id3

The documentation (http://docs.pgrouting.org/dev/src/ksp/doc/index.html) says that the result should be 0 for the last row. Is the same 0 than -1? I'm new on this. Thaks for the help.
1
vote
0answers
32 views

How to display table with more than one image from postgis in mapserver?

I have 3 tif files in one postgis(2.1.5 ver.) raster table. ( load with raster2pgsql) And i have mapserver MapServer 6.1-dev. I need to display table from postgis in qgis via mapserver. P.S I trying ...
1
vote
0answers
13 views

Replicate results from JSI using PostGIS

I am using OSM and facing an issue with finding the nearest road-segments to a given lat/lon point. I have a code that uses Java Spatial Index JSI which traverses the RTree index while computing the ...
1
vote
0answers
45 views

Mapserver display empty map when i add more then 1 raster file in 1 table postgis

Here is a part of mapfile with layer and WMS: WEB METADATA wms_title "Diplom" wms_abstract "no matter" wms_onlinesource ...
1
vote
0answers
49 views

GeoServer: Get styles from PostgreSQL/PostGIS table

We're running GeoServer with all layers coming from a PostGIS data source. Most people work directly on the PostGIS database, but we have one person sitting 10.000km away, and for him, connecting to ...
1
vote
0answers
33 views

Postgis - Creating Ellipse in WGS84 with metric parameters

I have points in WGS84 (x,y), radiuses in meters (rx, ry), rotation angle in degrees. I would like to create a new WGS84 geometry. I've tried this but the major/minor distances seem to be off by a ...
1
vote
0answers
47 views

Installing PostGIS Layer Viewer for pgAdmin III

I have difficulties installing pgAdmin's plugin PostGIS Layer Viewer. The official repository on GitHub gives this Web site for install procedure, then the former site gives this Web site for ...
1
vote
0answers
25 views

How to generate arcs from attribute data?

What I am trying to achieve is an ellipse-like shape from a digitised point location and cardinal measurements. For example, point location at 531500,181500 with the attributes North - 4m, South - ...
1
vote
0answers
44 views

Finding census block for given address using Tiger geocoder

I have a geocoder based on Tiger/Line data running on PostGIS. I need to find census block for a given address. How can I do it? Like I can do for census tract: SELECT get_tract(ST_Point(-71.101375, ...
1
vote
0answers
142 views

Fetching postgis data through php json and passing to leaflet map

I am new to this and trying to explore leaflet and geojson a bit. Please help me with this. This is my php page which I am using to fetch data from PostGIS. (the data opened successfully in the ...
1
vote
0answers
36 views

Batch load multiple shapefiles to Postgis

According to the shp2pgsql help, the options drop, append, create and prepare are mutually exclusive. So, if I want to create a table from a shape and then append multiple other shapefiles, I do ...
1
vote
0answers
71 views

pgsql2shp: create shapefile from empty table, but with known attributes (dbf)

I was trying to generate shapefile from postgis tables using pgsql2shp. Everything is fine except for table with no rows. When trying to create shapefile from an empty table, an error occurs: Could ...
1
vote
0answers
22 views

How to highlight joined features?

I have a task in QGIS (2.6), where I need to join two tables through an action (I think). I have some projects (points) that I need to connect to a list of partners (also points). I have data in both ...
1
vote
0answers
47 views

Dividing a geographical area (bbox) into smaller equal sized square miles

I'm working on an automated system for processing geographical information by bbox using PostGIS with an Openlayers 3 UI. The user will use dragbox to 'draw' the bbox they want processed. The catch ...
1
vote
0answers
63 views

Is there any VRP solver in Pgrouting 2.0?

after looking at older posts and googling for a while i guess there is not vrp solver (multiple trucks). there was DARP in pgr1.x but i can't see it in 2.x. i found a lot of information on ...
1
vote
0answers
71 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
72 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
388 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
32 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
30 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
34 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
39 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
113 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
188 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
37 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
77 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
38 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
63 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
113 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
70 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
116 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
46 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
90 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
55 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
131 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
27 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
65 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
77 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
95 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
50 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
27 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
75 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
153 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
85 views

Create geometry column of type 'PointZM' in PostGIS

I want to add a geometry column with geometry like "PointZM", "PolygonZM". I have written something like this: SELECT AddGeometryColumn ('data_rivne','geo_point','geom2',0,'POINTZM',0); But it ...
1
vote
0answers
67 views

Convert multiline to polygon

perfect result Shapefiles How I can convert this closed line to polygon with PostGIS? I tried many functions like ST_Polygonize, ST_MakePolygon, ST_BuildArea. I got some results, but not a perfect ...
1
vote
0answers
135 views

Finding areas with high POINT density from PostGIS table using Python

I have a PostGIS table with thousands of POINT objects and I want to find areas that have a high density of points. I have the DBSCAN clustering algorithm implemented in Python which does exactly ...
1
vote
0answers
60 views

Why does the postGIS file lose geometry?

I am loading shapefile data from a GPS into PostGIS via Leica ZenoOffice. This apparently imports fine with it's geometry in the attribute table. However, when I add a postGIS layer in QGIS the file ...
1
vote
0answers
39 views

Create “grid” of polygons with the same 3D area based on an underlying raster variable (e.g. DTM height)

This could apply to point or raster values but imagine a raster of a continuous variable such as height (DTM). Is there a way to create a complete coverage of polygons that will have an equal area, ...