{ "currentVersion" : 12, "id" : 0, "name" : "JoinTreesToMaintenance1MKeepRecent-Prune", "type" : "Feature Layer", "serviceItemId" : "46da1b6d3de24dc7bf302ab108621a61", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1719516902323, "schemaLastEditDate" : 1698938707214, "dataLastEditDate" : 1719516902323 }, "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, "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" : 144448, "maxScale" : 0, "extent" : { "xmin" : 2485322.0303679705, "ymin" : 363555.72067430615, "xmax" : 2509406.1255723834, "ymax" : 381703.69487698376, "spatialReference" : { "wkid" : 2930, "latestWkid" : 2930 } }, "spatialReference" : { "wkid" : 2930, "latestWkid" : 2930 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[79,129,189,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[54,93,141,255],"width":1}}}}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "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", "actualType" : "int", "alias" : "OBJECTID", "sqlType" : "sqlTypeInteger", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "NewAssetID", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "AssetWorks_ID", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AW_OLD", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "AW_OLD", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Asset_Category", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Asset Category", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Status", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Status", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Known_As", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Known As", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Common_Name", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Common Name", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Botanical_Name", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Botanical Name", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Side", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Side", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Site", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Site", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Condition", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Condition", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DBH", "type" : "esriFieldTypeDouble", "actualType" : "decimal", "alias" : "DBH", "sqlType" : "sqlTypeDecimal", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WU", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "WU", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Address", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "On_Street", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "On Street?", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Marked_for_Planting", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Marked for Planting", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Season", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Season", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HL_Ticket", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "HL Ticket", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HL_Status", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "HL Status", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HL_Cleared_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "HL Cleared Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Plant_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Plant Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Staked", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Staked", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Re_Staked", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Re Staked Date?", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Water_Bag", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Water Bag", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Fund_Code", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Fund Code", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Fund__", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Fund #", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cycle", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Cycle", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Location_Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Location Comments", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Comments", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Grow_Size_Inches", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Grow Size Inches", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GST_Desc", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "GST Desc", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wires_OH", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Wires OH", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wires_Adj", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Wires Adj", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Preferred_Species", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Preferred Species", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tree_Format", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Tree Format", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vendor", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Vendor", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Value", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Value", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Latitute", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Longitude", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Northing", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Northing", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Easting", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Easting", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGUID", "actualType" : "uniqueidentifier", "alias" : "GlobalID", "sqlType" : "sqlTypeGUID", "length" : 38, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "CreationDate", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Creator", "sqlType" : "sqlTypeNVarchar", "length" : 128, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "EditDate", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Editor", "sqlType" : "sqlTypeNVarchar", "length" : 128, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AW_OLD_1", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "AW_OLD 1", "sqlType" : "sqlTypeNVarchar", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Maintenance_Type", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Maintenance Type", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Performed", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Date Performed", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Requested", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Date Requested", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Reason_for_Prune", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Reason for Prune", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_Pruning", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Type of Pruning", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pruning_Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Pruning Comments", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Marked_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Marked for Removal Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Reason", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Reason", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Removed", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Removed", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pulled", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Pulled", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Topped", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Topped", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Removal_Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Removal Comments", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Stumped_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Stumped Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Pickup_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Pickup Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Vac_All_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Vac-All Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Backfill_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Backfill Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Seed_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Seed Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Stump_Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Stump Comments", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Chemical", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Chemical", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Amount", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Amount", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Equipment_Type", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Equipment Type", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F__of_injection_sites", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "# of injection sites", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Port_Size", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Port Size", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Chemical_Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Chemical Comments", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Crack_Length", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Crack Length", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Crack_Depth_1", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Crack Depth 1", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Crack_Depth_2", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Crack Depth 2", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Crack_Depth_3", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Crack Depth 3", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "w__Decay", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "w/ Decay", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "w__Crotch", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "w/ Crotch", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Crack_Check_Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Crack Check Comments", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wound_Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Wound Comments", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Stakes", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Stakes", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Mulched", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Mulched", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Watered", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Watered", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pick_up_Type", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Pick up Type", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Area_Affected", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Area Affected", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pick_up_Comments", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Pick up Comments", "sqlType" : "sqlTypeNVarchar", "length" : 225, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Width_Inches", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Width (In.)", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Height_Inches", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "Height (In.)", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Training", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Training", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Picked_Up", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Picked Up?", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Marked_For_Plant", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Marked For Planting?", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tree_Planted", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Tree Planted?", "sqlType" : "sqlTypeNVarchar", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID_1", "type" : "esriFieldTypeGUID", "actualType" : "uniqueidentifier", "alias" : "GlobalID 1", "sqlType" : "sqlTypeGUID", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate_1", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "CreationDate 1", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator_1", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Creator 1", "sqlType" : "sqlTypeNVarchar", "length" : 128, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EditDate_1", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "EditDate 1", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor_1", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Editor 1", "sqlType" : "sqlTypeNVarchar", "length" : 128, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Topped_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Date Topped", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Pulled_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Date Pulled", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Removed_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Date Removed", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ResidentNotifiedDate", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "ResidentNotifiedDate", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "HoleDugDate", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "HoleDugDate", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CrewName", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "CrewName", "sqlType" : "sqlTypeNVarchar", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__J909DAE6__F4B70D852316EC72", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_27853.J909DAE6F844A408AB0E348E179CFAD1C__Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "NewAssetID" : null, "AW_OLD" : null, "Asset_Category" : null, "Status" : null, "Known_As" : null, "Common_Name" : null, "Botanical_Name" : null, "Side" : null, "Site" : null, "Condition" : null, "DBH" : null, "WU" : null, "Address" : null, "On_Street" : null, "Marked_for_Planting" : null, "Season" : null, "HL_Ticket" : null, "HL_Status" : null, "HL_Cleared_Date" : null, "Plant_Date" : null, "Staked" : null, "Re_Staked" : null, "Water_Bag" : null, "Fund_Code" : null, "Fund__" : null, "Cycle" : null, "Location_Comments" : null, "Comments" : null, "Grow_Size_Inches" : null, "GST_Desc" : null, "Wires_OH" : null, "Wires_Adj" : null, "Preferred_Species" : null, "Tree_Format" : null, "Vendor" : null, "Value" : null, "Latitude" : null, "Longitude" : null, "Northing" : null, "Easting" : null, "GlobalID" : "{{00000000-0000-0000-0000-000000000000}}", "CreationDate" : null, "Creator" : null, "EditDate" : null, "Editor" : null, "AW_OLD_1" : null, "Maintenance_Type" : null, "Date_Performed" : null, "Date_Requested" : null, "Reason_for_Prune" : null, "Type_of_Pruning" : null, "Pruning_Comments" : null, "Marked_Date" : null, "Reason" : null, "Removed" : null, "Pulled" : null, "Topped" : null, "Removal_Comments" : null, "Stumped_Date" : null, "Pickup_Date" : null, "Vac_All_Date" : null, "Backfill_Date" : null, "Seed_Date" : null, "Stump_Comments" : null, "Chemical" : null, "Amount" : null, "Equipment_Type" : null, "F__of_injection_sites" : null, "Port_Size" : null, "Chemical_Comments" : null, "Crack_Length" : null, "Crack_Depth_1" : null, "Crack_Depth_2" : null, "Crack_Depth_3" : null, "w__Decay" : null, "w__Crotch" : null, "Crack_Check_Comments" : null, "Wound_Comments" : null, "Stakes" : null, "Mulched" : null, "Watered" : null, "Pick_up_Type" : null, "Area_Affected" : null, "Pick_up_Comments" : null, "Width_Inches" : null, "Height_Inches" : null, "Training" : null, "Picked_Up" : null, "Marked_For_Plant" : null, "Tree_Planted" : null, "GlobalID_1" : null, "CreationDate_1" : null, "Creator_1" : null, "EditDate_1" : null, "Editor_1" : null, "Topped_Date" : null, "Pulled_Date" : null, "Removed_Date" : null, "ResidentNotifiedDate" : null, "HoleDugDate" : null, "CrewName" : 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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" }