View In:   ArcGIS Online Map Viewer

Name: Address Points

Display Field: HOUSENUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 200000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 2000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 553489.183601201
YMin: 1306481.37716183
XMax: 719911.482380219
YMax: 1428845.51679579
Spatial Reference: 102659  (2237)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 0]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: Pink text
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• ADDRESSID ( type: esriFieldTypeInteger , alias: ADDRESSID , editable: true , nullable: true )
• MSLINK ( type: esriFieldTypeInteger , alias: MSLINK , editable: true , nullable: true )
• VALIDSTREETIDFK ( type: esriFieldTypeInteger , alias: VALIDSTREETIDFK , editable: true , nullable: true )
• HOUSENUMBER ( type: esriFieldTypeInteger , alias: HOUSENUMBER , editable: true , nullable: true )
• FRACTIONALHOUSENUMBER ( type: esriFieldTypeString , alias: FRACTIONALHOUSENUMBER , editable: true , nullable: true , length: 16 )
• FRACTIONALHOUSEID ( type: esriFieldTypeInteger , alias: FRACTIONALHOUSEID , editable: true , nullable: true )
• APARTMENTNUMBER ( type: esriFieldTypeString , alias: APARTMENTNUMBER , editable: true , nullable: true , length: 16 )
• LASTUPDATEDATE ( type: esriFieldTypeDate , alias: LASTUPDATEDATE , editable: true , nullable: true , length: 8 )
• LASTUPDATEUSER ( type: esriFieldTypeString , alias: LASTUPDATEUSER , editable: true , nullable: true , length: 255 )
• SECONDARYSTREETNAME ( type: esriFieldTypeString , alias: SECONDARYSTREETNAME , editable: true , nullable: true , length: 50 )
• HOUSENUMBERLITERAL ( type: esriFieldTypeString , alias: HOUSENUMBERLITERAL , editable: true , nullable: true , length: 10 )
• HOUSENUMBERNUMERICISED ( type: esriFieldTypeString , alias: HOUSENUMBERNUMERICISED , editable: true , nullable: true , length: 10 )
• PROPERTYID ( type: esriFieldTypeDouble , alias: PROPERTYID , editable: true , nullable: true )
• XCOORD ( type: esriFieldTypeDouble , alias: XCOORD , editable: true , nullable: true )
• YCOORD ( type: esriFieldTypeDouble , alias: YCOORD , editable: true , nullable: true )
• ADDRESSSTATUS ( type: esriFieldTypeString , alias: ADDRESSSTATUS , editable: true , nullable: true , length: 255 , Coded Values: [ACTIVE: Active] , [HISTORY: History] , [UNUSED: Unused] )
• ADDRESSTYPE ( type: esriFieldTypeString , alias: ADDRESSTYPE , editable: true , nullable: true , length: 255 , Coded Values: [LOCATION: Location] , [ACCOUNT: Account] )
• STREETNAME ( type: esriFieldTypeString , alias: STREETNAME , editable: true , nullable: true , length: 64 )
• HOUSENUMBER_TEXT ( type: esriFieldTypeString , alias: HOUSENUMBER_TEXT , editable: true , nullable: true , length: 16 )
• MS_COLOR ( type: esriFieldTypeSmallInteger , alias: MS_COLOR , editable: true , nullable: true )
• PREFIX ( type: esriFieldTypeString , alias: PREFIX , editable: true , nullable: true , length: 5 )
• TYPE ( type: esriFieldTypeString , alias: TYPE , editable: true , nullable: true , length: 5 )
• SUFFIX ( type: esriFieldTypeString , alias: SUFFIX , editable: true , nullable: true , length: 5 )
• FULLADDRESS ( type: esriFieldTypeString , alias: FULLADDRESS , editable: true , nullable: true , length: 64 )
• SYMBOLROTATION ( type: esriFieldTypeDouble , alias: SYMBOLROTATION , editable: true , nullable: true )
• CQ ( type: esriFieldTypeString , alias: CQ , editable: true , nullable: true , length: 8 )
• GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , editable: false , nullable: false , length: 38 )
• ALIADDRESS ( type: esriFieldTypeString , alias: ALIADDRESS , editable: true , nullable: true , length: 100 )
• UNIT ( type: esriFieldTypeString , alias: UNIT , editable: true , nullable: true , length: 40 )
• CITY_OVR ( type: esriFieldTypeString , alias: CITY_OVR , editable: true , nullable: true , length: 3 )
• BLG ( type: esriFieldTypeString , alias: BLG , editable: true , nullable: true , length: 3 )
• APT ( type: esriFieldTypeString , alias: APT , editable: true , nullable: true , length: 3 )
• SIGN ( type: esriFieldTypeString , alias: SIGN , editable: true , nullable: true , length: 1 )
• PMOD ( type: esriFieldTypeString , alias: PMOD , editable: true , nullable: true , length: 10 )
• FEMOD ( type: esriFieldTypeString , alias: FEMOD , editable: true , nullable: true , length: 10 )
• P_OVERRIDE ( type: esriFieldTypeString , alias: P_OVERRIDE , editable: true , nullable: true , length: 10 )
• FE_OVERRIDE ( type: esriFieldTypeString , alias: FE_OVERRIDE , editable: true , nullable: true , length: 10 )
• MAILINGCIT ( type: esriFieldTypeString , alias: MAILINGCIT , editable: true , nullable: true , length: 85 )
• ESN_CITY_N ( type: esriFieldTypeString , alias: ESN_CITY_N , editable: true , nullable: true , length: 85 )
• CITYCODE ( type: esriFieldTypeString , alias: CITYCODE , editable: true , nullable: true , length: 5 )
• TMAILINGC ( type: esriFieldTypeString , alias: TMAILINGC , editable: true , nullable: true , length: 85 )
• COL_HOUSENUM ( type: esriFieldTypeInteger , alias: COL_HOUSENUM , editable: true , nullable: true )
• COL_FRACTIONAL ( type: esriFieldTypeString , alias: COL_FRACTIONAL , editable: true , nullable: true , length: 16 )
• COL_PREFIX ( type: esriFieldTypeString , alias: COL_PREFIX , editable: true , nullable: true , length: 5 )
• COL_STREETNAME ( type: esriFieldTypeString , alias: COL_STREETNAME , editable: true , nullable: true , length: 64 )
• COL_TYPE ( type: esriFieldTypeString , alias: COL_TYPE , editable: true , nullable: true , length: 5 )
• COL_SUFFIX ( type: esriFieldTypeString , alias: COL_SUFFIX , editable: true , nullable: true , length: 5 )
• COL_APT ( type: esriFieldTypeString , alias: COL_APT , editable: true , nullable: true , length: 16 )
• COL_FULLADDRESS ( type: esriFieldTypeString , alias: COL_FULLADDRESS , editable: true , nullable: true , length: 85 )
• COL_CQ ( type: esriFieldTypeString , alias: COL_CQ , editable: true , nullable: true , length: 8 )
• ZIP ( type: esriFieldTypeString , alias: ZIP , editable: true , nullable: true , length: 5 )
• COL_UMSLOCATIONNO ( type: esriFieldTypeInteger , alias: COL_UMSLOCATIONNO , editable: true , nullable: true )
• ID ( type: esriFieldTypeInteger , alias: ID , editable: true , nullable: true )
• LUC_LINK ( type: esriFieldTypeInteger , alias: LUC_LINK , editable: true , nullable: true )
• REPLACEDADDRESSID ( type: esriFieldTypeInteger , alias: REPLACEDADDRESSID , editable: true , nullable: true )
• MULTIADDRESSREPLACE ( type: esriFieldTypeString , alias: MULTIADDRESSREPLACE , editable: true , nullable: true , length: 254 )
• ADDRESSPTID ( type: esriFieldTypeString , alias: ADDRESS_ID , editable: true , nullable: true , length: 20 )

Templates:

• Name: Address Points
  Description:
  Prototype:
  MULTIADDRESSREPLACE: null
  ADDRESSPTID: null
  ADDRESSID: null
  MSLINK: null
  VALIDSTREETIDFK: null
  HOUSENUMBER: null
  FRACTIONALHOUSENUMBER: null
  FRACTIONALHOUSEID: null
  APARTMENTNUMBER: null
  LASTUPDATEDATE: null
  LASTUPDATEUSER: null
  SECONDARYSTREETNAME: null
  HOUSENUMBERLITERAL: null
  HOUSENUMBERNUMERICISED: null
  PROPERTYID: null
  XCOORD: null
  YCOORD: null
  ADDRESSSTATUS: null
  ADDRESSTYPE: null
  STREETNAME: null
  HOUSENUMBER_TEXT: null
  MS_COLOR: null
  PREFIX: null
  TYPE: null
  SUFFIX: null
  FULLADDRESS: null
  SYMBOLROTATION: null
  CQ: null
  REPLACEDADDRESSID: null
  ALIADDRESS: null
  UNIT: null
  CITY_OVR: null
  BLG: null
  APT: null
  SIGN: null
  PMOD: null
  FEMOD: null
  P_OVERRIDE: null
  FE_OVERRIDE: null
  MAILINGCIT: null
  ESN_CITY_N: null
  CITYCODE: null
  TMAILINGC: null
  COL_HOUSENUM: null
  COL_FRACTIONAL: null
  COL_PREFIX: null
  COL_STREETNAME: null
  COL_TYPE: null
  COL_SUFFIX: null
  COL_APT: null
  COL_FULLADDRESS: null
  COL_CQ: null
  ZIP: null
  COL_UMSLOCATIONNO: null
  ID: null
  LUC_LINK: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata