postgis

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

Updating multiple rows in one table based on multiple rows in a second

I have two tables, table1 and table2, both of which contain columns that store postgis geometries.What I want to do is see where the geometry stored in any row of table2 geometrically intersects with[详细]

2023-03-17 15:30 分类：问答
how reprojections are done with srid = -1

I get a huge doubt, I have a shape file that I introduced to postgres and I didn\'t specify an srid, so the_geom column has -1 in the srid, when I start any other map viwers like QGis or MapSertver I[详细]

2023-03-16 15:48 分类：问答
Cluster points in PostGIS

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 \"cluster\" points close to each other so the user[详细]

2023-03-15 15:08 分类：问答
How to get this postgis data into a format I can use with Google Maps/KML

If I run the following query in postgis select postcode, st_astext(geom) from testshp where postcode = \'L9 2DA\';[详细]

2023-03-15 09:20 分类：问答
Casting a Geography type in PostGIS

I have the following table defined, which uses PostGIS geography. CREATE TABLE test_geog ( id SERIAL PRIMARY KEY,[详细]

2023-03-15 05:30 分类：问答
How would I write this spatial query?

I have the following table structure: column names : celllongitude latitude bcchbsic data types: varchar doubledoubledouble double[详细]

2023-03-14 16:31 分类：问答
Checking validity of postgis polygon data (imported from shapefile)

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 check that it has imported correctly. I\'ve tried SEL[详细]

2023-03-13 23:56 分类：问答
Postgis - st_distance

I\'m having problems with st_distance function in postgis. It returns wrongs results - for small distances the error isn\'t big - 10, maybe 20 meters but for bigger distances the difference between my[详细]

2023-03-12 03:49 分类：问答
Python PostgreSQL Statement Problem psycopg2 cursor.execute(Table Union)

I am new in python, and using Python & PostgreSQL (9.03) (and psycopg2 to interface between the two) in Windows XP environment.[详细]

2023-03-10 11:47 分类：问答
INSERT INTO and String Concatenation with Python

I have hit a major speed bump in inserting data in to my DB. You can see from the code below that I am simply building the SQL statement to pass in to the execute command. The values are correct and a[详细]

2023-03-08 07:55 分类：问答