Displaying 1 result from an estimated 1 matches for "name_lc".
Did you mean:
name_c
2006 Jun 22
0
Simple Query of Postgis Posgresql database?
...e and latitude and get a list of areas within which those
coordinates occur.
I have a postgis (postgresql) databases that contain shape files for
county, township, range and section.
I can query these databases in the following way from within postgresql
in the database county
county=# SELECT name_lc FROM counties WHERE
distance(the_geom,''POINT(-89.85139 42.73806)'') = 0;
name_lc
-----------
Lafayette
(1 row)
in the database section
section=# SELECT twp FROM secrdtrs_wgs84 WHERE
distance(the_geom,''POINT(-89.85139 42.73806)'') = 0;
twp
-----
3
(1 ro...