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

learn more… | top users | synonyms

1
vote
0answers
39 views

Mapserver display empty map when i add more then 1 raster file in 1 table postgis

Here is a part of mapfile with layer and WMS: WEB METADATA wms_title "Diplom" wms_abstract "no matter" wms_onlinesource ...
0
votes
1answer
36 views

Use C# to display PostGIS data in ArcGIS Developer kit with arcgis-ogr plugin

I am trying to display data in ArcGIS Runtime Engine Developer kit 10.2.2 using OGRPlugin/OGRPlugin/ develop by Ragi Yaser Burhum on https://github.com/RBURHUM/arcgis-ogr . I am using this format but ...
1
vote
0answers
38 views

GeoServer: Get styles from PostgreSQL/PostGIS table

We're running GeoServer with all layers coming from a PostGIS data source. Most people work directly on the PostGIS database, but we have one person sitting 10.000km away, and for him, connecting to ...
0
votes
2answers
61 views

Postgresql trigger on a table that update a field

Depending on values on 2 fields A and B, I would like a field C to be updated or filled with a specific value. For example : create or replace function periode() returns trigger as $BODY$ begin IF A ...
-2
votes
2answers
102 views

How to populate my table with data in excel format?

I have 160000 rows of data in Excel and I want to put them in my table in PostgreSQL. How can I import X,Y coordinates from my excel file to my table in postgresql?
0
votes
0answers
27 views

How to get elevation of a coordinate given a dtm file out of a PostGIS?

What would be the best way to get elevation of a coordinate out of a PostGIS database (SQL/plpgsql) given a GeoTIFF dtm file? Importing as PostGIS Raster (which seems more costly) and calling ...
1
vote
1answer
32 views

Why does ST_Area return different results for geog vs geom?

I have this simple query that returns very different values for a geom vs a geog: SELECT ST_Area(the_geom::geography) as area1, st_area(the_geom) from neighborhood where city_id='ny-new-york-city' ...
0
votes
0answers
21 views

Creating raster from points that conforms to a reference geometry using PostGIS, python, QGIS

Please forgive my ignorance, I'm fairly new to processing GIS data. My bread and butter is statistics but I'm now working on a project that requires more data preprocessing and cleaning than I've ...
2
votes
1answer
33 views

ST_LineMerge doesn't return LineString

I want to create a LINESTRING from a MULTILINESTRING. However in the following case ST_MultiLineString is returned: Select ST_GeometryType(ST_LineMerge(ST_AsText(' MULTILINESTRING( (-70.52570888 ...
0
votes
0answers
38 views

Any recomendations for a GIS web app?

I'm new at this world of geographic systems. I'm at Ubuntu 14.04 and I'm using Django (v1.6) to create an app that is both a CMS and a GIS. I already finished the CMS so now I'm trying to get started ...
1
vote
2answers
27 views

PostGIS ST_GeomFromGML giving strange result

I'm currently running Postgres 9.1 with PostGIS 2.0. I am trying to create a polygon geometry from the following GML: <gml:Surface gml:id="ID_63_1413425013514_23322" ...
0
votes
1answer
42 views

What is the best way to get two points along the line in both directions using postgis?

I have a point on a linestring geometry (found by an intersection). What is the best way to get two points along the line in both directions using postgis? It does not really matter if the points ...
1
vote
0answers
28 views

Postgis - Creating Ellipse in WGS84 with metric parameters

I have points in WGS84 (x,y), radiuses in meters (rx, ry), rotation angle in degrees. I would like to create a new WGS84 geometry. I've tried this but the major/minor distances seem to be off by a ...
0
votes
2answers
35 views

Postgis: Query ST_DWithin in square instead of circle

The ST_DWithin query queries all geometries within a certain radius from another geometry (in my case a point). For performance optimization of my application I want to query in a square. So that the ...
0
votes
2answers
31 views

“linestringZ” kills “pgr_createTopology”

I'm trying to make a postgis tabel ready for pgrouting. But when I run SELECT pgr_createTopology('network.VEJM_BR_SL', 0.001, 'geom', 'id'); I get an error: "Geometry has Z dimension but column ...
1
vote
1answer
34 views

How to deal with multiple overlaps in PostGIS?

I've been fighting this for quite a long time and everytime I think I got it, I got it wrong actually. What's the trouble See picture below. As a result of line buffers I got overlaps that need to ...
1
vote
1answer
26 views

How to select distinct geometries and ids with PostGIS?

I have point geometries in a PostGIS table. I want to select only the distinct geometries from this table. If a geometrie is duplicated, it should select the first appearance in the table. I tried to ...
0
votes
1answer
35 views

how to fix this ERROR: Start vertex was not found

I am attempting to make an SQL selection but receive an error. My statement: SELECT * FROM network JOIN (SELECT * FROM shortest_path(' SELECT gid AS id, start_id::int4 AS source, end_id::int4 ...
0
votes
1answer
25 views

problem in PostGIS Name of the system used for Points and how to get distance between to point?

I have started to work on a project in PostGIS. I have a table with a geometry points in which points saved like this : "010100000089F511C671C01E4162327E2A83545341" and I have translated this ...
0
votes
2answers
68 views

Neighbors within distance from every row

I have a research project of 180,000 entries and I need to calculate the number of neighbors (points from the same table) that exist within a 300 meter radius for each point. My method is very slow, ...
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. ...
1
vote
1answer
333 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
111 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
135 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
85 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
48 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
75 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
38 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
86 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
46 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
57 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
29 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
33 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
31 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
55 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
46 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
53 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
36 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
35 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 ...
1
vote
0answers
40 views

Installing PostGIS Layer Viewer for pgAdmin III

I have difficulties installing pgAdmin's plugin PostGIS Layer Viewer. The official repository on GitHub gives this Web site for install procedure, then the former site gives this Web site for ...
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
56 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
58 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
1answer
44 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
45 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
112 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
37 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
17 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
49 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: ...