PostgreSQL is an open source object-relational database system.
0
votes
1answer
5 views
PostGIS update SRID
learning PostGIS, I have a table called nyc_neighborhoods and I want to update the SRID number to 26918
SELECT update geometry SRID(‘nyc_neighborhoods’,’geom’,26918);
this is my query..it is ...
1
vote
2answers
28 views
Select point features using spatial query
I have two postgres tables, one polygon features and second point features, having same projection.
What i want to do is to select only the points which contains in large polygon and does not contain ...
0
votes
0answers
6 views
Owner's Features are NOT editable through Feature Service w/ Ownership-Based Access
Feature service with Ownership-Based Access enabled properly filters records based on ownership but does does not allow editing of owner's features.
Feature Service Operations Allowed: Create, Query, ...
1
vote
0answers
29 views
Custom pyQGIS function returns NULL
I've made a python function that returns the user logged in a postgis layer:
from qgis.core import *
from qgis.gui import *
@qgsfunction(args='auto', group='Custom')
def getUser(lay, feature, parent)...
0
votes
1answer
19 views
How to use pgr_dijkstra many-to-many
I am using pgr_dijkstra(or pgr_dijkstraCost) to find the shortest path and/or cost for drawing isochrone map. Since I need to calculate the shortest path from each of over 100,000 nodes to multiple ...
1
vote
0answers
21 views
Data Store error when registering a database in ArcGIS
I am using ArcMap 10.3.1 and have downloaded the PostgreSQL 9.3.5 files from MyESRI.com. PostgreSQL is installed locally for testing purposes. I have everything working smoothly and am attempting to ...
0
votes
1answer
28 views
How to get part of a linestring that is less than 300 meters apart from another linestring?
I've two linestrings Line1,Line2. I'm trying to get the part of Line1 that is 300m apart from line2.
line1 = "LINESTRING(72.863221 18.782499,72.863736 18.770147,72.882275 18.756169,72.881417 18....
1
vote
1answer
32 views
Has the function srid(geometry) been removed or has the name changed?
I am in the process of restoring a database that relied on PostGIS version 1.5 functions to a newer Postgresql engine that leverages PostGIS 2.2 functions. In my restore process, I receive the ...
0
votes
1answer
26 views
How to do an Overall Minimum Bounding Rectangle from a Python List of MBRs?
I've converted an ESRI GDB file over to a PostgreSQL DB and went through all the layers now expressed as tables.
I originally looked here but realized that having ~ 49 tables / layers would get hairy:...
1
vote
0answers
24 views
no layers after connected to Postgres using GDAL 2.1 c++ API
I connect to Postgres using GDAL 2.0 API using the function GDALOpenEx() as below. But when I use poDS->GetLayerCount(), it just returns 0. My Postgres(v9.5) has a database name postgres, and the ...
4
votes
0answers
68 views
Is there an Algorithm to detect circling and the beginning and the end of a circle?
I've got lots of flight data from glider pilots in the form of gps fixes in a fixed interval.
I would like to analyze the flight path and detect the start and the end of the 'circling' the glider ...
1
vote
1answer
46 views
Many-to-many relationship and QGIS Forms
I have a PostgreSQL/PostGIS database with a base table (Pois_points) and two subtables which constitute a many-to-many relationship with the base table, as you can see on the picture below (click on ...
0
votes
1answer
34 views
I have tried gdal builidng from source and rpm and still get the following error trying to create the postgis extension
create extension postgis;
ERROR: could not load library "/usr/pgsql-9.5/lib/rtpostgis-2.2.so": /lib64/libgdal.so.1: undefined symbol: atom_obj_cache
1
vote
1answer
42 views
ST_GeomFromText not found
I installed Postgres 9.5. Then I installed PostGIS. Then I created database named geodb. In it I created column with type polygon and several others like id.
Table polygon was created successfully, ...
0
votes
1answer
21 views
Making flood layer geojson into single featurev like ST_collect in PostgreSQL in openlayers 3 with JSTS?
I have read one geojson file using JSTS now all my features in the geojson file are comming as individual features. Now I want to convert all features into one collected feature like in postgres ...
1
vote
2answers
69 views
Saving select query results (year wise) from PostgreSQL/PostGIS to text files
I have two spatially enabled tables 'bar' and 'foo' in my PostgreSQL 9.5 (x64) database. Table 'bar' contains 87 rows and 'foo' contains 16,060 rows. For each address location (foo.gid), following ...
1
vote
1answer
29 views
Browser display nothing when debugging leaflet api file to connect to geoserver
actually here is url of geoserver on which my map is published:
http://localhost:8081/geoserver/test/wms?service=WMS&version=1.1.0&request=GetMap&layers=test:city_limit&styles=&...
1
vote
1answer
27 views
Import Foreign Schema Fails with “schema postgis does not exist”
I am connecting to a Postgres 9.4 foreign server instance where Postgis 2.1 was installed using CREATE EXTENSION postgis WITH SCHEMA postgis from a Postgres 9.6 Beta where Postgis 2.3dev was installed ...
1
vote
1answer
27 views
Displaying features on JMapPane in GeoTools from postgresql database table geometry column?
I am making a GIS maven project in GeoTools.
How can we display data from the postgresql database in geotool?
Presently I can display the shape file from the file path, but I want to display this ...
0
votes
0answers
14 views
customizing Map through leaflet api [duplicate]
I have created a database on Postgresql and connected it with geoserver and then after that i have published the map on geoserver and layers can be viewed.
Now i have to customize a map through any ...
1
vote
1answer
40 views
Find closest location to given point within distance
I have table location with column geo_data with DDL:
CREATE TABLE location
(
id INTEGER PRIMARY KEY NOT NULL,
geo_data GEOGRAPHY(GEOMETRY,4326),
);
CREATE INDEX index_location_on_geo_data ON ...
1
vote
0answers
31 views
Wampserver Error Notice: Undefined offset: 1 in C:\wamp\www\index.php on line 64
In order to change phpmyadmin to phppgadmin in wampserver , I edited the file "www / index.php" Wamp and duplicate each line MySql adapting with version of PostgreSQL
i have error Notice: Undefined ...
1
vote
1answer
35 views
Slow performance viewing attribute table of PostgreSQL/Postgis views in QGIS 2.14
A Postgis view was created with a query that executes in about one second.
It is a parcel layer composed of about 20,000 polygons (the original layer loads without any problems).
When loading this ...
0
votes
1answer
41 views
Unable to use pgRouting Layer QGIS plugin with osm2po tool (database connection error)
By following these amazing tutorials of Anita Graser An osm2po Quick Start and pgRouting on OSM using osm2po, I was able to use osm2po tool successfully on Windows 7 (x64) with PostgreSQL version 9.5 ...
0
votes
0answers
2 views
column {table_name} of relation {table_name} does not exist SQL state: 42703 [migrated]
I am getting this error while running update query with table name specified along with column name.
Query:
UPDATE Temp SET Temp.Id='234',Temp.Name='Test'WHERE Id='245'
I am getting the below error ...
1
vote
3answers
67 views
“libSFCGAL.so.1: undefined symbol” upgrading to Postgis 2.2.2 (and 2.2.1)
I recently got PostGIS upgraded to version 2.2.2. I would like to upgrade a legacy database to this new version, running this query:
alter extension postgis update to "2.2.2"
The result is this ...
0
votes
1answer
32 views
Calculate percentage of parcel area covered by wetland
Still a little new to Postgis. I'm trying to calculate the percentage of a wetland layer that intersects with a parcel layer. The desire is to eventually add "percent_wetland" to the parcel layer, but ...
0
votes
0answers
15 views
Create a geographic polygon for point selection based on a topology of Tiger road segments?
I'm building up a library of territory boundaries (closed polygons) for use in many aspects of structure, population, and use case management. I'm starting with a single territory but I have the whole ...
0
votes
1answer
36 views
find polygons within a radius of one point (of a table of points)
I'd like to perform a select by location analysis in PostGIS that first selects the geometry of ONE point out of a table (of many points). Creates then a circumference around it and checks which ...
0
votes
0answers
22 views
TopologyException: side location conflict with ST_Intersection in postGIS
PostGIS returns an error
ERROR: GEOSIntersects: TopologyException: side location conflict at 1006131.4037998166 193416.31115400587
CONTEXT: PL/pgSQL function _st_intersects(geometry,raster,...
1
vote
1answer
42 views
Unable to test pgr_dijkstra algorithm in pgRouting 2.1.0
I am using PostgeSQL 9.5 and pgRouting 2.1.0. I am trying to test pgRouting tool in my postgres DB by following this tutorial pgRouting 2.0 for Quick Windows Guide. Although the tutorial assumes road ...
1
vote
0answers
27 views
Why is GeoDjango not able to query geom column from PostGIS?
I'm using postgis and (geo)Django to build a web app. I've imported a shapefile into postGIS and used inspectdb to create the model. models.py looks like this:
from __future__ import unicode_literals
...
0
votes
1answer
40 views
Using Fiona to Convert file geodatabase to PostgreSQL / PostGIS?
Is there a way to use Fiona instead of OGR to convert a GDB over to postgresql / postgis within Python? If so, how or where can I look? I cannot seem to find this within the Fiona site or by simply ...
0
votes
1answer
41 views
Optimizing PostGIS query
I've a query that has to be run against 1 million records. The query finds the intersection between two polygons and the area of the result of the intersection. Here's the query:
SELECT
ST_Area(
...
2
votes
2answers
47 views
Order in PostGis multipoints
I am using PostgreSQL (9.5) and PostGIS (2.2.2).
I need to create a multipoint geometry while keeping track of the order of the points. (I would assume the point order to be the same order as the one ...
0
votes
0answers
53 views
Limitations of PostGIS Shapefile Import GUI tool?
I would like to improve my knowledge regrading this issue.
I am using PostgreSQL version 9.5 (x64bit) on Windows 7 Enterprise (x64bit Machine). I have a table containing 3515214 rows of X,Y ...
2
votes
3answers
141 views
Prevent export to shapefile from postgis table in QGIS
I have created a centralized database using postgreSQL and created multiple users assigned with different roles i.e. SELECT, UPDATE, MODIFY and DELETE etc.
Example:
CREATE USER hasan WITH ...
1
vote
1answer
24 views
Geoserver not recognizing jsonb attribute in SQL view of PostGIS db
I have an instance of Geoserver 2.8.2 running and a PostGIS database. I am attempting to create a FeatureType based on an SQL view of the following table (viewed through psql \d):
...
0
votes
1answer
30 views
Union PostGIS tables turns blank
I have a simple tasks that regarding combining multiple Postgis tables. Let's say I have 4 tables called tx_shape, ca_cd_1_shape,wy_shape, and ma_suffulk_co_shape. Two of which are states, one is a ...
0
votes
0answers
12 views
Error while creating development user CartoDB
While creating development user I get this error:
[pool] Found a connection for localhost:cartodb_dev_user_ec9cc5c4-2863-4fc6-acbf-95bcb52ea902_db:5432:postgres:sequel (4)
(0.000178s) BEGIN
PG::Error:...
0
votes
1answer
33 views
Odbc_fdw.control is missing
I am using cartoDB and Postgres 9.3 including PostGIS. When I try to create development user in cartoDB I get this error:
'CREATE EXTENSION IF NOT EXISTS odbc_fdw SCHEMA public;'
ERROR: could not ...
0
votes
1answer
38 views
Filling Colors for Some Countries in Carto
I imported the "world borders" from the data set library in Carto. I want to fill/highlight some countries (say United States, Africa and Europe) with the same color but not all countries. How can I ...
1
vote
1answer
18 views
Changing projection of PostGIS data? [duplicate]
I have exported osm data using osm2pgrouting in the database, it has SRID 4326. I want to change projection of all the tables created to a particular SRID in UTM.
I read the post FIrst and Second, ...
0
votes
1answer
20 views
Cannot load postgis query as layer in QGIS using create table command
I've a multilinestring object and a points object , where the points are located on the line. The user can set a start and end point on the line and my goal is to return a subset of the points that ...
0
votes
1answer
35 views
Make certain countries visible on Carto map
I want to show only APAC countries on the carto map. I re-wrote my SQL query (see below) and clicked 'create a dataset from query'. Although the countries specified were coded in colors, those outside ...
0
votes
1answer
39 views
carto.com when 2 points have the same location
Carto.com: We are mapping homicides and when two deaths occur at the same location, how do I prevent 2 points with the same lat, lon from overwriting each other? I want to be able to view each point ...
0
votes
0answers
32 views
Strange behavior of ST_length and ST_difference in POSTGIS
I've a LINESTRING that represents the route between Los Angeles and Austin. I calculated the total length of this linestring using ST_Length. Then I calculated the difference between a MULTIPOLYGON ...
1
vote
1answer
85 views
Restoring PostGIS 2.1. dump in PostGIS 2.2
I tryed to restore my old PostGIS dumps (Postgis 2.1, PostgreSQL 9.1) at my new system (PostGIS 2.2 and PostgreSQL 9.5)
I was using pgadmin3 to dump the databases and was now trying to restore it ...
1
vote
1answer
26 views
Setting names for attributes in properties in json returned by postgresql
I am trying to make a webmapping app that uses on the server side node.js and postgresql(PostGIS). what I am doing is retrieving data from the Postgresql database using node.js and sending the result ...
1
vote
2answers
38 views
Unable to insert data into table using geocode()
I am new to the world of PostgreSQL.
I am using PostgreSQL 9.5. I have installed PostGIS 2.2.2 plugin and along with that came Tiger, Tiger_data schemas. But the Tiger_data schema does not have any ...
