postgis

If I run the following query in postgis select postcode, st_astext(geom) from testshp where postcode = 'L9 2DA'; I get the following: "L9…

The problem: I need to select, for each building in my table that has say at least 2 pharmacies and 2 education centers within a radius of 1km, all…

I'm building an application that pulls lat/long values from a database and plots them on a Google Map. There could be thousands of data points so I…

I have the following table structure: column names : cell longitude latitude bcch bsic data types : varchar double double double double Keys : x I…

I have the following table defined, which uses PostGIS geography. CREATE TABLE test_geog ( id SERIAL PRIMARY KEY, boundary GEOGRAPHY(Polygon) ); I…

I have the following JDBC code. Note that I am attempting to use PostGIS geography: PreparedStatement stmt = db.prepareStatement("INSERT INTO " +…

I'm very new to postgres/postgis so please bear with me. I've imported a shapefile using the shp2pgsql command and now I'm trying to view it to…

After spending some time trying to create a mock object (or stub, who knows...) of Post-GIS's Geometry object, I have decided it would beneficial to…

I have a table Transport that has 2 fks pointing a table Spot . those fks store origin and destination of the transport. I need to do a query that…

I have a large amount of spatial data I need analyze and put into use in an application. Original data is represented in WKT format and I'm wrapping…

I am new in python, and using Python & PostgreSQL (9.03) (and psycopg2 to interface between the two) in Windows XP environment. I am working on…

Hi Guys, i'm working on a web-platform which analyzes GPX-Tracks and draws some profiles, speed stuff, etc. Currently i just calculate the…

Hi, I use postgis_adapter alongside with PostgreSQL 9.0.4, PostGIS 1.5.2 and Rails 3.1.0 on Ruby 1.9.2. As described in the the postgis_adapter…

I'm working with PostGIS and plotting polygons on a Google Earth plugin. I've found a few examples via Google on how to convert a LinestringM to a…

I made a table in a postgre database with a name image_id and geometry column in it. Here is what the schema looks like: CREATE TABLE images (…

I am currently in the process of developing a program and not sure where to go from here... I am using Visual C# and the DotSpatial frawework in…

Background: I need to store the following data in a database: osm nodes with tags; osm edges with weights (that is an edge between two nodes…

We have a table that has millions of rows with PostGIS geometries in them. The query we want to perform is: what are the most recent entries that…

Hello guys, I am trying to install nominatim using this : http://open.mapquestapi.com/npi/ After one day of process, I finaly get this message:…

I will be implementing a search feature on a project to allow a user to find the nearest store based on driving time given a input physical address.…