PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

0
votes
0answers
34 views

Displaying measurements on a grid of the Earth

I'm developing an application where I need to draw the averaged results of some measurements on a map. Right now, I'm using Leaflet to draw the map with MapQuest/OpenStreetMap tiles, and have the ...
1
vote
2answers
91 views

How to populate a table with geom line? [closed]

I have the coordinates of a lot of points in a table. In pgadmin I want to make a line that passes on these points. I already have my Coordinate point im my table. I want to make line with those ...
3
votes
1answer
127 views

PostGIS - ST_Within or ST_Disjoint performance issues

I have a table of about 150,000 points in PostGIS with a spatial index and a SRID of 27700 (OS). I want to select the points that fall outside England and Wales. I have a multipolygon table with ...
1
vote
1answer
115 views

Creating GeoJSON from Postgres

We are transitioning from Google Maps to Mapbox. Mapbox is a proponent of geoJSON and uses it extensively, so we are considering adopting it for all of our maps. An issue is the creation of the ...
0
votes
1answer
57 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 ...
0
votes
2answers
160 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
181 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
60 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
0answers
62 views

Trying to install PyGreSQL, receiving DLL load failed error

I am trying to install the PyGreSQL package into Python 2.7. I am running 32-bit Python on a 64-bit Windows 7 machine. The installer I am using is the file PyGreSQL-4.1.1.win32-py2.7.exe from here. ...
0
votes
0answers
21 views

php script with lat and long for postgresql

I would like to create a postgresql geodatabase able to display, with OL3, data entered through a php script. In the php script i indicated the two fields latitude and longitude data as numeric ...
0
votes
0answers
39 views

Use another schema than public in geoserver monitoring plugin

We want to use the Geoserver Monitoring Plugin, based on a PostgreSQL 9.3 database. It works fine except that the plugin create the tables request and request_resources in the public schema, while we ...
0
votes
0answers
28 views

Query processing time for network table creation using pgRouting 1.05

I am trying to follow these steps for creation of a network table using pgRouting 1.05. In my case I have two road geometry tables, one is bangalore_road and the other is all_india_roads. Obviously ...
1
vote
1answer
63 views

slow Openlayers with 270000 points

I have 270 000 points on a map. If you zoom out, the site hangs for a very long time and sometime the page just crash. I use Cartaro with Drupal. https://www.drupal.org/project/cartaro Cartaro is a ...
0
votes
1answer
92 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
28 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
99 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, ...
0
votes
0answers
12 views

PSQL: Setting maxspeed to all highway tags having 'highway' text= NULL AND 'maxspeed' text = NULL?

Hello everyone, I am trying to create a procedure in postgresql using functions of postgis extensions where I can first search and find all the rows having an empty 'highway' tags AND ...
1
vote
0answers
18 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
442 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
203 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
1answer
202 views

PG::UndefinedFunction: ERROR: operator does not exist: point = unknown

Recently, I developed a feature to save and fetch points(lat and lon) from DB. It is working fine on my local, but on production database it is giving error: PG::UndefinedFunction: ERROR: operator ...
1
vote
2answers
284 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 ...
2
votes
1answer
128 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" ...
0
votes
1answer
39 views

UPDATE a value field for area of the geom and convert sq m to acres using cartodb

I'm trying to use the SQL commands in CartoDB to UPDATE a value field that shows total acres of the area of the_geom. My SQL is pretty poor/entry level and has some issues: UPDATE table_name SET ...
0
votes
0answers
70 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
286 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 ...
0
votes
1answer
66 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 ...
1
vote
1answer
79 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 ...
1
vote
1answer
65 views

Is there any topology handler in QGIS?

When importing autocad maps, sometimes topology will be chaos, this need to be amended. And when I add new topology in QGIS, how to save that to the postgreSQL? Is these functions included in QGIS or ...
2
votes
1answer
59 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 ...
1
vote
1answer
62 views

What is the proj4 for World Behrmann (54017)?

I have this in an old SDE database: ...
2
votes
1answer
118 views

Database connection times - PostGreSQL vs Oracle (ArcSDE)

I have 2 SDE instances. Both have the same amount of data (2000 datasets both raster and vector). One is PostGreSQL 9.2 with ArcSDE 10.2.1 One is Oracle 11g with ArcSDE 10.2.1 So basically the ...
0
votes
0answers
76 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
1answer
29 views

Migrating Data to Another Database whit FDOToolbox

I want to migrate my data (Shapefile) to a PostgresSQL using a FDOtoolbox , i searched a tutorial for that but i dont found it . can any one explain the steps to do for migarte the data from a ...
1
vote
1answer
107 views

Get a point value with psycopg2 and PPyGIS

I'm trying to setup a basic working postgis setup with python ppygis package. >>> import psycopg2 >>> import ppygis >>> connection = psycopg2.connect(database='spre', ...
0
votes
0answers
26 views

Assinging ID numbers with a spatial query in PostGIS

I am fairly new to PostGIS and I am working on a project where I am trying to write SQL to assign ID numbers in a column to points relative to the ID numbers of the polygons that contain different ...
0
votes
1answer
82 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
269 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
103 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
264 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 ...
2
votes
1answer
74 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
88 views

ArcMap 10.1, the identify tool does not show feature attributes on a query layer on a PostgreSQL database. Why?

I'm developing an ArcGIS 10.1 desktop map editing application using ArcEngine and ArcObjects. I'm using a PostgreSQL database. After a direct database connection (using a query layer), I displayed the ...
0
votes
1answer
29 views

PostGIS problem finding FK to PK

I have 2 tables in a postgres db to which I need to establish a 1-m relationship between. One of the tables has geometry, the other table does not have geometry but contain fields that describe the ...
0
votes
0answers
141 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
203 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 ...
2
votes
1answer
118 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 ...
0
votes
1answer
55 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
2answers
97 views

How to get the number of polygons of a geometry in PostgreSQL

How can I get the number of polygons that form a geometry in PostgreSQL? For example U.S map has a lot of islands in addition to its main lands. I want to count these islands plus the main lands.
0
votes
0answers
46 views

display thematic map using openlayers

iam displaying map from mapfile(mapserver) in c# using openlayers mapfile is connected to postgres it is working well but now i want to diaplay thematic map using the postgrs database using ...
1
vote
1answer
75 views

How to create Spatial Reference System in QGIS?

I have some Attribute and the coordinate and the coordinate reference system. I want to create a DBmanagamet form my spatial data. To do that I want to create one table with name Spa_ref_sys, but I ...