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

learn more… | top users | synonyms

2
votes
0answers
314 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
195 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
53 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
787 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
323 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
252 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
308 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
274 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
95 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
1k views

How to fire a query from OpenLayers to GeoServer to fetch 'the_geom' column in PostGIS table?

I am coloring the polygon shapes of world_country. I have OpenLayers in my UI, GeoServer as server and PostGIS as db. All I want is fire this query: select the_geom from world_country where ...
2
votes
0answers
364 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
103 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
118 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
417 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
622 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
9 views

PostGIS Street Intersection Autocomplete with full text search

What I'm attempting to do is create a custom autocomplete for addresses, road intersections, POI's, etc. For now we are going to using Mapbox GL (we'll be creating a custom map at a later phase), ...
1
vote
0answers
24 views

ST_Intersection between MultiPolygon tables leads to gaps, missing intersections

I am trying to intersect two MultiPolygon tables, which are in the same UTM projection, and calculate the area of their intersections. I am getting some surprising results when I examine the ...
1
vote
0answers
14 views
+50

Update GeoDjango models from KML?

I'm working in Django 1.9 and Postgres 9.4 with PostGIS extensions. I have a KML file, and I want to use it to update my geo fields. This is my model: class PCT(models.Model): code = ...
1
vote
0answers
18 views

Problems using pgr_fromAtoB - postgresql error

I have some trouble with the pgr_fromAtoB function of the workshop. I get: ERROR: column "ways" does not exist But "ways" is the table, not a column. What am I do wrong? My table ways looks like: ...
1
vote
0answers
32 views

PostGIS query: filter rows by area?

I am working with PostGIS (in CartoDB). I want to find all rows in the database with an area of over 100 square metres. I've been trying this: SELECT *, ST_AREA(the_geom::geography) AS area ...
1
vote
0answers
16 views

Import raster using raster2pgsql with out-of-db option not working

I am using raster2pgsql to import DTED data into postgis database. I would like the data to be out-of-db, I am using the command as follows. raster2pgsql -R /home/gis/elevation/DTED/area.dt2 ...
1
vote
0answers
34 views

How to connect PostGIS raster data to Geoserver?

The data I have used is DEM. It creates a table and has 2 columns in PostGIS. Is it necessary to create a new table again and follow the configuration process as mentioned here The error - INFO | ...
1
vote
0answers
28 views

ST_Intersects in postgis

My version : postgres 8.4.1/postgis 1.4.0 I want to perform a simple spatial join with the following query : SELECT code_insee, nom, id_canton, lib_canton FROM localisants.alca_toponyme_commune ...
1
vote
0answers
29 views

QGIS - Alternatives to Offline Editing Plugin

I am looking for a way to edit my postgis layers offline (in field) using a Microsft Surface Tablet. I have been testing the "Offline Editing Plugin" unsuccessfully. These are the issues I have ...
1
vote
0answers
22 views

St_intersects returning false results in postgis

I want to intersect point geometry with raster. In postgis I'm executing select st_intersects(geom,rast) from testraster1,pft_pft and the result is false even though the points are sitting on ...
1
vote
0answers
22 views

QGIS crashes when using PostgreSQL/PostGIS triggers

When using PostgreSQL/PostGIS triggers saving layer edits gets slower and slower every time when saving a layer edit. This issue occurs after a few up to a few dozen saved layer edits. Finally QGIS ...
1
vote
0answers
19 views

PostGIS: Find nearest point given coordinates from another table

So I have two tables, one table is called stores which has the name of the store as well as the geom column that contains the coordinates for the stores. The other one is customers which has the ...
1
vote
0answers
24 views

pgrouting pointAtoB function

Has anyone successfully implemented pgr_fromAtoB function? Sometimes I get 0 results from points in the same line string, sometimes I do get results, How can accuracy be improved?, or maybe do I ...
1
vote
0answers
67 views

Visualizing shapefiles on web using SHINY package of R with PostGIS?

I am using PostGIS database to store my shapefiles. Now I want to read those files through shiny package of R. How can I visualize those files on web using shiny package of R and perform statistical ...
1
vote
0answers
55 views

How to calculate multiple distances between set of points and vector grid in PostGIS?

My set contains the following input data: A set of points and a hexagonal (vector) grid. For each cell in the grid, I want to calculate the driving-distance to each point. I thought this would be a ...
1
vote
0answers
39 views

Length not respected in ST_Segmentize

When segmentizing a geography line in Postgis, the max segment length does not seem to be respected when the line is more than 3000km. The error grows when the length of the line increases. Below the ...
1
vote
0answers
29 views

Multi-dimensional points in PostGIS

I have experience in PostgreSQL but I am fresh new in PostGIS and I can see how quickly would I like it. I have extensively worked on time series and now I am discovering the spatial side of my data. ...
1
vote
0answers
31 views

Automatically generating raster maps (from OSM) for areas bounded by polygons?

In order to create walking lists for a volunteer campaign I have used qgis to draw polygons over groups of addresses. These are irregular areas, so I've used postgis's ST_ENVELOPE function to ...
1
vote
0answers
24 views

Nearest neighbor POSTGIS in FME

So I have an attribute and I want to find the nearest neighbor but the issue is that the memory of the server may not be able to handle the use of all the FME transformers. I need to take records out ...
1
vote
0answers
41 views

POST (OL3-->Geoserver 2.8.1-->PostGIS 2.2)

I have a problem with post. Here is code OL3. (multi platform hybrid app - cordova) var point = new ol.geom.Point([18.25, 49.83]); var feature = new ol.Feature({ geometry: point }); ...
1
vote
0answers
18 views

Creating a contiguous raster stack from different sources (vectors and DTM bands)

This is a conceptual question I've been trying to implement for a while, and not being very good at raster/data processing or python I'd like to hear best practices in dealing with an extent such as ...
1
vote
0answers
29 views

How to translate QgsMapCanvas coordinates to wgs-84?

My application uses QgsMapCanvas. I've got point coordinates in wgs-84 crs and i need to add this point to vector layer (represents postgis table) inside of the canvas. Have no idea how to ...
1
vote
0answers
40 views

Updating an Openstreetmap PostgreSQL database after the system restore

My Openstreetmap PostgreSQL database takes a long time – about 25 hours by now – for updating via Osmosis after I had made a system restore at the last weekend. Before making the system restore it ...
1
vote
0answers
34 views

How do I translate gps sports data into a representative plane

I'm hoping to use qgis and postgis for a project but I'm unsure of, how to not only frame the question but accomplish the task. If I have gps data from 1 runner on an oval track but who has run on ...
1
vote
0answers
32 views

Find census block for street intersection with tiger geocoder

I'm geocoding lots of addresses and map them to census block. Some of addresses are street intersections, like this select ST_X((geo).geomout)::numeric(8,6), ST_Y((geo).geomout)::numeric(8,6) ...
1
vote
0answers
50 views

How to draw a raster over the World using Postgis

Im currently working on a system to track user interaction on mapwidgets. Now i need to visualize the bounds that users are looking at on the map. Since were using a whole lot of data i need to find a ...
1
vote
0answers
37 views

Creating look up tables in QGIS that last more than one session?

It seems that when I create a Look up Table or Value Map for a shapefile or a PostgreSQL table in QGIS it saves it for one session, then when I open it again it had disappears. Can someone ...
1
vote
0answers
25 views

pgr_nodeNetwork doesn't place new nodes properly

I wanted to use pgr_nodeNetwork tool to split lines where there's no vertex on intersection. The tool doesn't seem to work as expected, though. It doesn't place new nodes right where the two lines ...
1
vote
0answers
46 views

Unable to load raster from PostGIS into QGIS

I'm trying to load raster from a postGIS connection into QGIS, but I'm getting the following error: PG: dbname=EnvModel host=127.0.0.1 user=postgres port=5432 mode=2 schema=public column=rast ...
1
vote
0answers
45 views

refine nearest_node with radius-distance ( ST_Distance, ST_DWithin )

i am a hobby-IT-person and currently stuck with some simple problem, maybe somebody can help me: This is my working POSTGIS-function, source by underdark: ALTER TABLE distance_graz ADD COLUMN ...
1
vote
0answers
61 views

clip raster with polygon in postgis

I am newbie in postgis. I have a raster landsat images in table "ras" and a polygon shapefile image in table "shp". Now I want to clip raster with polygon using postgis, but I have a problem The ...
1
vote
0answers
26 views

PCA on correlation matrix in PostgreSQL

Does anyone know how to perform PCA using PL/pgSQL in a PostgreSQL function, considering correlation matrixes of potentially high order? Maybe a specific library for this problem... Thanks.
1
vote
0answers
45 views

How to get azimuth and altitude from a 3D surface in PostGIS?

I would like to know the azimuth and tilt of a polygon / surface in a PostGIS database. The azimuth should be given e.g. from 0° to 360° degrees. The altitude should be between 0° to 90°. An example ...
1
vote
0answers
49 views

raster2pgsql stops at line 53 at RETURN

I am importing some very large rasters (in the tif format) into Postgres SQL (9.3) using raster2pgsql on the command line. Most of the rasters imported fine, some had to be converted to the img format ...
1
vote
0answers
61 views

SRID of geoemtry exported in PostgreSQL with ogr2ogr

I use ogr2ogr to export geometric data from EDIGEO files to some PostgreSQL table in append mode, but the output geometry SRID is always set to zero. Can I do something to specify the output geometry ...