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

learn more… | top users | synonyms

0
votes
0answers
22 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
37 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
65 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
22 views

Need to find polygon info from postgis

After importing shapefile into postgis I got geom data as MultiPoligon Like: ...
1
vote
1answer
43 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
49 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 ...
5
votes
1answer
87 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
37 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
171 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
24 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
28 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
41 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
36 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
53 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
48 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
44 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
67 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
109 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
37 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
54 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
98 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
54 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
104 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
22 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
29 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
35 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
51 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 ...
4
votes
1answer
130 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 ...
9
votes
2answers
201 views

How to ST_Split features in one table by features in another?

I need to split polygons (layer 'pol') by both closed and non-closed linestrings (layer 'lin'). Unfortunately I don't get proper results running the following query. CREATE VIEW splitted_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
80 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
57 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
56 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
44 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
24 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
1answer
61 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
41 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
27 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
24 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
27 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
1answer
55 views

Understanding the format: WKB from WKT and how to convert the first into the latter

I don't understand which kind of format I have my data. The column name is wkb_geom, so I supposed that data were in WKB format, but then I was checking around and I couldn't find example of it. Data ...
0
votes
0answers
45 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
51 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
55 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
61 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
167 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 : ...