In my project I have a table full of residential properties by Parcel_ID. Table 2 is a TIGER streets shapefile. I would like to build a query in MS Access displaying all properties within a mile radius of my selected property from table 1.
My questions are :
Should I use open-source postgis (spatial databases) and build this project in SQL 2008 to query off map location rather than tabular data?
Or Should I use a FileGeodatabase to import the shape file into MS ACCESS?
Thanks for any help or reply,
PS - I have the shapefile loaded in ArcGIS explorer - but not sure how to export.
6/17/2012 update** I posted the state parcel tables below:
County Mapping Parcel Table
OBJECTID PARCEL_TAG PARCEL_I PARCEL_C LOTNUM SUBDIVISIO SUBDIVNUM STNUMBER PRE_DIR STREET_NAM SUFFIX SUF_DIR FULL_STNAM CITY COUNTY STATE TOWNSHIP ZIPCODE ESTSQFT BLOCK MODDATE STATUS SHAPE_AREA SHAPE_LEN | 1 1251683 8011477 8011477 7809 1723 4015 N KENWOOD AVE KENWOOD AVE INDIANAPOLIS MARION IN WASHINGTON 46208 5280 1004 **5279.952157* 343.9990607