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

learn more… | top users | synonyms

1
vote
0answers
15 views

Free tutorials for beginners in PostgreSQL, PostGIS and SQL? [duplicate]

I've been cruising youtube videos and various sites trying to pick up information on working with postgresql, postgis, and sql. I would love a few recommendations for quality tutorials and sites. ...
0
votes
1answer
63 views

How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?

I'm experiencing sever performance issues on a polygon featureclass(PG_GEOMETRY) in a PostgreSQL 9.2 database from a 10.2.2 client. Even when zoomed to an area with 10-20 features within the extent. ...
2
votes
1answer
79 views

PostgreSQL default values in QGIS 2.8.1

I have a problem with default values the are set in a PostgreSQL table. When I work on them in QGIS 2.8.1 and I save the layer, the default values were not computed, so the constraints block me. With ...
1
vote
2answers
100 views

Determine which points are contained inside a given polygon

I have these database tables defined: CREATE TABLE regions ( id SERIAL PRIMARY KEY, name VARCHAR(150) NOT NULL ) CREATE TABLE region_points ( id SERIAL PRIMARY KEY, region_id SERIAL ...
0
votes
2answers
82 views

How can I generate batch of coordinates from linestring to simulate driving on map?

I have a openlayers map and I want to simulate driving a route on it. I would like to draw a line (using GPX tool) and create gps coordinates (preferred with advancing time stamp) so I can query them ...
1
vote
1answer
27 views

Convert 2D coordinates from NAD83 to WGS84 using Postgis

I have a set of NAD83 coordinates that I need to convert to WGS84 coordinates. I am using postgis on an RDS. Specs for the box I am using from postgis_full_version(): POSTGIS="2.1.3 r12547" ...
3
votes
1answer
64 views

How to order points along a line?

I have a bus line with bus stops along the route. The sample data looks like this: LINESTRING (-70.57243474999999933 -33.37452829000000065, -70.57308152999999606 -33.37470645999999874, ...
0
votes
0answers
25 views

Create table into PostgreSql from Geoserver SQL View query

I know how to connect Geoserver to PostgreSql and create SQL View queries with parameters from Geoserver, but ;it is possible to create a new table into PostgreSql from a Geoserver Sql View with ...
0
votes
0answers
22 views

Rendered tiles look stretched

I've setup a tile rendering system based on Mapnik + PostGIS. When I open the data with QGis directly from PostGIS it looks fine; but when I attempt to generate tiles with Mapnik they look stretched ...
2
votes
2answers
75 views

Add a serial id column inside a view

Is it possible to create a new id serial column inside a view? I need it to be able to add my view in postgis I have made a full outer join on two tables I need a unique PK to load the view in ...
0
votes
0answers
26 views

PostGIS extension on Debian not found: could not open extension control file

I'm trying to set up the PostGIS extensions on a Postgres 9.1 database on Debian Wheezy, but getting an error: =# create extension postgis; ERROR: could not open extension control file ...
3
votes
1answer
51 views

How to check if line goes through point with PostGIS

I have a line representing a bus line and a stop representing a bus stop The following sample data represents the problem LINESTRING(-70.65357957000000511 -33.42323483999999922, ...
0
votes
1answer
16 views

OpenLayers WFS-T tinyows insert transaction: error GID value

I try to implement insertion of new point using Openlayers v2.13 saveStrategy calling tinyows which implements the WFS-T transaction; I use the example from ...
2
votes
0answers
26 views

PostGIS: What is the difference between regular R-tree and R-tree on top of GiST?

I have built a spatial index structure that I am trying to compare with other existing spatial index structures. I have to either code (in Java) the same logic that PostGIS uses or find a java library ...
0
votes
0answers
20 views

SQL XYZ tile server for OpenLayers

I am looking for some guidance to build a SQL XYZ tile server. I have a good understanding SQL Server and some experience with PostGIS. I currently generate the XYZ tiles from large raster images and ...
1
vote
1answer
51 views

Importing shapefile into PostgreSQL/PostGIS?

enter image description hereI'm completely new to PostgreSQL and PostGIS. I finally got both installed and have the PostGIS extension installed. I'm running the PostGIS shapefile import manager. I ...
2
votes
1answer
40 views

How to reproject all geometries columns in a PostGIS schema

Is there's a way to reproject all geometries columns of a postgis schema given the same source SRID to the same destination SRID? Exemple : schema.table1 has 2 geometries columns geom and geom2 with ...
0
votes
1answer
33 views

How to dispay my PostgGIS geometry on the GeoDjango map widget?

I'm trying to display a custom map feature on a GeoDjango map. The geometry is a multipolygon stored in a PostGIS database backend. And I have trouble to find the correct piece of documentation that ...
0
votes
0answers
24 views

Postgis C/C++ API unpacking geometries

I would like to create a postgres extension that works with postgist types Polygon, Multipolyon, Linestring, Multilinestring based on postgres extension building infrastructure: ...
0
votes
0answers
22 views

Geoserver has trouble translating date time to right UTC timezone

Geoserver has a problem while translating date time. We have a column "effective_begin_time" defined as a "timestamp with timezone" in postgres. It was specified this way hoping that all date/time ...
0
votes
0answers
26 views

Installing postgis_viewer.py for pgAdmin III

I have difficulties installing pgAdmin's plugin postgis_viewer.py. The official repository on GitHub gives this Web site for install procedure, then the former site gives this Web site for installing ...
0
votes
0answers
22 views

Displaying postgis data in geomoose

I'm a beginner in this field and i want to display the postgis data in geomoose.Here i'm attaching the mapfile code which i have stored in C:\ms4w\apps\geomoose2\maps\demo\"my map folder" . MAP ...
1
vote
0answers
25 views

How to generate arcs from attribute data?

What I am trying to achieve is an ellipse-like shape from a digitised point location and cardinal measurements. For example, point location at 531500,181500 with the attributes North - 4m, South - ...
0
votes
1answer
44 views

Displaying postgis database data

I'm a beginner in this field and tried to display the postgis database data in localhost.But i used select query in my code .so the table got displayed.I want to display the geographical points in a ...
0
votes
1answer
38 views

How to store Google Maps DrawingManager Circle overlay in PostgreSQL Postgis GEOMETRY(GEOMETRY, 4326)

What is the correct way to store a Google Maps DrawingManager circle overlay? Should I just store the center as a POINT and the radius in a separate column or store a polygon using ST_Buffer()?
0
votes
0answers
22 views

How to store Google Maps DrawingManager Rectangle overlay in PostgreSQL Postgis GEOMETRY(GEOMETRY, 4326)

What is the correct way to store a Google Maps DrawingManager rectangle overlay? The API basically provides me with NE & SW lat/long coordinates. Should I use BOX()? Is it possible to create a ...
0
votes
1answer
29 views

PostgreSQL PostGIS ST_Point_Inside_Circle() radius in meters

I'd like to begin by saying that I have very little knowledge and understanding when it comes to GIS (despite extensive experience with Google Maps API). PostGIS appears to be a whole new ball game on ...
0
votes
0answers
53 views

How to insert Google Maps API Lat/Long into PostgreSQL Postgis GEOMETRY(GEOMETRY, 4326)

I'd like to begin by saying that I have very little knowledge and understanding when it comes to GIS (despite extensive experience with Google Maps API). PostGIS appears to be a whole new ball game on ...
0
votes
0answers
27 views

Finding census block for given address using Tiger geocoder

I have a geocoder based on Tiger/Line data running on PostGIS. I need to find census block for a given address. How can I do it? Like I can do for census tract: SELECT get_tract(ST_Point(-71.101375, ...
0
votes
0answers
14 views

Saving and updating problems with PostGIS-Layer in QGIS

I have a OSM populated PostGIS DB (filled with osm2pgsql). All tables are working fine. But for my work, I need to combine some polygons with some points: create table attraction as select way as ...
0
votes
0answers
31 views

Hibernate spatial “org.hibernate.integrator.spi.Integrator” error

I use hibernate-spatial library and I encounter with this error: HTTP Status 500 - Handler processing failed; nested exception is java.util.ServiceConfigurationError: ...
2
votes
2answers
75 views

PostgreSQL/PostGIS Geom to JSON with Inner Join to another table

I am currently producing JSON from a database successfully using the following query: SELECT row_to_json(fc) FROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features FROM ...
0
votes
1answer
32 views

Postgis - get all records (lat, Log) that contain a polygon.

I have a polygon and want to get all the points inside from a georeference table. How is the sql sentence? For example. obtain all the lat/long records that are inside the department ZZ polygon. ...
2
votes
1answer
87 views

GROUP BY on geography in postgres 9.4.0 returns wrong/different results

table definition: CREATE TABLE search ( id bigserial NOT NULL, location geography(Point,4326) NOT NULL, location_aggregated geography(Point,4326) NOT NULL, created timestamp with time zone ...
2
votes
1answer
83 views

Best practice for a group working on the same shapefile, with open source tools

We are a small (~5) group working on a single, shared shapefile. The current workflow is that each one of us does the editing on a designated attribute field, on his local copy, then exports the ...
-1
votes
0answers
23 views

How to get the band number for a specific data value?

I have temperature data values which are stored in a raster image and I want to know which band numbers have that data value stored in them. Can anyone please guide me as to how can i do this using ...
0
votes
0answers
20 views

How to get a time cost related to polyline geometric characteristics in postgis using OSM data?

I'm trying to make an isochrone mapping of the emergency facilities in my region, I'm using a street map loaded in postgis by osm2pgrouting, data is supplied by OSM. The only cost I got for every ...
0
votes
1answer
33 views

Point inside st_dwithin with wrong results

I want to get all points, that are in the same area. Therefore, I have the following query for my table check: SELECT l.location_id, l.location FROM check l INNER JOIN check l2 ON ST_DWithin ...
1
vote
1answer
70 views

PostGIS: Geometry column registering as GeometryCollection, not converting to MULTIPOLYGON

I'm trying to aggregate data from a tabular data source and then join it to a geometry file (sl_adm2) in PostGIS using a primary key. The geometry file was imported using shp2psql. CREATE TABLE ...
0
votes
0answers
63 views

Fetching postgis data through php json and passing to leaflet map

I am new to this and trying to explore leaflet and geojson a bit. Please help me with this. This is my php page which I am using to fetch data from PostGIS. (the data opened successfully in the ...
1
vote
1answer
35 views

Renderd “planet_osm_polygon” not exists. What to do now?

I'm trying to create my map server. Importing a planet with osm2psql was perfect, I installed nominatim and is working too. I installed the libapache2-mod-tile packet, caring about to not create the ...
3
votes
1answer
57 views

ST_GeomFromGeoJSON strips coordinates, is it a bug?

I'm storing some geo paths in PostGIS using GeoJSON and the ST_GeomFromGeoJSON()-function but I just found an issue with it: SELECT ...
1
vote
1answer
35 views

Editing POSTGIS tables via QGIS

Is it possible to edit POSTGIS tables directly in QGIS 2.6.1. I've been using The DB MANAGER but can only really do DDL type edits....Or create/import a brand new layer. I did see a SQL Window but ...
2
votes
1answer
37 views

Odd performance of PostGIS Select Query with ST_AsText

I have this query: select ST_AsText(geo) as wkt, city, street_number, street_name, street_type, street_direction, street_unit from parcels_union order by id ...
2
votes
0answers
48 views

Postgres OSM planet reverse geocoding

i'm building function for reverse geocoding in Postgres using PostGIS function's. For now i was able to clean up all the data that was useless to me(rivers, buildings,etc.). I got 3 ...
4
votes
1answer
52 views

Using more than one ST_function in one query

I have got stuck with a dynamic analysis that I would like to include in a project I am working with. I want to save the query in the project file or make it to a view in my database. I have tried a ...
1
vote
0answers
32 views

Batch load multiple shapefiles to Postgis

According to the shp2pgsql help, the options drop, append, create and prepare are mutually exclusive. So, if I want to create a table from a shape and then append multiple other shapefiles, I do ...
1
vote
0answers
37 views

pgsql2shp: create shapefile from empty table, but with known attributes (dbf)

I was trying to generate shapefile from postgis tables using pgsql2shp. Everything is fine except for table with no rows. When trying to create shapefile from an empty table, an error occurs: Could ...
0
votes
1answer
66 views

Isochrone driving/public transport map : Grass or postgis?

I have to do Isochrone driving / public transport map. It would seem that the two better open-source solutions are grass and postgis. Could you tell me which one is the better? the easier to ...
5
votes
2answers
181 views

PostGIS nearest point with ST_Distance

I need to obtain on each element on one table the closest point of another table. The first table contains traffic signs and the second one the Entrance Halls of the town. The thing is that I can't ...