View In:   ArcGIS Online Map Viewer

Name: Addresses

Display Field: SECONDARYSTREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Street number, street name, street type, apartment or subaddress are shown in this feature class. Points are not necessarily located directly where the structure/fixture for the address is. Address points sometimes depict utiltiy accounts not associated with parcels. Multiple address points may reside in one parcel or depict several subaddresses/fixtures for one address. Multiple parcel ownership can have one address and have multiple address points for different subaddresses/fixtures. Addresses are assigned by the Office of Real Estate &amp; Property Information and graphically shown by IT/GIS where directed by that dvision of Community Development.</SPAN></P></DIV></DIV></DIV>

Definition Expression: N/A

Copyright Text: Community Development Department/Office of Real Estate & Property Information, Information Technology Department/GIS Division

Default Visibility: true

MaxRecordCount: 90000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

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: [56, 116, 165, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

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 )

Templates:

• Name: Addresses
  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,Create,Update,Delete,Uploads,Editing,Sync,Extract

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   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata