View In:   ArcGIS Online Map Viewer

Name: Geohazards AUM Site Inventory

Display Field: QUADRANGLE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

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: -2.0037507842788246E7
YMin: -3.024097145838615E7
XMax: 2.0037507842788246E7
YMax: 3.024097145838615E7
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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:

• NLFID ( type: esriFieldTypeString, alias: NLFID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: NLFID )
• CRS ( type: esriFieldTypeString, alias: CRS, editable: false, nullable: true, length: 17, defaultValue: null, modelName: CRS )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT District, editable: false, nullable: true, length: 2, defaultValue: null, modelName: ODOT_DISTRICT )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: false, nullable: true, length: 10, defaultValue: null, modelName: COUNTY )
• COUNTY_CD ( type: esriFieldTypeString, alias: County CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: COUNTY_CD )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: Route Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE_TYPE )
• ROUTE_NBR ( type: esriFieldTypeString, alias: Route Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ROUTE_NBR )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: Route Suffix, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ROUTE_SUFFIX )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: CTL_BEGIN_NBR )
• CTL_END_NBR ( type: esriFieldTypeDouble, alias: CTL End Number, editable: true, nullable: true, defaultValue: null, modelName: CTL_END_NBR )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: STL_BEGIN_NBR )
• STL_END_NBR ( type: esriFieldTypeDouble, alias: STL End Number, editable: true, nullable: true, defaultValue: null, modelName: STL_END_NBR )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Latitude DD Begin, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE_DD_BEGIN )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Longitude DD Begin, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE_DD_BEGIN )
• LATITUDE_DD_END ( type: esriFieldTypeDouble, alias: Latitude DD End, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE_DD_END )
• LONGITUDE_DD_END ( type: esriFieldTypeDouble, alias: Longitude DD End, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE_DD_END )
• PERP_DATE ( type: esriFieldTypeDate, alias: PERP Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PERP_DATE )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1, defaultValue: null, modelName: STATUS )
• PID ( type: esriFieldTypeInteger, alias: PID, editable: true, nullable: true, defaultValue: null, modelName: PID )
• LET_PLANS_URL ( type: esriFieldTypeString, alias: Let Plans URL , editable: true, nullable: true, length: 150, defaultValue: null, modelName: LET_PLANS_URL )
• MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: Maintenance Responsibility, editable: false, nullable: true, length: 1, defaultValue: null, modelName: MAINTAIN_RESPONSIBLE )
• LEGACY_GLOBAL_ID ( type: esriFieldTypeString, alias: Legacy GlobalID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LEGACY_GLOBAL_ID )
• ROAD_FUNCTIONAL_CLASS ( type: esriFieldTypeString, alias: Road Functional Class, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ROAD_FUNCTIONAL_CLASS )
• FEDERAL_AID_ELIGIBLE ( type: esriFieldTypeString, alias: Federal Aid Eligible, editable: true, nullable: true, length: 1, defaultValue: null, modelName: FEDERAL_AID_ELIGIBLE )
• ROAD_WIDTH ( type: esriFieldTypeInteger, alias: Road Width, editable: true, nullable: true, defaultValue: null, modelName: ROAD_WIDTH )
• OUTSIDE_SHOULDER_WIDTH ( type: esriFieldTypeInteger, alias: Outside Shoulder Width, editable: true, nullable: true, defaultValue: null, modelName: OUTSIDE_SHOULDER_WIDTH )
• INSIDE_SHOULDER_WIDTH ( type: esriFieldTypeInteger, alias: Inside Shoulder Width, editable: true, nullable: true, defaultValue: null, modelName: INSIDE_SHOULDER_WIDTH )
• MEDIAN_WIDTH ( type: esriFieldTypeInteger, alias: Median Width, editable: true, nullable: true, defaultValue: null, modelName: MEDIAN_WIDTH )
• LANE_NUM_PER_DIRECTION ( type: esriFieldTypeDouble, alias: Lane Number Per Direction, editable: true, nullable: true, defaultValue: null, modelName: LANE_NUM_PER_DIRECTION )
• SURFACE_TYPE_LEFT ( type: esriFieldTypeString, alias: Surface Type Left, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SURFACE_TYPE_LEFT )
• SURFACE_TYPE_RIGHT ( type: esriFieldTypeString, alias: Surface Type Right, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SURFACE_TYPE_RIGHT )
• BASE_TYPE_LEFT ( type: esriFieldTypeString, alias: Base Type Left, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BASE_TYPE_LEFT )
• BASE_TYPE_RIGHT ( type: esriFieldTypeString, alias: Base Type Right, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BASE_TYPE_RIGHT )
• SHOULDER_TYPE ( type: esriFieldTypeString, alias: Shoulder Type, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SHOULDER_TYPE )
• MEDIAN_TYPE ( type: esriFieldTypeString, alias: Median Type, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MEDIAN_TYPE )
• SPEED_LIMIT ( type: esriFieldTypeInteger, alias: Speed Limit, editable: true, nullable: true, defaultValue: null, modelName: SPEED_LIMIT )
• AADT_TOTAL_NUMBER ( type: esriFieldTypeInteger, alias: AADT Total Number, editable: true, nullable: true, defaultValue: null, modelName: AADT_TOTAL_NUMBER )
• AADT_TRUCK_NUMBER ( type: esriFieldTypeInteger, alias: AADT Truck Number, editable: true, nullable: true, defaultValue: null, modelName: AADT_TRUCK_NUMBER )
• QUADRANGLE_NAME ( type: esriFieldTypeString, alias: Quadrangle Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: QUADRANGLE_NAME )
• AUM_COMMENTS ( type: esriFieldTypeString, alias: AUMIRA Comments, editable: false, nullable: true, length: 2500, defaultValue: null, modelName: AUM_COMMENTS )
• AUM_SITE_ID ( type: esriFieldTypeString, alias: AUMIRA Site ID, editable: false, nullable: true, length: 10, defaultValue: null, modelName: AUM_SITE_ID )
• TOWNSHIP ( type: esriFieldTypeString, alias: Township, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TOWNSHIP )
• SECTION ( type: esriFieldTypeString, alias: Section, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SECTION )
• ODNR_MINE_MAP ( type: esriFieldTypeString, alias: ODNR Mine Map, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ODNR_MINE_MAP )
• API ( type: esriFieldTypeString, alias: API, editable: true, nullable: true, length: 100, defaultValue: null, modelName: API )
• SITE_DESCRIPTION ( type: esriFieldTypeString, alias: Site Description, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: SITE_DESCRIPTION )
• SECONDARY_MINING_EVID ( type: esriFieldTypeString, alias: Evidence of Secondary Mining, editable: true, nullable: true, length: 7, defaultValue: null, modelName: SECONDARY_MINING_EVID )
• SPECIAL_MINE_FEATURE ( type: esriFieldTypeString, alias: Special Mine Feature, editable: true, nullable: true, length: 7, defaultValue: null, modelName: SPECIAL_MINE_FEATURE )
• SPECIAL_MINE_COMMENT ( type: esriFieldTypeString, alias: Special Mine Feature Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: SPECIAL_MINE_COMMENT )
• AGE_OF_MINING ( type: esriFieldTypeInteger, alias: Age of Mining (Year of Last Survey), editable: true, nullable: true, defaultValue: null, modelName: AGE_OF_MINING )
• MINE_PROBLEM_REPORTED ( type: esriFieldTypeString, alias: Problem Reported During Active Mining, editable: true, nullable: true, length: 7, defaultValue: null, modelName: MINE_PROBLEM_REPORTED )
• MINING_PROBLEM_COMMENT ( type: esriFieldTypeString, alias: Mining Problem Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: MINING_PROBLEM_COMMENT )
• ROAD_SURFACE_ELEVATION ( type: esriFieldTypeInteger, alias: Road Surface Elevation, editable: true, nullable: true, defaultValue: null, modelName: ROAD_SURFACE_ELEVATION )
• BEDROCK_SURFACE_ELEV ( type: esriFieldTypeInteger, alias: Bedrock Surface Elevation, editable: true, nullable: true, defaultValue: null, modelName: BEDROCK_SURFACE_ELEV )
• BASE_ELEVATION_OF_SEAM ( type: esriFieldTypeInteger, alias: Base Elevation of Seam, editable: true, nullable: true, defaultValue: null, modelName: BASE_ELEVATION_OF_SEAM )
• MINE_SEAM_THICKNESS ( type: esriFieldTypeInteger, alias: Mine Seam Thickness, editable: true, nullable: true, defaultValue: null, modelName: MINE_SEAM_THICKNESS )
• UNCONSOLID_THICKNESS ( type: esriFieldTypeInteger, alias: Unconsolidated Thickness, editable: true, nullable: true, defaultValue: null, modelName: UNCONSOLID_THICKNESS )
• BEDROCK_THICKNESS ( type: esriFieldTypeInteger, alias: Bedrock Thickness, editable: true, nullable: true, defaultValue: null, modelName: BEDROCK_THICKNESS )
• OVERBURDEN_THICKNESS ( type: esriFieldTypeInteger, alias: Overburden Thickness, editable: true, nullable: true, defaultValue: null, modelName: OVERBURDEN_THICKNESS )
• UNCONSOLID_ROCK_THICK ( type: esriFieldTypeSingle, alias: Unconsolidated / Bedrock Thickness, editable: true, nullable: true, defaultValue: null, modelName: UNCONSOLID_ROCK_THICK )
• OVERBUR_INTERVAL_RATIO ( type: esriFieldTypeSingle, alias: Ratio of Minimum Total Overburden Thickness to Maximum Mined Interval Thickness, editable: true, nullable: true, defaultValue: null, modelName: OVERBUR_INTERVAL_RATIO )
• OVERBURDEN_COMMENT ( type: esriFieldTypeString, alias: Overburden Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: OVERBURDEN_COMMENT )
• ASSOC_SITE_SCREENING ( type: esriFieldTypeString, alias: Associated Site Screening, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ASSOC_SITE_SCREENING )
• ASSOC_SITE_COMMENTS ( type: esriFieldTypeString, alias: Associated Site Screening Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: ASSOC_SITE_COMMENTS )
• INFO_SOURCE ( type: esriFieldTypeString, alias: Info Source, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: INFO_SOURCE )
• PHOTO_LINK_TO_FALCON ( type: esriFieldTypeString, alias: Photo Link to Falcon, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTO_LINK_TO_FALCON )
• ANNUAL_MAINT_FREQUENCY ( type: esriFieldTypeInteger, alias: Annual Maintenance Frequency, editable: true, nullable: true, defaultValue: null, modelName: ANNUAL_MAINT_FREQUENCY )
• NBR_OF_MINE_OPENINGS ( type: esriFieldTypeInteger, alias: Number of Mine Openings, editable: true, nullable: true, defaultValue: null, modelName: NBR_OF_MINE_OPENINGS )
• NBR_OF_VERTICAL_SHAFTS ( type: esriFieldTypeInteger, alias: Number of Vertical Shafts, editable: true, nullable: true, defaultValue: null, modelName: NBR_OF_VERTICAL_SHAFTS )
• NBR_OF_SURFACE_DEFORM ( type: esriFieldTypeInteger, alias: Number of Surface Deformations, editable: true, nullable: true, defaultValue: null, modelName: NBR_OF_SURFACE_DEFORM )
• LATEST_ED ( type: esriFieldTypeString, alias: Latest Emergency Determination, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LATEST_ED )
• LATEST_ED_NBR ( type: esriFieldTypeString, alias: Latest Emergency Declaration Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LATEST_ED_NBR )
• LATEST_ED_DATE ( type: esriFieldTypeDate, alias: Latest Emergency Declaration Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LATEST_ED_DATE )
• LATEST_TIER ( type: esriFieldTypeInteger, alias: Latest Tier, editable: true, nullable: true, defaultValue: null, modelName: LATEST_TIER )
• LATEST_DETAILED_RATING ( type: esriFieldTypeInteger, alias: Latest Detailed Rating Score, editable: true, nullable: true, defaultValue: null, modelName: LATEST_DETAILED_RATING )
• INSPECTION_DUE ( type: esriFieldTypeInteger, alias: Inspection Due, editable: true, nullable: true, defaultValue: null, modelName: INSPECTION_DUE )
• 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 )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: sys_updated_date )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: GlobalID )
• ESRI_OID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: ESRI_OID )
• GDB_ARCHIVE_OID ( type: esriFieldTypeInteger, alias: GDB_ARCHIVE_OID, editable: true, nullable: false, defaultValue: null, modelName: GDB_ARCHIVE_OID )
• GDB_GEOMATTR_DATA ( type: esriFieldTypeBlob, alias: GDB_GEOMATTR_DATA, editable: true, nullable: true, defaultValue: null, modelName: GDB_GEOMATTR_DATA )
• GDB_FROM_DATE ( type: esriFieldTypeDate, alias: GDB_FROM_DATE, editable: true, nullable: false, length: 8, defaultValue: null, modelName: GDB_FROM_DATE )
• GDB_TO_DATE ( type: esriFieldTypeDate, alias: GDB_TO_DATE, editable: true, nullable: false, length: 8, defaultValue: null, modelName: GDB_TO_DATE )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Geohazards AUM Site Inventory
  Description:
  Prototype:
  GDB_TO_DATE: -2209161600000
  NLFID: null
  OBJECTID: 0
  GDB_FROM_DATE: -2209161600000
  GDB_GEOMATTR_DATA: null
  COUNTY_CD: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  CTL_BEGIN_NBR: null
  CTL_END_NBR: null
  STL_BEGIN_NBR: null
  STL_END_NBR: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  LATITUDE_DD_END: null
  LONGITUDE_DD_END: null
  PERP_DATE: null
  STATUS: null
  PID: null
  LET_PLANS_URL: null
  GDB_ARCHIVE_OID: 0
  LEGACY_GLOBAL_ID: null
  ROAD_FUNCTIONAL_CLASS: null
  FEDERAL_AID_ELIGIBLE: null
  ROAD_WIDTH: null
  OUTSIDE_SHOULDER_WIDTH: null
  INSIDE_SHOULDER_WIDTH: null
  MEDIAN_WIDTH: null
  LANE_NUM_PER_DIRECTION: null
  SURFACE_TYPE_LEFT: null
  SURFACE_TYPE_RIGHT: null
  BASE_TYPE_LEFT: null
  BASE_TYPE_RIGHT: null
  SHOULDER_TYPE: null
  MEDIAN_TYPE: null
  SPEED_LIMIT: null
  AADT_TOTAL_NUMBER: null
  AADT_TRUCK_NUMBER: null
  QUADRANGLE_NAME: null
  INSPECTION_DUE: null
  sys_updated_date: null
  TOWNSHIP: null
  SECTION: null
  ODNR_MINE_MAP: null
  API: null
  SITE_DESCRIPTION: null
  SECONDARY_MINING_EVID: null
  SPECIAL_MINE_FEATURE: null
  SPECIAL_MINE_COMMENT: null
  AGE_OF_MINING: null
  MINE_PROBLEM_REPORTED: null
  MINING_PROBLEM_COMMENT: null
  ROAD_SURFACE_ELEVATION: null
  BEDROCK_SURFACE_ELEV: null
  BASE_ELEVATION_OF_SEAM: null
  MINE_SEAM_THICKNESS: null
  UNCONSOLID_THICKNESS: null
  BEDROCK_THICKNESS: null
  OVERBURDEN_THICKNESS: null
  UNCONSOLID_ROCK_THICK: null
  OVERBUR_INTERVAL_RATIO: null
  OVERBURDEN_COMMENT: null
  ASSOC_SITE_SCREENING: null
  ASSOC_SITE_COMMENTS: null
  INFO_SOURCE: null
  PHOTO_LINK_TO_FALCON: null
  ANNUAL_MAINT_FREQUENCY: null
  NBR_OF_MINE_OPENINGS: null
  NBR_OF_VERTICAL_SHAFTS: null
  NBR_OF_SURFACE_DEFORM: null
  LATEST_ED: null
  LATEST_ED_NBR: null
  LATEST_ED_DATE: null
  LATEST_TIER: null
  LATEST_DETAILED_RATING: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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