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

learn more… | top users | synonyms

0
votes
1answer
32 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
33 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
48 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
44 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
22 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
41 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
63 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 ...
2
votes
2answers
91 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
34 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
52 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
92 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
44 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
82 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
19 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
24 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
28 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
34 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
50 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
104 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
53 views

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
44 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
12 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
63 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
39 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
55 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
vote
0answers
41 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
19 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": ...
1
vote
0answers
51 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
39 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
19 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
22 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 ...
0
votes
0answers
23 views

GDAL Python and postgis raster?

I'd like to create a postgis raster using GDAL and python. I can get the driver easily: drv = gdal.GetDriverByName("PostGISRaster") But how can I create a new raster table? I can't find any ...
0
votes
0answers
43 views

Raising height of a certain part of choropleth

I have a working choropleth map which shows number of patients in a certain coloured area. I want to raise the height of the specific area according to the patient count. The variable height is equal ...
1
vote
0answers
48 views

Loaded OSM Data into PostGIS Database. Cannot view in ArcMap “The coordinate system identifier is invalid”

I loaded OSM File for Pennsylvania into a PostGIS Database in PostgreSQL using osm2pgsql. Everything seemed to go without a hitch until I finally connected to the Database in arcCatalog and tried to ...
1
vote
1answer
48 views

How to concatenate values from postgis table which have the same id into a new column? [closed]

I have the following table in postgres-9.3 postgis 2.1. (geom values is too long , I cut to make it short in below table): id | name | geom ------------------------- 12 | A | "01030000000" 12 | ...
0
votes
0answers
10 views

postgis update query equivalent for shapefile geowithin update using QGIS [duplicate]

Using QGIS I can use the field calculator to update one point layer based on the point falling within another layer's polygon using geomwithin('water','water_id'). What is an equivalent update query ...
0
votes
1answer
51 views

Creating geometry from lat/lon in table using PostGIS?

I have a table with over 800,000 records including a lat and long column. The data source did not create geometries, so I was looking around how to do this. I know there's ST_MakePoint(x,y,SRID) but ...
2
votes
3answers
147 views

How to get India OSM map offline in geoserver which looks similar to online OSM map?

I need to OSM map of India having same look and feel as of Online OSM map. I have done following steps for the same : I have downloaded India map OSM data from below link : ...
3
votes
2answers
126 views

Creating polygons from line segments using PostgreSQL and PostGIS

Is there a PostGIS function that creates polygons from multiple line segments? I want to convert the pictured thirteen lines to four polygons. All lines belong to the table "boundary" (gid, geom). ...
1
vote
0answers
23 views

How to fix broken geometry after joining features in PostGIS

I have a PostGIS layer I'm serving over GeoServer. It looks like this. Im using the PostGIS query to get a new layer with some grouped features: SELECT id, name, st_union(st_buffer(geom, ...
1
vote
1answer
109 views

PyQGIS - load PostGIS layer as editable

I can load a PostGIS layer on QGIS' map canvas but "Toggle Editing" button comes "inactive". How can I load vector layer as editable? The code given below loads PostGIS layer on map canvas & ...
0
votes
0answers
44 views

Perfom SQL queries in Python and process the result

I query column names from a PostGIS table with following Python code: colnames = [] sql_getcolumns = "select column_name from information_schema.columns where table_name='shp2py';" ...
2
votes
1answer
46 views

How to know if two geometric figures are approximately equal?

I would like to know how to determine if two geometric figures (the_geom) are approximately equals. By the way, I'm working with Python, PostgreSQL and Postgis I have the following geometries: ...
1
vote
1answer
46 views

How to view a postgis raster query in QGIS

I have successfully loaded a large number of .asc images (>2800 200x200 tiles) into a Postgres table with PostGIS 2.1 support. The new table appears in QGIS's DB Manager and I can add the whole image ...
3
votes
1answer
60 views

ogr2ogr postgres import: check if dataset exists

I have a PostGIS database which I update daily with ogr2ogr using CSV files. This works great. Is there a way to check whether the actual value of a column already exists in the table (e.g. ...
1
vote
1answer
22 views

Why prj2epsg cannot resolve PostGIS SRText?

In many places I have seen people referring to http://prj2epsg.org (here, here). I have used this service too, however, the service cannot uniquely identify an EPSG code alway. I understand that it ...
0
votes
0answers
23 views

Branching factor in River system?

I would like to find the branching factor for a river system. I have tried dissolving it then trying to find the branching factor but I'm not to sure how. So I have it from west to east like it ...
1
vote
1answer
44 views

Creating geodjango model with geometry field that can accept different projections

I am working on web application with GeoDjango and within the model (db table) RoadAxis I have geometry field or more precisely LineStringField where I need to store different polylines (road axis) ...
0
votes
1answer
44 views

How to join a WFS layer to a table in OpenLayers

So I have to bring up this old question How to join a WFS layer to a stand-alone table in OpenLayers I recently have to get this working, I have to join a WFS layer data from GeoServer using postgis ...
0
votes
1answer
44 views

Insert rows into CartoDB from code

I have a simple web page where i show my cartoDB map and a dataset. I want to know if there is any way to insert new rows into my cartoDB dataset from code, so external users can add points to the map ...