Name: Possible Local Road Culvert Locations
Display Field: FEATURE_UNDER_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
Description: This data set begins the process to collect the inventory data on small bridge and large pipe structures between 6 feet and 20 feet in span length, as measured along the roadway required by the current state budget. Locations must be field verified and basic structure data gathered. Data from this data set can be downloaded from the WisDOT Open GIS Data website, filtered for the specific county or municipality doing the collections. Data can be downloaded as a CSV, KML or shape files depending on the end user's capabilities to view and use the data. Once downloaded, the locations must be field verified and updated using the Excel template spreadsheet provided by BOS. A word and editable PDF have also been created for those that prefer printed copies or for structures that are not included in the data set provided. These files can be found at the following link, along with basic instructions.
All found structures shall be consolidated into the template spreadsheet using the provided headings and data lists to be used to collect the inventory. Once complete, this spreadsheet will be sent back to the BOS State Ancillary Structures PM for inclusion into the HSIS database. Each county should consolidate the local municipalities into a single spreadsheet to send to BOS. It is critical that for this initial inventory, only fields shown on the form and spreadsheet are used to allow for efficient transfer of data into HSIS. Any critical findings or serious concerns regarding structures found shall be immediately forwarded to the structure's owner and the county so the condition issues can be addressed.
While the initial inventory is being collected, other procedures for inspection, maintenance, etc. will be developed.
Copyright Text: WisDOT, DTSD, BOS, WICDI, State Cartographer
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 283041.798648786
YMin: 224411.011265947
XMax: 778715.16031912
YMax: 727584.574057585
Spatial Reference: 3071 (3071)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[68,98,147,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- F_ (type: esriFieldTypeString, alias: Y/N, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- ESRIGNSS_LATTITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WI_CNTY_NM (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- WISLR_PTY_TYCD (type: esriFieldTypeString, alias: City-Town-Village, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- WISLR_PTY_NM (type: esriFieldTypeString, alias: Municipality Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- CULVERT_OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- CULVERT_LOCATION_TEXT (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- TOTAL_STRUCTURE_LENGTH (type: esriFieldTypeString, alias: Total Structure Length (FT), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- FEATURE_OVER (type: esriFieldTypeString, alias: Feature Over, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- FEATURE_UNDER (type: esriFieldTypeString, alias: Service Feature Under, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- FEATURE_UNDER_NAME (type: esriFieldTypeString, alias: Feature Under Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- STRUCTURE_TYPE (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- STRUCTURE_MATERIAL (type: esriFieldTypeString, alias: Structure Material, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- INVENTORY_DATE (type: esriFieldTypeString, alias: Inventory Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- INSPECTOR_NAME (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- CRITICAL_FINDING (type: esriFieldTypeString, alias: Critical Finding, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Templates:
Name: Possible Local Road Culvert Locations
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/31/2024 8:09:36 PM
Schema Last Edit Date: 1/31/2024 8:09:36 PM
Data Last Edit Date: 1/31/2024 8:09:36 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat