I actually did mine in PHP to make it server-side in case I ever wanted to put a web front end to it.
Yeah, I was tempted of doing mine in PHP so that I can store the information in MySQL.
Sounds like we're doing the same thing - I have to do things in two stages:
1. Request "Points" and parse the JSON return (for the South of the UK I get around 26k results for a 3 month period) (use Google Map coordinates to dictate geography, at present am doing about 60% of the UK).
2. Filter out by the type of icon used (so I'm just pulling yftl01y and yfel01y)
3. Request "MarkerDetail" for each point I want more info on and parse JSON response
4. Pull out information of interest into my own array (what I outputted earlier) and add a new field BDUK as a boolean based on a REGEX of the "works_desc" returned from step 3
How are you getting 26K results returned, all I get returned is a max of 100 records.
Also you don't need to look for the l for the type of icons thats for the Traffic Light shown in my partial list below which I had to work out for myself LOL:
'A B C D E F G'
--+-+-+-+-+-+--
"r|c|l|c|0|1|y" "High impact, delays likely" (Red, Digging in road, no entry)
"r|c|l|l|0|1|y" "Traffic control (multi-way signals)" (Red, Digging in road, traffic lights)
"y|c|w|n|0|1|y" "Medium impact, delays possible" (Yellow, Water Tap)
"r|c|w|c|0|1|y" "High impact, delays likely" (Red, Water Tap, no entry)
"r|c|w|l|0|1|y" "High impact, delays likely" (Red, Water Tap, traffic lights)
"y|f|r|l|0|1|y" "Medium impact, delays possible" (Yellow, Train, traffic lights)
"r|f|t|a|0|1|y" "High impact, delays likely" (Red, Phone, one lane closed)
"g|c|l|g|0|1|y" "Low impact, delays unlikely" (Green, Digging in road, Give and take)
"g|f|w|p|2|0|y" "Low impact, delays unlikely" (Green, Water Tap, Priority works)
"y|f|t|s|1|8|y" "Medium impact, delays possible" (Yellow, Phone, Stop/Go boards)
"g|f|g|n|0|1|y" "Low impact, delays unlikely" (Green, Black Flame [Gas maybe])
"y|c|e|n|0|1|y" "Medium impact, delays possible" (Yellow, Lightning Bolt)
--+-+-+-+-+-+--
[A, Colour of icon, Red, Yellow or Green]
r = red
y = yellow
g = green
[B, E, F, G, ???]
[C, Type of icon]
l = local authority work (road digging icon)
w = water/sewage works (water tap)
r = Network Rail works (train)
t = Telecoms work (phone)
g = Gas works (black flame)
e = Electricity works
[D, Type of symbol on icon, like no entry or traffic lights etc]
n = [chunk 1] none
l = [chunk 2] Traffic lights.
s = [chunk 3] Stop/Go boards
p = [chunk 4] Priority works
a = [chunk 5] Lane closure (lane closed)
= [chunk 6] Contra-flow (not seen this icon yet to work out)
g = [chunk 7] Give and take Lane.
* Single Icon *
c = [chunk 8] Road closure (No Entry sign)
As you can see its not fully completed.
What I do is where I am only looking for info in my area I created a POLYGON map around the area in question and that is used to selct the area I want to get infor for.
I then get sent back all work in that area (depending on the selected promoter(s) and I then process that JSON response and add them in a listview control on my app.
My intension was to have it poll for the information ever few mins (seems they update every 10 mins, so 5 mins should be fine) and then add them to the array list for each job work using its id as the key.
A couple of things I thought I could use this for was:
1. Track any changes within an area (keep a historical log in a DB of some sorts)
2. Give a prediction as to what stage people are at based on common steps that are undertaken (1. install of Cab, 2. power connection, 3. fibre ducting?)
Only issues is I don't understand some of the context of what I get back so cannot build a model that translates into some kind of process. So if anyone, in the know, is able to provide me with some guidelines as to what order / how things happen or what these nuggets of information actually mean I might be able to pull something together.
Also need to know if there is anything I need to consider outside of TEL/ELEC roadworks or should I look for something more than BDUK - I know I'm not pulling up anything on the ELEC side so guessing I need to look for something else?
Well I plan to do that as said above, how are you filtering?
Without knowing how you are requesting your information and what page your calling my way might not be any good for you.
I know I can select areas by authority by using lst_location_area_authority and setting that to the following: "186,189" with is Newham and Redbridge councils and use that as an area insted of using a POLYGON map.
From there you can also filter by one or more promoters reducing the list even more.
BTW can you PM whet page you are sending these requests to?
Paul
Print Thread
