{ "layers": [ { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 0, "name": "Street Work Orders", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "extent": { "xmin": 1371432.6868970953, "ymin": 271154.49483577907, "xmax": 1458606.4302001782, "ymax": 517640.8214159459, "spatialReference": { "wkid": 102697, "latestWkid": 102697, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -16806900, "falseY": -45827300, "xyUnits": 3048.00609601219, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102697, "latestWkid": 102697, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -16806900, "falseY": -45827300, "xyUnits": 3048.00609601219, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 153, 47, 135, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "WORKTYPE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "WORKTYPE", "type": "esriFieldTypeString", "alias": "Work Type", "domain": { "type": "codedValue", "name": "StreetWorkType", "description": "Streets work type", "codedValues": [ { "name": "AdoptAStreet", "code": "AdoptAStreet" }, { "name": "Banners", "code": "Banners" }, { "name": "Barricades", "code": "Barricades" }, { "name": "Bridge Work", "code": "Bridge Work" }, { "name": "Brush Hog", "code": "Brush Hog" }, { "name": "Christmas Lights/Decorations", "code": "Christmas Lights/Decorations" }, { "name": "CID Work", "code": "CID Work" }, { "name": "City Hall Grounds Maintenance", "code": "City Hall Grounds Maintenance" }, { "name": "Clean Up Spring/Fall", "code": "Clean Up Spring/Fall" }, { "name": "Cleaning Ditches", "code": "Cleaning Ditches" }, { "name": "Computer Work", "code": "Computer Work" }, { "name": "Concrete/Curb Work/Sidewalk", "code": "Concrete/Curb Work/Sidewalk" }, { "name": "Crack Seal", "code": "Crack Seal" }, { "name": "Delineators", "code": "Delineators" }, { "name": "Emergency Signage", "code": "Emergency Signage" }, { "name": "Equipment Maintenance", "code": "Equipment Maintenance" }, { "name": "FEMA", "code": "FEMA" }, { "name": "Flags on Gretna", "code": "Flags on Gretna" }, { "name": "Guardrail", "code": "Guardrail" }, { "name": "Handrail", "code": "Handrail" }, { "name": "Hauling Material", "code": "Hauling Material" }, { "name": "Inspections/Checks", "code": "Inspections/Checks" }, { "name": "Landscaping", "code": "Landscaping" }, { "name": "Moving/Transporting Equip/Items", "code": "Moving/Transporting Equip/Items" }, { "name": "Mowing", "code": "Mowing" }, { "name": "Mow Crew Mowing", "code": "Mow Crew Mowing" }, { "name": "Other", "code": "Other" }, { "name": "Parades (other)", "code": "Parades (other)" }, { "name": "Parking Blocks", "code": "Parking Blocks" }, { "name": "Paver Repairs", "code": "Paver Repairs" }, { "name": "PD/FD Assistance", "code": "PD/FD Assistance" }, { "name": "Potholes", "code": "Potholes" }, { "name": "Purchasing", "code": "Purchasing" }, { "name": "Road Kill Removal", "code": "Road Kill Removal" }, { "name": "Safety/Other Meetings", "code": "Safety/Other Meetings" }, { "name": "Shop Maintenance", "code": "Shop Maintenance" }, { "name": "SideArm Mowing", "code": "SideArm Mowing" }, { "name": "Snow Event", "code": "Snow Event" }, { "name": "Snow Plow Maintenance", "code": "Snow Plow Maintenance" }, { "name": "Spraying", "code": "Spraying" }, { "name": "Storm Drain Maintenance", "code": "Storm Drain Maintenance" }, { "name": "Storm Drain Repair", "code": "Storm Drain Repair" }, { "name": "Street Lights", "code": "Street Lights" }, { "name": "Street Patching", "code": "Street Patching" }, { "name": "Striping", "code": "Striping" }, { "name": "Sweeping", "code": "Sweeping" }, { "name": "Traffic Signals", "code": "Traffic Signals" }, { "name": "Trail Work", "code": "Trail Work" }, { "name": "Training", "code": "Training" }, { "name": "Trash Pickup", "code": "Trash Pickup" }, { "name": "Tree Trimming", "code": "Tree Trimming" }, { "name": "Utilities Patch/Repair", "code": "Utilities Patch/Repair" }, { "name": "Special Event", "code": "Special Event" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "WORKTYPE" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "mMaintenanceStatus", "description": "Maintenance Status", "codedValues": [ { "name": "Submitted", "code": "Submitted" }, { "name": "Assigned", "code": "Assigned" }, { "name": "In Progress", "code": "In Progress" }, { "name": "On Hold", "code": "On Hold" }, { "name": "Complete", "code": "Complete" }, { "name": "Canceled", "code": "Canceled" }, { "name": "On Break", "code": "On Break" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STATUS" }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "Priority", "domain": { "type": "codedValue", "name": "StreetWorkOrderPriority", "description": "Streets work order priority", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "6", "code": "6" }, { "name": "7", "code": "7" }, { "name": "8", "code": "8" }, { "name": "9", "code": "9" }, { "name": "10", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PRIORITY" }, { "name": "DUEDATE", "type": "esriFieldTypeDate", "alias": "Due Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DUEDATE" }, { "name": "WORKORDERNUMBER", "type": "esriFieldTypeString", "alias": "Work Order Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WORKORDERNUMBER" }, { "name": "ASSIGNEE", "type": "esriFieldTypeString", "alias": "Assignee", "domain": { "type": "codedValue", "name": "StreetAssigneeTeam", "description": "Street Assignee Team", "codedValues": [ { "name": "Team 1 (Blue)", "code": "Team 1" }, { "name": "Team 2 (Green)", "code": "Team 2" }, { "name": "Team 3 (Orange)", "code": "Team 3" }, { "name": "Team 4 (Red)", "code": "Team 4" }, { "name": "Unassigned", "code": "Unassigned" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ASSIGNEE" }, { "name": "COMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Date Completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COMPLETIONDATE" }, { "name": "STARTDATE", "type": "esriFieldTypeDate", "alias": "Date Started", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "STARTDATE" }, { "name": "TITLE", "type": "esriFieldTypeString", "alias": "Job title", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "TITLE" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Job Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "NEARADDR", "type": "esriFieldTypeString", "alias": "Nearest address", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "NEARADDR" }, { "name": "INDVASSIGNEE", "type": "esriFieldTypeString", "alias": "Individual assignee", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INDVASSIGNEE" }, { "name": "DIMENSIONS", "type": "esriFieldTypeString", "alias": "Dimensions", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "DIMENSIONS" }, { "name": "INCIDENTAL", "type": "esriFieldTypeString", "alias": "Incidental", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INCIDENTAL" }, { "name": "HISTORICSURVEYRECORD", "type": "esriFieldTypeGUID", "alias": "Historic Survey Record", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "HISTORICSURVEYRECORD" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R1430_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1430", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1430", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1045_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Street Work Orders", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "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 } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 1, "name": "Streets Equipment", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "NAME" }, { "name": "ACTIVE", "type": "esriFieldTypeString", "alias": "Active", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ACTIVE" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R1429_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Streets Equipment", "description": "", "prototype": { "attributes": { "ACTIVE": null, "NAME": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 2, "name": "Street Crew", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "ACTIVE", "type": "esriFieldTypeString", "alias": "Active (Yes/No)", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ACTIVE" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "EMAIL", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EMAIL" }, { "name": "TEAM", "type": "esriFieldTypeString", "alias": "Team", "domain": { "type": "codedValue", "name": "StreetAssigneeTeam", "description": "Street Assignee Team", "codedValues": [ { "name": "Team 1 (Blue)", "code": "Team 1" }, { "name": "Team 2 (Green)", "code": "Team 2" }, { "name": "Team 3 (Orange)", "code": "Team 3" }, { "name": "Team 4 (Red)", "code": "Team 4" }, { "name": "Unassigned", "code": "Unassigned" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "TEAM" } ], "indexes": [ { "name": "R1401_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Street Crew", "description": "", "prototype": { "attributes": { "EMAIL": null, "TEAM": null, "NAME": null, "ACTIVE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 3, "name": "Street Work Types", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CATEGORY", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CATEGORY", "type": "esriFieldTypeString", "alias": "Work category", "domain": { "type": "codedValue", "name": "StreetWorkTypes", "description": "Street work types", "codedValues": [ { "name": "General", "code": "General" }, { "name": "CID", "code": "CID" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CATEGORY" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "TYPE" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R1428_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Street Work Types", "description": "", "prototype": { "attributes": { "TYPE": null, "CATEGORY": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }