Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
147467 | 147467 | 82811 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2362 44th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50731 | 5982709.1994 | 2099047.2891 | 37.742582474230396 | -122.502443555218 | (37.7425824742304, -122.502443555218) | |
81719 | 81719 | 112974 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
90957 | 90957 | 112973 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
105015 | 105015 | 112975 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
127737 | 127737 | 112972 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | |
123125 | 123125 | 92233 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 606 40th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3x3 | Permit Number 52675 | 5983543.9 | 2111647.9 | 37.7772292115503 | -122.50048892058001 | (37.7772292115503, -122.50048892058) | ||
141647 | 141647 | 122627 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731.0 | 2094410.0 | 37.729968312905505 | -122.49511098534401 | (37.7299683129055, -122.495110985344) | |
71915 | 71915 | 96679 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375@32nd Ave 32nd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 5 | Permit Number 768040 | 5985878.99721 | 2113476.25396 | 37.7823861446856 | -122.49254586983999 | (37.7823861446856, -122.49254586984) | ||
187708 | 187708 | 96682 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375@32nd Ave 32nd Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 5 | Permit Number 768040 | 5985880.71623 | 2113435.4542400003 | 37.7822742209113 | -122.492536917229 | (37.7822742209113, -122.492536917229) | ||
73007 | 73007 | 96680 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375@32nd Ave 32nd Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 6 | Permit Number 768040 | 5985880.8401 | 2113452.3191 | 37.78232053420329 | -122.492537731103 | (37.7823205342033, -122.492537731103) | ||
62455 | 62455 | 96687 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375@32nd Ave 32nd Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 6 | Permit Number 768040 | 5985885.51193 | 2113329.22716 | 37.7819828323209 | -122.492512501026 | (37.7819828323209, -122.492512501026) | ||
80235 | 80235 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
99207 | 99207 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
124197 | 124197 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
92122 | 92122 | 115292 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2058 17th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 774300 | 5991031.5 | 2101384.0 | 37.7494839769409 | -122.47383819807501 | (37.7494839769409, -122.473838198075) | |||
107463 | 107463 | 122334 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 18 Almaden Ct | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5995898.24477745 | 2112499.08176223 | 37.7802838062154 | -122.457813168523 | (37.7802838062154, -122.457813168523) | |||||
118077 | 118077 | 111289 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 306 AVILA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000943.0 | 2121065.0 | 37.804092109664005 | -122.440975765753 | (37.804092109664, -122.440975765753) | ||||
77563 | 77563 | 94632 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3600 16th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 775358 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
11285 | 11285 | 83683 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004110.69577 | 2089162.29942 | 37.716674810270206 | -122.42773926378 | (37.7166748102702, -122.42773926378) | |
10590 | 10590 | 82568 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004119.416680001 | 2089176.12127 | 37.7167132553824 | -122.427710104164 | (37.7167132553824, -122.427710104164) | |
51547 | 51547 | 100515 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
78740 | 78740 | 100511 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
93844 | 93844 | 100509 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
98606 | 98606 | 100510 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
102274 | 102274 | 100512 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
115256 | 115256 | 100516 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
141150 | 141150 | 100513 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
116511 | 116511 | 109679 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 56 Nebraska St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6009259.3 | 2097729.0 | 37.7404870517112 | -122.410547623557 | (37.7404870517112, -122.410547623557) | |||
53784 | 53784 | 113548 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1911 20th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774960 | 6012300.00129 | 2104664.7502 | 37.759701124429796 | -122.400521077012 | (37.7597011244298, -122.400521077012) | ||
109588 | 109588 | 113335 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
119781 | 119781 | 113337 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
127734 | 127734 | 113338 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");