I suspect this is a basic question but, for a newb like me, it's proving to be quite a challenge. I have imported (using ogr2ogr) a collection of census tracts from the U.S. Census-provided .shp files (I'm told these are SRID 4269) into a PostGIS database. And I simply want to find the names of the tracts that fall within a certain radius (in meters) of a given lat/long point. (Bonus points if we can figure out how to get the tracts that are more than 50% within that radius.)
My table has two (relevant) columns: name [char(7)), and wkb_geometry [geometry(Polygon,4629)].
Any ideas?
أكثر...
My table has two (relevant) columns: name [char(7)), and wkb_geometry [geometry(Polygon,4629)].
Any ideas?
أكثر...