Tagged Questions

PostGIS spatial database extension for PostgreSQL.

learn more… | top users | synonyms

0
votes
1answer
17 views

IS NOT DESTINCT FROM versus =

Can anyone please help me. I have the following postgresql query: SELECT count(*) FROM trackPointsA WHERE gid NOT IN ( SELECT a.gid FROM trackPointsA a, trackPointsB b WHERE a.the_geom = ...
-1
votes
0answers
26 views

Where can I find some good online resources on learning how to port from Coldfusion MX7 to Django (specifically, GeoDjango, Postgis)? [closed]

I am applying for a position and would like to read up on this. Have been searching in vain. And, this is all the info I have about the role. Thanks in advance for all your help.
1
vote
1answer
13 views

How to load a raster from in-memory bitmap (not from file) into PostgreSQL

I have a bitmap in memory that I would like to load as a raster to PostgreSQL. An unfavorable option is saving the bitmap to file and then use raster2pgsql, but as we have several cameras that ...
0
votes
1answer
48 views

Postgres Version

I have been asked to develop my new application with Postgres 10.0. Before this, I have been developing applications with MsSql and was quite easy even. I searched for the Version 10.0 but didn't find ...
0
votes
0answers
14 views

java.lang.NullPointerException with GeoServer, Postgis and openlayer

I am continuing work that another person began based on Geoserver and postgis. On the database level there are many tables and the layers are views based on these tables. That is working great! Now I ...
0
votes
0answers
27 views

TALEND DI Job to create points-polygons and store them to postGis table

which is the best way to create points and polygons starting from raw data and than store them into a postGIS table containing a geometry column? Thanks
0
votes
0answers
18 views

Trouble installing postgreSQL + postGIS on mac OS [closed]

I've been trying to install the latest release of postgreSQL and postGIS (an extension for postgreSQL) on mac OS, and there's just been a ton of problems. I'm a beginner in this, so I actually don't ...
0
votes
1answer
36 views

PostgreSQL point_ops with GiST PostGIS Spatial Index

The 9.0 release notes for PostgreSQL states the following change: Add point_ops operator class for GiST (Teodor Sigaev) This feature permits GiST indexing of point columns. The index can be ...
0
votes
1answer
44 views

Error 28 “Out of Stack Space” executing a huge query with VB6 & ADO 2.8

Scenario: Executing an SQL command from a Visual Basic 6 application using ADO Connection.Execute method through PostgreSQL OLEDB Provider to a PostgreSQL 9.2 database. Query: It's a simple EXECUTE ...
0
votes
1answer
37 views

Run delete query until zero rows affected in postgresql

I'm using PostGIS to process some complex land use data. I have several cases were there were exact duplicate polygons created. I'd like to delete these duplicates, and I am currently using the ...
0
votes
1answer
40 views

call postgres function with hibernate

I wrote a PostgreSQL function with return value VOID: CREATE OR REPLACE FUNCTION queryinteriorexteriorcount() RETURNS void AS ..... The function works quite well if i call it in pgAdmin. But if i ...
2
votes
1answer
41 views

GeoLocation queries on PostgreSql

We are working on a ride sharing service, where we are using postgresql as our database to store ride details. We havent used any special datatype for storing latitude and longitude, but saving as ...
0
votes
0answers
28 views

RGeo-GeoJSON rendering feature collection

I need help rendering a feature collection in geojson for my index action. Using postgis, RGeo, RGeo-GeoJSON, activerecord-postgis-adapter, etc. MIME type is set to render geojson and the show action ...
0
votes
1answer
36 views

PostGIS - Database installation of functions failed

I'm using Windows 7 Home SP1 64bit and trying to install PostGIS 2.0.3 for PostgreSQL x64 9.2. PostgreSQL installation worked fine and I've connected to/modified databases. The same error listed below ...
0
votes
1answer
20 views

Specifying index method when using @Index annotation

I'm using (spatial) hibernate annotations to create a schema for a spatial application that is implemented on top of PostGIS. When creating the database schema from my annotated classes, I'm in need ...

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