postgis

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

How to put together two queries?

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

2023-01-03 11:33 分类：问答
How to change SRID of geometry column?

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

2023-01-02 19:06 分类：问答
Using data from a dataset in styles with Mapnik

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

2022-12-30 03:42 分类：问答
Divide a path into N sections using Java or PostgreSQL/PostGIS

Imagine开发者_C百科 a GPS tracking system that is following the position of several objects. The points are stored in a database (PostgreSQL + PostGIS).[详细]

2022-12-29 14:38 分类：问答
Installing PostGIS on Windows

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

2022-12-29 08:52 分类：问答
How can I convert a projection that's not part of spatial_ref_sys?

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

2022-12-28 09:12 分类：问答
Problem building Postgis 1.5.x for Pg 8.4 on Ubuntu 9.10

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

2022-12-25 04:01 分类：问答
PostGIS and JPA 2.0

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

2022-12-22 04:43 分类：问答
Driving directions using Postgis and pgRouting [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]

2022-12-21 14:22 分类：问答
Generating density/heat maps like SpatialKey

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

2022-12-19 01:56 分类：问答