{ "currentVersion" : 12, "id" : 0, "name" : "Street Trees For Collector", "type" : "Feature Layer", "serviceItemId" : "7137ef916e2c49d38b966273647caa9a", "cacheMaxAge" : 30, "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "CreationDate", "creatorField" : "Creator", "editDateField" : "EditDate", "editorField" : "Editor" }, "editingInfo" : { "lastEditDate" : 1786383265493, "schemaLastEditDate" : 1786383265493, "dataLastEditDate" : 1786383265493 }, "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, "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" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "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" ], "supportsQueryAttachmentsWithReturnUrl" : true, "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" : 507747.40227272187, "ymin" : 5452494.4016493391, "xmax" : 529062.46781529, "ymax" : 5461678.7668188941, "spatialReference" : { "wkid" : 26910, "latestWkid" : 26910 } }, "spatialReference" : { "wkid" : 26910, "latestWkid" : 26910 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[67,127,33,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : true, "viewSourceHasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "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" : "PRIMARYIND", "type" : "esriFieldTypeDouble", "alias" : "PRIMARYIND", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GISLINK", "type" : "esriFieldTypeDouble", "alias" : "GISLINK", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLASS", "type" : "esriFieldTypeString", "alias" : "CLASS", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSET_ID", "type" : "esriFieldTypeString", "alias" : "Asset ID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "Tree-" }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIVISION", "type" : "esriFieldTypeString", "alias" : "DIVISION", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "Parks" }, { "name" : "WORKGROUP", "type" : "esriFieldTypeString", "alias" : "WORKGROUP", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "Urban Forestry" }, { "name" : "TYPE", "type" : "esriFieldTypeString", "alias" : "TYPE", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Type", "codedValues" : [ { "name" : "Street Tree", "code" : "Street Tree" }, { "name" : "Park Tree", "code" : "Park Tree" }, { "name" : "Greenbelt Tree", "code" : "Greenbelt" }, { "name" : "Significant Tree", "code" : "Significant Tree" } ] }, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMMON_NAM", "type" : "esriFieldTypeString", "alias" : "COMMON_NAM", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SCIENTIFIC", "type" : "esriFieldTypeString", "alias" : "SCIENTIFIC", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DBH", "type" : "esriFieldTypeDouble", "alias" : "DBH", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ELEVATION", "type" : "esriFieldTypeDouble", "alias" : "ELEVATION", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NOTES", "type" : "esriFieldTypeString", "alias" : "NOTES", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGRESSO_ID", "type" : "esriFieldTypeString", "alias" : "AGRESSO_ID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PHYSICAL_C", "type" : "esriFieldTypeString", "alias" : "PHYSICAL_C", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "codedValues" : [ { "name" : "Good", "code" : "1" }, { "name" : "Moderate", "code" : "2" }, { "name" : "Poor", "code" : "3" }, { "name" : "Needs Replacement", "code" : "4" } ] }, "defaultValue" : null }, { "name" : "HISTORIC_COST", "type" : "esriFieldTypeDouble", "alias" : "HISTORIC_COST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LIFE_CYCLE", "type" : "esriFieldTypeInteger", "alias" : "LIFE_CYCLE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REPLACEMENTVALUE", "type" : "esriFieldTypeInteger", "alias" : "REPLACEMENTVALUE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PICTURE", "type" : "esriFieldTypeString", "alias" : "PICTURE", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F_matched_r", "type" : "esriFieldTypeString", "alias" : "F_matched_r", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESS", "type" : "esriFieldTypeString", "alias" : "ADDRESS", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COA", "type" : "esriFieldTypeString", "alias" : "COA", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "STATUS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Street Trees For Collector_STATUS_a9f87dce-879c-4f13-8e7a-6c20785df583", "codedValues" : [ { "name" : "REMOVED", "code" : "REMOVED" }, { "name" : "OPERATIONAL", "code" : "OPERATIONAL" } ] }, "defaultValue" : "OPERATIONAL" }, { "name" : "SUBTYPE", "type" : "esriFieldTypeString", "alias" : "SUBTYPE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Subtype", "codedValues" : [ { "name" : "Boulevard", "code" : "Boulevard" }, { "name" : "Median", "code" : "Median" }, { "name" : "Plaza", "code" : "Plaza" }, { "name" : "Park-Reg", "code" : "Park-Reg" }, { "name" : "Specimen", "code" : "Specimen" }, { "name" : "Heritage Tree", "code" : "Heritage Tree" } ] }, "defaultValue" : null }, { "name" : "GENUS", "type" : "esriFieldTypeString", "alias" : "GENUS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CULTIVAR", "type" : "esriFieldTypeString", "alias" : "CULTIVAR", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STRUCTURALDEFECTS", "type" : "esriFieldTypeString", "alias" : "STRUCTURALDEFECTS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HEIGHT", "type" : "esriFieldTypeInteger", "alias" : "HEIGHT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Street Trees For Collector_HEIGHT_72c4dd39-09b4-4a86-8b18-bc60564c7a29", "codedValues" : [ { "name" : "\u003c5m", "code" : 5 }, { "name" : "5-10m", "code" : 10 }, { "name" : "10-15m", "code" : 15 }, { "name" : "15-20m", "code" : 20 }, { "name" : "20-30m", "code" : 30 }, { "name" : "\u003e30m", "code" : 40 } ] }, "defaultValue" : null }, { "name" : "CANOPYSPREAD", "type" : "esriFieldTypeString", "alias" : "CANOPYSPREAD", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Street Trees For Collector_CANOPYSPREAD_ebd13bc9-3e68-4fd9-879d-4c849f225a6d", "codedValues" : [ { "name" : "\u003c5m", "code" : "5" }, { "name" : "5-10m", "code" : "10" }, { "name" : "10-15m", "code" : "15" }, { "name" : "15-20m", "code" : "20" }, { "name" : "20-30m", "code" : "30" }, { "name" : "\u003e30m", "code" : "40" } ] }, "defaultValue" : null }, { "name" : "ROOTS", "type" : "esriFieldTypeString", "alias" : "ROOTS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TREEARCHITECTURE", "type" : "esriFieldTypeString", "alias" : "TREEARCHITECTURE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PESTPROBLEMS", "type" : "esriFieldTypeString", "alias" : "PESTPROBLEMS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAINTENANCEREQ", "type" : "esriFieldTypeString", "alias" : "MAINTENANCEREQ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMPENSATIONTREE", "type" : "esriFieldTypeString", "alias" : "COMPENSATIONTREE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "ADDITIONALDOCUMENTATION", "type" : "esriFieldTypeString", "alias" : "ADDITIONALDOCUMENTATION", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUPPLIER", "type" : "esriFieldTypeString", "alias" : "SUPPLIER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGECATEGORY", "type" : "esriFieldTypeString", "alias" : "AGECATEGORY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AgeCategory", "codedValues" : [ { "name" : "Young", "code" : "Young" }, { "name" : "Semi-mature", "code" : "Semi-mature" }, { "name" : "Mature", "code" : "Mature" }, { "name" : "Senescent", "code" : "Senescent" } ] }, "defaultValue" : null }, { "name" : "AGE", "type" : "esriFieldTypeString", "alias" : "AGE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATEOFASBUILT", "type" : "esriFieldTypeDate", "alias" : "DATEOFASBUILT", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "INSTALL_DATE", "type" : "esriFieldTypeDate", "alias" : "INSTALL_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "WARRENTYCOMMENTS", "type" : "esriFieldTypeString", "alias" : "WARRENTYCOMMENTS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RECORDDRAWINGNUMBER", "type" : "esriFieldTypeString", "alias" : "RECORDDRAWINGNUMBER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REMAINING_LIFE", "type" : "esriFieldTypeString", "alias" : "REMAINING_LIFE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNER", "type" : "esriFieldTypeString", "alias" : "OWNER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "City of Port Moody" }, { "name" : "PROJECT", "type" : "esriFieldTypeString", "alias" : "PROJECT", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CRITICALITY", "type" : "esriFieldTypeString", "alias" : "CRITICALITY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PERFORMANCE", "type" : "esriFieldTypeString", "alias" : "PERFORMANCE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UNITRATE", "type" : "esriFieldTypeString", "alias" : "UNITRATE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PLANTINGSPACE", "type" : "esriFieldTypeString", "alias" : "PLANTINGSPACE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PlantingSpace", "codedValues" : [ { "name" : "Narrow", "code" : "Narrow" }, { "name" : "Wide", "code" : "Wide" }, { "name" : "Tree Pit", "code" : "Tree Pit" }, { "name" : "Sidewalk Cut Out", "code" : "Sidewalk Cut Out" } ] }, "defaultValue" : null }, { "name" : "PAVEMENTCONFLICTS", "type" : "esriFieldTypeString", "alias" : "PAVEMENTCONFLICTS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "SOILTYPE", "type" : "esriFieldTypeString", "alias" : "SOILTYPE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "SoilType", "codedValues" : [ { "name" : "Regular", "code" : "Regular" }, { "name" : "Structural", "code" : "Structural" }, { "name" : "Silva Cells", "code" : "Silva Cells" } ] }, "defaultValue" : null }, { "name" : "ADEQUATESOILVOLUME", "type" : "esriFieldTypeString", "alias" : "ADEQUATESOILVOLUME", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "SOILCOMPACTION", "type" : "esriFieldTypeString", "alias" : "SOILCOMPACTION", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "ROOTBARRIER", "type" : "esriFieldTypeString", "alias" : "ROOTBARRIER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "MULCH", "type" : "esriFieldTypeString", "alias" : "MULCH", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "TREEGATES", "type" : "esriFieldTypeString", "alias" : "TREEGATES", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "IRRIGATION", "type" : "esriFieldTypeString", "alias" : "IRRIGATION", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "PRUNINGHISTORY", "type" : "esriFieldTypeString", "alias" : "PRUNINGHISTORY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROOTPRUNING", "type" : "esriFieldTypeString", "alias" : "ROOTPRUNING", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STAKES", "type" : "esriFieldTypeString", "alias" : "STAKES", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "TREEGATEADJUSTMENT", "type" : "esriFieldTypeString", "alias" : "TREEGATEADJUSTMENT", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "PESTMANGMENTPROGRAM", "type" : "esriFieldTypeString", "alias" : "PESTMANGMENTPROGRAM", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrueFalse", "codedValues" : [ { "name" : "True", "code" : "True" }, { "name" : "False", "code" : "False" } ] }, "defaultValue" : null }, { "name" : "PRUNINGCYCLE", "type" : "esriFieldTypeString", "alias" : "PRUNINGCYCLE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PruningCycle", "codedValues" : [ { "name" : "5 Years", "code" : "5 Years" }, { "name" : "7 Years", "code" : "7 Years" }, { "name" : "10 Years", "code" : "10 Years" } ] }, "defaultValue" : null }, { "name" : "STATUSDATE", "type" : "esriFieldTypeDate", "alias" : "STATUSDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "STATUSDRAWINGNUMBER", "type" : "esriFieldTypeString", "alias" : "STATUS DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"STATUS DRAWING NUMBER or DESCRIPTION OF CHANGE\",\"fieldValueType\":\"\"}" }, { "name" : "TREETAGNUMBER", "type" : "esriFieldTypeString", "alias" : "TREETAGNUMBER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TREELOCATIONDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "Tree Location Description", "sqlType" : "sqlTypeOther", "length" : 255, "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" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "REMOVAL_DATE", "type" : "esriFieldTypeInteger", "alias" : "Removal Date", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REMOVAL_REASON", "type" : "esriFieldTypeString", "alias" : "Reason for Removal", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STUMP_REMOVED", "type" : "esriFieldTypeString", "alias" : "Stump Removed?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Street Trees For Collector_STUMP_REMOVED_2704bdac-1421-46f8-8a73-665270b10cfd", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__STREET_T__F4B70D854519D90A", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_4332.STREET_TREES_FOR_COLLECTOR_STREET_TREES_FOR_COLLECTOR_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "CreationDateIndex", "fields" : "CreationDate", "isAscending" : true, "isUnique" : false, "description" : "CreationDate Field index", "indexType" : "Attribute" }, { "name" : "CreatorIndex", "fields" : "Creator", "isAscending" : false, "isUnique" : false, "description" : "Creator Field index", "indexType" : "Attribute" }, { "name" : "EditDateIndex", "fields" : "EditDate", "isAscending" : true, "isUnique" : false, "description" : "EditDate Field index", "indexType" : "Attribute" }, { "name" : "EditorIndex", "fields" : "Editor", "isAscending" : false, "isUnique" : false, "description" : "Editor Field index", "indexType" : "Attribute" }, { "name" : "ASSET_ID_Index", "fields" : "ASSET_ID", "isAscending" : true, "isUnique" : false, "description" : "ASSET_ID_Index", "indexType" : "Attribute" }, { "name" : "TYPE_Index", "fields" : "TYPE", "isAscending" : true, "isUnique" : false, "description" : "TYPE_Index", "indexType" : "Attribute" }, { "name" : "WORKGROUP_Index", "fields" : "WORKGROUP", "isAscending" : true, "isUnique" : false, "description" : "WORKGROUP_Index", "indexType" : "Attribute" }, { "name" : "SUBTYPE_Index", "fields" : "SUBTYPE", "isAscending" : true, "isUnique" : false, "description" : "SUBTYPE_Index", "indexType" : "Attribute" }, { "name" : "COMMON_NAM_Index", "fields" : "COMMON_NAM", "isAscending" : true, "isUnique" : false, "description" : "COMMON_NAM_Index", "indexType" : "Attribute" }, { "name" : "SCIENTIFIC_Index", "fields" : "SCIENTIFIC", "isAscending" : true, "isUnique" : false, "description" : "SCIENTIFIC_Index", "indexType" : "Attribute" }, { "name" : "STATUS_Index", "fields" : "STATUS", "isAscending" : true, "isUnique" : false, "description" : "STATUS_Index", "indexType" : "Attribute" }, { "name" : "INSTALL_DATE_Index", "fields" : "INSTALL_DATE", "isAscending" : true, "isUnique" : false, "description" : "INSTALL_DATE_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Street Trees For Collector", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "TREETAGNUMBER" : null, "TREELOCATIONDESCRIPTION" : null, "PRIMARYIND" : null, "GISLINK" : null, "LOCATION" : null, "CLASS" : null, "ASSET_ID" : "Tree-", "NAME" : null, "DIVISION" : "Parks", "WORKGROUP" : "Urban Forestry", "TYPE" : null, "DESCRIPTION" : null, "COMMON_NAM" : null, "SCIENTIFIC" : null, "DBH" : null, "ELEVATION" : null, "NOTES" : null, "AGRESSO_ID" : null, "PHYSICAL_C" : null, "HISTORIC_COST" : null, "LIFE_CYCLE" : null, "REPLACEMENTVALUE" : null, "PICTURE" : null, "F_matched_r" : null, "ADDRESS" : null, "COA" : null, "STATUS" : "OPERATIONAL", "SUBTYPE" : null, "GENUS" : null, "CULTIVAR" : null, "STRUCTURALDEFECTS" : null, "HEIGHT" : null, "CANOPYSPREAD" : null, "ROOTS" : null, "TREEARCHITECTURE" : null, "PESTPROBLEMS" : null, "MAINTENANCEREQ" : null, "COMPENSATIONTREE" : null, "ADDITIONALDOCUMENTATION" : null, "SUPPLIER" : null, "AGECATEGORY" : null, "AGE" : null, "DATEOFASBUILT" : null, "INSTALL_DATE" : null, "WARRENTYCOMMENTS" : null, "RECORDDRAWINGNUMBER" : null, "REMAINING_LIFE" : null, "OWNER" : "City of Port Moody", "PROJECT" : null, "CRITICALITY" : null, "PERFORMANCE" : null, "UNITRATE" : null, "PLANTINGSPACE" : null, "PAVEMENTCONFLICTS" : null, "SOILTYPE" : null, "ADEQUATESOILVOLUME" : null, "SOILCOMPACTION" : null, "ROOTBARRIER" : null, "MULCH" : null, "TREEGATES" : null, "IRRIGATION" : null, "PRUNINGHISTORY" : null, "ROOTPRUNING" : null, "STAKES" : null, "TREEGATEADJUSTMENT" : null, "PESTMANGMENTPROGRAM" : null, "PRUNINGCYCLE" : null, "STATUSDATE" : null, "STATUSDRAWINGNUMBER" : null, "REMOVAL_DATE" : null, "REMOVAL_REASON" : null, "STUMP_REMOVED" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "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" : 400000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "viewDefinitionQuery" : "(SCIENTIFIC IN ('Fraxinus excelsior','Fraxinus americana','Fraxinus pennsylvanica','Fraxinus oxycarpa ''Raywood''','Fraxinus ornus','Fraxinus oxycarpa ')) AND (STATUS = 'OPERATIONAL')", "definitionQuery" : "(SCIENTIFIC IN ('Fraxinus excelsior','Fraxinus americana','Fraxinus pennsylvanica','Fraxinus oxycarpa ''Raywood''','Fraxinus ornus','Fraxinus oxycarpa ')) AND (STATUS = 'OPERATIONAL')" }