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

learn more… | top users | synonyms

0
votes
0answers
3 views

Create point on a line with given distance from end in PostGIS

Does anyone know how to create points along a line (MultiLineString geometry) with a given distance in PostGIS? I'd like to create points at a regular distance over a line, which represents a ...
0
votes
0answers
7 views

Method to translate PgRouting to ESRI Network Analyst network dataset?

I have a network dataset in a PostGIS database that is set up and routable via PgRouting. I would like to take this dataset and import it into Network Analyst in ArcMap in order to make some ...
1
vote
0answers
10 views

Server-side map generation from postGIS database

I have loaded some OSM data into a postGIS database, using imposm. Now using this data base, I computed a value associated to every point of the map (could be anything, real-estate average price or ...
1
vote
0answers
16 views

OS Terrain 50 into Postgresql/PostGIS for lat/long analysis

I am performing analysis using line of sight's and followed a very useful blog post at http://davidrowley.blogspot.co.uk/2013/08/calculating-line-of-sight-with-postgis.html which detailed how to load ...
1
vote
1answer
14 views

Error when creating new view using ST_Union (PostGIS)

I have a table in PostGIS (2.1.7) containing adjacent multipolygons, and I'd like to create a view containing polygons which are merged versions of the multipolygons based on some field value. I ...
0
votes
2answers
51 views

Why the execution of a query is very slow using PostGis?

I'm applying this Query to 8257800 point but it's taking 15 hours and it didn't return a results. SELECT a.gid , b.gid, st_distance(a.geom,b.geom) FROM shp1 a, shp2 b where ...
0
votes
0answers
12 views

Cannot draw geometery on WorldWind

I'm trying to draw my geometery on worldwind but it keeps saying WARNING: Unspecified coordinate system and draws a default blue line in the middle of nowhere. The procedure is that I populate ...
0
votes
1answer
21 views

how to insert area of polygon into a column named area in a polygon map in cartodb?

SELECT ST_Area(the_geom) FROM cartodb_query gives the area but trying to insert it into an area column using: UPDATE cartodb_query SET area = ST_Area(the_geom) doesn't work.
0
votes
1answer
25 views

where to download gdal_polygonize.py?

I am trying to help out a friend of mine. She learnt GIS in school in the past using ArcGIS but has recently installed QGIS package on her Mac OSX. When she tries to render raster into shape file, ...
0
votes
0answers
18 views

Need to find polygon info from postgis

After importing shapefile into postgis I got geom data as MultiPoligon Like: ...
1
vote
1answer
21 views

Postgis 4D Range Query

Is it possible to express a 4D range query in Postgis? I would like to know what 4d points lie within a hypercube. This is my table: CREATE TABLE myTable ( point geometry, attrib ...
0
votes
1answer
29 views

Create blank table from unix shell

I am in the middle of trying to create my first PostGiS database and seem to be running into problems developing scripts to automate importing the various spatial formats so I can use them in my ...
2
votes
0answers
44 views

Can I identify if a point is inside a volume in PostGIS?

We are currently investigating PostGIS as an option to look up three-dimensional blocks which contain a point (and later also lines). At this point in time I cannot see any functionality that operates ...
1
vote
1answer
28 views

In PostGIS, why does ST_Covers return f on this query?

In general this query functions fine. In my PHP application I tested it with a large number of points, and they all seemed to be true or false as appropriate (when I pasted data into two online WKT ...
6
votes
1answer
113 views

PostGIS polygon edge analysis (orientation, edge length)

I am rather new to the world of GIS and especially PostGIS, so please excuse me if the answer seems evident... I would like to do analysis on a number of buildings. One thing I am interested in is ...
1
vote
1answer
19 views

Fail to display correctly newly inserted data in PostGIS on Geoserver

I have created a postGis store in Geoserver. I have created layers with points and lines and I display them on an OpenLayers based application. I also use an FME workflow to insert new data to my ...
0
votes
0answers
15 views

Getting connected points in intersection from OpenStreetMap using PostGIS?

I'm trying to get the points that connected with the intersections. suppose that I know the point of the intersection (if we see in the pictures, I represent the intersections as black node). Now ...
0
votes
1answer
17 views

Query table names

I want to query a table in my postgis table named Seg_060_2009 using psycopg2 and cant seem to get my query to execute. The query will execute if I name the talbe layer. Are there restrictions on ...
0
votes
1answer
20 views

Loop through table, look for word in text field, set boolean true if word exists

I want to create a function that loops through a table and checks if a specific word exists in a text field. If it does, the function should set a Boolean field true. This is what I've come up with. I ...
0
votes
0answers
32 views

Splitting lines table using point table in PostGIS

My problem is that I want to get the shortest route between multiple point pairs which are stored in a table (PostGIS). In PostGIS I also have a network created using pgr_createTopology on a table ...
0
votes
1answer
28 views

Spatial join points and polygons in PostGIS

I have two spatial data sets in PostGIS tables: polygon grid (table: grid_jakarta) points (table:tweets) For each point in 'tweets', I want to retrieve the reelvant attribute 'gridID' from the ...
0
votes
1answer
17 views

Creating network for pgRouting from set of multiline strings?

I have a table which is a set of multiline strings. I wish to create a pgrouting topology from that table so I can do shortest-path problems. I have tried pgr_createTopology but it failed. Is ...
0
votes
1answer
32 views

How to create a polygon from the union of the areas formed by a circle running in a line formed by two geographic points?

How can I create a polygon like in the right side of the picture from a line formed by two geographic points like in the left side of the picture in PostGIS? I was thinking in calculating the area ...
0
votes
1answer
46 views

Database queries using GeoServer? [closed]

I am new to GeoServer. I have a PostGIS database and GeoServer setup. How can I query the database using the GeoServer/ Boundless SDK? I have OpenGeo Suite 4.6 and I am trying to query the database ...
0
votes
0answers
31 views

Merging linestrings in QGIS using PostgreSQL and PostGIS

I've to merge all linestrings from a PostgreSQL table "river" where not more than two start/-endpoints are overlapping. In the illustration below I use a "M" to mark all linestrings that needs to be ...
0
votes
0answers
22 views

Can't create ArcGIS feature class with PG_GEOMETRY keyword

I have enabled a PostgreSQL database as an enterprise geodatabase with ArcCatalog 10.3 (using server license file etc). When I create a new feature class with PG_GEOMETRY keyword, I get an error: ...
2
votes
2answers
43 views

How can I check if all boundaries of a polygon coincides with one or more of a set of lines

I have a polygon shapefile, and theoretically, all features in the shape are bounded by the union of some lines in another shapefile. Is there any way to confirm if this is true? I'm using QGis, FME ...
2
votes
1answer
58 views

How to efficiently use a Postgres DB with Python

I have a Postgres DB with a lot of lines that are too long and so now I want to split those lines into smaller ones. This is why I started writing a little python script for that job. Basically it ...
0
votes
1answer
22 views

GeoServer namespace URI causing invalid WFS transaction requests

Is there any naming conventions with GeoServer's namespace URI/settings that need to be changed to allow their proper use? I have a WFS-T that is being edited in QGIS - after a lot of issues getting ...
0
votes
1answer
45 views

How to set up wfs-t service in Geoserver using openlayers from postgis data?

I published my postgis data layers into Geoserver. I have enabled wfs in the edit workspace > services. Still the "layer preview" does not show any options under wfs. See the image. How can we set up ...
0
votes
0answers
12 views

pgRouting pgr_trsp returns no route

Installed a fresh PostgreSQL v9.4.1 x64 on Windows, and used the Application Stack Builder to install PostGIS 2.1 bundle which includes pgRouting 2.0. I created the sample data ...
0
votes
1answer
14 views

Can OpenGeo Suite co-exist with Homebrew-installed PostGIS/PostgreSQL in Yosemite?

I installed PostgreSQL (9.4.1) and PostGIS (2.1.7) using Homebrew in Yosemite (10.10.3). I'm just starting my way through "PostGIS In Action." I've been starting and stopping the server in Terminal ...
1
vote
0answers
26 views

Export only one value from a one-band raster

I have a PostGIS database with a georeferenced raster, with one band which contains values from 0 to 255. I should export it to a transparent GeoTiff picture in which the only visible pixels are those ...
0
votes
0answers
31 views

Determining intersection between list of points and list of linestrings?

I'm coding in php. I have a list of point coordinates (very large one) and a list of linestring geometries (large too). I'd like to determine for each linestring, the point coordinates that ...
0
votes
2answers
39 views

Count number of points within certain ranges from a set of points

I have the following, which gives me the number of customers within 10000 meters of any store location: SELECT COUNT(*) as customer_count FROM customer_table c WHERE EXISTS( SELECT 1 FROM ...
2
votes
1answer
73 views

Find number of points within certain radius of a set of points

I have two tables. One is a list of stores (with lat/long). The other is a list of customer addresses (with lat/long). What I want is a query that will return the number of customers within a certain ...
0
votes
0answers
24 views

Failed to insert all geometries from autocad into PostGIS with FME

I use FME 2014 for the insertion of an autocad to a postGis database. The autocad contains among others, lines and points. While I manage to load all points successfully, I fail to load all the ...
0
votes
0answers
33 views
+50

KNN combined with other clauses

I have a table with columns:- wkb_geometry (geometry), road_id character varying, year INTEGER The data set has multiples of road_id across many years. I want to get the nearest 10 values to a ...
2
votes
0answers
37 views

How do make ST_Split ready for QGIS?

In my recent QGIS project I need to split polygons (table/layer "pol") by both closed and non-closed linestrings (table/layer "lin"). I've tried the following SQL queries. CREATE VIEW split_pol AS ...
1
vote
0answers
8 views

PostGIS TIGER reverse_geocode() returns state only

I have a clean install of PostGIS 2.1 in Postgres 9.3 on Ubuntu, using apt-get and postgres extensions. Ran the data loading scripts from here. normalize_address works well, but geocode returns no ...
0
votes
1answer
43 views

Error with TileMill and OpenStreetMap Carto project

I have been trying to load the OpenStreetMap carto project in order to export tiles for use on our in house GIS Server. I have followed all the instructions up to loading the osm xml into postGIS and ...
1
vote
0answers
20 views

Export to shapefile error in QGIS from POSTGIS table

I am attempting to export a postGIS layer to a shapefile in QGIS 2.6.1 Brighton. The table has 244,674 rows. The data displays perfectly well in QGIS but when I attempt to export to shapefile I get ...
1
vote
1answer
42 views

Running spatial query on huge table [duplicate]

I've got two tables conatining geometry: 1 containing big polygon's (regions, srid=4326) and another containing smaller polygon's (pand, srid=28992, containg ~9.9milion rows) By using one of the big ...
-1
votes
0answers
23 views

geoserver 2.6.0 error in postgis database connection

I have been getting this error while connecting postgis database with geoserver version 2.6.0 "Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot ...
1
vote
0answers
35 views

How can I identify regions with some points as centers? [closed]

I have a Postgres database of entire U.S. zipcodes and their lat/long data. My requirement is to divide these zipcodes into non overlapping regions. All regions have some center zipcode. All ...
0
votes
0answers
13 views

Tilestache - Mismatch between the coordinates present in the PostgreSQL/PostGIS and those returned by PostGeoJSON provider

This is the relevant bit my Tilestache config, "points-of-interest": { "provider": { "class": "TileStache.Goodies.Providers.PostGeoJSON.Provider", "kwargs": { "dsn": ...
0
votes
0answers
26 views

How to update the OSM data in a PGRouting Database built with osm2pgrouting?

I'm using a PGRouting database originally built with osm2pgrouting from a *.osm file downloaded from Mapzen. If I want to update the OSM data in that database, ie. re-build my PGRouting Database, ...
0
votes
1answer
35 views

SQL query giving error in pgrouting?

SQL error: ERROR: function point(numeric) does not exist LINE 4: (ST_GeometryFromText(Point(53.34972 -6.26025)), 4326), 1000) ^ HINT: No function matches the ...
0
votes
0answers
9 views

Get addresses from TIGER geocoder in polygon

I have the TIGER geocoder installed, setup and working in POSTGIS. I also see the reverse geocoder lets me get an address from a point on the map. But now I want to provide a polygon and get all the ...
0
votes
0answers
17 views

How to share constraints between tables in a PostGIS database?

I have a PostGIS (v2.1) database that contains several tables, each representing a raster that I loaded by calling raster2pgsql. I'd like to ensure that the rasters contained by these tables have the ...