View In:   ArcGIS Online Map Viewer

Name: Address Points

Display Field: ST_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: County-wide E911 Address point locations. ADDRESS_ID is the unique ID for this layer.

Copyright Text: Rochester- Olmsted County MN Planning Department - GIS Division. Layer version managed via ROP rand updates follow Olmsted County schedules.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3600

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 560078.6961312145
YMin: 100270.74654622376
XMax: 720451.739885807
YMax: 232542.57714639604
Spatial Reference: 103761  (103761)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [40, 0, 171, 255]
Size: 1.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:
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: [ADDNO] CONCAT " " CONCAT [UNIT_TYPE] CONCAT " " CONCAT [UNIT]
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 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: bold
Font Decoration: none

Min. Scale: 2400.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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FEATURE_KEY ( type: esriFieldTypeInteger, alias: FEATURE_KEY, editable: true, nullable: true, defaultValue: null, modelName: FEATURE_KEY )
• ADDRESS_ID ( type: esriFieldTypeInteger, alias: ADDRESS_ID, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_ID )
• PARENT_ID ( type: esriFieldTypeInteger, alias: PARENT_ID, editable: true, nullable: true, defaultValue: null, modelName: PARENT_ID )
• STREET_ID ( type: esriFieldTypeInteger, alias: STREET_ID, editable: true, nullable: true, defaultValue: null, modelName: STREET_ID )
• DUP_STREET_ID ( type: esriFieldTypeInteger, alias: DUP_STREET_ID, editable: true, nullable: true, defaultValue: null, modelName: DUP_STREET_ID )
• CL_ID ( type: esriFieldTypeInteger, alias: CenterlineID, editable: true, nullable: true, defaultValue: null, modelName: CL_ID )
• ADD_TYPE ( type: esriFieldTypeSmallInteger, alias: AddressType, editable: true, nullable: true, defaultValue: 0, modelName: ADD_TYPE , Coded Values: [0: Situs] , [1: Building] , [2: Unit] , ...1 more... )
• EFF_STATUS ( type: esriFieldTypeString, alias: EffectiveStatus, editable: true, nullable: true, length: 20, defaultValue: P, modelName: EFF_STATUS , Coded Values: [A: Active] , [P: Pending] , [R: Retired] , ...3 more... )
• ADDNO_PRE ( type: esriFieldTypeString, alias: AddressNumberPrefix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADDNO_PRE )
• ADDNO ( type: esriFieldTypeString, alias: AddressNumber, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADDNO )
• ADDNO_SUF ( type: esriFieldTypeString, alias: AddressNumberSuffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADDNO_SUF )
• PRE_MOD ( type: esriFieldTypeString, alias: PreModifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRE_MOD )
• PRE_DIR ( type: esriFieldTypeString, alias: PreDir, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PRE_DIR , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• PRE_TYPE ( type: esriFieldTypeString, alias: PreType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRE_TYPE )
• ST_NAME ( type: esriFieldTypeString, alias: StreetName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ST_NAME )
• ST_TYPE ( type: esriFieldTypeString, alias: StreetType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ST_TYPE , Coded Values: [AVE: Avenue] , [BLVD: Boulevard] , [CIR: Circle] , ...10 more... )
• POST_DIR ( type: esriFieldTypeString, alias: PostDir, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POST_DIR , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• POST_MOD ( type: esriFieldTypeString, alias: PostModifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POST_MOD )
• UNIT_TYPE ( type: esriFieldTypeString, alias: UnitType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNIT_TYPE , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...10 more... )
• UNIT ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNIT )
• FLOOR_NO ( type: esriFieldTypeString, alias: FloorNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FLOOR_NO )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY , Coded Values: [ROCHESTER: Rochester] , [BYRON: Byron] , [CHATFIELD: Chatfield] , ...15 more... )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 25, defaultValue: null, modelName: COUNTY , Coded Values: [OLMSTED: Olmsted] , [DODGE: Dodge] , [GOODHUE: Goodhue] , ...4 more... )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: MN, modelName: STATE , Coded Values: [MN: Minnesota] )
• ZIP5 ( type: esriFieldTypeString, alias: Zipcode, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIP5 , Coded Values: [55901: Rochester - NW] , [55902: Rochester - SW] , [55904: Rochester-SE] , ...18 more... )
• ZIP4 ( type: esriFieldTypeString, alias: ZipPlus4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ZIP4 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
• EDIT_USER ( type: esriFieldTypeString, alias: EditUser, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EDIT_USER , Coded Values: [plajchez: Janice K. Chezick] , [pladwitt: David F. Wittman] , [plajrand: Jennifer L. Rand-Weaver] , ...12 more... )
• PAR_CHILD ( type: esriFieldTypeString, alias: ParentChild, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PAR_CHILD , Coded Values: [P: Parent] , [C: Child] )
• CONDADD1 ( type: esriFieldTypeString, alias: CondAddr1, editable: true, nullable: true, length: 320, defaultValue: null, modelName: CONDADD1 )
• CONDADD2 ( type: esriFieldTypeString, alias: CondAddr2, editable: true, nullable: true, length: 320, defaultValue: null, modelName: CONDADD2 )
• MULTIADDR ( type: esriFieldTypeString, alias: MultipleAddress, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MULTIADDR , Coded Values: [Y: Yes] , [N: No] )
• AUTHORITY ( type: esriFieldTypeString, alias: AddressAuthority, editable: true, nullable: true, length: 30, defaultValue: Olmsted, modelName: AUTHORITY , Coded Values: [Olmsted: County of Olmsted] , [Chatfield: City of Chatfield] , [Dover: City of Dover] , ...12 more... )
• PRV_PUB_ST ( type: esriFieldTypeString, alias: PrivatePublicStreet, editable: true, nullable: true, length: 8, defaultValue: Public, modelName: PRV_PUB_ST , Coded Values: [Private: Private] , [Public: Public] )
• ISSUE_DATE ( type: esriFieldTypeDate, alias: IssueDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ISSUE_DATE )
• INACT_DATE ( type: esriFieldTypeDate, alias: InactiveDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INACT_DATE )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PIN )
• PARID ( type: esriFieldTypeString, alias: ParcelNumber, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARID )
• LEG_ALERT ( type: esriFieldTypeString, alias: LegacyAlert, editable: true, nullable: true, length: 1, defaultValue: N, modelName: LEG_ALERT , Coded Values: [Y: Yes] , [N: No] )
• VENUE ( type: esriFieldTypeString, alias: Venue, editable: true, nullable: true, length: 5, defaultValue: null, modelName: VENUE , Coded Values: [CBY: City of Byron] , [CCH: City of Chatfield] , [CDO: City of Dover] , ...31 more... )
• VENUE_D ( type: esriFieldTypeString, alias: VenueDescription, editable: true, nullable: true, length: 35, defaultValue: null, modelName: VENUE_D , Coded Values: [Township of Haverhill: Township of Haverhill] , [Township of High Forest: Township of High Forest] , [Township of Kalmar: Township of Kalmar] , ...31 more... )
• VENUE_ID ( type: esriFieldTypeInteger, alias: VenueID, editable: true, nullable: true, defaultValue: null, modelName: VENUE_ID )
• CR_DATE ( type: esriFieldTypeDate, alias: Created_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CR_DATE )
• CR_EDITOR ( type: esriFieldTypeString, alias: Created_Editor_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CR_EDITOR , Coded Values: [plajchez: Janice K. Chezick] , [pladwitt: David F. Wittman] , [plajrand: Jennifer L. Rand-Weaver] , ...12 more... )
• X_COORD ( type: esriFieldTypeDouble, alias: X_Coord, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_Coord, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• Z_COORD ( type: esriFieldTypeDouble, alias: Z_Coord, editable: true, nullable: true, defaultValue: null, modelName: Z_COORD )
• COUNTRY ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 3, defaultValue: US, modelName: COUNTRY , Coded Values: [US: United States] )
• BLDG_TYPE ( type: esriFieldTypeString, alias: BuildingType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BLDG_TYPE , Coded Values: [LM: Landmark] , [C: Commercial] , [NS: No Structure] , ...8 more... )
• ADDR_NOTES ( type: esriFieldTypeString, alias: AddressNotes, editable: true, nullable: true, length: 1, defaultValue: N, modelName: ADDR_NOTES , Coded Values: [Y: Yes] , [N: No] )
• EDIT_REASN ( type: esriFieldTypeString, alias: ReasonForEdit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EDIT_REASN , Coded Values: [GC: Geometry Correction] , [INITIAL: Initial Data Load] , [ATTU: Attribute Update] , ...2 more... )
• ENFORCE_VALIDATION ( type: esriFieldTypeString, alias: EnforceValidation, editable: true, nullable: true, length: 1, defaultValue: Y, modelName: ENFORCE_VALIDATION , Coded Values: [Y: Yes] , [N: No] )
• JOIN_ID ( type: esriFieldTypeInteger, alias: JoinID, editable: true, nullable: true, defaultValue: null, modelName: JOIN_ID )
• FEE_PD ( type: esriFieldTypeString, alias: Fee Paid, editable: true, nullable: true, length: 6, defaultValue: null, modelName: FEE_PD , Coded Values: [Y: Yes] , [N: No] , [W: Waived] , ...1 more... )
• OCCU_CLASS ( type: esriFieldTypeString, alias: Occupancy Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OCCU_CLASS , Coded Values: [GROUP A: Assembly] , [GROUP B: Business] , [GROUP E: Education] , ...7 more... )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: COMMENT )
• SOURCE_ID ( type: esriFieldTypeInteger, alias: SOURCE_ID, editable: true, nullable: true, defaultValue: null, modelName: SOURCE_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CTU_ID_TXT ( type: esriFieldTypeString, alias: CTUCode, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CTU_ID_TXT , Coded Values: [02393488: Byron] , [00663760: Cascade Township] , [02393810: Chatfield] , ...25 more... )
• CTU_NAME ( type: esriFieldTypeString, alias: CTUNAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CTU_NAME , Coded Values: [Byron: Byron] , [Cascade Township: Cascade Township] , [Chatfield: Chatfield] , ...29 more... )
• ESN ( type: esriFieldTypeString, alias: Emergency Service Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN , Coded Values: [3150: 3150] , [3151: 3151] , [3152: 3152] , ...71 more... )
• MSAG_C ( type: esriFieldTypeString, alias: MSAG Community Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MSAG_C , Coded Values: [OOJ: Out of Jurisdiction] , [ROCHESTER: Rochester] , [BYRON: Byron] , ...16 more... )
• GIS911POC ( type: esriFieldTypeString, alias: 911 GIS Point-of-Contact, editable: true, nullable: true, length: 75, defaultValue: Olmsted, modelName: GIS911POC , Coded Values: [Olmsted: Olmsted] , [Dodge: Dodge] , [Goodhue: Goodhue] , ...5 more... )
• LST_PREDIR ( type: esriFieldTypeString, alias: Legacy Street Name Pre Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LST_PREDIR , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• LST_NAME ( type: esriFieldTypeString, alias: Legacy Street Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LST_NAME )
• LST_TYPE ( type: esriFieldTypeString, alias: Legacy Street Name Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LST_TYPE , Coded Values: [AVE: Avenue] , [BLVD: Boulevard] , [CIR: Circle] , ...10 more... )
• LST_POSTDIR ( type: esriFieldTypeString, alias: Legacy Street Name Post Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LST_POSTDIR , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )

Templates:

• Name: Address Points
  Description:
  Prototype:
  LST_TYPE: null
  LST_NAME: null
  FEATURE_KEY: null
  ADDRESS_ID: null
  PARENT_ID: null
  STREET_ID: null
  DUP_STREET_ID: null
  CL_ID: null
  ADD_TYPE: 0
  EFF_STATUS: P
  ADDNO_PRE: null
  ADDNO: null
  ADDNO_SUF: null
  PRE_MOD: null
  PRE_DIR: null
  PRE_TYPE: null
  ST_NAME: null
  ST_TYPE: null
  POST_DIR: null
  POST_MOD: null
  UNIT_TYPE: null
  UNIT: null
  FLOOR_NO: null
  CITY: null
  COUNTY: null
  STATE: MN
  ZIP5: null
  ZIP4: null
  EDIT_DATE: null
  EDIT_USER: null
  PAR_CHILD: null
  CONDADD1: null
  CONDADD2: null
  MULTIADDR: N
  AUTHORITY: Olmsted
  PRV_PUB_ST: Public
  ISSUE_DATE: null
  INACT_DATE: null
  PIN: null
  PARID: null
  LEG_ALERT: N
  VENUE: null
  VENUE_D: null
  VENUE_ID: null
  CR_DATE: null
  CR_EDITOR: null
  X_COORD: null
  Y_COORD: null
  Z_COORD: null
  COUNTRY: US
  BLDG_TYPE: null
  ADDR_NOTES: N
  EDIT_REASN: null
  ENFORCE_VALIDATION: Y
  JOIN_ID: null
  FEE_PD: null
  OCCU_CLASS: null
  COMMENT: null
  SOURCE_ID: null
  LST_POSTDIR: null
  CTU_ID_TXT: null
  CTU_NAME: null
  ESN: null
  MSAG_C: null
  GIS911POC: Olmsted
  LST_PREDIR: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata