Hardwood Subwatershed
MPCA water resource staff identified Total Maximum Daily Load (TMDL) and Watershed Restoration and Protection Strategy (WRAPS) project boundaries as a central data element for the agency. A team of staff from the MPCA Watershed Division and the MPCA Information Systems Office worked together to collect and store this data in a central repository and distribute it to MPCA partners as needed. The team designed a geospatial database, developed a user guide, and developed communication and distribution strategies for the database.The resulting geospatial database is maintained by the MPCA Watershed Division and polygons are included in the database for all EPA-approved TMDL/WRAPS projects. Where possible, polygons are taken from existing published geospatial data layers but new delineations can be included when necessary. Polygon boundaries typically follow hydrologic watershed delineations but in certain cases TMDL/WRAPS projects are defined by administrative boundaries, such as Watershed Districts or Watershed Management Organizations, especially in the Twin Cities Metropolitan Area. New polygons are added to the database using the ‘append’ [no_test] command in ArcGIS. Attribute information is added for each polygon including the organization that created the data, creation date, date submitted to MPCA, and a series of identification codes that allow the database to be linked to other MPCA databases. If a new revised polygon is added that replaces an older polygon for the same project, the older version is saved and coded as ‘inactive.’This new spatial database will give MPCA staff and external partners the ability to see the spatial extent of Minnesota TMDL/WRAPS projects in a GIS context. The database can also be used in spatial analysis operations with other spatial data layers that map features in the environment such as feedlots, surface water discharge locations, and riparian areas. The availability of this data should help to support collaboration between various organizations involved in water resource management and impaired waters issues in Minnesota.
[{'name': 'OBJECTID_1', 'type': 'esriFieldTypeOID', 'alias': 'FID', 'domain': None}, {'name': 'OBJECTID', 'type': 'esriFieldTypeInteger', 'alias': 'OBJECTID', 'domain': None}, {'name': 'prj_name', 'type': 'esriFieldTypeString', 'alias': 'prj_name', 'length': 100, 'domain': None}, {'name': 'prj_id', 'type': 'esriFieldTypeString', 'alias': 'prj_id', 'length': 50, 'domain': None}, {'name': 'createDate', 'type': 'esriFieldTypeDate', 'alias': 'createDate', 'length': 8, 'domain': None}, {'name': 'data_org', 'type': 'esriFieldTypeString', 'alias': 'data_org', 'length': 50, 'domain': None}, {'name': 'data_descr', 'type': 'esriFieldTypeString', 'alias': 'data_descr', 'length': 50, 'domain': None}, {'name': 'submitDate', 'type': 'esriFieldTypeDate', 'alias': 'submitDate', 'length': 8, 'domain': None}, {'name': 'status', 'type': 'esriFieldTypeString', 'alias': 'status', 'length': 50, 'domain': None}, {'name': 'statusDate', 'type': 'esriFieldTypeDate', 'alias': 'statusDate', 'length': 8, 'domain': None}, {'name': 'Shape_Leng', 'type': 'esriFieldTypeDouble', 'alias': 'Shape_Leng', 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}, {'name': 'Shape.STArea()', 'type': 'esriFieldTypeDouble', 'alias': 'Shape.STArea()', 'domain': None}, {'name': 'Shape.STLength()', 'type': 'esriFieldTypeDouble', 'alias': 'Shape.STLength()', 'domain': None}]
[{'name': 'R159_pk', 'fields': 'OBJECTID_1', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'S108_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSFS', 'style': 'esriSFSSolid', 'color': [157, 205, 157, 255], 'outline': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [0, 0, 0, 255], 'width': 1}}, 'label': '', 'description': ''}, 'transparency': 0, 'labelingInfo': [{'labelPlacement': 'esriServerPolygonPlacementAlwaysHorizontal', 'where': None, 'labelExpression': '[prj_name]', 'useCodedValues': True, 'symbol': {'type': 'esriTS', 'color': [0, 0, 0, 255], 'backgroundColor': None, 'borderLineColor': None, 'borderLineSize': None, 'verticalAlignment': 'baseline', 'horizontalAlignment': 'left', 'rightToLeft': False, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'kerning': True, 'haloColor': None, 'haloSize': None, 'font': {'family': 'Arial', 'size': 10, 'style': 'normal', 'weight': 'bold', 'decoration': 'none'}}, 'minScale': 0, 'maxScale': 0}]}
nan
nan