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

learn more… | top users | synonyms

1
vote
1answer
63 views

PostgreSQL/PostGIS: create spatial view

I have a polygon layer and a point layer. 1) I wrote a spatial query to count how many points fall in each polygon: SELECT polR.codeR, count(pntAZ.geom) as tot_pntAZ FROM boundaryR as polR LEFT ...
1
vote
0answers
20 views

Designing a database for Kinect cloud data [closed]

I'm developing a navegation system with a kinect, by this moment I can obtain a cloud points(X, Y, Z, RGB), the idea is to introduce the point cloud (X,Y,Z) into a database postgreSQL with postGIS ...
3
votes
1answer
69 views

Should I use a projection or not, and if so what SRID would be useful?

First off, I realize that this is perhaps not the most stackexchange-esque question. I am however having trouble finding a good source of information for this. So if there is a better place for me to ...
0
votes
1answer
32 views

Add GPX files to postgreSQL database and add one column with a given value

I already found out how to add a gpx track information into my postgres database: `ogr2ogr -append -f PostgreSQL "PG:dbname=your_db user=xxxx password=yyyy" filename.gpx` Everything works fine but ...
0
votes
1answer
43 views

Geometry to Shapefile

From importing the shapefile to postgis, its geometry is added to the database postgresql. The question, how can I load the shapefile in the Visual Basic.Net using the geometry in the database ?
0
votes
1answer
39 views

rubber sheet a polygon collection into another - postGIS

My question is this: How do I create a 4 x 4 grid over the orange grid like the pink(ish) one? The pink grid are geometries that have already been provided and are wonderful. I'm attempting to ...
0
votes
0answers
30 views

within using Hibernate Spatial

I'm doing this query using postgis and working properly SELECT "public".zona."id", "public".zona.zts FROM "public".zona WHERE ST_Within ( Geometry ( st_GeographyFromText ...
0
votes
2answers
50 views

Postgis: ST_Buffer breaks because of no forward edges

I try to buffer a huge road network using ST_Buffer. After 8h of processing I get an error message: ERROR: GEOSBuffer: TopologyException: No forward edges found in buffer subgraph Here is my query ...
0
votes
2answers
59 views

Common Web Server for Web Mapping?

I'm planning to create interactive routing map system( for small town only ) which will be running online. My server side language will be PHP and PostGIS/PostgreSQL with using pgRouting and client ...
1
vote
2answers
47 views

How to bring all “tourism:attraction” from points table and polygon table together?

Im using OSM data as osm2pgsql-import (from extract.bbbike.org). And I want to draw all attractions ("tourism" = 'attraction'). The most of the attractions I found in the planet_osm_point table. But ...
2
votes
1answer
41 views

Spike finder in PostGIS

I tried to modify spikeRemover from Schmidt & Krüger. My goal it's to obtain, for each polygon, the position of the spikes. I don't need to remove it. For some reason, that I can't figure out, my ...
0
votes
1answer
31 views

With osm2pgrouting, how to handle relations?

I'm trying to create a topology of the public transport in Paris. I use a OSM export, osm2pgrouting with the correspondent mapconfig.xml and Postgis. Everything works fine, except one thing. In ...
2
votes
1answer
29 views

OpenGeo/Geoserver: can I have a store that access more than one PostGIS schema?

I have an existing PostGIS database that I use with QGIS. I am now looking at options for getting some of this data up on the web. Hence OpenGeo. I have Geoserver installed and running and have ...
1
vote
1answer
23 views

How can I convert SRTEXT to PROJ4TEXT with QGIS

I have a SRTEXT like this: GEOGCS["My Data",DATUM["Not specified (..... I want to get PROJ4TEXT of this STREXT. Can I get it from QGIS. Because I want to insert it in Postgresql SPATIAL_REF_SYS ...
1
vote
1answer
64 views

Using ST_split to split a line feature using nearby points

I have a line shapefile and a point shapefile, and the line has just one segment and its attribute table, the point shapefile has points near the line above, not on it and the close ...
1
vote
2answers
70 views

Is it best to use multipolygon or polygon features for large intersect operations?

I have two large layers that I want to do intersect operations. One is municipalities and the other is landuse. Right now, the landuse layer is of MultiPolygon type that is, for the entire state, I ...
0
votes
3answers
61 views

ST_transform postgis

SQL within that zone is a point SELECT "public".zona.zts FROM "public".zona WHERE ST_Within ( ST_Transform ( ST_GeomFromText ( 'POINT(-30.033514 ...
0
votes
0answers
109 views

Postgres SSL SYSCALL error: EOF detected with python and psycopg

Using psycopg2 package with python 2.7 I keep getting the titled error: psycopg2.DatabaseError: SSL SYSCALL error: EOF detected It only occurs when I add a WHERE column LIKE ''%X%'' clause to my ...
0
votes
0answers
73 views

libgdal1 and libgdal1h conflict

I am on Ubuntu 14.04. When I am installing PostGIS-2.1, it's asking for libgdal1 library. But when I am installing libgdal1, it's removing grass and gdal. Can someone please guide me how to install ...
4
votes
1answer
96 views

Can I use a QGIS geometry in a Python PostGIS query?

I have a "Python Init function" for the attribute form in QGIS, which is called when I add a new geometry. I can access the geometry of the newly created feature like this geom = feature.geometry() ...
0
votes
0answers
25 views

Is there a Raster2pgsql GUI?

Has anyone ever attempted to create a raster2pgsql gui (like the shp2pgsql gui). As I am sometimes lazy to use command line, this could be a very nice to have.
0
votes
1answer
52 views

postgis finding lines that touch and update

I am not much of a postgis guy so please bear with me. I have a subset of lines representing exits and roads around those exists. Main roads and exists can be distinguished by their class attribute ...
1
vote
1answer
24 views

shp2pgsql data appent without gid

I have a shape file, I opened it in QGIS that has columns in attribute table named CITY_NAME, POPULATION and I have a database table in Posqgresql that has columns named gid (primary key), ...
0
votes
2answers
85 views

How to add polygon height in QGIS or PostGIS?

Is there an easy way to set the height of polygons in QGIS or PostGIS? I am trying to visualize polygons by turning them into volumes (same shape at the base and roof, but with walls). I would then ...
1
vote
0answers
13 views

QGIS DBmanager import file append not working [duplicate]

I am using QGIS and connecting to Postgresql database. I want to import shapefile data into database table via DBmanager tool. But Append data to table selection is inactive like following image. I ...
2
votes
2answers
71 views

Able to plot on map but having trouble with st_contains

I am new to working with GIS, and am building a rails app that uses the rgeo gem and PostGIS. I am trying to use geospatial data to determine the school district for a house. The house is represented ...
0
votes
1answer
35 views

Extract address data / Query point in administrative boundary

I try to create a DB in postgreSQL with all the postal adress data for a specific country. Actually I have this table full of data: id integer NOT NULL DEFAULT nextval('plz_id_seq'::regclass), ...
0
votes
0answers
24 views

Mapping application basic for ruby on rails

I am new to build map application using ruby on rails, with rails 4.1.1. I want to create map using map tiles. i have to use PostgreSQL database with postgis. Can you please explain how this flow ...
0
votes
2answers
59 views

Coordinate System Google Maps API

I am making an application in java using GMaps4JSF where the person will enter the address on the map I'll take this coordinate and consult on my postgis base regions in which region this point is ...
2
votes
1answer
120 views

CartoDB “Error loading rows, check your SQL query” & “There is a pb with your connection”

I have been trying to install my own CartoDB server for a few weeks. I succeeded to install each part with no error (after few corrections) with this tutorial. Make check with CartoDB-SQL-API and ...
1
vote
2answers
66 views

Find all points in a linestring that are contained by a polygon

I'm fairly new to PostGIS, so I apologize if this has been answered before. I have a linestring made up of 4D points and I need to determine which points in this linestring fall within a specific ...
0
votes
0answers
40 views

PGSQL2SHP Commnad switch column type

I work with Postgis. I have table CREATE TABLE centerline ( gid serial NOT NULL, l_from integer, l_to integer, r_add_pre character varying(15), r_to integer ... } Export this table with ...
0
votes
2answers
38 views

Which function is most appropriate to select postgis geometries that have any part inside another?

I ST_Dwithin the function returns TRUE if the geometry A is completely inside B. I happen to have many polygons (representing regions) and need to know which streets are within each of these polygons. ...
1
vote
1answer
42 views

PostGIS views vs WFS Filtering operations on PostGIS table

In what use cases should I prefer writing PostGIS views for filtering datasets versus filtering with WFS filter encoding operators and vice versa? In both cases I would be serving the data via ...
1
vote
2answers
36 views

How to style ways with CartoCSS depending on a relation property (OSM)

I'm using CartoCSS together with an OSM Postgres DB (hstore on). I want to set the line color depending on the operator tag of relations (routes). How can I do that? Update Thanks to Paul Norman for ...
1
vote
0answers
78 views

qgis-2.2.0 database tab missing

I have recently installed QGIS-2.2.0 but the Database tab in the top-menu bar is missing. It looks the main reason is missing libgdal1h library. But when I am installing it, it's removing ...
0
votes
1answer
38 views

Missing hstore column in TileMill!

I made a PostgreSQL with PosGIS Extension DB with the pgsnapshot_schema and loaded an .osm.pbf-file with OSMOSIS into it. Now i connected it to TileMill, but if i look up into the table i just see ...
-3
votes
1answer
68 views

Is it possible to access geoserver wfs layer from localhost:8080 in to web application? [closed]

I want to add a WFS layer. I am trying to get WFS layer from localhost:8080 geoserver. but I am getting eoserver DateLineWrap in Openlayers.js file...
0
votes
1answer
31 views

I need to test a condition within the sql in postgis.

I need to test a condition within the sql in postgis. My sql: SELECT (zoneamento3_32722.zt3), logradouros32722."NMIDEABR", logradouros32722."OBJECTID", ...
0
votes
2answers
48 views

PostgreSQL/PostGIS - group by series of values

I need to sum up linear objects' length and to group them by intervals of several years. I have one table storing my objects like this : - gid serial NOT NULL, - year INTEGER, - the_geom ...
2
votes
1answer
55 views

Centroid of Points using postgis

In my postgres database i have a set of points(lat, long) and i created the_geom index for that. Now i have to find the centroid of these points. I Google a lot and i find that for closed ...
0
votes
0answers
19 views

PHP Query Tables of Active Layers

I currently have an "Identify Features" function on my site that works by passing a the Lon and Lat of the click, along with a list of active layers to a PHP script that will then query my PostGIS ...
0
votes
2answers
37 views

How to join data in postgis tables to form layer with subset of attributes

In QGIS I am trying to join data from two postgis tables. I can not figure out how to do this at sql because add layer tools seem to allow one to select just one table to filter on. Instead I ...
1
vote
1answer
87 views

QGIS/PostGIS: Select Counties within Region via Spatial Query

I'm using GQIS 2.2 and PostGIS on Postgresql 9.3. I have 5 regions in the contiguous United States. Each region has states, and each state has counties. I would like to think that the data I'm given ...
0
votes
1answer
64 views

osm2po is missing edges while importing to pgrouting

I am using osm2po for importing pbf file to postgresql but when i find route using built-in algorithms i found that some of the edges are missing so route does not match with road. Did anybody know ...
0
votes
1answer
43 views

Searching closest region from Google Maps coordinates

Here is my problem. I'm mapping a region in google maps after that I'm saving the coordinates in PostGIS databse as geographic Polygon type. ST_GeographyFromText('SRID=4326;POLYGON((..))') The goal ...
0
votes
1answer
47 views

Drawing curved lines in CartoDB?

I am experimenting drawing curved line from Origin to Destination in Cartodb. I was able to do so once, however, failed the second and third time. Could anyone offer me some insights into the ...
0
votes
0answers
19 views

Installing PostGis / GeoServer in Mac OSX

On a Mac Server I am working to setup the ports. My understanding is that there is a system instance of PostgreSQL running and then a geoserver instance. Version is 10.7.5. I need help approaching ...
0
votes
0answers
66 views

Can't see Postgis layers added to QGIS

I'm trying to transition from an old Postgres/Postgis database to a new one. I'm working in a fresh install of Win 7 64 bit. I installed Postgresql 9.3 32 bit, then installed PostGIS 2.1.3. I created ...
0
votes
1answer
43 views

Calculating a vector raster intersection in postgis

I am using CartoDB and trying to calculate the total population (in raster format in popcount) within a specified distance to a line (vector data in mytable). The population data is at about 5km ...