{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "Emergency Work Request", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 50000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "Transportation Online Permitting System - TOPS -\nEmergency Work Request", "copyrightText": "DDOT", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -8584375.7419, "ymin": 4694974.704499997, "xmax": -8561548.2658, "ymax": 4720953.540399998, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "4480b1e7aa53e5f80abfc2b932c3d308", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADPElEQVRIieXWX4hVVRTH8c+5MzqTY2Ra450/khRDRvkQZD3Ugw8GJYVGBAZBUQgTVJNEUdFkaZnQH6kJHIjCh6BAkikUhaQG8aF/0ENEykAhM+fcqzWlJTbVzD2xOzu4On9oUHxpwebuvc4++3vW3r+11210nqzx/wnKSaqsyFmV04F5CZWErxvY28rJswIFQIW7K2zG5cGXnP7cOGMZ/TVe6GR01qAqLRXexdo691DCIZzK6cT1aMajJdZVWVvm8/8M+pa5NfbhpugaKPFsmW/q5/3MRWM8iKdQrjFYZeVUsClBC9gWIXlOTwd9McrleeGfh0Oj7O9ia8YA9mJpjYERrjlzGyeBwmI1ukM/4fl2+o6yeIIdNW6pn9tCWqW7zO6MWxWRlEs8gw0zgmo8hhIOl3nxRy78i0Esw5GEd2r8khTQ1TU+rLImwl5StO5j9Nar8TRQTkOF22L/zYTxjKcj5NM5rLmEkyM0L6EvKyLfXqN/iCua2T7GpiCQiSLCnVOCqizBojj8OP7eF1Scc+8ESyvsbaAto7edLRm3h8jms2ohezK+wI05104LSlgcciPYHNKoqnIQYgfDKZuSImGDbR5mW86+hNUx6j0JI2GNnDZ1dhooJF84nGATXHCCX1uKvFwQ3Ufqplc6Gatycfy4U9EfFFk/ngzCyL+dnKu6OJDxFVZk3PEHW+cWjy9r4LWfmJ9zf3AkHIzvLYvjdFpQ0H5WJOVy3IkD2IoP8HYTD7TzXJibsiQoLkCxLyRzTI2uCNo/U0TB3o+g9SmvtLMr5eWEx7ErK770OK6M7x9qKAQTUiMoLtj3Zb6cEdTIG+P0oDVh5w+s7OCJjM/wJK5TCKKKHXPYcim/pTxcdy/2JsXZTg8KSZayPimulRuaGEy5K0QWIhqiaRHNCzkRz6SxwsacjXGJgTbemyKAydbBRyk9Ca8HWMLhjLfCWSV8N87vabF1N1d4KG5jsIMl7jkzmmlBEdaXFldOALTikdBiDVJfl8Lx5PQfZ8PV/DnrwhciO8Yn4wVkXRRJvY1id4lXzywhswIFixfjltBGiuups5HmnKNlhpN/cvsc/zmJNWbacu1cgc7Gzhvob1XQA//GypUOAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "RequestID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "RequestID", "type": "esriFieldTypeInteger", "alias": "RequestID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RequestID" }, { "name": "RequestNumber", "type": "esriFieldTypeString", "alias": "RequestNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RequestNumber" }, { "name": "EmergencyTypeCode", "type": "esriFieldTypeString", "alias": "EmergencyTypeCode", "domain": { "type": "codedValue", "name": "TOPSEWREmergencyType", "description": "TOPS Emergency Work Request Emergency Type", "codedValues": [ { "name": "Electric Overhead", "code": "ElectricOver" }, { "name": "Electric Underground", "code": "ElectricUnder" }, { "name": "Gas", "code": "Gas" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Telecom Aboveground", "code": "TelecomAbove" }, { "name": "Telecom Underground", "code": "TelecomUnder" }, { "name": "Traffic Signal Outage", "code": "TRAFFICSIGNAL" }, { "name": "Water", "code": "Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EmergencyTypeCode" }, { "name": "EmergencyCauseID", "type": "esriFieldTypeInteger", "alias": "EmergencyCauseID", "domain": { "type": "codedValue", "name": "TOPSEWREmergencyCause", "description": "TOPS Emergency Work Request Emergency Cause", "codedValues": [ { "name": "Fire Hydrant Break / Leak", "code": 1 }, { "name": "Fire Hydrant Control Valve Break / Leak", "code": 2 }, { "name": "Struck Fire Hydrant", "code": 3 }, { "name": "Water Main Break / Leak", "code": 4 }, { "name": "Valve Break/Leak", "code": 5 }, { "name": "Water Service line Break / Leak", "code": 6 }, { "name": "Sanitary Sewer Backup", "code": 7 }, { "name": "Sanitary Sewer Collapse", "code": 8 }, { "name": "Sanitary Sewer Obstruction", "code": 9 }, { "name": "Sanitary Sewer Lateral Break / Collapse", "code": 10 }, { "name": "Storm / Combined Sewer Backup", "code": 11 }, { "name": "Storm / Combined Sewer Collapse", "code": 12 }, { "name": "Storm / Combined Sewer Obstruction", "code": 13 }, { "name": "Storm Sewer Inlet Break / Collapse / Strike", "code": 14 }, { "name": "Main line gas leak", "code": 15 }, { "name": "Lateral gas leak", "code": 16 }, { "name": "Outage", "code": 17 }, { "name": "Service Outage", "code": 18 }, { "name": "Hazardous Condition", "code": 19 }, { "name": "Overload/Safety", "code": 20 }, { "name": "Dig-in/Safety", "code": 21 }, { "name": "Pole Struck/Damaged", "code": 22 }, { "name": "Broken Pole", "code": 23 }, { "name": "Wire Down", "code": 24 }, { "name": "Other", "code": 25 }, { "name": "Manhole Repair", "code": 26 }, { "name": "Service Breakdown", "code": 27 }, { "name": "Pole Down", "code": 28 }, { "name": "Flashing Lights", "code": 29 }, { "name": "Lights Out", "code": 30 }, { "name": "Signal Malfunction", "code": 31 }, { "name": "Crosswalk Malfunction", "code": 32 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EmergencyCauseID" }, { "name": "EffectiveDate", "type": "esriFieldTypeDate", "alias": "EffectiveDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EffectiveDate" }, { "name": "ExpirationDate", "type": "esriFieldTypeDate", "alias": "ExpirationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ExpirationDate" }, { "name": "StartTime", "type": "esriFieldTypeString", "alias": "StartTime", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "StartTime" }, { "name": "ApplicationDate", "type": "esriFieldTypeDate", "alias": "ApplicationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ApplicationDate" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "TOPSEWRStatus", "description": "TOPS Emergency Work Request Status", "codedValues": [ { "name": "Cancelled", "code": "CANCELLED" }, { "name": "Permit Applied For", "code": "PERMITAPPLIED" }, { "name": "Rejected", "code": "REJECTED" }, { "name": "Pending Permit\nPending Permit", "code": "SUBMITTED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "LocationDetail", "type": "esriFieldTypeString", "alias": "LocationDetail", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LocationDetail" }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "LocationDescription", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "LocationDescription" }, { "name": "LocationFullDescription", "type": "esriFieldTypeString", "alias": "LocationFullDescription", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LocationFullDescription" }, { "name": "ConstructionTrackingNumber", "type": "esriFieldTypeInteger", "alias": "ConstructionTrackingNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConstructionTrackingNumber" }, { "name": "OccupancyTrackingNumber", "type": "esriFieldTypeInteger", "alias": "OccupancyTrackingNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OccupancyTrackingNumber" }, { "name": "SubmissionDate", "type": "esriFieldTypeDate", "alias": "SubmissionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SubmissionDate" }, { "name": "RejectedDate", "type": "esriFieldTypeDate", "alias": "RejectedDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RejectedDate" }, { "name": "LastUpdateDate", "type": "esriFieldTypeDate", "alias": "LastUpdateDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdateDate" }, { "name": "CancelledDate", "type": "esriFieldTypeDate", "alias": "CancelledDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CancelledDate" }, { "name": "StartTimeAMPM", "type": "esriFieldTypeString", "alias": "StartTimeAMPM", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartTimeAMPM" }, { "name": "ApplicationTime", "type": "esriFieldTypeString", "alias": "ApplicationTime", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ApplicationTime" }, { "name": "NotificationSent", "type": "esriFieldTypeDate", "alias": "NotificationSent", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "NotificationSent" }, { "name": "EWR_Location_ID", "type": "esriFieldTypeInteger", "alias": "EWR_Location_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EWR_Location_ID" }, { "name": "Ward", "type": "esriFieldTypeString", "alias": "Ward", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Ward" }, { "name": "FiscalYear", "type": "esriFieldTypeInteger", "alias": "FiscalYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FiscalYear" }, { "name": "Quadrant", "type": "esriFieldTypeString", "alias": "Quadrant", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Quadrant" }, { "name": "ZipCode", "type": "esriFieldTypeString", "alias": "ZipCode", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ZipCode" }, { "name": "ANC", "type": "esriFieldTypeString", "alias": "ANC", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "ANC" }, { "name": "SMD", "type": "esriFieldTypeString", "alias": "SMD", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "SMD" }, { "name": "NeighborhoodClusters", "type": "esriFieldTypeString", "alias": "NeighborhoodClusters", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NeighborhoodClusters" }, { "name": "NeighborhoodNames", "type": "esriFieldTypeString", "alias": "NeighborhoodNames", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NeighborhoodNames" }, { "name": "BID", "type": "esriFieldTypeString", "alias": "BID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BID" }, { "name": "AWI", "type": "esriFieldTypeString", "alias": "AWI", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "AWI" }, { "name": "EDZ", "type": "esriFieldTypeString", "alias": "EDZ", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EDZ" }, { "name": "NIF", "type": "esriFieldTypeString", "alias": "NIF", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "NIF" }, { "name": "HistoricDistrict", "type": "esriFieldTypeString", "alias": "HistoricDistrict", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HistoricDistrict" }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Zoning" }, { "name": "PUD", "type": "esriFieldTypeString", "alias": "PUD", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PUD" }, { "name": "CFAR", "type": "esriFieldTypeString", "alias": "CFAR", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CFAR" }, { "name": "PSA", "type": "esriFieldTypeString", "alias": "PSA", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PSA" }, { "name": "PD", "type": "esriFieldTypeString", "alias": "PD", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PD" }, { "name": "ProblemDetails", "type": "esriFieldTypeString", "alias": "ProblemDetails", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "ProblemDetails" }, { "name": "StatusDescription", "type": "esriFieldTypeString", "alias": "StatusDescription", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "StatusDescription" }, { "name": "XCoord", "type": "esriFieldTypeDouble", "alias": "XCoord", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "XCoord" }, { "name": "YCoord", "type": "esriFieldTypeDouble", "alias": "YCoord", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YCoord" }, { "name": "OnSegX", "type": "esriFieldTypeDouble", "alias": "OnSegX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OnSegX" }, { "name": "OnSegY", "type": "esriFieldTypeDouble", "alias": "OnSegY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OnSegY" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R21_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I37StatusDescrip", "fields": "StatusDescription", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I37RequestNumber", "fields": "RequestNumber", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I37RequestID", "fields": "RequestID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_eweStatus", "fields": "Status", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S11_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Emergency Work Request", "description": "", "prototype": { "attributes": { "Longitude": null, "RequestID": null, "RequestNumber": null, "EmergencyTypeCode": null, "EmergencyCauseID": null, "EffectiveDate": null, "ExpirationDate": null, "StartTime": null, "ApplicationDate": null, "Status": " ", "LocationDetail": null, "LocationDescription": null, "LocationFullDescription": null, "ConstructionTrackingNumber": null, "OccupancyTrackingNumber": null, "SubmissionDate": null, "RejectedDate": null, "LastUpdateDate": null, "CancelledDate": null, "StartTimeAMPM": null, "ApplicationTime": null, "NotificationSent": null, "EWR_Location_ID": null, "Ward": null, "FiscalYear": null, "Quadrant": null, "ZipCode": null, "ANC": null, "SMD": null, "NeighborhoodClusters": null, "NeighborhoodNames": null, "BID": null, "AWI": null, "EDZ": null, "NIF": null, "HistoricDistrict": null, "Zoning": null, "PUD": null, "CFAR": null, "PSA": null, "PD": null, "ProblemDetails": null, "StatusDescription": null, "XCoord": null, "YCoord": null, "OnSegX": null, "OnSegY": null, "Latitude": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }