View In:   ArcGIS Online Map Viewer

Name: Address Point

Display Field: HOUSENUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3cb904c4d21e473f992f7b7d35d94a45

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2500.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

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

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ADDRESSSTATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [255, 0, 197, 0]
Size: 1.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[230, 0, 169, 0] Width: 0
Default Label: Other (Pink Text)
UniqueValueInfos:
• Value: HISTORY
  Label: Historical (Blue Text)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 197, 255, 0]
  Size: 1.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 0
• Value: ACTIVE
  Label: Active/Unused (Pink Text)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 197, 0]
  Size: 1.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 0
• Value: UNUSED
  Label: Active/Unused (Pink Text)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 197, 0]
  Size: 1.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 169, 230, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 6
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: NaN
Max. Scale: NaN
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 169, 230, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 6
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: NaN
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [230, 0, 169, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 299.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [230, 0, 169, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 299.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [230, 0, 169, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 2500.0
Max. Scale: 300.0
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [230, 0, 169, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 9
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 2500.0
Max. Scale: 300.0

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
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: ADDRESSSTATUS

Fields:

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

Types:

ID: HISTORY
Name: Historical (Blue Text)
Domains:
• ADDRESSSTATUS:
  Inherited
• ADDRESSTYPE:
  Inherited
Templates:
• Name: Historical (Blue Text)
  Description:
  Prototype:
  YCOORD: null
  MULTIADDRESSREPLACE: 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
  ADDRESSSTATUS: HISTORY
  ADDRESSTYPE: null
  STREETNAME: null
  HOUSENUMBER_TEXT: null
  MS_COLOR: null
  PREFIX: null
  TYPE: null
  SUFFIX: null
  FULLADDRESS: null
  SYMBOLROTATION: null
  CQ: null
  ADDRESSPTID: 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
  REPLACEDADDRESSID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: ACTIVE
Name: Active/Unused (Pink Text)
Domains:
• ADDRESSSTATUS:
  Inherited
• ADDRESSTYPE:
  Inherited
Templates:
• Name: Active/Unused (Pink Text)
  Description:
  Prototype:
  YCOORD: null
  MULTIADDRESSREPLACE: 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
  ADDRESSSTATUS: ACTIVE
  ADDRESSTYPE: null
  STREETNAME: null
  HOUSENUMBER_TEXT: null
  MS_COLOR: null
  PREFIX: null
  TYPE: null
  SUFFIX: null
  FULLADDRESS: null
  SYMBOLROTATION: null
  CQ: null
  ADDRESSPTID: 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
  REPLACEDADDRESSID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: UNUSED
Name: Active/Unused (Pink Text)
Domains:
• ADDRESSSTATUS:
  Inherited
• ADDRESSTYPE:
  Inherited
Templates:
• Name: UNUSED
  Description:
  Prototype:
  MULTIADDRESSREPLACE: null
  REPLACEDADDRESSID: 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: UNUSED
  ADDRESSTYPE: null
  STREETNAME: null
  HOUSENUMBER_TEXT: null
  MS_COLOR: null
  PREFIX: null
  TYPE: null
  SUFFIX: null
  FULLADDRESS: null
  SYMBOLROTATION: null
  CQ: null
  ADDRESSPTID: 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: true

Supports Coordinates Quantization: true

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