{ "currentVersion": 10.81, "id": 9, "name": "CORPGIS.CORPDATA.UNI72LIVE_PR_LPI", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STREET_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "KEYVAL", "type": "esriFieldTypeString", "alias": "KEYVAL", "length": 13, "domain": null }, { "name": "PKEYVAL", "type": "esriFieldTypeString", "alias": "PKEYVAL", "length": 13, "domain": null }, { "name": "ST_KEYVAL", "type": "esriFieldTypeString", "alias": "ST_KEYVAL", "length": 13, "domain": null }, { "name": "U_VERSION", "type": "esriFieldTypeString", "alias": "U_VERSION", "length": 1, "domain": null }, { "name": "PROP_SEQ_NO", "type": "esriFieldTypeSmallInteger", "alias": "PROP_SEQ_NO", "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 240, "domain": null }, { "name": "START_D", "type": "esriFieldTypeDate", "alias": "START_D", "length": 8, "domain": null }, { "name": "END_D", "type": "esriFieldTypeDate", "alias": "END_D", "length": 8, "domain": null }, { "name": "CURRENCY_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "CURRENCY_FLAG", "domain": null }, { "name": "LOGICAL_STATUS", "type": "esriFieldTypeString", "alias": "LOGICAL_STATUS", "length": 1, "domain": null }, { "name": "PAO_START_NO", "type": "esriFieldTypeSmallInteger", "alias": "PAO_START_NO", "domain": null }, { "name": "PAO_START_SFX", "type": "esriFieldTypeString", "alias": "PAO_START_SFX", "length": 2, "domain": null }, { "name": "PAO_END_NO", "type": "esriFieldTypeSmallInteger", "alias": "PAO_END_NO", "domain": null }, { "name": "PAO_END_SFX", "type": "esriFieldTypeString", "alias": "PAO_END_SFX", "length": 2, "domain": null }, { "name": "PAO_DESC", "type": "esriFieldTypeString", "alias": "PAO_DESC", "length": 90, "domain": null }, { "name": "SAO_START_NO", "type": "esriFieldTypeSmallInteger", "alias": "SAO_START_NO", "domain": null }, { "name": "SAO_START_SFX", "type": "esriFieldTypeString", "alias": "SAO_START_SFX", "length": 2, "domain": null }, { "name": "SAO_END_NO", "type": "esriFieldTypeSmallInteger", "alias": "SAO_END_NO", "domain": null }, { "name": "SAO_END_SFX", "type": "esriFieldTypeString", "alias": "SAO_END_SFX", "length": 2, "domain": null }, { "name": "SAO_DESC", "type": "esriFieldTypeString", "alias": "SAO_DESC", "length": 90, "domain": null }, { "name": "POSTCODE", "type": "esriFieldTypeString", "alias": "POSTCODE", "length": 8, "domain": null }, { "name": "POST_TOWN", "type": "esriFieldTypeString", "alias": "POST_TOWN", "length": 30, "domain": null }, { "name": "LPI_LEVEL", "type": "esriFieldTypeString", "alias": "LPI_LEVEL", "length": 30, "domain": null }, { "name": "OFFICIAL_ADDR", "type": "esriFieldTypeString", "alias": "OFFICIAL_ADDR", "length": 1, "domain": null }, { "name": "LPI_CHECK_STATUS", "type": "esriFieldTypeString", "alias": "LPI_CHECK_STATUS", "length": 10, "domain": null }, { "name": "LPI_MATCH_STATUS", "type": "esriFieldTypeString", "alias": "LPI_MATCH_STATUS", "length": 10, "domain": null }, { "name": "PART_MATCH_STATUS", "type": "esriFieldTypeString", "alias": "PART_MATCH_STATUS", "length": 1, "domain": null }, { "name": "NLPG_RELEASE_NO", "type": "esriFieldTypeInteger", "alias": "NLPG_RELEASE_NO", "domain": null }, { "name": "PO_BOX", "type": "esriFieldTypeString", "alias": "PO_BOX", "length": 6, "domain": null }, { "name": "DEPARTMENT", "type": "esriFieldTypeString", "alias": "DEPARTMENT", "length": 60, "domain": null }, { "name": "ORGANISATION", "type": "esriFieldTypeString", "alias": "ORGANISATION", "length": 60, "domain": null }, { "name": "LPI_DESC", "type": "esriFieldTypeString", "alias": "LPI_DESC", "length": 240, "domain": null }, { "name": "CREATED_D", "type": "esriFieldTypeDate", "alias": "CREATED_D", "length": 8, "domain": null }, { "name": "UPDATED_D", "type": "esriFieldTypeDate", "alias": "UPDATED_D", "length": 8, "domain": null }, { "name": "LPI_USE", "type": "esriFieldTypeString", "alias": "LPI_USE", "length": 6, "domain": null }, { "name": "PR_PAON_KEYVAL", "type": "esriFieldTypeString", "alias": "PR_PAON_KEYVAL", "length": 13, "domain": null }, { "name": "NON_POSTAL", "type": "esriFieldTypeString", "alias": "NON_POSTAL", "length": 1, "domain": null }, { "name": "EX_DEPARTMENT", "type": "esriFieldTypeString", "alias": "EX_DEPARTMENT", "length": 1, "domain": null }, { "name": "EX_ORGANISATION", "type": "esriFieldTypeString", "alias": "EX_ORGANISATION", "length": 1, "domain": null }, { "name": "EX_POSTTOWN", "type": "esriFieldTypeString", "alias": "EX_POSTTOWN", "length": 1, "domain": null }, { "name": "EX_PAO_DESC", "type": "esriFieldTypeString", "alias": "EX_PAO_DESC", "length": 1, "domain": null }, { "name": "EX_SAO_DESC", "type": "esriFieldTypeString", "alias": "EX_SAO_DESC", "length": 1, "domain": null }, { "name": "QUERY_RESTRICTION_LEVEL", "type": "esriFieldTypeSmallInteger", "alias": "QUERY_RESTRICTION_LEVEL", "domain": null }, { "name": "TOWNLAND", "type": "esriFieldTypeString", "alias": "TOWNLAND", "length": 30, "domain": null }, { "name": "LPI_LANGUAGE", "type": "esriFieldTypeString", "alias": "LPI_LANGUAGE", "length": 3, "domain": null }, { "name": "LPI_KEY", "type": "esriFieldTypeString", "alias": "LPI_KEY", "length": 14, "domain": null }, { "name": "CUSTODIAN_ONE", "type": "esriFieldTypeSmallInteger", "alias": "CUSTODIAN_ONE", "domain": null }, { "name": "CUSTODIAN_TWO", "type": "esriFieldTypeSmallInteger", "alias": "CUSTODIAN_TWO", "domain": null }, { "name": "CAN_KEY", "type": "esriFieldTypeString", "alias": "CAN_KEY", "length": 14, "domain": null }, { "name": "EDIT_ADDRESS", "type": "esriFieldTypeString", "alias": "EDIT_ADDRESS", "length": 1, "domain": null }, { "name": "SUB_LOCALITY", "type": "esriFieldTypeString", "alias": "SUB_LOCALITY", "length": 35, "domain": null }, { "name": "KEYVAL_1", "type": "esriFieldTypeString", "alias": "KEYVAL_1", "length": 13, "domain": null }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "length": 100, "domain": null }, { "name": "LOCALITY_NAME", "type": "esriFieldTypeString", "alias": "LOCALITY_NAME", "length": 40, "domain": null }, { "name": "POSTAL_TOWN", "type": "esriFieldTypeString", "alias": "POSTAL_TOWN", "length": 40, "domain": null } ], "indexes": [ { "name": "R52191_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "fc2aafb4da5d4d118b54df78382735dc" }