trees
2,306 rows where qSpecies_id = 15 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
120537 | 250021 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1 Peter Yorke Way | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6005906.53716 | 2114478.71267 | 37.7862892740647 | -122.423330582061 | (37.7862892740647, -122.423330582061) | 13 | 9 | 1 | 28858 | 41 | ||||
122551 | 250651 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 142 El Camino Del Mar | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 4ft | 5988051.29763 | 2115371.58762 | 37.7877169631183 | -122.485169869815 | (37.7877169631183, -122.485169869815) | 11 | 6 | 1 | 55 | 33 | |||
128076 | 249720 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2500 Broderick St | 4 | Front Yard : Yard | Tree | Private 2 | 21 | 6000174.44289 | 2117385.9513 | 37.7939466172975 | -122.44337098458 | (37.7939466172975, -122.44337098458) | 13 | 9 | 1 | 57 | 27 | ||||
138186 | 1 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 10 10th Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.468982710496 | (37.7866097734767, -122.468982710496) | 11 | 6 | 1 | 54 | 11 | |||
139808 | 250139 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2550x Lyon St | 7 | Median : Yard | Tree | DPW 1 | 11 | 5999209.46456 | 2117608.80739 | 37.794503445131 | -122.446725934276 | (37.794503445131, -122.446725934276) | 13 | 1 | 57 | 30 | |||||
141789 | 23558 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2900X Van Ness Ave | 7 | Median : Cutout | Tree | DPW 1 | 30 | 9x200 | 6005648.5023441 | 2120304.1415398 | 37.8022698669467 | -122.424637865654 | (37.8022698669467, -122.424637865654) | 5 | 9 | 1 | 28858 | 32 | |||
151843 | 249688 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Baker St | 20 | Front Yard : Yard | Tree | Private 2 | 2 | 5999721.26309 | 2117323.67218 | 37.7937497619854 | -122.444934546805 | (37.7937497619854, -122.444934546805) | 13 | 9 | 1 | 57 | 27 | ||||
151937 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
157534 | 249719 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2500 Broderick St | 3 | Front Yard : Yard | Tree | Private 2 | 17 | 6000168.76533 | 2117405.83622 | 37.7940008922814 | -122.44339205842 | (37.7940008922814, -122.44339205842) | 13 | 9 | 1 | 57 | 27 | ||||
157788 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
163986 | 121133 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x10 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | |||
165293 | 132200 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1151 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6006710.22294 | 2120090.22803 | 37.801742419238 | -122.420948592699 | (37.801742419238, -122.420948592699) | 5 | 1 | 1 | 28858 | 32 | ||||
165494 | 132199 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2836 Larkin St | 14 | Side Yard : Yard | Tree | Private 2 | 17 | 6006498.02761 | 2121046.57665 | 37.8043563455331 | -122.42175085544 | (37.8043563455331, -122.42175085544) | 5 | 9 | 1 | 28858 | 32 | ||||
166062 | 115436 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1 PETER YORKE WAY | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6005775 | 2114336 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | 13 | 9 | 1 | 28858 | 41 | ||||
168621 | 106903 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 20X MAYFAIR DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5998146 | 2114573 | 37.7861071180483 | -122.450186711437 | (37.7861071180483, -122.450186711437) | 11 | 6 | 1 | 54 | 31 | ||||
172756 | 132198 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2836 Larkin St | 13 | Side Yard : Yard | Tree | Private 2 | 24 | 6006512.51972 | 2121038.28328 | 37.8043343912759 | -122.421700114783 | (37.8043343912759, -122.421700114783) | 5 | 9 | 1 | 28858 | 32 | ||||
182174 | 115437 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1 PETER YORKE WAY | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6005775 | 2114336 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | 13 | 9 | 1 | 28858 | 41 | ||||
184664 | 249698 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Baker St | 30 | Front Yard : Yard | Tree | Private 2 | 23 | 5999693.94716 | 2117283.58349 | 37.7936381300369 | -122.445026178739 | (37.7936381300369, -122.445026178739) | 13 | 9 | 1 | 57 | 27 | ||||
193693 | 255496 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2100 Turk Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 5999950 | 2111978 | 37.7790849877594 | -122.443758873408 | (37.7790849877594, -122.443758873408) | 15 | 5 | 1 | 29490 | 16 | |||||
14690 | 132193 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6008345.5033 | 2117049.6207 | 37.7934857075452 | -122.415074404558 | (37.7934857075452, -122.415074404558) | 5 | 1 | 10 | 28858 | 21 | |||
16781 | 260951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 190 Jackson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6013038 | 2118237 | 37.7970085486816 | -122.398921272101 | (37.7970085486816, -122.398921272101) | 3 | 1 | 10 | 28860 | 6 | ||||
18614 | 132205 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 12 Greenwich St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012257.5514 | 2120548.1369 | 37.8033108539845 | -122.401784364564 | (37.8033108539845, -122.401784364564) | 3 | 1 | 10 | 28860 | 6 | ||||
18878 | 250202 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 203 Union St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | 3 | 1 | 10 | 308 | 23 | |||
19052 | 260948 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 370 Drumm St | 1 | Side Yard : Yard | Tree | Private 2 | 6013616 | 2118213 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | 3 | 1 | 10 | 28860 | 6 | |||||
22008 | 132208 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Union St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6012099.30323 | 2119801.66278 | 37.8012523849575 | -122.402279475534 | (37.8012523849575, -122.402279475534) | 3 | 1 | 10 | 28860 | 6 | ||||
29505 | 132201 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 95 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6008101.98916 | 2119090.79799 | 37.7990765867616 | -122.416061605678 | (37.7990765867616, -122.416061605678) | 5 | 1 | 10 | 308 | 32 | ||||
32649 | 132207 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Union St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012049.27862 | 2119798.13006 | 37.8012398924644 | -122.40245233511 | (37.8012398924644, -122.40245233511) | 3 | 1 | 10 | 28860 | 6 | ||||
44600 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
56602 | 250219 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 310 Montgomery St | 2 | Front Yard : Yard | Tree | Private 2 | 23 | Width 0ft | 6011287.59722 | 2120080.15149 | 37.8019717040854 | -122.40510797016 | (37.8019717040854, -122.40510797016) | 3 | 1 | 10 | 308 | 23 | |||
58145 | 249825 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 391 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 25 | Width 0ft | 6010996.75714 | 2119996.47458 | 37.8017256846648 | -122.406108520815 | (37.8017256846648, -122.406108520815) | 3 | 1 | 10 | 308 | 23 | |||
60721 | 132203 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 941 Vallejo St | 9 | Front Yard : Yard | Tree | Private 2 | 25 | 6008948.41749 | 2118683.7067 | 37.7980063683465 | -122.413103866774 | (37.7980063683465, -122.413103866774) | 3 | 1 | 10 | 308 | 21 | ||||
69829 | 132202 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 956 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 54 | 6008925.46833 | 2118706.00298 | 37.7980663000818 | -122.413184855205 | (37.7980663000818, -122.413184855205) | 3 | 1 | 10 | 308 | 21 | ||||
84037 | 107611 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 470x Broadway | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 774041 | 6011286.02608 | 2118707.45024 | 37.7982025127238 | -122.40501669829 | (37.7982025127238, -122.40501669829) | 3 | 1 | 10 | 308 | 23 | ||||
84386 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1155@Sansome Battery St | 3 | Front Yard : Yard | Tree | Private 2 | Plaza | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | |||
84470 | 249790 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 173 Chestnut St | 4 | Front Yard : Yard | Tree | Private 2 | 16 | Width 0ft | 6010907.69463 | 2121032.6733 | 37.8045658498002 | -122.406489777591 | (37.8045658498002, -122.406489777591) | 3 | 1 | 10 | 308 | 23 | |||
91710 | 249898 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1497 Montgomery St | 4 | Side Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011364.51666 | 2120462.68134 | 37.8030263372523 | -122.404868738822 | (37.8030263372523, -122.404868738822) | 3 | 1 | 10 | 28860 | 23 | |||
92469 | 249994 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 230 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011548.30327 | 2120099.56234 | 37.8020395723386 | -122.404207166046 | (37.8020395723386, -122.404207166046) | 3 | 1 | 10 | 308 | 23 | |||
104357 | 132204 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 12 Greenwich St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6012294.06984 | 2120559.14097 | 37.8033431063468 | -122.401658764365 | (37.8033431063468, -122.401658764365) | 3 | 1 | 10 | 28860 | 6 | ||||
113589 | 249792 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 173 Chestnut St | 6 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6010895.76074 | 2121030.82581 | 37.8045601094175 | -122.406530945871 | (37.8045601094175, -122.406530945871) | 3 | 1 | 10 | 308 | 23 | |||
120059 | 249785 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 161 Chestnut St | 2 | Front Yard : Yard | Tree | Private 2 | 22 | Width 0ft | 6010956.1226 | 2121039.70037 | 37.8045878535131 | -122.406322682661 | (37.8045878535131, -122.406322682661) | 3 | 1 | 10 | 308 | 23 | |||
122382 | 249788 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 173 Chestnut St | 2 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6010917.19441 | 2121035.26704 | 37.8045735030171 | -122.406457085429 | (37.8045735030171, -122.406457085429) | 3 | 1 | 10 | 308 | 23 | |||
123228 | 249794 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Chestnut St | 2 | Front Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 6010881.72847 | 2121029.02109 | 37.8045543690603 | -122.406579378835 | (37.8045543690603, -122.406579378835) | 3 | 1 | 10 | 308 | 23 | |||
125785 | 249791 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 173 Chestnut St | 5 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010901.74911 | 2121032.79444 | 37.8045658498059 | -122.406510361262 | (37.8045658498059, -122.406510361262) | 3 | 1 | 10 | 308 | 23 | |||
149198 | 132194 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 10ft | 6008339.23292 | 2117055.47626 | 37.7935014331032 | -122.415096515291 | (37.7935014331032, -122.415096515291) | 5 | 1 | 10 | 28858 | 21 | |||
150077 | 107187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
158371 | 249789 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 173 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 19 | Width 0ft | 6010910.88479 | 2121034.69861 | 37.8045715892703 | -122.40647888049 | (37.8045715892703, -122.40647888049) | 3 | 1 | 10 | 308 | 23 | |||
159833 | 249795 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6010876.47514 | 2121028.77996 | 37.804553413072 | -122.406597541559 | (37.804553413072, -122.406597541559) | 3 | 1 | 10 | 308 | 23 | |||
167124 | 249784 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 161 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010971.15638 | 2121021.973 | 37.8045400194799 | -122.406269406801 | (37.8045400194799, -122.406269406801) | 3 | 1 | 10 | 308 | 23 | |||
167645 | 132197 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6008332.13215 | 2117158.10141 | 37.7937828174649 | -122.415128352216 | (37.7937828174649, -122.415128352216) | 5 | 1 | 10 | 28858 | 21 | |||
174269 | 132196 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 6008335.46638 | 2117136.84644 | 37.7937246439237 | -122.415115310227 | (37.7937246439237, -122.415115310227) | 5 | 1 | 10 | 28858 | 21 | |||
174747 | 250209 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 212 Union St | 5 | Front Yard : Yard | Tree | Private 2 | 17 | Width 0ft | 6011754.82957 | 2119792.32643 | 37.8012075150685 | -122.403470855112 | (37.8012075150685, -122.403470855112) | 3 | 1 | 10 | 308 | 23 | |||
176210 | 250207 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 212 Union St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011784.78005 | 2119790.75424 | 37.8012048710537 | -122.403367102114 | (37.8012048710537, -122.403367102114) | 3 | 1 | 10 | 308 | 23 | |||
180056 | 132206 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Union St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6012038.33041 | 2119798.95957 | 37.8012415589072 | -122.4024902793 | (37.8012415589072, -122.4024902793) | 3 | 1 | 10 | 28860 | 6 | ||||
185680 | 132195 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6008338.31576 | 2117104.3343 | 37.7936355337159 | -122.415103148693 | (37.7936355337159, -122.415103148693) | 5 | 1 | 10 | 28858 | 21 | |||
192723 | 249793 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6010888.03809 | 2121029.58951 | 37.8045562827982 | -122.406557583781 | (37.8045562827982, -122.406557583781) | 3 | 1 | 10 | 308 | 23 | |||
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
2578 | 139478 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 416 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2020 12:00:00 AM | 3 | Width 0ft | 5999096.683 | 2111385.8942 | 37.7774105099956 | -122.446668218684 | (37.7774105099956, -122.446668218684) | 15 | 5 | 11 | 29492 | 16 | ||
5276 | 9649 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 420X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999128.38767 | 2111347.91542 | 37.7773080410323 | -122.446555809153 | (37.7773080410323, -122.446555809153) | 15 | 5 | 11 | 29492 | 16 | |||
25020 | 54835 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 117 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 15 | Permit Number 10689 | 5998722.2979 | 2110262.8651 | 37.7743055679817 | -122.447882461981 | (37.7743055679817, -122.447882461981) | 15 | 5 | 11 | 29492 | 16 | ||
25777 | 257968 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
37143 | 257967 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
45339 | 253119 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 185 Belgrave Ave | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 780239 | 5997636.85301 | 2104869.74588 | 37.7594353359783 | -122.45124816933 | (37.7594353359783, -122.45124816933) | 15 | 5 | 11 | 28862 | 12 | ||||
72407 | 118344 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 621x Gough St | 1 | Front Yard : Yard | Tree | Private 2 | 6005346 | 2111820 | 37.7789574535961 | -122.425080654997 | (37.7789574535961, -122.425080654997) | 7 | 9 | 11 | 28852 | 41 | |||||
74341 | 247543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1101 Waller St | 25 | Sidewalk: Curb side : Yard | Tree | Private 2 | 80 | 6000225.31856 | 2108498.53576 | 37.7695469597628 | -122.442556551344 | (37.7695469597628, -122.442556551344) | 15 | 5 | 11 | 29492 | 9 | ||||
75471 | 98104 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | ||||
81315 | 104261 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1556X O'Farrell St | 1 | Front Yard : Yard | Tree | Private 2 | 6003781.85581 | 2113525.38813 | 37.783551542878 | -122.430613377711 | (37.783551542878, -122.430613377711) | 13 | 9 | 11 | 29490 | 41 | |||||
91877 | 113055 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 815 Buena Vista West Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | |||||
93603 | 95230 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 6 | Front Yard : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 27 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
101829 | 257926 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 8 Hill Point Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5996384 | 2106804 | 37.7646744896132 | -122.455720942569 | (37.7646744896132, -122.455720942569) | 15 | 5 | 11 | 29492 | 12 | ||||
103964 | 106914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1192 PAGE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | Permit Number 774208 | 6000862.8 | 2109319.8 | 37.7718382630699 | -122.440410441009 | (37.7718382630699, -122.440410441009) | 15 | 5 | 11 | 29492 | 9 | ||
114996 | 54892 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 171 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2008 12:00:00 AM | Permit Number 50283 | 5997476.90745851 | 2107071.75606077 | 37.7654723391322 | -122.451960202936 | (37.7654723391322, -122.451960202936) | 15 | 5 | 11 | 29492 | 9 | |||
117614 | 40618 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 201 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 41624 | 6005148.26696606 | 2109558.58269734 | 37.7727369810284 | -122.425603701556 | (37.7727369810284, -122.425603701556) | 7 | 9 | 11 | 28852 | 10 | ||
133453 | 9648 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 420X Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5999128.38767 | 2111347.91542 | 37.7773080410323 | -122.446555809153 | (37.7773080410323, -122.446555809153) | 15 | 5 | 11 | 29492 | 16 | |||
149072 | 9647 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 420X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 5999128.38767 | 2111347.91542 | 37.7773080410323 | -122.446555809153 | (37.7773080410323, -122.446555809153) | 15 | 5 | 11 | 29492 | 16 | |||
155662 | 105755 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1100X Divisadero St | 1 | Front Yard : Yard | Tree | Private 2 | 6001418 | 2112151 | 37.7796436231931 | -122.438692875339 | (37.7796436231931, -122.438692875339) | 15 | 5 | 11 | 29490 | 41 | |||||
168614 | 108208 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 100X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000799.34617 | 2109469.60329 | 37.7722459721119 | -122.440640678445 | (37.7722459721119, -122.440640678445) | 15 | 5 | 11 | 29492 | 9 | |||||
4854 | 117978 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 428 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5984094.13719 | 2112920.10602 | 37.7807546046446 | -122.498679507303 | (37.7807546046446, -122.498679507303) | 11 | 6 | 2 | 55 | 26 | |||
6943 | 262154 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 519 22nd Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5989039 | 2111772 | 37.7778909946523 | -122.481488924787 | (37.7778909946523, -122.481488924787) | 11 | 6 | 2 | 55 | 26 | ||||
8543 | 20492 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
12856 | 117976 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 428 38th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5984094.3285 | 2112929.06261 | 37.7807792080542 | -122.498679507315 | (37.7807792080542, -122.498679507315) | 11 | 6 | 2 | 55 | 26 | |||
20532 | 20482 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 42 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
31421 | 20481 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
35152 | 63257 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 465 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/1987 12:00:00 AM | 38 | Permit Number 23810 | 5984679.75149 | 2112668.94882 | 37.7800993277188 | -122.496635074658 | (37.7800993277188, -122.496635074658) | 11 | 6 | 2 | 55 | 26 | ||
36006 | 96113 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 229 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767768 | 5982054.02521 | 2112599.84865 | 37.7797554116507 | -122.505713372558 | (37.7797554116507, -122.505713372558) | 11 | 6 | 2 | 55 | 26 |
37487 | 20499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
41903 | 123370 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 785 03rd Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 4ft | Permit Number 781809 | 5995014 | 2110353 | 37.7743403969856 | -122.460716589224 | (37.7743403969856, -122.460716589224) | 11 | 6 | 2 | 54 | 11 | ||
47360 | 118634 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 349 Point Lobos Ave | 3 | Side Yard : Yard | Tree | Private 2 | 16 | 5981640.48035 | 2112637.49721 | 37.7798344356349 | -122.507146773829 | (37.7798344356349, -122.507146773829) | 11 | 6 | 2 | 55 | 26 | ||||
59197 | 20485 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
59956 | 255159 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 4150 Clement St | 1 | Front Yard : Yard | Tree | Private 2 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |||||
66223 | 118839 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600 46th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 5ft | 5981667.64941 | 2111553.97712 | 37.7768610093184 | -122.506972389283 | (37.7768610093184, -122.506972389283) | 11 | 6 | 2 | 55 | 26 | |||
68258 | 118463 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 545 Point Lobos Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 5981101.15577 | 2112608.26384 | 37.7797223901441 | -122.509010330711 | (37.7797223901441, -122.509010330711) | 11 | 6 | 2 | 55 | 26 | ||||
70167 | 124182 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 18 Almaden Ct | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 9ft | 5995869.66626 | 2112609.07722 | 37.7805841826664 | -122.457919996377 | (37.7805841826664, -122.457919996377) | 11 | 6 | 2 | 54 | 16 | |||
73033 | 118489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 8301 Geary Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | 5981241.64042 | 2112313.06401 | 37.778920139734 | -122.508502421445 | (37.778920139734, -122.508502421445) | 11 | 6 | 2 | 55 | 26 | ||||
79098 | 119516 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 741 31st Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | 5986357.0692 | 2110765.11995 | 37.7749700841439 | -122.490692434311 | (37.7749700841439, -122.490692434311) | 11 | 6 | 2 | 55 | 26 | ||||
81798 | 20491 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
100926 | 20493 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
108106 | 20487 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
109804 | 20484 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
109835 | 20502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 |
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) );