{ "currentVersion" : 12, "id" : 8, "name" : "DistrictCostData_2018", "type" : "Table", "serviceItemId" : "7fbd6d19f0ea4adab53aa73c0c25e153", "cacheMaxAge" : 30, "displayField" : "state_name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1690489973894, "schemaLastEditDate" : 1690489973894, "dataLastEditDate" : 1690489973894 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "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" : false, "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" : "", "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" : "year", "type" : "esriFieldTypeInteger", "alias" : "year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "leaid", "type" : "esriFieldTypeInteger", "alias" : "leaid", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "district", "type" : "esriFieldTypeString", "alias" : "district", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "state_name", "type" : "esriFieldTypeString", "alias" : "state_name", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "stabbr", "type" : "esriFieldTypeString", "alias" : "stabbr", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ppcstot", "type" : "esriFieldTypeInteger", "alias" : "ppcstot", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "predcost", "type" : "esriFieldTypeDouble", "alias" : "predcost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "fundinggap", "type" : "esriFieldTypeDouble", "alias" : "fundinggap", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "outcomegap", "type" : "esriFieldTypeString", "alias" : "outcomegap", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "enroll", "type" : "esriFieldTypeInteger", "alias" : "enroll", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pov", "type" : "esriFieldTypeDouble", "alias" : "pov", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "iep", "type" : "esriFieldTypeDouble", "alias" : "iep", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ell", "type" : "esriFieldTypeDouble", "alias" : "ell", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "amind", "type" : "esriFieldTypeDouble", "alias" : "amind", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "asian", "type" : "esriFieldTypeDouble", "alias" : "asian", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "black", "type" : "esriFieldTypeDouble", "alias" : "black", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hisp", "type" : "esriFieldTypeDouble", "alias" : "hisp", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "multi", "type" : "esriFieldTypeDouble", "alias" : "multi", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pac", "type" : "esriFieldTypeDouble", "alias" : "pac", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "white", "type" : "esriFieldTypeDouble", "alias" : "white", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field21", "type" : "esriFieldTypeString", "alias" : "Field21", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field22", "type" : "esriFieldTypeString", "alias" : "Field22", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field23", "type" : "esriFieldTypeString", "alias" : "Field23", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field24", "type" : "esriFieldTypeString", "alias" : "Field24", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field25", "type" : "esriFieldTypeString", "alias" : "Field25", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field26", "type" : "esriFieldTypeString", "alias" : "Field26", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field27", "type" : "esriFieldTypeString", "alias" : "Field27", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field28", "type" : "esriFieldTypeString", "alias" : "Field28", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field29", "type" : "esriFieldTypeString", "alias" : "Field29", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field30", "type" : "esriFieldTypeString", "alias" : "Field30", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field31", "type" : "esriFieldTypeString", "alias" : "Field31", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field32", "type" : "esriFieldTypeString", "alias" : "Field32", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field33", "type" : "esriFieldTypeString", "alias" : "Field33", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field34", "type" : "esriFieldTypeString", "alias" : "Field34", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field35", "type" : "esriFieldTypeString", "alias" : "Field35", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field36", "type" : "esriFieldTypeString", "alias" : "Field36", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field37", "type" : "esriFieldTypeString", "alias" : "Field37", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field38", "type" : "esriFieldTypeString", "alias" : "Field38", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field39", "type" : "esriFieldTypeString", "alias" : "Field39", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field40", "type" : "esriFieldTypeString", "alias" : "Field40", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field41", "type" : "esriFieldTypeString", "alias" : "Field41", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field42", "type" : "esriFieldTypeString", "alias" : "Field42", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field43", "type" : "esriFieldTypeString", "alias" : "Field43", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field44", "type" : "esriFieldTypeString", "alias" : "Field44", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field45", "type" : "esriFieldTypeString", "alias" : "Field45", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field46", "type" : "esriFieldTypeString", "alias" : "Field46", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field47", "type" : "esriFieldTypeString", "alias" : "Field47", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field48", "type" : "esriFieldTypeString", "alias" : "Field48", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field49", "type" : "esriFieldTypeString", "alias" : "Field49", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field50", "type" : "esriFieldTypeString", "alias" : "Field50", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field51", "type" : "esriFieldTypeString", "alias" : "Field51", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field52", "type" : "esriFieldTypeString", "alias" : "Field52", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field53", "type" : "esriFieldTypeString", "alias" : "Field53", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field54", "type" : "esriFieldTypeString", "alias" : "Field54", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field55", "type" : "esriFieldTypeString", "alias" : "Field55", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field56", "type" : "esriFieldTypeString", "alias" : "Field56", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field57", "type" : "esriFieldTypeString", "alias" : "Field57", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field58", "type" : "esriFieldTypeString", "alias" : "Field58", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field59", "type" : "esriFieldTypeString", "alias" : "Field59", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field60", "type" : "esriFieldTypeString", "alias" : "Field60", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field61", "type" : "esriFieldTypeString", "alias" : "Field61", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field62", "type" : "esriFieldTypeString", "alias" : "Field62", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field63", "type" : "esriFieldTypeString", "alias" : "Field63", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field64", "type" : "esriFieldTypeString", "alias" : "Field64", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field65", "type" : "esriFieldTypeString", "alias" : "Field65", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__FINALASS__F4B70D855FEC8EDE", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "DistrictCostData_2018", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Field64" : null, "Field65" : null, "year" : null, "leaid" : null, "district" : null, "state_name" : null, "stabbr" : null, "ppcstot" : null, "predcost" : null, "fundinggap" : null, "outcomegap" : null, "enroll" : null, "pov" : null, "iep" : null, "ell" : null, "amind" : null, "asian" : null, "black" : null, "hisp" : null, "multi" : null, "pac" : null, "white" : null, "Field21" : null, "Field22" : null, "Field23" : null, "Field24" : null, "Field25" : null, "Field26" : null, "Field27" : null, "Field28" : null, "Field29" : null, "Field30" : null, "Field31" : null, "Field32" : null, "Field33" : null, "Field34" : null, "Field35" : null, "Field36" : null, "Field37" : null, "Field38" : null, "Field39" : null, "Field40" : null, "Field41" : null, "Field42" : null, "Field43" : null, "Field44" : null, "Field45" : null, "Field46" : null, "Field47" : null, "Field48" : null, "Field49" : null, "Field50" : null, "Field51" : null, "Field52" : null, "Field53" : null, "Field54" : null, "Field55" : null, "Field56" : null, "Field57" : null, "Field58" : null, "Field59" : null, "Field60" : null, "Field61" : null, "Field62" : null, "Field63" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }