{ "currentVersion": 10.91, "id": 9, "name": "GURAS_DELIVERY.sde.ADDRESSSTRING_V", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ROADNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "length": 8, "domain": null }, { "name": "GURASID", "type": "esriFieldTypeInteger", "alias": "GURASID", "domain": null }, { "name": "ADDRESSTYPE", "type": "esriFieldTypeInteger", "alias": "ADDRESSTYPE", "domain": null }, { "name": "RURALADDRESS", "type": "esriFieldTypeInteger", "alias": "RURALADDRESS", "domain": null }, { "name": "PRINCIPALADDRESSTYPE", "type": "esriFieldTypeInteger", "alias": "PRINCIPALADDRESSTYPE", "domain": null }, { "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": null }, { "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": "ROAD", "type": "esriFieldTypeString", "alias": "ROAD", "length": 71, "domain": null }, { "name": "ROADSUBURB", "type": "esriFieldTypeString", "alias": "ROADSUBURB", "length": 122, "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": null }, { "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": null }, { "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": null }, { "name": "PROPID", "type": "esriFieldTypeInteger", "alias": "PROPID", "domain": null }, { "name": "SPPROPID", "type": "esriFieldTypeInteger", "alias": "SPPROPID", "domain": null }, { "name": "STARTDATE", "type": "esriFieldTypeDate", "alias": "STARTDATE", "length": 8, "domain": null }, { "name": "ENDDATE", "type": "esriFieldTypeDate", "alias": "ENDDATE", "length": 8, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "LASTUPDATE", "length": 8, "domain": null }, { "name": "packetid", "type": "esriFieldTypeDouble", "alias": "packetid", "domain": null }, { "name": "isprocessed", "type": "esriFieldTypeString", "alias": "isprocessed", "length": 1, "domain": null }, { "name": "recordstatus", "type": "esriFieldTypeString", "alias": "recordstatus", "length": 32, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }