First of all, I\'m using Rails3 with Ruby 1.9.2. I have a problem using PostgreSQL with PostGIS. I\'ve tried two gems:
CREATE TABLE geo ( geo_id INTEGER, ); SELECT AddGeometryColumn( \'geo\', \'geo_geom\', -1, \'GEOMETRY\', 4 );
I\'m trying to choose places from my postgis db that are inside a certain bounding box. I\'m trying to accomplish this with this 开发者_StackOverflow中文版query:
I\'m using PostGIS with django. I know how to开发者_高级运维 add a \"POINT\" on PostgreSQL from decimal coordinates but how do I add it using GeoDjango?
I am trying to solve the problem of finding the n nearest neighbors using PostGIS: Starting Point: Table geoname with geonames (from
on Mac OS X Snow Leopard, I get the following error on make gcc -g -O2-fno-common -DPIC-Wall -Wmissing-prototypes stringb开发者_开发知识库uffer.o shpopen.o dbfopen.o safileio.o getopt.o shp2pgsql-cor
I use PostgreSQL with PostGIS and Eclipselink. In the Postgres database I have some stored functions, as I know with Postgres stored functions + Eclipselink doesn\'t work the @NamedStoredProcedureQuer
I downloaded the shape data from OSM. I have imported data from Shapefile into PostgreSQL without any problem but I got an error when I do the select statement.
I\'ve written this query and it works, although it\'s a bit slow: SELECT name, (ST_Distance( ST_Transform( way,900913 ),ST_Transform( ST_GeomFromText(\'POINT (-6.2222 53.307)\',4326),900913 )))
I\'m currently working on a GIS database project using Manifold Ultimate. I am able to import data from PostGIS via the database开发者_如何学编程 console, and edit the data as a table object within Ma
加载中,请稍侯......