trees
163,064 rows where qCaretaker_id = 2 sorted by PlantType
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType ▼ | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142057 | 121418 | DPW Maintained 1 | Juniperus californica :: California juniper 295 | 521 Lakeview Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 5996348 | 2089857 | 37.7181401212561 | -122.454621046384 | (37.7181401212561, -122.454621046384) | 9 | 8 | 6 | 28861 | 24 | ||||
142135 | 105042 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 4 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x10 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
142477 | 89139 | DPW Maintained 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373 | (37.7541940143569, -122.41572017373) | 2 | 4 | 7 | 28859 | 19 | ||||
142599 | 92072 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 3001 Pacific Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/18/2009 12:00:00 AM | Permit Number 52188 | 5999733.7 | 2116663.4 | 37.7919375385156 | -122.444844029888 | (37.7919375385156, -122.444844029888) | 13 | 6 | 1 | 29490 | 27 | ||||
143343 | 109370 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
143607 | 254234 | DPW Maintained 1 | :: 45 | 2651 Baker St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/23/2018 12:00:00 AM | 3 | 7x3.6 | 5999602.71876 | 2117913.49531 | 37.7953624938231 | -122.445387148979 | (37.7953624938231, -122.445387148979) | 13 | 9 | 1 | 57 | 17 | ||
144676 | 99532 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
145213 | 256660 | Property Tree 8 | Private shrub :: Private Shrub 284 | 40X Miguel St | 1 | Back Yard : Yard | Landscaping | Private 2 | 3x3 | 6003624 | 2097154 | 37.7385906898162 | -122.429991281012 | (37.7385906898162, -122.429991281012) | 2 | 7 | 5 | 63 | 7 | ||||
145530 | 251249 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 161 Lundys Ln | 1 | Front Yard : Yard | Landscaping | Private 2 | 3x3 | 6006716 | 2098685 | 37.7429691002686 | -122.41940918518 | (37.7429691002686, -122.41940918518) | 2 | 7 | 7 | 28859 | 2 | ||||
147701 | 109353 | DPW Maintained 1 | Ficus Spp. :: 101 | 2505 Pacific Ave | 6 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092 | 2116990 | 37.7929686009801 | -122.43670770269 | (37.7929686009801, -122.43670770269) | 13 | 6 | 1 | 29490 | 27 | ||
148261 | 104667 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 172 Clipper St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/19/2016 12:00:00 AM | 6x12 | Permit Number 777366 | 6003998.6 | 2101043.1 | 37.7492904699227 | -122.42897329467 | (37.7492904699227, -122.42897329467) | 2 | 4 | 5 | 28862 | 22 | |
148544 | 104637 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6010036 | 2099691 | 37.7459177905176 | -122.408000413375 | (37.7459177905176, -122.408000413375) | 2 | 7 | 7 | 28859 | 2 | |||||
152155 | 107078 | DPW Maintained 1 | Tree(s) :: 17 | 92 Homestead St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/25/2014 12:00:00 AM | 3x3.5 | Permit Number 773562 | 6000948.33481 | 2101213.46128 | 37.7495851129185 | -122.439533357227 | (37.7495851129185, -122.439533357227) | 2 | 4 | 5 | 28862 | 22 | |||
152658 | 109368 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
152691 | 111758 | DPW Maintained 1 | :: 45 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.507284463143 | (37.7634442160317, -122.507284463143) | 1 | 8 | 3 | 56 | 35 | ||
153433 | 104374 | DPW Maintained 1 | Tree(s) :: 17 | 22 GARDENSIDE DR | 1 | Median : Yard | Landscaping | Private 2 | 50x50 | 5999468 | 2101996 | 37.7516494117124 | -122.444708626009 | (37.7516494117124, -122.444708626009) | 2 | 5 | 5 | 63 | 38 | ||||
153742 | 96292 | DPW Maintained 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot | Landscaping | Private 2 | 03/21/2011 12:00:00 AM | 6006773 | 2119090 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | 5 | 9 | 1 | 28858 | 32 | |||||
154536 | 254705 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
154649 | 109365 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
155364 | 105003 | DPW Maintained 1 | Shrub :: Shrub 66 | 607 CONGO ST | Sidewalk: Property side : Yard | Landscaping | Private 2 | 6000094.1 | 2095817 | 37.7347190590407 | -122.44210000591 | (37.7347190590407, -122.44210000591) | 9 | 7 | 4 | 63 | 40 | ||||||
156294 | 104564 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 18 FLOOD AVE | 1 | Front Yard : Yard | Landscaping | Private 2 | 6000327 | 2094154 | 37.7301661180838 | -122.441175517042 | (37.7301661180838, -122.441175517042) | 9 | 7 | 4 | 63 | 40 | |||||
157116 | 256250 | Permitted Site 7 | :: 45 | 2532 Sutter St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x18 | 6000473.43497 | 2114128.52893 | 37.7850196296057 | -122.442102513681 | (37.7850196296057, -122.442102513681) | 15 | 6 | 1 | 29490 | 27 | ||||
157535 | 114321 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2118 47th Ave | 1 | Front Yard : Cutout | Landscaping | Private 2 | 01/14/2016 12:00:00 AM | 5x16 | Permit Number 777356 | 5981743.9 | 2100646.6 | 37.7469169691931 | -122.505899765145 | (37.7469169691931, -122.505899765145) | 1 | 8 | 3 | 29491 | 35 | ||
157539 | 109767 | DPW Maintained 1 | :: 45 | 1801 Scott St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 11.75x1.5+3.6x3.6 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 | ||||
158395 | 109352 | DPW Maintained 1 | Ficus Spp. :: 101 | 2505 Pacific Ave | 5 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092 | 2116990 | 37.7929686009801 | -122.43670770269 | (37.7929686009801, -122.43670770269) | 13 | 6 | 1 | 29490 | 27 | ||
158438 | 109768 | DPW Maintained 1 | :: 45 | 2502X Bush St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x13 | 6001313.62368 | 2114572.17699 | 37.7862856185892 | -122.439227543381 | (37.7862856185892, -122.439227543381) | 13 | 6 | 1 | 29490 | 27 | ||||
159223 | 254087 | DPW Maintained 1 | :: 45 | 2520 Broadway | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 11.75x6 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
159483 | 93161 | DPW Maintained 1 | Tree(s) :: 17 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 | |||
159975 | 97139 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 937 Goettingen St | Front Yard : | Landscaping | Private 2 | 6011052 | 2090410 | 37.7204909525546 | -122.403834244644 | (37.7204909525546, -122.403834244644) | 10 | 7 | 8 | 309 | 28 | ||||||
160040 | 99534 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
162179 | 85184 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 501 Bartlett St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/13/2006 12:00:00 AM | 3x25 | Permit Number 768657 | 6006822 | 2100867 | 37.7489663498096 | -122.419197411761 | (37.7489663498096, -122.419197411761) | 2 | 4 | 7 | 28859 | 19 | |||
162713 | 96182 | DPW Maintained 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout | Landscaping | Private 2 | 04/04/2011 12:00:00 AM | Permit Number 767813 | 6007366 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | 8 | 4 | 7 | 28853 | 19 | ||||
163271 | 173852 | DPW Maintained 1 | :: 45 | 450 Toland St | 7 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 8.5x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
165551 | 85121 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.468484819075 | (37.7618848250494, -122.468484819075) | 1 | 8 | 4 | 56 | 12 | |
166540 | 109364 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
166833 | 254091 | DPW Maintained 1 | :: 45 | 2520 Broadway | 4 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 13x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
166923 | 117259 | DPW Maintained 1 | :: 45 | 670 Eddy St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 6007197.5 | 2113350.2 | 37.7832634280904 | -122.418784110751 | (37.7832634280904, -122.418784110751) | 7 | 9 | 9 | 28858 | 36 | ||||
169238 | 105039 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
169278 | 5412 | DPW Maintained 1 | Tree(s) :: 17 | 414 Dolores St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | 6004849.3785887 | 2105949.0211321 | 37.7628090992038 | -122.426380541105 | (37.7628090992038, -122.426380541105) | 8 | 4 | 5 | 28859 | 3 | |||
169546 | 254703 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
169559 | 253675 | DPW Maintained 1 | :: 45 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/24/2017 12:00:00 AM | 3 | 3.2x14.2 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | 13 | 9 | 1 | 28858 | 17 | ||
170014 | 173846 | DPW Maintained 1 | :: 45 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 15x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
170692 | 251419 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/14/2015 12:00:00 AM | 3x3 | 6009068 | 2112723 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | 7 | 10 | 9 | 28852 | 36 | |||
170913 | 99535 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
171003 | 117478 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 400 PERALTA AVE | 1 | Front Yard : Yard | Landscaping | Private 2 | 3x3 | 6009762 | 2099359 | 37.7449908466617 | -122.408924451675 | (37.7449908466617, -122.408924451675) | 2 | 7 | 7 | 28859 | 2 | ||||
171232 | 253516 | DPW Maintained 1 | :: 45 | 559 24th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 09/15/2017 12:00:00 AM | 3 | 2x2 | 5988392 | 2112177 | 37.7789653704935 | -122.483756799769 | (37.7789653704935, -122.483756799769) | 11 | 6 | 2 | 55 | 26 | ||
171517 | 104636 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6010036 | 2099691 | 37.7459177905176 | -122.408000413375 | (37.7459177905176, -122.408000413375) | 2 | 7 | 7 | 28859 | 2 | |||||
171662 | 105041 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x2 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
171678 | 107716 | DPW Maintained 1 | Tree(s) :: 17 | 2400X 25th Ave | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | Port | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773973 | 5985789 | 2098909 | 37.7423832554664 | -122.491784477839 | (37.7423832554664, -122.491784477839) | 1 | 8 | 3 | 29491 | 35 |
174259 | 79468 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 606 Webster St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52423 | 6004042.90191121 | 2110875.50885644 | 37.7762904169609 | -122.429521216963 | (37.7762904169609, -122.429521216963) | 7 | 9 | 11 | 28852 | 10 | ||
174827 | 88656 | DPW Maintained 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 | 94 Danton St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844 | 2094598 | 37.7315282931893 | -122.432505629551 | (37.7315282931893, -122.432505629551) | 9 | 7 | 5 | 28861 | 25 | ||||
178111 | 104635 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | |||||
178182 | 102414 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1301 Page St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6000345 | 2109213 | 37.7715155205087 | -122.442193873774 | (37.7715155205087, -122.442193873774) | 15 | 5 | 11 | 29492 | 9 | |||||
178979 | 254086 | DPW Maintained 1 | :: 45 | 2520 Broadway | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 11.75x6 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
179378 | 99528 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
179791 | 173853 | DPW Maintained 1 | :: 45 | 450 Toland St | 8 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 26.75x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
179831 | 256218 | Undocumented 4 | Arbutus unedo :: Strawberry Tree 106 | 159X Brewster St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
181901 | 191507 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 725 18th St | 3 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 6 | Width 2ft | 6015301.62259 | 2105759.06622 | 37.7628728201497 | -122.390216323947 | (37.7628728201497, -122.390216323947) | 10 | 3 | 8 | 28856 | 29 | |||
182766 | 85104 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.468484819075 | (37.7618848250494, -122.468484819075) | 1 | 8 | 4 | 56 | 12 | ||
186942 | 99610 | DPW Maintained 1 | Tree(s) :: 17 | 111 Corwin St | Unaccepted Street : Yard | Landscaping | Private 2 | 6000616 | 2104331 | 37.7581261988062 | -122.44090619354 | (37.7581261988062, -122.44090619354) | 2 | 4 | 5 | 28862 | 38 | ||||||
186997 | 20137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 898 Steiner St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54088 | 6003009.7075288 | 2111327.5412023 | 37.7774730322357 | -122.433127623561 | (37.7774730322357, -122.433127623561) | 15 | 9 | 11 | 29492 | 10 | |
187314 | 82512 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 52 Tulane St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52482 | 6007264 | 2093867 | 37.7297707824944 | -122.417173017284 | (37.7297707824944, -122.417173017284) | 9 | 3 | 7 | 309 | 28 | ||
187522 | 109253 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1355 46th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773041 | 5981790.7 | 2105864.5 | 37.7612466017789 | -122.506124767382 | (37.7612466017789, -122.506124767382) | 1 | 8 | 3 | 56 | 35 |
188049 | 191506 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 725 18th St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 12 | Width 2ft | 6015277.21856 | 2105757.38147 | 37.7628668405556 | -122.390300611982 | (37.7628668405556, -122.390300611982) | 10 | 3 | 8 | 28856 | 29 | |||
188940 | 93162 | DPW Maintained 1 | Tree(s) :: 17 | 201 Upper Ter | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 3x3 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 | |||
190887 | 82886 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 761 Clementina St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52437 | 6009240.34446046 | 2110165.45314704 | 37.7746336766823 | -122.411491580973 | (37.7746336766823, -122.411491580973) | 8 | 2 | 9 | 28853 | 34 | ||
191035 | 105040 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
191726 | 93936 | DPW Maintained 1 | Tree(s) :: 17 | 230 Seacliff Ave | Sidewalk: Curb side : | Landscaping | Private 2 | 04/26/2010 12:00:00 AM | 37x6 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | 11 | 6 | 1 | 55 | 33 | ||||
191808 | 103623 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | ||
192149 | 98878 | Property Tree 8 | Tree(s) :: 17 | 11 Panorama Dr | Back Yard : Yard | Landscaping | Private 2 | 5998029 | 2100213 | 37.7466715093679 | -122.449556386849 | (37.7466715093679, -122.449556386849) | 2 | 5 | 4 | 63 | 38 | ||||||
193077 | 253676 | DPW Maintained 1 | :: 45 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | 13 | 9 | 1 | 28858 | 17 | ||
3 | 121463 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
7 | 188479 | Prune Opt Out 3 | Ceratonia siliqua :: Carob 5 | 2208 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 787847 | 6010817.79084 | 2106032.71885 | 37.7633744862602 | -122.405743691032 | (37.7633744862602, -122.405743691032) | 8 | 4 | 8 | 28859 | 19 | ||
9 | 32966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 556 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/2020 12:00:00 AM | 3 | Permit Number 37281 | 6014072.59224 | 2104507.52941 | 37.759368126158 | -122.394379509632 | (37.759368126158, -122.394379509632) | 10 | 3 | 8 | 28856 | 29 | |
10 | 264794 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | 6011433 | 2091603 | 37.7237879639177 | -122.40260109208 | (37.7237879639177, -122.40260109208) | 10 | 3 | 7 | 309 | 28 | ||
12 | 264792 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
14 | 162252 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 789 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | Width 0ft | 6011428.3902 | 2091205.22693 | 37.7226955033817 | -122.402589068938 | (37.7226955033817, -122.402589068938) | 10 | 3 | 7 | 309 | 28 | ||
17 | 164866 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 719 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782492 | 5994853.78052 | 2092811.30491 | 37.7261661184654 | -122.459999785581 | (37.7261661184654, -122.459999785581) | 9 | 7 | 4 | 28861 | 40 | |
18 | 50210 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 830 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 8 | Permit Number 46918 | 5987602.00308 | 2110288.94488 | 37.7737352840678 | -122.486351029235 | (37.7737352840678, -122.486351029235) | 11 | 6 | 2 | 55 | 26 | |
20 | 264793 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
23 | 50211 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 834 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 9 | Permit Number 46919 | 5987605.33986 | 2110266.54313 | 37.7736739696217 | -122.486337841964 | (37.7736739696217, -122.486337841964) | 11 | 6 | 2 | 55 | 26 | |
24 | 264941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Portola Dr | 12 | Median : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2101261 | 37.7496473113918 | -122.443684097942 | (37.7496473113918, -122.443684097942) | 2 | 5 | 5 | 28862 | 38 | ||||
25 | 49783 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | Permit Number 46568 | 6011944.29976 | 2088937.30454 | 37.7164970376796 | -122.400646428989 | (37.7164970376796, -122.400646428989) | 10 | 7 | 8 | 309 | 39 | |
27 | 121462 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
30 | 254372 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778036 | 6010859.22958 | 2088882.34048 | 37.7162855403434 | -122.404393121162 | (37.7162855403434, -122.404393121162) | 9 | 7 | 8 | 309 | 39 |
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
33 | 261067 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1832 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782484 | 6011934 | 2092960 | 37.727541965346 | -122.400964507068 | (37.727541965346, -122.400964507068) | 10 | 3 | 8 | 58 | 1 | |
34 | 262408 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 66X Edgehill Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994840 | 2098758 | 37.7424934921887 | -122.46047813267 | (37.7424934921887, -122.46047813267) | 1 | 8 | 4 | 59 | 40 | ||||
35 | 16620 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 125 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/1999 12:00:00 AM | 6 | 3X3 | 6002913 | 2107540 | 37.7670678918229 | -122.433191472284 | (37.7670678918229, -122.433191472284) | 15 | 5 | 5 | 28862 | 3 | ||
36 | 166891 | Permitted Site 7 | Banksia integrifolia :: Coast Banksia 21 | 174 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787855 | 6003954.63071 | 2101612.59597 | 37.7508516839573 | -122.429165942869 | (37.7508516839573, -122.429165942869) | 2 | 4 | 5 | 28862 | 22 | |
37 | 264963 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | 6005706 | 2110306 | 37.7748207071365 | -122.423727591769 | (37.7748207071365, -122.423727591769) | 7 | 9 | 11 | 28852 | 10 | ||
38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
39 | 210801 | DPW Maintained 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 140 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 787871 | 5994480.90157 | 2099425.24867 | 37.7443049252384 | -122.461768149483 | (37.7443049252384, -122.461768149483) | 1 | 8 | 4 | 59 | 40 | |
40 | 6039 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1822 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001574.3819 | 2112547.6661 | 37.7807416628926 | -122.438180307395 | (37.7807416628926, -122.438180307395) | 15 | 5 | 11 | 29490 | 41 | |||
41 | 159866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001590.27181 | 2091627.71254 | 37.7233013847479 | -122.436627471279 | (37.7233013847479, -122.436627471279) | 9 | 7 | 6 | 28861 | 25 | ||
42 | 221891 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 180 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006685.21207 | 2102724.39469 | 37.7540586268078 | -122.419802203518 | (37.7540586268078, -122.419802203518) | 2 | 4 | 7 | 28859 | 19 | |||
43 | 264724 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 2901 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999656 | 2116990 | 37.7928298614365 | -122.445136362104 | (37.7928298614365, -122.445136362104) | 13 | 6 | 1 | 29490 | 27 | ||||
44 | 159867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001543.73914 | 2091652.70256 | 37.7233673572035 | -122.436790113668 | (37.7233673572035, -122.436790113668) | 9 | 7 | 6 | 28861 | 25 | ||
45 | 134298 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1948 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 4ft | 6004784.56446 | 2117433.72769 | 37.7943396156388 | -122.427422908337 | (37.7943396156388, -122.427422908337) | 13 | 9 | 1 | 28858 | 27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );