trees
1,914 rows where qSpecies_id = 45 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
| 179 | 113995 | DPW Maintained 1 | :: 45 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692457 | -122.446411428366 | (37.789931692457, -122.446411428366) | 13 | 6 | 1 | 29490 | 31 | |||
| 388 | 109369 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
| 391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 532 | 261313 | Permitted Site 7 | :: 45 | 2700 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x40 | 6000687.88763 | 2117206.96839 | 37.7934844433083 | -122.441581569821 | (37.7934844433083, -122.441581569821) | 13 | 9 | 1 | 57 | 27 | ||
| 1416 | 109762 | DPW Maintained 1 | :: 45 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 | ||||
| 2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
| 2338 | 260969 | Permitted Site 7 | :: 45 | 897 37th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 11/05/2019 12:00:00 AM | 3 | 10X27 | 5984476.51719 | 2109749.52706 | 37.7720715265353 | -122.497122586729 | (37.7720715265353, -122.497122586729) | 11 | 6 | 2 | 55 | 26 | ||
| 2548 | 104858 | DPW Maintained 1 | :: 45 | 4205 24th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6001816 | 2101720.7 | 37.7510272133613 | -122.436569249202 | (37.7510272133613, -122.436569249202) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 2737 | 258983 | Permitted Site 7 | :: 45 | 1355 27th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/03/2019 12:00:00 AM | 3 | 5.5x17 | Permit Number 782298 | 5987701.73439 | 2106071.48854 | 37.7621611287816 | -122.48569645736 | (37.7621611287816, -122.48569645736) | 1 | 8 | 3 | 56 | 35 | |
| 5098 | 251531 | DPW Maintained 1 | :: 45 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
| 6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
| 7664 | 261543 | Permitted Site 7 | :: 45 | 1305 Lombard St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 20x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
| 8663 | 258698 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
| 8883 | 261542 | Permitted Site 7 | :: 45 | 1305 Lombard St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 10x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
| 8983 | 258699 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
| 10197 | 251293 | DPW Maintained 1 | :: 45 | 3789 Market St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 6000208 | 2102740 | 37.753734455764 | -122.442203020617 | (37.753734455764, -122.442203020617) | 2 | 4 | 5 | 63 | 38 | ||||
| 12982 | 258981 | Permitted Site 7 | :: 45 | 480 Warren Dr | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/03/2019 12:00:00 AM | 3 | 11x8 | Permit Number 782233 | 5994337.77577 | 2104623.93258 | 37.7585709481755 | -122.462640083314 | (37.7585709481755, -122.462640083314) | 1 | 5 | 4 | 63 | 12 | |
| 12997 | 258944 | DPW Maintained 1 | :: 45 | 190 Freelon St | 1 | Sidewalk: Curb side : Yard | Landscaping | DPW 1 | Width 2ft | 6013228 | 2111376 | 37.7781804260272 | -122.397782321929 | (37.7781804260272, -122.397782321929) | 6 | 2 | 9 | 28856 | 34 | ||||
| 14351 | 109754 | Permitted Site 7 | :: 45 | 601 Steiner St | 1 | 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 | ||||
| 15400 | 112605 | DPW Maintained 1 | :: 45 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/10/2015 12:00:00 AM | 5.6x12 | 6000465 | 2110329.2 | 37.7745871625182 | -122.441858914128 | (37.7745871625182, -122.441858914128) | 15 | 5 | 11 | 29492 | 16 | |||
| 15760 | 251532 | DPW Maintained 1 | :: 45 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
| 16139 | 253515 | DPW Maintained 1 | :: 45 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391 | 2112180 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | 11 | 6 | 2 | 55 | 26 | ||
| 17437 | 105043 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 5 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x4 | 6008902 | 2102968 | 37.7548521445958 | -122.412153203197 | (37.7548521445958, -122.412153203197) | 2 | 4 | 7 | 28859 | 19 | ||||
| 18457 | 107144 | DPW Maintained 1 | :: 45 | 360 Spear St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 02/12/2020 12:00:00 AM | 3 | 6015708 | 2115219 | 37.7888702311939 | -122.38947147438 | (37.7888702311939, -122.38947147438) | 6 | 2 | 9 | 28855 | 6 | |||
| 18687 | 104158 | DPW Maintained 1 | :: 45 | 525X Church St | 6 | 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 | |||
| 18926 | 258980 | Permitted Site 7 | :: 45 | 480 Warren Dr | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/03/2019 12:00:00 AM | 3 | 16x8 | Permit Number 782233 | 5994337.77577 | 2104623.93258 | 37.7585709481755 | -122.462640083314 | (37.7585709481755, -122.462640083314) | 1 | 5 | 4 | 63 | 12 | |
| 22031 | 254088 | DPW Maintained 1 | :: 45 | 2520 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 3.5x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 22093 | 254089 | DPW Maintained 1 | :: 45 | 2520 Broadway | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 5x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 23775 | 108576 | Property Tree 8 | :: 45 | 2479 Diamond St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6002240 | 2097369 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | 2 | 7 | 5 | 63 | 7 | |||||
| 26240 | 115259 | DPW Maintained 1 | :: 45 | 2130 Jackson St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003918.8 | 2117004 | 37.7931106894063 | -122.430387878845 | (37.7931106894063, -122.430387878845) | 13 | 9 | 1 | 29490 | 27 | ||||
| 31577 | 104151 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 31704 | 111759 | DPW Maintained 1 | :: 45 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard | Landscaping | Private 2 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.507284463143 | (37.7634442160317, -122.507284463143) | 1 | 8 | 3 | 56 | 35 | ||
| 45114 | 109367 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 46090 | 173847 | DPW Maintained 1 | :: 45 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
| 46407 | 173850 | DPW Maintained 1 | :: 45 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
| 47766 | 253517 | DPW Maintained 1 | :: 45 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391 | 2112180 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | 11 | 6 | 2 | 55 | 26 | ||
| 52669 | 254715 | Permitted Site 7 | :: 45 | 636 Vermont St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 5x5.5 | 6011227.55095 | 2105388.49702 | 37.7616285037909 | -122.404281111091 | (37.7616285037909, -122.404281111091) | 10 | 3 | 8 | 28856 | 29 | ||
| 53078 | 255962 | Permitted Site 7 | :: 45 | 2518 Buchanan St | 2 | 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 | ||
| 54959 | 258601 | Private 9 | :: 45 | 682 12th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 05/29/2019 12:00:00 AM | 3 | 9X2 | 5992266.47414 | 2110804.58144 | 37.7754218561197 | -122.470253595146 | (37.7754218561197, -122.470253595146) | 11 | 6 | 2 | 54 | 11 | ||
| 55781 | 110246 | DPW Maintained 1 | :: 45 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.7554848751362 | -122.486075162345 | (37.7554848751362, -122.486075162345) | 1 | 8 | 3 | 56 | 35 | ||
| 57021 | 255180 | Permitted Site 7 | :: 45 | 619 06th Ave | 1 | Sidewalk: Property 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 | |||
| 59373 | 109769 | DPW Maintained 1 | :: 45 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.7862856185892 | -122.439227543381 | (37.7862856185892, -122.439227543381) | 13 | 6 | 1 | 29490 | 27 | ||||
| 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 | |||
| 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 | |
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||||||
| 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 | ||||||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||||
| 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 | ||||
| 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 | ||
| 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 | |||||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 |
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) );