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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
227 | 102275 | Property Tree 8 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001225.6 | 2097744.2 | 37.7400751189117 | -122.438326054857 | (37.7400751189117, -122.438326054857) | 2 | 7 | 5 | 63 | 7 | ||||||
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 | ||||
1437 | 109607 | DPW Maintained 1 | Shrub :: Shrub 66 | 775 Congo St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.441114705419 | (37.7350943222142, -122.441114705419) | 9 | 7 | 4 | 63 | 40 | |||||
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 | ||||||||||||
2116 | 108701 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 478 30th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774626 | 6003507.49152 | 2098366.33094 | 37.7419128730633 | -122.43048058961 | (37.7419128730633, -122.43048058961) | 2 | 7 | 5 | 63 | 22 | |
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 | ||||||
2598 | 95032 | - 12 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout | Landscaping | Private 2 | 6004772 | 2093802 | 37.7294517978782 | -122.425783519869 | (37.7294517978782, -122.425783519869) | 9 | 7 | 6 | 28861 | 5 | ||||||
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 | |
2857 | 99536 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 4 | 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 | ||||
3309 | 120871 | DPW Maintained 1 | Shrub :: Shrub 66 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot | Landscaping | Private 2 | 5993606 | 2106068 | 37.7624938100726 | -122.465275766733 | (37.7624938100726, -122.465275766733) | 1 | 8 | 11 | 56 | 12 | |||||
3740 | 102276 | DPW Maintained 1 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.438398959733 | (37.7402178594385, -122.438398959733) | 2 | 7 | 5 | 63 | 7 | ||||||
4037 | 260562 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 10 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x15 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
4335 | 187271 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2401 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 5 | Width 0ft | 5984941.9801 | 2098338.6223 | 37.7407676103918 | -122.494671132674 | (37.7407676103918, -122.494671132674) | 1 | 8 | 3 | 29491 | 35 | |||
4821 | 243633 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 4757 25th St | 1 | Front Yard : Pot | Landscaping | Private 2 | 0 | Width 10ft | 6000099.67022 | 2101057.51685 | 37.749108590101 | -122.442456864219 | (37.749108590101, -122.442456864219) | 2 | 4 | 5 | 28862 | 22 | |||
4985 | 260550 | Private 9 | Private shrub :: Private Shrub 284 | 155 Graystone Ter | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 3x3 | 5999080 | 2104142 | 37.7575196509651 | -122.446204727568 | (37.7575196509651, -122.446204727568) | 2 | 5 | 5 | 28862 | 3 | ||||
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 | ||||
7435 | 239668 | Private 9 | Butia capitata :: Pindo Palm 313 | 180 Dolores St | 3 | Sidewalk: Property side : Pot | Landscaping | Private 2 | 23 | Width 4ft | 6004776.3298 | 2107329.36682 | 37.7665950691341 | -122.426731495165 | (37.7665950691341, -122.426731495165) | 8 | 4 | 5 | 28862 | 3 | |||
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 | ||
8171 | 260560 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 8 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x8 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
8329 | 262123 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 270 Lansdale Ave | 1 | Back Yard : Yard | Landscaping | Private 2 | 5995063 | 2096577 | 37.7365178315951 | -122.459549144168 | (37.7365178315951, -122.459549144168) | 9 | 7 | 4 | 59 | 40 | |||||
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 | ||||
11448 | 96234 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/15/2011 12:00:00 AM | Permit Number 767856 | |||||||||||||||
11972 | 99201 | DPW Maintained 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | FUF | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | 2 | 4 | 5 | 28862 | 22 | ||
12231 | 96231 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
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 | ||||
13072 | 260558 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 6 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x6 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
13953 | 116804 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 131 LAKESHORE DR | 1 | Median : Yard | Landscaping | DPW 1 | 10x100 | 5984782 | 2094243 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | 1 | 8 | 4 | 64 | 35 | ||||
14034 | 260614 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Farnsworth Ln | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | Width 6ft | 5996584.89502 | 2106441.40106 | 37.763690412698 | -122.454999901235 | (37.763690412698, -122.454999901235) | 15 | 5 | 11 | 29492 | 12 | ||||
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 | ||||
14896 | 260559 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 7 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x12 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
15191 | 96232 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
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 | ||||||||||||
16094 | 206192 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 105 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10 | Width 3ft | 5991391.3951 | 2104508.95832 | 37.7580851326494 | -122.472821514428 | (37.7580851326494, -122.472821514428) | 1 | 8 | 4 | 56 | 12 | |||
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 | ||||
17612 | 262236 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 3540 Rivera St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 5982153 | 2100195 | 37.7457010726591 | -122.504451707081 | (37.7457010726591, -122.504451707081) | 1 | 8 | 3 | 29491 | 35 | ||||
18080 | 260563 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 11 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x10 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
18190 | 261630 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 15 Noe St | 1 | Sidewalk: Curb side : Pot | Landscaping | Private 2 | 3x3 | 6002878 | 2108185 | 37.7688369185992 | -122.433358627279 | (37.7688369185992, -122.433358627279) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | |||
18566 | 256863 | Section 806 (d) 5 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 274 Victoria St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/19/2018 12:00:00 AM | 3 | 3x8 | Permit Number 781692 | 5993256.27541 | 2089011.86791 | 37.7156417766237 | -122.465246370223 | (37.7156417766237, -122.465246370223) | 9 | 8 | 6 | 64 | 24 | |
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 | |||
18729 | 99529 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 3 | 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 | ||||
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 | |
19343 | 260561 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 9 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x7 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
19564 | 264882 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 2801 Lawton St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 3x3 | 5985570 | 2104278 | 37.7571122644181 | -122.49293709397 | (37.7571122644181, -122.49293709397) | 1 | 8 | 3 | 56 | 35 | ||||
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 | ||
22629 | 106932 | DPW Maintained 1 | Shrub :: Shrub 66 | 358 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 8x10 | 6007793.2 | 2105846.4 | 37.7626932925098 | -122.416191600332 | (37.7626932925098, -122.416191600332) | 8 | 4 | 7 | 28859 | 19 | ||||
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 | |||||
24293 | 94928 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 929#4 Broderick St | Sidewalk: Curb side : | Landscaping | Private 2 | 12/08/2010 12:00:00 AM | 3 | 26x6 | Permit Number 54775 | 6000937 | 2111843 | 37.7787705583514 | -122.440334763546 | (37.7787705583514, -122.440334763546) | 15 | 5 | 11 | 29490 | 41 | ||
25702 | 89015 | DPW Maintained 1 | Shrub :: Shrub 66 | 4437 20th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 09/30/2008 12:00:00 AM | 3x1 | Permit Number 51764 | 6001659 | 2104076 | 37.7574853780776 | -122.437280798466 | (37.7574853780776, -122.437280798466) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||
29040 | 89138 | 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 | ||||
29758 | 92776 | 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 | ||||
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 | ||
32024 | 109349 | DPW Maintained 1 | Ficus Spp. :: 101 | 2505 Pacific Ave | 2 | 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 | ||
33160 | 20136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 890 Steiner St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54087 | 6003007 | 2111306 | 37.777413731872 | -122.433135450293 | (37.777413731872, -122.433135450293) | 15 | 9 | 11 | 29492 | 10 | |
33206 | 245474 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | 15 | 5 | 11 | 29492 | 9 | |||
33621 | 105147 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 52 Mirabel Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/26/2013 12:00:00 AM | 3X3 | Permit Number 771012 | 6007663.7 | 2099931.8 | 37.7464458666696 | -122.416220575031 | (37.7464458666696, -122.416220575031) | 2 | 7 | 7 | 28859 | 2 | |||
34209 | 107409 | DPW Maintained 1 | Shrub :: Shrub 66 | 125 VILLA TER | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5999028.2 | 2104385.8 | 37.7581861070008 | -122.446401410764 | (37.7581861070008, -122.446401410764) | 2 | 5 | 5 | 28862 | 3 | |||||
35821 | 93164 | DPW Maintained 1 | Shrub :: Shrub 66 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 1x2 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 | |||
36468 | 140265 | DPW Maintained 1 | Shrub :: Shrub 66 | 2100X Grove St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 0 | Width 0ft | 5997671.17 | 2110272.3417 | 37.7742714515841 | -122.45151917218 | (37.7742714515841, -122.45151917218) | 15 | 5 | 2 | 29492 | 16 | |||
39983 | 83339 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2233 28th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52332 | 5987590.2167451 | 2100087.03718588 | 37.7457229434205 | -122.485642930331 | (37.7457229434205, -122.485642930331) | 1 | 8 | 3 | 29491 | 35 | ||
43687 | 117610 | DPW Maintained 1 | Shrub :: Shrub 66 | 391 NEVADA ST | 1 | Unaccepted Street : Yard | Landscaping | Private 2 | 3x3 | 6008958 | 2096497 | 37.7370873514658 | -122.411502385785 | (37.7370873514658, -122.411502385785) | 10 | 7 | 7 | 28859 | 2 | ||||
44398 | 110615 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/31/2015 12:00:00 AM | 3 | 13.2x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
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 | |
45129 | 98465 | Property Tree 8 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard | Landscaping | Private 2 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | 2 | 5 | 5 | 63 | 38 | ||||||
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 | ||
47855 | 93115 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 397 San Jose Ave | 1 | Sidewalk: Curb side : | Landscaping | Private 2 | 02/02/2009 12:00:00 AM | 26x6 | Permit Number 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | 2 | 4 | 5 | 28859 | 19 | ||
48163 | 82751 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 52 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52446 | 6009256.89976445 | 2109417.42292722 | 37.772580689338 | -122.41138145626 | (37.772580689338, -122.41138145626) | 8 | 2 | 9 | 28853 | 34 | |
49164 | 17450 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 1967 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | 42 | 3X3 | 6012966.10245 | 2096645.10936 | 37.7377180333685 | -122.397654855789 | (37.7377180333685, -122.397654855789) | 10 | 3 | 8 | 58 | 1 | |||
50373 | 95369 | - 12 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout | Landscaping | Private 2 | 02/18/2011 12:00:00 AM | 6002651 | 2105744 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | 15 | 4 | 5 | 28862 | 3 | |||||
51851 | 227519 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 375 Alabama St | 1 | : | Landscaping | Private 2 | 8 | Width 3ft | 6008967.54586 | 2106408.18704 | 37.7643017925286 | -122.412169648322 | (37.7643017925286, -122.412169648322) | 8 | 4 | 7 | 28859 | 19 | |||
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 | ||
54211 | 98502 | Property Tree 8 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999066 | 2100737 | 37.7481695560511 | -122.446008243376 | (37.7481695560511, -122.446008243376) | 2 | 5 | 5 | 63 | 38 | ||||||
54600 | 82096 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.8027979755173 | -122.427578771479 | (37.8027979755173, -122.427578771479) | 13 | 9 | 1 | 57 | 17 | ||
54811 | 109348 | DPW Maintained 1 | Ficus Spp. :: 101 | 2505 Pacific Ave | 1 | 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 | ||
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 | ||
55462 | 94961 | DPW Maintained 1 | Tree(s) :: 17 | 3098 PACIFIC AVE | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/25/2010 12:00:00 AM | 5999362 | 2116697 | 37.792008575714 | -122.446132526841 | (37.792008575714, -122.446132526841) | 13 | 6 | 1 | 29490 | 27 | ||||
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 | ||
56335 | 104565 | 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 | |||||
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 | |||
58243 | 109770 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 9 Pomona St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/29/2015 12:00:00 AM | 6x7 | Permit Number 774437 | 6014227.8 | 2094671.9 | 37.7323701819213 | -122.393154495945 | (37.7323701819213, -122.393154495945) | 10 | 3 | 8 | 58 | 1 | ||
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 |
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) );