search for: the_geom

...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 row) also in the database section sectio...

...-max(points$y)))) # generate voronoi edges tiles = tile.list(voro) # combine edges into polygons sink("voronoi.sql") # redirect output to file for (i in 1:length(tiles)) { # write out polygons tile = tiles[[i]] cat("insert into mytable (the_geom) values(geomfromtext('POLYGON((") for (j in 1:length(tile$x)) { cat (tile$x[[j]],' ',tile$y[[j]],",") } cat (tile$x[[1]],' ',tile$y[[1]]) #close polygon cat ("))',32718));\n") # add SRID and newline } sink()...