What's the Optimal Procedure For Data Mining Extractions?
Parcels which relate to the subject property chosen using the Digitizer Tool.
Say you have parcel layer and a joined table of tax records, and you want to export all of the tax records abutting your subject property, what is the optimal procedure extract only selected fields into a new spreadsheet?
In my fumbling attempts to finally automate (what I've done for decades "long hand"), I've started out in Global Mapper by using the Digitizer Tool, selecting just those parcels of interest, Ctrl+C (copy), Ctrl+V (paste) Paste To User Created Features Layers. This helps to isolate things a bit, but probably isn't really necessary.
Then onto the what's next? bit. An Export of all items selected seems in order, but there's so many (here's some of formats but is an incomplete list) to choose from, and really, which one(s) will offer the chance to save only selected fields (attributes) that I need in order to ultimately do a mail-merge in OpenOffice when I mail out notices to the abutters informing them of our surveying activities? And in reality, if truth be told, it isn't the attribute we're after, but rather its VALUE*
For this exercise we're only wanting certain fields:
[COLOR=#a9a9a9]DESCRIPTION=Parcel style 05 pale sandalwood CLOSED=YES OBJECTID=1085 TOWN=Sullivan GEOCODE=09300 STATE_ID=930001222 MAP_BK_LOT=029-007 PARENT= PROP_LOC=GARDEN WAY PROPLOCNUM=3.00 GEO_LOT=09300_029-007 FMSRC= FMSRCORG=hcpc FMPROCSS= FMUPDORG=umch FMUPDAT=20101012 FMNOTE= STAGE=2 FMSRCDAT=20070331 POLY_TYPE= [/COLOR][B][COLOR=#4b0082]OWNER1=[/COLOR][COLOR=#ff0000]MASKE, ANN C.[/COLOR][COLOR=#4b0082] OWN_ADDR1=[/COLOR][COLOR=#ff0000]3 GARDEN WAY[/COLOR][COLOR=#4b0082] OWN_CITY=[/COLOR][COLOR=#ff0000]SULLIVAN[/COLOR][COLOR=#4b0082] OWN_STATE=[/COLOR][COLOR=#ff0000]ME[/COLOR][COLOR=#4b0082] OWN_ZIP=[/COLOR][COLOR=#ff0000]04664[/COLOR][/B][COLOR=#a9a9a9] LS_PRICE=0.00 LS_BOOK=B2140 LS_PAGE=P345 LAND_VAL=90900.00 BLDG_VAL=137200.00 LIV_UNITS=0.00 LOT_SIZE=4.50 SIZE_UNITS=A BLDG_SIZE=0.00 LAND_USE=0.00 YEAR_CREAT=0.00 RES_AREA=0.00[/COLOR]
So... for fumbling starters, let's go with Simple ASCII - I love simple, or at least the idea of something being simple ... which it rarely turns out to be.
The file that's produced contains exactly the information that's desired (yea!)... but extracting it from amongst the over 4,000 lines of the undesired information will need to be dealt with if Global Mapper doesn't already offer a secret way of exporting only selected VALUES from selected ATTRIBUTES.
(...I feel a script comin' on, just don't see it just yet through the mist)
In the mean time: REGEX to the rescue!
... well, as a 4-day old student of regular expressions, I'm in over my head
but here's a start:
regex 01 find: ^([^(^OWN.*\.?.*\n)+].*\n)+ replace: \n
This will at least start to winnow things down a bit
Maybe you have a better idea or maybe there's a secret sauce yet to be tasted?