Name: DuplicateAddressPoint

Display Field: roadname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fbeb7b25affb4fe8a7ab74d20226d257

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( modelName: OBJECTID, nullable: false, defaultValue: null, editable: false, alias: OBJECTID, type: esriFieldTypeOID )
• createdate ( modelName: createdate, nullable: true, editable: true, defaultValue: null, length: 29, alias: createdate, type: esriFieldTypeDate )
• gurasid ( modelName: gurasid, nullable: false, editable: true, defaultValue: null, alias: gurasid, type: esriFieldTypeInteger )
• principaladdresssiteoid ( modelName: principaladdresssiteoid, nullable: true, editable: true, defaultValue: null, alias: principaladdresssiteoid, type: esriFieldTypeInteger )
• addressstringoid ( modelName: addressstringoid, nullable: true, editable: true, defaultValue: null, alias: addressstringoid, type: esriFieldTypeInteger )
• addresspointtype ( modelName: AddressPointType, nullable: true, editable: true, defaultValue: 1, alias: AddressPointType, type: esriFieldTypeInteger )
• addresspointuncertainty ( modelName: addresspointuncertainty, nullable: true, editable: true, defaultValue: null, alias: addresspointuncertainty, type: esriFieldTypeDouble )
• containment ( modelName: containment, nullable: true, editable: true, defaultValue: null, alias: containment, type: esriFieldTypeInteger )
• objectid_1 ( modelName: OBJECTID, nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• createdate_1 ( modelName: createdate_1, nullable: true, editable: true, defaultValue: null, length: 29, alias: createdate_1, type: esriFieldTypeDate )
• gurasid_1 ( modelName: gurasid, nullable: true, editable: true, defaultValue: null, alias: gurasid, type: esriFieldTypeInteger )
• addresstype ( modelName: addresstype, nullable: true, editable: true, defaultValue: null, alias: addresstype, type: esriFieldTypeInteger )
• ruraladdress ( modelName: ruraladdress, nullable: true, editable: true, defaultValue: null, alias: ruraladdress, type: esriFieldTypeInteger )
• principaladdresstype ( modelName: principaladdresstype, nullable: true, editable: true, defaultValue: null, alias: principaladdresstype, type: esriFieldTypeInteger )
• addressstringtype ( modelName: AddressStringType, nullable: true, editable: true, defaultValue: 1, alias: AddressStringType, type: esriFieldTypeInteger )
• principaladdresssiteoid_1 ( modelName: principaladdresssiteoid_1, nullable: true, editable: true, defaultValue: null, alias: principaladdresssiteoid_1, type: esriFieldTypeInteger )
• officialaddressstringoid ( modelName: officialaddressstringoid, nullable: true, editable: true, defaultValue: null, alias: officialaddressstringoid, type: esriFieldTypeInteger )
• roadside ( modelName: roadside, nullable: true, editable: true, defaultValue: null, alias: roadside, type: esriFieldTypeInteger )
• housenumberfirstprefix ( modelName: housenumberfirstprefix, nullable: true, editable: true, defaultValue: null, length: 1, alias: housenumberfirstprefix, type: esriFieldTypeString )
• housenumberfirst ( modelName: housenumberfirst, nullable: true, editable: true, defaultValue: null, alias: housenumberfirst, type: esriFieldTypeInteger )
• housenumberfirstsuffix ( modelName: housenumberfirstsuffix, nullable: true, editable: true, defaultValue: null, length: 2, alias: housenumberfirstsuffix, type: esriFieldTypeString )
• housenumbersecondprefix ( modelName: housenumbersecondprefix, nullable: true, editable: true, defaultValue: null, length: 1, alias: housenumbersecondprefix, type: esriFieldTypeString )
• housenumbersecond ( modelName: housenumbersecond, nullable: true, editable: true, defaultValue: null, alias: housenumbersecond, type: esriFieldTypeInteger )
• housenumbersecondsuffix ( modelName: housenumbersecondsuffix, nullable: true, editable: true, defaultValue: null, length: 2, alias: housenumbersecondsuffix, type: esriFieldTypeString )
• roadname ( modelName: roadname, nullable: true, editable: true, defaultValue: null, length: 50, alias: roadname, type: esriFieldTypeString )
• roadtype ( modelName: roadtype, nullable: true, editable: true, defaultValue: null, length: 20, alias: roadtype, type: esriFieldTypeString )
• roadsuffix ( modelName: roadsuffix, nullable: true, editable: true, defaultValue: null, length: 15, alias: roadsuffix, type: esriFieldTypeString )
• unittype ( modelName: unittype, nullable: true, editable: true, defaultValue: null, length: 25, alias: unittype, type: esriFieldTypeString )
• unitnumberprefix ( modelName: unitnumberprefix, nullable: true, editable: true, defaultValue: null, length: 2, alias: unitnumberprefix, type: esriFieldTypeString )
• unitnumber ( modelName: unitnumber, nullable: true, editable: true, defaultValue: null, alias: unitnumber, type: esriFieldTypeInteger )
• unitnumbersuffix ( modelName: unitnumbersuffix, nullable: true, editable: true, defaultValue: null, length: 2, alias: unitnumbersuffix, type: esriFieldTypeString )
• leveltype ( modelName: leveltype, nullable: true, editable: true, defaultValue: null, length: 25, alias: leveltype, type: esriFieldTypeString )
• levelnumberprefix ( modelName: levelnumberprefix, nullable: true, editable: true, defaultValue: null, length: 1, alias: levelnumberprefix, type: esriFieldTypeString )
• levelnumber ( modelName: levelnumber, nullable: true, editable: true, defaultValue: null, length: 3, alias: levelnumber, type: esriFieldTypeString )
• levelnumbersuffix ( modelName: levelnumbersuffix, nullable: true, editable: true, defaultValue: null, length: 2, alias: levelnumbersuffix, type: esriFieldTypeString )
• addresssitename ( modelName: addresssitename, nullable: true, editable: true, defaultValue: null, length: 45, alias: addresssitename, type: esriFieldTypeString )
• buildingname ( modelName: buildingname, nullable: true, editable: true, defaultValue: null, length: 45, alias: buildingname, type: esriFieldTypeString )
• locationdescription ( modelName: locationdescription, nullable: true, editable: true, defaultValue: null, length: 45, alias: locationdescription, type: esriFieldTypeString )
• privatestreetname ( modelName: privatestreetname, nullable: true, editable: true, defaultValue: null, length: 30, alias: privatestreetname, type: esriFieldTypeString )
• privatestreettype ( modelName: privatestreettype, nullable: true, editable: true, defaultValue: null, length: 15, alias: privatestreettype, type: esriFieldTypeString )
• privatestreetsuffix ( modelName: privatestreetsuffix, nullable: true, editable: true, defaultValue: null, length: 15, alias: privatestreetsuffix, type: esriFieldTypeString )
• secondroadname ( modelName: secondroadname, nullable: true, editable: true, defaultValue: null, length: 50, alias: secondroadname, type: esriFieldTypeString )
• secondroadtype ( modelName: secondroadtype, nullable: true, editable: true, defaultValue: null, length: 20, alias: secondroadtype, type: esriFieldTypeString )
• secondroadsuffix ( modelName: secondroadsuffix, nullable: true, editable: true, defaultValue: null, length: 15, alias: secondroadsuffix, type: esriFieldTypeString )
• suburbname ( modelName: suburbname, nullable: true, editable: true, defaultValue: null, length: 50, alias: suburbname, type: esriFieldTypeString )
• state ( modelName: State, nullable: true, editable: true, defaultValue: 2, alias: State, type: esriFieldTypeInteger )
• postcode ( modelName: postcode, nullable: true, editable: true, defaultValue: null, alias: postcode, type: esriFieldTypeInteger )
• council ( modelName: council, nullable: true, editable: true, defaultValue: null, length: 50, alias: council, type: esriFieldTypeString )
• deliverypointid ( modelName: deliverypointid, nullable: true, editable: true, defaultValue: null, alias: deliverypointid, type: esriFieldTypeInteger )
• deliverypointbarcode ( modelName: deliverypointbarcode, nullable: true, editable: true, defaultValue: null, length: 50, alias: deliverypointbarcode, type: esriFieldTypeString )
• addressconfidence ( modelName: addressconfidence, nullable: true, editable: true, defaultValue: null, alias: addressconfidence, type: esriFieldTypeInteger )
• contributororigin ( modelName: contributororigin, nullable: true, editable: true, defaultValue: null, alias: contributororigin, type: esriFieldTypeInteger )
• contributorid ( modelName: contributorid, nullable: true, editable: true, defaultValue: null, length: 20, alias: contributorid, type: esriFieldTypeString )
• contributoralignment ( modelName: contributoralignment, nullable: true, editable: true, defaultValue: null, alias: contributoralignment, type: esriFieldTypeInteger )
• routeoid ( modelName: routeoid, nullable: true, editable: true, defaultValue: null, alias: routeoid, type: esriFieldTypeInteger )
• gnafprimarysiteid ( modelName: gnafprimarysiteid, nullable: true, editable: true, defaultValue: null, alias: gnafprimarysiteid, type: esriFieldTypeInteger )
• containment_1 ( modelName: containment, nullable: true, editable: true, defaultValue: null, alias: containment, type: esriFieldTypeInteger )
• propid ( modelName: propid, nullable: true, editable: true, defaultValue: null, alias: propid, type: esriFieldTypeInteger )
• sppropid ( modelName: sppropid, nullable: true, editable: true, defaultValue: null, alias: sppropid, type: esriFieldTypeInteger )

Templates:

• Name: DuplicateAddressPoint
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata