2026-07-23_09-55-57Dataset SummaryTOTAL_MERGED_RECORDSALL125625Total merged records between C2_LAPMOS_LA_MASTER and C2_DMS_STAGING_PARCELS using cleaned LA number. 2026-07-23_09-55-57Source TableSOURCE_TABLEC2_LAPMOS_LA_MASTER125625Land application master table joined using LA_NO. 2026-07-23_09-55-57Source TableSOURCE_TABLEC2_DMS_STAGING_PARCELS125625DMS staging parcel table joined using la_num after cleaning. 2026-07-23_09-55-57Clean Key AvailabilityLA_NO_CLEANMISSING125625Availability count for cleaned LA number matching fields. 2026-07-23_09-55-57Clean Key AvailabilityLA_NUM_CLEANPRESENT38119Availability count for cleaned LA number matching fields. 2026-07-23_09-55-57Clean Key AvailabilityLA_NUM_CLEANMISSING87506Availability count for cleaned LA number matching fields. 2026-07-23_09-55-57Parcel DescriptionTOTAL_UNIQUE_PARCEL_DESCRIPTIONSparcel_des18718Total unique parcel descriptions. 2026-07-23_09-55-57Parcel DescriptionPARCEL_DESCRIPTION_PRESENTparcel_des45126Number of records with parcel description. 2026-07-23_09-55-57Parcel DescriptionPARCEL_DESCRIPTION_MISSINGparcel_des80499Number of records without parcel description. 2026-07-23_09-55-57Job TitleTOTAL_UNIQUE_JOB_TITLESjob_title18658Total unique job titles. 2026-07-23_09-55-57Job TitleJOB_TITLE_PRESENTjob_title121421Number of records with job title. 2026-07-23_09-55-57Job TitleJOB_TITLE_MISSINGjob_title4204Number of records without job title. 2026-07-23_09-55-57DistrictDISTRICT_DESCRANAU88741Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCNOT RECORDED17094Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKENINGAU2807Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCBELURAN2528Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKUDAT1616Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKINABATANGAN1439Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCPAPAR1290Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCSIPITANG1182Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCNABAWAN949Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCBEAUFORT863Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKOTA MARUDU857Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKOTA BELUD832Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCTAMBUNAN722Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCTONGOD615Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCPITAS587Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCTENOM544Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCTUARAN506Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCTAWAU496Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCSANDAKAN495Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCLAHAD DATU311Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCSEMPORNA307Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCPENAMPANG289Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKUALA PENYU263Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKUNAK179Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKOTA KINABALU88Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCKALABAKAN8Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCTELUPID8Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCIBU PEJABAT4Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCPUTATAN3Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57DistrictDISTRICT_DESCMEMBAKUT2Number of merged staging spatial records grouped by DISTRICT_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCCULTIVATION103955Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCNOT RECORDED20781Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCRESIDENTIAL469Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCAQUACULTURE99Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCLIVESTOCK86Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCOTHERS45Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCCOMMERCIAL31Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCPOULTRY28Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCEDUCATION26Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCINDUSTRIAL21Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCRELIGIOUS20Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCGOVERNMENT BUILDING17Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCPOWER6Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCRESERVE6Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCNGO BUILDING (ASSOCIATIONS)6Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCLEASURE/RECREATION5Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCCEMETERY5Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCMIX PURPOSES4Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCTRANSPORTATION3Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCMINING3Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCQUARRY2Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCCOMMUNICATION2Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCPUBLIC UTILITIES2Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCMEDICAL1Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCDEFENCE1Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CategoryPURPOSE_CATEGORY_DESCOTHER SERVICES1Number of merged staging spatial records grouped by PURPOSE_CATEGORY_DESC 2026-07-23_09-55-57Purpose CodePURPOSE_CODE_DESCNOT RECORDED125625Number of merged staging spatial records grouped by PURPOSE_CODE_DESC 2026-07-23_09-55-57PT StatusPT_STATUSNOT RECORDED125545Number of merged staging spatial records grouped by PT_STATUS 2026-07-23_09-55-57PT StatusPT_STATUSL40Number of merged staging spatial records grouped by PT_STATUS 2026-07-23_09-55-57PT StatusPT_STATUSR38Number of merged staging spatial records grouped by PT_STATUS 2026-07-23_09-55-57PT StatusPT_STATUSD2Number of merged staging spatial records grouped by PT_STATUS 2026-07-23_09-55-57Application StatusSTATUSY89355Number of merged staging spatial records grouped by STATUS 2026-07-23_09-55-57Application StatusSTATUSNOT RECORDED36270Number of merged staging spatial records grouped by STATUS 2026-07-23_09-55-57Applicant TypeTYPE_OF_APPLICANT_DESCNOT RECORDED122020Number of merged staging spatial records grouped by TYPE_OF_APPLICANT_DESC 2026-07-23_09-55-57Applicant TypeTYPE_OF_APPLICANT_DESCINDIVIDUAL3520Number of merged staging spatial records grouped by TYPE_OF_APPLICANT_DESC 2026-07-23_09-55-57Applicant TypeTYPE_OF_APPLICANT_DESCCOMPANY48Number of merged staging spatial records grouped by TYPE_OF_APPLICANT_DESC 2026-07-23_09-55-57Applicant TypeTYPE_OF_APPLICANT_DESCAGENCY37Number of merged staging spatial records grouped by TYPE_OF_APPLICANT_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCNative Title(NT)103861Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCNOT RECORDED20672Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCCountry Lease(CL)1021Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCTown Lease(TL)22Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCProvisional Lease(PL)15Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCTemporary Occupancy License(TOL)13Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCField Register(FR)12Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCGAZETTE NOTIFICATION7Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCSubsidiary Title (ST)1Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Title TypeTITLE_TYPE_DESCMining Lease(ML)1Number of merged staging spatial records grouped by TITLE_TYPE_DESC 2026-07-23_09-55-57Applied Title TypeAPPLIED_TITLE_TYPE_DESCNOT RECORDED125404Number of merged staging spatial records grouped by APPLIED_TITLE_TYPE_DESC 2026-07-23_09-55-57Applied Title TypeAPPLIED_TITLE_TYPE_DESCNative Title(NT)209Number of merged staging spatial records grouped by APPLIED_TITLE_TYPE_DESC 2026-07-23_09-55-57Applied Title TypeAPPLIED_TITLE_TYPE_DESCCountry Lease(CL)12Number of merged staging spatial records grouped by APPLIED_TITLE_TYPE_DESC 2026-07-23_09-55-57Area UnitUOM_AREA_DESCACRE/S102283Number of merged staging spatial records grouped by UOM_AREA_DESC 2026-07-23_09-55-57Area UnitUOM_AREA_DESCNOT RECORDED20753Number of merged staging spatial records grouped by UOM_AREA_DESC 2026-07-23_09-55-57Area UnitUOM_AREA_DESCHECTARE/S2431Number of merged staging spatial records grouped by UOM_AREA_DESC 2026-07-23_09-55-57Area UnitUOM_AREA_DESCSQ METRE/S133Number of merged staging spatial records grouped by UOM_AREA_DESC 2026-07-23_09-55-57Area UnitUOM_AREA_DESCSQ FEET/S25Number of merged staging spatial records grouped by UOM_AREA_DESC 2026-07-23_09-55-57Land Categoryland_catNOT RECORDED83056Number of merged staging spatial records grouped by land_cat 2026-07-23_09-55-57Land Categoryland_catDraft42252Number of merged staging spatial records grouped by land_cat 2026-07-23_09-55-57Land Categoryland_catFully Acquired317Number of merged staging spatial records grouped by land_cat 2026-07-23_09-55-57Data Sourcedata_srcISS_SHP57578Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_srcDCDB2010_CDE_P349156Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_srcGPKG13966Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_srcDCDB2010_DIGIT4764Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_srcJTU_ACTIVE_PARCELS127Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_srcESS16Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_src48Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_srcISS4Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_srcESS_SHP3Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Data Sourcedata_srcGDM3Number of merged staging spatial records grouped by data_src 2026-07-23_09-55-57Grid Typegrid_typeM125574Number of merged staging spatial records grouped by grid_type 2026-07-23_09-55-57Grid Typegrid_typeNOT RECORDED51Number of merged staging spatial records grouped by grid_type 2026-07-23_09-55-57Active StatusactiveY125625Number of merged staging spatial records grouped by active 2026-07-23_09-55-57Repaired Statusrepaired0124868Number of merged staging spatial records grouped by repaired 2026-07-23_09-55-57Repaired Statusrepaired1757Number of merged staging spatial records grouped by repaired 2026-07-23_09-55-57Restricted Field AvailabilityNAMEMISSING20706Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityNAMEPRESENT104919Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityFILE_REF_NOMISSING24849Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityFILE_REF_NOPRESENT100776Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityCOMMENTSMISSING125605Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityCOMMENTSPRESENT20Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityGOVT_COMMENTSMISSING115343Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityGOVT_COMMENTSPRESENT10282Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityGOVT_COMMENTS2MISSING122198Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityGOVT_COMMENTS2PRESENT3427Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityGOVT_COMMENTS3MISSING123845Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityGOVT_COMMENTS3PRESENT1780Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityLA_STATUS_COMMENTSMISSING125603Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityLA_STATUS_COMMENTSPRESENT22Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityPPHT_SYORMISSING115484Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityPPHT_SYORPRESENT10141Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityPROGRESS_REPORTMISSING26436Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityPROGRESS_REPORTPRESENT99189Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityremarkMISSING116837Only PRESENT/MISSING count is shown. Actual restricted values are not published. 2026-07-23_09-55-57Restricted Field AvailabilityremarkPRESENT8788Only PRESENT/MISSING count is shown. Actual restricted values are not published.