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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59691 | 255179 | Permitted Site 7 | :: 45 | 619 06th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/18/2018 12:00:00 AM | 3 | 5994069.31075 | 2111288.088 | 37.7768535012339 | -122.464052313375 | (37.7768535012339, -122.464052313375) | 11 | 6 | 2 | 54 | 11 | |||
| 60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
| 61259 | 221750 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 275 Grattan St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 11 | Width 4ft | 5997409.41415 | 2106414.31665 | 37.7636633116224 | -122.452146205787 | (37.7636633116224, -122.452146205787) | 15 | 5 | 11 | 29492 | 9 | |||
| 64175 | 109535 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 64619 | 253411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.7759913538039 | -122.414931236288 | (37.7759913538039, -122.414931236288) | 8 | 2 | 9 | 28853 | 34 | |
| 66039 | 109366 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 67643 | 92611 | DPW Maintained 1 | Shrub :: Shrub 66 | 3856 23rd St | Sidewalk: Property side : Pot | Landscaping | Private 2 | 08/31/2009 12:00:00 AM | Permit Number 52924 | 6004067 | 2102488 | 37.7532616988935 | -122.428839761175 | (37.7532616988935, -122.428839761175) | 2 | 4 | 5 | 28862 | 22 | ||||
| 67891 | 255961 | Permitted Site 7 | :: 45 | 2518 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/08/2018 12:00:00 AM | 3 | 5x7 | 6003674.59495 | 2116996.308 | 37.7930757331753 | -122.431232293197 | (37.7930757331753, -122.431232293197) | 13 | 9 | 1 | 29490 | 27 | ||
| 68093 | 106516 | DPW Maintained 1 | Tree(s) :: 17 | 366 Hill St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/07/2014 12:00:00 AM | 3X3 | Permit Number 772751 | 6003996.2 | 2103381.7 | 37.7557115810688 | -122.42914832014 | (37.7557115810688, -122.42914832014) | 2 | 4 | 5 | 28862 | 22 | |||
| 69385 | 83007 | DPW Maintained 1 | Laurus x 'Saratoga' :: Hybrid Laurel 4 | 1058 De Haro St | 1 | Median : Cutout | Landscaping | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52381 | 6012170.46860809 | 2103464.70975517 | 37.7563988530014 | -122.400884755815 | (37.7563988530014, -122.400884755815) | 10 | 3 | 8 | 28856 | 29 | ||
| 70325 | 254123 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2111 46th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/14/2019 12:00:00 AM | 3 | 3x15 | Permit Number 783274 | 5981986.1845 | 2100718.85597 | 37.747129621994 | -122.505067335608 | (37.747129621994, -122.505067335608) | 1 | 8 | 3 | 29491 | 35 | |
| 70329 | 16698 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 950X Noriega St | 2 | Median : Cutout | Landscaping | DPW 1 | 12 | 8 | 5991017.96771 | 2103156.31666 | 37.7543495107367 | -122.47401428524 | (37.7543495107367, -122.47401428524) | 1 | 8 | 4 | 56 | 12 | |||
| 70800 | 225282 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 101 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6 | Width 3ft | 5998123.1152 | 2105954.07554 | 37.762440462975 | -122.44964458054 | (37.762440462975, -122.44964458054) | 15 | 5 | 11 | 29492 | 9 | |||
| 71605 | 109344 | DPW Maintained 1 | :: 45 | 3211 Baker St | 3 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 72279 | 103619 | DPW Maintained 1 | Tree(s) :: 17 | 1200 Monterey Blvd | 1 | Front Yard : Yard | Landscaping | Private 2 | 5994284.3 | 2094292 | 37.7301989768893 | -122.462075764747 | (37.7301989768893, -122.462075764747) | 9 | 8 | 4 | 59 | 40 | |||||
| 73650 | 99530 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 4 | 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 | ||||
| 74831 | 181347 | DPW Maintained 1 | Tree(s) :: 17 | 2500 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 6 | Width 0ft | 5985144.6465 | 2098114.9716 | 37.7401653859663 | -122.493953920474 | (37.7401653859663, -122.493953920474) | 1 | 8 | 3 | 29491 | 35 | |||
| 75257 | 92778 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2701 Pacific Ave | Sidewalk: Property 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 | ||||
| 76327 | 109486 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1314 POLK ST | 1 | Sidewalk: Curb side : Pot | Landscaping | DPW 1 | 01/23/2016 04:50:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | 13 | 9 | 10 | 28858 | 21 | ||
| 77045 | 109322 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 191 24TH AVE | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 5988309.1 | 2114757.6 | 37.7860461422813 | -122.484232887865 | (37.7860461422813, -122.484232887865) | 11 | 6 | 1 | 55 | 33 | ||||
| 77582 | 82889 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1423 Francisco St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52339 | 6004509.13864627 | 2120473.3950975 | 37.8026701808582 | -122.42859269053 | (37.8026701808582, -122.42859269053) | 13 | 9 | 1 | 57 | 17 | ||
| 78434 | 104861 | DPW Maintained 1 | :: 45 | 3458A 18th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6006508 | 2105569.9 | 37.7618617394874 | -122.420617027809 | (37.7618617394874, -122.420617027809) | 8 | 4 | 7 | 28859 | 19 | ||||||
| 78553 | 109534 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 79157 | 173848 | DPW Maintained 1 | :: 45 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
| 79210 | 109345 | DPW Maintained 1 | :: 45 | 3211 Baker St | 4 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 79291 | 104154 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | 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 | |||
| 79912 | 254090 | DPW Maintained 1 | :: 45 | 2520 Broadway | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 1.75x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 82433 | 109343 | DPW Maintained 1 | :: 45 | 3211 Baker St | 2 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 85006 | 88654 | 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 | ||||
| 85052 | 258602 | Private 9 | :: 45 | 682 12th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/29/2019 12:00:00 AM | 3 | 8X4 | 5992266.47414 | 2110804.58144 | 37.7754218561197 | -122.470253595146 | (37.7754218561197, -122.470253595146) | 11 | 6 | 2 | 54 | 11 | ||
| 85170 | 110614 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/31/2015 12:00:00 AM | 3 | 21.4x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
| 86162 | 254706 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 1 | 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 | |||
| 86616 | 99531 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 5 | 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 | ||||
| 87883 | 120156 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 758 10th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10 | 5992930 | 2110298 | 37.7740692588728 | -122.467921468059 | (37.7740692588728, -122.467921468059) | 11 | 6 | 2 | 54 | 11 | ||||
| 88473 | 85294 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2255 Mariposa St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/27/2007 12:00:00 AM | 2x50 | Permit Number 49675 | 6010752 | 2105977 | 37.7632178155038 | -122.405967315915 | (37.7632178155038, -122.405967315915) | 8 | 4 | 8 | 28859 | 19 | |||
| 88857 | 100242 | DPW Maintained 1 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot | Landscaping | Private 2 | 6005815 | 2105046 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | 2 | 4 | 5 | 28859 | 19 | ||||||
| 89615 | 106576 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 507 STEINER ST | 1 | Front Yard : Yard | Landscaping | Private 2 | 6003113.3 | 2110111.6 | 37.7741402349502 | -122.432682383122 | (37.7741402349502, -122.432682383122) | 15 | 5 | 11 | 29492 | 10 | |||||
| 90504 | 98893 | Property Tree 8 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998910 | 2100761 | 37.7482265448319 | -122.446549410607 | (37.7482265448319, -122.446549410607) | 2 | 5 | 5 | 63 | 38 | ||||||
| 91537 | 85195 | DPW Maintained 1 | Tree(s) :: 17 | 333 Eucalyptus Dr | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 5990168 | 2094689 | 37.7310511825826 | -122.476335191755 | (37.7310511825826, -122.476335191755) | 1 | 8 | 4 | 64 | 14 | ||||||
| 91685 | 83367 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3124-3128 Laguna St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52345 | 6003823.24826281 | 2119450.20874415 | 37.7998219368855 | -122.430893152133 | (37.7998219368855, -122.430893152133) | 13 | 9 | 1 | 57 | 17 | ||
| 93333 | 254714 | Permitted Site 7 | :: 45 | 636 Vermont St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 10x5.5 | 6011227.55095 | 2105388.49702 | 37.7616285037909 | -122.404281111091 | (37.7616285037909, -122.404281111091) | 10 | 3 | 8 | 28856 | 29 | ||
| 94087 | 96183 | DPW Maintained 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout | Landscaping | Private 2 | 6007366 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | 8 | 4 | 7 | 28853 | 19 | ||||||
| 94473 | 96289 | DPW Maintained 1 | Tree(s) :: 17 | 228 30th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | Permit Number 767877 | 6005120 | 2098458 | 37.7422557889482 | -122.424911572967 | (37.7422557889482, -122.424911572967) | 2 | 7 | 5 | 63 | 22 | |||||
| 94668 | 104156 | DPW Maintained 1 | :: 45 | 525X Church St | 4 | 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 | |||
| 94878 | 117511 | DPW Maintained 1 | Shrub :: Shrub 66 | 2634 37TH AVE | 1 | Median : Yard | Landscaping | DPW 1 | 20 | 3x3 | 5984921 | 2097163 | 37.7375384395308 | -122.494657023299 | (37.7375384395308, -122.494657023299) | 1 | 8 | 3 | 29491 | 35 | |||
| 98772 | 66797 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2655 Polk St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 11/26/2018 12:00:00 AM | 3 | Permit Number 782624 | 6006123.61383 | 2119959.43623 | 37.8013502149967 | -122.422969232649 | (37.8013502149967, -122.422969232649) | 13 | 9 | 1 | 28858 | 32 | |
| 99131 | 94962 | DPW Maintained 1 | Tree(s) :: 17 | 3098@Lyon Pacific Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/25/2010 12:00:00 AM | 5999362 | 2116697.3 | 37.7920093994348 | -122.446132548429 | (37.7920093994348, -122.446132548429) | 13 | 6 | 1 | 29490 | 27 | |||||
| 101080 | 107348 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 260 LANSDALE AVE | 1 | Back Yard : Yard | Landscaping | Private 2 | 5995019 | 2096651.7 | 37.7367204092857 | -122.459706678853 | (37.7367204092857, -122.459706678853) | 9 | 7 | 4 | 59 | 40 | |||||
| 101202 | 88829 | DPW Maintained 1 | Shrub :: Shrub 66 | 4437 20th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 09/30/2008 12:00:00 AM | 8x1 | Permit Number 51764 | 6001659 | 2104076 | 37.7574853780776 | -122.437280798466 | (37.7574853780776, -122.437280798466) | 2 | 4 | 5 | 28862 | 3 | |||
| 101831 | 120995 | Property Tree 8 | Private shrub :: Private Shrub 284 | 231 Delano Ave | 1 | Front Yard : Yard | Landscaping | Private 2 | 3x3 | 6000066 | 2092260 | 37.7249507611268 | -122.44194193564 | (37.7249507611268, -122.44194193564) | 9 | 7 | 6 | 28861 | 25 | ||||
| 102745 | 256219 | Undocumented 4 | Arbutus unedo :: Strawberry Tree 106 | 159X Brewster St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
| 103545 | 117372 | DPW Maintained 1 | :: 45 | 1533 McAllister St | 5 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/08/2016 12:00:00 AM | 3 | 1x2.75 | 6001806.7 | 2111472.8 | 37.7778035619302 | -122.437299621265 | (37.7778035619302, -122.437299621265) | 15 | 5 | 11 | 29492 | 41 | ||
| 103775 | 251700 | DPW Maintained 1 | :: 45 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 06/05/2017 12:00:00 AM | 3 | 410x11 | Permit Number 780193 | 6003924 | 2099150 | 37.7440882334859 | -122.429096301435 | (37.7440882334859, -122.429096301435) | 2 | 7 | 5 | 63 | 22 | |
| 104259 | 104859 | DPW Maintained 1 | :: 45 | 650 Fillmore St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6003597.7 | 2110555.4 | 37.775386259915 | -122.431038440447 | (37.775386259915, -122.431038440447) | 7 | 9 | 11 | 29492 | 10 | ||||||
| 104589 | 253412 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.7759913538039 | -122.414931236288 | (37.7759913538039, -122.414931236288) | 8 | 2 | 9 | 28853 | 34 | |
| 104748 | 104860 | DPW Maintained 1 | :: 45 | 283 Randall St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6003774.7 | 2097827.3 | 37.7404479510811 | -122.429518236565 | (37.7404479510811, -122.429518236565) | 2 | 7 | 5 | 63 | 7 | ||||||
| 105747 | 98892 | Property Tree 8 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998935 | 2100753 | 37.7482060067302 | -122.44646238624 | (37.7482060067302, -122.44646238624) | 2 | 5 | 5 | 63 | 38 | ||||||
| 106502 | 109350 | DPW Maintained 1 | Ficus Spp. :: 101 | 2505 Pacific Ave | 3 | 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 | ||
| 107591 | 117608 | DPW Maintained 1 | :: 45 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 06/29/2016 12:00:00 AM | 3 | 6005708.4 | 2111040.6 | 37.776837876057 | -122.423771533631 | (37.776837876057, -122.423771533631) | 7 | 9 | 11 | 28852 | 10 | |||
| 108170 | 221749 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 275 Grattan St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 24 | Width 4ft | 5997432.91763 | 2106413.5715 | 37.763662611962 | -122.452064861225 | (37.763662611962, -122.452064861225) | 15 | 5 | 11 | 29492 | 9 | |||
| 109923 | 254704 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 2 | 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 | |||
| 110859 | 109342 | DPW Maintained 1 | :: 45 | 3211 Baker St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 111419 | 104155 | DPW Maintained 1 | :: 45 | 525X Church St | 3 | 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 | |||
| 112455 | 109755 | DPW Maintained 1 | :: 45 | 601 Steiner St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
| 112534 | 253518 | DPW Maintained 1 | :: 45 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391 | 2112180 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | 11 | 6 | 2 | 55 | 26 | ||
| 112926 | 251642 | DPW Maintained 1 | Shrub :: Shrub 66 | 2253 Broderick St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 6000298.51737 | 2116393.24113 | 37.7912279703404 | -122.442870356286 | (37.7912279703404, -122.442870356286) | 13 | 6 | 1 | 29490 | 27 | ||||
| 113115 | 109351 | DPW Maintained 1 | Ficus Spp. :: 101 | 2505 Pacific Ave | 4 | 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 | ||
| 113384 | 98890 | Property Tree 8 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999134 | 2100748 | 37.7482036421854 | -122.44577389345 | (37.7482036421854, -122.44577389345) | 2 | 5 | 5 | 63 | 38 | ||||||
| 114033 | 173849 | DPW Maintained 1 | :: 45 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
| 114988 | 109756 | DPW Maintained 1 | :: 45 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
| 115102 | 254629 | Permitted Site 7 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 321 Page St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | 6x18 | Permit Number 782768 | 6005023.51354 | 2109862.79569 | 37.7735652261688 | -122.426056898155 | (37.7735652261688, -122.426056898155) | 7 | 9 | 11 | 28852 | 10 |
| 115221 | 120636 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 385 Nevada St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 6008960 | 2096519 | 37.7371478708762 | -122.411497024701 | (37.7371478708762, -122.411497024701) | 10 | 7 | 7 | 28859 | 2 | ||||
| 115286 | 100355 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 591 Waller St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.7706563827164 | -122.43333123962 | (37.7706563827164, -122.43333123962) | 15 | 5 | 5 | 29492 | 9 | ||
| 115447 | 85273 | DPW Maintained 1 | Tree(s) :: 17 | 36 Santa Cruz Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 5993017.1 | 2086630.8 | 37.709090137513 | -122.465900153218 | (37.709090137513, -122.465900153218) | 9 | 8 | 6 | 28861 | 25 | ||||||
| 118620 | 80937 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3124-3128 Laguna St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52345 | 6003823.24826281 | 2119450.20874415 | 37.7998219368855 | -122.430893152133 | (37.7998219368855, -122.430893152133) | 13 | 9 | 1 | 57 | 17 | ||
| 119847 | 89137 | DPW Maintained 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Curb 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 | ||||
| 120050 | 96291 | 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 | |||||
| 120956 | 99527 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 1 | 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 | ||||
| 123101 | 104856 | DPW Maintained 1 | :: 45 | 739 27th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.7461866004606 | -122.436767226643 | (37.7461866004606, -122.436767226643) | 2 | 7 | 5 | 63 | 22 | ||||
| 123221 | 109536 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 123223 | 82995 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1412 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52364 | 6016260.71862294 | 2093905.81391215 | 37.7303793871252 | -122.386072773391 | (37.7303793871252, -122.386072773391) | 10 | 3 | 8 | 58 | 1 | ||
| 123486 | 99732 | DPW Maintained 1 | Shrub :: Shrub 66 | 4150 Ocean Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 5986619.2 | 2095203.6 | 37.7322576937009 | -122.488641645288 | (37.7322576937009, -122.488641645288) | 1 | 8 | 4 | 64 | 35 | |||||
| 123690 | 98250 | DPW Maintained 1 | Tree(s) :: 17 | 650 Eddy St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | Sidewalk landscaping permit adjacent to building. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | 7 | 9 | 9 | 28858 | 36 | |||||
| 125528 | 253409 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.7759913538039 | -122.414931236288 | (37.7759913538039, -122.414931236288) | 8 | 2 | 9 | 28853 | 34 | |
| 125932 | 208471 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1175 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/23/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 780657 | 5991201.16474 | 2105172.16858 | 37.7598951180952 | -122.473527781682 | (37.7598951180952, -122.473527781682) | 1 | 8 | 4 | 56 | 12 | |
| 126121 | 119616 | DPW Maintained 1 | :: 45 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/28/2016 12:00:00 AM | 3 | 6005873.69691 | 2111410.56393 | 37.7778630368848 | -122.423226025705 | (37.7778630368848, -122.423226025705) | 7 | 9 | 11 | 28852 | 10 | |||
| 126618 | 89140 | 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 | ||||
| 127049 | 107717 | DPW Maintained 1 | Tree(s) :: 17 | 2400X 25th Ave | 3 | 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 |
| 127177 | 115258 | DPW Maintained 1 | :: 45 | 2150 Jackson St | : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003858 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | 13 | 9 | 1 | 29490 | 27 | ||||
| 127241 | 104634 | 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 | |||||
| 127804 | 109831 | DPW Maintained 1 | :: 45 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | 9 | 7 | 4 | 28861 | 40 | ||||
| 128684 | 106641 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 1323X CLAYTON ST | 1 | Back Yard : Yard | Landscaping | Private 2 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||||
| 128788 | 117679 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 7800 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 19 | Width 3ft | 5982700.57004 | 2112440.07286 | 37.7793547453385 | -122.503464893902 | (37.7793547453385, -122.503464893902) | 11 | 6 | 2 | 55 | 26 | |||
| 128970 | 106639 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 1321X CLAYTON ST | 1 | Back Yard : Yard | Landscaping | Private 2 | 5998910 | 2105100 | 37.7601403710114 | -122.446861587167 | (37.7601403710114, -122.446861587167) | 15 | 5 | 5 | 28862 | 12 | |||||
| 129391 | 93160 | DPW Maintained 1 | Tree(s) :: 17 | 201 Upper Ter | 1 | 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 | |||
| 129771 | 253008 | DPW Maintained 1 | :: 45 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | ||
| 129876 | 104375 | DPW Maintained 1 | Tree(s) :: 17 | 30 GARDENSIDE DR | 1 | Median : Yard | Landscaping | Private 2 | 50x50 | 5999465 | 2102094 | 37.7519183246276 | -122.444726043725 | (37.7519183246276, -122.444726043725) | 2 | 5 | 5 | 63 | 38 | ||||
| 130887 | 173851 | DPW Maintained 1 | :: 45 | 450 Toland St | 6 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 27.75x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
| 132009 | 253410 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.7759913538039 | -122.414931236288 | (37.7759913538039, -122.414931236288) | 8 | 2 | 9 | 28853 | 34 | |
| 133338 | 93163 | DPW Maintained 1 | Shrub :: Shrub 66 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 1x15 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 |
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) );