Dargans Creek Reserve

Makefile

query.sql: parcels.txt
	cat parcels.txt | sed 's/Lot /(lotnumber = \'/' | sed -E 's/ DP ?/\' and plannumber = /' | sed 's/$/) or /' | tr -d '\n' | sed 's/ or $//'> query.sql

reserve.geojson:
	wget -O reserve.geojson 'https://maps.six.nsw.gov.au/arcgis/rest/services/public/NSW_Cadastre/MapServer/9/query?where=%28lotnumber+%3D+%272%27+and+plannumber+%3D+778317%29+or+%28lotnumber+%3D+%277014%27+and+plannumber+%3D+1020484%29+or+%28lotnumber+%3D+%277311%27+and+plannumber+%3D+1154270%29+or+%28lotnumber+%3D+%277312%27+and+plannumber+%3D+1154269%29+or+%28lotnumber+%3D+%277313%27+and+plannumber+%3D+1154269%29+or+%28lotnumber+%3D+%277301%27+and+plannumber+%3D+1123766%29+or+%28lotnumber+%3D+%277033%27+and+plannumber+%3D+1051528%29+or+%28lotnumber+%3D+%277015%27+and+plannumber+%3D+1051527%29+or+%28lotnumber+%3D+%271%27+and+plannumber+%3D+778317%29+or+%28lotnumber+%3D+%277018%27+and+plannumber+%3D+1051736%29+or+%28lotnumber+%3D+%277019%27+and+plannumber+%3D+1051736%29+or+%28lotnumber+%3D+%27266%27+and+plannumber+%3D+751650%29+or+%28lotnumber+%3D+%27251%27+and+plannumber+%3D+751650%29+or+%28lotnumber+%3D+%27250%27+and+plannumber+%3D+751650%29+or+%28lotnumber+%3D+%277034%27+and+plannumber+%3D+1051528%29+or+%28lotnumber+%3D+%277035%27+and+plannumber+%3D+1051737%29+or+%28lotnumber+%3D+%2782%27+and+plannumber+%3D+751650%29+or+%28lotnumber+%3D+%27239%27+and+plannumber+%3D+751650%29+or+%28lotnumber+%3D+%27235%27+and+plannumber+%3D+751650%29+or+%28lotnumber+%3D+%27234%27+and+plannumber+%3D+751650%29+or+%28lotnumber+%3D+%277015%27+and+plannumber+%3D+1051527%29+or+%28lotnumber+%3D+%277035%27+and+plannumber+%3D+1051737%29&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=&returnGeometry=true&returnTrueCurves=false&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&resultOffset=&resultRecordCount=&queryByDistance=&returnExtentsOnly=false&datumTransformation=&parameterValues=&rangeValues=&f=geojson'

parcels.txt

Lot 2 DP 778317
Lot 7014 DP 1020484
Lot 7311 DP 1154270
Lot 7312 DP 1154269
Lot 7313 DP 1154269
Lot 7301 DP 1123766
Lot 7033 DP 1051528
Lot 7015 DP 1051527
Lot 1 DP 778317
Lot 7018 DP1051736
Lot 7019 DP 1051736
Lot 266 DP 751650
Lot 251 DP 751650
Lot 250 DP 751650
Lot 7034 DP 1051528
Lot 7035 DP 1051737
Lot 82 DP 751650
Lot 239 DP 751650
Lot 235 DP 751650
Lot 234 DP 751650
Lot 7015 DP 1051527
Lot 7035 DP 1051737

query.sql

(lotnumber = '2' and plannumber = 778317) or (lotnumber = '7014' and plannumber = 1020484) or (lotnumber = '7311' and plannumber = 1154270) or (lotnumber = '7312' and plannumber = 1154269) or (lotnumber = '7313' and plannumber = 1154269) or (lotnumber = '7301' and plannumber = 1123766) or (lotnumber = '7033' and plannumber = 1051528) or (lotnumber = '7015' and plannumber = 1051527) or (lotnumber = '1' and plannumber = 778317) or (lotnumber = '7018' and plannumber = 1051736) or (lotnumber = '7019' and plannumber = 1051736) or (lotnumber = '266' and plannumber = 751650) or (lotnumber = '251' and plannumber = 751650) or (lotnumber = '250' and plannumber = 751650) or (lotnumber = '7034' and plannumber = 1051528) or (lotnumber = '7035' and plannumber = 1051737) or (lotnumber = '82' and plannumber = 751650) or (lotnumber = '239' and plannumber = 751650) or (lotnumber = '235' and plannumber = 751650) or (lotnumber = '234' and plannumber = 751650) or (lotnumber = '7015' and plannumber = 1051527) or (lotnumber = '7035' and plannumber = 1051737)

reserve.geojson