Tagged Questions

PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms

0
votes
1answer
23 views

Nearest neighbour for every row

I'm relatively new to PostGIS and postgresql . I'm trying to build a simple query containing two relations as follows : I've two relations R1 and R2 both of which contains geometries(Points) . I ...
0
votes
0answers
8 views

Publish raster dataset from register database

Now, we use 2 computers: 1 (ArcMap_Desktop_1 + ArcGis_Server) and 2 (ArcMap_Desktop_2). All data are stored in ArcMap_Desktop_2 (sde database + postgres 9.0.5). We use ArcMap_Desktop_1 for publish ...
0
votes
1answer
14 views

Connecting PostgreSQL/PostGIS and MapGuide Maestro

This is less a specific question, but hopefully more of an open question. There is little documentation regarding connecting the excellent OS web mapping software MapGuide Maestro ...
0
votes
0answers
18 views

Change Values with FieldCalculator on Postgres doesnt work [on hold]

When i try to change values in a Postgres-table - for example, very simple: Value = 'no', existing field ... this will not work, the OK-Button is only grey and not active. What is wrong? edit: On ...
0
votes
0answers
14 views

Full instruction for download OSM data in Ubuntu 12.04 LTC

Is there instruction for: 1) install software 2) download OSM data in Postgis database 3) set styles 4) generate tiles 5) initilaze MapProxy (all in OS Linux) 6) View map (generated tiles) ...
0
votes
1answer
48 views

Mimimum distance between points (Postgres/PostGIS)

I have a table (tab_Cities with cities which own more than 50000 inhabitants. The table also contains lat, long and the_geom as columns. I can already see the points via QGIS. Now I want to write a ...
0
votes
1answer
48 views

Error when trying to run Create Extension postgis

I have installed PostgreSQL 9.x and PostGIS 1.5/2.0 several times and have never had this problem. I just got a new CentOS 6.3 server up and running and and I have Postgres 9.3 functioning as ...
2
votes
1answer
59 views

Split Line at intersection and attach attributes

I want to slit line at intersection and attach attributes and export I have roads table with columns id,road_name,road_type,geom with 2115 records. I try using this query - select ...
0
votes
2answers
28 views

pgrouting - create topology from nodes?

I have a table of nodes (points) and i wish to route between the points. Its my understanding that i first need to build a pgrouting compatible topology (graph ?) that connects all the nodes using ...
0
votes
3answers
76 views

How to create a new 'gis' database in PostGIS?

I'd like to create a new database in PostGIS, so I can load stuff into it while the current database is being used. According to the docs Some packaged distributions of PostGIS (in particular the ...
2
votes
0answers
18 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
58 views

Transforming from SRID 900913 to 4236 with PostGis

I have two Postgres tables with different SRIDs, 4236, and 900913. I want to convert the latter to 4236. I first changed the SRID using: Select UpdateGeometrySRID('table', 'geomcolumn', 4236). I ...
0
votes
1answer
36 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
37 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
27 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
61 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
18 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
54 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
61 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 ...
1
vote
2answers
51 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 ...
0
votes
1answer
13 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
40 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
42 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
0answers
41 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 ...
2
votes
1answer
27 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, ...
3
votes
1answer
57 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
65 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
39 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 ...
0
votes
1answer
77 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
47 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
53 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
44 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
36 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
21 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 ...
3
votes
3answers
120 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
59 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
41 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
89 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
65 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
23 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
32 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 ...
0
votes
0answers
20 views

Getting locked out of PostgreSQL databases [migrated]

One of the greatest fears I have is getting locked out of my own data due to the security features of a heavy weight database such as PostgreSQL (and PostGIS). Whilst I can log in as the ...
0
votes
0answers
34 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
46 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
0
votes
0answers
23 views

How to show a selected area of a map in openlayers as we get in geonetwork

I have created a map using openlayers where user can select area on map, on this selected area user can see some result with the help of wfs openlayers, but I want to increase the size of the selected ...
1
vote
0answers
30 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
56 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
29 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
91 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 ...
4
votes
1answer
92 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 2 3 4 5 … 12