View In:   ArcGIS Online Map Viewer

Name: LOC_Address_ViewOnly

Display Field: ST_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Address points represent individual addressed locations as determined by the Local Addressing Authority. This authority rest in the municipal government in Ramsey County, and the municipalities assist in the maintenance of this information. The original source of many of these points came from the centroid of tax parcels with known situs addresses. In some locations this data has been enhanced to cases where a tax parcel may have multiple addresses (such as in some apartment units).

Service Item Id: 18019c77c2ec499897db0fefb624ca25

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 540198.8564292192
YMin: 136499.00746005774
XMax: 603861.1001674682
YMax: 221517.09989072382
Spatial Reference: 103768  (103768)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false
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 )
• FeatureUniqueID ( type: esriFieldTypeString, alias: FeatureUniqueID, editable: true, nullable: true, length: 36, defaultValue: null, modelName: FeatureUniqueID )
• LocalUniqueID ( type: esriFieldTypeString, alias: Local Unique ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocalUniqueID )
• NumberPrefix ( type: esriFieldTypeString, alias: NumberPrefix, editable: true, nullable: true, length: 6, defaultValue: null, modelName: NumberPrefix )
• ANUMBER ( type: esriFieldTypeInteger, alias: AddressNumber, editable: true, nullable: true, defaultValue: null, modelName: ANUMBER )
• NumberSuffix ( type: esriFieldTypeString, alias: NumberSuffix, editable: true, nullable: true, length: 6, defaultValue: null, modelName: NumberSuffix )
• SeperatorElement ( type: esriFieldTypeString, alias: SeperatorElement, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SeperatorElement )
• StreetPreModifier ( type: esriFieldTypeString, alias: StreetPreModifier, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StreetPreModifier )
• StreetPrefixDirectional ( type: esriFieldTypeString, alias: StreetPrefixDirectional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: StreetPrefixDirectional , Coded Values: [North: North] , [South: South] , [East: East] , ...5 more... )
• StreetPreType ( type: esriFieldTypeString, alias: StreetPreType, editable: true, nullable: true, length: 24, defaultValue: null, modelName: StreetPreType , Coded Values: [County Road: County Road] , [Interstate: Interstate] , [Highway: Highway] )
• ST_NAME ( type: esriFieldTypeString, alias: StreetNameOnly, editable: true, nullable: true, length: 42, defaultValue: null, modelName: ST_NAME )
• StreetPostType ( type: esriFieldTypeString, alias: StreetPostType, editable: true, nullable: true, length: 12, defaultValue: null, modelName: StreetPostType , Coded Values: [Alcove: Alcove] , [Alley: Alley] , [Avenue: Avenue] , ...38 more... )
• StreetPostDirectional ( type: esriFieldTypeString, alias: StreetPostDirectional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: StreetPostDirectional , Coded Values: [North: North] , [South: South] , [East: East] , ...5 more... )
• StreetPostModifier ( type: esriFieldTypeString, alias: StreetPostModifier, editable: true, nullable: true, length: 12, defaultValue: null, modelName: StreetPostModifier )
• SubType1 ( type: esriFieldTypeString, alias: SubType1, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SubType1 )
• SubNumber1 ( type: esriFieldTypeString, alias: SubNumber1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SubNumber1 )
• SubType2 ( type: esriFieldTypeString, alias: SubType2, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SubType2 )
• SubNumber2 ( type: esriFieldTypeString, alias: SubNumber2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SubNumber2 )
• CityCode ( type: esriFieldTypeString, alias: CityCode, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CityCode , Coded Values: [02393979: Arden Hills] , [02394183: Blaine] , [02394738: Falcon Heights] , ...61 more... )
• PostalCity ( type: esriFieldTypeString, alias: PostalCity, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PostalCity )
• CO_NAME ( type: esriFieldTypeString, alias: CountyName, editable: true, nullable: true, length: 20, defaultValue: 123, modelName: CO_NAME , Coded Values: [003: Anoka County] , [019: Carver County] , [037: Dakota County] , ...4 more... )
• ZIP ( type: esriFieldTypeString, alias: Zip, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIP )
• ZipCode4 ( type: esriFieldTypeString, alias: ZipCode4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ZipCode4 )
• LocationName ( type: esriFieldTypeString, alias: LocationName, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LocationName )
• LocationDescription ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LocationDescription )
• LandmarkName ( type: esriFieldTypeString, alias: LandmarkName, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LandmarkName )
• Residence ( type: esriFieldTypeString, alias: Residence, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Residence , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• MailableAddress ( type: esriFieldTypeString, alias: MailableAddress, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MailableAddress , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STATUS , Coded Values: [Active: Active] , [Retired: Retired] , [Planned: Planned] , ...3 more... )
• ParcelIDNumber ( type: esriFieldTypeString, alias: ParcelIDNumber, editable: true, nullable: true, length: 17, defaultValue: null, modelName: ParcelIDNumber )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• PositionAccuracy ( type: esriFieldTypeSmallInteger, alias: PositionAccuracy, editable: true, nullable: true, defaultValue: null, modelName: PositionAccuracy , Coded Values: [0: Unknown] , [1: Inside Tax Parcel] , [2: Doorstep/Entrance] , ...6 more... )
• AddressSource ( type: esriFieldTypeString, alias: AddressSource, editable: true, nullable: true, length: 40, defaultValue: null, modelName: AddressSource )
• AAUTHORITY ( type: esriFieldTypeString, alias: AddressAuthority, editable: true, nullable: true, length: 40, defaultValue: null, modelName: AAUTHORITY , Coded Values: [City of Arden Hills: City of Arden Hills] , [City of Blaine: City of Blaine] , [City of Falcon Heights: City of Falcon Heights] , ...19 more... )
• EDIT_ORG ( type: esriFieldTypeString, alias: EditOrganization, editable: true, nullable: true, length: 40, defaultValue: null, modelName: EDIT_ORG , Coded Values: [City of Arden Hills: City of Arden Hills] , [City of Blaine: City of Blaine] , [City of Falcon Heights: City of Falcon Heights] , ...18 more... )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UpdateDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATEDATE )
• AssignDate ( type: esriFieldTypeDate, alias: Assign Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AssignDate )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 240, defaultValue: null, modelName: Comments )
• AddressType ( type: esriFieldTypeString, alias: AddressType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AddressType , Coded Values: [Primary: Primary] , [Sub Address: Sub Address] , [Infrastructure: Infrastructure] , ...4 more... )
• RoutingStreetExtkey ( type: esriFieldTypeString, alias: RoutingStreetExtkey, editable: true, nullable: true, length: 36, defaultValue: null, modelName: RoutingStreetExtkey )
• CADAddress ( type: esriFieldTypeString, alias: CADAddress, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CADAddress )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• NotGeocodable ( type: esriFieldTypeString, alias: NotGeocodable, editable: true, nullable: true, length: 7, defaultValue: null, modelName: NotGeocodable )
• ESN ( type: esriFieldTypeString, alias: ESN, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN , Coded Values: [1: WASH:1] , [2: WASH:2] , [3: WASH:3] , ...153 more... )
• MSAGCommunity ( type: esriFieldTypeString, alias: MSAGCommunity, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MSAGCommunity , Coded Values: [Afton: Afton] , [Amador Twp: Amador Twp] , [Andover: Andover] , ...220 more... )
• FireID ( type: esriFieldTypeString, alias: FireID, editable: true, nullable: true, length: 11, defaultValue: null, modelName: FireID )
• PoliceID ( type: esriFieldTypeString, alias: PoliceID, editable: true, nullable: true, length: 11, defaultValue: null, modelName: PoliceID )
• UniqueAddress ( type: esriFieldTypeString, alias: UniqueAddress, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UniqueAddress , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• StreetNameAll ( type: esriFieldTypeString, alias: StreetNameAll, editable: false, nullable: true, length: 250, defaultValue: null, modelName: StreetNameAll )
• City ( type: esriFieldTypeString, alias: City, editable: false, nullable: true, length: 50, defaultValue: null, modelName: City )
• SiteAddress ( type: esriFieldTypeString, alias: SiteAddress, editable: false, nullable: true, length: 250, defaultValue: null, modelName: SiteAddress )
• SiteCityStateZIP ( type: esriFieldTypeString, alias: SiteCityStateZIP, editable: false, nullable: true, length: 250, defaultValue: null, modelName: SiteCityStateZIP )
• AddressNumberAll ( type: esriFieldTypeString, alias: AddressNumberAll, editable: false, nullable: true, length: 15, defaultValue: null, modelName: AddressNumberAll )
• HAE ( type: esriFieldTypeDouble, alias: Height Above Ellipsoid, editable: true, nullable: true, defaultValue: null, modelName: HAE )
• TotalAddress ( type: esriFieldTypeString, alias: TotalAddress, editable: false, nullable: true, length: 255, defaultValue: null, modelName: TotalAddress )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UnitAll ( type: esriFieldTypeString, alias: UnitAll, editable: false, nullable: true, length: 25, defaultValue: null, modelName: UnitAll )

Templates:

• Name: LOC_Address_ViewOnly
  Description:
  Prototype:
  ESN: null
  MSAGCommunity: null
  FeatureUniqueID: null
  LocalUniqueID: null
  NumberPrefix: null
  ANUMBER: null
  NumberSuffix: null
  SeperatorElement: null
  StreetPreModifier: null
  StreetPrefixDirectional: null
  StreetPreType: null
  ST_NAME: null
  StreetPostType: null
  StreetPostDirectional: null
  StreetPostModifier: null
  SubType1: null
  SubNumber1: null
  SubType2: null
  SubNumber2: null
  CityCode: null
  PostalCity: null
  CO_NAME: 123
  ZIP: null
  ZipCode4: null
  LocationName: null
  LocationDescription: null
  LandmarkName: null
  Residence: null
  MailableAddress: null
  STATUS: null
  ParcelIDNumber: null
  LONGITUDE: null
  LATITUDE: null
  PositionAccuracy: null
  AddressSource: null
  AAUTHORITY: null
  EDIT_ORG: null
  UPDATEDATE: null
  AssignDate: null
  Comments: null
  AddressType: null
  RoutingStreetExtkey: null
  CADAddress: null
  HAE: null
  FireID: null
  PoliceID: null
  UniqueAddress: null
  NotGeocodable: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

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

Supports Coordinates Quantization: true

Child Resources:

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