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

learn more… | top users | synonyms

2
votes
1answer
100 views

Can QGIS save layer direct to PostGIS?

I see that there is no option in the layer->save as menu for saving to a postgis database. There are for both SpatiaLite and SQLite. I am guessing that the interface to PostGIS is significantly more ...
13
votes
10answers
12k views

Open Source equivalent to Collector for ArcGIS to use with QGIS/PostGIS?

From my reading of the Esri web pages the Collector for ArcGIS is tightly tied to that platform. I would be delighted to learn that I am wrong about this. I have a strong interest in generic mobile ...
1
vote
2answers
678 views

Problem Importing shapefile into postgresql with simple geometries

I have a Line Type shapefiles to be imported to postgis database on my postgresql, I'm using the SHP loader, I checked the "Generate simple geometries instead of MULTI Geometries" options so that the ...
0
votes
1answer
205 views

pg_escape_string() equivalent?

A client is hosting one of my maps on a server that does NOT have a postgres module installed, and will not install it (nor anything else... ) . We have been told also by the site owner that we can't ...
2
votes
1answer
447 views

ST_Intersects incorrectly returning false in PostGIS

I have a shapefile created from ArcMap that contains about 400 geometry's. I've added this shapefile into PostGIS using the shp2pgsql tool. I am trying to use the ST_Intersects function to determine ...
1
vote
0answers
58 views

Create a single line from a resultset of line segments

How can I create a single line using the line segments geometry found in each row in resultset? I followed this tutorial: http://anitagraser.com/2013/07/06/pgrouting-2-0-for-windows-quick-guide/ I ...
5
votes
3answers
6k views

What's the fastest way to do a bounding box query in PostGIS

I have a Postgres table, with almost 2 million rows, with a long-lat coordinates field in the form POINT(-73.4938 33.2405). Supposing there's a geospatial index on that field, what's the most ...
2
votes
1answer
175 views

How to change table name of command raster2pgsql

I am completely newbie with GIS and PostGIS as well I'm trying to load raster into postgreSQL with raster2pgsql. It runs well. However, the table name of the raster is generated automatically. For ...
6
votes
0answers
871 views

How to use the linear referencing plugin from QGIS with postGIS data?

I need a guide how to use this plugin properly, I'm a newbie on PostGIS and I'm trying to use the linear referencing plugin of QGIS. I've created a database on postgreSQL with the postGIS extension ...
0
votes
0answers
284 views

Mapscript. Converting pixel coordinate to latitude longitude for postgis

I have a map created with mapscript. It is a 2D (PNG format) that's being shown on a web browser. I want to get the lat/long coordinates whenever the user click on the image, and then save it in my ...
0
votes
0answers
38 views

Linking Google Sheets with PostGIS

I am curious if there is a way to link a PostGIS table with a Google Sheets? Both tables (Post and Google) have a unique ID that can be used as a linkage. I am hoping to be able to build a view that ...
1
vote
1answer
211 views

Creating a new time column in PostGIS / CartoDB

I received a CSV file that has year (just two digits, '70'), month (as 'JAN'), day and time (as '0310') as separate columns. Bringing in to CartoDB / PostGIS they all appear as strings. I'd like to ...
3
votes
1answer
921 views

Access Shapefiles from PostgreSQL/Postgis in R

I successfully setup a connection to my PostgreSQL/PostGIS database on Ubuntu Server from my Laptop (Ubuntu 12.04). Therefore I installed RODBC in R to setup a connection and I made a correct entry ...
1
vote
3answers
1k views

Cannot st_linemerge a multilinestring because its not properly ordered

i have a MultiLineString which i created by using st_union in many steps. Each of them are connected to each other according to their points, but the order is not correct. So ST_LineMerge is not able ...
5
votes
1answer
4k views

How to Import ESRI Geodatabase format .gdb into PostGIS

I ran into a problem when loading a ESRI Geodatabase format .gdb into PostGIS. I have data 2.5GB GDB file. I followed some tutorials on the internet, but it seems that doesn't work out. I created a ...
9
votes
2answers
4k views

Import large CSV file into PostGIS

I am trying to import CSV files into PostGIS. Following this post, I have created tables before. I found other suggestions saying that I can run the copy command. If I run this command: COPY table ...
2
votes
0answers
373 views

Publish existing table from postgis to geoserver

I would like to know if there is any way for publishing existing table from postgis to geoserver using Geoserver REST API or geoserver-manager java implementation. The thing is that i'm actually ...
0
votes
2answers
447 views

How could I insert a 3-D LineString into postgis table?

Using: CREATE TABLE trajectories( gid SERIAL PRIMARY KEY, vehID VARCHAR(10), state INTEGER, geom geometry(MULTILINESTRING) ) I get an error, for instance, after inserting: INSERT INTO ...
0
votes
1answer
150 views

Can rgdal use an external GDAL installation?

The README for rgdal contains the following text: file.show(system.file("README", package="rgdal")) For additional drivers, users of the CRAN Windows and CRAN OSX binaries can either convert ...
2
votes
1answer
5k views

Trouble with INSERT in PostgreSQL 9.1

I am trying to execute the following: INSERT INTO lithic (cp_east, cp_north, type, material, art_count, comment, field_no, gps_unit, initials, rec_date, cortex, geom) SELECT (cp_east, cp_north, ...
0
votes
1answer
336 views

ST_Dump not working with geometry_dump

I am trying to ST_Dump a geometry_dump column comprised of points and paths in PostGIS 2.0 using SELECT (ST_Dump(geom)).geom FROM pointdump However, I get the error message 'function ...
2
votes
1answer
235 views

Creating a postgis database a GML application schema

Is there any open Source tool(automated or semi-automated) that converts GML application schema to a POSTGIS database/table .Specifically I have a huge application schema containing many ...
2
votes
2answers
184 views

shp2pgsql mangles date field — quotes data as if it were char or varchar

I'm attempting to import a shapefile into postgis via shp2pgsql. Among the fields in the shapefile's .dbf file is a date field with format yyyymmdd, which is a valid date format for postgresql. ...
2
votes
1answer
300 views

Delete duplicate spatial point/points in mssql from a perticular location

I am working with a Spatial data which has a street intersection points.... I get the intersection points from spatial query on street/roads datain MMSQL . but in my case some streets/roads are multi ...
0
votes
2answers
76 views

Select area which is at least x meters away from other geometries

In my table I have the build-up area from a region as a big number of polygons. urban_area: id | name | geometry(polygon) I was wondering if and how I would be able to find the area within a ...
1
vote
1answer
200 views

Why ST_SRID cause Geoserver generated SQL query to run about 500x slower?

When investigating why Geoserver was so slow to render my WMS tiles from a POSTGIS database I found that the following Geoserver generated SQL query run almost 500x faster when remplacing the ...
2
votes
1answer
258 views

PostGIS ST_Contains query returns null

I have a shapefile of all US States that I've imported into a table with a multipolygon geometry column. (SRID 4326) I perform a spatial query based on lat/lon to return the state abbreviation. This ...
0
votes
3answers
896 views

Install PostGIS 2.0.3 on PostgreSQL x64 9.1 on Windows Server 2008 R2

I just try to install the PostGIS 2.0.3 on PostgreSQL x64 9.1 on the Windows Server 2008 R2. I got the error message "Error openning file for writing" C:\Program ...
2
votes
1answer
312 views

Why is ArcMap leaving connections “<IDLE> in transaction”?

The TL;DR version: When you use ArcMap Query Layers to access a PostgreSQL table, ArcMap's database connections are almost always sitting idle in unclosed transactions. Why would this be? I have ...
0
votes
1answer
161 views

Convert an area to meters² in PostGIS

I have this query : SELECT ST_AREA(geom::geography) FROM region The (geom) contains polygons from a shapefile imported into PostGIS with shp2pgsql. I've appended ::geography, else the result of ...
0
votes
1answer
619 views

error of data conversion value getting while importing shapefile in shp2pgsql-gui on ubuntu

Connecting: host=localhost port=5432 user=postgres dbname=tremblement_de_terre Connection succeeded. Connecting: host=localhost port=5432 user=postgres dbname=tremblement_de_terre ...
1
vote
0answers
275 views

Find area with highest relative density of one type of object

I'm using PostgreSQL/PostGIS and I have an advanced type of query. My database contains two types of object - let's say pubs and churches :) Is there a way that I can find the area with the densest ...
0
votes
1answer
82 views

Issues with pgrouting workshop code in postgis 2.11/pgrouting 2.0

I'm having issues getting the pgrouting workshop to work on Postgresql 9.2/PostGIS 2.11 and pgrouting 2.0 on windows. How can I rewrite the following php/sql code and make it compatible with my ...
8
votes
2answers
3k views

Install PostGIS and TIGER Data in Ubuntu 12.04

Could someone write a brief albeit dumbed down idiot's guide to installing postgis and loading national Tiger data on ubuntu? I've tried a few guides, namely, ...
0
votes
2answers
370 views

Intersect and MBR in POSTGIS and Mysql

I would like to know if POSTGIS and MySql with Spatial Extension use true geometry to find intersections/overlaps between geospatial objects. But i don't find it precisely in the documentation. I know ...
1
vote
0answers
564 views

postgresql 8.4 and postgis 1.5 error: type modifier is not allowed for type 'geometry'

I would like to generate a buffer (within a limit of 3km ) where the user clicked point. In pgAdmin, select my database and open a query editor and create 2 PostGIS functions (UTM Zone Function and ...
0
votes
1answer
96 views

Simplify table of linestrings

I have a PostGIS table of linestrings representing a road network. I want to simplify the geometries such that only lines that connect road junctions are stored. At the moment the table has a large ...
0
votes
0answers
228 views

Using Terraformer to convert to WKT

I'm using Terraformer to parse some ArcGIS JSON into a Terraformer primitive. I'd like to store the geometry in PostGIS for other purposes. So I'm trying to use the WKT.convert tool to convert this ...
0
votes
1answer
316 views

How to automatically convert line features into polygons using QGIS/PostGIS?

I have a master table of line features and a number of tables that I use to join (in the SQL sense) to produce various layers. Some of theses layers consist of boundaries of administrative zones ...
1
vote
0answers
122 views

Need to enhance a function for creating quadrants within polygons

I wrote a function that creates arbitrary quadrants within a polygon SELECT (quadrant(20,0.0,90)).* The first parameter is the polygon ID, the second one is the start angle and with the third one ...
1
vote
1answer
108 views

Get DISTINCT nearest neighbors with indexed search

I'm using the indexed nearest neighbor search to return the closest points to a given starting location. My points also have attributes like color and shape, stored as strings. I want each query to ...
2
votes
0answers
180 views

Trajectory Indexing: How could I store and index the large trajectory dataset generated by cars' GPS?

I have a large trajectory dataset generated by cars' GPS. Since I will do some data mining work on them, I need an efficient way to store and index them. I read some papers about Trajectory Indexing ...
1
vote
0answers
999 views

Creating a spatial database using EXTENSIONS: error loading legacy.sql

I am using Postgres 9.3 and PostGIS 2.1, installed in a Docker container via RUN echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" >> /etc/apt/sources.list RUN apt-get -y ...
0
votes
2answers
519 views

Building CartoDB from source using updated dependencies on Ubuntu 13.10

I am attempting to build CartoDB from source on an Amazon VM for the first time in my life. For purposes of sanity, I want to use the same instance/database of postgres for both CartoDB and all of my ...
2
votes
1answer
457 views

creating a st_contains query with geographies not geometries

I'm trying to find all the geography points that are contained in a geography polygon, let say all the traffic lights within a given city or neighborhoods, how can i convert this working st_intersect ...
1
vote
1answer
709 views

Error while installing PostGIS on ubuntu 12.04

This is my first practice on Ubuntu machine. Here i am trying to install PostGIS 2.1 on postgresql server 9.3.2. When i am following the procedure mentioned here Help I am getting the following ...
2
votes
1answer
395 views

Geoserver configuration for large layers

I'm having problem with geoserver configuration. Currently I'm running geoserver 2.4 on CentOS and Tomcat 6 with 24 cores CPU and 48 GB RAM. I have uploaded 4 layers to PostGIS (PostgreSQL 9.3/PostGIS ...
1
vote
3answers
194 views

How to find area/multipolygon bounded by three other multipolygons?

Trying to get my head around PostGIS and QGIS...I'm trying to find the area (in white) bounded by three multipolygons (in purple) - refer to picture. Each multipolygon only touches the other two ...
1
vote
1answer
869 views

Can anyone explain me the TSP pgRouting function?

I have no problems using Dijkstra or A* functions, but when I try to run TSP, I really don't know where to start. What I'm, trying is to get the 'best route' to link four points (typical TSP ...
0
votes
0answers
198 views

issue with QGIS Scale Level

I have different layers of shape files. I have imported all shape files into PostGIS. Now i want to show 3 layers Country, State & District with different scale/zoom level I tried to set scale ...