search

AKST / Australian-Address-Boundaries-Land-Property-Price-Database

This is a database of geographic boundaries, addresses as well as land and property data (mostly NSW).
MIT License
1 stars 0 forks source link

How should Property Descriptions with `;` in them be interpreted? #7

Open AKST opened 2 weeks ago

AKST commented 2 weeks ago

Immediate Action, just gather examples

Examples

An example from NSW property id 3838002 (MAULES CREEK COLLIERY)

42, PT 57, PT 58, PT 59, PT 60, PT 61/754940 and Pt Leard State Forest No.420 in Parish of Leard; and then about 1700 ha subsurface being Lots 3, pt 35, 55, Pts 58, 64, 65 110 DP 754924; Lots 32, pt 35, 39, 40, 41, 42 DP 754940; Lots 27, 70, 74, 75, Pts 68, 69, 71, 83 DP 754948; Lots 1-2 DP 510801; pt 1 DP 1157540; pt 1, lot 3 DP 1144479; lot 1 DP114793; pt 7001 DP94069. Coal Lease 375 Mining Lease 1701

My guess is split the content by ; run the parser separately on each split and then combine the results, but the above example doesn't seem to follow a typical format.

More

I did this and turns out there's less than 20 actually. Perhaps this isn't a common syntax for the property descriptions

rows = description_containing(';', limit=20, offset=0)
for i, row in rows.iterrows():
    desc = rows.loc[i, 'desc']
    print(int(rows.loc[i, 'nsw_id']), desc)