{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 42, "name": "Task - All", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 39, "name": "sde.sde.tbl_catch_basins", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{C7B5E95C-7CF3-4988-8CFF-651E3BED8ACC}" }, { "id": 51, "name": "sde.sde.tbl_stormwater_ponds", "relatedTableId": 44, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{27FF24B6-EE56-4D7D-806B-1BFB767E7DDF}" }, { "id": 102, "name": "sde.sde.tbl_trees", "relatedTableId": 29, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{5A921638-DDA1-4629-9B36-714DA1E9D065}" }, { "id": 18, "name": "sde.sde.tbl_gate_valves", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{4F8784E6-0C9B-4921-9CB9-7B20C6F6F48E}" }, { "id": 30, "name": "sde.sde.tbl_storm_manholes", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{466090BE-7EDD-4CFA-B853-F3A801311A5C}" }, { "id": 72, "name": "sde.sde.tbl_lights", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{3D3AF772-C350-41D2-AE28-8F0EB455033C}" }, { "id": 106, "name": "sde.sde.tbl_plantings_forestry", "relatedTableId": 30, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{A7557CB6-A714-4F62-9A8D-94AF31488B1F}" }, { "id": 2, "name": "sde.sde.tbl_water_towers", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{3737A198-3BBF-4DB7-8CF2-035CDB7D0DC7}" }, { "id": 65, "name": "sde.sde.tbl_sanitary_sewers", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{E14EC07E-2066-4BEE-B797-260E4546AF5E}" }, { "id": 35, "name": "sde.sde.tbl_flare_ends", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{F0918F10-2E81-432E-8830-27BC3FDB7830}" }, { "id": 48, "name": "sde.sde.tbl_storm_vaults", "relatedTableId": 60, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{FE55E66D-4DEF-4A54-BD38-DE36258A4383}" }, { "id": 81, "name": "sde.sde.tbl_light_lines", "relatedTableId": 22, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{25980DA0-5C30-4B4A-9375-D6896174A3CC}" }, { "id": 115, "name": "sde.sde.tbl_parcels", "relatedTableId": 32, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{D3C13CCA-F844-459D-9D5A-D482A980CBB5}" }, { "id": 85, "name": "sde.sde.tbl_fiber_optics", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{81399E22-26B1-4F60-8C38-3777DDD8BBE5}" }, { "id": 11, "name": "sde.sde.tbl_pressure_relief_valves", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{A6B8BA50-7937-464C-A1AF-7DF542FEF0D6}" }, { "id": 6, "name": "sde.sde.tbl_water_breaks", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{9641D8BF-92A9-4D53-8269-4733EFC100D6}" }, { "id": 92, "name": "sde.sde.tbl_signs", "relatedTableId": 26, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{A0B0F948-DFE8-4F7E-BED5-583B1F9B3399}" }, { "id": 14, "name": "sde.sde.tbl_hydrants", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{43076C60-A32E-4AEC-ADBD-A6D10A2E2DCF}" }, { "id": 57, "name": "sde.sde.tbl_sanitary_manholes", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{A510312B-9DB7-41E2-8479-5B320B1CC09D}" }, { "id": 22, "name": "sde.sde.tbl_water_lines", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{CDC823F3-63A2-42FC-A4BC-B88C5075DC9A}" }, { "id": 76, "name": "sde.sde.tbl_feed_points", "relatedTableId": 41, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{41AFEBE1-A230-4FF1-AD7C-7E469F8FFA05}" }, { "id": 111, "name": "sde.sde.tbl_streets", "relatedTableId": 31, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{A384C0E1-D9E8-4ADF-9F49-848793D7128D}" }, { "id": 68, "name": "sde.sde.tbl_force_mains", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{CD50E1C6-982F-4702-8801-D6AF5A705371}" }, { "id": 89, "name": "sde.sde.tbl_signals", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{FE282C0E-E293-4724-AEBA-4C50E546E228}" }, { "id": 27, "name": "sde.sde.tbl_wells", "relatedTableId": 43, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{515631AD-DD49-42CF-B53E-C242D78E4CC9}" }, { "id": 98, "name": "sde.sde.tbl_private_trees", "relatedTableId": 28, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{1960D4A5-F534-4377-88C0-914B8C72A928}" }, { "id": 60, "name": "sde.sde.tbl_lift_stations", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{9CFD866D-9870-4848-950A-AAF0CC506FB4}" }, { "id": 44, "name": "sde.sde.tbl_storm_sewers", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "composite": false, "catalogID": "{0B1365F4-FD61-4368-B9F6-53890730B6A3}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "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, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": 499357.1995000001, "ymin": 4977173.9669, "xmax": 505349.43200000003, "ymax": 4986888.521199999, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 197, 0, 255, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "taskname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "StatusName", "description": "StatusName", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "status" }, { "name": "datecreated", "type": "esriFieldTypeDate", "alias": "Date Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "datecreated" }, { "name": "datemodified", "type": "esriFieldTypeDate", "alias": "Date Modified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "datemodified" }, { "name": "datecompleted", "type": "esriFieldTypeDate", "alias": "Date Completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "datecompleted" }, { "name": "usercreated", "type": "esriFieldTypeString", "alias": "Created By", "domain": { "type": "codedValue", "name": "Username", "description": "Username", "codedValues": [ { "name": "Mike K", "code": "Mike K" }, { "name": "Steve S", "code": "Steve S" }, { "name": "Reade D", "code": "Reade D" }, { "name": "Dane N", "code": "Dane N" }, { "name": "Bob M", "code": "Bob M" }, { "name": "Trent W", "code": "Trent W" }, { "name": "Wade M", "code": "Wade M" }, { "name": "Rob K", "code": "Rob K" }, { "name": "Loren C", "code": "Loren C" }, { "name": "Connor P", "code": "Connor P" }, { "name": "Terry L", "code": "Terry L" }, { "name": "Dan D", "code": "Dan D" }, { "name": "Jeremy Q", "code": "Jeremy Q" }, { "name": "Jeff K", "code": "Jeff K" }, { "name": "Matt W", "code": "Matt W" }, { "name": "Jesse F", "code": "Jesse F" }, { "name": "Terese A", "code": "Terese A" }, { "name": "Nate B", "code": "Nate B" }, { "name": "Parks", "code": "Parks" }, { "name": "Streets", "code": "Streets" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "usercreated" }, { "name": "usermodified", "type": "esriFieldTypeString", "alias": "Modified By", "domain": { "type": "codedValue", "name": "Username", "description": "Username", "codedValues": [ { "name": "Mike K", "code": "Mike K" }, { "name": "Steve S", "code": "Steve S" }, { "name": "Reade D", "code": "Reade D" }, { "name": "Dane N", "code": "Dane N" }, { "name": "Bob M", "code": "Bob M" }, { "name": "Trent W", "code": "Trent W" }, { "name": "Wade M", "code": "Wade M" }, { "name": "Rob K", "code": "Rob K" }, { "name": "Loren C", "code": "Loren C" }, { "name": "Connor P", "code": "Connor P" }, { "name": "Terry L", "code": "Terry L" }, { "name": "Dan D", "code": "Dan D" }, { "name": "Jeremy Q", "code": "Jeremy Q" }, { "name": "Jeff K", "code": "Jeff K" }, { "name": "Matt W", "code": "Matt W" }, { "name": "Jesse F", "code": "Jesse F" }, { "name": "Terese A", "code": "Terese A" }, { "name": "Nate B", "code": "Nate B" }, { "name": "Parks", "code": "Parks" }, { "name": "Streets", "code": "Streets" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "usermodified" }, { "name": "usercompleted", "type": "esriFieldTypeString", "alias": "Completed By", "domain": { "type": "codedValue", "name": "Username", "description": "Username", "codedValues": [ { "name": "Mike K", "code": "Mike K" }, { "name": "Steve S", "code": "Steve S" }, { "name": "Reade D", "code": "Reade D" }, { "name": "Dane N", "code": "Dane N" }, { "name": "Bob M", "code": "Bob M" }, { "name": "Trent W", "code": "Trent W" }, { "name": "Wade M", "code": "Wade M" }, { "name": "Rob K", "code": "Rob K" }, { "name": "Loren C", "code": "Loren C" }, { "name": "Connor P", "code": "Connor P" }, { "name": "Terry L", "code": "Terry L" }, { "name": "Dan D", "code": "Dan D" }, { "name": "Jeremy Q", "code": "Jeremy Q" }, { "name": "Jeff K", "code": "Jeff K" }, { "name": "Matt W", "code": "Matt W" }, { "name": "Jesse F", "code": "Jesse F" }, { "name": "Terese A", "code": "Terese A" }, { "name": "Nate B", "code": "Nate B" }, { "name": "Parks", "code": "Parks" }, { "name": "Streets", "code": "Streets" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "usercompleted" }, { "name": "description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "description" }, { "name": "type", "type": "esriFieldTypeString", "alias": "Task Type", "domain": { "type": "codedValue", "name": "TaskName_", "description": "", "codedValues": [ { "name": "Cleaning", "code": "Cleaning" }, { "name": "Inspection", "code": "Inspection" }, { "name": "Install Component", "code": "Install Component" }, { "name": "Install New", "code": "Install New" }, { "name": "Jetting", "code": "Jetting" }, { "name": "Paint", "code": "Paint" }, { "name": "Rebuild", "code": "Rebuild" }, { "name": "Remove", "code": "Remove" }, { "name": "Repair", "code": "Repair" }, { "name": "Replace", "code": "Replace" }, { "name": "Sealing", "code": "Sealing" }, { "name": "Trimming", "code": "Trimming" }, { "name": "Televise", "code": "Televise" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "type" }, { "name": "relfeaturelayer", "type": "esriFieldTypeString", "alias": "RelFeatureLayer", "domain": { "type": "codedValue", "name": "LayerName", "description": "", "codedValues": [ { "name": "Catch Basins", "code": "tbl_catch_basins" }, { "name": "Feed Points", "code": "tbl_feed_points" }, { "name": "Flare Ends", "code": "tbl_flare_ends" }, { "name": "Gate Valves", "code": "tbl_gate_valves" }, { "name": "Hydrants", "code": "tbl_hydrants" }, { "name": "Inspection Projects", "code": "tbl_inspection_projects" }, { "name": "Lift Stations", "code": "tbl_lift_stations" }, { "name": "Light Lines", "code": "tbl_light_lines" }, { "name": "Lights", "code": "tbl_lights" }, { "name": "Parcels", "code": "tbl_parcels" }, { "name": "Plantings", "code": "tbl_plantings_forestry" }, { "name": "PRV's", "code": "tbl_pressure_relief_valves" }, { "name": "Private Trees", "code": "tbl_private_trees" }, { "name": "Sanitary Manholes", "code": "tbl_sanitary_manholes" }, { "name": "Sanitary Sewers", "code": "tbl_sanitary_sewers" }, { "name": "Signals", "code": "tbl_signals" }, { "name": "Signs", "code": "tbl_signs" }, { "name": "Storm Manholes", "code": "tbl_storm_manholes" }, { "name": "Storm Sewers", "code": "tbl_storm_sewers" }, { "name": "Stormwater Ponds", "code": "tbl_stormwater_ponds" }, { "name": "Streets", "code": "tbl_streets" }, { "name": "Structures", "code": "tbl_structures" }, { "name": "Trails & Paths", "code": "tbl_trails_paths" }, { "name": "Trees", "code": "tbl_trees" }, { "name": "Water Breaks", "code": "tbl_water_breaks" }, { "name": "Water Mains", "code": "tbl_water_lines" }, { "name": "Water Towers", "code": "tbl_water_towers" }, { "name": "Wells", "code": "tbl_wells" }, { "name": "Force Mains", "code": "tbl_force_mains" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "relfeaturelayer" }, { "name": "relfeatureglobalid", "type": "esriFieldTypeGUID", "alias": "RelFeatureGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "relfeatureglobalid" }, { "name": "relfeaturealtid", "type": "esriFieldTypeString", "alias": "Alternate ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "relfeaturealtid" }, { "name": "workorderglobalid", "type": "esriFieldTypeGUID", "alias": "WorkorderGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "workorderglobalid" }, { "name": "userassigned", "type": "esriFieldTypeString", "alias": "userassigned", "domain": { "type": "codedValue", "name": "Username", "description": "Username", "codedValues": [ { "name": "Mike K", "code": "Mike K" }, { "name": "Steve S", "code": "Steve S" }, { "name": "Reade D", "code": "Reade D" }, { "name": "Dane N", "code": "Dane N" }, { "name": "Bob M", "code": "Bob M" }, { "name": "Trent W", "code": "Trent W" }, { "name": "Wade M", "code": "Wade M" }, { "name": "Rob K", "code": "Rob K" }, { "name": "Loren C", "code": "Loren C" }, { "name": "Connor P", "code": "Connor P" }, { "name": "Terry L", "code": "Terry L" }, { "name": "Dan D", "code": "Dan D" }, { "name": "Jeremy Q", "code": "Jeremy Q" }, { "name": "Jeff K", "code": "Jeff K" }, { "name": "Matt W", "code": "Matt W" }, { "name": "Jesse F", "code": "Jesse F" }, { "name": "Terese A", "code": "Terese A" }, { "name": "Nate B", "code": "Nate B" }, { "name": "Parks", "code": "Parks" }, { "name": "Streets", "code": "Streets" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "userassigned" }, { "name": "taskname", "type": "esriFieldTypeString", "alias": "taskname", "domain": { "type": "codedValue", "name": "TaskName", "description": "", "codedValues": [ { "name": "Winterized", "code": "Winterized" }, { "name": "Winterize", "code": "Winterize" }, { "name": "Water Bag", "code": "Water Bag" }, { "name": "Water", "code": "Water" }, { "name": "Vactor", "code": "Vactor" }, { "name": "Unspecified", "code": "Unspecified" }, { "name": "Un-named Service", "code": "Un-named Service" }, { "name": "Tuck Point", "code": "Tuck Point" }, { "name": "Tree Removal", "code": "Tree Removal" }, { "name": "Tree Pruning", "code": "Tree Pruning" }, { "name": "Tree Inventory", "code": "Tree Inventory" }, { "name": "Tree Inspection", "code": "Tree Inspection" }, { "name": "Top 50", "code": "Top 50" }, { "name": "TILTED SKY RUNNER", "code": "TILTED SKY RUNNER" }, { "name": "Temporary sedimentation basin(s) are present and functioning", "code": "Temporary sedimentation basin(s) are present and functioning" }, { "name": "Temporary or permanent energy dissipation present at outlets", "code": "Temporary or permanent energy dissipation present at outlets" }, { "name": "Televise", "code": "Televise" }, { "name": "Sweep", "code": "Sweep" }, { "name": "Surface Water Inspection", "code": "Surface Water Inspection" }, { "name": "Surface Treatment", "code": "Surface Treatment" }, { "name": "Suface Water Maintenance", "code": "Suface Water Maintenance" }, { "name": "Subordinated Branch Pruning", "code": "Subordinated Branch Pruning" }, { "name": "Stump Grinding", "code": "Stump Grinding" }, { "name": "Striping", "code": "Striping" }, { "name": "Storm Water Pollution Prevention Plan (SWPPP) is available", "code": "Storm Water Pollution Prevention Plan (SWPPP) is available" }, { "name": "Stacked Branch Pruning", "code": "Stacked Branch Pruning" }, { "name": "Stabilization and Structure Condition Inspection", "code": "Stabilization and Structure Condition Inspection" }, { "name": "Spring Clean-up", "code": "Spring Clean-up" }, { "name": "Snow Plow", "code": "Snow Plow" }, { "name": "Sign of Erosion or Slope Failure Inspection", "code": "Sign of Erosion or Slope Failure Inspection" }, { "name": "Sealing", "code": "Sealing" }, { "name": "Sanitary Manhole Change", "code": "Sanitary Manhole Change" }, { "name": "Rotate", "code": "Rotate" }, { "name": "Rip Rap", "code": "Rip Rap" }, { "name": "Required inspections/maintenance has been performed", "code": "Required inspections/maintenance has been performed" }, { "name": "Replace Rings and Grout", "code": "Replace Rings and Grout" }, { "name": "Replace Grate", "code": "Replace Grate" }, { "name": "Replace", "code": "Replace" }, { "name": "Repair", "code": "Repair" }, { "name": "Remove Tree", "code": "Remove Tree" }, { "name": "Remove Sign", "code": "Remove Sign" }, { "name": "Remove Sediment", "code": "Remove Sediment" }, { "name": "Remove Obstruction", "code": "Remove Obstruction" }, { "name": "Remove Grate", "code": "Remove Grate" }, { "name": "Reconstruct", "code": "Reconstruct" }, { "name": "Rebuild", "code": "Rebuild" }, { "name": "Raised/Clearance Branch Pruning", "code": "Raised/Clearance Branch Pruning" }, { "name": "Rainfall Inspection", "code": "Rainfall Inspection" }, { "name": "Pump Out", "code": "Pump Out" }, { "name": "Prune", "code": "Prune" }, { "name": "Pretreatment of permanent storm water BMPs in place", "code": "Pretreatment of permanent storm water BMPs in place" }, { "name": "Pre-emergent Herbicide", "code": "Pre-emergent Herbicide" }, { "name": "Post-emergent Herbicide", "code": "Post-emergent Herbicide" }, { "name": "Plant", "code": "Plant" }, { "name": "Phone Call - Water", "code": "Phone Call - Water" }, { "name": "Phone Call - Streets", "code": "Phone Call - Streets" }, { "name": "Phone Call - Storm", "code": "Phone Call - Storm" }, { "name": "Phone Call - Sanitary", "code": "Phone Call - Sanitary" }, { "name": "Phone Call - Lights", "code": "Phone Call - Lights" }, { "name": "Phone Call - Forestry", "code": "Phone Call - Forestry" }, { "name": "Permanent storm water management BMPs are in place", "code": "Permanent storm water management BMPs are in place" }, { "name": "Patch", "code": "Patch" }, { "name": "Paint", "code": "Paint" }, { "name": "Overlay", "code": "Overlay" }, { "name": "Outside Collar", "code": "Outside Collar" }, { "name": "Oil Change / Greasing", "code": "Oil Change / Greasing" }, { "name": "Mulching", "code": "Mulching" }, { "name": "Mulch", "code": "Mulch" }, { "name": "Mow Lawn", "code": "Mow Lawn" }, { "name": "Mow Ditch", "code": "Mow Ditch" }, { "name": "Minor Patch", "code": "Minor Patch" }, { "name": "Medium Deadwood Pruning", "code": "Medium Deadwood Pruning" }, { "name": "Major Patch", "code": "Major Patch" }, { "name": "Litter Pickup", "code": "Litter Pickup" }, { "name": "Lining", "code": "Lining" }, { "name": "Light Bulb Replacement", "code": "Light Bulb Replacement" }, { "name": "LABCO (paint)", "code": "LABCO (paint)" }, { "name": "LABCO", "code": "LABCO" }, { "name": "Jetting", "code": "Jetting" }, { "name": "Install New", "code": "Install New" }, { "name": "Install Component", "code": "Install Component" }, { "name": "Inspection", "code": "Inspection" }, { "name": "Injection Treatment", "code": "Injection Treatment" }, { "name": "Illicit Discharge", "code": "Illicit Discharge" }, { "name": "Hedge", "code": "Hedge" }, { "name": "Hazard Branch Pruning", "code": "Hazard Branch Pruning" }, { "name": "Hand Weed", "code": "Hand Weed" }, { "name": "Grouting", "code": "Grouting" }, { "name": "Grind Stump", "code": "Grind Stump" }, { "name": "Greasing", "code": "Greasing" }, { "name": "Girdle", "code": "Girdle" }, { "name": "Flushing Sanitary", "code": "Flushing Sanitary" }, { "name": "Flushing", "code": "Flushing" }, { "name": "Flood Rinks", "code": "Flood Rinks" }, { "name": "Flag Replacement", "code": "Flag Replacement" }, { "name": "Fine Deadwood Pruning", "code": "Fine Deadwood Pruning" }, { "name": "Fertilization", "code": "Fertilization" }, { "name": "Exterior Painting", "code": "Exterior Painting" }, { "name": "Exposed soils that are not actively being worked for 14 days", "code": "Exposed soils that are not actively being worked for 14 days" }, { "name": "Exercising", "code": "Exercising" }, { "name": "Edge", "code": "Edge" }, { "name": "EAB", "code": "EAB" }, { "name": "Down gradient perimeter control is installed and functioning", "code": "Down gradient perimeter control is installed and functioning" }, { "name": "Diseased Tree", "code": "Diseased Tree" }, { "name": "Dewatering activity is resulting in the discharge of clean water.", "code": "Dewatering activity is resulting in the discharge of clean water." }, { "name": "Debris", "code": "Debris" }, { "name": "Dead Head", "code": "Dead Head" }, { "name": "Cut Grass", "code": "Cut Grass" }, { "name": "Cut Channel", "code": "Cut Channel" }, { "name": "Cut Brush", "code": "Cut Brush" }, { "name": "Curb Stop Repair", "code": "Curb Stop Repair" }, { "name": "Crossed Branch Pruning", "code": "Crossed Branch Pruning" }, { "name": "Crackfill", "code": "Crackfill" }, { "name": "Course Deadwood Pruning", "code": "Course Deadwood Pruning" }, { "name": "Coppice", "code": "Coppice" }, { "name": "Construction entrance(s) are installed and functioning", "code": "Construction entrance(s) are installed and functioning" }, { "name": "Construction activity is not resulting in erosion impacts", "code": "Construction activity is not resulting in erosion impacts" }, { "name": "Clearance Pruning", "code": "Clearance Pruning" }, { "name": "Cleaning", "code": "Cleaning" }, { "name": "CIP Projected", "code": "CIP Projected" }, { "name": "Chipping", "code": "Chipping" }, { "name": "Chemical Treatment", "code": "Chemical Treatment" }, { "name": "Change Cover", "code": "Change Cover" }, { "name": "Buckthorn Curbside Collection", "code": "Buckthorn Curbside Collection" }, { "name": "Bolt Replacement", "code": "Bolt Replacement" }, { "name": "Annual Outfall Inspection", "code": "Annual Outfall Inspection" }, { "name": "Annual Inspection", "code": "Annual Inspection" }, { "name": "All inlet control BMPs are installed and functioning", "code": "All inlet control BMPs are installed and functioning" }, { "name": "All construction waste is properly managed and disposed of", "code": "All construction waste is properly managed and disposed of" }, { "name": "All areas that have achieved final grade have been permanently stabilized.", "code": "All areas that have achieved final grade have been permanently stabilized." }, { "name": "Air Spade", "code": "Air Spade" }, { "name": "Adjust Curb Box", "code": "Adjust Curb Box" }, { "name": "Adequate up gradient BMPs are installed and functioning", "code": "Adequate up gradient BMPs are installed and functioning" }, { "name": "Other", "code": "Other" }, { "name": "General Topic", "code": "General Topic" }, { "name": "Online Citizen Request", "code": "Online Citizen Request" }, { "name": "Storm Damage", "code": "Storm Damage" }, { "name": "Sewer Backup", "code": "Sewer Backup" }, { "name": "Sanitary Flushing", "code": "Sanitary Flushing" }, { "name": "Televising Inspection", "code": "Televising Inspection" }, { "name": "Sewer Lining", "code": "Sewer Lining" }, { "name": "Root Removal", "code": "Root Removal" }, { "name": "Watering", "code": "Watering" }, { "name": "Bulb Out", "code": "Bulb Out" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "taskname" }, { "name": "layername", "type": "esriFieldTypeString", "alias": "layername", "domain": { "type": "codedValue", "name": "LayerName", "description": "", "codedValues": [ { "name": "Catch Basins", "code": "tbl_catch_basins" }, { "name": "Feed Points", "code": "tbl_feed_points" }, { "name": "Flare Ends", "code": "tbl_flare_ends" }, { "name": "Gate Valves", "code": "tbl_gate_valves" }, { "name": "Hydrants", "code": "tbl_hydrants" }, { "name": "Inspection Projects", "code": "tbl_inspection_projects" }, { "name": "Lift Stations", "code": "tbl_lift_stations" }, { "name": "Light Lines", "code": "tbl_light_lines" }, { "name": "Lights", "code": "tbl_lights" }, { "name": "Parcels", "code": "tbl_parcels" }, { "name": "Plantings", "code": "tbl_plantings_forestry" }, { "name": "PRV's", "code": "tbl_pressure_relief_valves" }, { "name": "Private Trees", "code": "tbl_private_trees" }, { "name": "Sanitary Manholes", "code": "tbl_sanitary_manholes" }, { "name": "Sanitary Sewers", "code": "tbl_sanitary_sewers" }, { "name": "Signals", "code": "tbl_signals" }, { "name": "Signs", "code": "tbl_signs" }, { "name": "Storm Manholes", "code": "tbl_storm_manholes" }, { "name": "Storm Sewers", "code": "tbl_storm_sewers" }, { "name": "Stormwater Ponds", "code": "tbl_stormwater_ponds" }, { "name": "Streets", "code": "tbl_streets" }, { "name": "Structures", "code": "tbl_structures" }, { "name": "Trails & Paths", "code": "tbl_trails_paths" }, { "name": "Trees", "code": "tbl_trees" }, { "name": "Water Breaks", "code": "tbl_water_breaks" }, { "name": "Water Mains", "code": "tbl_water_lines" }, { "name": "Water Towers", "code": "tbl_water_towers" }, { "name": "Wells", "code": "tbl_wells" }, { "name": "Force Mains", "code": "tbl_force_mains" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "layername" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "priority", "type": "esriFieldTypeString", "alias": "priority", "domain": { "type": "codedValue", "name": "Priority", "description": "Priority", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Medium", "code": "Medium" }, { "name": "Low", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "priority" }, { "name": "patching_amount", "type": "esriFieldTypeDouble", "alias": "Patching Tons", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "patching_amount" }, { "name": "userenter", "type": "esriFieldTypeString", "alias": "User Entered", "domain": { "type": "codedValue", "name": "userenter", "description": "User Entered", "codedValues": [ { "name": "Bob Moore", "code": "Bob Moore" }, { "name": "Brian Bachmeier", "code": "Brian Bachmeier" }, { "name": "Chris Buntjer", "code": "Chris Buntjer" }, { "name": "Connor Papenfuss", "code": "Connor Papenfuss" }, { "name": "Dan Determan", "code": "Dan Determan" }, { "name": "Dane Neska", "code": "Dane Neska" }, { "name": "Jake Knoepfler", "code": "Jake Knoepfler" }, { "name": "Jeremy Quinzon", "code": "Jeremy Quinzon" }, { "name": "Jim Romanik", "code": "Jim Romanik" }, { "name": "Kelly Armstrong", "code": "Kelly Armstrong" }, { "name": "Loren Cota", "code": "Loren Cota" }, { "name": "Mike Kothe", "code": "Mike Kothe" }, { "name": "Miranda Williams", "code": "Miranda Williams" }, { "name": "Reade Damlo", "code": "Reade Damlo" }, { "name": "Steve Schloegel", "code": "Steve Schloegel" }, { "name": "Terry Lang", "code": "Terry Lang" }, { "name": "Trent Wirkus", "code": "Trent Wirkus" }, { "name": "Wade Madsen", "code": "Wade Madsen" }, { "name": "Street Department", "code": "Street Department" }, { "name": "Environmental Services Department", "code": "Environmental Services Department" }, { "name": "Parks Department", "code": "Parks Department" }, { "name": "Neil Hiatt", "code": "Neil Hiatt" }, { "name": "Tim Mehlhorn", "code": "Tim Mehlhorn" }, { "name": "Nate Burlingame", "code": "Nate Burlingame" }, { "name": "GIS Admin", "code": "GIS Admin" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "userenter" }, { "name": "dashboard_priority_sort", "type": "esriFieldTypeSmallInteger", "alias": "dashboard_priority_sort", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "dashboard_priority_sort" }, { "name": "taskcategory_parcels", "type": "esriFieldTypeString", "alias": "taskcategory", "domain": { "type": "codedValue", "name": "taskcategory_parcels", "description": "Task Category Parcels", "codedValues": [ { "name": "Utilities", "code": "Utilities" }, { "name": "Trees", "code": "Trees" }, { "name": "Storm", "code": "Storm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "taskcategory_parcels" }, { "name": "contractor", "type": "esriFieldTypeString", "alias": "contractor", "domain": { "type": "codedValue", "name": "contractors", "description": "Contractors", "codedValues": [ { "name": "Burchville Construction", "code": "Burchville Construction" }, { "name": "Killmer Electric", "code": "Killmer Electric" }, { "name": "LABCO", "code": "LABCO" }, { "name": "Magney Construction", "code": "Magney Construction" }, { "name": "MCES", "code": "MCES" }, { "name": "MDH", "code": "MDH" }, { "name": "Miller Excavating", "code": "Miller Excavating" }, { "name": "MPCA", "code": "MPCA" }, { "name": "Pace Analytical", "code": "Pace Analytical" }, { "name": "Parsons Electric - Mark Weiss", "code": "Parsons Electric" }, { "name": "St. Paul Regional Water", "code": "St. Paul Regional Water" }, { "name": "TPC", "code": "TPC" }, { "name": "Xcel Energy", "code": "Xcel Energy" }, { "name": "Oakdale Public Works", "code": "Oakdale Public Works" }, { "name": "North St Paul Electric", "code": "North St Paul Electric" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "contractor" }, { "name": "cost", "type": "esriFieldTypeDouble", "alias": "cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cost" }, { "name": "labor", "type": "esriFieldTypeDouble", "alias": "labor hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "labor" } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "shape" }, "indexes": [ { "name": "gdb_532_relfeatu", "isAscending": true, "isUnique": false, "description": "", "fields": "relfeatureglobalid" }, { "name": "r110_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" }, { "name": "uuid_110", "isAscending": true, "isUnique": true, "description": "", "fields": "globalid" }, { "name": "a91_ix1", "isAscending": true, "isUnique": true, "description": "", "fields": "shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Task - All", "description": "", "prototype": { "attributes": { "cost": null, "contractor": null, "status": null, "datecreated": null, "datemodified": null, "datecompleted": null, "usercreated": null, "usermodified": null, "usercompleted": null, "description": null, "type": null, "relfeaturelayer": null, "relfeatureglobalid": null, "relfeaturealtid": null, "workorderglobalid": null, "userassigned": null, "taskname": null, "layername": null, "labor": null, "priority": null, "patching_amount": null, "userenter": null, "dashboard_priority_sort": null, "taskcategory_parcels": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "attachmentid", "isEnabled": true }, { "name": "globalId", "fieldName": "globalid", "isEnabled": true }, { "name": "name", "fieldName": "att_name", "isEnabled": true }, { "name": "size", "fieldName": "data_size", "isEnabled": true }, { "name": "contentType", "fieldName": "content_type", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "attachmentid", "type": "esriFieldTypeOID", "alias": "attachmentid", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "att_name", "type": "esriFieldTypeString", "alias": "att_name", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "data_size", "type": "esriFieldTypeInteger", "alias": "data_size", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "content_type", "type": "esriFieldTypeString", "alias": "content_type", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "5dabca1d632c4527b975c832db5519c6" }