PostgreSQL is an open source object-relational database system.
0
votes
1answer
16 views
PostGIS: Querying a record table and explanatory table
Basically I have two tables one containing a collection of records and one table that contains extra info about features in the first. i.e
Records Table:
GID
SITE
SPECIES
GEOM
and the second table ...
-1
votes
0answers
56 views
To create a map dynamiclly in openlayers?
Need to group any one attribute field of the table(Eg india_state) in any ranges like 0-20 taking primary key gid in consideration through postgresql and php.Now after reclassifying the group,now need ...
1
vote
0answers
39 views
QGIS PostGIS Authentication Failure with “trust” option [migrated]
I'm trying to setup a PostGIS db using PostGreSQL 9.1 on Ubuntu 12.04. I've set up the database, created a user account "jay" with no password, added spatial functionality following section 2.5 here, ...
2
votes
1answer
32 views
PostGIS ST_Contains question
Here's a quick summary about what I'm trying to do: Let's say I got two layers. One (A) with 10 polygons and one that is more granular with 100 polygons (B). Just to check if the behavior of PostGIS ...
1
vote
1answer
28 views
segment lines according to point using pgRouting?
I'm working on postgresql and I am trying to create table to generate graphs. I have a table that contains all the objects of a city (points) and another contains the city street. My goal now is to ...
1
vote
2answers
21 views
Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)
I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
1
vote
1answer
17 views
st_clip and gdal_translate: “Error browsing database for PostGIS Raster properties” - Why?
Im using shell-script, postgis2.0 and gdal for trying to clip raster apart, using an overlapping raster and a the_geom-object. At first I create a view to clip the overlapping part of the raster. It ...
1
vote
2answers
56 views
Which version of pgRouting should I use with PostgreSQL 9.1 and PostGIS 2.0 (on win xp)?
I am new to GIS.
I want to install pgRouting on my system (win-xp 32-bit). I am trying to run routing_core.sql file and got the following error:
ERROR: incompatible library "C:/Program ...
4
votes
1answer
93 views
How to speed up an st_intersects() query?
I have a "huge" spatial database: 72GB, 200 millions documents with geometries (points)
I have a GIST index on the geometries
the database:
CREATE TABLE resources
(
id bigint NOT NULL,
accuracy ...
4
votes
1answer
63 views
How can I snap lines in PostGIS?
I have a few linestrings that together form a long line. The start- and endpoints of the linestrings are equal with their direct neighbour, but when tested the ST_Distance between any 2 lines is like ...
1
vote
0answers
92 views
Can POSTGIS 2.0 be install with POSTGRES 9.2 on Ubuntu 12.04 OS at the moment?
This question is more about environment set up.
At the current moment, March 4th 2013, can POSTGIS2.0 be install with POSTGRES 9.2?
I check their website out and to my understanding it is not ...
1
vote
0answers
35 views
Function for Selecting Points in a Polygon
I've been banging on this for a few hours, but since I'm relatively new to PostgreSQL and PostGIS, I can't find the solution. I'm trying to create a stored procedure (function) which will return all ...
2
votes
3answers
55 views
Postgis st_intersects fails on an obtained point on the line with the line itself
I am trying to split a line from its intersection with another line. I know I can use st_split directly here but I wish to split a line from several positions where it intersects other lines. What I ...
2
votes
1answer
66 views
Given a lat/long point, determine if it's land or water?
I have a PostGIS-enabled PostgreSQL 9.1 installation with the 10M physical dataset from Natural Earth imported. It's been converted to 900913, and in QGIS I can visualize the data. So the plumbing's ...
1
vote
0answers
28 views
How to properly use PostGIS with Maps
First time using PostGIS in an app.
Target:
- Get Heat Map of customers from address table using leaflet.js and heatmap.js
Have DB called store_dev.
Installed OSM Bright from Mapbox in it.
Have a ...
1
vote
1answer
41 views
Keep .gdb structure to postgresql + PostGIS (Feature dataset)
I have a .gdb file with a specific structure. I will extract all shp files for uploading to a postgtresql db. But I want to keep the structure of gdb. How can I keep this structure to ...
1
vote
0answers
60 views
Adding polygon to existing database column
I've built a database with postgreSQL with a few geometry columns.
When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my DB using postgis. Now, I want to add ...
-1
votes
1answer
38 views
unable to connect postgresql on 5432 port [closed]
error is :
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the server running ...
0
votes
0answers
34 views
How to pass parameter postgres sql to Map file - java
I am new to GIS. I want to pass a parameter map file dynamically. Or how map file fetches the data from the database. I can't find out the solution. This is my map script.
LAYER
CLASSITEM ...
3
votes
1answer
54 views
Visualization of a big graph in 3D from postgresql/postgis
We have a graph in 3D in a PostgreSQL/PostGIS database. It contains something like 50'000 edges and 50'000 vertices, with x-y coordinates and floors.
We would like to visualize this graph with ...
1
vote
1answer
38 views
How to install postgis2.0 on Debian
How to install postgis2.0 on Debian6.0 and with Postgressql9.1 ?
Didn't find any good repository ?
Do you have to go all the way and compile ?
0
votes
0answers
25 views
How to Draw a Point on a Geotiff in Android and Put it in the Postgresql Database?
I need to:
Open a geotiff in my phone (android) {offline)
Draw a point
Get it's coordinates (X,Y)
Fill in the data attributes (name of the point, ...)
Put the data and the coordinates in my ...
-2
votes
0answers
25 views
traverse array in c#/javascript application [closed]
I am using postgres and I have created a function in plpgsql that returns an array of points.
Now I would like to traverse the array and read each point in the array using c# and javascript.
Can ...
2
votes
1answer
53 views
Postgis shapfile and DBF loader 2.0 problem windows
I am trying to import a shapefile with polygons into Postgis (Windows 2008 server). If I import 100 polygons it works fine. If I try to import the full map of 8,100 polygons, about halfway I get an ...
4
votes
2answers
120 views
How to install PostGIS on Linux Mint 14?
I am trying to install PostGIS on Linux Mint 14 KDE. First thing I tried was to install PostgreSQL using "sudo apt-get install postgresql". I was successful doing that. I then did "sudo apt-get ...
1
vote
1answer
30 views
point of intersection issues
I have a table containing a set of points of intersections.
Most of the roads intersects whith just one road BUT i have some roads which intersects with two, therefore three different point of ...
3
votes
2answers
51 views
Traversing a PostGIS table tree
I'm developing a geospatial db for a company that operates at a number of large facilities. Its primary purpose is to help staff locate themselves and equipment within each facilities' multi-storey ...
1
vote
1answer
99 views
PostGIS spacial data type to represent geo-located polygons
I have a PostgreSQL database with circle shaped objects called 'spots'. Each of those objects has latitude, longitude and a variable radius, information that I need to define this circles. Given an ...
1
vote
0answers
43 views
How can I snap 2 lines in QGIS so the st_distance between them is 0?
Sometimes when I snap the ends of 2 LineStrings together and I check the st_distance between those endpoints I get a value in the order of 1.1E-10 while at the same time when I check for equality of ...
2
votes
1answer
69 views
generate height data from DTED maps
I have 16 DTED maps of (1 degree x 1 degree). I have to generate combined height matrix of maximum 4 (1 degree x 1 degree) DTED maps in my C++ application.
Can someone suggest to me which open source ...
1
vote
1answer
69 views
Stuck in loading raster to PostGIS
I am running running Mac OS X (10.7.5), PostgreSQL (9.2) and PostGIS (2.0.2) (installed via Postgres.app).
The PostGIS extension seems to work perfectly with vector and raster layers. Once I enable ...
1
vote
0answers
50 views
Shapefile postgis database to be queried by GeoDjango
I would like to create a Postgres database (postgreslq-9.1 and postgis-2.0.2) storing several shapefiles but I am uncertain on how to implement it so I'm searching for some advices.
I have already ...
2
votes
1answer
42 views
How to configure and install psycogpg2 - beginner?
I need to install psycogpg2 for working with 'django'.
I read the instructions but I dont understand whether to run the commands in command prompt or in python command line. I am lot used to the GUI ...
4
votes
2answers
119 views
PostGIS stored procedures
I am wondering if there are open source applications that make extensive uses of the special functions (the ST_* stored procedures) provided by PostGIS? I found many apps that support storing map data ...
3
votes
2answers
101 views
Connecting to ArcGIS Desktop PostgreSQL database (running locally)
I know this is a total noob question but then again, when it comes to PostgreSQL I am a total noob...
I have installed the OpenGeo suite on my computer, running Windows 7, 64-bit. I have ...
3
votes
2answers
129 views
PostGIS - incorrect result distance between two points
I am quite confused the way PostGIS is returning the result for this basic query.
So I am trying to find the distance between two points
45.2714,71.2087 and 42.3739,66.39
and the distance should be ...
0
votes
0answers
85 views
ajax not working with postgresql
I know is a silly question but I thought I should ask since you guys know more about postgresql. Sorry for being analytical, but I think its the only way to make my question clear.
I'm using ...
4
votes
1answer
47 views
How to use -lco options in gdal_contour?
I'm trying to create contours from geotiff raster with gdal_contour. My output format is Postgresql and I would like to ovewrite the existing table.
When I do:
gdal_contour -a 1 -f PostgreSQL -i 50 ...
1
vote
0answers
62 views
SELECT DISTINCT from table in Geoserver SQL view [closed]
The postgis table I have has the following columns,
id | name | style_id | unique_id | time_stamp | the_geom(polygon)
and logically the unique constraint (not currently imposed in the db) lies with ...
1
vote
2answers
50 views
mulitlinestring to linestring
I am using postgres with postgis and I have a set of points which I would like to interpolate with a set of lines.
Now my problem is that the set of lines are of type multilinestring.
Is there a ...
3
votes
1answer
60 views
pgRouting Dijkstra returns wrong
I've just observed something quite odd.
I have created a table with data for routing, and this table contains data for a graph over six different hour conditions. So when performing shortest_path, I ...
4
votes
2answers
170 views
PostgreSQL, PostGIS and GeoServer publishing 1.7 million records
I have a polygon geodata in postgresql and I am publishing out to geoserver the 1.7 million records. How long is too long when processing?
EDIT: Forgot to mention that I successfully published a ...
4
votes
3answers
110 views
How to join two tables using date, time, lat and lon as common field?
I am sorry if the question is elementary but I did not find any clear discussion or guide to understand how to run a query in postgresql. So that a pointer to another website would be also useful. ...
2
votes
0answers
41 views
Pgrouting can't find postgresql (on Mac)
I've installed both postgreSQL 9.0 and postgreSQL 9.1 on my mac, using binaries from http://www.kyngchaos.com. I also have postgis 1.5 installed.
I tried to install pgrouting, again using binaries ...
3
votes
1answer
67 views
PostGIS Trigger doesn't work
The trigger below don't works and I need that when a new pipeline (adutoras) is inserted or updated, the procedure check what are the municipalities (municipios) that intersects the pipes and put the ...
1
vote
1answer
39 views
Ordnance Survey TOIDS: converting from strings to integers
I'm planning to load a number of OS datasets into Postgres/PostGIS.
In order to save space and speed up queries, I'd like to strip the 'osgb' off the front of the TOID strings and then store the ...
0
votes
0answers
48 views
how to group interconnected edges inside a table?
Given a table and a random set of edges with source and target columns, how can I find out which edges connect with each other and then group them together using PostgreSQL?
2
votes
3answers
78 views
ST_Covers: Geography Implementation is not working, Geometry Implementation taking too long
I have a query: (This query uses geographical implementation of ST_Covers function)
SELECT ST_Covers(ST_GeoGraphyFromText('MULTIPOLYGON(((179 -89,179 89,-179 89,-179 -89,179 ...
1
vote
0answers
37 views
given sets of vehicle passing on each edge, how to get most used vehicle to avoid transition?
I have two tables: one, the resulting table from converting osm.xml via osm2po so I can use pgRouting, and another one that contains information on what edges each public vehicle passes through ...
1
vote
0answers
78 views
pgrouting shortest path result in wrong order
I am using the Dijkstra shortest path algorithm to plot a route between two points using the latest version of pgrouting in postgresql 9.1 with postGIS 2.0.1.
I am able to get a correct result ...