In the title is what I need. CREATE TABLE newTable1 AS SELECT t2.name,t2.the_geom2 FROM t1,t2 WHERE ST_Contains(ST_Expand(t2.the_geom2,0.05),t1.the_geom1)
I have a table where one of the columns is a geometry column the_geom for polygons with an SRID. I added a new column in the 开发者_开发问答same table with exactly the same geometry data as the_geom.
I\'ve setup Mapnik to connect to a PostGIS database, and display geometry. I\'d like to have a column in my database called opacity, and use it as the opacity for that row of geometry when Mapnik rend
Imagine开发者_C百科 a GPS tracking system that is following the position of several objects. The points are stored in a database (PostgreSQL + PostGIS).
I\'ve installed PostgreSQL and PostGIS, and now I\'m trying to follow these instructions: http://docs.djangoproject.com/en/dev/ref/contrib/gis/install/#spatialdb-template
I\'m importing shapefiles into a Postgres+PostGIS database. Here\'s my usual procedure: * Find an srid in the spatial_ref_sys table where srtext appears to match the shapefile\'s .prj file
Here are things installed: $ sudo apt-get install postgresql-server-dev-8.4 libpq5 libpq-dev Here is a past to my config.out: http://pastebin.com/8Nk6pr96
I\'d like to map datatypes from PostGIS开发者_StackOverflow with JPA 2.0. I googled for solutions or examples, but all I can find is that JPA does not support mapping of custom data types. Is it still
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
SpatialKey generates some really nice looking heatmaps, and we\'re looking into what\'s involved in doing this for an internal project to visualize large amounts of points. I\'m looking for feedback o
加载中,请稍侯......