{ "layers" : [ { "currentVersion" : 12, "id" : 3, "name" : "MDOT_Points_Spatial_v70r0_3857", "type" : "Feature Layer", "serviceItemId" : "facf1e0aebb04e6eb4abf47fa6e2f38b", "cacheMaxAge" : 30, "displayField" : "PR_Number", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1715279582890, "schemaLastEditDate" : 1715272200527, "dataLastEditDate" : 1715279582890 }, "relationships" : [ { "id" : 0, "name" : "MdotJobsWithSources_v70r0", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "CanonicalContractID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -10039695.4931, "ymin" : 5121696.7586999983, "xmax" : -9175439.084, "ymax" : 6017962.8759, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"DemandType_Attr_value","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"Demand Type","classes":[{"label":"","description":"","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,128,111,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[[""]]},{"label":"Active Project","description":"Active Project","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,197,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Active Project"]]},{"label":"Future Project","description":"Future Project","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,197,255,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Future Project"]]},{"label":"Historic Project","description":"Historic Project","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Historic Project"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,128,111,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"","label":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,197,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Active Project","label":"Active Project"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,197,255,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Future Project","label":"Future Project"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Historic Project","label":"Historic Project"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,128,111,255],"toColor":[252,128,111,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[126,176,214,255],"toColor":[126,176,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[178,224,96,255],"toColor":[178,224,96,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,126,191,255],"toColor":[190,126,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,180,89,255],"toColor":[255,180,89,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,237,102,255],"toColor":[255,237,102,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,184,219,255],"toColor":[189,184,219,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,229,255],"toColor":[252,204,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[140,212,200,255],"toColor":[140,212,200,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,237,197,255],"toColor":[204,237,197,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "DemandType_Attr_value", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PR_Number", "type" : "esriFieldTypeString", "alias" : "PR Number", "sqlType" : "sqlTypeOther", "length" : 7, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PR_Beg_MP", "type" : "esriFieldTypeDouble", "alias" : "PR Begin Milepost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PR_End_MP", "type" : "esriFieldTypeDouble", "alias" : "PR End Milepost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "length", "type" : "esriFieldTypeDouble", "alias" : "Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalContractID", "type" : "esriFieldTypeString", "alias" : "Canonical Contract ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalJobSource", "type" : "esriFieldTypeString", "alias" : "Canonical Contract Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_Value", "type" : "esriFieldTypeString", "alias" : "Job Numbers", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_Source", "type" : "esriFieldTypeString", "alias" : "Job Numbers Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Length_1", "type" : "esriFieldTypeDouble", "alias" : "Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Expand", "type" : "esriFieldTypeString", "alias" : "Expand Flag", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PredictFlag", "type" : "esriFieldTypeString", "alias" : "Predict Flag", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CalendarRows", "type" : "esriFieldTypeInteger", "alias" : "Number of Calendar Rows", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_value", "type" : "esriFieldTypeString", "alias" : "Revised Grouping", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_source", "type" : "esriFieldTypeString", "alias" : "Revised Grouping Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_value", "type" : "esriFieldTypeString", "alias" : "Region", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_source", "type" : "esriFieldTypeString", "alias" : "Region Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_value", "type" : "esriFieldTypeString", "alias" : "TSC", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_source", "type" : "esriFieldTypeString", "alias" : "TSC Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_value", "type" : "esriFieldTypeString", "alias" : "Major Route", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_source", "type" : "esriFieldTypeString", "alias" : "Major Route Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_value", "type" : "esriFieldTypeString", "alias" : "Loaction Report", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_source", "type" : "esriFieldTypeString", "alias" : "Location Report Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_value", "type" : "esriFieldTypeString", "alias" : "Work Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_source", "type" : "esriFieldTypeString", "alias" : "Work Description Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionStart_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction Start", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionStart_Attr_source", "type" : "esriFieldTypeString", "alias" : "Construction Start Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionEnd_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction End", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionEnd_Attr_source", "type" : "esriFieldTypeString", "alias" : "Construction End Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PercentComplete_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Percent Complete", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PercentComplete_Attr_source", "type" : "esriFieldTypeString", "alias" : "Percent Complete Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_value", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_source", "type" : "esriFieldTypeString", "alias" : "Demand Type Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Point Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_source", "type" : "esriFieldTypeString", "alias" : "Point Projects Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Line Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_source", "type" : "esriFieldTypeString", "alias" : "Line Projects Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Total Project Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_source", "type" : "esriFieldTypeString", "alias" : "Total Project Length Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Original Spend", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_source", "type" : "esriFieldTypeString", "alias" : "Original Spend Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_value", "type" : "esriFieldTypeString", "alias" : "Total Lane Miles", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_source", "type" : "esriFieldTypeString", "alias" : "Total Lane Miles Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_value", "type" : "esriFieldTypeString", "alias" : "Structure Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_source", "type" : "esriFieldTypeString", "alias" : "Structure Number Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_value", "type" : "esriFieldTypeString", "alias" : "Bridge ID", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_source", "type" : "esriFieldTypeString", "alias" : "Bridge ID Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_value", "type" : "esriFieldTypeString", "alias" : "NBI", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_source", "type" : "esriFieldTypeString", "alias" : "NBI Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_value", "type" : "esriFieldTypeString", "alias" : "Finance System", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_source", "type" : "esriFieldTypeString", "alias" : "Finance System Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StartYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project Start Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EndYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project End Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nmonths_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Months", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nyears_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Years", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IsBridgeProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Bridge Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RollForwardProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Roll Forward Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Spend (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Spend (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "HMA (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Actuals_source", "type" : "esriFieldTypeString", "alias" : "HMA (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Concrete (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Aggregate (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Labor (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Labor (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Spend (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Spend (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "HMA (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Estimates_source", "type" : "esriFieldTypeString", "alias" : "HMA (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Concrete (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Aggregate (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Labor (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Labor (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Factors_source", "type" : "esriFieldTypeString", "alias" : "HMA Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Factors_source", "type" : "esriFieldTypeString", "alias" : "Concrete Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Factors_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Factors_source", "type" : "esriFieldTypeString", "alias" : "Labor Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Predictions_source", "type" : "esriFieldTypeString", "alias" : "HMA Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Concrete Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Predictions", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Spend Predictions (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Spend Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Expand_source", "type" : "esriFieldTypeString", "alias" : "Spend Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Expand_source", "type" : "esriFieldTypeString", "alias" : "HMA Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Expand_source", "type" : "esriFieldTypeString", "alias" : "Concrete Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Expand_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Expand_source", "type" : "esriFieldTypeString", "alias" : "Labor Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "All Labor Factor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Factors_source", "type" : "esriFieldTypeString", "alias" : "All Labor Factor Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Factor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Factors_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Factor Sorce", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Electrician Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Factors_source", "type" : "esriFieldTypeString", "alias" : "Electrician Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Factors_source", "type" : "esriFieldTypeString", "alias" : "Ironworker Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Factors_source", "type" : "esriFieldTypeString", "alias" : "Laborer Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "CementMason Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Factors_source", "type" : "esriFieldTypeString", "alias" : "CementMason Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Factors_source", "type" : "esriFieldTypeString", "alias" : "Operator Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Factors_sourc", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Factors_source", "type" : "esriFieldTypeString", "alias" : "Teamster Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "AllLabor Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Rates_source", "type" : "esriFieldTypeString", "alias" : "AllLabor Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Rates_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Electrician Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Rates_source", "type" : "esriFieldTypeString", "alias" : "Electrician Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Rates_source", "type" : "esriFieldTypeString", "alias" : "Ironworker Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Rates_source", "type" : "esriFieldTypeString", "alias" : "Laborer Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "CementMason Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Rates_source", "type" : "esriFieldTypeString", "alias" : "CementMason Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Rates_source", "type" : "esriFieldTypeString", "alias" : "Operator Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Rates_source", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Rates_source", "type" : "esriFieldTypeString", "alias" : "Teamster Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "AllLabor Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "AllLabor Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_LabPredictions_valu", "type" : "esriFieldTypeDouble", "alias" : "Electrician Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_LabPredictions_sour", "type" : "esriFieldTypeString", "alias" : "Electrician Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_LabPredictions_sourc", "type" : "esriFieldTypeString", "alias" : "Ironworker Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Laborer Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_LabPredictions_valu", "type" : "esriFieldTypeDouble", "alias" : "CementMason Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_LabPredictions_sour", "type" : "esriFieldTypeString", "alias" : "CementMason Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Operator Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_LabPrediction", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_LabPredicti_1", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Teamster Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GeometryType", "type" : "esriFieldTypeString", "alias" : "Geometry Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectDurationMonths", "type" : "esriFieldTypeInteger", "alias" : "Project Duration (Months)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectViewURL", "type" : "esriFieldTypeString", "alias" : "Project View Link", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOC_ANGLE", "type" : "esriFieldTypeDouble", "alias" : "LOC_ANGLE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOC_ERROR", "type" : "esriFieldTypeString", "alias" : "LOC_ERROR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "NEWID() WITH VALUES" }, { "name" : "IntegerYear", "type" : "esriFieldTypeString", "alias" : "Integer Year", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__MDOT_PRO__F4B70D8554CBF658", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3958.MDOT_PROGRAM_PLANNER_DATA_V7_MDOT_POINTS_SPATIAL_V70R0_3857_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "G3CanonicalContr", "fields" : "CanonicalContractID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : null, "name" : "\u003cNull\u003e", "domains" : { }, "templates" : [ { "name" : "\u003cNull\u003e", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LOC_ANGLE" : null, "LOC_ERROR" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Length_1" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : null, "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "GeometryType" : null, "ProjectDurationMonths" : null, "ProjectViewURL" : null, "IntegerYear" : null } } } ] }, { "id" : "Active Project", "name" : "Active Project", "domains" : { }, "templates" : [ { "name" : "Active Project", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LOC_ANGLE" : null, "LOC_ERROR" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Length_1" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : "Active Project", "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "GeometryType" : null, "ProjectDurationMonths" : null, "ProjectViewURL" : null, "IntegerYear" : null } } } ] }, { "id" : "Future Project", "name" : "Future Project", "domains" : { }, "templates" : [ { "name" : "Future Project", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LOC_ANGLE" : null, "LOC_ERROR" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Length_1" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : "Future Project", "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "GeometryType" : null, "ProjectDurationMonths" : null, "ProjectViewURL" : null, "IntegerYear" : null } } } ] }, { "id" : "Historic Project", "name" : "Historic Project", "domains" : { }, "templates" : [ { "name" : "Historic Project", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LOC_ANGLE" : null, "LOC_ERROR" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Length_1" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : "Historic Project", "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "GeometryType" : null, "ProjectDurationMonths" : null, "ProjectViewURL" : null, "IntegerYear" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract,Sync" }, { "currentVersion" : 12, "id" : 1, "name" : "ASD_Points_Spatial_3857", "type" : "Feature Layer", "serviceItemId" : "facf1e0aebb04e6eb4abf47fa6e2f38b", "cacheMaxAge" : 30, "displayField" : "PR_Number", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1715279582890, "schemaLastEditDate" : 1715272543357, "dataLastEditDate" : 1715279582890 }, "relationships" : [ { "id" : 1, "name" : "MdotJobsWithSources_v70r0", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "CanonicalContractID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -9971319.1579, "ymin" : 5121696.7586999983, "xmax" : -9175439.084, "ymax" : 6017962.8759, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"DemandType_Attr_value","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"Demand Type","classes":[{"label":"","description":"","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,128,111,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[[""]]},{"label":"Active Project","description":"Active Project","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,197,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Active Project"]]},{"label":"Future Project","description":"Future Project","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,197,255,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Future Project"]]},{"label":"Historic Project","description":"Historic Project","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Historic Project"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,128,111,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"","label":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,197,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Active Project","label":"Active Project"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,197,255,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Future Project","label":"Future Project"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Historic Project","label":"Historic Project"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,128,111,255],"toColor":[252,128,111,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[126,176,214,255],"toColor":[126,176,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[178,224,96,255],"toColor":[178,224,96,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,126,191,255],"toColor":[190,126,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,180,89,255],"toColor":[255,180,89,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,237,102,255],"toColor":[255,237,102,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,184,219,255],"toColor":[189,184,219,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,229,255],"toColor":[252,204,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[140,212,200,255],"toColor":[140,212,200,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,237,197,255],"toColor":[204,237,197,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "ExpandedDate", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [ 1514764800000, 1830297600000 ], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "timeInterval" : 0, "timeIntervalUnits" : "", "exportOptions" : { "useTime" : false, "timeDataCumulative" : false, "TimeOffset" : 0, "timeOffsetUnits" : "esriTimeUnitsCenturies" }, "hasLiveData" : false }, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "DemandType_Attr_value", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PR_Number", "type" : "esriFieldTypeString", "alias" : "PR Number", "sqlType" : "sqlTypeOther", "length" : 7, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PR_Beg_MP", "type" : "esriFieldTypeDouble", "alias" : "PR Begin Milepost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PR_End_MP", "type" : "esriFieldTypeDouble", "alias" : "PR End Milepost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "length", "type" : "esriFieldTypeDouble", "alias" : "Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalContractID", "type" : "esriFieldTypeString", "alias" : "Canonical Contract ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_value", "type" : "esriFieldTypeString", "alias" : "Job Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber", "type" : "esriFieldTypeString", "alias" : "Structure Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId", "type" : "esriFieldTypeString", "alias" : "Bridge ID", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI", "type" : "esriFieldTypeString", "alias" : "NBI", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalJobNumber", "type" : "esriFieldTypeString", "alias" : "Canonical Job Number", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalJobSource", "type" : "esriFieldTypeString", "alias" : "Canonical Job Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PredictFlag", "type" : "esriFieldTypeString", "alias" : "Predict Flag", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CalendarRows", "type" : "esriFieldTypeInteger", "alias" : "Number of Calendar Rows", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_value", "type" : "esriFieldTypeString", "alias" : "Revised Grouping", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_value", "type" : "esriFieldTypeString", "alias" : "Region", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_value", "type" : "esriFieldTypeString", "alias" : "TSC", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_value", "type" : "esriFieldTypeString", "alias" : "Major Route", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_value", "type" : "esriFieldTypeString", "alias" : "Location Report", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_value", "type" : "esriFieldTypeString", "alias" : "Work Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionStart_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction Start", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionEnd_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction End", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PercentComplete_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Percent Complete", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_value", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Point Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Line Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Total Project Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Original Spend", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_value", "type" : "esriFieldTypeString", "alias" : "Total Lane Miles", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_value", "type" : "esriFieldTypeString", "alias" : "Structure Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_value", "type" : "esriFieldTypeString", "alias" : "Bridge ID", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_value", "type" : "esriFieldTypeString", "alias" : "NBI", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_value", "type" : "esriFieldTypeString", "alias" : "Finance System", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StartYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project Start Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EndYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project End Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nmonths_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Months", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nyears_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Years", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IsBridgeProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Bridge Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RollForwardProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Roll Forward Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GeometryType", "type" : "esriFieldTypeString", "alias" : "Geometry Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ExpandedDate", "type" : "esriFieldTypeDate", "alias" : "Expanded Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "IntegerYear", "type" : "esriFieldTypeInteger", "alias" : "Year (Integer)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ExpandedAmount", "type" : "esriFieldTypeDouble", "alias" : "Expanded Amount", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MaterialType", "type" : "esriFieldTypeString", "alias" : "Material Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SpatialAdjustment", "type" : "esriFieldTypeDouble", "alias" : "Spatial Adjustment Factor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VisualDemandClass", "type" : "esriFieldTypeString", "alias" : "Visual Demand Class", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DataSource", "type" : "esriFieldTypeString", "alias" : "Data Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectViewURL", "type" : "esriFieldTypeString", "alias" : "Project View Link", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOC_ANGLE", "type" : "esriFieldTypeDouble", "alias" : "LOC_ANGLE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOC_ERROR", "type" : "esriFieldTypeString", "alias" : "LOC_ERROR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "NEWID() WITH VALUES" } ], "indexes" : [ { "name" : "PK__MDOT_PRO__F4B70D85FCAF75FC", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3958.MDOT_PROGRAM_PLANNER_DATA_V7_ASD_POINTS_SPATIAL_3857_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "G5CanonicalContr", "fields" : "CanonicalContractID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "DemandType_Attr_value_Index", "fields" : "DemandType_Attr_value", "isAscending" : true, "isUnique" : false, "description" : "DemandType_Attr_value_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : null, "name" : "\u003cNull\u003e", "domains" : { }, "templates" : [ { "name" : "\u003cNull\u003e", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LOC_ANGLE" : null, "LOC_ERROR" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "JobNumbers_Attr_value" : null, "StructureNumber" : null, "BridgeId" : null, "NBI" : null, "CanonicalJobNumber" : null, "CanonicalJobSource" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : null, "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "GeometryType" : null, "ExpandedDate" : null, "IntegerYear" : null, "Material" : null, "DemandType" : null, "ExpandedAmount" : null, "MaterialType" : null, "SpatialAdjustment" : null, "VisualDemandClass" : null, "DataSource" : null, "ProjectViewURL" : null } } } ] }, { "id" : "Active Project", "name" : "Active Project", "domains" : { }, "templates" : [ { "name" : "Active Project", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LOC_ANGLE" : null, "LOC_ERROR" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "JobNumbers_Attr_value" : null, "StructureNumber" : null, "BridgeId" : null, "NBI" : null, "CanonicalJobNumber" : null, "CanonicalJobSource" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : "Active Project", "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "GeometryType" : null, "ExpandedDate" : null, "IntegerYear" : null, "Material" : null, "DemandType" : null, "ExpandedAmount" : null, "MaterialType" : null, "SpatialAdjustment" : null, "VisualDemandClass" : null, "DataSource" : null, "ProjectViewURL" : null } } } ] }, { "id" : "Future Project", "name" : "Future Project", "domains" : { }, "templates" : [ { "name" : "Future Project", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LOC_ANGLE" : null, "LOC_ERROR" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "JobNumbers_Attr_value" : null, "StructureNumber" : null, "BridgeId" : null, "NBI" : null, "CanonicalJobNumber" : null, "CanonicalJobSource" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : "Future Project", "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "GeometryType" : null, "ExpandedDate" : null, "IntegerYear" : null, "Material" : null, "DemandType" : null, "ExpandedAmount" : null, "MaterialType" : null, "SpatialAdjustment" : null, "VisualDemandClass" : null, "DataSource" : null, "ProjectViewURL" : null } } } ] }, { "id" : "Historic Project", "name" : "Historic Project", "domains" : { }, "templates" : [ { "name" : "Historic Project", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LOC_ANGLE" : null, "LOC_ERROR" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "JobNumbers_Attr_value" : null, "StructureNumber" : null, "BridgeId" : null, "NBI" : null, "CanonicalJobNumber" : null, "CanonicalJobSource" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : "Historic Project", "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "GeometryType" : null, "ExpandedDate" : null, "IntegerYear" : null, "Material" : null, "DemandType" : null, "ExpandedAmount" : null, "MaterialType" : null, "SpatialAdjustment" : null, "VisualDemandClass" : null, "DataSource" : null, "ProjectViewURL" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract,Sync" }, { "currentVersion" : 12, "id" : 2, "name" : "MDOT_Lines_Spatial_v70r0_3857", "type" : "Feature Layer", "serviceItemId" : "facf1e0aebb04e6eb4abf47fa6e2f38b", "cacheMaxAge" : 30, "displayField" : "PR_Number", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1715282662678, "schemaLastEditDate" : 1715282662678, "dataLastEditDate" : 1715279582890 }, "multiScaleGeometryInfo" : { "levels" : [ 3, 5, 7, 9, 11, 13, 15 ], "generalizationType" : "Default" }, "relationships" : [ { "id" : 2, "name" : "MdotJobsWithSources_v70r0", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "CanonicalContractID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -10040180.5633, "ymin" : 5115867.8759, "xmax" : -9175419.781, "ymax" : 6020748.2849999964, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"DemandType_Attr_value","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1},"defaultLabel":"","uniqueValueGroups":[{"heading":"Demand Type","classes":[{"label":"","description":"","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[252,128,111,255],"width":1},"values":[[""]]},{"label":"Active Project","description":"Active Project","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":1},"values":[["Active Project"]]},{"label":"Future Project","description":"Future Project","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":1},"values":[["Future Project"]]},{"label":"Historic Project","description":"Historic Project","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":1},"values":[["Historic Project"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[252,128,111,255],"width":1},"value":"","label":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":1},"value":"Active Project","label":"Active Project"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":1},"value":"Future Project","label":"Future Project"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":1},"value":"Historic Project","label":"Historic Project"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,128,111,255],"toColor":[252,128,111,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[126,176,214,255],"toColor":[126,176,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[178,224,96,255],"toColor":[178,224,96,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,126,191,255],"toColor":[190,126,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,180,89,255],"toColor":[255,180,89,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,237,102,255],"toColor":[255,237,102,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,184,219,255],"toColor":[189,184,219,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,229,255],"toColor":[252,204,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[140,212,200,255],"toColor":[140,212,200,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,237,197,255],"toColor":[204,237,197,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "DemandType_Attr_value", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PR_Number", "type" : "esriFieldTypeString", "alias" : "PR Number", "sqlType" : "sqlTypeOther", "length" : 7, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PR_Beg_MP", "type" : "esriFieldTypeDouble", "alias" : "PR Begin Milepost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PR_End_MP", "type" : "esriFieldTypeDouble", "alias" : "PR End Milepost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "length", "type" : "esriFieldTypeDouble", "alias" : "Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalContractID", "type" : "esriFieldTypeString", "alias" : "Canonical Contract ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalJobSource", "type" : "esriFieldTypeString", "alias" : "Canonical Contract Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_Value", "type" : "esriFieldTypeString", "alias" : "Job Numbers", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_Source", "type" : "esriFieldTypeString", "alias" : "Job Numbers Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Length_1", "type" : "esriFieldTypeDouble", "alias" : "Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Expand", "type" : "esriFieldTypeString", "alias" : "Expand Flag", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PredictFlag", "type" : "esriFieldTypeString", "alias" : "Predict Flag", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CalendarRows", "type" : "esriFieldTypeInteger", "alias" : "Number of Calendar Rows", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_value", "type" : "esriFieldTypeString", "alias" : "Revised Grouping", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_source", "type" : "esriFieldTypeString", "alias" : "Revised Grouping Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_value", "type" : "esriFieldTypeString", "alias" : "Region", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_source", "type" : "esriFieldTypeString", "alias" : "Region Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_value", "type" : "esriFieldTypeString", "alias" : "TSC", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_source", "type" : "esriFieldTypeString", "alias" : "TSC Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_value", "type" : "esriFieldTypeString", "alias" : "Major Route", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_source", "type" : "esriFieldTypeString", "alias" : "Major Route Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_value", "type" : "esriFieldTypeString", "alias" : "Loaction Report", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_source", "type" : "esriFieldTypeString", "alias" : "Location Report Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_value", "type" : "esriFieldTypeString", "alias" : "Work Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_source", "type" : "esriFieldTypeString", "alias" : "Work Description Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionStart_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction Start", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionStart_Attr_source", "type" : "esriFieldTypeString", "alias" : "Construction Start Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionEnd_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction End", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionEnd_Attr_source", "type" : "esriFieldTypeString", "alias" : "Construction End Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PercentComplete_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Percent Complete", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PercentComplete_Attr_source", "type" : "esriFieldTypeString", "alias" : "Percent Complete Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_value", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_source", "type" : "esriFieldTypeString", "alias" : "Demand Type Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Point Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_source", "type" : "esriFieldTypeString", "alias" : "Point Projects Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Line Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_source", "type" : "esriFieldTypeString", "alias" : "Line Projects Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Total Project Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_source", "type" : "esriFieldTypeString", "alias" : "Total Project Length Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Original Spend", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_source", "type" : "esriFieldTypeString", "alias" : "Original Spend Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_value", "type" : "esriFieldTypeString", "alias" : "Total Lane Miles", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_source", "type" : "esriFieldTypeString", "alias" : "Total Lane Miles Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_value", "type" : "esriFieldTypeString", "alias" : "Structure Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_source", "type" : "esriFieldTypeString", "alias" : "Structure Number Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_value", "type" : "esriFieldTypeString", "alias" : "Bridge ID", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_source", "type" : "esriFieldTypeString", "alias" : "Bridge ID Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_value", "type" : "esriFieldTypeString", "alias" : "NBI", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_source", "type" : "esriFieldTypeString", "alias" : "NBI Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_value", "type" : "esriFieldTypeString", "alias" : "Finance System", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_source", "type" : "esriFieldTypeString", "alias" : "Finance System Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StartYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project Start Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EndYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project End Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nmonths_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Months", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nyears_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Years", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IsBridgeProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Bridge Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RollForwardProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Roll Forward Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Spend (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Spend (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "HMA (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Actuals_source", "type" : "esriFieldTypeString", "alias" : "HMA (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Concrete (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Aggregate (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Labor (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Labor (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Spend (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Spend (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "HMA (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Estimates_source", "type" : "esriFieldTypeString", "alias" : "HMA (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Concrete (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Aggregate (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Labor (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Labor (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Factors_source", "type" : "esriFieldTypeString", "alias" : "HMA Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Factors_source", "type" : "esriFieldTypeString", "alias" : "Concrete Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Factors_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Factors_source", "type" : "esriFieldTypeString", "alias" : "Labor Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Predictions_source", "type" : "esriFieldTypeString", "alias" : "HMA Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Concrete Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Predictions", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Spend Predictions (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Spend Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Expand_source", "type" : "esriFieldTypeString", "alias" : "Spend Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Expand_source", "type" : "esriFieldTypeString", "alias" : "HMA Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Expand_source", "type" : "esriFieldTypeString", "alias" : "Concrete Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Expand_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Expand_source", "type" : "esriFieldTypeString", "alias" : "Labor Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "All Labor Factor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Factors_source", "type" : "esriFieldTypeString", "alias" : "All Labor Factor Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Factor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Factors_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Factor Sorce", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Electrician Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Factors_source", "type" : "esriFieldTypeString", "alias" : "Electrician Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Factors_source", "type" : "esriFieldTypeString", "alias" : "Ironworker Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Factors_source", "type" : "esriFieldTypeString", "alias" : "Laborer Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "CementMason Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Factors_source", "type" : "esriFieldTypeString", "alias" : "CementMason Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Factors_source", "type" : "esriFieldTypeString", "alias" : "Operator Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Factors_sourc", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Factors_source", "type" : "esriFieldTypeString", "alias" : "Teamster Factors Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "AllLabor Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Rates_source", "type" : "esriFieldTypeString", "alias" : "AllLabor Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Rates_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Electrician Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Rates_source", "type" : "esriFieldTypeString", "alias" : "Electrician Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Rates_source", "type" : "esriFieldTypeString", "alias" : "Ironworker Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Rates_source", "type" : "esriFieldTypeString", "alias" : "Laborer Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "CementMason Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Rates_source", "type" : "esriFieldTypeString", "alias" : "CementMason Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Rates_source", "type" : "esriFieldTypeString", "alias" : "Operator Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Rates_source", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Rates_source", "type" : "esriFieldTypeString", "alias" : "Teamster Rates Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "AllLabor Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "AllLabor Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_LabPredictions_valu", "type" : "esriFieldTypeDouble", "alias" : "Electrician Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_LabPredictions_sour", "type" : "esriFieldTypeString", "alias" : "Electrician Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_LabPredictions_sourc", "type" : "esriFieldTypeString", "alias" : "Ironworker Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Laborer Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_LabPredictions_valu", "type" : "esriFieldTypeDouble", "alias" : "CementMason Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_LabPredictions_sour", "type" : "esriFieldTypeString", "alias" : "CementMason Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Operator Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_LabPrediction", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_LabPredicti_1", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Teamster Predictions Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GeometryType", "type" : "esriFieldTypeString", "alias" : "Geometry Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectDurationMonths", "type" : "esriFieldTypeInteger", "alias" : "Project Duration (Months)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectViewURL", "type" : "esriFieldTypeString", "alias" : "Project View Link", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOC_ERROR", "type" : "esriFieldTypeString", "alias" : "LOC_ERROR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "NEWID() WITH VALUES" } ], "indexes" : [ { "name" : "PK__MDOT_PRO__F4B70D8564EFFA7B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3958.MDOT_PROGRAM_PLANNER_DATA_V7_MDOT_LINES_SPATIAL_V70R0_3857_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "G8CanonicalContr", "fields" : "CanonicalContractID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : null, "name" : "\u003cNull\u003e", "domains" : { }, "templates" : [ { "name" : "\u003cNull\u003e", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LOC_ERROR" : null, "ProjectViewURL" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Length_1" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : null, "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "GeometryType" : null, "ProjectDurationMonths" : null } } } ] }, { "id" : "Active Project", "name" : "Active Project", "domains" : { }, "templates" : [ { "name" : "Active Project", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LOC_ERROR" : null, "ProjectViewURL" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Length_1" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : "Active Project", "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "GeometryType" : null, "ProjectDurationMonths" : null } } } ] }, { "id" : "Future Project", "name" : "Future Project", "domains" : { }, "templates" : [ { "name" : "Future Project", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LOC_ERROR" : null, "ProjectViewURL" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Length_1" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : "Future Project", "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "GeometryType" : null, "ProjectDurationMonths" : null } } } ] }, { "id" : "Historic Project", "name" : "Historic Project", "domains" : { }, "templates" : [ { "name" : "Historic Project", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LOC_ERROR" : null, "ProjectViewURL" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Length_1" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : "Historic Project", "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "GeometryType" : null, "ProjectDurationMonths" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract,Sync" }, { "currentVersion" : 12, "id" : 0, "name" : "ASD_Lines_Spatial_3857", "type" : "Feature Layer", "serviceItemId" : "facf1e0aebb04e6eb4abf47fa6e2f38b", "cacheMaxAge" : 30, "displayField" : "PR_Number", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1715283326794, "schemaLastEditDate" : 1715283326794, "dataLastEditDate" : 1715279582890 }, "multiScaleGeometryInfo" : { "levels" : [ 3, 5, 7, 9, 11, 13, 15 ], "generalizationType" : "Default" }, "relationships" : [ { "id" : 3, "name" : "MdotJobsWithSources_v70r0", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "CanonicalContractID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -10040180.5633, "ymin" : 5115867.8759, "xmax" : -9175419.781, "ymax" : 6020748.2849999964, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"DemandType_Attr_value","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1},"defaultLabel":"","uniqueValueGroups":[{"heading":"Demand Type","classes":[{"label":"","description":"","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[252,128,111,255],"width":1},"values":[[""]]},{"label":"Active Project","description":"Active Project","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":1},"values":[["Active Project"]]},{"label":"Future Project","description":"Future Project","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":1},"values":[["Future Project"]]},{"label":"Historic Project","description":"Historic Project","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":1},"values":[["Historic Project"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[252,128,111,255],"width":1},"value":"","label":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":1},"value":"Active Project","label":"Active Project"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":1},"value":"Future Project","label":"Future Project"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":1},"value":"Historic Project","label":"Historic Project"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,128,111,255],"toColor":[252,128,111,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[126,176,214,255],"toColor":[126,176,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[178,224,96,255],"toColor":[178,224,96,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,126,191,255],"toColor":[190,126,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,180,89,255],"toColor":[255,180,89,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,237,102,255],"toColor":[255,237,102,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,184,219,255],"toColor":[189,184,219,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,229,255],"toColor":[252,204,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[140,212,200,255],"toColor":[140,212,200,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,237,197,255],"toColor":[204,237,197,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "ExpandedDate", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [ 1514764800000, 1830297600000 ], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "timeInterval" : 0, "timeIntervalUnits" : "", "exportOptions" : { "useTime" : false, "timeDataCumulative" : false, "TimeOffset" : 0, "timeOffsetUnits" : "esriTimeUnitsCenturies" }, "hasLiveData" : false }, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "DemandType_Attr_value", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PR_Number", "type" : "esriFieldTypeString", "alias" : "PR Number", "sqlType" : "sqlTypeOther", "length" : 7, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PR_Beg_MP", "type" : "esriFieldTypeDouble", "alias" : "PR Begin Milepost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PR_End_MP", "type" : "esriFieldTypeDouble", "alias" : "PR End Milepost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "length", "type" : "esriFieldTypeDouble", "alias" : "Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalContractID", "type" : "esriFieldTypeString", "alias" : "Canonical Contract ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_value", "type" : "esriFieldTypeString", "alias" : "Job Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber", "type" : "esriFieldTypeString", "alias" : "Structure Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId", "type" : "esriFieldTypeString", "alias" : "Bridge ID", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI", "type" : "esriFieldTypeString", "alias" : "NBI", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalJobNumber", "type" : "esriFieldTypeString", "alias" : "Canonical Job Number", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalJobSource", "type" : "esriFieldTypeString", "alias" : "Canonical Job Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PredictFlag", "type" : "esriFieldTypeString", "alias" : "Predict Flag", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CalendarRows", "type" : "esriFieldTypeInteger", "alias" : "Number of Calendar Rows", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_value", "type" : "esriFieldTypeString", "alias" : "Revised Grouping", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_value", "type" : "esriFieldTypeString", "alias" : "Region", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_value", "type" : "esriFieldTypeString", "alias" : "TSC", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_value", "type" : "esriFieldTypeString", "alias" : "Major Route", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_value", "type" : "esriFieldTypeString", "alias" : "Location Report", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_value", "type" : "esriFieldTypeString", "alias" : "Work Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionStart_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction Start", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionEnd_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction End", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PercentComplete_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Percent Complete", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_value", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Point Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Line Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Total Project Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Original Spend", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_value", "type" : "esriFieldTypeString", "alias" : "Total Lane Miles", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_value", "type" : "esriFieldTypeString", "alias" : "Structure Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_value", "type" : "esriFieldTypeString", "alias" : "Bridge ID", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_value", "type" : "esriFieldTypeString", "alias" : "NBI", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_value", "type" : "esriFieldTypeString", "alias" : "Finance System", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StartYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project Start Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EndYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project End Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nmonths_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Months", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nyears_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Years", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IsBridgeProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Bridge Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RollForwardProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Roll Forward Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GeometryType", "type" : "esriFieldTypeString", "alias" : "Geometry Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ExpandedDate", "type" : "esriFieldTypeDate", "alias" : "Expanded Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "IntegerYear", "type" : "esriFieldTypeInteger", "alias" : "Year (Integer)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ExpandedAmount", "type" : "esriFieldTypeDouble", "alias" : "Expanded Amount", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MaterialType", "type" : "esriFieldTypeString", "alias" : "Material Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SpatialAdjustment", "type" : "esriFieldTypeDouble", "alias" : "Spatial Adjustment Factor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VisualDemandClass", "type" : "esriFieldTypeString", "alias" : "Visual Demand Class", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DataSource", "type" : "esriFieldTypeString", "alias" : "Data Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectViewURL", "type" : "esriFieldTypeString", "alias" : "Project View Link", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOC_ERROR", "type" : "esriFieldTypeString", "alias" : "LOC_ERROR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "NEWID() WITH VALUES" } ], "indexes" : [ { "name" : "PK__MDOT_PRO__F4B70D85262B5B8E", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3958.MDOT_PROGRAM_PLANNER_DATA_V7_ASD_LINES_SPATIAL_3857_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "G6CanonicalContr", "fields" : "CanonicalContractID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "DemandType_Attr_value_Index", "fields" : "DemandType_Attr_value", "isAscending" : true, "isUnique" : false, "description" : "DemandType_Attr_value_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : null, "name" : "\u003cNull\u003e", "domains" : { }, "templates" : [ { "name" : "\u003cNull\u003e", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LOC_ERROR" : null, "ProjectViewURL" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "JobNumbers_Attr_value" : null, "StructureNumber" : null, "BridgeId" : null, "NBI" : null, "CanonicalJobNumber" : null, "CanonicalJobSource" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : null, "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "GeometryType" : null, "ExpandedDate" : null, "IntegerYear" : null, "Material" : null, "DemandType" : null, "ExpandedAmount" : null, "MaterialType" : null, "SpatialAdjustment" : null, "VisualDemandClass" : null, "DataSource" : null } } } ] }, { "id" : "Active Project", "name" : "Active Project", "domains" : { }, "templates" : [ { "name" : "Active Project", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LOC_ERROR" : null, "ProjectViewURL" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "JobNumbers_Attr_value" : null, "StructureNumber" : null, "BridgeId" : null, "NBI" : null, "CanonicalJobNumber" : null, "CanonicalJobSource" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : "Active Project", "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "GeometryType" : null, "ExpandedDate" : null, "IntegerYear" : null, "Material" : null, "DemandType" : null, "ExpandedAmount" : null, "MaterialType" : null, "SpatialAdjustment" : null, "VisualDemandClass" : null, "DataSource" : null } } } ] }, { "id" : "Future Project", "name" : "Future Project", "domains" : { }, "templates" : [ { "name" : "Future Project", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LOC_ERROR" : null, "ProjectViewURL" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "JobNumbers_Attr_value" : null, "StructureNumber" : null, "BridgeId" : null, "NBI" : null, "CanonicalJobNumber" : null, "CanonicalJobSource" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : "Future Project", "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "GeometryType" : null, "ExpandedDate" : null, "IntegerYear" : null, "Material" : null, "DemandType" : null, "ExpandedAmount" : null, "MaterialType" : null, "SpatialAdjustment" : null, "VisualDemandClass" : null, "DataSource" : null } } } ] }, { "id" : "Historic Project", "name" : "Historic Project", "domains" : { }, "templates" : [ { "name" : "Historic Project", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LOC_ERROR" : null, "ProjectViewURL" : null, "PR_Number" : null, "PR_Beg_MP" : null, "PR_End_MP" : null, "length" : null, "CanonicalContractID" : null, "JobNumbers_Attr_value" : null, "StructureNumber" : null, "BridgeId" : null, "NBI" : null, "CanonicalJobNumber" : null, "CanonicalJobSource" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : "Historic Project", "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "GeometryType" : null, "ExpandedDate" : null, "IntegerYear" : null, "Material" : null, "DemandType" : null, "ExpandedAmount" : null, "MaterialType" : null, "SpatialAdjustment" : null, "VisualDemandClass" : null, "DataSource" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract,Sync" } ], "tables" : [ { "currentVersion" : 12, "id" : 4, "name" : "MdotDemandCalendar_v70r0", "type" : "Table", "serviceItemId" : "facf1e0aebb04e6eb4abf47fa6e2f38b", "cacheMaxAge" : 30, "displayField" : "CanonicalContractID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1715279582890, "schemaLastEditDate" : 1715279582890, "dataLastEditDate" : 1715279582890 }, "relationships" : [ { "id" : 4, "name" : "MdotJobsWithSources_v70r0", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "CanonicalContractID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalContractID", "type" : "esriFieldTypeString", "alias" : "Canonical Contract ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalDataSource", "type" : "esriFieldTypeString", "alias" : "Canonical Data Source", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_value", "type" : "esriFieldTypeString", "alias" : "Job Numbers", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_value", "type" : "esriFieldTypeString", "alias" : "Revised Grouping", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_value", "type" : "esriFieldTypeString", "alias" : "Region", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_value", "type" : "esriFieldTypeString", "alias" : "TSC", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_value", "type" : "esriFieldTypeString", "alias" : "Major Route", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_value", "type" : "esriFieldTypeString", "alias" : "Location Report", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_value", "type" : "esriFieldTypeString", "alias" : "Work Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionStart_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction Start", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionEnd_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction End", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PercentComplete_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Percent Complete", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_value", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Point Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Line Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Total Project Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Original Spend", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_value", "type" : "esriFieldTypeString", "alias" : "Lane Miles", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_value", "type" : "esriFieldTypeString", "alias" : "Structure Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_value", "type" : "esriFieldTypeString", "alias" : "Bridge ID", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_value", "type" : "esriFieldTypeString", "alias" : "NBI", "sqlType" : "sqlTypeOther", "length" : 1999, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_value", "type" : "esriFieldTypeString", "alias" : "Finance System", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StartYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project Start Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EndYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project End Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nmonths_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Months", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nyears_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Years", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IsBridgeProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Bridge Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RollForwardProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Roll Forward Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumber", "type" : "esriFieldTypeString", "alias" : "Job Number", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ExpandedDate", "type" : "esriFieldTypeDate", "alias" : "Expanded Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ExpandedAmount", "type" : "esriFieldTypeDouble", "alias" : "Expanded Amount", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DataSource", "type" : "esriFieldTypeString", "alias" : "Data Source", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MaterialType", "type" : "esriFieldTypeString", "alias" : "Material Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VisualDemandClass", "type" : "esriFieldTypeString", "alias" : "Visual Demand Class", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "NEWID() WITH VALUES" }, { "name" : "IntegerYear", "type" : "esriFieldTypeInteger", "alias" : "Integer Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__MDOT_PRO__F4B70D85AE5DFDBE", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G7CanonicalContr", "fields" : "CanonicalContractID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "MdotDemandCalendar_v70r0", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "MaterialType" : null, "VisualDemandClass" : null, "CanonicalContractID" : null, "CanonicalDataSource" : null, "JobNumbers_Attr_value" : null, "RevisedGrouping_Attr_value" : null, "Region_Attr_value" : null, "TSC_Attr_value" : null, "MajorRoute_Attr_value" : null, "LocationReport_Attr_value" : null, "WorkDescription_Attr_value" : null, "ConstructionStart_Attr_value" : null, "ConstructionEnd_Attr_value" : null, "PercentComplete_Attr_value" : null, "DemandType_Attr_value" : null, "PointProjects_Attr_value" : null, "LineProjects_Attr_value" : null, "TotalProjectLength_Attr_value" : null, "OriginalSpend_Attr_value" : null, "TotalLaneMiles_Attr_value" : null, "StructureNumber_Attr_value" : null, "BridgeId_Attr_value" : null, "NBI_Attr_value" : null, "FinanceSystem_Attr_value" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "JobNumber" : null, "ExpandedDate" : null, "Material" : null, "ExpandedAmount" : null, "DataSource" : null, "DemandType" : null, "IntegerYear" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 32000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract,Sync", "layerOverrides" : [ "allowGeometryUpdates", "capabilities" ] }, { "currentVersion" : 12, "id" : 5, "name" : "MdotJobsWithSources_v70r0", "type" : "Table", "serviceItemId" : "facf1e0aebb04e6eb4abf47fa6e2f38b", "cacheMaxAge" : 30, "displayField" : "CanonicalContractID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1715279582890, "schemaLastEditDate" : 1715277852906, "dataLastEditDate" : 1715279582890 }, "relationships" : [ { "id" : 0, "name" : "MDOT_Points_Spatial_v70r0_3857", "relatedTableId" : 3, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "CanonicalContractID", "composite" : false }, { "id" : 1, "name" : "ASD_Points_Spatial_3857", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "CanonicalContractID", "composite" : false }, { "id" : 3, "name" : "ASD_Lines_Spatial_3857", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "CanonicalContractID", "composite" : false }, { "id" : 4, "name" : "MdotDemandCalendar_v70r0", "relatedTableId" : 4, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "CanonicalContractID", "composite" : false }, { "id" : 2, "name" : "MDOT_Lines_Spatial_v70r0_3857", "relatedTableId" : 2, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "CanonicalContractID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalContractID", "type" : "esriFieldTypeString", "alias" : "Canonical Contract ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CanonicalJobSource", "type" : "esriFieldTypeString", "alias" : "Canonical Contract Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_Value", "type" : "esriFieldTypeString", "alias" : "Job Numbers", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JobNumbers_Attr_Source", "type" : "esriFieldTypeString", "alias" : "Job Numbers Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Expand", "type" : "esriFieldTypeString", "alias" : "Expand Flag", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PredictFlag", "type" : "esriFieldTypeString", "alias" : "Predict Flag", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CalendarRows", "type" : "esriFieldTypeInteger", "alias" : "Number of Calendar Rows", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_value", "type" : "esriFieldTypeString", "alias" : "Revised Grouping", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RevisedGrouping_Attr_source", "type" : "esriFieldTypeString", "alias" : "Revised Grouping Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_value", "type" : "esriFieldTypeString", "alias" : "Region", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region_Attr_source", "type" : "esriFieldTypeString", "alias" : "Region Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_value", "type" : "esriFieldTypeString", "alias" : "TSC", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TSC_Attr_source", "type" : "esriFieldTypeString", "alias" : "TSC Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_value", "type" : "esriFieldTypeString", "alias" : "Major Route", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MajorRoute_Attr_source", "type" : "esriFieldTypeString", "alias" : "Major Route Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_value", "type" : "esriFieldTypeString", "alias" : "Loaction Report", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationReport_Attr_source", "type" : "esriFieldTypeString", "alias" : "Location Report Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_value", "type" : "esriFieldTypeString", "alias" : "Work Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkDescription_Attr_source", "type" : "esriFieldTypeString", "alias" : "Work Description Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionStart_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction Start", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionStart_Attr_source", "type" : "esriFieldTypeString", "alias" : "Construction Start Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ConstructionEnd_Attr_value", "type" : "esriFieldTypeDate", "alias" : "Construction End", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ConstructionEnd_Attr_source", "type" : "esriFieldTypeString", "alias" : "Construction End Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PercentComplete_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Percent Complete", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PercentComplete_Attr_source", "type" : "esriFieldTypeString", "alias" : "Percent Complete Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_value", "type" : "esriFieldTypeString", "alias" : "Demand Type", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DemandType_Attr_source", "type" : "esriFieldTypeString", "alias" : "Demand Type Source", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Point Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PointProjects_Attr_source", "type" : "esriFieldTypeString", "alias" : "Point Projects Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Line Projects", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LineProjects_Attr_source", "type" : "esriFieldTypeString", "alias" : "Line Projects Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Total Project Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalProjectLength_Attr_source", "type" : "esriFieldTypeString", "alias" : "Total Project Length Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_value", "type" : "esriFieldTypeDouble", "alias" : "Original Spend", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OriginalSpend_Attr_source", "type" : "esriFieldTypeString", "alias" : "Original Spend Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_value", "type" : "esriFieldTypeString", "alias" : "Total Lane Miles", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TotalLaneMiles_Attr_source", "type" : "esriFieldTypeString", "alias" : "Total Lane Miles Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_value", "type" : "esriFieldTypeString", "alias" : "Structure Number", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructureNumber_Attr_source", "type" : "esriFieldTypeString", "alias" : "Structure Number Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_value", "type" : "esriFieldTypeString", "alias" : "Bridge ID", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BridgeId_Attr_source", "type" : "esriFieldTypeString", "alias" : "Bridge ID Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_value", "type" : "esriFieldTypeString", "alias" : "NBI", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBI_Attr_source", "type" : "esriFieldTypeString", "alias" : "NBI Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_value", "type" : "esriFieldTypeString", "alias" : "Finance System", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FinanceSystem_Attr_source", "type" : "esriFieldTypeString", "alias" : "Finance System Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StartYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project Start Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EndYear_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Project End Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nmonths_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Months", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nyears_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Number of Project Years", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IsBridgeProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Bridge Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RollForwardProject_Attr_value", "type" : "esriFieldTypeInteger", "alias" : "Is Roll Forward Project", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Spend (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Spend (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "HMA (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Actuals_source", "type" : "esriFieldTypeString", "alias" : "HMA (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Concrete (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Aggregate (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Actuals_value", "type" : "esriFieldTypeDouble", "alias" : "Labor (Actuals)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Actuals_source", "type" : "esriFieldTypeString", "alias" : "Labor (Actuals) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Spend (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Spend (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "HMA (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Estimates_source", "type" : "esriFieldTypeString", "alias" : "HMA (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Concrete (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Aggregate (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Estimates_value", "type" : "esriFieldTypeDouble", "alias" : "Labor (Estimates)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Estimates_source", "type" : "esriFieldTypeString", "alias" : "Labor (Estimates) Source", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Factors_source", "type" : "esriFieldTypeString", "alias" : "HMA Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Factors_source", "type" : "esriFieldTypeString", "alias" : "Concrete Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Factors_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Prediction Factors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Factors_source", "type" : "esriFieldTypeString", "alias" : "Labor Factors (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Predictions_source", "type" : "esriFieldTypeString", "alias" : "HMA Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Concrete Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Prediction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Prediction (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Predictions_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Predictions", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Predictions_source", "type" : "esriFieldTypeString", "alias" : "Spend Predictions (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Spend Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Spend_Expand_source", "type" : "esriFieldTypeString", "alias" : "Spend Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "HMA Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HMA_Expand_source", "type" : "esriFieldTypeString", "alias" : "HMA Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Concrete Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Concrete_Expand_source", "type" : "esriFieldTypeString", "alias" : "Concrete Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Aggregate Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggregate_Expand_source", "type" : "esriFieldTypeString", "alias" : "Aggregate Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Expand_value", "type" : "esriFieldTypeDouble", "alias" : "Labor Expand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Labor_Expand_source", "type" : "esriFieldTypeString", "alias" : "Labor Expand (Source)", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "All Labor Factor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Factors_source", "type" : "esriFieldTypeString", "alias" : "All Labor Factor Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Factor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Factors_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Factor Sorce", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Electrician Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Factors_source", "type" : "esriFieldTypeString", "alias" : "Electrician Factors Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Factors_source", "type" : "esriFieldTypeString", "alias" : "Ironworker Factors Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Factors_source", "type" : "esriFieldTypeString", "alias" : "Laborer Factors Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "CementMason Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Factors_source", "type" : "esriFieldTypeString", "alias" : "CementMason Factors Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Factors_source", "type" : "esriFieldTypeString", "alias" : "Operator Factors Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Factors_sourc", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Factors Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Factors_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Factors ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Factors_source", "type" : "esriFieldTypeString", "alias" : "Teamster Factors Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "AllLabor Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_Rates_source", "type" : "esriFieldTypeString", "alias" : "AllLabor Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_Rates_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Electrician Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_Rates_source", "type" : "esriFieldTypeString", "alias" : "Electrician Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_Rates_source", "type" : "esriFieldTypeString", "alias" : "Ironworker Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_Rates_source", "type" : "esriFieldTypeString", "alias" : "Laborer Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "CementMason Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_Rates_source", "type" : "esriFieldTypeString", "alias" : "CementMason Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_Rates_source", "type" : "esriFieldTypeString", "alias" : "Operator Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_Rates_source", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Rates_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Rates ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_Rates_source", "type" : "esriFieldTypeString", "alias" : "Teamster Rates Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "AllLabor Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllLabor_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "AllLabor Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Carpenter Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Carpenter_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Carpenter Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_LabPredictions_valu", "type" : "esriFieldTypeDouble", "alias" : "Electrician Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Electrician_LabPredictions_sour", "type" : "esriFieldTypeString", "alias" : "Electrician Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Ironworker Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ironworker_LabPredictions_sourc", "type" : "esriFieldTypeString", "alias" : "Ironworker Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Laborer Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Laborer_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Laborer Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_LabPredictions_valu", "type" : "esriFieldTypeDouble", "alias" : "CementMason Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CementMason_LabPredictions_sour", "type" : "esriFieldTypeString", "alias" : "CementMason Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Operator Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operator_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Operator Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_LabPrediction", "type" : "esriFieldTypeDouble", "alias" : "ProjectManagement Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectManagement_LabPredicti_1", "type" : "esriFieldTypeString", "alias" : "ProjectManagement Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_LabPredictions_value", "type" : "esriFieldTypeDouble", "alias" : "Teamster Predictions ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Teamster_LabPredictions_source", "type" : "esriFieldTypeString", "alias" : "Teamster Predictions Source", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nmonths", "type" : "esriFieldTypeInteger", "alias" : "Project Duration (Months)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectViewURL", "type" : "esriFieldTypeString", "alias" : "Project View Link", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ContractID", "type" : "esriFieldTypeString", "alias" : "Contract ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "NEWID() WITH VALUES" } ], "indexes" : [ { "name" : "PK__MDOT_PRO__F4B70D857DF4BA93", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G4CanonicalContr", "fields" : "CanonicalContractID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "MdotJobsWithSources_v70r0", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "ProjectViewURL" : null, "ContractID" : null, "CanonicalContractID" : null, "CanonicalJobSource" : null, "JobNumbers_Attr_Value" : null, "JobNumbers_Attr_Source" : null, "Expand" : null, "PredictFlag" : null, "CalendarRows" : null, "RevisedGrouping_Attr_value" : null, "RevisedGrouping_Attr_source" : null, "Region_Attr_value" : null, "Region_Attr_source" : null, "TSC_Attr_value" : null, "TSC_Attr_source" : null, "MajorRoute_Attr_value" : null, "MajorRoute_Attr_source" : null, "LocationReport_Attr_value" : null, "LocationReport_Attr_source" : null, "WorkDescription_Attr_value" : null, "WorkDescription_Attr_source" : null, "ConstructionStart_Attr_value" : null, "ConstructionStart_Attr_source" : null, "ConstructionEnd_Attr_value" : null, "ConstructionEnd_Attr_source" : null, "PercentComplete_Attr_value" : null, "PercentComplete_Attr_source" : null, "DemandType_Attr_value" : null, "DemandType_Attr_source" : null, "PointProjects_Attr_value" : null, "PointProjects_Attr_source" : null, "LineProjects_Attr_value" : null, "LineProjects_Attr_source" : null, "TotalProjectLength_Attr_value" : null, "TotalProjectLength_Attr_source" : null, "OriginalSpend_Attr_value" : null, "OriginalSpend_Attr_source" : null, "TotalLaneMiles_Attr_value" : null, "TotalLaneMiles_Attr_source" : null, "StructureNumber_Attr_value" : null, "StructureNumber_Attr_source" : null, "BridgeId_Attr_value" : null, "BridgeId_Attr_source" : null, "NBI_Attr_value" : null, "NBI_Attr_source" : null, "FinanceSystem_Attr_value" : null, "FinanceSystem_Attr_source" : null, "StartYear_Attr_value" : null, "EndYear_Attr_value" : null, "nmonths_Attr_value" : null, "nyears_Attr_value" : null, "IsBridgeProject_Attr_value" : null, "RollForwardProject_Attr_value" : null, "Spend_Actuals_value" : null, "Spend_Actuals_source" : null, "HMA_Actuals_value" : null, "HMA_Actuals_source" : null, "Concrete_Actuals_value" : null, "Concrete_Actuals_source" : null, "Aggregate_Actuals_value" : null, "Aggregate_Actuals_source" : null, "Labor_Actuals_value" : null, "Labor_Actuals_source" : null, "Spend_Estimates_value" : null, "Spend_Estimates_source" : null, "HMA_Estimates_value" : null, "HMA_Estimates_source" : null, "Concrete_Estimates_value" : null, "Concrete_Estimates_source" : null, "Aggregate_Estimates_value" : null, "Aggregate_Estimates_source" : null, "Labor_Estimates_value" : null, "Labor_Estimates_source" : null, "HMA_Factors_value" : null, "HMA_Factors_source" : null, "Concrete_Factors_value" : null, "Concrete_Factors_source" : null, "Aggregate_Factors_value" : null, "Aggregate_Factors_source" : null, "Labor_Factors_value" : null, "Labor_Factors_source" : null, "HMA_Predictions_value" : null, "HMA_Predictions_source" : null, "Concrete_Predictions_value" : null, "Concrete_Predictions_source" : null, "Aggregate_Predictions_value" : null, "Aggregate_Predictions_source" : null, "Labor_Predictions_value" : null, "Labor_Predictions_source" : null, "Spend_Expand_value" : null, "Spend_Expand_source" : null, "HMA_Expand_value" : null, "HMA_Expand_source" : null, "Concrete_Expand_value" : null, "Concrete_Expand_source" : null, "Aggregate_Expand_value" : null, "Aggregate_Expand_source" : null, "Labor_Expand_value" : null, "Labor_Expand_source" : null, "AllLabor_Factors_value" : null, "AllLabor_Factors_source" : null, "Carpenter_Factors_value" : null, "Carpenter_Factors_source" : null, "Electrician_Factors_value" : null, "Electrician_Factors_source" : null, "Ironworker_Factors_value" : null, "Ironworker_Factors_source" : null, "Laborer_Factors_value" : null, "Laborer_Factors_source" : null, "CementMason_Factors_value" : null, "CementMason_Factors_source" : null, "Operator_Factors_value" : null, "Operator_Factors_source" : null, "ProjectManagement_Factors_value" : null, "ProjectManagement_Factors_sourc" : null, "Teamster_Factors_value" : null, "Teamster_Factors_source" : null, "AllLabor_Rates_value" : null, "AllLabor_Rates_source" : null, "Carpenter_Rates_value" : null, "Carpenter_Rates_source" : null, "Electrician_Rates_value" : null, "Electrician_Rates_source" : null, "Ironworker_Rates_value" : null, "Ironworker_Rates_source" : null, "Laborer_Rates_value" : null, "Laborer_Rates_source" : null, "CementMason_Rates_value" : null, "CementMason_Rates_source" : null, "Operator_Rates_value" : null, "Operator_Rates_source" : null, "ProjectManagement_Rates_value" : null, "ProjectManagement_Rates_source" : null, "Teamster_Rates_value" : null, "Teamster_Rates_source" : null, "AllLabor_LabPredictions_value" : null, "AllLabor_LabPredictions_source" : null, "Carpenter_LabPredictions_value" : null, "Carpenter_LabPredictions_source" : null, "Electrician_LabPredictions_valu" : null, "Electrician_LabPredictions_sour" : null, "Ironworker_LabPredictions_value" : null, "Ironworker_LabPredictions_sourc" : null, "Laborer_LabPredictions_value" : null, "Laborer_LabPredictions_source" : null, "CementMason_LabPredictions_valu" : null, "CementMason_LabPredictions_sour" : null, "Operator_LabPredictions_value" : null, "Operator_LabPredictions_source" : null, "ProjectManagement_LabPrediction" : null, "ProjectManagement_LabPredicti_1" : null, "Teamster_LabPredictions_value" : null, "Teamster_LabPredictions_source" : null, "nmonths" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 10000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract,Sync", "layerOverrides" : [ "allowGeometryUpdates", "capabilities" ] } ] }