postgis

相关标签：javascript jquery android 多少钱 iPhone

Rails with PostGIS

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:[详细]

2023-02-16 13:28 分类：问答
How to update multipoint in postgis?

CREATE TABLE geo ( geo_id INTEGER, ); SELECT AddGeometryColumn( \'geo\', \'geo_geom\', -1, \'GEOMETRY\', 4 );[详细]

2023-02-15 13:28 分类：问答
Get points inside a bounding box

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:[详细]

2023-02-15 06:38 分类：问答
django - add a POINT in a PostgreSQL database using GeoDjango from decimal coordinates

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?[详细]

2023-02-13 17:07 分类：问答
Find n Nearest Neighbors for given Point using PostGIS?

I am trying to solve the problem of finding the n nearest neighbors using PostGIS: Starting Point: Table geoname with geonames (from[详细]

2023-02-13 02:38 分类：问答
installing Postgis 1.5.2 with PostGres 9.0.3 fails

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[详细]

2023-02-10 12:45 分类：问答
PostgreSQL/PostGIS stored function + Eclipselink converter problem

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[详细]

2023-02-09 19:36 分类：问答
Problem with a column name contains a colon in PostgreSQL

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.[详细]

2023-02-09 16:06 分类：问答
ST_Distance and 'as' in Postgis

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 )))[详细]

2023-02-08 17:46 分类：问答
Manifold/PostGIS data manipulation and export

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[详细]

2023-02-08 15:46 分类：问答