PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

1
vote
2answers
9 views

PostGIS: Intersection between line & polygon

I have a linestrings consist of 2 vertices. I want to get all lines that don't intersects with any polygons on the way. In my example: blue line Not intersects - only touches some polygons, but black ...
2
votes
1answer
22 views

PostGIS: Add vertices to polygon

For example I have rectangular polygon (4 vertices). I want to add mid-point on each line of the polygon, so in total now I have 8 vertices. And from them I want to build new polygon who will have ...
0
votes
1answer
18 views

Which is the correct Options 's “Hydraulics” field in EPANET?

Which parameter has to be given into Options 's "Hydraulics" field in EPANET? Has it to be only a name or a complete file name with the extension? In my case .rpt doesn't work, neither without the ...
0
votes
1answer
9 views

Configure GeoNetwork with postgreSQL

For testing purposes, I deployed geonetwork 3.0.1 on tomcat7 and ubuntu 14.04 with default configuration, especially h2 database. Now I wanted to switch to postgres and followed the instructions ...
2
votes
2answers
109 views

PostgreSQL trouble editing points / lines / polygons in QGIS

I have a problem with postgresql and QGIS : I can add points/lines/polygons and fillup field But I can't : delete points/lines/polygons modify points/lines/polygons (move or modify field) ex : ...
-6
votes
0answers
21 views

SPATIAL QUERYING ON A VECTOR LAYER IN OPENLAYERS 3 , TO HAVE ONLY SOME SPECIFIC LAYERS TO BE VISIBLE IN OPENGEO SUITE APP [on hold]

As i am unable to write a query on vector layer in openalyers 3. On raster layer i am able to restrict layers using CQL_FILTER, but unable to add styling and overlay it on a bing map. Looking for a ...
-4
votes
0answers
13 views

HOW TO PASS AND CALL VALUES FROM A OPENGEO SUITE APPLICATION TO A .NET APPLICATION [on hold]

I am unable to call and pass values from a separate application(.NET application) to a opengeo suite applciation. As i am given with a (url :- http://localhost:9080/ ) generated in command prompt ...
0
votes
2answers
109 views

Sql Query in Postgresql

I am trying to execute a query but I am stuck. I have two tables A and B. The a table has columns gid, geometry(line-string) and value which cells is empty , the B table has got 3 columns gid, ...
3
votes
2answers
52 views

ST_Area of a buffer differs by coordinate

Why are these results different? The only difference is the coordinate. Seem like the area should be the same. select st_area(st_buffer(st_setsrid(st_point(-70, 40), 4326)::geography, 10)) AS ...
1
vote
0answers
13 views

access the encrypted table in qgis

I have a vector layer in qgis connected to PostgreSQL database table. Suppose I encrypt the table column using pgp_sysm_encrypt or some other encryption in PostgreSQL Is there any way i can say ...
2
votes
3answers
611 views

ST_MakePoint or ST_PointFromText to generate points

I'm new to postGIS and am having trouble finding an answer to this question. I have loaded UK postcode data (OSGB36, SRID 27700 with eastings and northings fields) into a postGIS database. I now want ...
1
vote
1answer
35 views

How to transform from a SRID to another?

How can I transform a geometric column of table from "SRID=4326" to "SRID=32650". I saw "ST_Transfom" and " ST_SETSRID" operator before. To do so, I used follow construction operator, But it dosen't ...
0
votes
1answer
23 views

How to identify the right road using postgres and postgis

I want to identify a road at particular point of intrest using post gis. Example Input String : 16th cross near xyz mall. Problem I am facing As there will be many "16th cross roads" in the map , ...
0
votes
1answer
466 views

ERROR: Operation on two geometries with different SRIDs

I'm new when it comes to GIS and PostgreSQL. I have searched everywhere for the cause of this problem but I can't find the solution. I was following the documentation here First i created a table: ...
0
votes
1answer
29 views

How to resolve the postgis “type geometry does not exist” issue on installing tiger_geocode extension?

I have installed postgis extension in my db. I have few columns associated with its type in few tables and now I would like to use reverse geocode functionality in my app. Hence I tried to create ...
0
votes
1answer
23 views

How to set srid of a single point coordinates pair?

I think is better explain with a small example: selected a geometry point i get it back in a coordinate pair SELECT ST_AsGeoJSON('010100002031BF0D009A999919F9BD2D41CDCCCC4C758E5241') --result: ...
1
vote
1answer
25 views

How to merge(transfer) one layer into another postgis layer?

I want to merge 2 layer which have identical structure. First layer is from postgres database table say "layer1" and other layer is shapefile say "layer2". I want to merge layer2 "INTO" layer1 (NOT ...
1
vote
2answers
236 views

Getting OSM maps in Equirectangular Projection via osm2pgsql

I'm trying to import some OSM data into psql as equirectangular projection using osm2pgsql with the following command: osm2pgsql -c -d osm -S /usr/local/share/osm2pgsql/default.style -l ...
1
vote
3answers
320 views

Create shapefile from data PostGIS or KML using Java

I'm working on a geographic information system project, whose products form shapefiles. I am using the Java programming language and a PostGIS database. Is there a way to generate a shapefile from ...
1
vote
1answer
51 views

counting overlapping polygons - ST_Union very slow, how to make it more efficient?

I have a set of 1000 polygons that overlap and I want to count the areas of overlap. I am using this blog post's instructions to create multilines from the 1000 polygons then use this line file to ...
0
votes
1answer
37 views

PostGIS: Closest outside point to point inside polygon

There is the famous ST_ClosestPoint() return the closest point inside polygon to some outside point. I'm looking the inverse problem: I have a location inside polygon, and I want to get the closest ...
4
votes
3answers
2k views

Importing .shp to postgreSQL

I want to import a shp file to postgreSQL. First I create sql file and then run PostgreSQL. To create sql file, I run this command in windows cmd: shp2pgsql -s 4326 worldCountries.shp worldcountries ...
0
votes
0answers
24 views

PostGIS: Lines from location touches but not intersecting polygons

I have OSM .shp file of buildings. I created vertices along each line of the building in that way: vertices (red) & mid points (green). The mid points made by ST_Line_Interpolate_Point() after ...
0
votes
1answer
20 views

How to use intersection in spatial guery in postgresql?

I want to get id, time and point_metric columns from intersection between two geometry(geom_lines and gem_houses). I wrote following sql code, however it fore an error (argument of WHERE must be type ...
0
votes
1answer
195 views

Shp2pgsql - exec() not allowed on external server

Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise). We put these commands in a php variable and use the exec() command to execute them. This ...
0
votes
2answers
55 views

PostGIS: Closest polygon to point [duplicate]

I have .shp file of polygons and single (point) location. How can I retrieve the closest polygon to that single location? Thanks,
6
votes
2answers
171 views

What controls the direction of TopoGeometry Linestrings?

In PostGIS, what if anything controls the direction that topogeometry LINESTRINGs will have when converted to geometry? It doesn't appear to be the order in which the edges are listed in the call to ...
0
votes
1answer
18 views

With schema, function postgis_full_version() does not exist

A rails application is configured to run with postgis. Database.yml is configured as follows: development: adapter: postgis database: app_development username: simpleton schema_search_path: ...
0
votes
0answers
30 views

Error's while retrieving data from postgres to Qgis using python?

This is my code of python in qgis from qgis documentation docs uri = QgsDataSourceURI() uri.setConnection("localhost","5432","gis_data","postgres","vajja") ...
1
vote
0answers
23 views

How raster files are stored in databases?

When storing raster files in PostgreSQL only one row is created in the database, but the raster is a matrix so typically it must create rows and columns. I want to understand how raster files are ...
1
vote
0answers
31 views

Issues creating ArcSDE sde_logfile for certain users (username begins with a numeral)

I am having issues when editing an sde feature class from certain users. The way my database is set up is that the authentication roles are updating constantly by comparing the current authentication ...
5
votes
3answers
106 views

Poor performance with storing large rasters in PostGIS and visualising in QGIS

my question concerns the use and performance of several software tools in conjunction, namely PostgreSQL, PostGIS, QGIS, and GDAL. I'm a long-time ArcGIS, Python, and R user who is interested in ...
2
votes
1answer
292 views

Geoserver OSM data Imported via osm2pgsql - most efficient tables to use to style roads

The Osm2pgsql importer for OSM data to Postgres results in two tables for ways, one called planet_osm_roads and a second one called planet_osm_lines The Osm2pgsql documentation states that the ...
1
vote
1answer
23 views

Get points in a union of circles

I am trying to create a postgis query that would get all the points in an union of circles (possibly more than a thousand of circles with different radius). The circles would be created dynamically ...
3
votes
2answers
148 views

How to classify a raster using QGIS Plugin interacting with PostGIS?

I'm developing a QGIS plugin where users can enter some parameters (like distance, depth, area...) and by submiting the plugin interact with a PostGIS database and extract informations form vector and ...
0
votes
1answer
49 views

Error while connecting qgis with postgres?

sql="select long,lat from poidata.poi_ca from where city LIKE '%unnyvale'" uri = QgsDataSourceURI() uri.setConnection("localhost","5432","gis_data","postgres","vajja") ...
2
votes
2answers
85 views

Problem with PostgreSQL View layer in QGIS

I have a PostgreSQL table and view: CREATE TABLE lines ( geom geometry(MultiLineString,4326), type character varying(254), login text, gid serial NOT NULL, ...
0
votes
1answer
36 views

Issue using pgr_dijkstra from Postgres pgRouting

I am using Postgres with Postgis extension to retrieve streets (only for pedestrian use) and several "natural" points. I need to make updates every minute and i am working on a small bounding box. For ...
0
votes
0answers
16 views

geojson coordinate conversion to the format of the data coming from PostgreSQL?

I use hibernate spatial and geotools this is save to vector code : if (vectorType.equalsIgnoreCase("Point")) { LineString point =new GeometryJSON().readPoint(item.getData()); ...
1
vote
1answer
266 views

Convert native box to geometry

I have an old table that contains bounding boxes of lat long coordinates in a "box" type. How do I convert them to PostGIS geometry ? I tried using ...
2
votes
2answers
268 views

Counting self intersections of linestring using PostGIS?

Is there a way of using PostgreSQL + PostGIS for finding the number of self intersections in a linestring? I have a linestring that goes forward but in circles, and I need to find the number of times ...
0
votes
0answers
30 views

Postgis ST_Azimuth only returning a small range of angles

I have a puzzler with postgis and ST_Azimuth. I have a table of points (taken from country borders, and run through the QChainage plugin). I want to find the azimuth from a fixed point (15.0,50.0) to ...
1
vote
1answer
46 views

Percent total from postgis clip

How would I calculate the percentage of streets that have sidewalks summarized by census tracts using PostGIS. My sidewalks file has an id that links it to its adjacent street and I've worked out how ...
0
votes
0answers
16 views

using changeset for larger region to update OSM data in PostGIS

I'm using the OSM import and update workflow described here to maintain OSM data in a PostGIS database. Import (osm2pgsql): osm2pgsql -c -d gps -U gps --cache 8000 --number-processes 4 --slim ...
1
vote
1answer
39 views

A few PgRouting database design questions

Does someone know how the cost field in PgRouting is calculated? What are 'source' and 'target' good for? 'osm_source_id' and 'osm_target_id' contain the same information using different numbers. Is ...
1
vote
1answer
24 views

How to select from geometry column in postgresql?

I've got a table which it has a geometry column filed by some point (ex. "POINT Z (116.309627 39.991285 148)"). now I want to select point's id from the table. I wrote follow sql Code but I force an ...
1
vote
0answers
16 views

GeoTools How to add attribute to a schema in DataStore

As you know, you can create a schema in a DataStore. For example, you may create a table in a postgresql database like this: SimpleFeatureType schema = ...;// some schema DataStore dataStore = ...
4
votes
3answers
692 views

clustering points in postgresql to create contour map

UPDATE: To try to make this a little more simple, is it possible to create a query which selects a group of points such that each point in the group is at most X units away from at least one other ...
0
votes
1answer
16 views

Intersection of two vector tables data in postgresql

I have satellite raster data is converted in to pixels using create table gtru_tile_pix as SELECT (ST_PixelAsPolygons(rast)).val, (ST_PixelAsPolygons(rast)).geom FROM ...
0
votes
1answer
11 views

pgsql2shp error: table does not exist

I am exporting tables from Postgresql 9.2 to shapefiles using postgis 2.0. I have the same system on other machines and it works correctly. I have tried running the command from a prompt and get an ...