PostgreSQL is an open source object-relational database system.
0
votes
2answers
24 views
PostGIS query to retrieve the largest polygon for multi-polygons by grouping on attribute field
I'm working with the Natural Earth 10m Admin 1 States Provinces polygon data. This dataset contains multi-polygons for each state / province in the entire world. What I'd like to do is to grab the ...
1
vote
1answer
37 views
Creating geodatabase administrator account other than SDE?
I need to create another account other than SDE and make it geodatabase administrator. Is it possible?
I have already created another account and have given SUPERUSER priviledge. However I cannot do ...
0
votes
0answers
15 views
Copying File Geodatabase to PostgreSQL using ogr2ogr?
I am trying to export Feature Classes and Tables from GDB to PostgreSQL.
I am using ogr2ogr tool to export from GDB to PostgreSQL. I am using following method:
ogr2ogr -f "PostgreSQL" ...
2
votes
1answer
50 views
How to update a postgres/postgis table periodically with multiple data?
I have created a postgis table from point.shp with 5 fields containing 20 records. Now I want to populate the table with another 150 records keeping the previous 20 records so that the total records ...
1
vote
0answers
94 views
+50
How can I generate a specific number of random points in a polygon with PostGIS?
I have a postgis table that I've uploaded a shapefile to, this shapefile contains 200+ polygon rows with several integer columns.
What I'd like to do is similar to the QGIS 'random points in polygon' ...
0
votes
0answers
31 views
Postgres PostGIS geocode_intersection()- How to handle exception?
I have a table in Postgres with a set of records that are street names which needs to be geocoded to get an intersection point.Some of the records would be bad input and when using the ...
1
vote
0answers
8 views
Import postgis layer from S3 link
I have a postgis layer (layer.sql), which I am trying to add to my postgres database (mydatabase). The postgis layer is stored on S3 (https://s3.us.../layer.sql). I can add the layer to my database ...
0
votes
1answer
44 views
from two tables make a new one
I have two tables both of them has linestring geometry. I try to make a new one which contain the first one and from the second take only the decimal v when the linestring of the first table touch a ...
0
votes
0answers
26 views
PostGIS Clustering. Group by geographic point location proximity
I have a table where i keep user's location history. The system gets user's current location each minute and writes it into "user_locations" table.
Later on; when showing the locations that the user ...
2
votes
2answers
30 views
Combining ST_Touches and ST_Buffer
I'm looking for a PostGIS/Postgres query thats a bit tricky.
I want to find all polygons within a specified radius and all neighboring polygons to the polygon where I have my coordinates
SELECT *
...
0
votes
0answers
28 views
Use postgis functions in restful web service java
I am trying to access Postgis functions in Restful web service JAVA.
I am using netbeans 8.0.2, Glass Fish, J2EE 7 to create web service, PostGres 9.2 and postgis 2.1.1. Connection to postgres is ...
0
votes
0answers
35 views
How to use interacting PostgreSQL/PostGIS triggers in QGIS?
I use point geometries (table 'label_point') to place multiple labels on polygon geometries (table 'soil'). After doing layer edits I've to update the affected label_point features. Therefore I've ...
0
votes
2answers
40 views
How to create a bounding box around a point using postgis
How to create a bounding box around a geom (POINT) and find all the intersecting geoms(POINTS) within that bounding box?
Thanks in Advance
1
vote
2answers
24 views
Getting year from a field of type character varying
I did an intersection between two tables and the resulting field has an sdate of type character varying (29). An example value is 2012-01-13 05:00:00. How do I get just the year from it?
I want to ...
1
vote
1answer
45 views
PostgreSQL 'forgot' PostGIS functionality
System details:
PostgreSQL 9.3.5 64bit on Windows 7 Ultimate;
PostGIS 2.1.3
Two days ago I re-organised my schema structure - effectively moving a series of tables of the form ...
1
vote
2answers
35 views
Intersection between line & polygon in PostGIS?
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 ...
3
votes
1answer
39 views
Adding vertices to polygon in PostGIS?
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
27 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 ...
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 ...
3
votes
2answers
53 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
1answer
37 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 ...
-1
votes
2answers
120 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, ...
0
votes
1answer
27 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
36 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 ...
1
vote
1answer
27 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 ...
0
votes
1answer
39 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 ...
0
votes
0answers
27 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
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
59 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
2answers
60 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,
0
votes
1answer
20 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 ...
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 ...
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")
...
0
votes
1answer
21 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: ...
1
vote
0answers
41 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 ...
1
vote
1answer
25 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 ...
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")
...
0
votes
1answer
43 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 ...
2
votes
2answers
94 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
0answers
22 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());
...
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 ...
0
votes
0answers
19 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
25 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 ...
0
votes
1answer
17 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 ...
1
vote
1answer
45 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
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 ...
1
vote
0answers
17 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 = ...
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 ...
3
votes
2answers
149 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 ...
