{ "layers" : [], "tables" : [ { "currentVersion" : 12, "id" : 0, "name" : "Project Scoping", "type" : "Table", "serviceItemId" : "6a326a5ddba4490e84ba25fdf53a142f", "displayField" : "USERNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1687731041859, "schemaLastEditDate" : 1687731041859, "dataLastEditDate" : 1687731039578 }, "relationships" : [], "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", "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" : "OBJECTIVES", "type" : "esriFieldTypeString", "alias" : "Objectives", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "Location / Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LEVELSTUDYREQUIRED", "type" : "esriFieldTypeSmallInteger", "alias" : "Level of Study Required", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "LevelStudyRequired", "codedValues" : [ { "name" : "Through Design", "code" : 1 }, { "name" : "To Letting", "code" : 2 }, { "name" : "Through Planning (to concept)", "code" : 0 } ] }, "defaultValue" : null }, { "name" : "DESIREDFISCALYEAR", "type" : "esriFieldTypeSmallInteger", "alias" : "Desired Fiscal Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TRAFFICCRITICAL", "type" : "esriFieldTypeSmallInteger", "alias" : "Traffic Critical?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "LEVIESAFFECTED", "type" : "esriFieldTypeSmallInteger", "alias" : "Levies Affected?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "INTERCHANGEREQUIRED", "type" : "esriFieldTypeSmallInteger", "alias" : "Operation Report (IJR/IOR) Required?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "OUTSIDESERVICES", "type" : "esriFieldTypeSmallInteger", "alias" : "Outside Services Expected?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "ROWNEED", "type" : "esriFieldTypeSmallInteger", "alias" : "Anticipated Range of ROW Required", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ROWneed_1", "codedValues" : [ { "name" : "0 Acres", "code" : 0 }, { "name" : "0.1-1 Acres", "code" : 1 }, { "name" : "1-5 Acres", "code" : 2 }, { "name" : "5-10 Acres", "code" : 3 }, { "name" : "10+ Acres", "code" : 4 } ] }, "defaultValue" : null }, { "name" : "ACQUISITIONANTICIPATED", "type" : "esriFieldTypeSmallInteger", "alias" : "Acquisition Anticipated?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "ROWRELOCATION", "type" : "esriFieldTypeSmallInteger", "alias" : "Residential/Commercial Relocation Needed?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "TITLEANTICIPATED", "type" : "esriFieldTypeSmallInteger", "alias" : "Title Anticipated?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ROWtitle", "codedValues" : [ { "name" : "New", "code" : 0 }, { "name" : "Modify Existing", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "EASEMENTANTICIPATED", "type" : "esriFieldTypeSmallInteger", "alias" : "Easement Anticipated?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "ROWDISPOSAL", "type" : "esriFieldTypeSmallInteger", "alias" : "ROW Disposals?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "TANDE", "type" : "esriFieldTypeSmallInteger", "alias" : "Potential Threatened & Endangered Species?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "CULTURALSITE", "type" : "esriFieldTypeSmallInteger", "alias" : "Known Archaeological Site?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "HISTORICALSITE", "type" : "esriFieldTypeSmallInteger", "alias" : "Known Historical Site?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "FLOODPLAIN", "type" : "esriFieldTypeSmallInteger", "alias" : "Floodplain?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "CONCURRENCEPOINT", "type" : "esriFieldTypeSmallInteger", "alias" : "Concurrence Point Process?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo2", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "LEVELOFDOCUMENTATION", "type" : "esriFieldTypeSmallInteger", "alias" : "Environmental Classification", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnvironmentalClassification", "codedValues" : [ { "name" : "Environmental Impact Statement", "code" : 1 }, { "name" : "Environmental Assessment", "code" : 2 }, { "name" : "Categorical Exclusion", "code" : 3 }, { "name" : "Programmatic Categorical Exclusion", "code" : 4 }, { "name" : "Unknown", "code" : 5 } ] }, "defaultValue" : null }, { "name" : "BUDGETRANGEMIN", "type" : "esriFieldTypeDouble", "alias" : "Budget Range Min (1,000’s)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "BUDGETRANGEMAX", "type" : "esriFieldTypeDouble", "alias" : "Budget Range Max (1,000’s)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATED_USER", "type" : "esriFieldTypeString", "alias" : "CREATED_USER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATED_DATE", "type" : "esriFieldTypeDate", "alias" : "created_date (UTC)", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LAST_EDITED_USER", "type" : "esriFieldTypeString", "alias" : "LAST_EDITED_USER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LAST_EDITED_DATE", "type" : "esriFieldTypeDate", "alias" : "last_edited_date (UTC)", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "USERNAME", "type" : "esriFieldTypeString", "alias" : "DOT Username", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PIN_ID", "type" : "esriFieldTypeDouble", "alias" : "PIN ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PIN", "type" : "esriFieldTypeString", "alias" : "PIN", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECT_TYPE", "type" : "esriFieldTypeString", "alias" : "Project Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MITIGATION", "type" : "esriFieldTypeString", "alias" : "Mitigation", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PERMIT_404_REQUIRED", "type" : "esriFieldTypeString", "alias" : "Permit 404 Required?", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIRST_LETTING", "type" : "esriFieldTypeDate", "alias" : "First Letting Date (UTC)", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PROG_EST_SUM", "type" : "esriFieldTypeDouble", "alias" : "Prog Est Sum", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEV_EST_SUM", "type" : "esriFieldTypeDouble", "alias" : "Dev Est Sum", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FUNDS", "type" : "esriFieldTypeString", "alias" : "Funds", "sqlType" : "sqlTypeOther", "length" : 32, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY_NAME", "type" : "esriFieldTypeString", "alias" : "County Name", "sqlType" : "sqlTypeOther", "length" : 67, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ALL_ROUTES", "type" : "esriFieldTypeString", "alias" : "All Routes", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WKGROUP", "type" : "esriFieldTypeString", "alias" : "Work Type", "sqlType" : "sqlTypeOther", "length" : 400, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROUTE_1", "type" : "esriFieldTypeString", "alias" : "Route 1", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROUTE_2", "type" : "esriFieldTypeString", "alias" : "Route 2", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROUTE_3", "type" : "esriFieldTypeString", "alias" : "Route 3", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROUTE_4", "type" : "esriFieldTypeString", "alias" : "Route 4", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HIGHWAY_CLASS", "type" : "esriFieldTypeString", "alias" : "Highway Class", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RECORD_LAST_UPDATED", "type" : "esriFieldTypeDate", "alias" : "Record Last Updated (UTC)", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "COUNTY_1", "type" : "esriFieldTypeString", "alias" : "County 1", "sqlType" : "sqlTypeOther", "length" : 67, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY_2", "type" : "esriFieldTypeString", "alias" : "County 2", "sqlType" : "sqlTypeOther", "length" : 67, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY_3", "type" : "esriFieldTypeString", "alias" : "County 3", "sqlType" : "sqlTypeOther", "length" : 67, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY_4", "type" : "esriFieldTypeString", "alias" : "County 4", "sqlType" : "sqlTypeOther", "length" : 67, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATION_DATE", "type" : "esriFieldTypeDate", "alias" : "Record Creation Date (UTC)", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ACCESS_CONTROL", "type" : "esriFieldTypeString", "alias" : "Access Control", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BEGIN_MILEPOST", "type" : "esriFieldTypeString", "alias" : "Begin Milepost", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CORRIDOR", "type" : "esriFieldTypeString", "alias" : "Corridor", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DISTRICT", "type" : "esriFieldTypeSmallInteger", "alias" : "District", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "END_MILEPOST", "type" : "esriFieldTypeString", "alias" : "End Milepost", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LIGHTING", "type" : "esriFieldTypeString", "alias" : "Lighting", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MATERIALS_ENGINEER", "type" : "esriFieldTypeString", "alias" : "Material Engineer", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MILES", "type" : "esriFieldTypeDouble", "alias" : "Miles", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECT_MANAGER", "type" : "esriFieldTypeString", "alias" : "Project Manager", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RAILROAD_INVOLVED", "type" : "esriFieldTypeString", "alias" : "Railroad Involved", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SEGMENT_MANAGER", "type" : "esriFieldTypeString", "alias" : "Segment Manager", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TRAFFIC_SIGNALS", "type" : "esriFieldTypeString", "alias" : "Traffic Signals", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TRAFFIC_SIGNS", "type" : "esriFieldTypeString", "alias" : "Traffic Signs", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UTILITIES", "type" : "esriFieldTypeString", "alias" : "Utilities", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UTILITIES_IMPACTED", "type" : "esriFieldTypeString", "alias" : "Utilities Impacted", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UTILITY_STATUS", "type" : "esriFieldTypeString", "alias" : "Utility Status", "sqlType" : "sqlTypeOther", "length" : 35, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REST_UPDATED", "type" : "esriFieldTypeDate", "alias" : "REST Service Last Updated (UTC)", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PARK_INSTITUTION", "type" : "esriFieldTypeString", "alias" : "Park Institution", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UTC_OFFSET", "type" : "esriFieldTypeString", "alias" : "UTC Offset", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRIMARY_ROUTE", "type" : "esriFieldTypeString", "alias" : "Primary Route", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DISTRICT_PRIORITY", "type" : "esriFieldTypeDouble", "alias" : "District Priority", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DistrictPriority", "codedValues" : [ { "name" : "N/A", "code" : 0 }, { "name" : "1", "code" : 1 }, { "name" : "2", "code" : 2 }, { "name" : "3", "code" : 3 }, { "name" : "4", "code" : 4 }, { "name" : "5", "code" : 5 } ] }, "defaultValue" : null }, { "name" : "HOLD_FISCAL_YEAR", "type" : "esriFieldTypeSmallInteger", "alias" : "Hold Fiscal Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "HoldDate", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "PD_COMPLETED_BY", "type" : "esriFieldTypeSmallInteger", "alias" : "Project Development Completed by", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PDCompletedBy", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "District", "code" : 1 }, { "name" : "Office of Design", "code" : 2 }, { "name" : "Office of Bridges & Structures", "code" : 3 }, { "name" : "Office of Traffic & Safety", "code" : 4 }, { "name" : "Office of Right of Way", "code" : 5 }, { "name" : "Office of Location & Environment", "code" : 6 }, { "name" : "Local Public Agency", "code" : 7 }, { "name" : "Other", "code" : 8 } ] }, "defaultValue" : null }, { "name" : "PD_COMPLETED_BY_OTHER", "type" : "esriFieldTypeString", "alias" : "Project Development Completed by Other", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESIRED_FISCAL_MONTH", "type" : "esriFieldTypeSmallInteger", "alias" : "Desired Month", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "FiscalMonth", "codedValues" : [ { "name" : "No Preference", "code" : 0 }, { "name" : "May", "code" : 5 }, { "name" : "Jan", "code" : 1 }, { "name" : "Feb", "code" : 2 }, { "name" : "Mar", "code" : 3 }, { "name" : "Apr", "code" : 4 }, { "name" : "Jun", "code" : 6 }, { "name" : "Jul", "code" : 7 }, { "name" : "Aug", "code" : 8 }, { "name" : "Sept", "code" : 9 }, { "name" : "Oct", "code" : 10 }, { "name" : "Nov", "code" : 11 }, { "name" : "Dec", "code" : 12 } ] }, "defaultValue" : 0 }, { "name" : "READABLE_PRIMARY_ROUTE", "type" : "esriFieldTypeString", "alias" : "Scoping Primary Route", "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__Project___F4B70D85C4A249DF", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "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" : "Project Scoping", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "DESIRED_FISCAL_MONTH" : 0, "READABLE_PRIMARY_ROUTE" : null, "OBJECTIVES" : null, "DESCRIPTION" : null, "LEVELSTUDYREQUIRED" : null, "DESIREDFISCALYEAR" : null, "TRAFFICCRITICAL" : null, "LEVIESAFFECTED" : null, "INTERCHANGEREQUIRED" : null, "OUTSIDESERVICES" : null, "ROWNEED" : null, "ACQUISITIONANTICIPATED" : null, "ROWRELOCATION" : null, "TITLEANTICIPATED" : null, "EASEMENTANTICIPATED" : null, "ROWDISPOSAL" : null, "TANDE" : null, "CULTURALSITE" : null, "HISTORICALSITE" : null, "FLOODPLAIN" : null, "CONCURRENCEPOINT" : null, "LEVELOFDOCUMENTATION" : null, "BUDGETRANGEMIN" : 0, "BUDGETRANGEMAX" : null, "CREATED_USER" : null, "CREATED_DATE" : null, "LAST_EDITED_USER" : null, "LAST_EDITED_DATE" : null, "USERNAME" : null, "PIN_ID" : null, "PIN" : null, "STATUS" : null, "PROJECT_TYPE" : null, "MITIGATION" : null, "PERMIT_404_REQUIRED" : null, "FIRST_LETTING" : null, "PROG_EST_SUM" : null, "DEV_EST_SUM" : null, "FUNDS" : null, "COUNTY_NAME" : null, "ALL_ROUTES" : null, "WKGROUP" : null, "ROUTE_1" : null, "ROUTE_2" : null, "ROUTE_3" : null, "ROUTE_4" : null, "HIGHWAY_CLASS" : null, "RECORD_LAST_UPDATED" : null, "COUNTY_1" : null, "COUNTY_2" : null, "COUNTY_3" : null, "COUNTY_4" : null, "CREATION_DATE" : null, "ACCESS_CONTROL" : null, "BEGIN_MILEPOST" : null, "CORRIDOR" : null, "DISTRICT" : null, "END_MILEPOST" : null, "LIGHTING" : null, "MATERIALS_ENGINEER" : null, "MILES" : null, "PROJECT_MANAGER" : null, "RAILROAD_INVOLVED" : null, "SEGMENT_MANAGER" : null, "TRAFFIC_SIGNALS" : null, "TRAFFIC_SIGNS" : null, "UTILITIES" : null, "UTILITIES_IMPACTED" : null, "UTILITY_STATUS" : null, "REST_UPDATED" : null, "PARK_INSTITUTION" : null, "UTC_OFFSET" : null, "PRIMARY_ROUTE" : null, "DISTRICT_PRIORITY" : null, "HOLD_FISCAL_YEAR" : 0, "PD_COMPLETED_BY" : null, "PD_COMPLETED_BY_OTHER" : 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" : "Create,Delete,Query,Update,Editing" } ] }