Questions tagged [postgresql-9.6]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
36 views

PostGIS ST_Within processing speed

I've created an SQL script that selects a given set of polygons ("v_rag_RenouvellementClaim") that are completeley within a specified buffer ("v_rag_RenouvellementClaimGrtr25000_Buffer") using PostGIS ...
2
votes
1answer
85 views

ST_Transform not working locally

I am using PostgreSQL 9.6 and PostGIS extension 2.4.4. On my machine, I get an error while running ST_Transform query: SELECT ST_Transform(ST_SetSRID(ST_MakePoint('27.9252', '-26.0987'),4326),32619) ...
0
votes
0answers
18 views

Deleting users and roles on ArcSDE for PostgreSQL geodatabase?

I can easily create users and assign them to roles using the context menus in ArcCatalog or the geoprocessing tools, but how do I delete users and roles? Do I have to go into pgAdmin?
1
vote
2answers
962 views

How get intersection of polygons in the same table by PostGIS?

I have a single table of over 1000 polygons in postgreSQL (with PostGIS), and I have a field "evaluation_type" that only receives two values, either 'good'(green) or 'bad'(red), as you can see in the ...
0
votes
1answer
258 views

Postgis 2 - ST_area : huge difference between 3857 and 4326

I've been doing tests between projections with Postgis 2.3 and I was surprised by the result of the ST_area function with the Web Mercator projection (3857). Here is a sample query and result on a ...
0
votes
2answers
62 views

Problem While Selecting from table using ST_Transform

This following query is not returning any values SELECT * FROM leads WHERE leads.latlong && ST_Transform( ST_MakeEnvelope(78.2137, 12.5186, 78.2460, 12.5419, 4326),3587); Results like: ...
2
votes
1answer
252 views

Using a subselect for ST_Distance query

So I am at a bit of a loss here, trying to get the distance in meters between a point stored in my table and a set of coordinates locations id | name | location(point) ---------------------...
1
vote
1answer
709 views

Using Python Subprocess module to import shapefile into postgres

I am trying to use your mentioned code..but getting an error. The code used is mentioned below: import os import subprocess cmd = 'shp2pgsql -s 4326 E:\Forest\ForestFire\28052018\...
2
votes
0answers
95 views

Creating a trigger containing St_intesects in Postgres

I am new to SQL. I need a help creating a simple trigger function that can contain records from a intersection. I have points layer(vnp14imgtdl_nrt_global_24h) and a polygon boundary(states). The ...
0
votes
1answer
161 views

How to publish a postgis layer to geoserver?

Now my geoserver is on the amazon instance and the postgresql is on the other Amazon RDS. I have try the way provided by official document, but it always show the errors as following: "Caused by: ...
1
vote
0answers
175 views

Using CASE WHEN condition in PostGIS?

I'm trying to assign weights based on intersection of two layers. Below is my query SELECT count(*), -- total number of grids in a postcode CASE WHEN st_intersects(centroids.geom, urban.geom) ...
3
votes
2answers
1k views

Inserting Geometry [] using PostGIS?

I am trying to figure out how to insert Geometry Array in Geometry [] column in PostGIS. CREATE TABLE public.array_data_demo ( id bigint PRIMARY KEY, txt_arr text[] COLLATE pg_catalog."default", ...
1
vote
2answers
300 views

Postgis geometry creation of polygon from geojson

I am working on postgis and was ran below query but i have my doubts Is the below representation valid ? As far as I know the polygon must have 4 coordinates. SELECT ST_GeometryType ( ...
1
vote
1answer
85 views

How to do intersection/union across all tables in schema?

I have a schema with multiple tables, all of which have a particular field, let's call it foo. They all have geometry wkb_geometry and unique key ogc_fid. I need to create two new tables that would ...
2
votes
0answers
120 views

PostGis st_dwithin super slow when inserting

I am trying to insert the newly obtained data from st_dwithin into a new table. However, it has been running since 1 day and I still can't get any data into the new table. Can i know what is the ...
2
votes
1answer
441 views

Connect PostGIS with ArcMap

I want to connect a PostGIS database to ArcMap 10.4. I work on Windows 7 with a PostgreSQL 9.6. Interoperability extension is installed and activated. I can see the PostGIS layers in the Catalog. I ...
1
vote
0answers
92 views

Deleting/identifying near-identical linestrings in PostGIS? - EDITED

I am trying to process a road network file in which certain road links have near-identical duplicates/neighbours. By "near identical" i mean 2 Linestrings may share the same centroid but have start/...
2
votes
1answer
108 views

Creating a table from the result of ST_DumpValues()

I have, I believe, successfully loaded a raster into my PG DB. I see the table in PGAdmin but am unable to see it in QGIS. The table in PG has 1 row. Running, e.g. st_count(rast) on the table returns ...