Questions tagged [postgresql]

PostgreSQL is an open source object-relational database system.

Filter by
Sorted by
Tagged with
0
votes
0answers
108 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 ...
0
votes
2answers
240 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
231 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 ...
0
votes
1answer
1k views

In cartodb, how to automatically update the_geom with new longitude and latitude?

I am currently posting new table row using the cartodb sql api with the following commands: update {table_name} set geom = ST_Transform(ST_SetSRID(ST_MakePoint(latitude, longitude),4326) latitude and ...
0
votes
1answer
60 views

Database access pattern using PostgreSQL and ArcGIS

I am planning to connect to a PostgreSQL DBs on a server from ArcGIS on my laptop. My server admin is interested to know "The access pattern: How, when, how often, (would ArcGIS access the DBs) during ...
0
votes
0answers
167 views

Creating a table and inserting selected streets using plpgsql functions

I am trying to select all streets within 50 meters distance from each address location and store them in a separate table using Postgresql (plpgsql) functions. So far, I have written the following two ...
0
votes
0answers
296 views

Database modeling for big data (big set of points X big sets of possible values for each points)?

I'm building a PostgreSQL database with the intent to host modelisation results for different projects. Each project has a set of receptors points (~5000-10000 receptors) and have many results sets (...
0
votes
0answers
175 views

Is it possible to use pgsql2shp utility in PL/pgsql environment?

I intend to use PL/pgSQL to generate calculation points on streets with respect to address locations. I am aware that using pgsql2shp utility, a shapefile can be generate using postgis query. I was ...
0
votes
1answer
168 views

Geocoding addresses based on own reference data

I have a historical addresses dataset in form: |Name |Description | Where "Name" is a single field with house number, street name, city and country. I have digitised two georeferenced ...
0
votes
0answers
74 views

PostGIS - raster coodinates - no result for negative values of GPS

I have data in raster and try to run this query WITH ref As ( SELECT (ST_SetSRID(ST_Point(-20.12, 51.50), 4326)) AS pt ) SELECT ST_Value(raw_data, 1, ref.pt) AS val_0 FROM model_data The problem ...
0
votes
2answers
58 views

Proper handling in PostgreSQL/PostGIS only after many queries?

I am trying to analyze GPS data of a parade on a fixed route with a certain variance due to the urban surrounding (canyoning). I'd like to project the GPS waypoints to the nearest points on the route ...
0
votes
1answer
113 views

Importing information on bridges into postgis-table using OSM2PGROUTING

In OpenStreetMap (OSM) road data there is information about whether or not a road feature is a bridge or not (boolean). However, when importing into a postgreSQL data base for routing (pgrouting), ...
0
votes
0answers
463 views

Unable to install pgrouting for postgres 9.3.5/postgis 2.1.7

I am running postgres 9.3.5 and postgis 2.1.7 on Ubuntu Server 14.10. I am trying to install pgrouting, but having no luck. 1) I tried the following based in the official workshop documentation: ...
0
votes
1answer
713 views

Can't execute a simple psycopg2 script twice when running from ArcGIS Desktop as a script tool

I'm building a geoprocessing service that queries an SDE database (running on postgres) and returns results. I do a lot of development by calling the script from a toolbox in ArcGIS desktop 10.3. ...
0
votes
0answers
357 views

postgis ST_Intersect on 2 valid geometries throws TopologyException

Using Postgis 2.1 on PostgreSQL 9.3.4, I'm getting an error when I try to intersect two valid geometries: TopologyException: found non-noded intersection... These geometries are created on the fly ...
0
votes
1answer
643 views

function st_length3d(geometry) does not exist

Whenever I execute this query: SELECT ST_Length3D(ST_GeomFromEWKT('LINESTRING(0 0 0,5 0 3,5 10 5)')); Postgresql is throwing an error: ERROR: function st_length3d(geometry) does not exist SQL ...
0
votes
0answers
277 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
0answers
63 views

Use of constraints and Spatial indexes in Postgis

We'are using Postgis to manage our geo data. They are coming from several sources, like Open street map, VPF, Shape and so on. We have defined constraints on the tables, and spatial indexes on ...
0
votes
0answers
411 views

MultiPatch Shapefile import into PostGIS Database

I have geometry of buildings in Shapefile MultiPatch format. I want to import it into PostGIS database in the same format. Is that even possible? If yes, then how?
0
votes
0answers
41 views

Display graduated QGIS buggy?

I counted points in polygons in PostGIS like this UPDATE hexagons SET count = (SELECT count(*) FROM points WHERE ST_Within(points.geom, hexagons.geom)); That came back with that UPDATE 1554 That ...
0
votes
1answer
830 views

Create blank table from unix shell

I am in the middle of trying to create my first PostGiS database and seem to be running into problems developing scripts to automate importing the various spatial formats so I can use them in my ...
0
votes
1answer
422 views

how to insert coordinate of province to postgresql?

i need insert to database this area sample: [ [ [ 50.227886556627098, 31.15709614260982 ], [ 50.227886335531331, ...
0
votes
1answer
854 views

find all circles intersecting another in a table [duplicate]

I am using postGreSQL (9.3) and postGIS (2.1). I have a table containing names and circles (point + radius). Given a name and a circle (point + radius), I would like to find all the database lines ...
0
votes
0answers
481 views

How to get elevation of a coordinate given a dtm file out of a PostGIS?

What would be the best way to get elevation of a coordinate out of a PostGIS database (SQL/plpgsql) given a GeoTIFF dtm file? Importing as PostGIS Raster (which seems more costly) and calling ...
0
votes
0answers
58 views

Query processing time for network table creation using pgRouting 1.05

I am trying to follow these steps for creation of a network table using pgRouting 1.05. In my case I have two road geometry tables, one is bangalore_road and the other is all_india_roads. Obviously ...
0
votes
0answers
242 views

Create table into PostgreSql from Geoserver SQL View query

I know how to connect Geoserver to PostgreSql and create SQL View queries with parameters from Geoserver, but ;it is possible to create a new table into PostgreSql from a Geoserver Sql View with ...
0
votes
0answers
67 views

How to create unique plane with PostGIS?

How to create a unique plane, with (x , y ,z) as center and a vector as normal, in PostGIS? I already saw "Make3DBox" function, but it does not make a unique one.
0
votes
0answers
143 views

Routes through centroids and array functions

I have a table stopcentroids4 like in figure with the following fields: gid, routes, geom and i want to draw a line for each route that runs through centroids. In my code there is a mistake. ...
0
votes
0answers
616 views

box2d spatial type

I'm storing data that defines a box. I created a column by adding it to my table as follows: SELECT addgeometrycolumn('grid', 'grid_geometry', 32650, 'GEOMETRY', 2); I then insert my data in using ...
0
votes
1answer
79 views

Is it possible to label a postgis Query Layer in ArcMap?

I've created a PostGIS query layer and I can't label it. I'm trying to work out if I'm dealing with a bug that I can't workaround, a bug that I can workaround, or if it is operator error. After ...
0
votes
0answers
53 views

Connect to PostgreSQL from ArcMap 10.2 failed [duplicate]

I have a database server PostgreSQL and Postgis. I want to connect to database from ArcMap 10.2 , I tried Add Database Connection from arcmap menü. I typed my connection informations and clicked ...
0
votes
0answers
349 views

mysql foreign data wrapper for postgres with parameter substitution

I have created a mysql_fdw for my postgres and when i try to run the one with a subquerry that has parameter substitution it does create a table but on querying the foreign table it throws an error: ...
0
votes
1answer
126 views

Function get_partition(geometry, unknown) does not exist - Nominatim tiger data import

Ive install Nominatim with postgres9.3 and postgis 2.1, imported osm data ok and now trying to import tiger data (tiger2013 edges) for the house numbers. The import looks to go ok, but there is no ...
0
votes
0answers
83 views

Postgresql (soln would be basic SQL I think): ORDER by distance to a point and return those distances in array pairs w/ the full records

so I know there have been some questions asked about how to calculate distance using postgis and how to order results by their distance from a respective point. I'm not very talented at SQL (at all) ...
0
votes
3answers
783 views

Faster routing algorithm on pgrouting [duplicate]

I have downloaded data for india as a dbf file then converted it using osm2po to make it routable but the problem is when i make any routing query it takes a lot of time around 300 seconds and these ...
0
votes
1answer
226 views

Visualizing information when click in polygon‏ - Spatial join

I am new to cartodb, right now I am trying to do something similar to the cartodb tutorial: Create your first map with CartoDB.js, but with polygons using my own map. For example: I did a spatial ...
0
votes
1answer
1k views

ogr2ogr DXF to PostgreSQL some LINESTRING coordinates mirrored to the negative longitude

I have been using ogr2ogr GDAL tool to migrate geospatial data from DXF file to PotgresQL database without much problems. But now there is a special problem I can not fix. I have a DXF file with ...
0
votes
0answers
37 views

How to install PostgreSQL and PostGIS on Ubuntu 13.10? [duplicate]

I have upgraded my OS from Ubuntu 12.10 to 13.10. I had a clean installation of 13.10 version. Can someone please suggest which version of PostgreSQL and PostGIS can be installed on Ubuntu 13.10 ...
0
votes
1answer
410 views

Is it possible to install the PostGIS to the PostgreSQL (binary version)?

I'm using the PostgreSQL 9.2.4 which is the no installation version.I run this by using the command "Program Files/PostgreSQL/9.0/bin/pg_ctl" -D "Program Files/PostgreSQL/9.0/data" -l "Program Files/...
0
votes
1answer
400 views

Geodjango InspectDB Fails on Postgis Raster_Columns View

I am trying to generate models for an existing Postgresql database using the Django InspectDB command. Models are produced but a failure occurs on the raster_columns view. The error is: Exception: ...
0
votes
0answers
143 views

Shooting star algorithm in postgres 8.4 and postgis1.4 showing fatal error and remaining are working fine

When I try to run this shooting star algorithm, the postgis suddenly loosing connection to postgres and showing error no connection to server SELECT * FROM shortest_path_shooting_star(' SELECT gid ...
0
votes
1answer
585 views

What Spatial Reference System do I store Google Map's Lat/Lng in [duplicate]

I am new to PostGIS, Spatial Reference Systems and projections and want to store lat/lng coordinates retrieved from Google Maps and its services like the Geocoder. I'm working with data in America and ...
0
votes
0answers
1k 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 ...
0
votes
1answer
922 views

Eclipse can't find Driver.class from postgresql-9.2-1002.jdbc4.jar file nor AbstractJdbc4Connection class

I am using the jar file in my configuration path after following the example from postgresql/jdbc tutorial. But after I added the jar file and configured it for my reference library when I run it I am ...
0
votes
1answer
140 views

Calculating spaces between roads from PostGIS database? [duplicate]

Is it possible to calculate the spaces between the roads using a select statement in a PostGIS/PostgreSQL Database? I tried using some combinations of the predefined functions as ST_Intersects & ...
0
votes
1answer
65 views

Enable users to read data from postgis-database using QGIS

I have uploaded a geojson file to a fresh Postgis installation with ogr2ogr following this example here. I than created a new psql user for my colleague without any special rights but afterwards I ...
0
votes
1answer
260 views

Open source UML modeling software (GIS)

I am wondering is there any opensource UML to Postgresql Mysql tables conversion software which also includes the geospatial datatypes ? Note:I want conversion from UML to database. and NOT ...
-1
votes
1answer
68 views

PostGIS problem finding FK to PK [closed]

I have 2 tables in a postgres db to which I need to establish a 1-m relationship between. One of the tables has geometry, the other table does not have geometry but contain fields that describe the ...
-1
votes
1answer
238 views

Using PostgreSQL as database with ArcGIS Pro? [closed]

I've been with my current job for 2 years now and have been using QGIS with PostgreSQL. We are currently testing ArcGIS Pro noticed that I can connect to my PostgreSQL database that I was using on ...
-1
votes
1answer
114 views

Populating a table-postgis

I had two tables, one with polygons and one with points. The table of points had the attributes of value and time. I created a new table at postgis with this query SELECT polygon.gid, time, avg(value)...