Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138891 | 138891 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 139193 | 139193 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 139478 | 139478 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 10275 | 10275 | 32464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | ||
| 107056 | 107056 | 104507 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5998517.0 | 2087907.0 | 37.7129100350962 | -122.44698352706499 | (37.7129100350962, -122.446983527065) | |||
| 53785 | 53785 | 111858 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
| 88303 | 88303 | 111854 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
| 88535 | 88535 | 111853 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | |||
| 95443 | 95443 | 111857 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
| 110099 | 110099 | 111855 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
| 144152 | 144152 | 111856 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
| 43528 | 43528 | 209215 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x Castenada Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 5993821.14503 | 2100240.07202 | 37.746504222711295 | -122.46410856948 | (37.7465042227113, -122.46410856948) | |||
| 134453 | 134453 | 209214 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x Castenada Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993812.322269999 | 2100226.93547 | 37.746467644571 | -122.464138123878 | (37.746467644571, -122.464138123878) | |||
| 180603 | 180603 | 206418 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x Castenada Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5993828.80673 | 2100251.01259 | 37.7465347043225 | -122.464082870453 | (37.7465347043225, -122.464082870453) | |||
| 110994 | 110994 | 111670 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998115.0 | 2107097.0 | 37.7655781805803 | -122.44975501544201 | (37.7655781805803, -122.449755015442) | ||||
| 116012 | 116012 | 111669 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998115.0 | 2107097.0 | 37.7655781805803 | -122.44975501544201 | (37.7655781805803, -122.449755015442) | ||||
| 99106 | 99106 | 111065 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007219.0 | 2106804.0 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | ||||
| 111688 | 111688 | 111064 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007219.0 | 2106804.0 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | |||
| 13964 | 13964 | 24120 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6016647.77235 | 2095170.8389599998 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | |||
| 77908 | 77908 | 23617 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992931.1771373 | 2097763.0006234 | 37.7396514793132 | -122.467005897689 | (37.7396514793132, -122.467005897689) | |||
| 118929 | 118929 | 23618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992931.1771373 | 2097763.0006234 | 37.7396514793132 | -122.467005897689 | (37.7396514793132, -122.467005897689) | |||
| 79227 | 79227 | 106170 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99X THOR AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6002346.0 | 2095994.0 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | |||
| 101415 | 101415 | 24476 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99X Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002281.226578901 | 2096676.7830479 | 37.73720422475029 | -122.43459982975 | (37.7372042247503, -122.43459982975) | |||
| 85680 | 85680 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | |||||
| 5846 | 5846 | 18671 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 13 | 2X2 | 5999533.57531 | 2119335.56991 | 37.799263184406705 | -122.445728714712 | (37.7992631844067, -122.445728714712) | ||
| 5935 | 5935 | 18670 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 5999509.53732 | 2119357.2628900004 | 37.799321375051704 | -122.445813455145 | (37.7993213750517, -122.445813455145) | |||
| 78086 | 78086 | 24438 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 83108 | 83108 | 24439 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 90479 | 90479 | 24437 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 93710 | 93710 | 24440 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 97951 | 97951 | 24433 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 112421 | 112421 | 24434 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 92691 | 92691 | 52391 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 99103 | 99103 | 52390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 119408 | 119408 | 52392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 145547 | 145547 | 52389 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 143358 | 143358 | 117258 | Undocumented 2 | Tree(s) :: 17 | 99X PROSPER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6003339.0 | 2106236.0 | 37.7635115803019 | -122.431624896471 | (37.7635115803019, -122.431624896471) | ||||
| 81456 | 81456 | 17320 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 87430 | 87430 | 17324 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 90076 | 90076 | 17321 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 119477 | 119477 | 17322 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 142907 | 142907 | 17323 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 44523 | 44523 | 111165 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003411.20248 | 2119815.94235 | 37.800802791376796 | -122.432345118256 | (37.8008027913768, -122.432345118256) | |||
| 53706 | 53706 | 111161 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003338.31122 | 2119805.5444900002 | 37.8007701082019 | -122.432596609162 | (37.8007701082019, -122.432596609162) | |||
| 61466 | 61466 | 111164 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003392.2553900005 | 2119813.00098 | 37.8007936407819 | -122.43241047286199 | (37.8007936407819, -122.432410472862) | |||
| 151211 | 151211 | 111160 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003321.77346 | 2119803.50555 | 37.8007635719416 | -122.43265369092899 | (37.8007635719416, -122.432653690929) | |||
| 154752 | 154752 | 111162 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003355.09781 | 2119808.05454 | 37.8007779520905 | -122.43253870000001 | (37.8007779520905, -122.4325387) | |||
| 167365 | 167365 | 111163 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003374.28365 | 2119810.9912900003 | 37.80078710360971 | -122.43247251891898 | (37.8007871036097, -122.432472518919) | |||
| 102548 | 102548 | 101898 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
| 105468 | 105468 | 101899 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
| 2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2859 | 2859 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2869 | 2869 | 253250 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2874 | 2874 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 34310 | 34310 | 12969 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 99X Lippard Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X4 | 6001957.7757889 | 2095598.483465 | 37.734225095766796 | -122.43564102376301 | (37.7342250957668, -122.435641023763) | |||
| 106673 | 106673 | 12970 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 99X Lippard Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 5X4 | 6001957.7757889 | 2095598.483465 | 37.734225095766796 | -122.43564102376301 | (37.7342250957668, -122.435641023763) | |||
| 112623 | 112623 | 12968 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 99X Lippard Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 6001957.7757889 | 2095598.483465 | 37.734225095766796 | -122.43564102376301 | (37.7342250957668, -122.435641023763) | |||
| 143021 | 143021 | 12967 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 99X Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001957.7757889 | 2095598.483465 | 37.734225095766796 | -122.43564102376301 | (37.7342250957668, -122.435641023763) | |||
| 17038 | 17038 | 115537 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 78927 | 78927 | 115540 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x5 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 89451 | 89451 | 115539 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 120364 | 120364 | 115538 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 142150 | 142150 | 115536 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 102241 | 102241 | 121608 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 117773 | 117773 | 121606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 140890 | 140890 | 121607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 88365 | 88365 | 47489 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 99X LYELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | |
| 90674 | 90674 | 47490 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 99X LYELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 2 | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | |
| 101202 | 101202 | 47488 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 99X LYELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | ||
| 119045 | 119045 | 32752 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5995934.0 | 2088667.0 | 37.714848906239204 | -122.455966075921 | (37.7148489062392, -122.455966075921) | ||
| 8877 | 8877 | 103815 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006959.84507 | 2114826.77891 | 37.7873043685578 | -122.419711106691 | (37.7873043685578, -122.419711106691) | ||
| 9028 | 9028 | 103814 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006931.25215 | 2114822.01169 | 37.787289668217795 | -122.41980969397 | (37.7872896682178, -122.41980969397) | ||
| 20029 | 20029 | 10244 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 99X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 6 | 3X3 | 6005773.33687 | 2109613.89968 | 37.7729241676403 | -122.42344544616002 | (37.7729241676403, -122.42344544616) | ||
| 89922 | 89922 | 10245 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 99X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2008 12:00:00 AM | 6 | 3X3 | Permit Number 769626 | 6005669.1162393 | 2109600.6288971 | 37.7728818463732 | -122.42380501439399 | (37.7728818463732, -122.423805014394) | |
| 113153 | 113153 | 106104 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X HARTFORD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x3 | 6002644.0 | 2105609.0 | 37.761750572206104 | -122.433983855891 | (37.7617505722061, -122.433983855891) | |||
| 92322 | 92322 | 9315 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 99X Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 94044 | 94044 | 9319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 98684 | 98684 | 9317 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | ||
| 104495 | 104495 | 9316 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 99X Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 109307 | 109307 | 9318 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 99X Gold Mine Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 112931 | 112931 | 9320 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 99X Gold Mine Dr | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 126064 | 126064 | 9313 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 99X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 20380 | 20380 | 112084 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 104211 | 104211 | 112085 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 95984 | 95984 | 103790 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
| 108374 | 108374 | 103789 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
| 139518 | 139518 | 103788 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
| 9683 | 9683 | 173631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 99X Everglade Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986361.0 | 2095495.0 | 37.733042731061104 | -122.48955570953301 | (37.7330427310611, -122.489555709533) | ||||
| 9987 | 9987 | 173779 | Significant Tree 6 | Ficus macrophylla :: Morton Bay Fig 148 | 99X Cleveland St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10010 | 10010 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 9230 | 9230 | 3927 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 9370 | 9370 | 3926 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 9417 | 9417 | 3919 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 9469 | 9469 | 3928 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 77675 | 77675 | 3914 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X Castro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 80306 | 80306 | 3923 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2011 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 83397 | 83397 | 3920 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) |
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");