Mapping Building record <OPO>

n.a.

Fixed mappings

country_id = 528 (NL)

law_country_id = 528 (NL)

status_id = '1'

obj_plaats

Direct mapping

city

obj_bouwjaar

Direct mapping

buildyear

obj_grondm2

Direct mapping

surface_area

obj_renojaar

Direct mapping

year

obj_inspectie

Direct mapping

inspection_date

obj_type

Functional mapping

label

Converts the field obj_type but first removes special characters. When Empty value ‘Niet gevuld in O-Prognose’

obj_adres

Functional mapping

street

This method will strip the field <obj_adres> into two Humble Fields street and house_number The address is divided by each space character. The last part will be the house_number, the rest is the street part

obj_adres

Functional mapping

house_number

See above

obj_memoxxx fields

Functional mapping

remark

Gets all the available and nit empty <obj_memoxxx> fields and concatenate them to one result. The remark length has a maximum of 512 characters in HUMBLE and the result will be truncated if necessary

Functional mapping

short_label

A new code is generated by default for each location of type Building. Code like ‘G-000001’

obj_grondm2

Functional mapping

surface_area

Integer value for the obj_grondm2

obj_postcode

Functional mapping

zipcode

Remove all spaces from the field obj_postcode

obj_code

Functional mapping

search_label

The original reference

obj_code

Functional mapping

reference

The original reference

obj_foto,obj_foto2,

obj_foto,obj_foto4

Image mapping

Added as separate images within HUMBLE. Images are related to the location (building)