Dataset

Brownfield land

This dataset is the yield of the Brownfield land pipeline. The pipeline has been configured to collect, process and yield data that matches the Brownfield land schema.

Configuration summary

Typology
Geography
Sources
1090
Pipeline rules
557
Lookup rules
29351
Collection
Brownfield land

Pipeline rules

122 column rules

Map resource column name to dataset field

Showing 5 column rules

Dataset Column Endpoint Field Resource Entry date Start date End date
brownfield-landBNG_NorthingGeoY
brownfield-landOrganistionURIOrganisationURI
brownfield-landOrganisationURLOrganisationURI
brownfield-landOrgansiationURIOrganisationURI
brownfield-landOrganisationURIOrganisationURI

See all column rules

0 combine rules

Combine a series of facts from multiple entries

2 concat rules

Concatenate fields during the harmonise phase

Showing 2 concat rules

Dataset Endpoint Field Fields Resource Separator Entry date Start date End date
brownfield-landNotesDevelopmentDescription;SiteInformation.
brownfield-landSiteNameAddressSITENAME;Site Name;Address 1;Address 2,

See all concat rules

25 convert rules

Convert a resource

Showing 5 convert rules

Dataset Endpoint Parameters Plugin Resource Entry date Start date End date
brownfield-land03c7a1f30e458d43019c33bf16f050650c7e109a833fa57076a660fad9c02bf4
brownfield-land083bcaab201ec76562ca96c13b687b249e16fbe9372966078d9f870e722a365b
brownfield-land34e3c37538889673a7227716ccb0faca6e1b1ffa6a0b8bc7807294d8d144577a
brownfield-land3b08e37cd8d9263627609d72c3b2b2c6c0cfb3a120e42f0504ef45d158d674ea
brownfield-land40ba241c5f5da1de68d3c025e68210d8707413a4d7c50ce9396a006802556669

See all convert rules

0 default rules

Take a missing field default value from another field

0 default-value rules

provide a default value for a missing or empty field

0 filter rules

Filter entries

29351 lookup rules

Lookup entities

Showing 5 lookup rules

Dataset Endpoint Entity Entry number Organisation CURIE prefix Reference Resource Value Entry date Start date End date
10900000ownership-statusowned by a public authority
10900001ownership-statusnot owned by a public authority
10900002ownership-statusmixed ownership
11900000planning-permission-typefull planning permission
11900001planning-permission-typeoutline planning permission

See all lookup rules

378 patch rules

Assert a field value during harmonise

Showing 5 patch rules

Dataset Endpoint Entry number Field Pattern Resource Value Entry date Start date End date
brownfield-landHectares0..463c6a9a9d1c175350d98273d0dd73e85a5de2e55c4744b880426e818a3b62db900.46
brownfield-landLastUpdatedDate2021-12-01b155065090c5164dd719ad535b3fc130a92f02d877d77f856e57ea4f6ab1e5c42021-09-09
brownfield-landSiteReferenceSSv20fe443fa80b877feec0fb9f9cc5476b30be6ea33505ebf9e1616c5c3c6844e6e0SSV20
brownfield-land^<*[Nn][Uu][Ll][Ll]>*$
brownfield-land^#*[Nn]/?[Aa]$

See all patch rules

7 skip rules

Remove lines from a resource during normalise

Showing 5 skip rules

Dataset Endpoint Entry number Pattern Resource Entry date Start date End date
brownfield-land^,*[^,]*,*$
brownfield-land^.*Unnamed: 1,Unnamed: 2,Unnamed: 3,Unnamed: 4,Unnamed: 5,Unnamed: 6.*$
brownfield-land^Unnamed: 0,
brownfield-land^1,2,3,4,5,6,7,8,
brownfield-land^(Mandatory|Optional)(,Mandatory|,Optional){6,}

See all skip rules

23 transform rules

None

Showing 5 transform rules

Dataset Endpoint Entry number Field Replacement field Resource Entry date Start date End date
brownfield-landOrganisationURI
brownfield-landSiteReference
brownfield-landSiteReference
brownfield-landSiteNameAddress
brownfield-landGeoX

See all transform rules

Sources

+ add new source

Showing 20 sources.

See table of all sources for Brownfield land dataset.