RealProperty

Currently the method returns only a list of Building identifiers for the requested Real Property.

Mapping of the FESD attributes to the WorkZone FESD Web Services database fields and notes on WorkZone FESD Web Services implementation are presented in the table below.

FESD Parameter WorkZone FESD Web Services Table WorkZone FESD Web Services Implementation Notes WorkZone FESD Web Services Implementation Notes
userIdentifier N/A N/A Is recorded to the Use_log.identification field.
realPropertyIdentifier Name fesd_id_key Parameter type is GUID.
landParcelIdentifier Cadastre cadastre_no

Is retrieved from the WorkZone FESD Web Services database by the following algorithm:

  1. Retrieve name_key from a row found in Name table by fesd_id_key = realPropertyIdentifier.
  2. Retrieve name_key from a row found in Name_name table by name_ref_key = name_key and name_type = "1" ("Real property").
  3. Retrieve cadastre_no from a row found in Cadastre table by name_key.
cadastralDistrictIdentifier Name name_code

Is retrieved from the WorkZone FESD Web Services database by the following algorithm:

  1. Retrieve name_key from a row found in Name table by fesd_id_key = realPropertyIdentifier.
  2. Retrieve name_key from a row found in Name_name table by name_ref_key = name_key and name_type = "1" ("Real property").
  3. Retrieve shareholders_key from a row found in Cadastre table by name_key.
  4. Retrieve name_code from a row found in Name table by name_key = shareholders_key.
municipalityCode Name name_code

Is retrieved from the WorkZone FESD Web Services database by the following algorithm:

  1. Retrieve name_key from a row found in Name table by fesd_id_key = realPropertyIdentifier.
  2. Retrieve name_key from a row found in Name_name table by name_ref_key = name_key and name_type = "1" ("Real property").
  3. Retrieve municipality_key from a row found in Cadastre table by name_key.
  4. Retrieve name_code from a row found in Name table by name_key = municipality_key.
landParcelMunicipalPartNumber Contact_info info

Is retrieved from the WorkZone FESD Web Services database by the following algorithm:

  1. Retrieve name_key from a row found in Name table by fesd_id_key = realPropertyIdentifier.
  2. Retrieve name_key from a row found in Name_name table by name_ref_key = name_key and name_type = "1" ("Real property").
  3. Retrieve info from a row found in Contact_info table by name_key and custom_label = ‘delNr’.
buildingIdentifier N/A N/A

Is retrieved from the WorkZone FESD Web Services database by the following algorithm:

  1. Retrieve name_key from a row found in Name table by fesd_id_key = realPropertyIdentifier.
  2. Retrieve name_key from all rows in Name_name table found by name_ref_key = name_key and name_type = "1" ("Real property").
  3. For each row retrieve fesd_id_key from a row found in Name table by name_key.
cadastralIdentifier N/A N/A

Is retrieved from the WorkZone FESD Web Services database by the following algorithm:

  1. Retrieve name_key from a row found in Name table by fesd_id_key = realPropertyIdentifier.
  2. Retrieve name_key from a row found in Name_name table by name_ref_key = name_key and name_type = "1" ("Real property").
  3. Retrieve fesd_id_key from a row found in Name table by name_key.