Explore our sites

Stack Exchange
tour help
careers 2.0

Tagged Questions

0
votes
0answers
16 views

PostgreSQL 9.3 - PostGIS 2.0 installation failure

My webhosting company has installed postgreSQL 9.3.2 (on a Centos 5.1 VPS that is running Cpanel), but they have given up on trying to install postGIS 2.0.4. CREATE EXTENSION postgis; works, but ...
0
votes
1answer
12 views

Error installing PostGis on Debian

Hi I am in the process of installing PostGis over psql on a Debian machine (actually crunchbang). I have completed the following steps: $ wget ...
1
vote
1answer
27 views

Passing a function name as argument

While trying to deal with GEOMETRYCOLLECTION in PostGIS, I've found here what seems to address the conversion of GEOMETRYCOLLECTION into simple GEOMETRY, but it only works with the ST_Intersect ...
1
vote
0answers
51 views

PostgreSQL backup and restore

I'm having trouble restoring a PostgreSQL backup. On my own computer I dump a table using the custom backup format. On the server, I try to restore the file but it gives me several errors: ...
0
votes
1answer
36 views

saving point type data to pg server

I have a function in postgres that inserts data to a table, and one of the columns is of type point. I don't know how to save my gotten data to an acceptable form for the function to save my data. ...
2
votes
1answer
63 views

Grouping variably contiguous timestamped records with spacing threshold

I have a sequence of intermittently spaced GPS coordinates with timestamps. I'm using PostGIS to render them onto a map canvas. To render them, the points need to be aggregated into lines using the ...
1
vote
0answers
33 views

JPA entity with Glassfish 4 and Postgis

I'm trying to create a JPA entity with glassfish 4 using Postgres 9.1 and Postgis 1.5. I've create/configure a datasource in glassfish by adding the postgres-jdbc and postgis-jdbc jars into the ...
0
votes
0answers
23 views

PG_Restore failure. How do i get disk space back?

Im fairly new to PostGIS. I had been attempting to use pg_restore of a large dump file through command line (around 13GB). My computer crashed while this was processing and did not complete. I now ...
3
votes
1answer
27 views

PostGIS Functions not working using hibernate in java?

I need to execute select ST_AsText(column_name) from table using hibernate createSQlQuery(). When i executed that query, it fires an exception. But when i execute the same query using simple JDBC ...
0
votes
0answers
18 views

Posgis update from 2.0 to 2.1: cannot find libraries

I've just updated (yum update, using the official postgres 9.2 packages for RHEL in an amazon machine) postgis from 2.0 (that was working perfectly) to 2.1. Now all the libraries of postgis are still ...
0
votes
0answers
27 views

Type error when replacing ST_Intersects with ST_Contains in PostGIS

(In Postgresql 9.3) I'm writing the following ST_Intersect query and it works fine select count(*) from table1 where table1.UniqueID in ( SELECT table1.UniqueID FROM table1 INNER JOIN table2 ON ...
1
vote
0answers
39 views

Error when trying to create postgis extension

I have looked at all the answers on this topic, but none of them solved the issue that I have. I would really appreciate any guidance on resolving this issue. version: psql (9.1.4, server 9.2.4) OS: ...
0
votes
1answer
26 views

How does select work in postgresql, postgis?

I have the following statement in a book: SELECT AddGeometryColumn('public','my_geometries','my_points',-1,'POINT',2); INSERT INTO my_geometries (name,my_points) VALUES ...
0
votes
2answers
24 views

Calculate the overlap between two unrelated tables in posgres/posgis

This is both a basic SQL question and a postgres/postgis question. I have two table sets, in the same database but from different sources, provide similar yet different geographic data. For ...
0
votes
1answer
33 views

Inserting values generated from query into a blank column

I am trying to count the number of points (stored in table2) that are found in each polygon of table 1. The query works but I have tried to alter it to add the valus generated to a blank column in ...
0
votes
1answer
25 views

Weird error calling postgis function

I am trying to solve a problem related to what appears to be duplicated functions in a postgis database (original question here), but in my testing I'm getting something very odd happening. I have ...
0
votes
0answers
30 views

Postgis function is not unique

I'm trying out cartaro, and I get an error when trying to create a spatial object. The error mesage is Unable to parse WKT: POLYGON((2323165.9017765 -3715665.1528316,2325153.2645117 ...
1
vote
2answers
72 views

PG::UndefinedFunction: ERROR: operator does not exist: geometry && box

Why does PostgreSQL complain that the && operator does not exist? (I have PostGIS installed - see below). mydb=# SELECT "monuments".* FROM "monuments" WHERE mydb=# (coord && ...
0
votes
1answer
22 views

Finding the pair of points whose distance from each other is maximal ( Plpgsql )

I have a very small database which includes 6 points, with those coloums id, the_geom, descr. And my aim to write a PL/pgSQL function which finds the the pair of points whose distance from each other ...
0
votes
0answers
89 views

osm2pgsql has stopped working

I want to import osm planet-131113.osm.pbf whit osm2pgsql. But whent it proccessing relation the window throw and say "osm2pgsql has stopped working" and then proccess killed.What is the problem? My ...
0
votes
1answer
8 views

Update with CSV in PostGis

I am new to this postGIS concepts.. I have an postgres table in that i have some 10000 datas.Now i want to update some 100 datas in that table. I have this 100 datas in CSV file. SO i used the ...
1
vote
1answer
52 views

Postgres create POSTGIS extension error with CentOS 6

I am running PostgreSQL 9.3 with Postgis 2.0 on CentOS 6.3. I installed Postgersql and Postgis according to this instructions: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21CentOS6pgdg When ...
0
votes
0answers
27 views

PostGIS Tiger Geocoder can't get any result

I followed the doc to install postgresql postgis. I also loaded many states data into database. It all looks normal and I didn't get any error during the loading process. But when I ran the query to ...
3
votes
1answer
52 views

Select query within a particluar radius in postGIS

I am new to this postGIS. My requirement is to retrieve data with the particular radius.IN my database i have the_geom(POINT).Now i have a query which will retrieve data within 2 DEGREE from the ...
0
votes
3answers
84 views

can't use postgresql function in bash script

I am new to postgresql and I'm using postgresql 9.3 and postgis 2.1. In pgadmin, I am able to use a function in database "AddGeometryColumn", but when I write that script in Ubuntu bash, it doesn't ...
0
votes
1answer
71 views

Getting org.postgresql.geometric.PGpoint instead of org.postgis.PGgeometry in Hibernate Spatial

I've been struggling with this for a while. Running on Tomcat 7.0.47 Relevant Entity Class snippet: @Column(name = "geopoint", columnDefinition = "org.postgis.Geometry") @Type(type = ...
1
vote
1answer
60 views

Is there an API for rendering OpenStreetMap data from PostgreSQL database?

I have setup a local PostgreSQL database with PostGIS extension and imported a .osm file into the database using osm2pgsql. Now I want to display selected data on my Android client. Via SQL ...
0
votes
1answer
44 views

Django model creating geography not geometry fields

I have a Django model in which i declare maplocation = models.PointField() I'd like to work with geography not geometry, if i use python manage.py sql it maps as "maplocation" geometry(POINT,4326) ...
1
vote
1answer
34 views

Django settings configure databases with two engines

I'm trying to run DJango with postgresql and postgis for Django & postgresql I configures the setting.py file as follows DATABASES = { 'default': { ...
0
votes
2answers
36 views

pgr_astar and impossible edges (e.g., locked doors)

I'm using postgresql / PostGIS with pgrouting and I need to compute the shortest path. In a previous version of pgrouting, I was using shortest_path_astar. In my routing graph I had impossible ...
1
vote
2answers
237 views

postgresql - center - “No function matches the given name and argument types. You might need to add explicit type casts.”

On Slackware 14.0 x86_64 with postgresql-9.2.4 and postgis-2.0.3. Have loaded essex-latest.osm.pbf into a database. I want to get the centre of the roads in Essex, but am having problems. These work ...
0
votes
3answers
60 views

Compound OR SQL query (query #1 with WITH) and (query #2) with COUNT() excusions

EDIT Yes, you are correct. What I am looking for in pseudo code is a list that (st_area(geom)>0.1) OR (COUNT(*) > 1) and in words: return a list, that only has only states that have an area ...
6
votes
1answer
131 views

Hibernate Spatial - 'Invalid endian flag value encountered' Exception

I'm trying to run a simple query in Hibernate Spatial 4.0 on PostgreSQL 9.3. I have a number of objects in a table with latitude/longitude values, and I'm trying to query objects that fall within a ...
-3
votes
1answer
34 views

Postgis functionalities in Microsoft SQL Server

I'm using Postgresql 8.4, Postgis 1.5 for My GIS works. Planning to change my Database to Microsoft SQL Server 2012. Can we use all the Postgis functionalities in Microsoft SQL Server 2012. Please ...
1
vote
1answer
45 views

shp2pgsql creates a table but psql reports “relation…does not exist”

Using shp2pgsql to import a shapefile into a PostGIS database, all works fine: Connection: host=localhost port=5432 user=aperrin dbname=tweets password='******' Destination: ...
1
vote
1answer
138 views

postgis query for addresses (with osm data)

I want to make queries for addresses to postgis database with data from openstreetmap, check if such address exist in database and if so, get coordinates. Database was filled from .pbf file using ...
1
vote
1answer
45 views

GeoDjango touches function is slow

First off, here's my setup: Python 2.7.6 Django 1.6 PostgreSQL 9.3.1 PostGIS 2.1.1 I have loaded up the Natural Earth countries and states datasets into PostGIS. Here's the Django model I'm using: ...
0
votes
1answer
51 views

Postgres/Postgis - Querying all values in clipped raster

I'm currently using Postgres 9.1 My goal is to clip a PostGIS raster with a polygon. Then I would like either an postgres array or delimited set of values for each of the raster pixels that are ...
1
vote
1answer
74 views

How to save geospatial data into database using java?

I am working on a GIS Application. What progress i have done is that i have loaded a KML Layer on Google MAPS API and i am plotting the routes between the points. This is GUI Part. Now how do i save ...
1
vote
1answer
81 views

Vagrant setup to get PostgreSQL to use UTF8 encoding by default?

I'm trying to get a VM set up in Vagrant so that when the machine comes up PostgreSQL is running and using an encoding of UTF8, but it's LATIN1 every time, no matter what I do. The instructions on ...
0
votes
2answers
164 views

Insert into PostgreSQL/PostGIS database is too slow

I am working on a project that requires me to take a live Twitter feed and store records from it in a PostgreSQL database. The project requires that the tweets' location data be stored for searching ...
0
votes
1answer
44 views

How to use subquery as a geometry parameter on postgis?

I need to compare some spatial data on postgis, but I need to compare with not geometry data in another table "card_history", witch contains lat and long fields necessary to use "ST_GeomFromText" ...
0
votes
1answer
99 views

How to insert current timestamp in Postgis timestamp without time zone column by using javascript?

I have tried to insert/update the timestamp in postgis database from javascript, But its not working. I have Timestamp column in postgis with Timestamp without time zone data type. //My Javascript ...
0
votes
2answers
46 views

The pgsql2shp.exe cuts-off text to max 254 characters (varchar(254))

im using the pgsql2shp tool to generate *.shp files from geometries in Postgres. The thing is that I have a description colomn with a lot of text. In the Postgres DB it is of type text. But when I use ...
0
votes
1answer
41 views

postgresql Converting WKB to utm

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 ...
0
votes
1answer
59 views

postgresql with postgis & polygons

I'm working with postgresql with postgis. I have few questions: trying to insert into a table with polygon column using the following syntax: ST_GeomFromText('POLYGON((long1 lat1, long2 lat2, ...
0
votes
1answer
56 views

PostgreSQL how to create a scalable location-based query

I need suggestions because I am not good enough. I have a DB in PostgreSQL that runs on AWS (Amazon Web Services). I have a table "user_location" where there are stored the locations of each user ...
3
votes
2answers
47 views

PostgreSQL How to return tuple {a,b} but not tuple {b,a}?

Given a table of polygons with geometric data and using ST_INTERESECTS(), how can we return the polygons that intersect while preventing out results from being redundant? To be clear, if we return ...
-3
votes
1answer
55 views

Please explain ST_GeomFromText parameters

I am having trouble understanding ST_GeomFromText. It looks like there are 3 sets of 2 numbers. Why is that? Wouldn't coordinates just consist of a latitude and longitude? Here is an example from ...
0
votes
1answer
93 views

delete_node failure with osm2pgsql

I updated to OS X Mavericks and I try to setup again a workflow to convert personnal OSM data (created using JOSM software) into Tilemill maps. For this, I use osm2pgsql to populate a ...

1 2 3 4 5 … 11
15 30 50 per page