Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [postgresql]

PostgreSQL is an open source object-relational database system.

Filter by
Sorted by
Tagged with
0
votes
1answer
387 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
141 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
580 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
898 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
137 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
249 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
65 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
107 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)...
-1
votes
1answer
251 views

ST_Covers returning false with PostgreSQL/PostGIS

I have two lon/lats that I've turned into geometry. I've tried having the column type being both text and geometry. I have a fence_geom and a user_geom. I am looking to test to see if the user is ...
-1
votes
2answers
428 views

Saving to different schema using Osmosis?

Does anyone know how to use osmosis to save to a different schema? I used the pgsnapshot_schema_0.6.sql to create a blank data table, but it always creates it in the public schema. I need to create ...
-1
votes
2answers
381 views

How to convert WKB to radians or utm in postgresql?

I am using PostgreSQL with postgis, the geometries are in UTM and stored as WKB with several shapes types (point, polygon, linestring...). Is there a way to convert the WKB to a list of points in ...
-1
votes
1answer
32 views

Why the replace function in PostgreSQL is not returning the value?

I am trying to convert state names to abbreviations and I am using the replace function. I am able to run the snippet successfully but names remain the same without being converted to abbreviation: ...
-1
votes
1answer
188 views

Get PostGIS geometry data and display it on map using GetMapRequest

How can I get the data from PostgreSQL db and display on map using GetMapRequest? I have done connecting the PostgreSQL db which contains the geometry data. Now I want to redirect that data to map ...
-1
votes
1answer
160 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
191 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
861 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
877 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
456 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
891 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
117 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
144 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
473 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
0answers
28 views

XSD to PostgreSQL

I want to create from CitygmGML ADE XSD file a PostgreSQL database schema. I have used Altova XMLSpy but the results were not satisfying. Is there a method to do that or a database that is created ...
-1
votes
1answer
207 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
671 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
116 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
672 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
878 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
347 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
116 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
269 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... ...
-3
votes
1answer
902 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
173 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
121 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
487 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
239 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
335 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
181 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
591 views

Creating spatial queries in QGIS? [closed]

How can I create spatial queries in QGIS?
-7
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?