{ "layers": [ { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 19, "name": "Sign Posts", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102704, "latestWkid": 26852, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.503599627370495E11, "falseY": -4.503599627370495E11, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 0, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1.0499999999999998 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 2634477.931274414, "ymin": 515119.81048583984, "xmax": 2768474.014892578, "ymax": 592845.5676879883, "spatialReference": { "wkid": 102704, "latestWkid": 26852, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119097700, "falseY": -96454900, "xyUnits": 3.730056732191823E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "INSPECTOR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "INSPECTOR", "length": 50, "domain": { "type": "codedValue", "name": "WS1_TR_INSPECTOR", "description": "Traffic Inspectors", "codedValues": [ { "name": "Scott Musgrove", "code": "SM" }, { "name": "Tom Kraus", "code": "TK" }, { "name": "John Pollreis", "code": "JP" }, { "name": "Kyle Imig", "code": "KI" }, { "name": "Traffic GIS", "code": "GIS" }, { "name": "TEA", "code": "TEA" }, { "name": "Sign Crew", "code": "SC" }, { "name": "P Mrk Crew", "code": "PC" }, { "name": "Douglas County", "code": "DC" }, { "name": "Mike Hustig", "code": "MH" }, { "name": "Ian Donahue", "code": "ID" }, { "name": "Sean King", "code": "SK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NUM_POSTS", "type": "esriFieldTypeSmallInteger", "alias": "Number of Posts", "domain": null }, { "name": "POST_TYPE", "type": "esriFieldTypeString", "alias": "Post Type", "length": 50, "domain": { "type": "codedValue", "name": "WS1_TR_POST_TYPE", "description": "Post Type", "codedValues": [ { "name": "2 Pound U-Post", "code": "2LB_UPOST" }, { "name": "4 Pound U-Post", "code": "4LB_UPOST" }, { "name": "Steel Pole", "code": "STEEL_POLE" }, { "name": "Signal Pole", "code": "SIGNAL_POLE" }, { "name": "Wood Pole", "code": "WOOD_POLE" }, { "name": "Wood Post", "code": "WOOD_POST" }, { "name": "Span Wire", "code": "SPAN_WIRE" }, { "name": "Node Marker", "code": "NODE_MARKER" }, { "name": "Fence", "code": "FENCE" }, { "name": "Wall/Bridge", "code": "WALL_BRIDGE" }, { "name": "Deco Post", "code": "DECO_POST" }, { "name": "Deco Light Pole", "code": "DECO_LIGHT_POLE" }, { "name": "Cantilever", "code": "CANTILEVER" }, { "name": "Truss", "code": "TRUSS" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATE_INSP", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "WS1_SignStatus", "description": "Omaha Sign Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Sign Post ID", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 100, "domain": null }, { "name": "OWNED_BY", "type": "esriFieldTypeString", "alias": "Owned By", "length": 30, "domain": { "type": "codedValue", "name": "WS1_TR_ASSET_OWN", "description": "Asset Ownership", "codedValues": [ { "name": "City Of Omaha", "code": "CITY OF OMAHA" }, { "name": "Douglas County", "code": "DOUGLAS COUNTY" }, { "name": "Ralston", "code": "RALSTON" }, { "name": "Papillion", "code": "PAPILLION" }, { "name": "La Vista", "code": "LA VISTA" }, { "name": "Bellevue", "code": "BELLEVUE" }, { "name": "Sarpy County", "code": "SARPY COUNTY" }, { "name": "Boys Town", "code": "BOYS TOWN" }, { "name": "Valley", "code": "VALLEY" }, { "name": "Waterloo", "code": "WATERLOO" }, { "name": "Carter Lake", "code": "CARTER LAKE" }, { "name": "La Vista Douglas County", "code": "LA VISTA_DOUGLAS CO" }, { "name": "NDOR", "code": "NDOR" }, { "name": "Private/Other", "code": "Private_Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTAINED_BY", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 30, "domain": { "type": "codedValue", "name": "WS1_TR_ASSET_OWN", "description": "Asset Ownership", "codedValues": [ { "name": "City Of Omaha", "code": "CITY OF OMAHA" }, { "name": "Douglas County", "code": "DOUGLAS COUNTY" }, { "name": "Ralston", "code": "RALSTON" }, { "name": "Papillion", "code": "PAPILLION" }, { "name": "La Vista", "code": "LA VISTA" }, { "name": "Bellevue", "code": "BELLEVUE" }, { "name": "Sarpy County", "code": "SARPY COUNTY" }, { "name": "Boys Town", "code": "BOYS TOWN" }, { "name": "Valley", "code": "VALLEY" }, { "name": "Waterloo", "code": "WATERLOO" }, { "name": "Carter Lake", "code": "CARTER LAKE" }, { "name": "La Vista Douglas County", "code": "LA VISTA_DOUGLAS CO" }, { "name": "NDOR", "code": "NDOR" }, { "name": "Private/Other", "code": "Private_Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MTCE_AREA", "type": "esriFieldTypeSmallInteger", "alias": "Mtce Area", "domain": { "type": "range", "name": "WS1_TR_MTCE_AREA", "description": "Traffic Mtce Areas", "range": [ 1, 50 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "REHAB_STATUS", "type": "esriFieldTypeString", "alias": "Rehab Status", "length": 40, "domain": { "type": "codedValue", "name": "WS1_REHAB_STATUS", "description": "Rehab Status", "codedValues": [ { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Inspected, No Action Required", "code": "Inspected, No Action Required" }, { "name": "Inspected, Engineer Check Required", "code": "Inspected, Engineer Check Required" }, { "name": "Active", "code": "Active" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REHAB_AREA", "type": "esriFieldTypeString", "alias": "Rehab Area", "length": 10, "domain": null }, { "name": "IntersectionID", "type": "esriFieldTypeString", "alias": "IntersectionID", "length": 30, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "COMMENTS_1", "type": "esriFieldTypeString", "alias": "COMMENTS_1", "length": 200, "domain": { "type": "codedValue", "name": "WS1_PostReflector", "description": "Post Reflector", "codedValues": [ { "name": "Red", "code": "Red" }, { "name": "Yellow", "code": "Yellow" }, { "name": "FYG", "code": "FYG" }, { "name": "White", "code": "White" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS_2", "type": "esriFieldTypeString", "alias": "COMMENTS_2", "length": 200, "domain": null }, { "name": "COMMENTS3", "type": "esriFieldTypeString", "alias": "COMMENTS3", "length": 200, "domain": null }, { "name": "COMMENTS4", "type": "esriFieldTypeString", "alias": "COMMENTS4", "length": 200, "domain": null }, { "name": "COMMENTS5", "type": "esriFieldTypeString", "alias": "COMMENTS5", "length": 200, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R69_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_69", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G607FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S39_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 3, "name": "Total_Number_of_Unique_Requests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NumOfRequestIDs", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "NumOfRequestIDs", "type": "esriFieldTypeInteger", "alias": "NumOfRequestIDs", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 4, "name": "Total_Unique_Requests_Per_Problem_Code", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROBLEMCODE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PROBLEMCODE", "type": "esriFieldTypeString", "alias": "PROBLEMCODE", "length": 20, "domain": null }, { "name": "NumOfRequestIDs", "type": "esriFieldTypeInteger", "alias": "NumOfRequestIDs", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeDouble", "alias": "OBJECTID", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 5, "name": "SR_Unique_Initiated_by_Category", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INITIATEDBY", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "length": 50, "domain": null }, { "name": "NumOfRequestIDs", "type": "esriFieldTypeOID", "alias": "NumOfRequestIDs", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeDouble", "alias": "OBJECTID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 6, "name": "SR_Unique_Closed_By_Category", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CLOSEDBY", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "CLOSEDBY", "type": "esriFieldTypeString", "alias": "CLOSEDBY", "length": 50, "domain": null }, { "name": "NumOfRequestIDs", "type": "esriFieldTypeOID", "alias": "NumOfRequestIDs", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeDouble", "alias": "OBJECTID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 7, "name": "SR_and_WO", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Reqest_ID", "type": "esriFieldTypeDouble", "alias": "Reqest_ID", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "Workorder_ID", "type": "esriFieldTypeString", "alias": "Workorder_ID", "length": 60, "domain": null }, { "name": "SR_Initiated", "type": "esriFieldTypeDate", "alias": "SR_Initiated", "length": 8, "domain": null }, { "name": "SR_Closed", "type": "esriFieldTypeDate", "alias": "SR_Closed", "length": 8, "domain": null }, { "name": "WO_Initiated", "type": "esriFieldTypeDate", "alias": "WO_Initiated", "length": 8, "domain": null }, { "name": "WO_Closed", "type": "esriFieldTypeDate", "alias": "WO_Closed", "length": 8, "domain": null }, { "name": "WO_Description", "type": "esriFieldTypeString", "alias": "WO_Description", "length": 60, "domain": null }, { "name": "Problem_Code", "type": "esriFieldTypeString", "alias": "Problem_Code", "length": 20, "domain": null }, { "name": "SR_Description", "type": "esriFieldTypeString", "alias": "SR_Description", "length": 50, "domain": null }, { "name": "SR_Details", "type": "esriFieldTypeString", "alias": "SR_Details", "length": 500, "domain": null }, { "name": "Problem_Address", "type": "esriFieldTypeString", "alias": "Problem_Address", "length": 100, "domain": null }, { "name": "PROBADDTYPE", "type": "esriFieldTypeString", "alias": "PROBADDTYPE", "length": 30, "domain": null }, { "name": "Initiated_By", "type": "esriFieldTypeString", "alias": "Initiated_By", "length": 50, "domain": null }, { "name": "Submit_To", "type": "esriFieldTypeString", "alias": "Submit_To", "length": 50, "domain": null }, { "name": "Submit_To_Phone", "type": "esriFieldTypeString", "alias": "Submit_To_Phone", "length": 24, "domain": null }, { "name": "Submit_To_Email", "type": "esriFieldTypeString", "alias": "Submit_To_Email", "length": 256, "domain": null }, { "name": "Closed_By", "type": "esriFieldTypeString", "alias": "Closed_By", "length": 50, "domain": null }, { "name": "WO_ID_from_SR", "type": "esriFieldTypeString", "alias": "WO_ID_from_SR", "length": 60, "domain": null }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project_Name", "length": 130, "domain": null }, { "name": "SRX", "type": "esriFieldTypeDouble", "alias": "SRX", "domain": null }, { "name": "SRY", "type": "esriFieldTypeDouble", "alias": "SRY", "domain": null }, { "name": "Date_Submit_To", "type": "esriFieldTypeDate", "alias": "Date_Submit_To", "length": 8, "domain": null }, { "name": "Submit_To_Opened", "type": "esriFieldTypeString", "alias": "Submit_To_Opened", "length": 50, "domain": null }, { "name": "DATESUBMITTOOPEN", "type": "esriFieldTypeDate", "alias": "DATESUBMITTOOPEN", "length": 8, "domain": null }, { "name": "Dispatch_To", "type": "esriFieldTypeString", "alias": "Dispatch_To", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "Request_Category", "type": "esriFieldTypeString", "alias": "Request_Category", "length": 50, "domain": null }, { "name": "Problem_SID", "type": "esriFieldTypeDouble", "alias": "Problem_SID", "domain": null }, { "name": "REQCUSTFIELDCATID", "type": "esriFieldTypeDouble", "alias": "REQCUSTFIELDCATID", "domain": null }, { "name": "Project_Complete_Date", "type": "esriFieldTypeDate", "alias": "Project_Complete_Date", "length": 8, "domain": null }, { "name": "Projects_ID", "type": "esriFieldTypeDouble", "alias": "Projects_ID", "domain": null }, { "name": "INITIATEDBYAPP", "type": "esriFieldTypeString", "alias": "INITIATEDBYAPP", "length": 50, "domain": null }, { "name": "Street_Name", "type": "esriFieldTypeString", "alias": "Street_Name", "length": 50, "domain": null }, { "name": "Problem_Location", "type": "esriFieldTypeString", "alias": "Problem_Location", "length": 256, "domain": null }, { "name": "Text_9", "type": "esriFieldTypeString", "alias": "Text_9", "length": 100, "domain": null }, { "name": "INITIATEDBYSID", "type": "esriFieldTypeInteger", "alias": "INITIATEDBYSID", "domain": null }, { "name": "SUBMITTOSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOSID", "domain": null }, { "name": "SUBMITTOOPENBYSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOOPENBYSID", "domain": null }, { "name": "CANCELLEDBYSID", "type": "esriFieldTypeInteger", "alias": "CANCELLEDBYSID", "domain": null }, { "name": "CLOSEDBYSID", "type": "esriFieldTypeInteger", "alias": "CLOSEDBYSID", "domain": null }, { "name": "DISPATCHTOSID", "type": "esriFieldTypeInteger", "alias": "DISPATCHTOSID", "domain": null }, { "name": "DISPATCHOPENBYSID", "type": "esriFieldTypeInteger", "alias": "DISPATCHOPENBYSID", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 8, "name": "WO_Select_Signs_and_WOTasks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TASKNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "WOTASKID", "type": "esriFieldTypeDouble", "alias": "WOTASKID", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "length": 60, "domain": null }, { "name": "TASKSID", "type": "esriFieldTypeDouble", "alias": "TASKSID", "domain": null }, { "name": "TASKNAME", "type": "esriFieldTypeString", "alias": "TASKNAME", "length": 50, "domain": null }, { "name": "Task_Description", "type": "esriFieldTypeString", "alias": "Task_Description", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 250, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "TASKSEQID", "type": "esriFieldTypeInteger", "alias": "TASKSEQID", "domain": null }, { "name": "ENTITYUID", "type": "esriFieldTypeString", "alias": "ENTITYUID", "length": 50, "domain": null }, { "name": "Workorder_Description", "type": "esriFieldTypeString", "alias": "Workorder_Description", "length": 60, "domain": null }, { "name": "INITIATEDATE", "type": "esriFieldTypeDate", "alias": "INITIATEDATE", "length": 8, "domain": null }, { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "length": 50, "domain": null }, { "name": "DATEWOCLOSED", "type": "esriFieldTypeDate", "alias": "DATEWOCLOSED", "length": 8, "domain": null }, { "name": "WOCLOSEDBY", "type": "esriFieldTypeString", "alias": "WOCLOSEDBY", "length": 50, "domain": null }, { "name": "WORKCOMPLETEDBY", "type": "esriFieldTypeString", "alias": "WORKCOMPLETEDBY", "length": 50, "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 9, "name": "Barricade_Work_Orders", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TASKNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WOTASKID", "type": "esriFieldTypeDouble", "alias": "WOTASKID", "domain": null }, { "name": "TASK_WO_ID", "type": "esriFieldTypeString", "alias": "TASK_WO_ID", "length": 60, "domain": null }, { "name": "TASKSID", "type": "esriFieldTypeDouble", "alias": "TASKSID", "domain": null }, { "name": "TASKCODE", "type": "esriFieldTypeString", "alias": "TASKCODE", "length": 20, "domain": null }, { "name": "TASKNAME", "type": "esriFieldTypeString", "alias": "TASKNAME", "length": 50, "domain": null }, { "name": "Task_Description", "type": "esriFieldTypeString", "alias": "Task_Description", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 250, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "ACTSTARTDATE", "type": "esriFieldTypeDate", "alias": "ACTSTARTDATE", "length": 8, "domain": null }, { "name": "ACTFINISHDATE", "type": "esriFieldTypeDate", "alias": "ACTFINISHDATE", "length": 8, "domain": null }, { "name": "TASKSEQID", "type": "esriFieldTypeInteger", "alias": "TASKSEQID", "domain": null }, { "name": "ENTITYUID", "type": "esriFieldTypeString", "alias": "ENTITYUID", "length": 50, "domain": null }, { "name": "Workorder_Description", "type": "esriFieldTypeString", "alias": "Workorder_Description", "length": 60, "domain": null }, { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "length": 60, "domain": null }, { "name": "SUBMITTO", "type": "esriFieldTypeString", "alias": "SUBMITTO", "length": 50, "domain": null }, { "name": "REQUESTEDBY", "type": "esriFieldTypeString", "alias": "REQUESTEDBY", "length": 50, "domain": null }, { "name": "INITIATEDATE", "type": "esriFieldTypeDate", "alias": "INITIATEDATE", "length": 8, "domain": null }, { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "length": 50, "domain": null }, { "name": "DATEWOCLOSED", "type": "esriFieldTypeDate", "alias": "DATEWOCLOSED", "length": 8, "domain": null }, { "name": "WOCLOSEDBY", "type": "esriFieldTypeString", "alias": "WOCLOSEDBY", "length": 50, "domain": null }, { "name": "WORKCOMPLETEDBY", "type": "esriFieldTypeString", "alias": "WORKCOMPLETEDBY", "length": 50, "domain": null }, { "name": "WOADDRESS", "type": "esriFieldTypeString", "alias": "WOADDRESS", "length": 130, "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 10, "name": "Traffic_Service_Requests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROJECTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "REQUESTID", "type": "esriFieldTypeDouble", "alias": "REQUESTID", "domain": null }, { "name": "PROBLEMCODE", "type": "esriFieldTypeString", "alias": "PROBLEMCODE", "length": 20, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 50, "domain": null }, { "name": "PROBADDRESS", "type": "esriFieldTypeString", "alias": "PROBADDRESS", "length": 100, "domain": null }, { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "length": 50, "domain": null }, { "name": "SUBMITTO", "type": "esriFieldTypeString", "alias": "SUBMITTO", "length": 50, "domain": null }, { "name": "CLOSEDBY", "type": "esriFieldTypeString", "alias": "CLOSEDBY", "length": 50, "domain": null }, { "name": "INITIATEDDATE", "type": "esriFieldTypeDate", "alias": "INITIATEDDATE", "length": 8, "domain": null }, { "name": "DATETIMECLOSED", "type": "esriFieldTypeDate", "alias": "DATETIMECLOSED", "length": 8, "domain": null }, { "name": "PROJECTNAME", "type": "esriFieldTypeString", "alias": "PROJECTNAME", "length": 130, "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "DATESUBMITTO", "type": "esriFieldTypeDate", "alias": "DATESUBMITTO", "length": 8, "domain": null }, { "name": "SUBMITTOOPENBY", "type": "esriFieldTypeString", "alias": "SUBMITTOOPENBY", "length": 50, "domain": null }, { "name": "DATESUBMITTOOPEN", "type": "esriFieldTypeDate", "alias": "DATESUBMITTOOPEN", "length": 8, "domain": null }, { "name": "DISPATCHTO", "type": "esriFieldTypeString", "alias": "DISPATCHTO", "length": 50, "domain": null }, { "name": "DATEDISPATCHTO", "type": "esriFieldTypeDate", "alias": "DATEDISPATCHTO", "length": 8, "domain": null }, { "name": "DISPATCHOPENBY", "type": "esriFieldTypeString", "alias": "DISPATCHOPENBY", "length": 50, "domain": null }, { "name": "DATEDISPATCHOPEN", "type": "esriFieldTypeDate", "alias": "DATEDISPATCHOPEN", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "REQCATEGORY", "type": "esriFieldTypeString", "alias": "REQCATEGORY", "length": 50, "domain": null }, { "name": "DATECANCELLED", "type": "esriFieldTypeDate", "alias": "DATECANCELLED", "length": 8, "domain": null }, { "name": "INITIATEDBYAPP", "type": "esriFieldTypeString", "alias": "INITIATEDBYAPP", "length": 50, "domain": null }, { "name": "INITIATEDBYSID", "type": "esriFieldTypeInteger", "alias": "INITIATEDBYSID", "domain": null }, { "name": "SUBMITTOSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOSID", "domain": null }, { "name": "SUBMITTOOPENBYSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOOPENBYSID", "domain": null }, { "name": "CLOSEDBYSID", "type": "esriFieldTypeInteger", "alias": "CLOSEDBYSID", "domain": null }, { "name": "DISPATCHTOSID", "type": "esriFieldTypeInteger", "alias": "DISPATCHTOSID", "domain": null }, { "name": "DISPATCHOPENBYSID", "type": "esriFieldTypeInteger", "alias": "DISPATCHOPENBYSID", "domain": null }, { "name": "ToSRClose_Day", "type": "esriFieldTypeInteger", "alias": "ToSRClose_Day", "domain": null }, { "name": "ToSRClose_Hrs", "type": "esriFieldTypeInteger", "alias": "ToSRClose_Hrs", "domain": null }, { "name": "ToSRClose_Min", "type": "esriFieldTypeInteger", "alias": "ToSRClose_Min", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }