Questions tagged [postgresql]

PostgreSQL is an open source object-relational database system.

Filter by
Sorted by
Tagged with
-1
votes
1answer
146 views

raster2pgsql error: “ERROR: malformed record literal: DETAIL: Missing left parenthesis.”

This is a command I use to upload dem.tiff into PostGIS database: $ raster2pgsql -a "/path/to/dem.tiff" -F test_schema.raster2 | psql -h localhost -d pisl -U postgres However, I get the following ...
-1
votes
1answer
171 views

Splitting points from GeometryCollection?

I am using PostGIS ST_ClusterWithin function for clustering: SELECT row_number() over () AS id, ST_NumGeometries(gc) as total, ST_AsGeoJson(gc) as geo_collection, ...
-1
votes
1answer
59 views

Newbie, for GIS (need wander path, trail data) [closed]

I need Greek wander paths of places like mountains and forests as shapefiles, but I don't know how to start to extract them from specific sites or getting them ready as shapefiles. I need these data ...
-1
votes
1answer
810 views

How postgresql gets time zone from my data? [closed]

I have a set of data containing latitude, longitude value, time and some other my application oriented values. In my application, a device is doing a job in a particular location during some time. So, ...
-1
votes
1answer
822 views

How to calculate shortest path using pgrouting 2.1?

I installed postgresql 9.1.12 & created database "mydb" with user "abc" as below: sudo apt-get install postgresql-9.1 postgresql-9.1-contrib postgresql-9.1-postgis and created databse "mydb". ...
-1
votes
1answer
448 views

SQL multi shortest path query (A* algorithm)

I am applying multi shortest path query however the SQL query indicate an error! SELECT "n1-centroid-shp".gid, "n1-centroid-shp".geom, "n1-desti-shp".gid, "n1-desti-shp".geom FROM ...
-1
votes
1answer
866 views

postgis/postgres ST_Distance and GROUP BY

Trying to find the nearest road to a postcode point and order the results by distance. The roads are named according to UK convention so A606 etc and there are multiple entries for many road numbers (...
-1
votes
1answer
113 views

Duplicate Points [closed]

How to find duplicate points(poi) in an area by creating a radius for each points and Return all results within a specific radius?
-1
votes
1answer
40 views

Adding data column by column in postgreSQL database

I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file ...
-1
votes
1answer
140 views

Rotate Polygon to be Parallel with the X Axis

By default, PostGIS calculates the Envelope or Extent of a polygon based on the bounding box of the polygon ((MINX, MINY), (MINX, MAXY), (MAXX, MAXY), (MAXX, MINY), (MINX, MINY)). This gives a result ...
-1
votes
1answer
180 views

How to import data into a table from another similar table?

I am working with PostgreSQL to import a table from a .shp file and my task is to populate another table (same attributes as this .shp table) with the data of the table of the .shp file table that i ...
-1
votes
1answer
53 views

Migrating Data to Another Database whit FDOToolbox [closed]

I want to migrate my data (Shapefile) to a PostgresSQL using a FDOtoolbox , i searched a tutorial for that but i dont found it . can any one explain the steps to do for migarte the data from a ...
-1
votes
1answer
460 views

Internal server error using a combination of Geoserver, PostGIS and Leaflet

I have been using the getfeatureinfo operation on layers published from shapefile and it works however the data which is being served from within PostGIS throws an internal server error. I am not sure ...
-1
votes
1answer
131 views

How best to divide line features into equal parts and create continuous buffer zones for them using Postgres/PostGIS and QGIS [closed]

Having familiarized with an similar question specified on the link Dividing a buffer into segments based on path and distance, the author asked an analogous question whether it is possible to solve ...
-1
votes
1answer
662 views

US Census Geocoder returns different city that TIGER Shapefile data

When I geocode an address using PostGIS+TIGER 2013 I get a different city than what Census Bureau Geocoder reports. The Long/Lat are identical in both cases, but the PLACEFP is different although both ...
-2
votes
1answer
112 views

Connect shapefile from postgres in qgis [closed]

Why do not show the shapefile imported in postgres to qgis conection? how its possible to make a new database and import new shapefile ? How to set SRID projection to a shapefile ? I try to import a ...
-2
votes
1answer
668 views

how to build and install pgrouting-2.0 on postgresql-9.3 on ubutntu 12.04 Lts precise? [closed]

I try to build following instructions from this link https://github.com/pgRouting/pgrouting after downloading from the github. I have done the cmake command and there is my error output: ~/...
-2
votes
1answer
51 views

Qgis 2.0 and conection with Postgres 9.3.2 [closed]

I tried conection with Qgis 2.0 with Postgres 9.3.2 but I was unable to do it. Can anyone help me?
-2
votes
1answer
869 views

How do I set the protocolVersion using the jdbc postgres driver? [closed]

I attempted to concatenate a string to the url parameter of the below in order to set the protocolVersion, but I'm not sure how to keep the string in the url without altering the name of the database, ...
-2
votes
1answer
306 views

Leaflet map with toggleable overlays - reading in data from a PostgreSQL database

I have a Leaflet map with several sets of points read in from a PostgreSQL database. I would like to make each of these collections an overlay that I can toggle on and off. Without having overlays I ...
-2
votes
1answer
112 views

Loading LIDAR data to POSTGRES and use it with DJANGO [closed]

I have some project at the Faculty and I don't know from where to begin. I have point cloud data (LIDAR data) and I need to make the website with that data on it and with functions for some sort of ...
-2
votes
2answers
12k views

Postgres error: fatal role “username” does not exist [closed]

I by mistake installed PostgreSQL twice, uninstalled one, and now I am trying to create a new PostGIS connection in QGIS but receive the following error when testing the connection: fatal role "...
-2
votes
1answer
267 views

opengeo suite and pg_hba.conf [closed]

I need help with how to add access to my computer. When I edit the pg_hba.conf i still get the access denied error. I just want to give a specific ip access to all db and all users from that ip... ...
-2
votes
0answers
14 views

PostgreSQL command to get the agg_cost value [closed]

Can someone guide me on how can I pass the agg_cost value to a variable from PostgreSQL?
-3
votes
1answer
822 views

ERROR: syntax error at or near “group” LINE 4: …E ST_DWithin [closed]

I'm writing an SQL query but I am getting a syntax error on the line with the GROUP BY. What can possibly be the problem? UPDATE intersection_points i SET nbr_victimes = sum(tue+bl+bg) FROM ...
-3
votes
1answer
130 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 ...
-3
votes
1answer
120 views

Fractional Area Calculation

I have a file (in both raster and vector) of different districts in a country. I have also made a grid of 1 deg * 1 deg (both vector and raster) of the country. I want to calculate the area of each ...
-3
votes
2answers
76 views

How can this Postgresql be solved [closed]

I am new in Postgrsql. I am trying to Insert few records in a column. I have a where condition. I am trying the following code INSERT INTO table_name(column_one) VALUES ('1000') (SELECT * ...
-3
votes
1answer
130 views

Extract coordinates from postgres [closed]

I'd like to know how can I extract coordinates from "geom" column to this format: For example: [-37.8839, 175.3745188667].
-3
votes
1answer
475 views

How do you combine multiple spatial functions in one query?

I want to find out the intersection and difference in the same query using postgresql. How can I combine both st_intersect and st_Difference in same query and return the result.I want to compute the ...
-4
votes
1answer
207 views

PostgreSQL query to C# [closed]

So I have this query in PostgreSQL: SELECT * FROM "Database"; Which works great, but now I want to do a more complicated query and I have no idea how. So how can I write this Query in C#: SELECT *...
-4
votes
1answer
313 views

How to use st_touches to get all nearby states [closed]

I have a table with all US states geometrical data: USstate ------- state | The_geom (here filling in random value) AL | 00012312 NM | 000234234 NJ | 0000234534 NY | 00005465 ...
-4
votes
1answer
171 views

Make connection from Postgresql to QGIS? [closed]

I'm still new in QGIS. I want to add data from one layer to another layer in QGIS. How could I accomplish that?
-5
votes
2answers
586 views

Creating spatial queries in QGIS? [closed]

How can I create spatial queries in QGIS?
-8
votes
2answers
1k views

What is the difference between PostGIS and PostgreSQL? [closed]

I do not understand the difference between PostGIS and PostgreSQL. What is the difference in detail between them?