Name: PlantDatesKnown
Display Field: StreetName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: Trees and tree planting sites owned, planted or maintained by the City of Cambridge, the Massachusetts Department of Conservation and Recreation, and MIT, Harvard University and other private organizations. This layer is maintained by Cambridge Public Works
Copyright Text: City of Cambridge
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 748154.35827975
YMin: 2954415.47298817
XMax: 772626.015701175
YMax: 2971774.34771918
Spatial Reference: 102686 (2249)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[77,55,142,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID_2
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- trunks (type: esriFieldTypeInteger, alias: # of trunks, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SiteType (type: esriFieldTypeString, alias: Site Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Tree: Tree], [Retired: Retired], [Planting Site: Planting Site], ... 5 more ...)
- PlantDate (type: esriFieldTypeDate, alias: Plant Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- RemovalDat (type: esriFieldTypeDate, alias: Removal Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SpeciesSho (type: esriFieldTypeString, alias: Species Abbr, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Oak: Oak], [Elm: Elm], [Maple: Maple], ... 54 more ...)
- OverheadWi (type: esriFieldTypeInteger, alias: Overhead Wires, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Cultivar (type: esriFieldTypeString, alias: Cultivar, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- StreetNumb (type: esriFieldTypeInteger, alias: Street Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- StreetName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- MemTree (type: esriFieldTypeString, alias: Memoriam Tree, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ADAComplia (type: esriFieldTypeString, alias: ADA Compliant, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- TreeGrateA (type: esriFieldTypeInteger, alias: Tree Grate Action Req., SQL Type: sqlTypeOther, nullable: true, editable: true)
- BareRoot (type: esriFieldTypeString, alias: Bare Root, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- diameter (type: esriFieldTypeSingle, alias: diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TreeWellCo (type: esriFieldTypeString, alias: Tree Well Cover, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- Structural (type: esriFieldTypeString, alias: Structural Soil, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- AbutsOpenA (type: esriFieldTypeString, alias: Abuts Open Area, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- ExposedRoo (type: esriFieldTypeString, alias: Exposed Root Flare, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- TreeID (type: esriFieldTypeString, alias: Tree ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- TreeWellID (type: esriFieldTypeInteger, alias: Tree Well ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- created_us (type: esriFieldTypeString, alias: Data Created By, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- created_da (type: esriFieldTypeDate, alias: Data Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- last_edite (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- last_edi_1 (type: esriFieldTypeDate, alias: Last Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CommonName (type: esriFieldTypeString, alias: Common Name, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- Genus (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- Scientific (type: esriFieldTypeString, alias: Scientific Name, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- creator (type: esriFieldTypeString, alias: creator, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- inspectr (type: esriFieldTypeString, alias: Tree Inspector, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- species (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Order_ (type: esriFieldTypeString, alias: Order_, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- PlantingCo (type: esriFieldTypeString, alias: Planting Contract, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- WateringRe (type: esriFieldTypeString, alias: Watering Responsibility, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- LocationRe (type: esriFieldTypeString, alias: Location Retired, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- SiteReplan (type: esriFieldTypeString, alias: Site Replanted, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- SiteRetire (type: esriFieldTypeString, alias: Site Retired Reason, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- Biochar_Ad (type: esriFieldTypeString, alias: Biochar Added, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- SolarRatin (type: esriFieldTypeInteger, alias: Solar Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TreeWellLe (type: esriFieldTypeDouble, alias: Tree Well Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TreeWellWi (type: esriFieldTypeDouble, alias: Tree Well Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TreeWellDe (type: esriFieldTypeDouble, alias: Tree Well Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ScheduledR (type: esriFieldTypeInteger, alias: Scheduled Removal, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RemovalRea (type: esriFieldTypeString, alias: Removal Reason, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- PB (type: esriFieldTypeString, alias: PB, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- PlantingSe (type: esriFieldTypeString, alias: Planting Season, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- StTreePrun (type: esriFieldTypeString, alias: Street Tree Pruning Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- OffStTreeP (type: esriFieldTypeString, alias: Off-Street Tree Pruning Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PendingSit (type: esriFieldTypeString, alias: PendingSit, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- TreeWellSt (type: esriFieldTypeString, alias: TreeWellSt, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- TreeWellEx (type: esriFieldTypeString, alias: TreeWellEx, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- NurserySto (type: esriFieldTypeString, alias: NurserySto, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Templates:
Name: PlantDatesKnown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 6/12/2025 7:51:09 AM
Schema Last Edit Date: 7/16/2024 4:15:31 PM
Data Last Edit Date: 6/12/2025 7:51:09 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat