View In:   ArcGIS Online Map Viewer

Name: Street Addresses

Display Field: st_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0c64fa8be37345d6b7a6acbecbdc258c

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2000.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: -8420743.867856722
YMin: 4577568.838818857
XMax: -8354537.420269562
YMax: 4644540.189717674
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [add_number] CONCAT " " CONCAT [unit_number]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 24000.0
Max. Scale: 0.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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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 )
• discrpagid ( type: esriFieldTypeString, alias: discrpagid, editable: true, nullable: true, length: 75, defaultValue: null, modelName: DiscrpAgID )
• dateupdate ( type: esriFieldTypeDate, alias: dateupdate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateUpdate )
• site_nguid ( type: esriFieldTypeString, alias: site_nguid, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Site_NGUID )
• country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Country )
• state ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: State )
• county ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 40, defaultValue: null, modelName: County )
• addcode ( type: esriFieldTypeString, alias: addcode, editable: true, nullable: true, length: 6, defaultValue: null, modelName: AddCode )
• inc_muni ( type: esriFieldTypeString, alias: inc_muni, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Inc_Muni )
• uninc_muni ( type: esriFieldTypeString, alias: uninc_muni, editable: true, nullable: true, length: 100, defaultValue: null, modelName: uninc_muni )
• addnum_pre ( type: esriFieldTypeString, alias: addnum_pre, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AddNum_Pre )
• add_number ( type: esriFieldTypeString, alias: add_number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: add_number )
• addnum_suf ( type: esriFieldTypeString, alias: addnum_suf, editable: true, nullable: true, length: 4, defaultValue: null, modelName: addnum_suf )
• st_premod ( type: esriFieldTypeString, alias: st_premod, editable: true, nullable: true, length: 15, defaultValue: null, modelName: St_PreMod )
• st_predir ( type: esriFieldTypeString, alias: st_predir, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PreDir )
• st_pretyp ( type: esriFieldTypeString, alias: st_pretyp, editable: true, nullable: true, length: 50, defaultValue: null, modelName: St_PreTyp )
• st_presep ( type: esriFieldTypeString, alias: st_presep, editable: true, nullable: true, length: 20, defaultValue: null, modelName: St_PreSep )
• st_name ( type: esriFieldTypeString, alias: st_name, editable: true, nullable: true, length: 60, defaultValue: null, modelName: St_Name )
• st_postyp ( type: esriFieldTypeString, alias: st_postyp, editable: true, nullable: true, length: 50, defaultValue: null, modelName: St_PosTyp )
• st_posdir ( type: esriFieldTypeString, alias: st_posdir, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PosDir )
• st_posmod ( type: esriFieldTypeString, alias: st_posmod, editable: true, nullable: true, length: 25, defaultValue: null, modelName: St_PosMod )
• lst_predir ( type: esriFieldTypeString, alias: lst_predir, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LSt_PreDir )
• lst_name ( type: esriFieldTypeString, alias: lst_name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LSt_Name )
• lst_type ( type: esriFieldTypeString, alias: lst_type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LSt_Type )
• lst_posdir ( type: esriFieldTypeString, alias: lst_posdir, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LSt_PosDir )
• unit_type ( type: esriFieldTypeString, alias: unit_type, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Unit_Type )
• unit_number ( type: esriFieldTypeString, alias: unit_number, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Unit )
• landmkname ( type: esriFieldTypeString, alias: landmkname, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LandmkName )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• external_nguid ( type: esriFieldTypeInteger, alias: external_nguid, editable: true, nullable: true, defaultValue: null, modelName: external_nguid )
• photo_front ( type: esriFieldTypeString, alias: PHOTO_FRONT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_front )
• photo_back ( type: esriFieldTypeString, alias: PHOTO_BACK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_back )
• photo_right ( type: esriFieldTypeString, alias: PHOTO_RIGHT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_right )
• photo_left ( type: esriFieldTypeString, alias: PHOTO_LEFT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_left )
• photo_front_link ( type: esriFieldTypeString, alias: PHOTO_FRONT_LINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_front_link )
• photo_back_link ( type: esriFieldTypeString, alias: PHOTO_BACK_LINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_back_link )
• photo_right_link ( type: esriFieldTypeString, alias: PHOTO_RIGHT_LINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_right_link )
• photo_left_link ( type: esriFieldTypeString, alias: PHOTO_LEFT_LINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photo_left_link )
• zipcode ( type: esriFieldTypeString, alias: ZIPcode, editable: true, nullable: true, length: 5, defaultValue: null, modelName: zipcode )
• zip_src ( type: esriFieldTypeString, alias: ZIP_SRC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: zip_src )
• veriftime ( type: esriFieldTypeDate, alias: VerifTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: veriftime )
• veriftype ( type: esriFieldTypeString, alias: VerifType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: veriftype )
• photo_status ( type: esriFieldTypeString, alias: PHOTO_STATUS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: photo_status )
• labrotate ( type: esriFieldTypeInteger, alias: Labrotate, editable: true, nullable: true, defaultValue: null, modelName: labrotate )
• inset ( type: esriFieldTypeInteger, alias: Inset, editable: true, nullable: true, defaultValue: null, modelName: inset )
• maptype ( type: esriFieldTypeString, alias: Maptype, editable: true, nullable: true, length: 12, defaultValue: null, modelName: maptype )
• comunity_l ( type: esriFieldTypeString, alias: comunity_l, editable: true, nullable: true, length: 20, defaultValue: null, modelName: comunity_l )
• comunity_r ( type: esriFieldTypeString, alias: comunity_r, editable: true, nullable: true, length: 20, defaultValue: null, modelName: comunity_r )
• full_address ( type: esriFieldTypeString, alias: Full_address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: full_address )
• st_number ( type: esriFieldTypeString, alias: ST_NUMBER, editable: true, nullable: true, length: 5, defaultValue: null, modelName: st_number )
• cityl ( type: esriFieldTypeString, alias: CityL, editable: true, nullable: true, length: 4, defaultValue: null, modelName: cityl )
• cityr ( type: esriFieldTypeString, alias: cityr, editable: true, nullable: true, length: 4, defaultValue: null, modelName: cityr )
• st_prefix ( type: esriFieldTypeString, alias: st_prefix, editable: true, nullable: true, length: 4, defaultValue: null, modelName: st_prefix )
• st_type ( type: esriFieldTypeString, alias: st_type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: st_type )
• st_suffix ( type: esriFieldTypeString, alias: st_suffix, editable: true, nullable: true, length: 4, defaultValue: null, modelName: st_suffix )
• st_num_suffix ( type: esriFieldTypeString, alias: st_num_suffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: st_num_suffix )
• Community ( type: esriFieldTypeString, alias: Community, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Community )
• ESN ( type: esriFieldTypeString, alias: ESN, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN )

Templates:

• Name: sde.WORCESTERSDE.Worc_addresses
  Description:
  Prototype:
  Community: null
  discrpagid: null
  dateupdate: null
  site_nguid: null
  country: null
  state: null
  county: null
  addcode: null
  inc_muni: null
  uninc_muni: null
  addnum_pre: null
  add_number: null
  addnum_suf: null
  st_premod: null
  st_predir: null
  st_pretyp: null
  st_presep: null
  st_name: null
  st_postyp: null
  st_posdir: null
  st_posmod: null
  lst_predir: null
  lst_name: null
  lst_type: null
  lst_posdir: null
  unit_type: null
  unit_number: null
  landmkname: null
  ESN: null
  st_num_suffix: null
  st_suffix: null
  st_type: null
  external_nguid: null
  photo_front: null
  photo_back: null
  photo_right: null
  photo_left: null
  photo_front_link: null
  photo_back_link: null
  photo_right_link: null
  photo_left_link: null
  zipcode: null
  zip_src: null
  veriftime: null
  veriftype: null
  photo_status: null
  labrotate: null
  inset: null
  maptype: null
  comunity_l: null
  comunity_r: null
  full_address: null
  st_number: null
  cityl: null
  cityr: null
  st_prefix: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata