PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

2
votes
0answers
19 views

Problem with postgres/quantum converting long/lat to suitable projection/SRID [duplicate]

I'm sure it's a simple question but this is all very new to me and after a lot of internet searching my points are still in the sea! I have a set of UK postcode data that I have converted into ...
2
votes
1answer
1k views

Transforming from SRID 900913 to 4326 with PostGis

I have two Postgres tables with different SRIDs, 4326, and 900913. I want to convert the latter to 4236. I first changed the SRID using: Select UpdateGeometrySRID('table', 'geomcolumn', 4326). I ...
0
votes
1answer
75 views

Is it possible to install the PostGIS to the PostgreSQL (binary version)?

I'm using the PostgreSQL 9.2.4 which is the no installation version.I run this by using the command "Program Files/PostgreSQL/9.0/bin/pg_ctl" -D "Program Files/PostgreSQL/9.0/data" -l "Program ...
1
vote
2answers
114 views

ArcSDE installation; “sdesetup: command not found”

I am trying to install ArcSDE component for postgresql database from A DVD file. I have copied files of following folders on the server : command_64 pg_64 in both of theses files there are ...
0
votes
0answers
63 views

Parameterizing SQL Views Timestamp Issue

Could Someone help me? I am having some difficulties creating KML views. I am trying this SQL: SELECT the_geom FROM lighting.history WHERE stroke_time BETWEEN %inicialtime% and %finaltime% and ...
1
vote
1answer
165 views

How to address Geodatabase must be enabled as geodatabase admin user error? [closed]

I am trying to use "enable Enterprise Geodatabase" but I am getting the following error: "Geodatabase must be enabled as geodatabase admin user.Failed to execute " I am using postgresql 9.1.3 ...
1
vote
0answers
60 views

PostGis search query on hstore tags

I am writing a search client, to query postgis db. The search query will be, SELECT tags->'name' AS name,ST_Transform(way,4326) AS pt_lonlattext FROM planet_osm_point WHERE lower(tags->'name') ...
0
votes
2answers
469 views

“Create Enterprise Geodatabase” errors

I am trying to use " Create Enterprise Geodatabase" option in arcmap 10.1: I am getting two following errors: You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL ...
2
votes
1answer
1k views

Import database (Excel file) into PostgreSQL [closed]

In order to import my database (excel file) into PostgreSQL, I converted the Excel file into ".csv" file. Then, I used the application: "Import Data For PostgreSQL" and I could import my database but ...
2
votes
1answer
69 views

Tiger geocoder / postgis - get county from point

Looking for some help with getting the county for a lat / lon. I have postgis / tiger geocoder installed and can reverse look up a point and get the addresses. I would like to get the county the ...
1
vote
2answers
257 views

Is it real to install PostgreSQL 9 on the virtual machine Windows Server R2?

I have Virtual Box with GuestAddition. And virtual machine "Windows Server 2008 R2" When I use real computer with Windows Server 2008 R2 I can install postgresql-9.2.3-2-windows. But when I install ...
1
vote
2answers
112 views

Postgis csv and error loading into mysql

I want to load spatial data into mysql using a csv i have generated from a postgres table and when loading it into mysql database using phpmyadmin it complains Cannot get geometry object from data ...
0
votes
1answer
651 views

Could not add the specified data object to the map

I have registered the postgresql database with arcgis desktop 10.1. In ArcMap, When I try to drag and drop one of the tables to the map I get this error: Could not add the specified data object to ...
1
vote
1answer
104 views

Is postgres 9.1.9 supported by ArcGis 10.1 Service Pack 1?

I want to install Postgres and Postgis. Now we use ArcGis 10.1 So I install Postgres 9.0.5 But there is not exist Postgis for this version. I try install postgis 2.0.3 But I fail(it is only 32 bit ...
0
votes
1answer
86 views

Create Layer editing/Analysis in an ArcGIS web map application using Javascript API

I want to make an ArcGIS web map application in which user can select different layers of the published map (data of the layer in Postrgresql) and do some analysis based on layer data.import data to ...
3
votes
1answer
87 views

Select linestrings containing points with duplicating M coordinates in postgis

I have a table of LineStringM geometries. Some of lines have points with same measure (M coordinate). This is a bug in initial data, that I want to clean somehow. So I need to: 1. Select all records, ...
0
votes
0answers
9 views

Converting Grib Files to a format suitable for Geoserver [duplicate]

What is the best way to display Grib Files in Geoserver dynamically, preferably via Postgres/PostGis.
3
votes
1answer
284 views

Database connection failed

I am trying to connect from Arc Cataloge (version 10.1) to postgresql 9.2. But every time I try to make "Database Connection" I am getting this error: Failed to connect to the specified server. ...
0
votes
1answer
290 views

Best way to store polygon geospatial data in postgreSQL?

I have to store longitude and latitude coordinates for several places in a PostgreSQL db table. Each row in this table has a field with a set of pairs {latitude1, longitude1, ....latitudeN, ...
0
votes
2answers
243 views

connection from ArcMAP to Postgresql, Is ArcSDE required?

I wan to make a direct connection form Arcmap to Postgresql. I have ArcGIS for Desktop 10.1 on windows (64bit). So I need to put "pg_client_windows64" libraries in C:\Program Files ...
1
vote
1answer
235 views

Is there any instructions to download OSM in postgres database?

Is there any instructions to download OSM in postgres database? I use geosuite (geoserver, postgres, postgis). I'd like to download USA and Russia (1-12 levels). I also want to download sld styles. ...
2
votes
0answers
147 views

Finding poi using st_dwithin in postgis

I am not familiar with gis or writing sql, so my understanding in this field is lacking. I have a hundreds of lat/lng geographic coordinates stored in a single table called Places like this: ID | ...
0
votes
0answers
140 views

How to use st_geometry.dll for Postgres 9.2 (64) from ArcGIS 10.2 in 10.1?

I do not know if this is appropriate here, but I would like to try to use the st_geometry.dll for Postgres 9.2 (64) that is found in ArcGIS 10.2 in 10.1. Is it even possible? If so is there anyone ...
1
vote
1answer
120 views

connection to postgresql; From ArcGIS for Desktop 10.1 OR ArcGIS for Server 10.1

As it is mentioned in ArcGIS Resources "PostgreSQL client libraries are required on the ArcGIS client application from which you will connect to the database". My questions are: by ArcGIS client ...
0
votes
1answer
246 views

How to fix “Connection failed - Check settings and try again” when connecting to PostGIS?

I have Postgres running via Postgres.app on rails already and am trying to connect QGis to the database. PostGIS is working already. (questions already found online deal with this issue only) I do ...
0
votes
0answers
61 views

Error when deleting field in arcgis: “Table contails a column type not allowed in versioned views”

Something messy :) happened to my geodatabase. When I'm trying to delete a field in ArcMap I get this message: * "Failed to delete the selected field. Table contains a column type not allowed ...
1
vote
1answer
101 views

Three table postgres sql join query

I'm having trouble getting my SQL query to work with three tables. I'm new to SQL to I've already spent considerable time trying to understand the documentation and making some sense of it. I'm using ...
3
votes
3answers
647 views

Using PostgreSQL with ArcGIS

Have mercy ... with Stackexcachange I'm not yet so familiar, so this is initially somewhat opaque. I try to do my best to organize this thread as well as possible. Recently I've started to get WFS ...
1
vote
1answer
123 views

Calculating area of MultiPolygons within 250m buffer of points

I am using using PostgreSQL 9.2 and PostGIS 2.0. I have two tables: 1) a geocoded table of home addresses (address_list) and 2) a table containing data on tree density in the same geographical area. I ...
2
votes
1answer
79 views

Points to paths

I have a set of lat/long points which represent positions along a set of paths (the points are generated by satellite collars on several animals that we are tracking), and I want to link the points ...
2
votes
1answer
414 views

WFS & Feature Access -> Database connection / Database support (ArcGIS 10.2)

Over the last two days I've tried to set up and to use a postgreSQL database to use WFS and Feature Access. I've also started a thread in the esri forums, but I hope that I can reach a wider audience ...
0
votes
2answers
90 views

What queries can I use to select data?

Which queries can I use to select the following information: How many towns are within a distance of 3km of both a road and a railway and are within 6km of the coast? And any towns that have both a ...
1
vote
0answers
32 views

How to load or query data directly to R from a PostGIS database using RPostgreSQL and rgdal [duplicate]

Is it possible to load/query a shapefile to R, which is stored in a postgres/postgis database? I've built up a connection to my postgres database via DBI, RPostgreSQL and I want to make some ...
0
votes
0answers
68 views

Polygon dynamic grid creation for a shape file

I have used QGIS Vector->ResearchTools-> Vector Grid to create a 1lat x 1 long grid for the landpolygon shape file (from osm). Now, I am interested in creating dynamic grid for the original ...
1
vote
0answers
341 views

Import raster data from postgis and publish in geoserver

I am using geoserver 2.3.3, PostGIS 2.1 and PostgreSQl 9.1. The Image Mosaic JDBC extension is also installed correctly. I am trying to import raster data from PostGIS and publish in Geoserver but ...
1
vote
1answer
70 views

how to identify EPSG of any shapefile [duplicate]

I have a shape file, imported in PostgreSQL using PostGIS when this shape-file is published in Geo-server it didn't show any layer. I had used EPSG:4326..thanks
1
vote
0answers
84 views

CREATE Script for Enterprise Geodatabase?

I have an ArcGIS For Desktop license, and we have a PostgreSQL 9.2/PostGIS 2 database server running in our network. We currently use Query Layers to add the PostgreSQL data to ArcMap sessions. We ...
0
votes
2answers
187 views

How to convert shp to PostGIS dump?

Given a file my_file.shp such those from Gadm e.g. US administrative divisions, where the coordinate reference system is latitude/longitude with WGS84 datum. Input could actually be: Shapefile, ...
0
votes
1answer
31 views

How to make a vectorlayer through of sentence SQL on PostGRES

How do I create a vectorlayer to through SQL on PostGiS on Python 2.7. I is working with QGIS 1.8 and I needed create a vectorLayer through SQL on PostGIS.
1
vote
0answers
209 views

save features from openlayers to postgis via nodejs and websockets

I try to save features created on a vector layer (openlayers) to postgreSQL 9.1/postGIS 2.0 via websockets. As server I use nodejs 0.10.12 along with the pg module I cannot fix it. Its getting so ...
3
votes
3answers
229 views

What does the “service” box in the PostGIS connection dialog stand for?

Can sоmеbody explain me what to write in the "service" box when connecting to the local DB. QGIS Lisboa and Postgres are installed.
4
votes
1answer
171 views

Maritime route prediction avoiding land masses

I am working on a project where the following functions have to be implemented: Predicting the locations of the ships (in maritime environment) at a future time. (Can be done with Kalman filter, IMM ...
1
vote
1answer
185 views

OpenLayers, Geoserver, Postgis, GITHUB and content management

Im not sure if this is the right forum for this question. I am working on a project to look into developing a prototype mapping applications for the agriculture industry. I am using asp classic, ...
2
votes
0answers
92 views

Hitting Memory Limits of PostGIS ST_ConcaveHull / Incomplete Shrink Wrap

I am trying to use PostGIS 2.0 on Postgres 8.4 to do some mapping. I am working with the NOAA Shapefiles, specifically their US States & Territories file located here: ...
1
vote
1answer
308 views

PostGIS package problem on Ubuntu 12.04.2 LTS

I've started getting an error on Ubuntu when trying to upgrade packages: "Not all updates can be installed Run a partial upgrade, to install as many upgrades as possible" When I run a partial ...
3
votes
1answer
392 views

Setting coordinate system in PostGIS

The geographical information data that INEGI (part of the Mexico's goverment) provides are in the following coordinate system (or is projection?) Lambert Conformal Conic, double standard parallel ...
0
votes
0answers
15 views

postgres on bash command line and conversion to python with parameter substitution [duplicate]

i can use the pgsql2shp on the command line but however if i try to incorporate it into a python script with parameter substitution it fails. how best could I improve this. This is for a postgres ...
2
votes
1answer
84 views

Postgis and python parameterised queries

I have a python script that i am trying to run in order to dump a postgres table and I noticed there is a pgsql2shp command in bash to perform this easily but I would like to incoperate the same ...
0
votes
0answers
77 views

Problem with Strava Like Identifying of Trails From a GPS Track

I'm playing around with creating some basic Strava-like functionality for a project and I've ran into a problem. I have a database of existing trails, the user uploads their gps track of a ride they ...
0
votes
1answer
103 views

Find closest NON interpolated point on a LINESTRING

I have a linestring and a point, I want to find the closest point on the linestring to that point. Below is a screenshot of a test I created to confirm that the various POSTGIS functions for finding ...