Name: Environmental Inspection

Display Field: FileNum

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: For the environmental inspection of DNR NRO Lease and other sites.

Copyright Text: DNR NRO MLW Conveyances Team

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -5120900
YMin: 1900
XMax: 13752085.612677
YMax: 17297321.16068
Spatial Reference: 102006 (3338)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"3719e4d831eedb2d78365f762f323338","imageData":"iVBORw0KGgoAAAANSUhEUgAAAC4AAAArCAYAAAAHdLqEAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAABS9JREFUWIXtmX9sU1UUxz9ljMssOHiLieWnisKE4QQM4ICBISCSgWF0OAgjwAwQFMQZgQgIKkKCqPgLwQQxlizoooiEiKhDQYnBDAEdESHI1PCC4BUCDziDbf5xu+4HXdeWdrLE7z9tz3vnnE9ezrv3nNuWNFO1/K8BotX/4A2oHXA2HoHjCZ6ilFogIvPjETye4ONE5BGgeYEr8Ap0sSyrv9Z6X6zjxwu8HYrhCDiO4wWaDfhYERNbRMYTh3KJC7iCHKn5eYdlWX201j/GMkc8wNu6FQ9KLXJ/udzw4FlaSATI6QdFJQCMBxbFMknMwZUiRwQmZcCc0QZcRHp4PJ4027Z/jlWeWIO7LRhtAzkDIa0LKEAArbUXuGHBH7IFBdDvTmijYEkOLC4KrC7LYpUopuCWRY7WkDsAOqUY27A0oAiANKA78GsscsUSvLVyGAMwYRC4/MbeXevc4wVWxCJZMPBsoCfAuHtpk5vJqMSWtG4s0OlzJM3cQBKYMqnWzUmw+GFYvhUmZfCMdyBTwgH7/TSl83yBJbQCeBc4FQp8BzAayN9yALYcCCdNjSYMgM4pdW3D0w144V7chXvpEWaoHpiHeFIpNVlETtW+GAz8IvAosBN4B0gORLKgyy2hs03OrCmTaqXfBiMawa0Aio9cY94OTBWRM/UvhKrxDzHNUSFwv98mq/NJvKcrLUJj1FV7N+x8vuHrF8thzTbOFR8JPKRyYCGwBqgK5tPYy3kCyFRKPSciC49oVPp82DgTmTQU1SohEvzgOn4KZr3FpS/80Eqpo263O1drvT+UXzirylURWaSU+lJENgEdpq1H7T6MrMhD3ZrcqH9QVVbBZ/u5mrWKBDAvNeATkdkicqEx/7CXQxHZBaQDG4GsjXtQxaVUbnqCFoNSr63rUDp7EVZ+jKzaZjYr4ALwGPB+uDEiXcfPAGOAucCqMo0ashRezaNqxkhcN7VqPMChEzB9LRUlZQHo/UAucDQSkGg3oNcty/rGcZzNIpL6pA9X2yTIHx7a6e/zkL4AgAQApdRr/mG6PFKAqHdOrfVBpdRsoBig7+2N+6S0hfxhsOFrAHaLyLxo81/vlj8WoKsFqZ3CcxjX34AryJDrOHe5LnAL8drA46MgqV59O+Xwx2lI7VjX3qeb+RSTewzgiyZ31OCWZd1na90JILNX3Wu//QVz1nFleymJvtkwYTBUr/medjB1CLy3BzCTUdOCO46TDWZQ6NnZ2CqrYMdByF4Jghnf8tbCt79QtTQXlyfZLJvZAw24glECbsBpMnDLjdcWMyi0UXDuEry8hasvbA3EPA8cAgatL8a14wBVvrm4Bt8NfWvKRWEauqImAfd4PL1s274LzKBw+E+Y9TYVe44F4v0ATASOA08BL5ZpWmUug1fyYMYIyMsA317AlEvTgNu2Pb76+75jUGCqNAGoVEq9JCJLgCv+W1ZblrXLcZxCEele4IPvDlPVvYPZbBVkCbQGLscd3FJ4tf/cpKDm1TqplJoiIl/Vv19rXQL0Bd4Apn1UggtzbIG/xkcCn8YbvJsWetezbQOmB+uba8kBpgOfA+up1edjBoa4g2fX+n4ZeBp4MwL/D4DvMX1+ht82FrMKXWnIqb6iAa+u71KPxzPRtu2foohRhunzl4rIIqC9UuoBEdkZboBIwTsC/YF1QIFt25ci9K+tChF5trrP95+7xA18KKZUPonQr0GJyG5Mn78caAFUhuMXKfjmcANHqH8wg0TY80ik4PGArq2gg3EwNdv/Of8FBKixfRu1gqMAAAAASUVORK5CYII=","contentType":"image/png","width":34,"height":32,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Date_time (type: esriFieldTypeDate, alias: Date of site visit ***, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspector1 (type: esriFieldTypeSmallInteger, alias: Inspector 1 Name ***, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Heather McEachen], [2: Juile Smith], [3: Kelsey Stybr], ... 4 more ...)
• Inspector2 (type: esriFieldTypeSmallInteger, alias: Inspector 2 Name, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Heather McEachen], [2: Juile Smith], [3: Kelsey Stybr], ... 4 more ...)
• Inspector3 (type: esriFieldTypeSmallInteger, alias: Inspector 3 Name, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Heather McEachen], [2: Juile Smith], [3: Kelsey Stybr], ... 4 more ...)
• FileTyp (type: esriFieldTypeSmallInteger, alias: Select file type for master material site, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: ADL], [2: LAS], [3: RST], ... 2 more ...)
• FileNum (type: esriFieldTypeString, alias: File number for master material site: eg 123456, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Proj_desc (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Doc_rev (type: esriFieldTypeSmallInteger, alias: Was documentation reviewed before inspection?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Area_affct (type: esriFieldTypeSmallInteger, alias: Is the area populated / could be affected by project?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Ag_signs (type: esriFieldTypeSmallInteger, alias: Signs of agricultural activity?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Past_use (type: esriFieldTypeSmallInteger, alias: Past use of site visibly discernable?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Past_desc (type: esriFieldTypeString, alias: >>If yes, what was use?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Rds_trails (type: esriFieldTypeSmallInteger, alias: Roads/trails/parking facilities present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Rds_dump (type: esriFieldTypeSmallInteger, alias: >>If yes, evidence of illicit dumping?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Rds_haz (type: esriFieldTypeSmallInteger, alias: >>If yes, evidence of hazardous/petroleum spills?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Vhcl_hvyeq (type: esriFieldTypeSmallInteger, alias: Vehicles/heavy equipment present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Structures (type: esriFieldTypeSmallInteger, alias: Buildings/structures presnt?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Strct_con (type: esriFieldTypeSmallInteger, alias: >>If yes, are structures in disrepair/disuse or poor condition?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• PCBs (type: esriFieldTypeSmallInteger, alias: >>If yes, Evidence of PCBs, ACM, or LBP in structure/on property?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• PCBs_desc (type: esriFieldTypeString, alias: >>>>If yes, describe evidence/explain., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Heat_src (type: esriFieldTypeSmallInteger, alias: >>If yes, source of heating?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Gas], [2: Electric], [3: Oil], ... 2 more ...)
• Drains (type: esriFieldTypeSmallInteger, alias: >>If yes, drains or sumps present in building?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Corrosion (type: esriFieldTypeSmallInteger, alias: >>If yes, stains or corrosion within building?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Septic (type: esriFieldTypeSmallInteger, alias: Visible septic tanks, leach fields, or sewage disposal?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Sept_cndtn (type: esriFieldTypeSmallInteger, alias: >>If yes, in disrepair, leaking, or need removal?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Pot_water (type: esriFieldTypeSmallInteger, alias: Source of potable water on property?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• H2O_src (type: esriFieldTypeSmallInteger, alias: >>If yes, water source?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Surface Water], [2: Groundwater], [3: Unknown])
• H2O_meth (type: esriFieldTypeSmallInteger, alias: >>If yes, method of water withdrawl?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Well], [2: Infiltration gallery], [3: Other], ... 1 more ...)
• H2O_treat (type: esriFieldTypeString, alias: >>If yes, type of water treatment method?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• H2O_stor (type: esriFieldTypeString, alias: >>If yes, water storage system?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pipes (type: esriFieldTypeSmallInteger, alias: Fill or vent pipes sticking up from ground?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Wells (type: esriFieldTypeSmallInteger, alias: Abandoned/closed wells present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Tanks (type: esriFieldTypeSmallInteger, alias: Empty aboveground tanks present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Transfrmr (type: esriFieldTypeSmallInteger, alias: Electrical transformers present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Basins (type: esriFieldTypeSmallInteger, alias: Catch basins/lagoons/pits present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Warnings (type: esriFieldTypeSmallInteger, alias: Warning signs posted?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Warn_desc (type: esriFieldTypeString, alias: >>If yes, for what?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Surf_contm (type: esriFieldTypeSmallInteger, alias: Evidence of surface or subsurface contamination?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Contm_desc (type: esriFieldTypeString, alias: >>If yes, describe contamination, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ext_contam (type: esriFieldTypeSmallInteger, alias: Contamination migration pathway onto site from elsewhere?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Ext_desc (type: esriFieldTypeString, alias: >>If yes, describe contamination pathway, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Haz_strg (type: esriFieldTypeSmallInteger, alias: Evidence of hazardous waste disposal/storage?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Odors (type: esriFieldTypeSmallInteger, alias: Strong odors present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Odors_desc (type: esriFieldTypeString, alias: >>If yes, explain/describe odors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Staining (type: esriFieldTypeSmallInteger, alias: Unusual colors/staining?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Stain_desc (type: esriFieldTypeString, alias: >>If yes, describe staining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Drums (type: esriFieldTypeSmallInteger, alias: Abandoned drums or other containers?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Veg_stress (type: esriFieldTypeSmallInteger, alias: Stressed vegetation?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Carcasses (type: esriFieldTypeSmallInteger, alias: Dead fish or game present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Chem (type: esriFieldTypeSmallInteger, alias: Evidence of chemicals?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Chem_safe (type: esriFieldTypeSmallInteger, alias: >>If yes, are the chemicals stored safely?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Fuel_stor (type: esriFieldTypeSmallInteger, alias: Fuel storage tanks (above or underground) present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Fuel_cklst (type: esriFieldTypeSmallInteger, alias: >>If yes, is the fuel tank checklist filled out?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Trash (type: esriFieldTypeSmallInteger, alias: Trash or dumping present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Fire (type: esriFieldTypeSmallInteger, alias: Evidence of fire, explosion, or other concerning activities?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Wetland (type: esriFieldTypeSmallInteger, alias: Evidence of wetlands?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• More_envir (type: esriFieldTypeSmallInteger, alias: Recommend further environmental evaluation?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Concerns (type: esriFieldTypeString, alias: Concerns/recommendations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc1 (type: esriFieldTypeString, alias: Caption for Image 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc2 (type: esriFieldTypeString, alias: Caption for Image 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc3 (type: esriFieldTypeString, alias: Caption for Image 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc4 (type: esriFieldTypeString, alias: Caption for Image 4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc5 (type: esriFieldTypeString, alias: Caption for Image 5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc6 (type: esriFieldTypeString, alias: Caption for Image 6, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc7 (type: esriFieldTypeString, alias: Caption for Image 7, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc8 (type: esriFieldTypeString, alias: Caption for Image 8, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc9 (type: esriFieldTypeString, alias: Caption for Image 9, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc10 (type: esriFieldTypeString, alias: Caption for Image 10, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc11 (type: esriFieldTypeString, alias: Caption for Image 11, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc12 (type: esriFieldTypeString, alias: Caption for Image 12, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc13 (type: esriFieldTypeString, alias: Caption for Image 13, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc14 (type: esriFieldTypeString, alias: Caption for Image 14, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Img_desc15 (type: esriFieldTypeString, alias: Caption for Image 15, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: Environmental Inspection
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/9/2022 3:45:11 AM

Schema Last Edit Date: 6/9/2022 3:45:11 AM

Data Last Edit Date: 6/9/2022 3:45:11 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat