-- Multiple AOI geometries for use in testing CART queries in different locations -- -- Wisconsin Testing SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-89.41635 43.03728,-89.33979 43.03301,-89.34734 43.00013,-89.42253 42.99485,-89.41635 43.03728)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T0001 Fld1', @aoiGeomFixed); ---Origional testing: SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-102.12335160658608 45.959173206572416, -102.13402890980223 45.959218442561564, -102.13386921506947 45.944643788188387, -102.12327175652177 45.944703605814198, -102.12335160658608 45.959173206572416)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T9981 Fld3', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-102.1130336443976 45.959162795100383, -102.12335160658608 45.959173206572416, -102.12327175652177 45.944703605814198, -102.1128892282776 45.944710506326032, -102.1130336443976 45.959162795100383)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T9981 Fld4', @aoiGeomFixed); --- END Origional SD landunit (small - 179.5 acres) with Cutcomb mucky peat soil; comppct_r=85%) ----------------------------------------------------------------------------------------- SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-101.84494063299996 43.00114497800007, -101.86442166199998 43.001375866000046, -101.86439375499998 42.999115980000056, -101.84495783899996 42.998998459000063, -101.84494063299996 43.00114497800007)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T1106 Fld1', @aoiGeomFixed); Same SD Cutcomb mucky peat soil, but a very large landunit (1,790 acres) ----------------------------------------------------------------------------------------- SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-101.84492377099997 43.003248366000037, -101.84487397499998 43.010584351000034, -101.85488937099996 43.010487579000028, -101.85521510499996 43.017703231000041, -101.85498712099997 43.03217367700006, -101.86037680099997 43.032140587000072, -101.86449558999999 43.032147413000075, -101.86441548599998 43.02540250900006, -101.86453770199995 43.019487328000025, -101.86446939499996 43.014259870000046, -101.86453545799998 43.010589917000061, -101.86439375499998 42.999115980000056, -101.84495783899996 42.998998459000063, -101.84492377099997 43.003248366000037)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T1106 Fld1', @aoiGeomFixed); -- 1. Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-87.905419010999935 32.687136181000028, -87.90659362699995 32.687184033000051, -87.906732993999981 32.687332464000065, -87.906745523999973 32.687333203000037, -87.907199056999957 32.687342894000039, -87.907241298999963 32.687341967000066, -87.907822303999978 32.687329023000075, -87.908709177999981 32.687309278000043, -87.909374251999964 32.687355514000046, -87.909992215999978 32.687390741000058, -87.910925844999952 32.687383964000048, -87.911352688999955 32.68738086500008, -87.911368323999966 32.687380752000024, -87.911657083999955 32.68739000000005, -87.911912217999941 32.687393819000079, -87.911925544999974 32.687394066000024, -87.912355368999954 32.687401945000033, -87.912724630999946 32.687404933000039, -87.914879618999976 32.687411913000062, -87.916155549999985 32.687453664000031, -87.917013746999942 32.687488021000036, -87.917617168999982 32.687512167000079, -87.91771364799996 32.687516027000072, -87.918218739999986 32.687547049000045, -87.918291351999983 32.687551515000052, -87.919271164999941 32.687521643000025, -87.920405989999949 32.687599981000062, -87.920534134999969 32.687608819000047, -87.920784716999947 32.687610569000071, -87.92077672399995 32.687468754000065, -87.920733313999961 32.687466251000046, -87.920685403999983 32.687410605000025, -87.920656272999963 32.687338819000047, -87.920647159999987 32.686450896000053, -87.920623631999945 32.686003064000033, -87.920591544999979 32.68564329700007, -87.920541091999951 32.685339673000044, -87.920528910999963 32.685075746000052, -87.920542069999954 32.684907979000059, -87.920664046999946 32.684575857000027, -87.920753361999971 32.684346554000058, -87.920873269999959 32.684150923000061, -87.921018100999959 32.683873802000051, -87.921017177999943 32.683783866000056, -87.920985978999965 32.683706999000037, -87.920974465999961 32.683692002000043, -87.920932043999983 32.683636730000046, -87.920840294999948 32.683585995000044, -87.920703465999964 32.683587000000045, -87.920498492999968 32.683614212000066, -87.920459039999969 32.683624730000076, -87.920418527999971 32.683621601000027, -87.920406039999989 32.68358749600003, -87.920329979999963 32.683369175000053, -87.920149335999952 32.680351884000061, -87.92010587499999 32.679632496000067, -87.920097447999979 32.679492931000027, -87.920091496999987 32.679394426000044, -87.918411478999985 32.678730872000074, -87.910744681999972 32.678729481000062, -87.90496914299996 32.678598577000059, -87.904986735999955 32.678854802000046, -87.904991535999955 32.678924689000041, -87.904996521999976 32.678997176000053, -87.905064323999966 32.67904048500003, -87.905197512999962 32.684459569000069, -87.905300979999936 32.686658353000041, -87.905419010999935 32.687136181000028)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T1296 Fld71', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-87.915895409999962 32.66788157600007, -87.924714900999959 32.670745020000027, -87.924775777999969 32.667451004000043, -87.92250695499996 32.665451466000036, -87.920978207999951 32.664294192000057, -87.92050352199999 32.664228939000054, -87.920044372999939 32.664358322000055, -87.919762094999953 32.664566597000032, -87.919629604999955 32.664853966000067, -87.919517565999968 32.665815936000058, -87.916873719999955 32.665537427000061, -87.915895409999962 32.66788157600007)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T1685 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-87.904822252999963 32.676459432000058, -87.904913085999965 32.677782192000052, -87.904926487999944 32.677977369000075, -87.904960914999947 32.678478746000053, -87.90496514299997 32.678540319000035, -87.90496914299996 32.678598577000059, -87.910744681999972 32.678729481000062, -87.918411478999985 32.678730872000074, -87.920091496999987 32.679394426000044, -87.920075917999952 32.679136542000037, -87.920034054999974 32.678443616000038, -87.920022080999956 32.678245436000054, -87.920014742999967 32.678123697000046, -87.919985572999963 32.677640998000072, -87.919978536999963 32.67748425700006, -87.919976880999968 32.677447376000032, -87.919929092999951 32.676382386000057, -87.91988332599999 32.675362618000065, -87.919878045999951 32.675244968000072, -87.919860283999981 32.674849140000049, -87.919851784999935 32.674659829000063, -87.919848770999977 32.674592622000034, -87.919828438999957 32.674139552000042, -87.919808687999989 32.673699369000076, -87.919801485999983 32.673538849000067, -87.919735036999953 32.672058102000051, -87.919742864999989 32.671942742000056, -87.920712701999946 32.672249511000075, -87.92089200199996 32.672336955000048, -87.921576430999949 32.672582220000038, -87.921996397999976 32.672758690000023, -87.923775965999937 32.673773966000056, -87.925006148999955 32.674537537000049, -87.925757739999938 32.675054337000063, -87.926504396999974 32.675590758000055, -87.92686174399995 32.67593090500003, -87.926953748999949 32.676025622000054, -87.927023826999971 32.676114161000044, -87.927857701999983 32.677120038000055, -87.928549412999985 32.67790724300005, -87.928291435999938 32.669895100000076, -87.928280524999991 32.669584573000066, -87.928162092999969 32.666213483000035, -87.927923383999939 32.66223451500008, -87.927916166999978 32.662114065000026, -87.927907074999951 32.661962499000026, -87.923695715999941 32.662046747000034, -87.919523370999968 32.661939916000051, -87.919350795999947 32.65859980700003, -87.919348922999973 32.658599844000037, -87.919220343999939 32.656439291000027, -87.918894905999935 32.656418424000037, -87.91889488999999 32.656413389000079, -87.914714344999936 32.655293628000038, -87.914691973999936 32.654921192000074, -87.914621641999986 32.653750397000067, -87.914471028999969 32.651242876000026, -87.914453748999961 32.650955233000047, -87.911118173999967 32.65092448300004, -87.910814007999988 32.65091633600008, -87.910674259999951 32.650912596000069, -87.908737057999986 32.650860715000078, -87.906088482999962 32.650777498000025, -87.905531714999938 32.650765143000058, -87.905195249999963 32.650757756000075, -87.905021162999958 32.650749206000057, -87.904939479999939 32.650700743000073, -87.904720719999943 32.65053843100003, -87.904690948999985 32.65051634200006, -87.904567442999962 32.65067427300005, -87.90456203399998 32.650670586000047, -87.904421615999979 32.650870790000056, -87.902659842999981 32.653382579000038, -87.902223015999937 32.655575433000024, -87.902224215999979 32.655624886000055, -87.902211929999964 32.658102230000054, -87.902011345999938 32.658102634000045, -87.90219613499994 32.66249420500003, -87.902226841999948 32.663223853000034, -87.90223541599994 32.663427616000035, -87.902713380999955 32.664033948000053, -87.903630236999959 32.665428902000031, -87.903898431999949 32.665784927000061, -87.904363157999967 32.666371467000033, -87.904537302999984 32.666546868000069, -87.904668824999987 32.666643070000077, -87.90483384199996 32.666735908000078, -87.905059718999951 32.666862360000039, -87.905332611999938 32.666988462000063, -87.905982815999948 32.667231082000058, -87.909421458999986 32.668411039000034, -87.909505542999966 32.675677520000079, -87.904810269999984 32.675692823000077, -87.904822252999963 32.676459432000058), (-87.920978207999951 32.664294192000057, -87.92250695499996 32.665451466000036, -87.924775777999969 32.667451004000043, -87.924714900999959 32.670745020000027, -87.915895409999962 32.66788157600007, -87.916873719999955 32.665537427000061, -87.919517565999968 32.665815936000058, -87.919629604999955 32.664853966000067, -87.919762094999953 32.664566597000032, -87.920044372999939 32.664358322000055, -87.92050352199999 32.664228939000054, -87.920978207999951 32.664294192000057)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T1685 Fld14', @aoiGeomFixed); -- End of AOI geometry section 1 -- 2. Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-101.75381402699998 38.248027620000073, -101.75583309899997 38.248009653000054, -101.75949633599998 38.247998068000072, -101.75963968499997 38.247997614000042, -101.76211003299994 38.247977892000051, -101.76211791299994 38.247354238000071, -101.76214685299999 38.245064192000029, -101.76210893799998 38.24289570500008, -101.76211875399997 38.240735528000073, -101.76203815199995 38.240766754000049, -101.75806883499996 38.240751697000064, -101.75410411699994 38.24072865800008, -101.75385442499999 38.240750010000056, -101.75385112999999 38.243004688000042, -101.75386108999999 38.245220301000074, -101.75377863399996 38.247329621000063, -101.75381402699998 38.248027620000073)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T6578 Fld3', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-101.72622757199997 38.242650612000034, -101.72625483899998 38.248007287000064, -101.72625545399995 38.248127649000025, -101.72623010599995 38.248895270000048, -101.72623060199999 38.251142111000036, -101.72626771299997 38.255271222000033, -101.72911575899997 38.255251051000073, -101.73522427999995 38.255266730000073, -101.73948118499999 38.25523404300003, -101.74348481299995 38.255225670000073, -101.74435029099999 38.255249632000073, -101.74435103999997 38.255267382000056, -101.74587787099995 38.255239388000064, -101.74981335399997 38.255247883000038, -101.75393073399994 38.255259731000081, -101.75394161499997 38.255677867000031, -101.75396084799996 38.25787775200007, -101.75401070099997 38.260107930000061, -101.75401176999998 38.261883265000051, -101.75401211599996 38.262470460000031, -101.75401212599996 38.262486443000057, -101.75674354699999 38.262476499000059, -101.75711655599997 38.262336011000059, -101.75825924299994 38.261890764000043, -101.75925289799994 38.261402522000026, -101.75993558399995 38.261006817000066, -101.76047012599997 38.260591360000035, -101.76093476799997 38.26014654200003, -101.76132028299998 38.259688097000037, -101.76155193099999 38.259318500000063, -101.76180805899997 38.258816619000072, -101.76191244399996 38.258589476000054, -101.76205310499995 38.258152285000051, -101.76210657299998 38.257748151000044, -101.76217313499995 38.256522442000062, -101.76218398899994 38.254345080000064, -101.76216026799995 38.252292493000027, -101.76214519599995 38.250208705000034, -101.76212947899995 38.247977736000053, -101.76211003899999 38.247977888000037, -101.75963969099996 38.247997610000027, -101.75949633099998 38.247998064000058, -101.75583308199998 38.24800964800005, -101.75381403299997 38.248027623000041, -101.75377863899996 38.247329625000077, -101.75386109599998 38.245220314000051, -101.75385112399994 38.243004683000038, -101.75385441899999 38.24075001500006, -101.75410412299999 38.240728653000076, -101.75806882999996 38.240751702000068, -101.76203815599996 38.240766749000045, -101.76211875999996 38.240735532000031, -101.76214465599998 38.240725506000047, -101.76215570199997 38.240368845000035, -101.76215384899996 38.238114299000074, -101.76212591699999 38.236897932000034, -101.75817571099998 38.236952794000047, -101.75789226299997 38.23699044600005, -101.75780158199996 38.236930597000026, -101.75781594599994 38.236790801000041, -101.75789299699994 38.236750255000061, -101.75794470799997 38.236818768000035, -101.75809513699994 38.236900457000047, -101.76193402599995 38.236848850000058, -101.76212455599995 38.236838786000078, -101.76210086099996 38.235806727000067, -101.76208092799999 38.233723050000037, -101.76196916299995 38.233624967000026, -101.75816273699996 38.233621569000036, -101.75432745399996 38.233634231000053, -101.75021707899998 38.233645452000076, -101.74400860699996 38.233652268000071, -101.74400847699997 38.233628169000042, -101.73516243499995 38.233610111000075, -101.73116892099995 38.233594709000045, -101.72935020199998 38.233571957000038, -101.72929968599999 38.234304531000078, -101.72876487899998 38.234975534000057, -101.72850019699996 38.235252861000049, -101.72826668399995 38.235312534000059, -101.72811511999998 38.235199837000039, -101.72624613099998 38.235180442000058, -101.72620671999994 38.236406754000029, -101.72615388899999 38.238050141000031, -101.72617602799994 38.240319747000058, -101.72617691099998 38.240411251000069, -101.72618326299994 38.240691876000028, -101.72618473599994 38.240756976000057, -101.72622757199997 38.242650612000034)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T976 Fld11', @aoiGeomFixed); -- End of AOI geometry section 2 -- 3. Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-89.904010109999945 38.888116154000045, -89.903946862999987 38.891067781000061, -89.910521639999956 38.88770600600003, -89.913311120999936 38.886283109000033, -89.910606990999952 38.886243797000077, -89.90975174099998 38.886236041000075, -89.909299224999984 38.88626494600004, -89.908724946999939 38.88631747200003, -89.908633978999944 38.886416669000027, -89.908554357999947 38.886486878000028, -89.908438866999973 38.88644950500003, -89.908277527999985 38.886456672000065, -89.907998727999939 38.886472170000047, -89.906777420999958 38.886954642000035, -89.904733023999938 38.887850031000028, -89.904010109999945 38.888116154000045)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T12808 Fld2', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-89.915584702999979 38.887214267000047, -89.915543630999991 38.886285784000052, -89.915541337999969 38.886285713000063, -89.914238643999965 38.88624463900004, -89.911396778999972 38.887694811000074, -89.908611617999952 38.889106618000028, -89.907381269999973 38.889690800000039, -89.905724641999939 38.890515651000044, -89.90535856799994 38.89073806600004, -89.903992391999964 38.891424345000075, -89.904005196999947 38.894362860000058, -89.904201331999957 38.894401203000029, -89.904415135999955 38.894403539000052, -89.904622228999983 38.894455590000064, -89.90491800999996 38.894528316000049, -89.907626236999988 38.894554934000041, -89.909008761999985 38.89449503700007, -89.909034805999966 38.893904366000072, -89.90903112899997 38.893718863000061, -89.909040660999949 38.893631561000063, -89.90944520499994 38.893656475000057, -89.909747809999942 38.893669604000024, -89.910011787999963 38.893676596000034, -89.910219592999965 38.893658818000063, -89.910478578999971 38.893560826000055, -89.910578620999956 38.893487780000044, -89.910744771999987 38.893425941000032, -89.91088590399994 38.893382365000036, -89.911305875999972 38.893312859000048, -89.911624076999942 38.893268990000024, -89.911835566999969 38.893268928000055, -89.911862337999935 38.893565739000053, -89.911856118999935 38.893771840000056, -89.911852703999955 38.894046521000064, -89.91185162499994 38.894378351000057, -89.911756249999939 38.894552354000041, -89.91256935399997 38.894615499000054, -89.913213381999981 38.894632536000074, -89.916479550999952 38.894649572000048, -89.917582594999942 38.894666578000056, -89.917761174999953 38.894671301000074, -89.917781303999959 38.893487300000061, -89.917814336999982 38.893222527000034, -89.917709162999984 38.893124725000064, -89.91755348099997 38.893183627000042, -89.917229556999985 38.893043403000036, -89.917177984999967 38.892881863000071, -89.917138548999958 38.892763624000054, -89.917213713999956 38.892713320000041, -89.917447633999984 38.892740254000046, -89.917607506999957 38.892767365000054, -89.917695746999982 38.892758249000053, -89.917780390999951 38.892690267000035, -89.917789598999946 38.892196134000073, -89.917724085999964 38.892023277000078, -89.917784103999963 38.891730882000047, -89.917807460999938 38.890175510000063, -89.917339338999966 38.890301839000074, -89.916634966999936 38.890544964000071, -89.916309127999966 38.890635884000062, -89.916162703999987 38.890646274000062, -89.916154456999948 38.890555732000053, -89.916451295999991 38.890391375000036, -89.916572723999991 38.89029160900003, -89.916664920999949 38.890191079000033, -89.916711753999948 38.890123673000062, -89.916775685999937 38.889999507000027, -89.916789528999971 38.889935548000039, -89.916243305999956 38.889978149000058, -89.915974762999952 38.889999573000068, -89.915626506999956 38.889895294000041, -89.915608080999959 38.889026972000067, -89.915584913999965 38.887935083000059, -89.915584702999979 38.887214267000047)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T12808 Fld6', @aoiGeomFixed); -- End of AOI geometry section 3 -- 4. Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-78.154780969999933 41.650096440000027, -78.155127299999947 41.650196509000068, -78.155959584999948 41.650342944000045, -78.156643053999971 41.650405617000047, -78.157041622999941 41.650358295000046, -78.157623488999945 41.65030407200004, -78.157898182999986 41.650299432000054, -78.158088013999986 41.650144005000072, -78.158314337999968 41.649852229000032, -78.159027929999979 41.650270195000076, -78.159599069999956 41.650112759000081, -78.160214924999934 41.649979300000041, -78.160884953999982 41.649823438000055, -78.161001729999953 41.648889304000079, -78.160903401999974 41.648886874000027, -78.160538823999957 41.648854995000079, -78.160114822999958 41.648787324000068, -78.159674584999948 41.648742125000069, -78.159186138999985 41.648752920000049, -78.158943423999972 41.648724041000037, -78.158775362999961 41.648731321000071, -78.158426522999946 41.648688379000077, -78.158354882999959 41.648583669000061, -78.158072500999936 41.648416557000075, -78.157821589999969 41.648227348000034, -78.157618387999946 41.64799356900005, -78.15765287399995 41.647902922000071, -78.157830635999971 41.648021696000058, -78.158078530999944 41.648279456000068, -78.158333461999973 41.648377264000032, -78.158526800999937 41.648141859000077, -78.158816056999967 41.64780588900004, -78.158223345999943 41.647413788000051, -78.157903313999952 41.647062744000038, -78.158040245999985 41.646723007000048, -78.158242467999969 41.645938812000054, -78.158183047999955 41.645903031000046, -78.157650937999961 41.64586698800008, -78.15687361199997 41.645859186000052, -78.156278061999956 41.645878755000069, -78.156265136999934 41.646518944000036, -78.155991463999953 41.64650073100006, -78.155093772999976 41.646455624000055, -78.154485500999954 41.646417679000081, -78.154290504999949 41.646344223000028, -78.153804593999951 41.646297870000069, -78.153542631999983 41.64636000400003, -78.153527533999977 41.646702755000035, -78.154045596999936 41.648442657000032, -78.154248146999976 41.648344738000048, -78.154445160999956 41.648372494000057, -78.154364470999951 41.648473433000049, -78.154258986999935 41.648791069000026, -78.154455636999955 41.649173380000036, -78.154734490999942 41.649420476000046, -78.15472140899999 41.649717535000036, -78.154780969999933 41.650096440000027), (-78.15543132199997 41.646972377000054, -78.15557394199999 41.647000675000072, -78.15566464799997 41.647029453000073, -78.155747833999953 41.647068662000038, -78.155761680999944 41.647129156000062, -78.155762493999987 41.647217623000074, -78.155685401999961 41.647254628000042, -78.15561213899997 41.647258119000071, -78.155553408999936 41.647306197000034, -78.155500094999979 41.647338486000081, -78.15546388599995 41.647464960000036, -78.155318744999988 41.647440138000036, -78.15515090599996 41.647395293000045, -78.154899358999955 41.647323607000033, -78.15471331699996 41.647317233000081, -78.154599042999962 41.647287879000032, -78.154502117999982 41.647239476000038, -78.154407943999956 41.647182306000047, -78.154418899999939 41.647094121000066, -78.154429944999947 41.647004183000035, -78.154446546999964 41.646894911000061, -78.154469775999985 41.646849493000047, -78.154579411999975 41.646876976000044, -78.15474110699995 41.64690044300005, -78.154861104999952 41.646906955000077, -78.154990361999978 41.646917227000074, -78.155079043999933 41.646991957000068, -78.155187652999984 41.646989334000068, -78.155312101999982 41.646948206000047, -78.15543132199997 41.646972377000054)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T89 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-78.155762493999987 41.647217623000074, -78.155761680999944 41.647129156000062, -78.155747833999953 41.647068662000038, -78.15566464799997 41.647029453000073, -78.15557394199999 41.647000675000072, -78.15543132199997 41.646972377000054, -78.155312101999982 41.646948206000047, -78.155187652999984 41.646989334000068, -78.155079043999933 41.646991957000068, -78.154990361999978 41.646917227000074, -78.154861104999952 41.646906955000077, -78.15474110699995 41.64690044300005, -78.154579411999975 41.646876976000044, -78.154469775999985 41.646849493000047, -78.154446546999964 41.646894911000061, -78.154429944999947 41.647004183000035, -78.154418899999939 41.647094121000066, -78.154407943999956 41.647182306000047, -78.154502117999982 41.647239476000038, -78.154599042999962 41.647287879000032, -78.15471331699996 41.647317233000081, -78.154899358999955 41.647323607000033, -78.15515090599996 41.647395293000045, -78.155318744999988 41.647440138000036, -78.15546388599995 41.647464960000036, -78.155500094999979 41.647338486000081, -78.155553408999936 41.647306197000034, -78.15561213899997 41.647258119000071, -78.155685401999961 41.647254628000042, -78.155762493999987 41.647217623000074)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T89 Fld2', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-78.152130821999947 41.649794507000081, -78.153318340999988 41.649951929000053, -78.154530432999934 41.650170384000035, -78.153982601999985 41.649506232000078, -78.154089369999951 41.649398898000072, -78.154130693999946 41.649290292000046, -78.15408038299995 41.648980711000036, -78.154026593999959 41.648638986000037, -78.153767204999951 41.648370379000028, -78.153269402999967 41.648265609000077, -78.152852754999969 41.648255281000047, -78.152498149999985 41.648400196000068, -78.152291332999937 41.648518659000047, -78.151902154999959 41.648530338000057, -78.151863261999949 41.648337400000059, -78.151771071999974 41.64810809200003, -78.151831479999942 41.647773848000043, -78.151889100999938 41.647295645000042, -78.151874696999982 41.647000658000024, -78.152137062999941 41.64664401400006, -78.152061512999978 41.646440350000034, -78.151831638999965 41.646526811000058, -78.15170600099998 41.646475732000056, -78.151028106999945 41.646726141000045, -78.150947023999947 41.647050039000078, -78.15083544099997 41.647268211000039, -78.150621254999976 41.647500835000073, -78.15048384499994 41.647615037000037, -78.150505031999955 41.648143739000034, -78.150711678999983 41.648276372000055, -78.15075133299996 41.648404822000032, -78.150822317999939 41.648593533000053, -78.150845414999935 41.648840540000037, -78.150532641999973 41.648832781000067, -78.150573128999952 41.64984310300008, -78.151098653999952 41.649768908000055, -78.151478057999952 41.649764098000048, -78.151695853999968 41.649769500000048, -78.152130821999947 41.649794507000081)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T89 Fld3', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-78.156463634999966 41.650737761000073, -78.161224867999977 41.650875801000041, -78.16122799599998 41.650175907000062, -78.16124718399999 41.649739171000078, -78.16128393799994 41.648902647000057, -78.161320356999965 41.648073688000068, -78.161404502999972 41.645811131000073, -78.158893747999969 41.645691862000035, -78.156138816999942 41.645577932000037, -78.150347736999947 41.645503020000035, -78.150476337999976 41.647427720000053, -78.15048384499994 41.647615037000037, -78.150621254999976 41.647500835000073, -78.15083544099997 41.647268211000039, -78.150947023999947 41.647050039000078, -78.151028106999945 41.646726141000045, -78.15170600099998 41.646475732000056, -78.151831638999965 41.646526811000058, -78.152061512999978 41.646440350000034, -78.152137062999941 41.64664401400006, -78.151874696999982 41.647000658000024, -78.151889100999938 41.647295645000042, -78.151831479999942 41.647773848000043, -78.151771071999974 41.64810809200003, -78.151863261999949 41.648337400000059, -78.151902154999959 41.648530338000057, -78.152291332999937 41.648518659000047, -78.152498149999985 41.648400196000068, -78.152852754999969 41.648255281000047, -78.153269402999967 41.648265609000077, -78.153767204999951 41.648370379000028, -78.154026593999959 41.648638986000037, -78.15408038299995 41.648980711000036, -78.154130693999946 41.649290292000046, -78.154089369999951 41.649398898000072, -78.153982601999985 41.649506232000078, -78.154530432999934 41.650170384000035, -78.153318340999988 41.649951929000053, -78.152130821999947 41.649794507000081, -78.151695853999968 41.649769500000048, -78.151478057999952 41.649764098000048, -78.151098653999952 41.649768908000055, -78.150573128999952 41.64984310300008, -78.150599751999948 41.650507469000047, -78.152906639999969 41.650548350000065, -78.156463634999966 41.650737761000073), (-78.155959584999948 41.650342944000045, -78.155127299999947 41.650196509000068, -78.154780969999933 41.650096440000027, -78.15472140899999 41.649717535000036, -78.154734490999942 41.649420476000046, -78.154455636999955 41.649173380000036, -78.154258986999935 41.648791069000026, -78.154364470999951 41.648473433000049, -78.154445160999956 41.648372494000057, -78.154248146999976 41.648344738000048, -78.154045596999936 41.648442657000032, -78.153527533999977 41.646702755000035, -78.153542631999983 41.64636000400003, -78.153804593999951 41.646297870000069, -78.154290504999949 41.646344223000028, -78.154485500999954 41.646417679000081, -78.155093772999976 41.646455624000055, -78.155991463999953 41.64650073100006, -78.156265136999934 41.646518944000036, -78.156278061999956 41.645878755000069, -78.15687361199997 41.645859186000052, -78.157650937999961 41.64586698800008, -78.158183047999955 41.645903031000046, -78.158242467999969 41.645938812000054, -78.158040245999985 41.646723007000048, -78.157903313999952 41.647062744000038, -78.158223345999943 41.647413788000051, -78.158816056999967 41.64780588900004, -78.158526800999937 41.648141859000077, -78.158333461999973 41.648377264000032, -78.158078530999944 41.648279456000068, -78.157830635999971 41.648021696000058, -78.15765287399995 41.647902922000071, -78.157618387999946 41.64799356900005, -78.157821589999969 41.648227348000034, -78.158072500999936 41.648416557000075, -78.158354882999959 41.648583669000061, -78.158426522999946 41.648688379000077, -78.158775362999961 41.648731321000071, -78.158943423999972 41.648724041000037, -78.159186138999985 41.648752920000049, -78.159674584999948 41.648742125000069, -78.160114822999958 41.648787324000068, -78.160538823999957 41.648854995000079, -78.160903401999974 41.648886874000027, -78.161001729999953 41.648889304000079, -78.160884953999982 41.649823438000055, -78.160214924999934 41.649979300000041, -78.159599069999956 41.650112759000081, -78.159027929999979 41.650270195000076, -78.158314337999968 41.649852229000032, -78.158088013999986 41.650144005000072, -78.157898182999986 41.650299432000054, -78.157623488999945 41.65030407200004, -78.157041622999941 41.650358295000046, -78.156643053999971 41.650405617000047, -78.155959584999948 41.650342944000045), (-78.154685112999971 41.650381032000041, -78.153746396999964 41.650315680000062, -78.153735737999966 41.650133015000051, -78.154524220999974 41.650243024000076, -78.154685112999971 41.650381032000041)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T89 Fld8', @aoiGeomFixed); -- End of AOI geometry section 4 -- 5. Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-89.806278797999937 44.851347223000062, -89.807045347999974 44.851349651000078, -89.806646831999956 44.848320677000061, -89.805774475999954 44.848227803000043, -89.805618129999971 44.847789662000025, -89.804033072999971 44.847779001000049, -89.803934571999946 44.848067238000056, -89.802536930999963 44.848078715000042, -89.802180537999959 44.849510826000028, -89.799472665999986 44.849514407000072, -89.799420631999965 44.848772560000043, -89.798231106999935 44.848767438000039, -89.798220040999979 44.84853905500006, -89.796200617999943 44.848555131000069, -89.79620906599996 44.84882843500003, -89.796118834999959 44.848956405000081, -89.795866420999971 44.849054052000042, -89.794889440999953 44.849123714000029, -89.794810847999941 44.849159937000081, -89.794724982999981 44.849876581000046, -89.794326431999991 44.849943504000066, -89.793781748999947 44.849979716000064, -89.793623803999935 44.849979703000031, -89.793603867999991 44.851306344000079, -89.799055930999941 44.85132410500006, -89.804478759999938 44.851341514000069, -89.806278797999937 44.851347223000062)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T4793 Fld11', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-89.797154318999958 44.845330503000071, -89.79704675499994 44.845393309000031, -89.797003503999974 44.845574898000052, -89.79680852499996 44.845579685000075, -89.796828705999985 44.846824488000038, -89.799373822999939 44.846785172000068, -89.803829786999984 44.846716203000028, -89.805967211999985 44.846683056000074, -89.805963937999991 44.846339869000076, -89.805989901999965 44.845881932000054, -89.80593782699998 44.845471628000041, -89.805902357999969 44.84507235600006, -89.805766181999957 44.84491564700005, -89.805621168999949 44.844907780000028, -89.805408621999959 44.844832977000067, -89.805214345999957 44.844803455000033, -89.805080391999979 44.844692421000047, -89.805079107999973 44.844665968000072, -89.804530967999938 44.84479426300004, -89.804033386999947 44.844806490000053, -89.803777214999968 44.844729407000045, -89.803771676999986 44.844584302000044, -89.803495157999976 44.844551983000031, -89.803473051999958 44.844474280000043, -89.802409591999947 44.844467795000071, -89.802380218999986 44.844194664000042, -89.801008667999952 44.844180671000061, -89.799395345999983 44.844157811000059, -89.79710283299994 44.844132854000065, -89.797122743999978 44.844812827000055, -89.797154318999958 44.845330503000071)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T4793 Fld3', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-89.796725975999948 44.845804267000062, -89.796711229999971 44.846588361000045, -89.796720278999942 44.847633382000026, -89.796829483999943 44.847594121000043, -89.797487875999991 44.84758369900004, -89.797452724999971 44.847087159000068, -89.806261473999939 44.847128932000032, -89.806465764999984 44.847101115000044, -89.806437504999963 44.846850291000067, -89.806221519999951 44.846679107000057, -89.805967211999985 44.846683056000074, -89.803829786999984 44.846716203000028, -89.799373822999939 44.846785172000068, -89.796828705999985 44.846824488000038, -89.79680852499996 44.845579685000075, -89.796703236999974 44.845585560000075, -89.796725975999948 44.845804267000062)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T4793 Fld4', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-89.796200617999943 44.848555131000069, -89.798220040999979 44.84853905500006, -89.798231106999935 44.848767438000039, -89.799420631999965 44.848772560000043, -89.799472665999986 44.849514407000072, -89.802180537999959 44.849510826000028, -89.802536930999963 44.848078715000042, -89.803934571999946 44.848067238000056, -89.804033072999971 44.847779001000049, -89.805618129999971 44.847789662000025, -89.80632061099999 44.847794389000057, -89.806261473999939 44.847128932000032, -89.797452724999971 44.847087159000068, -89.797487875999991 44.84758369900004, -89.796829483999943 44.847594121000043, -89.796720278999942 44.847633382000026, -89.796654497999953 44.847657040000058, -89.796174055999984 44.847696369000062, -89.796200617999943 44.848555131000069)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T4793 Fld5', @aoiGeomFixed); -- End of AOI geometry section 5 -- 6. Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-99.519358715999942 39.444600988000047, -99.519354667999949 39.444055865000053, -99.519354791999945 39.440257895000059, -99.51933713699998 39.438370253000073, -99.519328272999985 39.43746923100008, -99.518347779999942 39.437464594000062, -99.515520414999969 39.437463644000047, -99.512736734999976 39.437475947000053, -99.510091092999971 39.43749659100007, -99.510110347999955 39.440136615000029, -99.510097123999969 39.444646480000074, -99.510439879999979 39.444635966000078, -99.512816226999973 39.444652545000054, -99.515008055999942 39.444665387000043, -99.519358715999942 39.444600988000047)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T328 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-99.502655798999967 39.444688887000041, -99.503685699999949 39.444680414000061, -99.503655765999952 39.444582341000057, -99.503578067999968 39.444436119000045, -99.503539320999948 39.444367555000042, -99.503480911999986 39.44423418100007, -99.503393565999943 39.44407123700006, -99.503430633999983 39.443900330000076, -99.503525629999956 39.443795986000055, -99.503629878999959 39.443647059000057, -99.503677001999961 39.443542922000063, -99.503675344999976 39.443312793000075, -99.503636512999947 39.443238723000036, -99.503529912999966 39.443061015000069, -99.503682725999965 39.443008386000031, -99.503817086999959 39.443052347000048, -99.503904272999989 39.443193022000059, -99.503943585999991 39.443333902000063, -99.503935081999941 39.443482414000073, -99.503897373999962 39.443564239000068, -99.503793018999943 39.443698319000077, -99.503697862999957 39.443780392000065, -99.503593826999975 39.44395901300004, -99.503603989999988 39.444040631000064, -99.503642928999966 39.444129547000045, -99.503749156999959 39.444255290000058, -99.503798045999986 39.444396131000076, -99.503904861999956 39.444603533000077, -99.503905402999976 39.444678605000036, -99.509842420999973 39.444629576000068, -99.509840744999963 39.444399813000075, -99.509856849999949 39.442232077000028, -99.508870042999945 39.442231613000047, -99.506711712999959 39.442250572000034, -99.505864299999985 39.442259252000042, -99.505737713999963 39.442176614000061, -99.50534021499999 39.441632392000031, -99.505176412999958 39.441536127000063, -99.504974582999978 39.441462356000045, -99.504570190999971 39.441213025000025, -99.503904197999987 39.440768481000077, -99.503786842999943 39.440598885000043, -99.503721080999981 39.440439041000047, -99.503616742999952 39.440213193000034, -99.503314304999947 39.439550463000046, -99.502741295999954 39.43857164700006, -99.50266725299997 39.438331668000046, -99.502569039999969 39.437748365000061, -99.502584827999954 39.437569751000069, -99.501667754999971 39.437582774000077, -99.50109228599996 39.437590414000056, -99.501191334999987 39.437861066000039, -99.501194667999982 39.438326102000076, -99.501198665999937 39.438884145000031, -99.501321678999943 39.439311462000035, -99.501515994999977 39.439645459000076, -99.50151746399996 39.439850075000038, -99.501544120999938 39.440222000000063, -99.501570778999962 39.44059392500003, -99.501573180999969 39.440928750000069, -99.501623293999955 39.441226165000046, -99.501912911999966 39.441466743000035, -99.502323549999971 39.441855611000051, -99.502661818999968 39.442188987000065, -99.502666766999937 39.442877238000051, -99.502655798999967 39.444688887000041), (-99.503789677999976 39.442300621000072, -99.503728034999938 39.442373189000079, -99.503580485999976 39.442385879000028, -99.503472264999971 39.442464673000075, -99.503394257999958 39.442422835000059, -99.503370554999947 39.442368712000075, -99.503478646999952 39.442271843000071, -99.503641693999953 39.442253062000077, -99.503789677999976 39.442300621000072)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T329 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-99.500661603999959 39.437596129000042, -99.500693890999969 39.442105801000025, -99.500606690999973 39.444331796000029, -99.50060175599998 39.444705757000065, -99.502655798999967 39.444688887000041, -99.502666766999937 39.442877238000051, -99.502661818999968 39.442188987000065, -99.502323549999971 39.441855611000051, -99.501912911999966 39.441466743000035, -99.501623293999955 39.441226165000046, -99.501573180999969 39.440928750000069, -99.501570778999962 39.44059392500003, -99.501544120999938 39.440222000000063, -99.50151746399996 39.439850075000038, -99.501515994999977 39.439645459000076, -99.501321678999943 39.439311462000035, -99.501198665999937 39.438884145000031, -99.501194667999982 39.438326102000076, -99.501191334999987 39.437861066000039, -99.50109228599996 39.437590414000056, -99.500661603999959 39.437596129000042)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T329 Fld4', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-99.505864299999985 39.442259252000042, -99.506711712999959 39.442250572000034, -99.508870042999945 39.442231613000047, -99.509856849999949 39.442232077000028, -99.509859254999981 39.44190830000008, -99.509880038999938 39.440673756000081, -99.509878105999974 39.439461838000057, -99.509862760999965 39.438304042000027, -99.509850209999968 39.437529184000027, -99.508358855999973 39.437535711000066, -99.507066184999985 39.437545869000076, -99.506973957999946 39.437546270000041, -99.506941497999946 39.43767705700003, -99.50689674399996 39.437713294000048, -99.50672788299994 39.437714030000052, -99.506592572999978 39.437683082000035, -99.506483964999973 39.437629492000042, -99.50648244599995 39.438021460000073, -99.506484142999966 39.438255728000058, -99.506535566999958 39.438336600000071, -99.506541681999977 39.438426679000031, -99.506513939999991 39.438458337000043, -99.506440484999985 39.438445141000045, -99.506395228999963 39.438413792000063, -99.50637223199999 39.438346322000029, -99.506416378999972 39.438224485000035, -99.506432338999957 39.438071236000042, -99.50641765599994 39.437548693000053, -99.504176826999981 39.437558429000035, -99.50415351099997 39.438252338000041, -99.504216343999985 39.438355687000069, -99.504217155999982 39.438468316000069, -99.504121354999938 39.438477742000032, -99.504070726999942 39.438455435000037, -99.504053364999947 39.438414963000071, -99.504103227999963 39.438279587000068, -99.504098032999991 39.437558769000077, -99.503033356999993 39.437563379000039, -99.502584827999954 39.437569751000069, -99.502569039999969 39.437748365000061, -99.50266725299997 39.438331668000046, -99.502741295999954 39.43857164700006, -99.503314304999947 39.439550463000046, -99.503616742999952 39.440213193000034, -99.503721080999981 39.440439041000047, -99.503786842999943 39.440598885000043, -99.503904197999987 39.440768481000077, -99.504570190999971 39.441213025000025, -99.504974582999978 39.441462356000045, -99.505176412999958 39.441536127000063, -99.50534021499999 39.441632392000031, -99.505737713999963 39.442176614000061, -99.505864299999985 39.442259252000042)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T329 Fld5', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-99.503529912999966 39.443061015000069, -99.503636512999947 39.443238723000036, -99.503675344999976 39.443312793000075, -99.503677001999961 39.443542922000063, -99.503629878999959 39.443647059000057, -99.503525629999956 39.443795986000055, -99.503430633999983 39.443900330000076, -99.503393565999943 39.44407123700006, -99.503480911999986 39.44423418100007, -99.503539320999948 39.444367555000042, -99.503578067999968 39.444436119000045, -99.503655765999952 39.444582341000057, -99.503685699999949 39.444680414000061, -99.503905402999976 39.444678605000036, -99.503904861999956 39.444603533000077, -99.503798045999986 39.444396131000076, -99.503749156999959 39.444255290000058, -99.503642928999966 39.444129547000045, -99.503603989999988 39.444040631000064, -99.503593826999975 39.44395901300004, -99.503697862999957 39.443780392000065, -99.503793018999943 39.443698319000077, -99.503897373999962 39.443564239000068, -99.503935081999941 39.443482414000073, -99.503943585999991 39.443333902000063, -99.503904272999989 39.443193022000059, -99.503817086999959 39.443052347000048, -99.503682725999965 39.443008386000031, -99.503529912999966 39.443061015000069)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T329 Fld6', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-99.503478646999952 39.442271843000071, -99.503370554999947 39.442368712000075, -99.503394257999958 39.442422835000059, -99.503472264999971 39.442464673000075, -99.503580485999976 39.442385879000028, -99.503728034999938 39.442373189000079, -99.503789677999976 39.442300621000072, -99.503641693999953 39.442253062000077, -99.503478646999952 39.442271843000071)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T329 Fld7', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-99.500579347999974 39.451216011000042, -99.500753545999942 39.451449536000041, -99.500959167999952 39.451709958000038, -99.501105645999985 39.451826465000067, -99.501284854999938 39.451897777000056, -99.501545873999987 39.45203181100004, -99.501581768999984 39.452022645000056, -99.503224840999962 39.452011042000038, -99.504869086999975 39.451991428000042, -99.506285078999952 39.451964557000053, -99.509812084999965 39.451949150000075, -99.509891109999955 39.451793434000081, -99.509886309999956 39.444724328000063, -99.509842420999973 39.444629576000068, -99.503905402999976 39.444678605000036, -99.503685699999949 39.444680414000061, -99.502655798999967 39.444688887000041, -99.50060175599998 39.444705757000065, -99.500602400999981 39.444795861000046, -99.500567633999992 39.448463325000034, -99.500569656999971 39.450369057000046, -99.500577121999982 39.450905155000044, -99.500579347999974 39.451216011000042)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T330 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-99.510097123999969 39.444646480000074, -99.510095421999949 39.445209650000038, -99.510083495999936 39.447705639000048, -99.510088434999943 39.450174519000029, -99.510087983999938 39.451904554000066, -99.512980638999977 39.451864800000067, -99.515765065999972 39.451825454000073, -99.518532376999985 39.451831170000048, -99.51929875899998 39.451832256000046, -99.519347929999981 39.447939462000079, -99.519358715999942 39.444600988000047, -99.515008055999942 39.444665387000043, -99.512816226999973 39.444652545000054, -99.510439879999979 39.444635966000078, -99.510097123999969 39.444646480000074)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T9518 Fld2', @aoiGeomFixed); -- End of AOI geometry section 6 -- 7.Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-69.109603879999952 44.992930255000033, -69.109768238999948 44.992940702000055, -69.110087030999978 44.99289275700005, -69.110581920999948 44.992785102000028, -69.111177452999982 44.992653527000073, -69.111630523999963 44.992617357000029, -69.112092061999988 44.992622855000036, -69.112133899999947 44.992557316000045, -69.112183948999984 44.992408410000053, -69.112011546999952 44.992215056000077, -69.112304814999959 44.991982544000052, -69.112866370999939 44.991654501000028, -69.113360962999934 44.991397968000058, -69.113649886999951 44.991108890000078, -69.113582528999984 44.990995829000042, -69.113506610999934 44.990793451000059, -69.113749654999936 44.99064435300005, -69.11358110599997 44.990275342000075, -69.113387341999953 44.989882545000057, -69.113252854999985 44.989769542000033, -69.113265059999947 44.989570047000029, -69.113239572999987 44.989415266000037, -69.113188931999957 44.989266460000067, -69.113112863999959 44.988986674000046, -69.11305379099997 44.98881405700007, -69.113028353999937 44.988677126000027, -69.112961163999955 44.988647424000078, -69.112969327999963 44.988534278000031, -69.112868431999971 44.988433151000038, -69.112717412999984 44.988433301000043, -69.11245729999996 44.988439517000074, -69.112037863999944 44.988493518000041, -69.111534488999951 44.988529739000057, -69.110871788999987 44.988619702000051, -69.110603300999969 44.988631872000042, -69.110556756999983 44.988426483000069, -69.110497371999941 44.988087140000061, -69.110480073999952 44.987819205000051, -69.110328540999944 44.98756331800007, -69.11005159299998 44.987533807000034, -69.109850284999936 44.987569729000029, -69.109514626999953 44.987552192000066, -69.109111908999978 44.987570436000055, -69.109036132999961 44.987433554000063, -69.108893286999944 44.987326513000028, -69.108624782999982 44.987326768000059, -69.108113119999985 44.98741657100004, -69.107567957999947 44.987542132000044, -69.107198958999959 44.987643706000028, -69.107173967999984 44.987738997000065, -69.10724969499995 44.987852063000048, -69.107527621999964 44.988405556000032, -69.107835050999938 44.989027508000049, -69.108214091999969 44.989795267000034, -69.108576381999967 44.990574951000042, -69.10851207199994 44.990666517000079, -69.108985299999972 44.991607661000046, -69.109603879999952 44.992930255000033)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T22 Fld4', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-69.108409932999962 44.99063007500007, -69.108316324999976 44.990616886000055, -69.108207071999971 44.990527672000042, -69.108164873999954 44.990396708000048, -69.108030038999971 44.990087213000038, -69.107798331999959 44.989578327000061, -69.107520493999971 44.989084373000026, -69.107419342999947 44.988834385000075, -69.107285203999936 44.988894050000056, -69.10728514699997 44.98886428000003, -69.107234766999966 44.988846459000058, -69.107159248999949 44.988846530000046, -69.107033496999975 44.988906196000073, -69.107041758999969 44.988840690000075, -69.106907475999947 44.988822956000035, -69.106764761999955 44.98878736000006, -69.106664186999978 44.988852953000048, -69.106596913999965 44.988769648000073, -69.106579865999947 44.988626758000066, -69.106487192999964 44.988424400000042, -69.106402904999982 44.988222025000027, -69.106310431999987 44.988126843000032, -69.106092323999974 44.988156816000071, -69.105861717999971 44.98823145800003, -69.105610087999935 44.988285279000081, -69.105408741999952 44.988303334000079, -69.105316585999958 44.988380827000071, -69.10531670599994 44.988446325000041, -69.105426102999957 44.988618899000073, -69.105476801999941 44.988809397000068, -69.105620038999973 44.989130814000077, -69.10574612399995 44.989249775000076, -69.105865635999976 44.989368562000038, -69.10585580999998 44.989577155000063, -69.105962918999978 44.989711447000047, -69.106082810999965 44.989821086000063, -69.106292595999946 44.989814941000077, -69.106468719999953 44.989779048000059, -69.106611490999967 44.989844413000071, -69.106657889999951 44.989978346000044, -69.106817798999941 44.990247975000045, -69.107003320999979 44.990728281000031, -69.106911083999933 44.990764088000049, -69.106768444999943 44.990770180000027, -69.106684571999949 44.990794078000079, -69.106584005999935 44.990859669000031, -69.106424745999959 44.990955085000053, -69.106315658999961 44.990955187000054, -69.106265353999959 44.990979053000046, -69.106273970999951 44.991098131000058, -69.106316088999961 44.991187410000066, -69.106391895999934 44.991342154000051, -69.106606350999982 44.991595017000066, -69.106807885999956 44.991672237000046, -69.106975797999951 44.99171971700008, -69.106992858999945 44.991868558000078, -69.10705194999997 44.992059046000065, -69.107153126999947 44.992320936000056, -69.107178541999986 44.992445958000076, -69.10738878899997 44.992695852000054, -69.107388888999935 44.992749441000058, -69.107414282999969 44.992862553000066, -69.107406073999982 44.992963788000054, -69.107469260999949 44.993097704000036, -69.107654563999972 44.993466699000066, -69.107755446999988 44.993561871000054, -69.107890064999935 44.993752288000053, -69.108008136999956 44.994061807000037, -69.107915985999966 44.994145262000075, -69.10791611999997 44.994216710000046, -69.107949921999989 44.994347665000078, -69.108067904999984 44.994609555000068, -69.108160537999936 44.994782151000038, -69.108285341999988 44.994858423000039, -69.110273860999939 44.994559079000055, -69.110135812999943 44.994265200000029, -69.109567024999933 44.993036154000038, -69.108981490999952 44.991807139000059, -69.108409932999962 44.99063007500007)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T22 Fld5', @aoiGeomFixed); -- End of AOI geometry section 7 -- 8. Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-82.419432968999956 29.064175663000071, -82.419482105999975 29.068333231000054, -82.427298153999971 29.068169147000049, -82.427293271999986 29.067057017000025, -82.427280993999943 29.066678809000052, -82.427272390999974 29.066567260000056, -82.427220556999941 29.06639414600005, -82.427126080999983 29.066202877000023, -82.42695125299997 29.065820188000032, -82.426868583999976 29.065461337000045, -82.426873353999952 29.065293820000079, -82.426906708999979 29.065150817000074, -82.427074224999956 29.063976793000052, -82.427173593999953 29.063498157000026, -82.427283283999941 29.06325509100003, -82.427449991999936 29.063048645000038, -82.427624606999984 29.062904130000049, -82.427820934999943 29.062796601000059, -82.428010621999988 29.062720159000037, -82.428509643999973 29.062534983000035, -82.428643092999948 29.062477738000041, -82.428684535999935 29.062409073000026, -82.428264592999938 29.061226121000061, -82.428318162999972 29.061112582000078, -82.429861725999956 29.060684691000063, -82.430348316999982 29.060623690000057, -82.430913301999965 29.060611459000029, -82.43112502699995 29.060596803000067, -82.431272849999971 29.060558010000079, -82.43134211399996 29.060458039000025, -82.431375374999959 29.060308828000075, -82.431393048999951 29.060054340000079, -82.431377058999942 29.057362695000052, -82.431388960999982 29.057201312000075, -82.431437027999948 29.057101558000056, -82.43154220699995 29.057044611000038, -82.431654963999961 29.057024800000079, -82.434572580999941 29.057003832000078, -82.435341568999945 29.056960624000055, -82.435425967999947 29.056934914000067, -82.435460177999971 29.056853923000062, -82.435398078999981 29.053389953000078, -82.432301485999972 29.053456209000046, -82.423292557999957 29.053436971000053, -82.423318279999989 29.053869619000068, -82.423322793999944 29.054198294000059, -82.423303905999944 29.055395547000046, -82.423308077999934 29.055699418000074, -82.423262813999941 29.056003813000075, -82.423216433999983 29.056227587000024, -82.423134406999964 29.056426931000033, -82.423051856999962 29.056589072000065, -82.422934000999987 29.056751570000074, -82.42280167399997 29.056889430000069, -82.422661855999934 29.056996353000045, -82.422430472999963 29.057122856000035, -82.422191779999935 29.05723082600008, -82.422001660999967 29.057276257000069, -82.421747644999982 29.057297556000037, -82.420971039999984 29.057330586000035, -82.420596516999979 29.05732215200004, -82.419331522999983 29.05728590700005, -82.419432968999956 29.064175663000071)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T3042 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-82.408545687999947 29.068366916000059, -82.414971951999973 29.068337075000045, -82.41492035899995 29.060990083000036, -82.410588159999975 29.060983270000065, -82.40854174399999 29.060974455000064, -82.408545687999947 29.068366916000059)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T3239 Fld21', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-82.40854174399999 29.060974455000064, -82.410588159999975 29.060983270000065, -82.410574553999936 29.053439946000026, -82.408760619999953 29.053448723000031, -82.408641038999974 29.057257978000052, -82.408581054999956 29.059998428000029, -82.40854174399999 29.060974455000064)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T3239 Fld22', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-82.41492035899995 29.060990083000036, -82.414971951999973 29.068337075000045, -82.419279590999963 29.068337439000061, -82.419197690999965 29.060937953000064, -82.41492035899995 29.060990083000036)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T3644 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-82.41492035899995 29.060990083000036, -82.419197690999965 29.060937953000064, -82.419159988999979 29.053550145000031, -82.414894943999968 29.053443583000046, -82.41492035899995 29.060990083000036)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T3644 Fld2', @aoiGeomFixed); -- End of AOI geometry section 8 -- 9. Insert identifier string and WKT geometry for each AOI polygon after this... SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.399337938999963 39.027054616000044, -81.399518262999948 39.027103155000077, -81.399726597999972 39.027288389000034, -81.400205766999989 39.02771520400006, -81.400778229999958 39.02814171600005, -81.401157203999958 39.028456907000077, -81.401812919999941 39.02820822800004, -81.401811429999952 39.027945005000049, -81.401883752999936 39.027761647000034, -81.402055288999975 39.026959954000063, -81.402185194999959 39.026581844000077, -81.402227392999976 39.026261248000026, -81.402292910999961 39.025902734000056, -81.402133503999949 39.025873439000065, -81.401998491999962 39.025825396000073, -81.401935985999955 39.025769021000031, -81.401472610999974 39.025687244000039, -81.401449200999934 39.025827288000073, -81.400712527999985 39.025684298000044, -81.400702530999979 39.025749014000041, -81.400598483999943 39.025676606000047, -81.400484382999934 39.025660832000028, -81.400308060999976 39.025637187000029, -81.400350103999983 39.025742133000051, -81.399966395999968 39.02570303400006, -81.399865127999988 39.02556603000005, -81.399820990999956 39.025646940000058, -81.399707219999982 39.025687747000063, -81.399644622999972 39.025615203000029, -81.399538268999947 39.025534881000056, -81.399364427999956 39.025551490000055, -81.39944789599997 39.025648219000061, -81.39945985199995 39.025931132000039, -81.39948125799998 39.026052323000044, -81.400000512999952 39.026236483000048, -81.400281578999966 39.02645379900008, -81.400677147999943 39.026759644000037, -81.400792974999945 39.02708261600003, -81.400585914999965 39.02712375200008, -81.40041821899996 39.026792866000051, -81.400271842999985 39.026567005000061, -81.399918272999969 39.02635803000004, -81.399544127999945 39.026173373000063, -81.399357658999975 39.026190178000036, -81.399337938999963 39.027054616000044)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T241 Fld2', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.398918838999975 39.029028031000053, -81.399887396999986 39.029059048000079, -81.400459546999969 39.029045641000039, -81.400855630999956 39.029032828000027, -81.400992155999973 39.02904337800004, -81.400936867999974 39.028966567000055, -81.400819037999952 39.028886863000025, -81.400818326999968 39.028760977000047, -81.400935315999959 39.028691909000031, -81.401022895999972 39.028611498000032, -81.401051592999977 39.028496957000073, -81.401021860999947 39.02842839200008, -81.400830413999984 39.028303163000032, -81.400727708999966 39.028303516000051, -81.400640064999948 39.028372483000055, -81.400537683999971 39.028430056000047, -81.400464258999989 39.02841886300007, -81.400419854999939 39.028350350000039, -81.40040486099997 39.028293180000048, -81.400345913999956 39.028247606000036, -81.400287225999989 39.028247806000024, -81.40024340399998 39.02828229000005, -81.400141086999952 39.028351308000026, -81.40008246299999 39.028362952000066, -81.400038188999986 39.028317328000071, -81.399993592999976 39.028214481000077, -81.399949382999978 39.028180291000069, -81.399875700999985 39.028123321000066, -81.399728980999953 39.02812382500008, -81.399552915999948 39.02812442700008, -81.399420804999977 39.028113436000069, -81.399273955999945 39.028091050000057, -81.399200402999952 39.028056968000044, -81.399141263999979 39.027977061000058, -81.399050873999954 39.027907172000027, -81.399045225999942 39.028020499000036, -81.398918838999975 39.029028031000053)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T241 Fld3', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.400830413999984 39.028303163000032, -81.400476885999979 39.028005320000034, -81.400060527999983 39.027691453000045, -81.399758607999956 39.02744995900008, -81.399591768999983 39.027272675000063, -81.399435622999988 39.027151945000071, -81.399269660999948 39.027128264000055, -81.399089744999969 39.027127699000062, -81.399050873999954 39.027907172000027, -81.399141263999979 39.027977061000058, -81.399200402999952 39.028056968000044, -81.399273955999945 39.028091050000057, -81.399420804999977 39.028113436000069, -81.399552915999948 39.02812442700008, -81.399728980999953 39.02812382500008, -81.399875700999985 39.028123321000066, -81.399949382999978 39.028180291000069, -81.399993592999976 39.028214481000077, -81.400038188999986 39.028317328000071, -81.40008246299999 39.028362952000066, -81.400141086999952 39.028351308000026, -81.40024340399998 39.02828229000005, -81.400287225999989 39.028247806000024, -81.400345913999956 39.028247606000036, -81.40040486099997 39.028293180000048, -81.400419854999939 39.028350350000039, -81.400464258999989 39.02841886300007, -81.400537683999971 39.028430056000047, -81.400640064999948 39.028372483000055, -81.400727708999966 39.028303516000051, -81.400830413999984 39.028303163000032)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T241 Fld6', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.399337938999963 39.027054616000044, -81.399357658999975 39.026190178000036, -81.399544127999945 39.026173373000063, -81.399918272999969 39.02635803000004, -81.400271842999985 39.026567005000061, -81.40041821899996 39.026792866000051, -81.400585914999965 39.02712375200008, -81.400792974999945 39.02708261600003, -81.400677147999943 39.026759644000037, -81.400281578999966 39.02645379900008, -81.400000512999952 39.026236483000048, -81.39948125799998 39.026052323000044, -81.39945985199995 39.025931132000039, -81.39944789599997 39.025648219000061, -81.399364427999956 39.025551490000055, -81.399538268999947 39.025534881000056, -81.399464269999953 39.025523799000041, -81.399171907999971 39.025480013000049, -81.399093368999957 39.02705506500007, -81.399310667999941 39.027047284000048, -81.399337938999963 39.027054616000044)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T241 Fld7', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.399865127999988 39.02556603000005, -81.399625794999963 39.025547981000045, -81.399538268999947 39.025534881000056, -81.399644622999972 39.025615203000029, -81.399707219999982 39.025687747000063, -81.399820990999956 39.025646940000058, -81.399865127999988 39.02556603000005)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T241 Fld8', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.399865127999988 39.02556603000005, -81.399966395999968 39.02570303400006, -81.400350103999983 39.025742133000051, -81.400308060999976 39.025637187000029, -81.400484382999934 39.025660832000028, -81.400598483999943 39.025676606000047, -81.400702530999979 39.025749014000041, -81.400712527999985 39.025684298000044, -81.401449200999934 39.025827288000073, -81.401472610999974 39.025687244000039, -81.399865127999988 39.02556603000005)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T241 Fld9', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.394628946999944 39.026552916000071, -81.394452565999984 39.026493813000059, -81.393982310999945 39.026358062000043, -81.393408974999943 39.02615399900003, -81.392174159999968 39.025723282000058, -81.391940046999935 39.025838503000045, -81.391661983999938 39.025965324000026, -81.391340281999987 39.026160957000059, -81.391121154999951 39.026333357000055, -81.390872995999985 39.02656307500007, -81.390508218999969 39.02693051500006, -81.390099474999943 39.027309545000037, -81.389837141999976 39.02763086300007, -81.389750744999958 39.027928704000033, -81.389694255999984 39.028329454000072, -81.390007902999969 39.029335504000073, -81.390262554999936 39.030284531000063, -81.390590662999955 39.031244755000046, -81.390754004999962 39.031598981000059, -81.391282347999947 39.031620099000065, -81.391971903999945 39.031606340000053, -81.393424501999959 39.03160144900005, -81.394468655999958 39.031597923000049, -81.39457136499999 39.029388823000033, -81.394635422999954 39.027717728000027, -81.394628946999944 39.026552916000071)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T242 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.394468655999958 39.031597923000049, -81.394554300999971 39.031597633000047, -81.395185035999987 39.031561165000028, -81.39659420199996 39.031659381000054, -81.397372368999982 39.031748288000074, -81.398180074999971 39.031871422000052, -81.39948691799998 39.032038617000069, -81.40008914699996 39.032150997000031, -81.40098451199998 39.032205143000056, -81.401615701999958 39.032248749000075, -81.401621462999969 39.03213161900004, -81.402214410999989 39.029360378000035, -81.401891334999959 39.029100614000072, -81.401627300999962 39.029112968000049, -81.401333726999951 39.029091091000055, -81.400776119999989 39.029081562000044, -81.399837164999951 39.029096229000061, -81.398942097999964 39.029087849000064, -81.39892851899998 39.029282441000078, -81.39878797099999 39.030381584000054, -81.398661190999974 39.031320451000056, -81.397927301999971 39.031277179000028, -81.396973130999982 39.031200320000039, -81.397014843999955 39.030788183000027, -81.397084492999966 39.030124176000072, -81.396424106999973 39.030103534000034, -81.396521825999969 39.029210545000069, -81.396630824999988 39.027710960000036, -81.396684970999956 39.026898230000029, -81.396376864999979 39.026899277000041, -81.395951373999935 39.02690072200005, -81.395540181999934 39.026833451000073, -81.395128735999947 39.02672040200008, -81.394628946999944 39.026552916000071, -81.394635422999954 39.027717728000027, -81.39457136499999 39.029388823000033, -81.394468655999958 39.031597923000049)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T252 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.401472610999974 39.025687244000039, -81.401963596999963 39.025724257000036, -81.402024070999971 39.025731807000057, -81.402003488999981 39.025700031000042, -81.401767708999955 39.025517735000051, -81.401576267999985 39.025392507000049, -81.401208759999975 39.025267883000026, -81.401032638999936 39.025257045000046, -81.400943187999985 39.025005578000048, -81.400942670999939 39.024914025000044, -81.400986361999969 39.024856653000029, -81.40120733699996 39.025016113000049, -81.401398786999948 39.02514134200004, -81.401633463999985 39.025129090000064, -81.401721362999979 39.025105900000028, -81.40176155499995 39.024430546000076, -81.401879442999984 39.024521694000043, -81.401967470999978 39.024521392000054, -81.402040696999961 39.024498251000068, -81.402143071999944 39.02444067600004, -81.402174423999952 39.024795342000061, -81.402190014999974 39.024955508000062, -81.402219799999955 39.025035516000059, -81.402440129999945 39.025080542000069, -81.40258094099994 39.025088491000076, -81.402494981999951 39.024231265000026, -81.401583169999981 39.024019164000038, -81.400319761999981 39.023725955000032, -81.400306898999986 39.024046439000074, -81.400293130999955 39.024206698000057, -81.400352202999954 39.024275170000067, -81.400396797999974 39.02437801700006, -81.400456450999968 39.024549477000051, -81.400442748999978 39.024721189000047, -81.400502014999972 39.024823984000079, -81.400693322999985 39.024926325000024, -81.400752395999973 39.024994788000072, -81.400752654999962 39.02504056500004, -81.400650083999949 39.025063807000038, -81.400591721999945 39.025121229000035, -81.40060684499997 39.025201287000073, -81.400680460999979 39.025246811000045, -81.400636962999954 39.025338515000044, -81.400534768999989 39.025430421000067, -81.400432208999973 39.025453653000056, -81.400402414999974 39.025373654000077, -81.400343212999985 39.025282301000061, -81.400240447999977 39.025271211000074, -81.400137748999953 39.025271563000047, -81.400123592999989 39.025363166000034, -81.400094379999985 39.025386155000035, -81.400021215999971 39.025420739000026, -81.399932940999975 39.025375264000047, -81.399741620999976 39.025272921000067, -81.399535704999948 39.025182072000064, -81.399403856999982 39.025216855000053, -81.399345556999947 39.025285721000046, -81.399346008999942 39.025365830000055, -81.399464216999945 39.025514202000068, -81.399464269999953 39.025523799000041, -81.399538268999947 39.025534881000056, -81.399625794999963 39.025547981000045, -81.399865127999988 39.02556603000005, -81.401472610999974 39.025687244000039)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T262 Fld1', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.400319761999981 39.023725955000032, -81.401583169999981 39.024019164000038, -81.402494981999951 39.024231265000026, -81.402485871999943 39.024140490000036, -81.402455005999968 39.023983917000066, -81.402272193999977 39.023925236000025, -81.40196371199994 39.02385763400008, -81.401802005999969 39.023800969000035, -81.401816417999953 39.023755142000027, -81.401874388999943 39.023629046000053, -81.401946966999958 39.023491473000036, -81.402063686999952 39.023376627000061, -81.402121527999952 39.02322765200006, -81.402135290999979 39.023067384000058, -81.402178472999935 39.022918459000039, -81.402221500999985 39.022746645000041, -81.402162752999971 39.022735404000059, -81.401766703999954 39.022748213000057, -81.401150451999968 39.022738889000038, -81.400372637999965 39.022695784000064, -81.400363384999935 39.022841213000049, -81.400345683999944 39.023119316000077, -81.400319761999981 39.023725955000032)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T262 Fld2', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.398767329999941 39.024211924000042, -81.399046338999938 39.024256756000057, -81.39929581399997 39.02426734800008, -81.399574564999966 39.024266392000072, -81.399897267999961 39.024253842000064, -81.400293130999955 39.024206698000057, -81.400306898999986 39.024046439000074, -81.400319761999981 39.023725955000032, -81.400345683999944 39.023119316000077, -81.400363384999935 39.022841213000049, -81.400094665999973 39.022834070000044, -81.399786500999937 39.02282368200008, -81.399360926999975 39.02280225100003, -81.398935213999948 39.022757930000068, -81.398348251999948 39.022737047000078, -81.398452937999934 39.023091464000061, -81.398647710999967 39.023811791000071, -81.398767329999941 39.024211924000042)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T262 Fld3', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.398348251999948 39.022737047000078, -81.398243692999984 39.022405519000074, -81.398198074999982 39.022119567000061, -81.398079104999965 39.021833855000068, -81.39803419499998 39.021673788000044, -81.397871855999938 39.021502677000058, -81.397857826999939 39.021617168000034, -81.397844503999977 39.021857544000056, -81.397830730999942 39.022017812000058, -81.397875767999949 39.02220077700008, -81.397951174999946 39.02256673800008, -81.398011526999937 39.02286407500003, -81.398072969999987 39.023355980000076, -81.398119872999985 39.023870815000066, -81.398180545999935 39.024225383000044, -81.398241862999953 39.024694389000047, -81.398418817999982 39.024854006000055, -81.398492880999981 39.024979640000026, -81.398582193999971 39.025208221000071, -81.398625693999975 39.025116519000051, -81.398698473999957 39.025013272000081, -81.39875683799994 39.024955850000026, -81.398932751999951 39.024932360000037, -81.398872470999947 39.024646458000063, -81.398767329999941 39.024211924000042, -81.398647710999967 39.023811791000071, -81.398452937999934 39.023091464000061, -81.398348251999948 39.022737047000078)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T262 Fld4', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.400372637999965 39.022695784000064, -81.401150451999968 39.022738889000038, -81.401766703999954 39.022748213000057, -81.402162752999971 39.022735404000059, -81.402221500999985 39.022746645000041, -81.402160288999937 39.022300528000073, -81.402112904999967 39.021705577000034, -81.40205150099996 39.021225127000037, -81.401976268999988 39.020893501000046, -81.401829628999963 39.020905451000033, -81.401727970999957 39.021088901000041, -81.401361143999964 39.021078728000077, -81.401008780999973 39.021034162000035, -81.400861687999964 39.02096600200008, -81.400758864999943 39.020943467000052, -81.400656236999964 39.020955264000065, -81.400568729999975 39.021047119000059, -81.400496216999954 39.021196135000025, -81.400570731999949 39.021401895000054, -81.400630189999958 39.021539014000041, -81.400601558999938 39.021665000000041, -81.400543004999975 39.021688090000055, -81.40042551099998 39.021665604000077, -81.400367021999955 39.021700138000028, -81.40035312599997 39.021837518000041, -81.400355255999955 39.022215182000025, -81.400356675999944 39.022466952000059, -81.40034316699996 39.02267299600004, -81.400372637999965 39.022695784000064)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T262 Fld5', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.399171907999971 39.025480013000049, -81.399464269999953 39.025523799000041, -81.399464216999945 39.025514202000068, -81.399346008999942 39.025365830000055, -81.399345556999947 39.025285721000046, -81.399403856999982 39.025216855000053, -81.399535704999948 39.025182072000064, -81.399741620999976 39.025272921000067, -81.399932940999975 39.025375264000047, -81.400021215999971 39.025420739000026, -81.400094379999985 39.025386155000035, -81.400123592999989 39.025363166000034, -81.400137748999953 39.025271563000047, -81.400240447999977 39.025271211000074, -81.400343212999985 39.025282301000061, -81.400402414999974 39.025373654000077, -81.400432208999973 39.025453653000056, -81.400534768999989 39.025430421000067, -81.400636962999954 39.025338515000044, -81.400680460999979 39.025246811000045, -81.40060684499997 39.025201287000073, -81.400591721999945 39.025121229000035, -81.400650083999949 39.025063807000038, -81.400752654999962 39.02504056500004, -81.400752395999973 39.024994788000072, -81.400693322999985 39.024926325000024, -81.400502014999972 39.024823984000079, -81.400442748999978 39.024721189000047, -81.400456450999968 39.024549477000051, -81.400396797999974 39.02437801700006, -81.400352202999954 39.024275170000067, -81.400293130999955 39.024206698000057, -81.399897267999961 39.024253842000064, -81.399574564999966 39.024266392000072, -81.39929581399997 39.02426734800008, -81.399046338999938 39.024256756000057, -81.398767329999941 39.024211924000042, -81.398872470999947 39.024646458000063, -81.398932751999951 39.024932360000037, -81.39875683799994 39.024955850000026, -81.398698473999957 39.025013272000081, -81.398625693999975 39.025116519000051, -81.398582193999971 39.025208221000071, -81.398492880999981 39.024979640000026, -81.398418817999982 39.024854006000055, -81.398241862999953 39.024694389000047, -81.398180545999935 39.024225383000044, -81.398119872999985 39.023870815000066, -81.398072969999987 39.023355980000076, -81.398011526999937 39.02286407500003, -81.397951174999946 39.02256673800008, -81.397875767999949 39.02220077700008, -81.397830730999942 39.022017812000058, -81.397844503999977 39.021857544000056, -81.397857826999939 39.021617168000034, -81.397871855999938 39.021502677000058, -81.39803419499998 39.021673788000044, -81.398079104999965 39.021833855000068, -81.398198074999982 39.022119567000061, -81.398243692999984 39.022405519000074, -81.398348251999948 39.022737047000078, -81.398935213999948 39.022757930000068, -81.399360926999975 39.02280225100003, -81.399786500999937 39.02282368200008, -81.400094665999973 39.022834070000044, -81.400363384999935 39.022841213000049, -81.400372637999965 39.022695784000064, -81.40034316699996 39.02267299600004, -81.400356675999944 39.022466952000059, -81.400355255999955 39.022215182000025, -81.40035312599997 39.021837518000041, -81.400367021999955 39.021700138000028, -81.40042551099998 39.021665604000077, -81.400543004999975 39.021688090000055, -81.400601558999938 39.021665000000041, -81.400630189999958 39.021539014000041, -81.400570731999949 39.021401895000054, -81.400496216999954 39.021196135000025, -81.400568729999975 39.021047119000059, -81.400656236999964 39.020955264000065, -81.400758864999943 39.020943467000052, -81.400861687999964 39.02096600200008, -81.401008780999973 39.021034162000035, -81.401361143999964 39.021078728000077, -81.401727970999957 39.021088901000041, -81.401829628999963 39.020905451000033, -81.401976268999988 39.020893501000046, -81.40205150099996 39.021225127000037, -81.402112904999967 39.021705577000034, -81.402160288999937 39.022300528000073, -81.402221500999985 39.022746645000041, -81.402178472999935 39.022918459000039, -81.402135290999979 39.023067384000058, -81.402121527999952 39.02322765200006, -81.402063686999952 39.023376627000061, -81.401946966999958 39.023491473000036, -81.401874388999943 39.023629046000053, -81.401816417999953 39.023755142000027, -81.401802005999969 39.023800969000035, -81.40196371199994 39.02385763400008, -81.402272193999977 39.023925236000025, -81.402455005999968 39.023983917000066, -81.402381023999965 39.023608646000071, -81.402334814999961 39.023374242000045, -81.402210637999985 39.022173016000067, -81.402070951999974 39.020823058000076, -81.401985559999957 39.019943598000054, -81.397501936999959 39.019587491000038, -81.397368028999949 39.019576862000065, -81.397288876999937 39.019570572000077, -81.397171503999971 39.019570972000054, -81.397216742999944 39.019788260000041, -81.397308298999974 39.020417386000076, -81.397399896999957 39.02105795600005, -81.397505986999988 39.021664145000045, -81.397671659999958 39.022430359000055, -81.397807674999967 39.023139443000048, -81.397928300999979 39.023722692000035, -81.398047928999972 39.02412283600006, -81.398168507999969 39.024694640000064, -81.398272426999938 39.024911727000074, -81.398539337999978 39.025414367000053, -81.399171907999971 39.025480013000049)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T262 Fld7', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.390236761999972 39.01731867400008, -81.390466271999969 39.017631499000061, -81.390614532999962 39.017917111000031, -81.39070432699998 39.018237251000073, -81.390690286999984 39.01835174200005, -81.390632173999961 39.018454935000079, -81.390721138999936 39.01862630200003, -81.390868909999938 39.018820362000042, -81.390972986999941 39.019071788000076, -81.391076055999974 39.019140108000045, -81.391149469999959 39.019151307000072, -81.39141359599995 39.019161865000058, -81.391589636999981 39.019161274000055, -81.391721541999971 39.019137942000043, -81.391736213999934 39.01913789300005, -81.391765804999977 39.019183572000031, -81.391838966999956 39.019148992000055, -81.391926797999986 39.019114364000075, -81.391941720999966 39.01916009200005, -81.391898152999943 39.019240348000039, -81.391737538999962 39.019378220000078, -81.39159134199997 39.019470266000042, -81.391606516999957 39.019561779000071, -81.391577681999934 39.019653420000054, -81.391489963999959 39.01971093700007, -81.39143116799994 39.019688246000044, -81.391386778999959 39.019619728000066, -81.391356744999939 39.019493942000054, -81.391326962999983 39.019413931000031, -81.391297558999952 39.01940258500008, -81.391180197999972 39.019402979000063, -81.391151424999975 39.019506075000038, -81.391152433999935 39.019689180000057, -81.391198588999941 39.020078133000027, -81.391273265999985 39.020318214000042, -81.391304309999953 39.020627107000053, -81.391247140999951 39.020901962000039, -81.391133559999957 39.021589012000049, -81.391019347999986 39.022161611000058, -81.390875600999948 39.022699976000069, -81.390833100999942 39.022974782000063, -81.390800203999959 39.02334045300006, -81.390797274999954 39.023387683000067, -81.390826112999946 39.023417405000032, -81.390857946999972 39.023414810000077, -81.390894180999965 39.023409462000075, -81.390952736999964 39.023386377000065, -81.391303959999959 39.023224979000076, -81.391758000999971 39.023086124000031, -81.392549155999973 39.022888910000063, -81.393369724999957 39.022703037000042, -81.394366072999958 39.022470786000042, -81.394836110999961 39.022372586000074, -81.394805433999977 39.02233196800006, -81.394745349999937 39.022080396000035, -81.394758672999956 39.021840011000052, -81.394816411999955 39.021668151000029, -81.39485921499994 39.021450564000077, -81.394887421999954 39.021244471000045, -81.394769917999952 39.021221980000064, -81.394505975999948 39.021245761000046, -81.394242031999966 39.021269533000066, -81.394198401999972 39.021338356000058, -81.394170394999946 39.021578790000035, -81.39414168899998 39.021693321000043, -81.39408313399997 39.021716408000032, -81.393994918999965 39.021682373000033, -81.393833478999966 39.021671474000073, -81.393613481999978 39.021683661000054, -81.393569342999967 39.021660921000034, -81.393554226999981 39.021580871000026, -81.393524315999969 39.021477972000071, -81.39342073399996 39.021318092000058, -81.393376024999952 39.021192355000039, -81.393448869999986 39.021100555000032, -81.393595448999974 39.021077172000048, -81.393786290999969 39.021099417000073, -81.393874251999989 39.021087675000047, -81.394035119999955 39.020995577000065, -81.394078495999963 39.020880988000044, -81.394340657999976 39.020536772000071, -81.394354946999954 39.020468058000063, -81.394295946999989 39.020411035000052, -81.394324842999936 39.020330827000066, -81.394383269999935 39.020284853000078, -81.394529846999944 39.020261467000068, -81.394661179999957 39.020135136000079, -81.394835823999983 39.019882770000038, -81.394806164999977 39.01982564900004, -81.394556451999961 39.01976927100003, -81.394160100999954 39.019724835000034, -81.393866313999979 39.019657161000055, -81.393454660999964 39.019498329000044, -81.393057739999961 39.019350882000026, -81.392910520999976 39.019259832000046, -81.392835206999962 39.018905311000026, -81.392760716999987 39.01869956400003, -81.392598650999957 39.018574213000079, -81.392407179999964 39.018437534000043, -81.392259531999969 39.018266365000045, -81.392185106999989 39.018072062000044, -81.392110303999971 39.017809094000029, -81.392138126999953 39.017534345000058, -81.392137367999965 39.017396998000038, -81.392195351999987 39.01727091500004, -81.392091778999941 39.017111042000067, -81.39201729399997 39.016905295000072, -81.391972461999956 39.016756669000074, -81.391986500999963 39.016642178000041, -81.392087924999942 39.016412951000063, -81.392116503999944 39.016275522000058, -81.392057319999935 39.016184167000063, -81.391881223999974 39.016173314000071, -81.391705505999937 39.016231125000047, -81.391632534999985 39.016300037000065, -81.391573982999944 39.016323121000028, -81.391441893999968 39.016312121000055, -81.391265733999944 39.016289824000069, -81.391205169999978 39.016260271000078, -81.391021699999953 39.01638732400005, -81.390714835999972 39.016605795000032, -81.390540122999937 39.016846711000028, -81.39040947999996 39.017098923000049, -81.390236761999972 39.01731867400008)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld11', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.383773016999953 39.022271733000025, -81.383934156999942 39.02233392100004, -81.384389695999971 39.022469753000053, -81.384859720999941 39.022571202000051, -81.385726171999977 39.022728561000065, -81.385917193999944 39.02278515200004, -81.385976101999972 39.022830697000074, -81.38605359099995 39.02269827300006, -81.386052780999989 39.022549499000036, -81.386051971999962 39.022400725000068, -81.386110095999982 39.022297534000074, -81.386270414999956 39.022102450000034, -81.38659279899997 39.022032707000051, -81.386783391999984 39.022009186000048, -81.386915429999988 39.022008748000076, -81.386959753999975 39.022065823000048, -81.387033481999936 39.022134253000047, -81.387180127999954 39.02212232200003, -81.387238559999957 39.022076342000048, -81.38742909299998 39.02204137700005, -81.387663699999962 39.02201771700004, -81.387693166999952 39.02204049900007, -81.387795798999946 39.022028714000044, -81.38789836899997 39.022005484000033, -81.388030405999984 39.022005045000071, -81.388089338999976 39.022050626000066, -81.388177488999986 39.022073222000074, -81.388382753999963 39.022049650000042, -81.388602889999959 39.022060361000058, -81.388735164999957 39.022105707000037, -81.388955414999941 39.022139305000053, -81.389307135999957 39.022069457000043, -81.389380113999948 39.022000548000051, -81.389335672999948 39.021920586000078, -81.389453027999934 39.021920194000074, -81.389629075999949 39.02191960600004, -81.389731393999966 39.021850598000071, -81.389716220999958 39.02175909400006, -81.389598164999938 39.021633601000076, -81.389509574999977 39.021530898000037, -81.389875723999978 39.021415232000038, -81.390300479999951 39.021287924000035, -81.390652321999937 39.021240969000075, -81.390798776999986 39.02119470100007, -81.39085683899998 39.021080063000056, -81.390811744999951 39.020885660000033, -81.390588967999975 39.020394299000031, -81.390424835999966 39.019891298000061, -81.390320885999984 39.019662760000074, -81.390232108999953 39.019525725000051, -81.390202076999969 39.01939993700006, -81.390245583999956 39.019308247000026, -81.390318745999934 39.019273660000067, -81.390392222999935 39.019296302000043, -81.390465825999968 39.019341833000055, -81.390524505999963 39.019341637000025, -81.390538861999971 39.019284368000058, -81.39042061899994 39.019124542000043, -81.390095989999963 39.018782299000065, -81.38993348799994 39.018576844000052, -81.390137798999945 39.018381608000027, -81.390356652999969 39.018163432000051, -81.390458649999971 39.018037203000063, -81.390458020999972 39.017922762000069, -81.39033971799995 39.01775148400003, -81.39015220999994 39.017403329000047, -81.389986572999987 39.017558111000028, -81.389693981999983 39.017707874000052, -81.389240470999937 39.017938275000063, -81.388728967999953 39.018294755000056, -81.388188482999965 39.018719995000026, -81.387618548999967 39.019122443000072, -81.386024064999958 39.018133550000073, -81.385899591999987 39.01822771500008, -81.385784902999944 39.018351837000068, -81.385651355999983 39.01854729300004, -81.38550467999994 39.018877671000041, -81.385593123999968 39.018957489000059, -81.385593622999977 39.019049042000063, -81.385433814999942 39.01933568000004, -81.385288665999951 39.019622267000045, -81.385318628999983 39.019736611000042, -81.385407891999989 39.019965203000027, -81.385393655999962 39.02004536000004, -81.385263237999936 39.020343344000025, -81.385117961999981 39.02060704400003, -81.385016633999953 39.02085915300006, -81.384886212999959 39.021157136000056, -81.384682375999944 39.021443917000056, -81.384449008999979 39.021696462000079, -81.384156895999979 39.021937755000067, -81.38379172499998 39.022236509000038, -81.383773016999953 39.022271733000025)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld12', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.395523791999949 39.026550003000068, -81.39577301099996 39.026602558000036, -81.396448354999961 39.026680375000069, -81.39672718099996 39.026690872000074, -81.396563681999965 39.026313756000036, -81.396488597999962 39.026005015000067, -81.396529671999986 39.025478437000061, -81.396553878999953 39.025030332000028, -81.396317060999934 39.025050582000063, -81.396067967999954 39.025108659000068, -81.396011835999957 39.025566623000032, -81.396012282999948 39.025646732000041, -81.395806754999967 39.02562454100007, -81.39571910899997 39.02569350300007, -81.395675859999983 39.025830972000051, -81.395589170999983 39.026071607000063, -81.395575518999976 39.026254762000065, -81.395517650999977 39.026403744000049, -81.395503500999951 39.026495346000047, -81.395523791999949 39.026550003000068)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld16', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.394836110999961 39.022372586000074, -81.394908892999979 39.022468950000075, -81.395100441999944 39.022617078000053, -81.395144899999934 39.022697037000057, -81.394763954999974 39.022789882000041, -81.394192500999964 39.022917702000029, -81.393899579999982 39.023010246000069, -81.393577400999959 39.02311433300008, -81.393240159999948 39.023149802000034, -81.393049235999968 39.023116113000071, -81.392844285999956 39.023196913000049, -81.392771258999971 39.023254381000072, -81.392698270999972 39.023323293000033, -81.392772650999973 39.023506151000049, -81.392846692999967 39.023631790000024, -81.392979554999954 39.023780118000047, -81.393170618999989 39.023836697000036, -81.393331925999973 39.023824709000053, -81.393536941999969 39.023755351000034, -81.39377084299997 39.023605785000029, -81.394063004999964 39.023375913000052, -81.394209142999955 39.023272419000079, -81.394311648999974 39.023237749000032, -81.394575535999934 39.023202515000037, -81.394766118999939 39.023178982000047, -81.394956598999954 39.023132550000071, -81.395366428999978 39.022959506000063, -81.395483923999961 39.022981996000055, -81.395674964999955 39.02303857000004, -81.395910018999984 39.023094994000076, -81.396086006999951 39.023082953000028, -81.396306006999964 39.023070761000042, -81.396307412999988 39.023322532000066, -81.396337968999944 39.023539870000036, -81.396368130999974 39.023688544000038, -81.396471669999983 39.023836968000069, -81.396531313999958 39.024008440000046, -81.396548702999951 39.024135250000029, -81.396533217999945 39.023487112000055, -81.396499912999957 39.022777677000079, -81.396394020999935 39.022205821000057, -81.396346494999989 39.021576535000065, -81.396344193999937 39.021164548000058, -81.396341765999978 39.020729670000037, -81.396413335999966 39.020393686000034, -81.396396761999938 39.019854210000062, -81.396260875999985 39.019379514000036, -81.396146635999969 39.018775948000041, -81.395902856999953 39.018316407000043, -81.395721525999988 39.01822366500005, -81.39548665999996 39.018129672000043, -81.39511239999996 39.017941361000055, -81.394877421999979 39.017827055000055, -81.394546412999944 39.017611499000054, -81.393919221999965 39.017200604000038, -81.393483735999951 39.016924472000028, -81.393004332999965 39.016553697000063, -81.392385470999955 39.016075054000055, -81.391971874999967 39.01577758500008, -81.391854265999939 39.015732203000027, -81.391839974999982 39.015800916000046, -81.391679369999963 39.015938789000074, -81.39138705199997 39.016134323000074, -81.391205169999978 39.016260271000078, -81.391265733999944 39.016289824000069, -81.391441893999968 39.016312121000055, -81.391573982999944 39.016323121000028, -81.391632534999985 39.016300037000065, -81.391705505999937 39.016231125000047, -81.391881223999974 39.016173314000071, -81.392057319999935 39.016184167000063, -81.392116503999944 39.016275522000058, -81.392087924999942 39.016412951000063, -81.391986500999963 39.016642178000041, -81.391972461999956 39.016756669000074, -81.39201729399997 39.016905295000072, -81.392091778999941 39.017111042000067, -81.392195351999987 39.01727091500004, -81.392137367999965 39.017396998000038, -81.392138126999953 39.017534345000058, -81.392110303999971 39.017809094000029, -81.392185106999989 39.018072062000044, -81.392259531999969 39.018266365000045, -81.392407179999964 39.018437534000043, -81.392598650999957 39.018574213000079, -81.392760716999987 39.01869956400003, -81.392835206999962 39.018905311000026, -81.392910520999976 39.019259832000046, -81.393057739999961 39.019350882000026, -81.393454660999964 39.019498329000044, -81.393866313999979 39.019657161000055, -81.394160100999954 39.019724835000034, -81.394556451999961 39.01976927100003, -81.394806164999977 39.01982564900004, -81.394835823999983 39.019882770000038, -81.394661179999957 39.020135136000079, -81.394529846999944 39.020261467000068, -81.394383269999935 39.020284853000078, -81.394324842999936 39.020330827000066, -81.394295946999989 39.020411035000052, -81.394354946999954 39.020468058000063, -81.394340657999976 39.020536772000071, -81.394078495999963 39.020880988000044, -81.394035119999955 39.020995577000065, -81.393874251999989 39.021087675000047, -81.393786290999969 39.021099417000073, -81.393595448999974 39.021077172000048, -81.393448869999986 39.021100555000032, -81.393376024999952 39.021192355000039, -81.39342073399996 39.021318092000058, -81.393524315999969 39.021477972000071, -81.393554226999981 39.021580871000026, -81.393569342999967 39.021660921000034, -81.393613481999978 39.021683661000054, -81.393833478999966 39.021671474000073, -81.393994918999965 39.021682373000033, -81.39408313399997 39.021716408000032, -81.39414168899998 39.021693321000043, -81.394170394999946 39.021578790000035, -81.394198401999972 39.021338356000058, -81.394242031999966 39.021269533000066, -81.394505975999948 39.021245761000046, -81.394769917999952 39.021221980000064, -81.394887421999954 39.021244471000045, -81.39485921499994 39.021450564000077, -81.394816411999955 39.021668151000029, -81.394758672999956 39.021840011000052, -81.394745349999937 39.022080396000035, -81.394805433999977 39.02233196800006, -81.394836110999961 39.022372586000074)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld17', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.385261256999968 39.030179126000064, -81.385253190999947 39.030191831000025, -81.385077493999972 39.030261077000034, -81.384945629999947 39.030295845000069, -81.384931452999979 39.030387447000066, -81.384976214999938 39.030524631000048, -81.385094143999936 39.030627240000058, -81.385241313999984 39.030706864000081, -81.385417508999979 39.030729171000075, -81.385563985999966 39.030682910000053, -81.385666381999954 39.030625350000037, -81.385700473999975 39.030610008000053, -81.386071920999939 39.029651233000038, -81.385836789999985 39.029583354000067, -81.385733710999943 39.029515029000038, -81.385777355999949 39.029446219000079, -81.385777167999947 39.029411885000059, -81.385703744999944 39.029400684000052, -81.385878754999965 39.029205553000054, -81.386032917999955 39.029084282000042, -81.385464325999976 39.028543152000054, -81.385390654999981 39.028486174000079, -81.384702617999949 39.028774553000062, -81.38467426599999 39.028957756000068, -81.384616705999974 39.029163942000025, -81.38455874899995 39.02930146500006, -81.384535691999986 39.029342390000068, -81.38482365699997 39.029449369000076, -81.385117412999989 39.029505621000055, -81.385322824999946 39.029504942000074, -81.385381699999982 39.029539081000053, -81.385367774999963 39.029676459000029, -81.385368209999967 39.029756576000068, -81.385265688999937 39.029791239000076, -81.385236654999972 39.029848556000047, -81.385237152999935 39.029940109000052, -81.385310948999972 39.030019976000062, -81.385311383999976 39.030100085000072, -81.385261256999968 39.030179126000064)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld19', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.387768333999986 39.025937646000045, -81.387856113999987 39.025891577000039, -81.387972358999946 39.025685193000072, -81.387986092999938 39.025513482000065, -81.388058949999959 39.025421685000026, -81.38832277399996 39.025375030000077, -81.388411252999958 39.02545484500007, -81.388573264999934 39.025568750000048, -81.388705182999956 39.025545421000061, -81.388851458999966 39.025464824000039, -81.388968265999949 39.025361435000036, -81.388967700999956 39.025258438000037, -81.388996291999945 39.025121011000067, -81.389215985999954 39.025051612000027, -81.389288839999949 39.024959815000045, -81.389186066999969 39.024948713000072, -81.389024943999971 39.024995028000035, -81.388819607999949 39.025007157000061, -81.388584689999959 39.024973607000049, -81.388496712999938 39.024985344000072, -81.388438716999985 39.025111424000045, -81.38838046799998 39.025191729000028, -81.388248425999961 39.025192169000036, -81.388101336999966 39.025123992000033, -81.387909983999975 39.025010185000042, -81.387850984999943 39.024953160000052, -81.387894561999985 39.024872905000052, -81.387938137999981 39.024792650000052, -81.387908357999947 39.024712647000058, -81.387863718999938 39.024598343000036, -81.38792209099995 39.024540928000079, -81.38787720199997 39.02438085700004, -81.38778842399995 39.024243819000048, -81.387670741999955 39.024186989000043, -81.38743612799999 39.024210658000072, -81.386996541999963 39.024315115000036, -81.386732833999986 39.024384655000063, -81.386572260999969 39.024533964000057, -81.386543353999969 39.024614180000071, -81.386499776999983 39.024694425000064, -81.386529555999971 39.024774437000076, -81.386573817999988 39.024820067000064, -81.38664717499995 39.024819824000076, -81.386778905999961 39.024762166000073, -81.386808248999955 39.024762069000076, -81.386867369999948 39.024841983000044, -81.38688222899998 39.024876266000035, -81.386999786999979 39.02491021000003, -81.387146873999939 39.024978387000033, -81.387161918999936 39.025047003000054, -81.387133262999953 39.02517298600003, -81.387075202999938 39.025287631000026, -81.386929161999944 39.025413994000075, -81.386812052999971 39.02546016000008, -81.386592417999964 39.025540998000054, -81.386680570999943 39.025563595000051, -81.386959266999952 39.025551226000061, -81.387487075999957 39.025480808000054, -81.387605447999988 39.025663524000038, -81.387768333999986 39.025937646000045)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld26', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.385700473999975 39.030610008000053, -81.385768841999948 39.030579234000072, -81.385929927999939 39.030521479000072, -81.38609100299999 39.030463725000061, -81.386384900999985 39.030542862000061, -81.386752336999962 39.030656087000068, -81.386767383999938 39.030724703000033, -81.386855854999965 39.030804520000061, -81.38701731499998 39.030815429000029, -81.38720780999995 39.030769019000047, -81.387501583999949 39.030825265000033, -81.388061081999979 39.031178188000069, -81.388296595999975 39.03131473600007, -81.388604658999952 39.03130225700005, -81.389029788999949 39.031232183000043, -81.389147131999948 39.03122475400005, -81.389146856999957 39.031174571000065, -81.389102775999959 39.031163273000061, -81.389043834999939 39.031117693000056, -81.389043394999987 39.031037584000046, -81.389071924999939 39.030888713000024, -81.389115691999962 39.030842781000047, -81.389262416999941 39.030842291000056, -81.389394532999972 39.030853295000043, -81.389511850999952 39.030841459000044, -81.389525957999979 39.030738413000051, -81.38954025299995 39.030669699000043, -81.389348956999982 39.030567339000072, -81.389216378999947 39.030476227000065, -81.389128229999983 39.030453632000047, -81.389011226999969 39.030522697000038, -81.38885045699999 39.030637668000054, -81.388718528999959 39.030660996000051, -81.388542270999949 39.030627250000066, -81.38840952999999 39.030501805000029, -81.388321055999938 39.030421998000065, -81.388247568999986 39.030399345000035, -81.388189128999954 39.030445317000044, -81.38808592099997 39.030354106000061, -81.388085670999942 39.030308329000036, -81.388114577999943 39.030228123000029, -81.388261050999972 39.030181858000049, -81.388481524999975 39.030249790000028, -81.388789759999952 39.030271652000067, -81.388951031999966 39.030248226000026, -81.389097504999938 39.030201960000056, -81.389347010999984 39.030212563000077, -81.389434907999942 39.030189390000032, -81.389493031999962 39.03008619700006, -81.389550779999979 39.029914338000026, -81.389505945999986 39.029765713000074, -81.38937320399998 39.029640260000065, -81.389167163999957 39.029526513000064, -81.389034611999989 39.029435401000057, -81.388975734999974 39.029401264000057, -81.389019437999934 39.029343896000057, -81.389107282999987 39.029309271000045, -81.389180455999963 39.029274694000037, -81.389312254999936 39.029228477000061, -81.389399785999956 39.029136630000039, -81.389428564999946 39.029033534000064, -81.389413452999975 39.028953476000027, -81.389296201999969 39.028976756000077, -81.389047213999959 39.029057696000052, -81.388886070999945 39.029104010000026, -81.388621907999948 39.029093447000037, -81.388299056999983 39.029083078000042, -81.388137537999967 39.029060727000058, -81.387917079999966 39.028992793000043, -81.387828608999939 39.028912978000051, -81.387798763999967 39.028821523000033, -81.387827545999983 39.028718428000047, -81.387871372999939 39.028683950000072, -81.387856451999937 39.028638221000051, -81.387856387999989 39.028626778000046, -81.387591853999936 39.028547547000073, -81.38747465299997 39.028582269000026, -81.38728447799997 39.028685900000028, -81.387152802999935 39.028755002000025, -81.386991409999951 39.028755538000041, -81.386757028999966 39.02882498200006, -81.386376175999942 39.028940686000055, -81.386039463999964 39.029079141000068, -81.386032917999955 39.029084282000042, -81.385878754999965 39.029205553000054, -81.385703744999944 39.029400684000052, -81.385777167999947 39.029411885000059, -81.385777355999949 39.029446219000079, -81.385733710999943 39.029515029000038, -81.385836789999985 39.029583354000067, -81.386071920999939 39.029651233000038, -81.385700473999975 39.030610008000053)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld3', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.392825076999941 39.025028070000076, -81.39277999799998 39.024833668000042, -81.392763920999982 39.024581948000048, -81.392556751999962 39.024262203000035, -81.392335607999939 39.024068394000039, -81.392129326999964 39.023908868000035, -81.39199602399998 39.023680428000034, -81.391936895999947 39.02360051800008, -81.391878211999938 39.023600714000054, -81.391673007999941 39.023635736000074, -81.391299744999969 39.02380596900008, -81.391191569999989 39.023831185000063, -81.391140549999989 39.02382390300005, -81.391098984999985 39.023796702000027, -81.391063563999978 39.023727245000032, -81.390967724999939 39.023443549000035, -81.390952736999964 39.023386377000065, -81.390894180999965 39.023409462000075, -81.390857946999972 39.023414810000077, -81.390826112999946 39.023417405000032, -81.390797274999954 39.023387683000067, -81.390800203999959 39.02334045300006, -81.390833100999942 39.022974782000063, -81.390875600999948 39.022699976000069, -81.391019347999986 39.022161611000058, -81.391133559999957 39.021589012000049, -81.391247140999951 39.020901962000039, -81.391304309999953 39.020627107000053, -81.391273265999985 39.020318214000042, -81.391198588999941 39.020078133000027, -81.391152433999935 39.019689180000057, -81.391151424999975 39.019506075000038, -81.391180197999972 39.019402979000063, -81.391297558999952 39.01940258500008, -81.391326962999983 39.019413931000031, -81.391356744999939 39.019493942000054, -81.391386778999959 39.019619728000066, -81.39143116799994 39.019688246000044, -81.391489963999959 39.01971093700007, -81.391577681999934 39.019653420000054, -81.391606516999957 39.019561779000071, -81.39159134199997 39.019470266000042, -81.391737538999962 39.019378220000078, -81.391898152999943 39.019240348000039, -81.391941720999966 39.01916009200005, -81.391926797999986 39.019114364000075, -81.391838966999956 39.019148992000055, -81.391765804999977 39.019183572000031, -81.391736213999934 39.01913789300005, -81.391721541999971 39.019137942000043, -81.391589636999981 39.019161274000055, -81.39141359599995 39.019161865000058, -81.391149469999959 39.019151307000072, -81.391076055999974 39.019140108000045, -81.390972986999941 39.019071788000076, -81.390868909999938 39.018820362000042, -81.390721138999936 39.01862630200003, -81.390632173999961 39.018454935000079, -81.390690286999984 39.01835174200005, -81.39070432699998 39.018237251000073, -81.390614532999962 39.017917111000031, -81.390466271999969 39.017631499000061, -81.390236761999972 39.01731867400008, -81.390220094999961 39.017339879000076, -81.39015220999994 39.017403329000047, -81.39033971799995 39.01775148400003, -81.390458020999972 39.017922762000069, -81.390458649999971 39.018037203000063, -81.390356652999969 39.018163432000051, -81.390137798999945 39.018381608000027, -81.38993348799994 39.018576844000052, -81.390095989999963 39.018782299000065, -81.39042061899994 39.019124542000043, -81.390538861999971 39.019284368000058, -81.390524505999963 39.019341637000025, -81.390465825999968 39.019341833000055, -81.390392222999935 39.019296302000043, -81.390318745999934 39.019273660000067, -81.390245583999956 39.019308247000026, -81.390202076999969 39.01939993700006, -81.390232108999953 39.019525725000051, -81.390320885999984 39.019662760000074, -81.390424835999966 39.019891298000061, -81.390588967999975 39.020394299000031, -81.390811744999951 39.020885660000033, -81.39085683899998 39.021080063000056, -81.390798776999986 39.02119470100007, -81.390652321999937 39.021240969000075, -81.390300479999951 39.021287924000035, -81.389875723999978 39.021415232000038, -81.389509574999977 39.021530898000037, -81.389598164999938 39.021633601000076, -81.389716220999958 39.02175909400006, -81.389731393999966 39.021850598000071, -81.389629075999949 39.02191960600004, -81.389453027999934 39.021920194000074, -81.389335672999948 39.021920586000078, -81.389380113999948 39.022000548000051, -81.389307135999957 39.022069457000043, -81.388955414999941 39.022139305000053, -81.388735164999957 39.022105707000037, -81.388602889999959 39.022060361000058, -81.388382753999963 39.022049650000042, -81.388177488999986 39.022073222000074, -81.388089338999976 39.022050626000066, -81.388030405999984 39.022005045000071, -81.38789836899997 39.022005484000033, -81.387795798999946 39.022028714000044, -81.387693166999952 39.02204049900007, -81.387663699999962 39.02201771700004, -81.38742909299998 39.02204137700005, -81.387238559999957 39.022076342000048, -81.387180127999954 39.02212232200003, -81.387033481999936 39.022134253000047, -81.386959753999975 39.022065823000048, -81.386915429999988 39.022008748000076, -81.386783391999984 39.022009186000048, -81.38659279899997 39.022032707000051, -81.386270414999956 39.022102450000034, -81.386110095999982 39.022297534000074, -81.386051971999962 39.022400725000068, -81.386052780999989 39.022549499000036, -81.38605359099995 39.02269827300006, -81.385976101999972 39.022830697000074, -81.385966372999974 39.02284733700003, -81.385879043999978 39.022973514000057, -81.385821156999953 39.02312248100003, -81.385998080999968 39.023282117000065, -81.38610227099997 39.023556437000025, -81.386191293999957 39.023739250000062, -81.386397499999987 39.023887353000077, -81.386661703999948 39.023909358000026, -81.386984282999947 39.023873954000067, -81.387262907999968 39.023850141000025, -81.38744860099996 39.023810064000031, -81.387888682999971 39.023797157000047, -81.388490009999941 39.023760823000032, -81.389150209999968 39.023758623000049, -81.389619935999974 39.023802833000047, -81.389751787999955 39.023768059000076, -81.389883512999972 39.023710398000048, -81.389956302999963 39.023607154000047, -81.38995573699998 39.023504157000048, -81.38995491999998 39.023355393000031, -81.389998617999936 39.023298017000059, -81.390174870999942 39.023331760000076, -81.390262947999986 39.023342910000054, -81.390380126999958 39.023308185000076, -81.390423950999946 39.023273705000065, -81.39062877899994 39.023170020000066, -81.390745830999947 39.023112407000042, -81.390775350999945 39.023146632000078, -81.39077598099999 39.023261082000033, -81.390718504999938 39.023478716000056, -81.390749232999951 39.023730389000036, -81.390780516999939 39.024085058000026, -81.390767055999959 39.024302545000069, -81.390827251999951 39.024577008000051, -81.39087176999999 39.024668414000075, -81.390637469999945 39.024749308000025, -81.390667504999954 39.024875096000073, -81.390668386999948 39.025035312000057, -81.390521484999965 39.025001472000042, -81.390301477999969 39.02501365300003, -81.390037832999951 39.025094645000024, -81.389818956999989 39.025312818000032, -81.389629547999959 39.025553782000031, -81.389118681999946 39.026036149000049, -81.388958548999938 39.026265569000032, -81.388900551999939 39.026391650000051, -81.388945632999935 39.026586062000035, -81.388961558999938 39.02681489500003, -81.388918672999978 39.027021036000065, -81.388786814999946 39.027055809000046, -81.388639846999979 39.027010521000079, -81.388536955999939 39.026976531000059, -81.388493191999942 39.027022454000075, -81.388479083999982 39.027125500000068, -81.388391364999961 39.027183013000069, -81.388302583999973 39.027045986000076, -81.38818433299997 39.026886150000053, -81.388038366999979 39.027023968000037, -81.388083320999954 39.02719548400006, -81.38815786899994 39.027412677000029, -81.388290603999963 39.027538124000046, -81.388569996999934 39.027651635000041, -81.388746435999963 39.027719722000029, -81.388761295999984 39.027753997000048, -81.38877697099997 39.027937054000063, -81.38877765999996 39.028062939000051, -81.38885133399998 39.028119915000048, -81.389029529999959 39.028508428000066, -81.389207277999958 39.028816831000029, -81.389045958999986 39.028828813000075, -81.388708185999974 39.028772718000027, -81.388106127999947 39.028683169000033, -81.388046938999935 39.028591811000069, -81.387987937999981 39.028534785000033, -81.387885295999979 39.028546572000039, -81.387856387999989 39.028626778000046, -81.387856451999937 39.028638221000051, -81.387871372999939 39.028683950000072, -81.387827545999983 39.028718428000047, -81.387798763999967 39.028821523000033, -81.387828608999939 39.028912978000051, -81.387917079999966 39.028992793000043, -81.388137537999967 39.029060727000058, -81.388299056999983 39.029083078000042, -81.388621907999948 39.029093447000037, -81.388886070999945 39.029104010000026, -81.389047213999959 39.029057696000052, -81.389296201999969 39.028976756000077, -81.389413452999975 39.028953476000027, -81.389428564999946 39.029033534000064, -81.389399785999956 39.029136630000039, -81.389312254999936 39.029228477000061, -81.389180455999963 39.029274694000037, -81.389107282999987 39.029309271000045, -81.389019437999934 39.029343896000057, -81.388975734999974 39.029401264000057, -81.389034611999989 39.029435401000057, -81.389167163999957 39.029526513000064, -81.38937320399998 39.029640260000065, -81.389505945999986 39.029765713000074, -81.389550779999979 39.029914338000026, -81.389493031999962 39.03008619700006, -81.389434907999942 39.030189390000032, -81.389347010999984 39.030212563000077, -81.389097504999938 39.030201960000056, -81.388951031999966 39.030248226000026, -81.388789759999952 39.030271652000067, -81.388481524999975 39.030249790000028, -81.388261050999972 39.030181858000049, -81.388114577999943 39.030228123000029, -81.388085670999942 39.030308329000036, -81.38808592099997 39.030354106000061, -81.388189128999954 39.030445317000044, -81.388247568999986 39.030399345000035, -81.388321055999938 39.030421998000065, -81.38840952999999 39.030501805000029, -81.388542270999949 39.030627250000066, -81.388718528999959 39.030660996000051, -81.38885045699999 39.030637668000054, -81.389011226999969 39.030522697000038, -81.389128229999983 39.030453632000047, -81.389216378999947 39.030476227000065, -81.389348956999982 39.030567339000072, -81.38954025299995 39.030669699000043, -81.389525957999979 39.030738413000051, -81.389511850999952 39.030841459000044, -81.389394532999972 39.030853295000043, -81.389262416999941 39.030842291000056, -81.389115691999962 39.030842781000047, -81.389071924999939 39.030888713000024, -81.389043394999987 39.031037584000046, -81.389043834999939 39.031117693000056, -81.389102775999959 39.031163273000061, -81.389146856999957 39.031174571000065, -81.389147131999948 39.03122475400005, -81.38941115199998 39.031208022000044, -81.389660523999964 39.031195745000048, -81.389968712999973 39.031206159000078, -81.390115690999949 39.031251445000066, -81.390116130999957 39.03133155300003, -81.390072489999966 39.031400356000063, -81.389925826999956 39.031412300000056, -81.389661780999973 39.031424627000035, -81.389075500999979 39.03154102700006, -81.388474358999986 39.031623140000079, -81.38797611199999 39.031739242000071, -81.387067513999966 39.031948258000057, -81.386613280999939 39.032064207000076, -81.385968598999966 39.032238007000046, -81.385264809999967 39.032331888000044, -81.384663407999938 39.032368206000058, -81.384061633999977 39.032335856000032, -81.383738458999971 39.032268253000041, -81.38372523999999 39.032263620000037, -81.382929907999937 39.031984803000057, -81.382106381999961 39.031644174000064, -81.381753250999964 39.031462221000027, -81.381165161999945 39.031246702000033, -81.380533072999981 39.031031324000026, -81.379900863999978 39.030793045000053, -81.37929775799995 39.030508900000029, -81.379018124999959 39.030349580000063, -81.378782571999977 39.03020157800006, -81.378899413999989 39.030098199000065, -81.37927953999997 39.029845189000071, -81.379615901999955 39.029638096000042, -81.379981545999954 39.029419464000057, -81.380288558999951 39.029212466000047, -81.380462651999949 39.029065754000044, -81.380493060999981 39.029040135000059, -81.380580284999951 39.028891065000039, -81.380697172999987 39.028799138000068, -81.380799691999982 39.028764471000045, -81.380887786999949 39.028775627000073, -81.38097600399999 39.028809673000069, -81.381063606999987 39.028729276000035, -81.381165328999941 39.028545834000056, -81.38125249999996 39.028385329000059, -81.381315173999951 39.028230032000067, -81.380993431999968 39.028425636000065, -81.380773903999966 39.028529352000078, -81.38046671099994 39.028702018000047, -81.380335457999934 39.028851223000061, -81.380116600999941 39.029080823000072, -81.379604726999958 39.029391486000065, -81.37913649799998 39.029633340000032, -81.378579925999986 39.029818256000055, -81.378534614999978 39.030344662000061, -81.37867119699996 39.030424509000056, -81.379318255999976 39.030697070000031, -81.380112473999986 39.031049258000053, -81.380788517999974 39.03125306000004, -81.382023671999946 39.03174111800007, -81.382611877999977 39.031979529000068, -81.383244229999946 39.032240673000047, -81.383832134999977 39.032421849000059, -81.384258093999961 39.032500557000049, -81.384771957999988 39.032556084000078, -81.385256100999982 39.032543042000043, -81.38578395199994 39.032472631000076, -81.386575228999959 39.032275459000061, -81.387234759999956 39.032135939000057, -81.388729883999986 39.03185630300004, -81.389844322999977 39.031726696000078, -81.390518890999942 39.031655774000058, -81.389922748999936 39.029975446000037, -81.389698315999965 39.029186538000033, -81.389338899999984 39.027860197000052, -81.389835167999934 39.027389322000033, -81.390170682999951 39.027033427000049, -81.390695211999969 39.026367901000071, -81.391455549999989 39.025896126000077, -81.391997194999988 39.025676865000037, -81.392656017999968 39.025422874000071, -81.392709541999977 39.025360345000024, -81.392797063999978 39.025268505000042, -81.392825836999975 39.02516539100003, -81.392825076999941 39.025028070000076)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld30', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.392656017999968 39.025422874000071, -81.392876532999935 39.025502242000073, -81.393788576999953 39.025934051000036, -81.394553341999938 39.026263352000058, -81.395185430999959 39.026478654000073, -81.395523791999949 39.026550003000068, -81.395503500999951 39.026495346000047, -81.395517650999977 39.026403744000049, -81.395575518999976 39.026254762000065, -81.395589170999983 39.026071607000063, -81.395675859999983 39.025830972000051, -81.39571910899997 39.02569350300007, -81.395806754999967 39.02562454100007, -81.396012282999948 39.025646732000041, -81.396011835999957 39.025566623000032, -81.396067967999954 39.025108659000068, -81.396317060999934 39.025050582000063, -81.396553878999953 39.025030332000028, -81.396556264999958 39.024986241000079, -81.396552364999934 39.024288150000075, -81.396548702999951 39.024135250000029, -81.396531313999958 39.024008440000046, -81.396471669999983 39.023836968000069, -81.396368130999974 39.023688544000038, -81.396337968999944 39.023539870000036, -81.396307412999988 39.023322532000066, -81.396306006999964 39.023070761000042, -81.396086006999951 39.023082953000028, -81.395910018999984 39.023094994000076, -81.395674964999955 39.02303857000004, -81.395483923999961 39.022981996000055, -81.395366428999978 39.022959506000063, -81.394956598999954 39.023132550000071, -81.394766118999939 39.023178982000047, -81.394575535999934 39.023202515000037, -81.394311648999974 39.023237749000032, -81.394209142999955 39.023272419000079, -81.394063004999964 39.023375913000052, -81.39377084299997 39.023605785000029, -81.393536941999969 39.023755351000034, -81.393331925999973 39.023824709000053, -81.393170618999989 39.023836697000036, -81.392979554999954 39.023780118000047, -81.392846692999967 39.023631790000024, -81.392772650999973 39.023506151000049, -81.392698270999972 39.023323293000033, -81.392771258999971 39.023254381000072, -81.392844285999956 39.023196913000049, -81.393049235999968 39.023116113000071, -81.393240159999948 39.023149802000034, -81.393577400999959 39.02311433300008, -81.393899579999982 39.023010246000069, -81.394192500999964 39.022917702000029, -81.394763954999974 39.022789882000041, -81.395144899999934 39.022697037000057, -81.395100441999944 39.022617078000053, -81.394908892999979 39.022468950000075, -81.394836110999961 39.022372586000074, -81.394366072999958 39.022470786000042, -81.393369724999957 39.022703037000042, -81.392549155999973 39.022888910000063, -81.391758000999971 39.023086124000031, -81.391303959999959 39.023224979000076, -81.390952736999964 39.023386377000065, -81.390967724999939 39.023443549000035, -81.391063563999978 39.023727245000032, -81.391098984999985 39.023796702000027, -81.391140549999989 39.02382390300005, -81.391191569999989 39.023831185000063, -81.391299744999969 39.02380596900008, -81.391673007999941 39.023635736000074, -81.391878211999938 39.023600714000054, -81.391936895999947 39.02360051800008, -81.39199602399998 39.023680428000034, -81.392129326999964 39.023908868000035, -81.392335607999939 39.024068394000039, -81.392556751999962 39.024262203000035, -81.392763920999982 39.024581948000048, -81.39277999799998 39.024833668000042, -81.392825076999941 39.025028070000076, -81.392825836999975 39.02516539100003, -81.392797063999978 39.025268505000042, -81.392709541999977 39.025360345000024, -81.392656017999968 39.025422874000071)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld7', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.384050394999974 39.028559954000059, -81.38408663599995 39.028822360000049, -81.384175721999952 39.02901662000005, -81.384279356999969 39.029187953000076, -81.38442669899996 39.029301901000053, -81.384535691999986 39.029342390000068, -81.38455874899995 39.02930146500006, -81.384616705999974 39.029163942000025, -81.38467426599999 39.028957756000068, -81.384702617999949 39.028774553000062, -81.385390654999981 39.028486174000079, -81.385464325999976 39.028543152000054, -81.386032917999955 39.029084282000042, -81.386039463999964 39.029079141000068, -81.386376175999942 39.028940686000055, -81.386757028999966 39.02882498200006, -81.386991409999951 39.028755538000041, -81.387152802999935 39.028755002000025, -81.38728447799997 39.028685900000028, -81.38747465299997 39.028582269000026, -81.387591853999936 39.028547547000073, -81.387856387999989 39.028626778000046, -81.387885295999979 39.028546572000039, -81.387987937999981 39.028534785000033, -81.388046938999935 39.028591811000069, -81.388106127999947 39.028683169000033, -81.388708185999974 39.028772718000027, -81.389045958999986 39.028828813000075, -81.389207277999958 39.028816831000029, -81.389029529999959 39.028508428000066, -81.38885133399998 39.028119915000048, -81.38877765999996 39.028062939000051, -81.38877697099997 39.027937054000063, -81.388761295999984 39.027753997000048, -81.388746435999963 39.027719722000029, -81.388569996999934 39.027651635000041, -81.388290603999963 39.027538124000046, -81.38815786899994 39.027412677000029, -81.388083320999954 39.02719548400006, -81.388038366999979 39.027023968000037, -81.38818433299997 39.026886150000053, -81.388302583999973 39.027045986000076, -81.388391364999961 39.027183013000069, -81.388479083999982 39.027125500000068, -81.388493191999942 39.027022454000075, -81.388536955999939 39.026976531000059, -81.388639846999979 39.027010521000079, -81.388786814999946 39.027055809000046, -81.388918672999978 39.027021036000065, -81.388961558999938 39.02681489500003, -81.388945632999935 39.026586062000035, -81.388900551999939 39.026391650000051, -81.388958548999938 39.026265569000032, -81.389118681999946 39.026036149000049, -81.389629547999959 39.025553782000031, -81.389818956999989 39.025312818000032, -81.390037832999951 39.025094645000024, -81.390301477999969 39.02501365300003, -81.390521484999965 39.025001472000042, -81.390668386999948 39.025035312000057, -81.390667504999954 39.024875096000073, -81.390637469999945 39.024749308000025, -81.39087176999999 39.024668414000075, -81.390827251999951 39.024577008000051, -81.390767055999959 39.024302545000069, -81.390780516999939 39.024085058000026, -81.390749232999951 39.023730389000036, -81.390718504999938 39.023478716000056, -81.39077598099999 39.023261082000033, -81.390775350999945 39.023146632000078, -81.390745830999947 39.023112407000042, -81.39062877899994 39.023170020000066, -81.390423950999946 39.023273705000065, -81.390380126999958 39.023308185000076, -81.390262947999986 39.023342910000054, -81.390174870999942 39.023331760000076, -81.389998617999936 39.023298017000059, -81.38995491999998 39.023355393000031, -81.38995573699998 39.023504157000048, -81.389956302999963 39.023607154000047, -81.389883512999972 39.023710398000048, -81.389751787999955 39.023768059000076, -81.389619935999974 39.023802833000047, -81.389150209999968 39.023758623000049, -81.388490009999941 39.023760823000032, -81.387888682999971 39.023797157000047, -81.38744860099996 39.023810064000031, -81.387262907999968 39.023850141000025, -81.387102149999976 39.023965118000035, -81.386458925999989 39.024390691000065, -81.386035016999983 39.024678203000065, -81.385611163999954 39.02497715700008, -81.385304618999953 39.025264277000076, -81.38505650899998 39.025505419000069, -81.384881754999981 39.025746336000054, -81.38473627999997 39.025975702000039, -81.384790244999976 39.025993285000027, -81.384819774999983 39.02602752100006, -81.384805350999954 39.026073355000051, -81.38489350499998 39.02609594300003, -81.385025548999977 39.026095508000026, -81.385186811999972 39.026072096000064, -81.385318793999943 39.026060206000068, -81.385348448999935 39.026117330000034, -81.385334284999942 39.026208931000042, -81.385275897999975 39.026266346000057, -81.385085290999939 39.026289864000034, -81.384865278999939 39.026302034000025, -81.384836121999967 39.026336463000064, -81.384792168999979 39.026348053000049, -81.384606221999945 39.02634234900006, -81.384348081999974 39.027441863000035, -81.384490139999969 39.027470602000051, -81.384403348999967 39.027699773000052, -81.384217706999948 39.027751290000026, -81.38417463199994 39.027923096000052, -81.384117360999937 39.028136041000039, -81.384083600999986 39.028261599000075, -81.384040823999953 39.028490626000064, -81.384050394999974 39.028559954000059), (-81.387768333999986 39.025937646000045, -81.387605447999988 39.025663524000038, -81.387487075999957 39.025480808000054, -81.386959266999952 39.025551226000061, -81.386680570999943 39.025563595000051, -81.386592417999964 39.025540998000054, -81.386812052999971 39.02546016000008, -81.386929161999944 39.025413994000075, -81.387075202999938 39.025287631000026, -81.387133262999953 39.02517298600003, -81.387161918999936 39.025047003000054, -81.387146873999939 39.024978387000033, -81.386999786999979 39.02491021000003, -81.38688222899998 39.024876266000035, -81.386867369999948 39.024841983000044, -81.386808248999955 39.024762069000076, -81.386778905999961 39.024762166000073, -81.38664717499995 39.024819824000076, -81.386573817999988 39.024820067000064, -81.386529555999971 39.024774437000076, -81.386499776999983 39.024694425000064, -81.386543353999969 39.024614180000071, -81.386572260999969 39.024533964000057, -81.386732833999986 39.024384655000063, -81.386996541999963 39.024315115000036, -81.38743612799999 39.024210658000072, -81.387670741999955 39.024186989000043, -81.38778842399995 39.024243819000048, -81.38787720199997 39.02438085700004, -81.38792209099995 39.024540928000079, -81.387863718999938 39.024598343000036, -81.387908357999947 39.024712647000058, -81.387938137999981 39.024792650000052, -81.387894561999985 39.024872905000052, -81.387850984999943 39.024953160000052, -81.387909983999975 39.025010185000042, -81.388101336999966 39.025123992000033, -81.388248425999961 39.025192169000036, -81.38838046799998 39.025191729000028, -81.388438716999985 39.025111424000045, -81.388496712999938 39.024985344000072, -81.388584689999959 39.024973607000049, -81.388819607999949 39.025007157000061, -81.389024943999971 39.024995028000035, -81.389186066999969 39.024948713000072, -81.389288839999949 39.024959815000045, -81.389215985999954 39.025051612000027, -81.388996291999945 39.025121011000067, -81.388967700999956 39.025258438000037, -81.388968265999949 39.025361435000036, -81.388851458999966 39.025464824000039, -81.388705182999956 39.025545421000061, -81.388573264999934 39.025568750000048, -81.388411252999958 39.02545484500007, -81.38832277399996 39.025375030000077, -81.388058949999959 39.025421685000026, -81.387986092999938 39.025513482000065, -81.387972358999946 39.025685193000072, -81.387856113999987 39.025891577000039, -81.387768333999986 39.025937646000045)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld8', @aoiGeomFixed); SELECT @aoiGeom = GEOMETRY::STGeomFromText('MULTIPOLYGON (((-81.387262907999968 39.023850141000025, -81.386984282999947 39.023873954000067, -81.386661703999948 39.023909358000026, -81.386397499999987 39.023887353000077, -81.386191293999957 39.023739250000062, -81.38610227099997 39.023556437000025, -81.385998080999968 39.023282117000065, -81.385821156999953 39.02312248100003, -81.385879043999978 39.022973514000057, -81.385966372999974 39.02284733700003, -81.385976101999972 39.022830697000074, -81.385917193999944 39.02278515200004, -81.385726171999977 39.022728561000065, -81.384859720999941 39.022571202000051, -81.384389695999971 39.022469753000053, -81.383934156999942 39.02233392100004, -81.383773016999953 39.022271733000025, -81.383602921999966 39.022591914000031, -81.383355854999934 39.023027610000042, -81.383138086999963 39.023451766000051, -81.382934667999962 39.023818653000035, -81.382789189999983 39.024048017000041, -81.38258657099999 39.024563676000071, -81.382354296999949 39.025022211000078, -81.382122203999984 39.025515068000061, -81.381904297999938 39.025916342000073, -81.381686859999945 39.026409159000025, -81.381571270999984 39.026741432000051, -81.381469552999988 39.026924874000031, -81.381323879999968 39.027119903000028, -81.38112001199994 39.027406678000034, -81.381061999999986 39.027532755000038, -81.380960647999984 39.027784861000043, -81.381008909999935 39.028095781000047, -81.38051214799998 39.028486500000042, -81.380190098999947 39.02862489100005, -81.380059151999944 39.028831317000027, -81.379269178999948 39.029268781000042, -81.378631107999979 39.02949792000004, -81.378579010999943 39.029646595000031, -81.378523706999943 39.029698796000048, -81.378579925999986 39.029818256000055, -81.37913649799998 39.029633340000032, -81.379604726999958 39.029391486000065, -81.380116600999941 39.029080823000072, -81.380335457999934 39.028851223000061, -81.38046671099994 39.028702018000047, -81.380773903999966 39.028529352000078, -81.380993431999968 39.028425636000065, -81.381315173999951 39.028230032000067, -81.381631680999988 39.027061676000073, -81.38417463199994 39.027923096000052, -81.384217706999948 39.027751290000026, -81.384158338999953 39.027625598000043, -81.38417252499994 39.027533996000045, -81.384172091999972 39.027453888000025, -81.384348081999974 39.027441863000035, -81.384606221999945 39.02634234900006, -81.384415118999982 39.026274313000044, -81.38417962799997 39.026137757000072, -81.384046642999976 39.025966530000062, -81.384031228999959 39.025829249000026, -81.384060137999938 39.025749044000065, -81.384118773999944 39.025737406000076, -81.384162985999978 39.025771594000048, -81.384266232999948 39.025874252000051, -81.384413506999977 39.025976766000042, -81.384589750999965 39.026010518000078, -81.38473627999997 39.025975702000039, -81.384881754999981 39.025746336000054, -81.38505650899998 39.025505419000069, -81.385304618999953 39.025264277000076, -81.385611163999954 39.02497715700008, -81.386035016999983 39.024678203000065, -81.386458925999989 39.024390691000065, -81.387102149999976 39.023965118000035, -81.387262907999968 39.023850141000025)))', 4326); SELECT @aoiGeomFixed = @aoiGeom.MakeValid().STUnion(@aoiGeom.STStartPoint()); INSERT INTO #AoiTable ( landunit, aoigeom ) VALUES ('T645 Fld9', @aoiGeomFixed); -- End of AOI geometry section 9