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
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
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
If I run the following query in postgis select postcode, st_astext(geom) from testshp where postcode = \'L9 2DA\';
I have the following table defined, which uses PostGIS geography. CREATE TABLE test_geog ( id SERIAL PRIMARY KEY,
I have the following table structure: column names : celllongitude latitude bcchbsic data types: varchar doubledoubledouble double
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
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
I am new in python, and using Python & PostgreSQL (9.03) (and psycopg2 to interface between the two) in Windows XP environment.
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
加载中,请稍侯......