trees
2,694 rows where qSpecies_id = 84 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
884 | 261406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
3071 | 31851 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
4023 | 31850 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
4740 | 119761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
4940 | 39332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
5244 | 261407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
6169 | 39333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
11366 | 53918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
12262 | 261408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
339 | 18096 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3008 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/1997 12:00:00 AM | 6 | 3X3 | 5999424.6928 | 2114682.6521 | 37.7864812852303 | -122.445770680231 | (37.7864812852303, -122.445770680231) | 15 | 6 | 1 | 29490 | 31 | ||
1818 | 38898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 127 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 1 | Permit Number 40712 | 5996846.0934 | 2113584.1977 | 37.7833176557587 | -122.454612555673 | (37.7833176557587, -122.454612555673) | 11 | 6 | 1 | 54 | 31 | |
3715 | 137933 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 23 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003135 | 2115313 | 37.788423206128 | -122.432979003927 | (37.788423206128, -122.432979003927) | 13 | 9 | 1 | 29490 | 27 | |||
8548 | 138687 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2828 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999933.5509 | 2114410.1103 | 37.7857619969761 | -122.443990574135 | (37.7857619969761, -122.443990574135) | 15 | 6 | 1 | 29490 | 31 | |||
9198 | 44212 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2009 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2001 12:00:00 AM | 2 | Permit Number 43659 | 6003842.4279 | 2115438.8041 | 37.7888087328674 | -122.430540396598 | (37.7888087328674, -122.430540396598) | 13 | 9 | 1 | 29490 | 27 | |
11005 | 49212 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1901 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2003 12:00:00 AM | 5 | Permit Number 46298 | 6001466.4689 | 2115088.0238 | 37.7877106976566 | -122.438735717029 | (37.7877106976566, -122.438735717029) | 13 | 6 | 1 | 29490 | 27 | |
12308 | 61076 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2611 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1983 12:00:00 AM | 1 | Permit Number 20913 | 5999537.3607 | 2113600.286 | 37.7835158217397 | -122.445303028393 | (37.7835158217397, -122.445303028393) | 15 | 6 | 1 | 29490 | 31 | |
20346 | 141250 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 42 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996544.0519 | 2114280.1621 | 37.7852112604093 | -122.455707816901 | (37.7852112604093, -122.455707816901) | 11 | 6 | 1 | 54 | 31 | |||
24348 | 41338 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 176 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.0232 | 2113139.8498 | 37.7820642497954 | -122.456590671642 | (37.7820642497954, -122.456590671642) | 11 | 6 | 1 | 54 | 31 | ||
25617 | 135906 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007265.47268 | 2119876.05587 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | 5 | 1 | 1 | 28858 | 32 | |||
26690 | 68135 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1640 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2011 12:00:00 AM | 1 | Permit Number 767463 | 6000632.1236 | 2114329.1398 | 37.7855794974585 | -122.441567904047 | (37.7855794974585, -122.441567904047) | 15 | 6 | 1 | 29490 | 27 | ||
26778 | 138244 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2760 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999379.987 | 2113979.7781 | 37.7845488238542 | -122.445874780745 | (37.7845488238542, -122.445874780745) | 15 | 6 | 1 | 29490 | 31 | |||
31260 | 52535 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3148GREENWICH Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2006 12:00:00 AM | Permit Number 48634 | 6001945.28510554 | 2118977.8518821 | 37.7984183853373 | -122.437357750068 | (37.7984183853373, -122.437357750068) | 13 | 9 | 1 | 57 | 17 | |||
40316 | 93176 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651 | 2115280 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | 11 | 6 | 1 | 54 | 31 | ||
41552 | 140842 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5996517.655 | 2113507.2067 | 37.783087415663 | -122.455743248453 | (37.783087415663, -122.455743248453) | 11 | 6 | 1 | 54 | 31 | |||
41559 | 135907 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007940.29606 | 2119623.01107 | 37.80052881831 | -122.416658842755 | (37.80052881831, -122.416658842755) | 5 | 1 | 1 | 308 | 32 | |||
41827 | 143115 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1635 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6004533.1119 | 2119761.6458 | 37.8007172577851 | -122.428458969748 | (37.8007172577851, -122.428458969748) | 13 | 9 | 1 | 57 | 17 | |||
53051 | 48847 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 211@ Lake St 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | Permit Number 46061 | 5987400.97577089 | 2114545.21286522 | 37.7854100709912 | -122.487359105809 | (37.7854100709912, -122.487359105809) | 11 | 6 | 1 | 55 | 33 | |||
54636 | 108099 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2390X Green St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | ||
55731 | 36180 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 97 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | Permit Number 39250 | 5996187.56440634 | 2113855.50691306 | 37.7840248062044 | -122.456910420622 | (37.7840248062044, -122.456910420622) | 11 | 6 | 1 | 54 | 31 | ||
56550 | 49210 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1901 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | 4 | Permit Number 46298 | 6001469.3091 | 2115060.1894 | 37.7876344331375 | -122.43872389522 | (37.7876344331375, -122.43872389522) | 13 | 6 | 1 | 29490 | 27 | ||
58157 | 93178 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 290 Maple St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651 | 2115280 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | 11 | 6 | 1 | 54 | 31 | ||
60519 | 104961 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 125 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2013 12:00:00 AM | 10 | Permit Number 770811 | 5996496.5 | 2113597.6 | 37.7833343975689 | -122.455822972198 | (37.7833343975689, -122.455822972198) | 11 | 6 | 1 | 54 | 31 | ||
65795 | 31652 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2066 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1995 12:00:00 AM | Permit Number 35162 | 6001931.34452098 | 2119821.7914856 | 37.8007348293225 | -122.437466455186 | (37.8007348293225, -122.437466455186) | 13 | 9 | 1 | 57 | 17 | |||
66396 | 138797 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1823 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000490.7856 | 2114966.8512 | 37.7873224344393 | -122.442102683059 | (37.7873224344393, -122.442102683059) | 13 | 6 | 1 | 29490 | 27 | |||
69267 | 135892 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6001823.0897 | 2121828.59544 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | 13 | 9 | 1 | 57 | 17 | |||
69522 | 93177 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 290 Maple St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651 | 2115280 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | 11 | 6 | 1 | 54 | 31 | ||
73938 | 135905 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2843 Larkin St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6006460.32075 | 2121020.93031 | 37.8042838008308 | -122.421879520521 | (37.8042838008308, -122.421879520521) | 5 | 9 | 1 | 28858 | 32 | |||
78657 | 44057 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 708 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | 7 | Permit Number 43584 | 6007279.94096 | 2121616.88851 | 37.8059663388498 | -122.419085450154 | (37.8059663388498, -122.419085450154) | 5 | 1 | 1 | 28858 | 32 | ||
80447 | 93179 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651 | 2115280 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | 11 | 6 | 1 | 54 | 31 | ||
85842 | 46075 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 126 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2001 12:00:00 AM | 4 | Permit Number 44456 | 5996572.8178 | 2113519.7283 | 37.7831249622244 | -122.455553314082 | (37.7831249622244, -122.455553314082) | 11 | 6 | 1 | 54 | 31 | ||
86475 | 141238 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 31 PARKER AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996802.437 | 2114389.98 | 37.7855276158827 | -122.454821826496 | (37.7855276158827, -122.454821826496) | 11 | 6 | 1 | 54 | 31 | |||
87497 | 48417 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2483 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | Permit Number 45795 | 6001088.95867007 | 2118610.64400879 | 37.7973614105806 | -122.440294547032 | (37.7973614105806, -122.440294547032) | 13 | 9 | 1 | 57 | 17 | ||
88513 | 104081 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2610 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | 11 | 6 | 1 | 55 | 33 | |||||
91713 | 140802 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 82 JORDAN AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5996233.7192 | 2113991.8267 | 37.7844017542187 | -122.456760605162 | (37.7844017542187, -122.456760605162) | 11 | 6 | 1 | 54 | 31 | |||
93485 | 50751 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 159 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2004 12:00:00 AM | Permit Number 47292 | 5996528.05046834 | 2113286.09690266 | 37.7824809034135 | -122.455691296828 | (37.7824809034135, -122.455691296828) | 11 | 6 | 1 | 54 | 31 | |||
96980 | 140966 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 159 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996524.4235 | 2113288.9246 | 37.782488459378 | -122.455704048946 | (37.782488459378, -122.455704048946) | 11 | 6 | 1 | 54 | 31 | |||
101029 | 108939 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774694 | 6004341.9 | 2118349.2 | 37.7968282226561 | -122.429019881342 | (37.7968282226561, -122.429019881342) | 13 | 9 | 1 | 57 | 17 |
103229 | 48416 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2483 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | Permit Number 45795 | 6001088.95867007 | 2118610.64400879 | 37.7973614105806 | -122.440294547032 | (37.7973614105806, -122.440294547032) | 13 | 9 | 1 | 57 | 17 | ||
104206 | 18098 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3016 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 11:58:00 AM | 3 | 5999364.6601 | 2114676.4418 | 37.7864608055495 | -122.445977930803 | (37.7864608055495, -122.445977930803) | 15 | 6 | 1 | 29490 | 31 | |||
104764 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 3524 Jackson St | 2 | Front Yard : Cutout | Tree | Private 2 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||||
106638 | 138796 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1821 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000490.0431 | 2114976.5028 | 37.7873488929161 | -122.442105945015 | (37.7873488929161, -122.442105945015) | 13 | 6 | 1 | 29490 | 27 | |||
112489 | 249683 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 15 | Front Yard : Yard | Tree | Private 2 | 5 | 5999743.16478 | 2117253.42108 | 37.7935581209611 | -122.444853713047 | (37.7935581209611, -122.444853713047) | 13 | 9 | 1 | 57 | 27 | ||||
112566 | 23490 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2500X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6005777.87956 | 2119177.13076 | 37.7991826887835 | -122.424109961515 | (37.7991826887835, -122.424109961515) | 13 | 9 | 1 | 28858 | 32 | |||
115492 | 256141 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1560 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 10/16/1972 12:00:00 AM | Permit Number 11222 | 6005424.25713 | 2119606.92915 | 37.8003428333403 | -122.425364219431 | (37.8003428333403, -122.425364219431) | 13 | 9 | 1 | 57 | 17 | ||
115943 | 51854 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 19 Emerson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2005 12:00:00 AM | 3 | Permit Number 48078 | 5998665.3644 | 2113591.8967 | 37.7834429726209 | -122.448319180732 | (37.7834429726209, -122.448319180732) | 15 | 6 | 1 | 54 | 31 | ||
118423 | 114730 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2536 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780830 | 6002593.47602 | 2116148.5251 | 37.7906866135575 | -122.434912365239 | (37.7906866135575, -122.434912365239) | 13 | 9 | 1 | 29490 | 27 | |
119264 | 106857 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2800 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001545 | 2118180 | 37.7962049292866 | -122.438685656109 | (37.7962049292866, -122.438685656109) | 13 | 9 | 1 | 57 | 17 | ||
120294 | 138798 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1827 Broderick St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000492.2704 | 2114959.4269 | 37.7873021338531 | -122.442097012851 | (37.7873021338531, -122.442097012851) | 13 | 6 | 1 | 29490 | 27 | |||
122246 | 135891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2398 North Point St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.8024605098936 | -122.446592451473 | (37.8024605098936, -122.446592451473) | 13 | 9 | 1 | 57 | 17 | |||
123823 | 33331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1771 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/2005 12:00:00 AM | Permit Number 37471 | 6004431.94596599 | 2119422.40230613 | 37.7997800572789 | -122.428784847863 | (37.7997800572789, -122.428784847863) | 13 | 9 | 1 | 57 | 17 | ||
126865 | 30894 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 1 | Permit Number 34721 | 5996515.6245 | 2113531.2346 | 37.7831532733672 | -122.45575201055 | (37.7831532733672, -122.45575201055) | 11 | 6 | 1 | 54 | 31 | ||
129201 | 49209 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1901 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | 4 | Permit Number 46298 | 6001476.6938 | 2115031.787 | 37.7875568675655 | -122.438696309687 | (37.7875568675655, -122.438696309687) | 13 | 6 | 1 | 29490 | 27 | ||
129376 | 135893 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6001843.59752 | 2121830.48703 | 37.8062451862265 | -122.437914052191 | (37.8062451862265, -122.437914052191) | 13 | 9 | 1 | 57 | 17 | ||||
132643 | 138799 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1827 Broderick St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000493.7553 | 2114952.745 | 37.7872838717102 | -122.44209139561 | (37.7872838717102, -122.44209139561) | 13 | 6 | 1 | 29490 | 27 | |||
133905 | 36161 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 59 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 2 | Permit Number 39242 | 5997481.3111 | 2113388.5898 | 37.7828169808275 | -122.452400845607 | (37.7828169808275, -122.452400845607) | 15 | 6 | 1 | 54 | 31 | |
136417 | 94722 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 172 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53857 | 5998128.6274 | 2113392.2279 | 37.7828640340497 | -122.450161675731 | (37.7828640340497, -122.450161675731) | 15 | 6 | 1 | 54 | 31 |
136690 | 50963 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 120 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2004 12:00:00 AM | 2 | Permit Number 47459 | 5996572.8178 | 2113583.69 | 37.7833005840711 | -122.455557938638 | (37.7833005840711, -122.455557938638) | 11 | 6 | 1 | 54 | 31 | ||
138461 | 49798 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 314AY REVISED Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2006 12:00:00 AM | Permit Number 46590 | 5997636.49453559 | 2115383.50122102 | 37.7883033693994 | -122.452007952375 | (37.7883033693994, -122.452007952375) | 11 | 6 | 1 | 54 | 31 | |||
138983 | 46074 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 126 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2010 12:00:00 AM | 4 | Permit Number 53303 | 5996573.1562 | 2113506.5298 | 37.7830887420653 | -122.455551189088 | (37.7830887420653, -122.455551189088) | 11 | 6 | 1 | 54 | 31 | ||
141889 | 140965 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 72 COOK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997532.582 | 2113283.8483 | 37.7825323254485 | -122.452215910684 | (37.7825323254485, -122.452215910684) | 15 | 6 | 1 | 54 | 31 | |||
145606 | 45712 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2276 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2001 12:00:00 AM | Permit Number 44382 | 6000967.59952761 | 2119687.6743116 | 37.8003117407877 | -122.440791778151 | (37.8003117407877, -122.440791778151) | 13 | 9 | 1 | 57 | 17 | |||
152721 | 143340 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1796 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004433.9519 | 2118779.1956 | 37.798014090515 | -122.42873202906 | (37.798014090515, -122.42873202906) | 13 | 9 | 1 | 57 | 17 | |||
154113 | 36163 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 70 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | Permit Number 39244 | 5997546.61161576 | 2113239.64875876 | 37.7824117688158 | -122.452164184395 | (37.7824117688158, -122.452164184395) | 15 | 6 | 1 | 54 | 31 | ||
155555 | 249682 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 5999744.12671 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | 13 | 9 | 1 | 57 | 27 | ||||
157205 | 36164 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 78 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 3 | Permit Number 39245 | 5997542.7347 | 2113210.4108 | 37.7823312669858 | -122.452175486469 | (37.7823312669858, -122.452175486469) | 15 | 6 | 1 | 54 | 31 | |
164734 | 106722 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2905 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5999550.4676 | 2114295.9601 | 37.7854267102234 | -122.445307719005 | (37.7854267102234, -122.445307719005) | 15 | 6 | 1 | 29490 | 31 | |||
166152 | 41337 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 176 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.7 | 2113122.5903 | 37.7820168986492 | -122.456587081702 | (37.7820168986492, -122.456587081702) | 11 | 6 | 1 | 54 | 31 | ||
169380 | 36162 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 66 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 5 | Permit Number 39243 | 5997531.2283 | 2113294.3394 | 37.7825610537015 | -122.452221351103 | (37.7825610537015, -122.452221351103) | 15 | 6 | 1 | 54 | 31 | |
170021 | 53179 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2610@ 27th Ave Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51476 | 5987391.86463584 | 2114656.62979524 | 37.7857154586457 | -122.487398814258 | (37.7857154586457, -122.487398814258) | 11 | 6 | 1 | 55 | 33 | ||
171801 | 49211 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1901 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | 4 | Permit Number 46298 | 6001478.3979 | 2115000.5443 | 37.7874711800947 | -122.438688174294 | (37.7874711800947, -122.438688174294) | 13 | 6 | 1 | 29490 | 27 | ||
177825 | 138813 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1605 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000066.1969 | 2114526.3397 | 37.7860886985052 | -122.443540010204 | (37.7860886985052, -122.443540010204) | 15 | 6 | 1 | 29490 | 31 | |||
178374 | 49799 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 314AY REVISED Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2006 12:00:00 AM | Permit Number 46590 | 5997636.49453559 | 2115383.50122102 | 37.7883033693994 | -122.452007952375 | (37.7883033693994, -122.452007952375) | 11 | 6 | 1 | 54 | 31 | |||
179367 | 137853 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1955 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003344.2833 | 2115489.023 | 37.7889183890757 | -122.432267493573 | (37.7889183890757, -122.432267493573) | 13 | 9 | 1 | 29490 | 27 | |||
181361 | 36181 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 97 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1998 12:00:00 AM | Permit Number 39250 | 5996187.56440634 | 2113855.50691306 | 37.7840248062044 | -122.456910420622 | (37.7840248062044, -122.456910420622) | 11 | 6 | 1 | 54 | 31 | |||
182032 | 13118 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1633 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004565.4050748 | 2119750.0667864 | 37.8006872921539 | -122.428346396238 | (37.8006872921539, -122.428346396238) | 13 | 9 | 1 | 57 | 17 | |||
182125 | 50964 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 120 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2004 12:00:00 AM | 4 | Permit Number 47459 | 5996570.7873 | 2113602.9801 | 37.783353433046 | -122.455566358041 | (37.783353433046, -122.455566358041) | 11 | 6 | 1 | 54 | 31 | ||
184830 | 135937 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 98 Spruce St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780098 | 5997052.02369 | 2116054.59656 | 37.7901125223289 | -122.454078602473 | (37.7901125223289, -122.454078602473) | 11 | 6 | 1 | 54 | 31 |
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) );