{ "currentVersion": 10.51, "id": 9, "name": "delivsdm:geodb.AddressString", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "roadname", "typeIdField": "AddressStringType", "subtypeFieldName": "AddressStringType", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "createdate", "type": "esriFieldTypeDate", "alias": "createdate", "length": 8, "domain": null }, { "name": "gurasid", "type": "esriFieldTypeInteger", "alias": "gurasid", "domain": { "type": "range", "name": "DmG_GURASID_Range", "range": [ 0, 999999999 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "addresstype", "type": "esriFieldTypeInteger", "alias": "addresstype", "domain": { "type": "codedValue", "name": "DmG_AddressType", "codedValues": [ { "name": "Property Address", "code": 1 }, { "name": "Delivery Address", "code": 2 }, { "name": "Correspondence Address", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ruraladdress", "type": "esriFieldTypeInteger", "alias": "ruraladdress", "domain": { "type": "codedValue", "name": "DmG_RuralAddress", "codedValues": [ { "name": "Unknown", "code": 3 }, { "name": "Rural", "code": 1 }, { "name": "Urban", "code": 2 }, { "name": "Waterway", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "principaladdresstype", "type": "esriFieldTypeInteger", "alias": "principaladdresstype", "domain": { "type": "codedValue", "name": "DmG_PrincipalAddressType", "codedValues": [ { "name": "Primary", "code": 1 }, { "name": "Secondary", "code": 2 }, { "name": "Alternate", "code": 3 }, { "name": "Unknown", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "addressstringtype", "type": "esriFieldTypeInteger", "alias": "AddressStringType", "domain": null }, { "name": "principaladdresssiteoid", "type": "esriFieldTypeInteger", "alias": "principaladdresssiteoid", "domain": null }, { "name": "officialaddressstringoid", "type": "esriFieldTypeInteger", "alias": "officialaddressstringoid", "domain": null }, { "name": "roadside", "type": "esriFieldTypeInteger", "alias": "roadside", "domain": { "type": "codedValue", "name": "DmG_RoadSide", "codedValues": [ { "name": "Left", "code": 1 }, { "name": "Right", "code": 2 }, { "name": "Unknown", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "housenumberfirstprefix", "type": "esriFieldTypeString", "alias": "housenumberfirstprefix", "length": 1, "domain": null }, { "name": "housenumberfirst", "type": "esriFieldTypeInteger", "alias": "housenumberfirst", "domain": null }, { "name": "housenumberfirstsuffix", "type": "esriFieldTypeString", "alias": "housenumberfirstsuffix", "length": 2, "domain": null }, { "name": "housenumbersecondprefix", "type": "esriFieldTypeString", "alias": "housenumbersecondprefix", "length": 1, "domain": null }, { "name": "housenumbersecond", "type": "esriFieldTypeInteger", "alias": "housenumbersecond", "domain": null }, { "name": "housenumbersecondsuffix", "type": "esriFieldTypeString", "alias": "housenumbersecondsuffix", "length": 2, "domain": null }, { "name": "roadname", "type": "esriFieldTypeString", "alias": "roadname", "length": 50, "domain": null }, { "name": "roadtype", "type": "esriFieldTypeString", "alias": "roadtype", "length": 20, "domain": null }, { "name": "roadsuffix", "type": "esriFieldTypeString", "alias": "roadsuffix", "length": 15, "domain": null }, { "name": "unittype", "type": "esriFieldTypeString", "alias": "unittype", "length": 25, "domain": null }, { "name": "unitnumberprefix", "type": "esriFieldTypeString", "alias": "unitnumberprefix", "length": 2, "domain": null }, { "name": "unitnumber", "type": "esriFieldTypeInteger", "alias": "unitnumber", "domain": null }, { "name": "unitnumbersuffix", "type": "esriFieldTypeString", "alias": "unitnumbersuffix", "length": 2, "domain": null }, { "name": "leveltype", "type": "esriFieldTypeString", "alias": "leveltype", "length": 25, "domain": null }, { "name": "levelnumberprefix", "type": "esriFieldTypeString", "alias": "levelnumberprefix", "length": 1, "domain": null }, { "name": "levelnumber", "type": "esriFieldTypeString", "alias": "levelnumber", "length": 3, "domain": null }, { "name": "levelnumbersuffix", "type": "esriFieldTypeString", "alias": "levelnumbersuffix", "length": 2, "domain": null }, { "name": "addresssitename", "type": "esriFieldTypeString", "alias": "addresssitename", "length": 45, "domain": null }, { "name": "buildingname", "type": "esriFieldTypeString", "alias": "buildingname", "length": 45, "domain": null }, { "name": "locationdescription", "type": "esriFieldTypeString", "alias": "locationdescription", "length": 45, "domain": null }, { "name": "privatestreetname", "type": "esriFieldTypeString", "alias": "privatestreetname", "length": 30, "domain": null }, { "name": "privatestreettype", "type": "esriFieldTypeString", "alias": "privatestreettype", "length": 15, "domain": null }, { "name": "privatestreetsuffix", "type": "esriFieldTypeString", "alias": "privatestreetsuffix", "length": 15, "domain": null }, { "name": "secondroadname", "type": "esriFieldTypeString", "alias": "secondroadname", "length": 50, "domain": null }, { "name": "secondroadtype", "type": "esriFieldTypeString", "alias": "secondroadtype", "length": 20, "domain": null }, { "name": "secondroadsuffix", "type": "esriFieldTypeString", "alias": "secondroadsuffix", "length": 15, "domain": null }, { "name": "suburbname", "type": "esriFieldTypeString", "alias": "suburbname", "length": 50, "domain": null }, { "name": "state", "type": "esriFieldTypeInteger", "alias": "State", "domain": { "type": "codedValue", "name": "DmC_State", "codedValues": [ { "name": "Australian Capital Territory", "code": 1 }, { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "Queensland", "code": 4 }, { "name": "South Australia", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "postcode", "type": "esriFieldTypeInteger", "alias": "postcode", "domain": null }, { "name": "council", "type": "esriFieldTypeString", "alias": "council", "length": 50, "domain": null }, { "name": "deliverypointid", "type": "esriFieldTypeInteger", "alias": "deliverypointid", "domain": null }, { "name": "deliverypointbarcode", "type": "esriFieldTypeString", "alias": "deliverypointbarcode", "length": 50, "domain": null }, { "name": "addressconfidence", "type": "esriFieldTypeInteger", "alias": "addressconfidence", "domain": null }, { "name": "contributororigin", "type": "esriFieldTypeInteger", "alias": "contributororigin", "domain": { "type": "codedValue", "name": "DmG_ContributorOrigin", "codedValues": [ { "name": "Council", "code": 1 }, { "name": "VALNET", "code": 2 }, { "name": "GNAF", "code": 4 }, { "name": "GURAS", "code": 6 }, { "name": "Australia Post", "code": 10 }, { "name": "Guras App", "code": 11 }, { "name": "Complex Address", "code": 13 }, { "name": "RAAP", "code": 9 }, { "name": "Land and Housing Corporation", "code": 8 }, { "name": "NSW Point", "code": 12 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "contributorid", "type": "esriFieldTypeString", "alias": "contributorid", "length": 20, "domain": null }, { "name": "contributoralignment", "type": "esriFieldTypeInteger", "alias": "contributoralignment", "domain": null }, { "name": "routeoid", "type": "esriFieldTypeInteger", "alias": "routeoid", "domain": null }, { "name": "gnafprimarysiteid", "type": "esriFieldTypeInteger", "alias": "gnafprimarysiteid", "domain": null }, { "name": "containment", "type": "esriFieldTypeInteger", "alias": "containment", "domain": { "type": "codedValue", "name": "DmG_Containment", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 }, { "name": "Unknown", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "propid", "type": "esriFieldTypeInteger", "alias": "propid", "domain": null }, { "name": "sppropid", "type": "esriFieldTypeInteger", "alias": "sppropid", "domain": null } ], "indexes": [ { "name": "di159_council", "fields": "council", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_nametypesuff", "fields": "roadname,roadtype,roadsuffix", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_officialaddressstringoid", "fields": "officialaddressstringoid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_postcode", "fields": "postcode", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_principaladdresstype", "fields": "principaladdresstype", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_propid", "fields": "propid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_roadname", "fields": "roadname", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_routeoid", "fields": "routeoid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_sppropid", "fields": "sppropid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "di159_suburbname", "fields": "suburbname", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_159_principa", "fields": "principaladdresssiteoid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r354_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ui159_gurasid", "fields": "gurasid", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "gurasid": {"type": "inherited"}, "addresstype": {"type": "inherited"}, "ruraladdress": {"type": "inherited"}, "principaladdresstype": {"type": "inherited"}, "roadside": {"type": "inherited"}, "state": { "type": "codedValue", "name": "DmG_State", "codedValues": [ { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "South Australia", "code": 5 }, { "name": "Queeensland", "code": 4 }, { "name": "Australian Capital Territory", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "contributororigin": {"type": "inherited"}, "containment": {"type": "inherited"} }, "id": 1, "name": "Official" }, { "domains": { "gurasid": {"type": "inherited"}, "addresstype": {"type": "inherited"}, "ruraladdress": {"type": "inherited"}, "principaladdresstype": {"type": "inherited"}, "roadside": {"type": "inherited"}, "state": { "type": "codedValue", "name": "DmG_State", "codedValues": [ { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "South Australia", "code": 5 }, { "name": "Queeensland", "code": 4 }, { "name": "Australian Capital Territory", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "contributororigin": {"type": "inherited"}, "containment": {"type": "inherited"} }, "id": 2, "name": "Alias" }, { "domains": { "gurasid": {"type": "inherited"}, "addresstype": {"type": "inherited"}, "ruraladdress": {"type": "inherited"}, "principaladdresstype": {"type": "inherited"}, "roadside": {"type": "inherited"}, "state": { "type": "codedValue", "name": "DmG_State", "codedValues": [ { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "South Australia", "code": 5 }, { "name": "Queeensland", "code": 4 }, { "name": "Australian Capital Territory", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "contributororigin": {"type": "inherited"}, "containment": {"type": "inherited"} }, "id": 3, "name": "Assigned" }, { "domains": { "gurasid": {"type": "inherited"}, "addresstype": {"type": "inherited"}, "ruraladdress": {"type": "inherited"}, "principaladdresstype": {"type": "inherited"}, "roadside": {"type": "inherited"}, "state": { "type": "codedValue", "name": "DmG_State", "codedValues": [ { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "South Australia", "code": 5 }, { "name": "Queeensland", "code": 4 }, { "name": "Australian Capital Territory", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "contributororigin": {"type": "inherited"}, "containment": {"type": "inherited"} }, "id": 4, "name": "Verified" } ], "subtypes": [ { "domains": { "gurasid": {"type": "inherited"}, "addresstype": {"type": "inherited"}, "ruraladdress": {"type": "inherited"}, "principaladdresstype": {"type": "inherited"}, "roadside": {"type": "inherited"}, "state": { "type": "codedValue", "name": "DmG_State", "codedValues": [ { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "South Australia", "code": 5 }, { "name": "Queeensland", "code": 4 }, { "name": "Australian Capital Territory", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "contributororigin": {"type": "inherited"}, "containment": {"type": "inherited"} }, "defaultValues": { "createdate": null, "gurasid": null, "addresstype": null, "ruraladdress": null, "principaladdresstype": null, "addressstringtype": 1, "principaladdresssiteoid": null, "officialaddressstringoid": null, "roadside": null, "housenumberfirstprefix": null, "housenumberfirst": null, "housenumberfirstsuffix": null, "housenumbersecondprefix": null, "housenumbersecond": null, "housenumbersecondsuffix": null, "roadname": null, "roadtype": null, "roadsuffix": null, "unittype": null, "unitnumberprefix": null, "unitnumber": null, "unitnumbersuffix": null, "leveltype": null, "levelnumberprefix": null, "levelnumber": null, "levelnumbersuffix": null, "addresssitename": null, "buildingname": null, "locationdescription": null, "privatestreetname": null, "privatestreettype": null, "privatestreetsuffix": null, "secondroadname": null, "secondroadtype": null, "secondroadsuffix": null, "suburbname": null, "state": 2, "postcode": null, "council": null, "deliverypointid": null, "deliverypointbarcode": null, "addressconfidence": null, "contributororigin": null, "contributorid": null, "contributoralignment": null, "routeoid": null, "gnafprimarysiteid": null, "containment": null, "propid": null, "sppropid": null }, "code": 1, "name": "Official" }, { "domains": { "gurasid": {"type": "inherited"}, "addresstype": {"type": "inherited"}, "ruraladdress": {"type": "inherited"}, "principaladdresstype": {"type": "inherited"}, "roadside": {"type": "inherited"}, "state": { "type": "codedValue", "name": "DmG_State", "codedValues": [ { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "South Australia", "code": 5 }, { "name": "Queeensland", "code": 4 }, { "name": "Australian Capital Territory", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "contributororigin": {"type": "inherited"}, "containment": {"type": "inherited"} }, "defaultValues": { "createdate": null, "gurasid": null, "addresstype": null, "ruraladdress": null, "principaladdresstype": null, "addressstringtype": 2, "principaladdresssiteoid": null, "officialaddressstringoid": null, "roadside": null, "housenumberfirstprefix": null, "housenumberfirst": null, "housenumberfirstsuffix": null, "housenumbersecondprefix": null, "housenumbersecond": null, "housenumbersecondsuffix": null, "roadname": null, "roadtype": null, "roadsuffix": null, "unittype": null, "unitnumberprefix": null, "unitnumber": null, "unitnumbersuffix": null, "leveltype": null, "levelnumberprefix": null, "levelnumber": null, "levelnumbersuffix": null, "addresssitename": null, "buildingname": null, "locationdescription": null, "privatestreetname": null, "privatestreettype": null, "privatestreetsuffix": null, "secondroadname": null, "secondroadtype": null, "secondroadsuffix": null, "suburbname": null, "state": 2, "postcode": null, "council": null, "deliverypointid": null, "deliverypointbarcode": null, "addressconfidence": null, "contributororigin": null, "contributorid": null, "contributoralignment": null, "routeoid": null, "gnafprimarysiteid": null, "containment": null, "propid": null, "sppropid": null }, "code": 2, "name": "Alias" }, { "domains": { "gurasid": {"type": "inherited"}, "addresstype": {"type": "inherited"}, "ruraladdress": {"type": "inherited"}, "principaladdresstype": {"type": "inherited"}, "roadside": {"type": "inherited"}, "state": { "type": "codedValue", "name": "DmG_State", "codedValues": [ { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "South Australia", "code": 5 }, { "name": "Queeensland", "code": 4 }, { "name": "Australian Capital Territory", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "contributororigin": {"type": "inherited"}, "containment": {"type": "inherited"} }, "defaultValues": { "createdate": null, "gurasid": null, "addresstype": null, "ruraladdress": null, "principaladdresstype": null, "addressstringtype": 3, "principaladdresssiteoid": null, "officialaddressstringoid": null, "roadside": null, "housenumberfirstprefix": null, "housenumberfirst": null, "housenumberfirstsuffix": null, "housenumbersecondprefix": null, "housenumbersecond": null, "housenumbersecondsuffix": null, "roadname": null, "roadtype": null, "roadsuffix": null, "unittype": null, "unitnumberprefix": null, "unitnumber": null, "unitnumbersuffix": null, "leveltype": null, "levelnumberprefix": null, "levelnumber": null, "levelnumbersuffix": null, "addresssitename": null, "buildingname": null, "locationdescription": null, "privatestreetname": null, "privatestreettype": null, "privatestreetsuffix": null, "secondroadname": null, "secondroadtype": null, "secondroadsuffix": null, "suburbname": null, "state": 2, "postcode": null, "council": null, "deliverypointid": null, "deliverypointbarcode": null, "addressconfidence": null, "contributororigin": null, "contributorid": null, "contributoralignment": null, "routeoid": null, "gnafprimarysiteid": null, "containment": null, "propid": null, "sppropid": null }, "code": 3, "name": "Assigned" }, { "domains": { "gurasid": {"type": "inherited"}, "addresstype": {"type": "inherited"}, "ruraladdress": {"type": "inherited"}, "principaladdresstype": {"type": "inherited"}, "roadside": {"type": "inherited"}, "state": { "type": "codedValue", "name": "DmG_State", "codedValues": [ { "name": "New South Wales", "code": 2 }, { "name": "Victoria", "code": 3 }, { "name": "South Australia", "code": 5 }, { "name": "Queeensland", "code": 4 }, { "name": "Australian Capital Territory", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "contributororigin": {"type": "inherited"}, "containment": {"type": "inherited"} }, "defaultValues": { "createdate": null, "gurasid": null, "addresstype": null, "ruraladdress": null, "principaladdresstype": null, "addressstringtype": 4, "principaladdresssiteoid": null, "officialaddressstringoid": null, "roadside": null, "housenumberfirstprefix": null, "housenumberfirst": null, "housenumberfirstsuffix": null, "housenumbersecondprefix": null, "housenumbersecond": null, "housenumbersecondsuffix": null, "roadname": null, "roadtype": null, "roadsuffix": null, "unittype": null, "unitnumberprefix": null, "unitnumber": null, "unitnumbersuffix": null, "leveltype": null, "levelnumberprefix": null, "levelnumber": null, "levelnumbersuffix": null, "addresssitename": null, "buildingname": null, "locationdescription": null, "privatestreetname": null, "privatestreettype": null, "privatestreetsuffix": null, "secondroadname": null, "secondroadtype": null, "secondroadsuffix": null, "suburbname": null, "state": 2, "postcode": null, "council": null, "deliverypointid": null, "deliverypointbarcode": null, "addressconfidence": null, "contributororigin": null, "contributorid": null, "contributoralignment": null, "routeoid": null, "gnafprimarysiteid": null, "containment": null, "propid": null, "sppropid": null }, "code": 4, "name": "Verified" } ], "relationships": [ { "id": 1, "name": "AddressPoint", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }