Connected Sewer Service Areas
This data was created through the modification of an existing sewer service dataset from the CTs Office of Policy and Management (OPM), in addition to sewer data from the Southeastern Connecticut Council Of Government (SCCOG) and the Town of Stonington. It also includes data from the Sewer Service Area 2018 file in areas where the OPM dataset was not as current.The OPM data was modified by reducing the extensive categories which represent all areas containing sewers to a "Connected" classification and everything that falls outside as "Not Connected"PROCESSSCCOG DataData was clipped to individual town boundaries for all 21 towns with sewer information within the SCCOG. The "Existing" category from attribute table was extracted via selection to create the "Connected" areas for 19/21 towns. The Town of Stonington data was merged with the SCCOG data as both had areas which were not included in the other. The North Stonington data was combined with SSA 2018 data to get the most accurate representation for that town.OPM DataData was modified to isolate the undefined and fragmented categories, (QA- using town websites, PDF maps and local contacts for verification where available) then Clipped to town boundaries. All the areas that are connected to sewers were Dissolved, only maintaining the key fields listed and described below. The datasets were combined using the Merge tool to get all the connected sewer service areas in the state. This Connected feature-class was Erased from the CT State by towns feature-class to obtain the "Not Connected" areas which and then Merged to ascertain a feature-class containing areas that are Connected and Not Connected.FIELDSTOWN- Represents all the towns/ cities with the state of CTs boundaries.CNTY_NAME- Represents the eight (8) county names to which each town belongs to.SEWERS- This field has two classes "Existing" and "No Sewer" and this identifies if a town has sewers existing within its boundary or not.SEWER-STATUS- The Sewer Status field represents the areas within in each town or city that is either "Connected" or "Not Connected" to sewers.TREATMENTFACILITY- This field represents the sewer service treatment facility (endpoint) that processes the waste for each town. (Will be updated momentarily). For towns without sewers “Not Applicable” will be the designated value.PASSTHROUGH- This field will identify if the wastewater passthrough other towns on the way to the endpoint denoted by a "Yes" or "No" category. An Excel file will be available with the passthrough details if this field has a "Yes" value. Towns with No Sewers will be categorized as “Not Applicable”.  (Will be updated momentarily).
nan
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'TOWN', 'type': 'esriFieldTypeString', 'alias': 'Town', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CNTY_NAME', 'type': 'esriFieldTypeString', 'alias': 'County Name', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Sewers', 'type': 'esriFieldTypeString', 'alias': 'Sewers', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SewerStatus', 'type': 'esriFieldTypeString', 'alias': 'Sewer Status', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'TreatmentFacility', 'type': 'esriFieldTypeString', 'alias': 'Treatment Facility', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'PassThrough', 'type': 'esriFieldTypeString', 'alias': 'Pass Through', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Shape__Area', 'type': 'esriFieldTypeDouble', 'alias': 'Shape__Area', 'sqlType': 'sqlTypeDouble', 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'Shape__Length', 'type': 'esriFieldTypeDouble', 'alias': 'Shape__Length', 'sqlType': 'sqlTypeDouble', 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__CONNECTE__F4B70D85C4B33B46', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_1723.CONNECTED_SEWER_SERVICE_AREAS_CONNECTED_SEWER_SERVICE_AREAS_Shape_sidx', 'fields': 'Shape', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Spatial'}, {'name': 'Shape__Area_Index', 'fields': 'Shape__Area', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}, {'name': 'Shape__Length_Index', 'fields': 'Shape__Length', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}]
nan
{'renderer': {'type': 'uniqueValue', 'field1': 'SewerStatus', 'field2': None, 'field3': None, 'defaultSymbol': None, 'defaultLabel': None, 'uniqueValueInfos': [{'symbol': {'type': 'esriSFS', 'style': 'esriSFSSolid', 'color': [0, 255, 197, 255], 'outline': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [110, 110, 110, 255], 'width': 0.4}}, 'value': 'Connected', 'label': 'Connected', 'description': ''}, {'symbol': {'type': 'esriSFS', 'style': 'esriSFSSolid', 'color': [52, 52, 52, 255], 'outline': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [110, 110, 110, 255], 'width': 0.4}}, 'value': 'Not Connected', 'label': 'Not Connected', 'description': ''}], 'fieldDelimiter': ','}, 'transparency': 0, 'labelingInfo': None}
[{'id': 'Connected', 'name': 'Connected', 'domains': {}, 'templates': [{'name': 'Connected', 'description': '', 'drawingTool': 'esriFeatureEditToolPolygon', 'prototype': {'attributes': {'TreatmentFacility': None, 'PassThrough': None, 'TOWN': None, 'CNTY_NAME': None, 'Sewers': None, 'SewerStatus': 'Connected'}}}]}, {'id': 'Not Connected', 'name': 'Not Connected', 'domains': {}, 'templates': [{'name': 'Not Connected', 'description': '', 'drawingTool': 'esriFeatureEditToolPolygon', 'prototype': {'attributes': {'TreatmentFacility': None, 'PassThrough': None, 'TOWN': None, 'CNTY_NAME': None, 'Sewers': None, 'SewerStatus': 'Not Connected'}}}]}]
[]