trees
194,517 rows 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134781 | 227520 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 16 Tiffany Ave | 1 | : | Landscaping | Private 2 | 4 | Width 2ft | 6006374.41145 | 2099856.22866 | 37.7461657844399 | -122.420673433456 | (37.7461657844399, -122.420673433456) | 2 | 7 | 5 | 28859 | 2 | |||
136488 | 109499 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207237 | (37.7359945088656, -122.43418207237) | 2 | 7 | 5 | 63 | 7 |
137283 | 109242 | Property Tree 8 | Private shrub :: Private Shrub 284 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard | Landscaping | Private 2 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | 2 | 7 | 5 | 63 | 7 | ||||||
137488 | 98501 | Property Tree 8 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998998 | 2100740 | 37.7481739100487 | -122.446243600021 | (37.7481739100487, -122.446243600021) | 2 | 5 | 5 | 63 | 38 | ||||||
137888 | 256220 | Undocumented 4 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 527 | 159X Brewster St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
138736 | 99533 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 1 | 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 | ||||
140191 | 117919 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 727 41st Ave | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3 | Width 3ft | 5983193.78874 | 2110818.22502 | 37.774930606826 | -122.501638652158 | (37.774930606826, -122.501638652158) | 11 | 6 | 2 | 55 | 26 | |||
140484 | 92775 | Permitted Site 7 | Tree(s) :: 17 | 2701 Pacific Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | 13 | 6 | 1 | 29490 | 27 | ||||
141139 | 251418 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 39 Jones St | 1 | 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 | |||
141581 | 110613 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/27/2015 12:00:00 AM | 3 | 12.8x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
141766 | 104864 | DPW Maintained 1 | :: 45 | 45 Hoffman Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6000629.3 | 2102650 | 37.7535113392088 | -122.440739618385 | (37.7535113392088, -122.440739618385) | 2 | 4 | 5 | 28862 | 22 | ||||||
141783 | 110320 | Property Tree 8 | :: 45 | 9 Imperial Aly | Back Yard : Yard | Landscaping | Private 2 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | 13 | 9 | 1 | 57 | 17 | ||||||
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 | ||||
153628 | 104153 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
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 | |||||
156692 | 104157 | DPW Maintained 1 | :: 45 | 525X Church St | 5 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
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 | ||||
161563 | 116580 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 3 | Sidewalk: Property side : Cutout | Landscaping | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | |||
161681 | 4313 | DPW Maintained 1 | Shrub :: Shrub 66 | 727 Chenery St | 1 | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | 08/17/2013 12:00:00 AM | 3X3 | 6002321.25178 | 2095689.19659 | 37.7344948117373 | -122.434390856497 | (37.7344948117373, -122.434390856497) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
164652 | 104152 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
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 | ||
1 | 264847 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010522 | 2093730 | 37.729577358437 | -122.405900044893 | (37.729577358437, -122.405900044893) | 10 | 3 | 7 | 309 | 28 | |||
2 | 262167 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
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 | |
4 | 264831 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | 6011678 | 2088870 | 37.7162973770842 | -122.401562170369 | (37.7162973770842, -122.401562170369) | 10 | 7 | 8 | 309 | 39 | ||
5 | 264836 | DPW Maintained 1 | Laurus x 'Saratoga' :: Hybrid Laurel 4 | 325 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | 6010737 | 2090909 | 37.7218435009065 | -122.404958220137 | (37.7218435009065, -122.404958220137) | 10 | 3 | 7 | 309 | 28 | ||
6 | 262166 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
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 | ||
8 | 264824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6012032 | 2089425 | 37.7178410421308 | -122.400377527521 | (37.7178410421308, -122.400377527521) | 10 | 7 | 8 | 309 | 39 | |||
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 | ||
11 | 264841 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
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 |
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) );