{ "layers": [ { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 0, "name": "Street Work Orders", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "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": "WORKTYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WORKTYPE", "type": "esriFieldTypeString", "alias": "Work Type", "length": 200, "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" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 1000, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "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" } }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "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" } }, { "name": "DUEDATE", "type": "esriFieldTypeDate", "alias": "Due Date", "length": 8, "domain": null }, { "name": "WORKORDERNUMBER", "type": "esriFieldTypeString", "alias": "Work Order Number", "length": 50, "domain": null }, { "name": "ASSIGNEE", "type": "esriFieldTypeString", "alias": "Assignee", "length": 50, "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" } }, { "name": "COMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "STARTDATE", "type": "esriFieldTypeDate", "alias": "Date Started", "length": 8, "domain": null }, { "name": "TITLE", "type": "esriFieldTypeString", "alias": "Job title", "length": 100, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Job Description", "length": 200, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "NEARADDR", "type": "esriFieldTypeString", "alias": "Nearest address", "length": 100, "domain": null }, { "name": "INDVASSIGNEE", "type": "esriFieldTypeString", "alias": "Individual assignee", "length": 50, "domain": null }, { "name": "DIMENSIONS", "type": "esriFieldTypeString", "alias": "Dimensions", "length": 200, "domain": null }, { "name": "INCIDENTAL", "type": "esriFieldTypeString", "alias": "Incidental", "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": "HISTORICSURVEYRECORD", "type": "esriFieldTypeGUID", "alias": "Historic Survey Record", "length": 38, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "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 }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 1, "name": "Streets Equipment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 200, "domain": null }, { "name": "ACTIVE", "type": "esriFieldTypeString", "alias": "Active", "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R1429_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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 }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 2, "name": "Street Crew", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "ACTIVE", "type": "esriFieldTypeString", "alias": "Active (Yes/No)", "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "EMAIL", "type": "esriFieldTypeString", "alias": "Email", "length": 100, "domain": null }, { "name": "TEAM", "type": "esriFieldTypeString", "alias": "Team", "length": 25, "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" } } ], "indexes": [ { "name": "R1401_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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 }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 3, "name": "Street Work Types", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CATEGORY", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CATEGORY", "type": "esriFieldTypeString", "alias": "Work category", "length": 100, "domain": { "type": "codedValue", "name": "StreetWorkTypes", "description": "Street work types", "codedValues": [ { "name": "General", "code": "General" }, { "name": "CID", "code": "CID" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 200, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R1428_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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 }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }