PostgreSQL is an open source object-relational database system.
0
votes
1answer
34 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
0answers
13 views
Change Values with FieldCalculator on Postgres doesnt work
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
9 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) ...
2
votes
1answer
157 views
How can I make a Postgres/PostGIS ST_Distance_sphere query more efficient?
Within Postgres/PostGIS I have written an SQL query to get the closest distance for each element within a point coordinate table from a polyline table. The query comes back and works correctly, but ...
0
votes
0answers
28 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
34 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
27 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
1answer
49 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 ...
1
vote
1answer
38 views
Creating pop-ups on point layers
i have a postgresql database which is refreshed all 10 minutes and i need to create graphs in pop-up with the data. When i click, a pop-up (or annotation ?) appears. How can i make it possible ?
...
10
votes
4answers
4k views
Loading a raster into a PostGIS 2.0 database on Windows
I'm trying to figure out how to load a raster into a PostGIS2.0 database (I have asked previous questions on this topic here and here). I am trying to use the raster2pgsql.exe program provided with ...
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
34 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
50 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
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 ...
