{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "DuplicateAddressPoint", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "gurasid_1": null, "addressconfidence": null, "unitnumbersuffix": null, "createdate": null, "roadtype": null, "roadsuffix": null, "addresspointuncertainty": null, "gnafprimarysiteid": null, "unitnumberprefix": null, "addresssitename": null, "housenumbersecond": null, "state": 2, "levelnumber": null, "secondroadtype": null, "sppropid": null, "roadside": null, "unittype": null, "propid": null, "postcode": null, "gurasid": 0, "principaladdresssiteoid_1": null, "unitnumber": null, "secondroadsuffix": null, "routeoid": null, "council": null, "privatestreetname": null, "principaladdresssiteoid": null, "principaladdresstype": null, "addresspointtype": 1, "buildingname": null, "contributorid": null, "housenumbersecondsuffix": null, "officialaddressstringoid": null, "containment": null, "deliverypointbarcode": null, "secondroadname": null, "contributororigin": null, "addresstype": null, "addressstringoid": null, "containment_1": null, "createdate_1": null, "ruraladdress": null, "suburbname": null, "addressstringtype": 1, "leveltype": null, "housenumberfirst": null, "objectid_1": null, "privatestreettype": null, "privatestreetsuffix": null, "locationdescription": null, "levelnumbersuffix": null, "deliverypointid": null, "housenumbersecondprefix": null, "housenumberfirstsuffix": null, "levelnumberprefix": null, "housenumberfirstprefix": null, "roadname": null, "contributoralignment": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "DuplicateAddressPoint", "displayField": "roadname", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "createdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createdate", "length": 29, "alias": "createdate", "type": "esriFieldTypeDate" }, { "modelName": "gurasid", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "gurasid", "alias": "gurasid", "type": "esriFieldTypeInteger" }, { "modelName": "principaladdresssiteoid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "principaladdresssiteoid", "alias": "principaladdresssiteoid", "type": "esriFieldTypeInteger" }, { "modelName": "addressstringoid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addressstringoid", "alias": "addressstringoid", "type": "esriFieldTypeInteger" }, { "modelName": "AddressPointType", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "addresspointtype", "alias": "AddressPointType", "type": "esriFieldTypeInteger" }, { "modelName": "addresspointuncertainty", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addresspointuncertainty", "alias": "addresspointuncertainty", "type": "esriFieldTypeDouble" }, { "modelName": "containment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "containment", "alias": "containment", "type": "esriFieldTypeInteger" }, { "modelName": "OBJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid_1", "alias": "OBJECTID", "type": "esriFieldTypeInteger" }, { "modelName": "createdate_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createdate_1", "length": 29, "alias": "createdate_1", "type": "esriFieldTypeDate" }, { "modelName": "gurasid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gurasid_1", "alias": "gurasid", "type": "esriFieldTypeInteger" }, { "modelName": "addresstype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addresstype", "alias": "addresstype", "type": "esriFieldTypeInteger" }, { "modelName": "ruraladdress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ruraladdress", "alias": "ruraladdress", "type": "esriFieldTypeInteger" }, { "modelName": "principaladdresstype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "principaladdresstype", "alias": "principaladdresstype", "type": "esriFieldTypeInteger" }, { "modelName": "AddressStringType", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "addressstringtype", "alias": "AddressStringType", "type": "esriFieldTypeInteger" }, { "modelName": "principaladdresssiteoid_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "principaladdresssiteoid_1", "alias": "principaladdresssiteoid_1", "type": "esriFieldTypeInteger" }, { "modelName": "officialaddressstringoid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "officialaddressstringoid", "alias": "officialaddressstringoid", "type": "esriFieldTypeInteger" }, { "modelName": "roadside", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadside", "alias": "roadside", "type": "esriFieldTypeInteger" }, { "modelName": "housenumberfirstprefix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "housenumberfirstprefix", "length": 1, "alias": "housenumberfirstprefix", "type": "esriFieldTypeString" }, { "modelName": "housenumberfirst", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "housenumberfirst", "alias": "housenumberfirst", "type": "esriFieldTypeInteger" }, { "modelName": "housenumberfirstsuffix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "housenumberfirstsuffix", "length": 2, "alias": "housenumberfirstsuffix", "type": "esriFieldTypeString" }, { "modelName": "housenumbersecondprefix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "housenumbersecondprefix", "length": 1, "alias": "housenumbersecondprefix", "type": "esriFieldTypeString" }, { "modelName": "housenumbersecond", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "housenumbersecond", "alias": "housenumbersecond", "type": "esriFieldTypeInteger" }, { "modelName": "housenumbersecondsuffix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "housenumbersecondsuffix", "length": 2, "alias": "housenumbersecondsuffix", "type": "esriFieldTypeString" }, { "modelName": "roadname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadname", "length": 50, "alias": "roadname", "type": "esriFieldTypeString" }, { "modelName": "roadtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadtype", "length": 20, "alias": "roadtype", "type": "esriFieldTypeString" }, { "modelName": "roadsuffix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadsuffix", "length": 15, "alias": "roadsuffix", "type": "esriFieldTypeString" }, { "modelName": "unittype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unittype", "length": 25, "alias": "unittype", "type": "esriFieldTypeString" }, { "modelName": "unitnumberprefix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitnumberprefix", "length": 2, "alias": "unitnumberprefix", "type": "esriFieldTypeString" }, { "modelName": "unitnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitnumber", "alias": "unitnumber", "type": "esriFieldTypeInteger" }, { "modelName": "unitnumbersuffix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitnumbersuffix", "length": 2, "alias": "unitnumbersuffix", "type": "esriFieldTypeString" }, { "modelName": "leveltype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "leveltype", "length": 25, "alias": "leveltype", "type": "esriFieldTypeString" }, { "modelName": "levelnumberprefix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "levelnumberprefix", "length": 1, "alias": "levelnumberprefix", "type": "esriFieldTypeString" }, { "modelName": "levelnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "levelnumber", "length": 3, "alias": "levelnumber", "type": "esriFieldTypeString" }, { "modelName": "levelnumbersuffix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "levelnumbersuffix", "length": 2, "alias": "levelnumbersuffix", "type": "esriFieldTypeString" }, { "modelName": "addresssitename", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addresssitename", "length": 45, "alias": "addresssitename", "type": "esriFieldTypeString" }, { "modelName": "buildingname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "buildingname", "length": 45, "alias": "buildingname", "type": "esriFieldTypeString" }, { "modelName": "locationdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locationdescription", "length": 45, "alias": "locationdescription", "type": "esriFieldTypeString" }, { "modelName": "privatestreetname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "privatestreetname", "length": 30, "alias": "privatestreetname", "type": "esriFieldTypeString" }, { "modelName": "privatestreettype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "privatestreettype", "length": 15, "alias": "privatestreettype", "type": "esriFieldTypeString" }, { "modelName": "privatestreetsuffix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "privatestreetsuffix", "length": 15, "alias": "privatestreetsuffix", "type": "esriFieldTypeString" }, { "modelName": "secondroadname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "secondroadname", "length": 50, "alias": "secondroadname", "type": "esriFieldTypeString" }, { "modelName": "secondroadtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "secondroadtype", "length": 20, "alias": "secondroadtype", "type": "esriFieldTypeString" }, { "modelName": "secondroadsuffix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "secondroadsuffix", "length": 15, "alias": "secondroadsuffix", "type": "esriFieldTypeString" }, { "modelName": "suburbname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "suburbname", "length": 50, "alias": "suburbname", "type": "esriFieldTypeString" }, { "modelName": "State", "nullable": true, "editable": true, "defaultValue": 2, "domain": null, "name": "state", "alias": "State", "type": "esriFieldTypeInteger" }, { "modelName": "postcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "postcode", "alias": "postcode", "type": "esriFieldTypeInteger" }, { "modelName": "council", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "council", "length": 50, "alias": "council", "type": "esriFieldTypeString" }, { "modelName": "deliverypointid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deliverypointid", "alias": "deliverypointid", "type": "esriFieldTypeInteger" }, { "modelName": "deliverypointbarcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deliverypointbarcode", "length": 50, "alias": "deliverypointbarcode", "type": "esriFieldTypeString" }, { "modelName": "addressconfidence", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addressconfidence", "alias": "addressconfidence", "type": "esriFieldTypeInteger" }, { "modelName": "contributororigin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contributororigin", "alias": "contributororigin", "type": "esriFieldTypeInteger" }, { "modelName": "contributorid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contributorid", "length": 20, "alias": "contributorid", "type": "esriFieldTypeString" }, { "modelName": "contributoralignment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contributoralignment", "alias": "contributoralignment", "type": "esriFieldTypeInteger" }, { "modelName": "routeoid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "routeoid", "alias": "routeoid", "type": "esriFieldTypeInteger" }, { "modelName": "gnafprimarysiteid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gnafprimarysiteid", "alias": "gnafprimarysiteid", "type": "esriFieldTypeInteger" }, { "modelName": "containment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "containment_1", "alias": "containment", "type": "esriFieldTypeInteger" }, { "modelName": "propid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "propid", "alias": "propid", "type": "esriFieldTypeInteger" }, { "modelName": "sppropid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sppropid", "alias": "sppropid", "type": "esriFieldTypeInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r1138_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fbeb7b25affb4fe8a7ab74d20226d257", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }