View In:   ArcGIS Online Map Viewer

Name: Ramsey County Address Points

Display Field: st_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Open data downloaded from https://data-ramseygis.opendata.arcgis.com/ 20200929

Service Item Id: fe83d08c341c45d2abef30df2a3ef617

Copyright Text: Open data downloaded from https://data-ramseygis.opendata.arcgis.com/ 20200929

Default Visibility: false

MaxRecordCount: 2000

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: 510090.01350188255
YMin: 47418.93880756199
XMax: 573115.2604826391
YMax: 132450.77104014158
Spatial Reference: 0  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [52, 121, 153, 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
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_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• objectid ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: objectid )
• globalid ( type: esriFieldTypeString, alias: GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: globalid )
• featureuni ( type: esriFieldTypeString, alias: FeatureUni, editable: true, nullable: true, length: 36, defaultValue: null, modelName: featureuni )
• localuniqu ( type: esriFieldTypeString, alias: LocalUniqu, editable: true, nullable: true, length: 45, defaultValue: null, modelName: localuniqu )
• numberpref ( type: esriFieldTypeString, alias: NumberPref, editable: true, nullable: true, length: 1, defaultValue: null, modelName: numberpref )
• anumber ( type: esriFieldTypeSmallInteger, alias: ANUMBER, editable: true, nullable: true, defaultValue: null, modelName: anumber )
• numbersuff ( type: esriFieldTypeString, alias: NumberSuff, editable: true, nullable: true, length: 4, defaultValue: null, modelName: numbersuff )
• seperatore ( type: esriFieldTypeString, alias: SeperatorE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: seperatore )
• streetprem ( type: esriFieldTypeString, alias: StreetPreM, editable: true, nullable: true, length: 1, defaultValue: null, modelName: streetprem )
• streetpref ( type: esriFieldTypeString, alias: StreetPref, editable: true, nullable: true, length: 1, defaultValue: null, modelName: streetpref )
• streetpret ( type: esriFieldTypeString, alias: StreetPreT, editable: true, nullable: true, length: 11, defaultValue: null, modelName: streetpret )
• st_name ( type: esriFieldTypeString, alias: ST_NAME, editable: true, nullable: true, length: 28, defaultValue: null, modelName: st_name )
• streetpost ( type: esriFieldTypeString, alias: StreetPost, editable: true, nullable: true, length: 9, defaultValue: null, modelName: streetpost )
• streetpo_1 ( type: esriFieldTypeString, alias: StreetPo_1, editable: true, nullable: true, length: 9, defaultValue: null, modelName: streetpo_1 )
• streetpo_2 ( type: esriFieldTypeString, alias: StreetPo_2, editable: true, nullable: true, length: 1, defaultValue: null, modelName: streetpo_2 )
• subtype1 ( type: esriFieldTypeString, alias: SubType1, editable: true, nullable: true, length: 9, 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: 1, defaultValue: null, modelName: subtype2 )
• subnumber2 ( type: esriFieldTypeString, alias: SubNumber2, editable: true, nullable: true, length: 1, defaultValue: null, modelName: subnumber2 )
• citycode ( type: esriFieldTypeString, alias: CityCode, editable: true, nullable: true, length: 8, defaultValue: null, modelName: citycode )
• postalcity ( type: esriFieldTypeString, alias: PostalCity, editable: true, nullable: true, length: 11, defaultValue: null, modelName: postalcity )
• co_name ( type: esriFieldTypeString, alias: CO_NAME, editable: true, nullable: true, length: 6, defaultValue: null, modelName: co_name )
• 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 )
• locationna ( type: esriFieldTypeString, alias: LocationNa, editable: true, nullable: true, length: 30, defaultValue: null, modelName: locationna )
• locationde ( type: esriFieldTypeString, alias: LocationDe, editable: true, nullable: true, length: 40, defaultValue: null, modelName: locationde )
• landmarkna ( type: esriFieldTypeString, alias: LandmarkNa, editable: true, nullable: true, length: 40, defaultValue: null, modelName: landmarkna )
• residence ( type: esriFieldTypeString, alias: Residence, editable: true, nullable: true, length: 7, defaultValue: null, modelName: residence )
• mailablead ( type: esriFieldTypeString, alias: MailableAd, editable: true, nullable: true, length: 7, defaultValue: null, modelName: mailablead )
• status ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: status )
• parcelidnu ( type: esriFieldTypeString, alias: ParcelIDNu, editable: true, nullable: true, length: 12, defaultValue: null, modelName: parcelidnu )
• 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 )
• positionac ( type: esriFieldTypeSmallInteger, alias: PositionAc, editable: true, nullable: true, defaultValue: null, modelName: positionac )
• addresssou ( type: esriFieldTypeString, alias: AddressSou, editable: true, nullable: true, length: 32, defaultValue: null, modelName: addresssou )
• aauthority ( type: esriFieldTypeString, alias: AAUTHORITY, editable: true, nullable: true, length: 24, defaultValue: null, modelName: aauthority )
• edit_org ( type: esriFieldTypeString, alias: EDIT_ORG, editable: true, nullable: true, length: 24, defaultValue: null, modelName: edit_org )
• updatedate ( type: esriFieldTypeDate, alias: UPDATEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: updatedate )
• assigndate ( type: esriFieldTypeDate, alias: AssignDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: assigndate )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 102, defaultValue: null, modelName: comments )
• addresstyp ( type: esriFieldTypeString, alias: AddressTyp, editable: true, nullable: true, length: 19, defaultValue: null, modelName: addresstyp )
• routingstr ( type: esriFieldTypeString, alias: RoutingStr, editable: true, nullable: true, length: 36, defaultValue: null, modelName: routingstr )
• cadaddress ( type: esriFieldTypeString, alias: CADAddress, editable: true, nullable: true, length: 1, defaultValue: null, modelName: cadaddress )
• created_us ( type: esriFieldTypeString, alias: created_us, editable: true, nullable: true, length: 16, defaultValue: null, modelName: created_us )
• created_da ( type: esriFieldTypeDate, alias: created_da, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_da )
• last_edite ( type: esriFieldTypeString, alias: last_edite, editable: true, nullable: true, length: 12, defaultValue: null, modelName: last_edite )
• last_edi_1 ( type: esriFieldTypeDate, alias: last_edi_1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edi_1 )
• notgeocoda ( type: esriFieldTypeString, alias: NotGeocoda, editable: true, nullable: true, length: 3, defaultValue: null, modelName: notgeocoda )
• esn ( type: esriFieldTypeString, alias: ESN, editable: true, nullable: true, length: 4, defaultValue: null, modelName: esn )
• msagcommun ( type: esriFieldTypeString, alias: MSAGCommun, editable: true, nullable: true, length: 16, defaultValue: null, modelName: msagcommun )
• fireid ( type: esriFieldTypeString, alias: FireID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: fireid )
• policeid ( type: esriFieldTypeString, alias: PoliceID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: policeid )
• streetname ( type: esriFieldTypeString, alias: StreetName, editable: true, nullable: true, length: 38, defaultValue: null, modelName: streetname )
• city ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 19, defaultValue: null, modelName: city )
• 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 )
• globalid_1 ( type: esriFieldTypeGlobalID, alias: globalid_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid_1 )

Templates:

• Name: Ramsey County Address Points
  Description:
  Prototype:
  streetname: null
  city: null
  objectid: null
  globalid: null
  featureuni: null
  localuniqu: null
  numberpref: null
  anumber: null
  numbersuff: null
  seperatore: null
  streetprem: null
  streetpref: null
  streetpret: null
  st_name: null
  streetpost: null
  streetpo_1: null
  streetpo_2: null
  subtype1: null
  subnumber1: null
  subtype2: null
  subnumber2: null
  citycode: null
  postalcity: null
  co_name: null
  zip: null
  zipcode4: null
  locationna: null
  locationde: null
  landmarkna: null
  residence: null
  mailablead: null
  status: null
  parcelidnu: null
  longitude: null
  latitude: null
  positionac: null
  addresssou: null
  aauthority: null
  edit_org: null
  updatedate: null
  assigndate: null
  comments: null
  addresstyp: null
  routingstr: null
  cadaddress: null
  created_us: null
  created_da: null
  last_edite: null
  last_edi_1: null
  notgeocoda: null
  esn: null
  msagcommun: null
  fireid: null
  policeid: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Sync,Extract

Sync Can Return Changes: true

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

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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