{ "currentVersion": 10.81, "id": 13, "name": "bg_gn.sde.adComponent", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "id_namespace", "typeIdField": "STYPE", "subtypeFieldName": "STYPE", "subtypeField": "STYPE", "defaultSubtypeCode": 16, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "Unique identifier", "domain": null }, { "name": "ifcid", "type": "esriFieldTypeInteger", "alias": "ArcGIS for INSPIRE identifier, used in references to the object/feature", "domain": null }, { "name": "id_localid", "type": "esriFieldTypeString", "alias": "inspireId_localId", "length": 255, "domain": null }, { "name": "id_namespace", "type": "esriFieldTypeString", "alias": "inspireId_namespace", "length": 255, "domain": null }, { "name": "id_versionid", "type": "esriFieldTypeString", "alias": "inspireId_versionId", "length": 255, "domain": null }, { "name": "id_versionid_void", "type": "esriFieldTypeSmallInteger", "alias": "inspireId_versionId_void", "domain": null }, { "name": "alternativeidentifier", "type": "esriFieldTypeString", "alias": "alternativeIdentifier", "length": 255, "domain": null }, { "name": "alternativeidentifier_void", "type": "esriFieldTypeSmallInteger", "alias": "alternativeIdentifier_void", "domain": null }, { "name": "beginlifespanversion", "type": "esriFieldTypeDate", "alias": "beginLifespanVersion", "length": 8, "domain": null }, { "name": "beginlifespanversion_void", "type": "esriFieldTypeSmallInteger", "alias": "beginLifespanVersion_void", "domain": null }, { "name": "endlifespanversion", "type": "esriFieldTypeDate", "alias": "endLifespanVersion", "length": 8, "domain": null }, { "name": "endlifespanversion_void", "type": "esriFieldTypeSmallInteger", "alias": "endLifespanVersion_void", "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 255, "domain": { "type": "codedValue", "name": "adStatusValue", "description": "Current validity of the real world address or address component. \n \n \n NOTE 1 This element enables the application schema to represent a full life-cycle of an address and address component, from proposed to reserved, current and retired, or even alternative. \n \n NOTE 2 The status value relates to the real world address or address component and not to the property to which the address or address component is assigned (the addressable object).", "codedValues": [ { "name": "current", "code": "current" }, { "name": "retired", "code": "retired" }, { "name": "proposed", "code": "proposed" }, { "name": "reserved", "code": "reserved" }, { "name": "alternative", "code": "alternative" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "status_cl", "type": "esriFieldTypeString", "alias": "status_cl", "length": 255, "domain": null }, { "name": "status_void", "type": "esriFieldTypeSmallInteger", "alias": "status_void", "domain": null }, { "name": "validfrom", "type": "esriFieldTypeDate", "alias": "validFrom", "length": 8, "domain": null }, { "name": "validfrom_void", "type": "esriFieldTypeSmallInteger", "alias": "validFrom_void", "domain": null }, { "name": "validto", "type": "esriFieldTypeDate", "alias": "validTo", "length": 8, "domain": null }, { "name": "validto_void", "type": "esriFieldTypeSmallInteger", "alias": "validTo_void", "domain": null }, { "name": "within_void", "type": "esriFieldTypeSmallInteger", "alias": "situatedWithin_void", "domain": null }, { "name": "level_", "type": "esriFieldTypeString", "alias": "level", "length": 255, "domain": { "type": "codedValue", "name": "auAdmHierarchyLevel", "description": "Levels of administration in the national administrative hierarchy. This code list reflects the level in the hierarchical pyramid of the administrative structures, which is based on geometric aggregation of territories and does not necessarily describe the subordination between the related administrative authorities.", "codedValues": [ { "name": "1stOrder", "code": "1stOrder" }, { "name": "2ndOrder", "code": "2ndOrder" }, { "name": "3rdOrder", "code": "3rdOrder" }, { "name": "4thOrder", "code": "4thOrder" }, { "name": "5thOrder", "code": "5thOrder" }, { "name": "6thOrder", "code": "6thOrder" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "level_cl", "type": "esriFieldTypeString", "alias": "level_cl", "length": 255, "domain": null }, { "name": "adminunit", "type": "esriFieldTypeInteger", "alias": "adminUnit", "domain": null }, { "name": "adminunit_void", "type": "esriFieldTypeSmallInteger", "alias": "adminUnit_void", "domain": null }, { "name": "link_void", "type": "esriFieldTypeSmallInteger", "alias": "transportLink_void", "domain": null }, { "name": "namedplace", "type": "esriFieldTypeInteger", "alias": "namedPlace", "domain": null }, { "name": "namedplace_void", "type": "esriFieldTypeSmallInteger", "alias": "namedPlace_void", "domain": null }, { "name": "postcode", "type": "esriFieldTypeString", "alias": "postCode", "length": 255, "domain": null }, { "name": "stype", "type": "esriFieldTypeInteger", "alias": "Subtype discriminator (type name)", "domain": { "type": "codedValue", "name": "adComponent_D", "description": "Possible Subtypes", "codedValues": [ { "name": "adAdminUnitName", "code": 16 }, { "name": "adPostalDescriptor", "code": 15 }, { "name": "adThoroughfareName", "code": 14 }, { "name": "adAddressAreaName", "code": 13 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "i1041ifcid", "fields": "ifcid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r928_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": {}, "id": 16, "name": "adAdminUnitName" }, { "domains": {}, "id": 15, "name": "adPostalDescriptor" }, { "domains": {}, "id": 14, "name": "adThoroughfareName" }, { "domains": {}, "id": 13, "name": "adAddressAreaName" } ], "subtypes": [ { "domains": {}, "defaultValues": { "ifcid": null, "id_localid": null, "id_namespace": null, "id_versionid": null, "id_versionid_void": null, "alternativeidentifier": null, "alternativeidentifier_void": null, "beginlifespanversion": null, "beginlifespanversion_void": null, "endlifespanversion": null, "endlifespanversion_void": null, "status": null, "status_cl": null, "status_void": null, "validfrom": null, "validfrom_void": null, "validto": null, "validto_void": null, "within_void": null, "level_": null, "level_cl": null, "adminunit": null, "adminunit_void": null, "link_void": null, "namedplace": null, "namedplace_void": null, "postcode": null, "stype": null }, "code": 16, "name": "adAdminUnitName" }, { "domains": {}, "defaultValues": { "ifcid": null, "id_localid": null, "id_namespace": null, "id_versionid": null, "id_versionid_void": null, "alternativeidentifier": null, "alternativeidentifier_void": null, "beginlifespanversion": null, "beginlifespanversion_void": null, "endlifespanversion": null, "endlifespanversion_void": null, "status": null, "status_cl": null, "status_void": null, "validfrom": null, "validfrom_void": null, "validto": null, "validto_void": null, "within_void": null, "level_": null, "level_cl": null, "adminunit": null, "adminunit_void": null, "link_void": null, "namedplace": null, "namedplace_void": null, "postcode": null, "stype": null }, "code": 15, "name": "adPostalDescriptor" }, { "domains": {}, "defaultValues": { "ifcid": null, "id_localid": null, "id_namespace": null, "id_versionid": null, "id_versionid_void": null, "alternativeidentifier": null, "alternativeidentifier_void": null, "beginlifespanversion": null, "beginlifespanversion_void": null, "endlifespanversion": null, "endlifespanversion_void": null, "status": null, "status_cl": null, "status_void": null, "validfrom": null, "validfrom_void": null, "validto": null, "validto_void": null, "within_void": null, "level_": null, "level_cl": null, "adminunit": null, "adminunit_void": null, "link_void": null, "namedplace": null, "namedplace_void": null, "postcode": null, "stype": null }, "code": 14, "name": "adThoroughfareName" }, { "domains": {}, "defaultValues": { "ifcid": null, "id_localid": null, "id_namespace": null, "id_versionid": null, "id_versionid_void": null, "alternativeidentifier": null, "alternativeidentifier_void": null, "beginlifespanversion": null, "beginlifespanversion_void": null, "endlifespanversion": null, "endlifespanversion_void": null, "status": null, "status_cl": null, "status_void": null, "validfrom": null, "validfrom_void": null, "validto": null, "validto_void": null, "within_void": null, "level_": null, "level_cl": null, "adminunit": null, "adminunit_void": null, "link_void": null, "namedplace": null, "namedplace_void": null, "postcode": null, "stype": null }, "code": 13, "name": "adAddressAreaName" } ], "relationships": [ { "id": 0, "name": "gnNamedPlaceL_gnNamedPlaceL_name", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "namedplace", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "gnNamedPlaceP_gnNamedPlaceP_name", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "namedplace", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "gnNamedPlaceS_gnNamedPlaceS_name", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "namedplace", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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 }