{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "CatchBasin", "type": "Feature Layer", "description": "

Stormwater combination inlets, curb inlets, and drop inlets owned by the City of Durham and available for adoption through the Adopt-A-Drain program managed by the Public Works Department.<\/SPAN><\/P>

Definition query for export from Stormwater Nodes feature class managed by the Public Works Department:<\/SPAN><\/P>

STATUS = 'Active' And (TYPE = 'COMBO INLET' Or TYPE = 'CURB INLET' Or TYPE = 'DROP INLET') And (OWNER = 'CITY' Or OWNER = 'CITY-ROW')<\/SPAN><\/P><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "City of Durham Public Works Department", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 80, 168, 60, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8794580.67431737, "ymin": 4282396.881866121, "xmax": -8769573.911553705, "ymax": 4324181.793164006, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "nickname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 20, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "Creation date", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 255, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Last update", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Updated by", "length": 255, "domain": null }, { "name": "adoptedby", "type": "esriFieldTypeString", "alias": "Adopted By", "length": 255, "domain": null }, { "name": "adoptedon", "type": "esriFieldTypeDate", "alias": "Adopted On", "length": 8, "domain": null }, { "name": "nickname", "type": "esriFieldTypeString", "alias": "Nickname", "length": 255, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Nearest Address", "length": 255, "domain": null }, { "name": "publicview", "type": "esriFieldTypeString", "alias": "Publicly Visible", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator.", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Asset Type", "length": 16, "domain": null }, { "name": "ADOPTED", "type": "esriFieldTypeString", "alias": "Adopted", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator.", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R541_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_541", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S502_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GISDiv.GISDIV.PW_CatchBasinActivities", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "globalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "20349bcf71ce46fa82079f18f6f3832d" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "CatchBasinVolunteers", "type": "Feature Layer", "description": "

A feature layer used to store catch basin volunteers and clearing activities for use in the Adopt-A-Drain program managed by the City of Durham Public Works Department.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 117, 53, 163, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "pocfirstname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pocfirstname", "type": "esriFieldTypeString", "alias": "First Name", "length": 150, "domain": null }, { "name": "poclastname", "type": "esriFieldTypeString", "alias": "Last Name", "length": 150, "domain": null }, { "name": "pocfullname", "type": "esriFieldTypeString", "alias": "Full Name", "length": 300, "domain": null }, { "name": "pocphone", "type": "esriFieldTypeString", "alias": "Phone Number", "length": 15, "domain": null }, { "name": "pocemail", "type": "esriFieldTypeString", "alias": "Email", "length": 150, "domain": null }, { "name": "fulladdr", "type": "esriFieldTypeString", "alias": "Address", "length": 500, "domain": null }, { "name": "municipality", "type": "esriFieldTypeString", "alias": "Municipality", "length": 150, "domain": null }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "zipcode", "type": "esriFieldTypeString", "alias": "Zip Code", "length": 5, "domain": null }, { "name": "team", "type": "esriFieldTypeString", "alias": "Team", "length": 100, "domain": null }, { "name": "username", "type": "esriFieldTypeString", "alias": "Username", "length": 255, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "Status", "length": 100, "domain": { "type": "codedValue", "name": "ApprovalStatus", "description": "Pending, Approved or Denied", "codedValues": [ { "name": "Pending", "code": "Pending" }, { "name": "Approved", "code": "Approved" }, { "name": "Denied", "code": "Dened" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited On", "length": 8, "domain": null }, { "name": "orgorbiz", "type": "esriFieldTypeString", "alias": "Organization or Business?", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator.", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "orgname", "type": "esriFieldTypeString", "alias": "Organization Name", "length": 255, "domain": null }, { "name": "orgtype", "type": "esriFieldTypeString", "alias": "Organization Type", "length": 50, "domain": { "type": "codedValue", "name": "OtherOrgType", "description": "", "codedValues": [ { "name": "City/County", "code": "City/County" }, { "name": "Civic/Club", "code": "Civic/Club" }, { "name": "Corporate/Business", "code": "Corporate/Business" }, { "name": "Facility", "code": "Facility" }, { "name": "Faith-Based", "code": "Faith-Based" }, { "name": "Individual", "code": "Individual" }, { "name": "NonProfit", "code": "NonProfit" }, { "name": "School", "code": "School" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R543_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_543", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S503_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "GISDiv.GISDIV.PW_CatchBasinActivities", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "globalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "20349bcf71ce46fa82079f18f6f3832d" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "CatchBasinActivities", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "username", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "activitydate", "type": "esriFieldTypeDate", "alias": "Activity Date", "length": 8, "domain": null }, { "name": "cbglobalid", "type": "esriFieldTypeGUID", "alias": "Catch Basin GlobalID", "length": 38, "domain": null }, { "name": "username", "type": "esriFieldTypeString", "alias": "Username", "length": 255, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited On", "length": 8, "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 4000, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "cbvglobalid", "type": "esriFieldTypeGUID", "alias": "Catch Basin Volunteer GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R542_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_542", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1058cbvglobalid", "fields": "cbvglobalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1058cbglobalid", "fields": "cbglobalid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GISDiv.GISDIV.PW_CatchBasin", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "cbglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "GISDiv.GISDIV.PW_CatchBasinVolunteers", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "cbvglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "20349bcf71ce46fa82079f18f6f3832d" } ] }