Name: Material Site

Display Field: FileNum

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: For use in collecting data at DNR NRO Material Sale 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":"e8103a87bd15b56a2daad0bd3f4648c4","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAAcCAYAAAByDd+UAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAABCNJREFUSIm91nmIVlUYx/GPpV0t217aBs22aUNEQwsxNbWRVpNKMWihjdIWSoNqMtLCHCIkWyiLFmosMluoaFNbFSliSIoJJybqtWws4tUytYOS/XEf37kzjpYVPXA5557z3Od7fs957r2nu//Zuu+i/3HojxrshTVZlq1OKS3Hxv8KuH+WZVNTbbpYs8M7T6aUKEkyi7JKNjel9N6/Ad6g1qzUmnpr3olXRYZxSRrnMEuUTcbXuwLc07EatThPa2H0QpyBg9ADv6AFc9EWPmV1an2WfZeNTym9/3eA3Q32jibDqyN34HL0Q7cunrgeH2E6mtBq71RKizPZ2M7Q7YH9PViFZXgDp3by2YLN6BkL6IXTcBJm4gFU7J5q06tanaCQ3g7ALMuGp+Y0uTqwFCdGP8X9y3gkxgbjSpwZ6vfHPTH3QK7UME9ZbmSXwHRyeti2GltQgP2Am/B8J6VNccGLODdUz8QncS03IsuyMduqtwoslUpDKu9VBoCxGBcTFVyKxXF/D4bL0/h9qH0LEwJ6fii9E6eHkDFpurd0BG4YvGFSNeh1ERAeC1gN3sGAgsITUIf75AUzAWV5ekfGM2340gjsiY1VYNovnVMNNCjaNtRH/5mAbcL7+BlDcQymYlkofROTY8E34haU9ciybFhKaUn7Hv7q4Gp/W68l2sMijVsxG7MKKlsCOiWAj+NqefUe2+6WUupDsWhW6l1Vl8VYJdo6eTGs7QSDjwPYN+6b8Hso3LfgN0w/y4vAPrYo290q/IHdAgJrou0Vq24pBDog2k2FsR7Rbi6MHSx1VNjHemQq+A37oE/MvSGvyL6Yj4sCejtGh8/SaKcUov5UAL6Sv/ztwL7K1fV+hSGhZkQEe1he6kOwIhTtJ9+rL3BrxDkv2q3yPW235o7A7ubLvx0sicA9cVeoaAi/a0JpT/leLcMlMXdBLBBW4dnoT7TOQis7Au/1tEHmWGE39ZiIo3AKnsAVAW3AWTgkFlaO58dijvaCe7Kg7Wivtetqt7UmeskKE5Gn7xH5f/0yHCn/ayyV72nRGnAVSnH/bmQGRtlithu6AjLdFc413iv20IhDcVtAR2GRvFhWy9NZku9zTSHGp5GBsGx09lD6IK3rGsh6dSb4yquadTMb32GGPL09MTCuzrYJr2NSYaze52lGmlp02/5/eK3Xs3nZ9PRguluzbhrRKE9bnfwl7y1/TxN+lFft/SieZqZZrcHQzuG7PGKkyalBo1avec7C8KnX/l3NcHyAurIGy9QbLf9V/zUQXGyhBT401gseNVJT4XCRdgCbZm1pcOnGyoWVZ3YUduentkl+wihvO8JaNys7W9mBvrWHVboZaIu+Nqr1WU2pZl7bhLbnK9UP8D8BbrPTfSP/aE3pMF44OrZVj207t109ef9r+xNOazU7Z9A0ugAAAABJRU5ErkJggg==","contentType":"image/png","width":21,"height":21,"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)
• Access_typ (type: esriFieldTypeString, alias: Access type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: none], [2: exisiting road / open], [3: existing road / reveg], ... 6 more ...)
• Gated (type: esriFieldTypeSmallInteger, alias: Is site gated?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Mult_enter (type: esriFieldTypeSmallInteger, alias: Multiple entrances?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Site_activ (type: esriFieldTypeSmallInteger, alias: Evidence of active mining?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Flpn_activ (type: esriFieldTypeSmallInteger, alias: Are activities below OHW?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Grnd_water (type: esriFieldTypeSmallInteger, alias: Groundwater observed?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Mat_type1 (type: esriFieldTypeSmallInteger, alias: Primary material type?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: bedrock], [2: weathered bedrock], [3: fluvial], ... 4 more ...)
• Mat_type2 (type: esriFieldTypeSmallInteger, alias: Secondary material type?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: bedrock], [2: weathered bedrock], [3: fluvial], ... 4 more ...)
• OB (type: esriFieldTypeSmallInteger, alias: Overburden present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• OB_thick (type: esriFieldTypeString, alias: Overburden thickness, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: 0-3], [2: 3-6], [3: >6], ... 2 more ...)
• OB_type (type: esriFieldTypeString, alias: Overburden type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: silt], [2: colluvium], [3: peat], ... 4 more ...)
• Ice_pres (type: esriFieldTypeSmallInteger, alias: Ice present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Min_method (type: esriFieldTypeSmallInteger, alias: Mining method used (Select most appropriate), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: quarry], [2: borrow pit], [3: bailing], ... 1 more ...)
• Rec_method (type: esriFieldTypeSmallInteger, alias: Reclamation method (Select most appropriate), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: contemporaneous], [2: post-mining], [3: other], ... 2 more ...)
• Slope_stab (type: esriFieldTypeSmallInteger, alias: Are slopes stable?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Slope_note (type: esriFieldTypeString, alias: Describe slope stability at site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Slope_H_V (type: esriFieldTypeSmallInteger, alias: avg horiz to vertical ratio (see slope graphic), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: steeper than 1:1], [2: 1:1], [3: 2:1], ... 4 more ...)
• Slope_Lit (type: esriFieldTypeSmallInteger, alias: avg horiz to vertical ratio of Littoral Zones, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: steeper than 1:1], [2: 1:1], [3: 2:1], ... 4 more ...)
• Veg_est (type: esriFieldTypeSmallInteger, alias: Vegetation established?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Veg_pct (type: esriFieldTypeSmallInteger, alias: select veg % cover using Braun-Blaquet method, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 = less than 5% cover], [2: 2 = 6-25% cover], [3: 3 = 26-50% cover], ... 2 more ...)
• Veg_note (type: esriFieldTypeString, alias: Describe vegetation at site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Road_buff (type: esriFieldTypeSmallInteger, alias: Road buffer present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Site_buff (type: esriFieldTypeSmallInteger, alias: Does the buffer appear to be maintained?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Buff_note (type: esriFieldTypeString, alias: Buffer description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wildlife (type: esriFieldTypeSmallInteger, alias: Are wildlife or signs of wildlife observed?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• WL_note (type: esriFieldTypeString, alias: Describe wildlife observations or signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Stockpile (type: esriFieldTypeSmallInteger, alias: Stockpile(s) on site?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Stock_desc (type: esriFieldTypeString, alias: Stockpile description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Archology (type: esriFieldTypeString, alias: Archaeological site protection measures taken?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Erosion (type: esriFieldTypeSmallInteger, alias: Is erosion occurring on site?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Turbidity (type: esriFieldTypeSmallInteger, alias: Is turbid water running off site?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Ero_note (type: esriFieldTypeString, alias: Describe any evidence of erosion or turbidity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Trail (type: esriFieldTypeSmallInteger, alias: Is a GAU trail (< 5ft wide) present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Trail_note (type: esriFieldTypeString, alias: < 5ft? Mineral exposed? Resource degradation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Garbage (type: esriFieldTypeSmallInteger, alias: Potentially hazardous materials on site? (see Hazmat list), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: De Minimis])
• Garb_note (type: esriFieldTypeString, alias: Description of garbage, hazmat on site., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Insp_PF (type: esriFieldTypeSmallInteger, alias: Inspection Pass or Fail?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pass], [2: Fail])
• Site_stat (type: esriFieldTypeSmallInteger, alias: Does site status require follow-up activities?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• Stat_desc (type: esriFieldTypeString, alias: Describe follow-up recommendations., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MSPY_GIS (type: esriFieldTypeSmallInteger, alias: Is there a polygon for the material site in GIS?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• MSPY_OK (type: esriFieldTypeSmallInteger, alias: Does the polygon appear correctly?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• MSPY_Note (type: esriFieldTypeString, alias: Specify polygon location corrections if needed., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MS_desc (type: esriFieldTypeString, alias: General Notes, 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: Material Site
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