{"name":"Drilling Permit Monitor","nodes":[{"name":"Schedule Trigger","type":"n8n-nodes-base.scheduleTrigger","position":[250,300],"parameters":{"rule":{"interval":[{"field":"hours","hoursInterval":6}]}}},{"name":"Fetch RRC Permits","type":"n8n-nodes-base.httpRequest","position":[450,300],"parameters":{"url":"https://www.rrc.texas.gov/resource-center/research/data-sets-available-for-download/","method":"GET","authentication":"none"}},{"name":"Parse Permit Data","type":"n8n-nodes-base.code","position":[650,300],"parameters":{"jsCode":"// Parse RRC CSV/XML permit data\n// Filter for new permits since last check\nreturn items;"}},{"name":"Filter New Permits","type":"n8n-nodes-base.filter","position":[850,300],"parameters":{"conditions":{"string":[{"value1":"={{$json.status}}","operation":"equals","value2":"NEW"}]}}},{"name":"Geocode Locations","type":"n8n-nodes-base.httpRequest","position":[1050,200],"parameters":{"url":"https://api.mapbox.com/geocoding/v5/mapbox.places/{{$json.latitude}},{{$json.longitude}}.json","method":"GET"}},{"name":"Generate Map Image","type":"n8n-nodes-base.httpRequest","position":[1050,400],"parameters":{"url":"https://api.mapbox.com/styles/v1/mapbox/satellite-v9/static/{{$json.longitude}},{{$json.latitude}},12,0/600x400@2x","method":"GET","responseFormat":"file"}},{"name":"Enrich Operator Data","type":"n8n-nodes-base.httpRequest","position":[1250,300],"parameters":{"url":"https://www.rrc.texas.gov/resource-center/research/gis-viewer/","method":"GET"}},{"name":"Format Alert","type":"n8n-nodes-base.set","position":[1450,300]},{"name":"Send Telegram Alert","type":"n8n-nodes-base.telegram","position":[1650,300],"parameters":{"chatId":"={{$env.TELEGRAM_CHAT_ID}}","text":"={{$json.alertText}}","additionalFields":{"parse_mode":"HTML"}}},{"name":"Store in Database","type":"n8n-nodes-base.postgres","position":[1650,500],"parameters":{"operation":"insert","table":"drilling_permits"}}],"connections":{"Schedule Trigger":{"main":[[{"node":"Fetch RRC Permits","type":"main","index":0}]]},"Fetch RRC Permits":{"main":[[{"node":"Parse Permit Data","type":"main","index":0}]]},"Parse Permit Data":{"main":[[{"node":"Filter New Permits","type":"main","index":0}]]},"Filter New Permits":{"main":[[{"node":"Geocode Locations","type":"main","index":0},{"node":"Generate Map Image","type":"main","index":0}]]},"Geocode Locations":{"main":[[{"node":"Enrich Operator Data","type":"main","index":0}]]},"Generate Map Image":{"main":[[{"node":"Enrich Operator Data","type":"main","index":0}]]},"Enrich Operator Data":{"main":[[{"node":"Format Alert","type":"main","index":0}]]},"Format Alert":{"main":[[{"node":"Send Telegram Alert","type":"main","index":0},{"node":"Store in Database","type":"main","index":0}]]}}}