Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1708 | 1708 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1710 | 1710 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 100647 | 100647 | 121134 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x10 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 119513 | 119513 | 121133 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x10 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | |||
| 46681 | 46681 | 249785 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 161 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 0ft | 6010956.1226 | 2121039.70037 | 37.804587853513105 | -122.406322682661 | (37.8045878535131, -122.406322682661) | |||
| 34887 | 34887 | 249788 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010917.19441 | 2121035.2670400003 | 37.8045735030171 | -122.406457085429 | (37.8045735030171, -122.406457085429) | |||
| 184049 | 184049 | 249789 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 0ft | 6010910.8847900005 | 2121034.69861 | 37.804571589270296 | -122.40647888049 | (37.8045715892703, -122.40647888049) | |||
| 172377 | 172377 | 249791 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.74911 | 2121032.7944400003 | 37.8045658498059 | -122.406510361262 | (37.8045658498059, -122.406510361262) | |||
| 63805 | 63805 | 249790 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6010907.694630001 | 2121032.6733 | 37.804565849800206 | -122.406489777591 | (37.8045658498002, -122.406489777591) | |||
| 133837 | 133837 | 249792 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010895.76074 | 2121030.82581 | 37.8045601094175 | -122.406530945871 | (37.8045601094175, -122.406530945871) | |||
| 154988 | 154988 | 249793 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6010888.03809 | 2121029.58951 | 37.8045562827982 | -122.406557583781 | (37.8045562827982, -122.406557583781) | |||
| 42673 | 42673 | 249794 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6010881.7284699995 | 2121029.02109 | 37.8045543690603 | -122.40657937883499 | (37.8045543690603, -122.406579378835) | |||
| 115163 | 115163 | 249795 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 6010876.47514 | 2121028.77996 | 37.804553413072 | -122.406597541559 | (37.804553413072, -122.406597541559) | |||
| 59452 | 59452 | 249784 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 161 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010971.1563800005 | 2121021.973 | 37.8045400194799 | -122.406269406801 | (37.8045400194799, -122.406269406801) | |||
| 187806 | 187806 | 132199 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2836 Larkin St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6006498.02761 | 2121046.57665 | 37.8043563455331 | -122.42175085543998 | (37.8043563455331, -122.42175085544) | ||||
| 130652 | 130652 | 132198 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2836 Larkin St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6006512.519719999 | 2121038.28328 | 37.804334391275894 | -122.42170011478301 | (37.8043343912759, -122.421700114783) | ||||
| 20076 | 20076 | 98360 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | ||||
| 155029 | 155029 | 132204 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 12 Greenwich St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 6012294.06984 | 2120559.14097 | 37.803343106346794 | -122.40165876436501 | (37.8033431063468, -122.401658764365) | ||||
| 187393 | 187393 | 132205 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 12 Greenwich St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6012257.5514 | 2120548.1369 | 37.8033108539845 | -122.401784364564 | (37.8033108539845, -122.401784364564) | ||||
| 173273 | 173273 | 249898 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1497 Montgomery St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011364.51666 | 2120462.68134 | 37.8030263372523 | -122.404868738822 | (37.8030263372523, -122.404868738822) | |||
| 76843 | 76843 | 249887 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 230 Greenwich St | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011491.952269999 | 2120439.55706 | 37.802969965942104 | -122.40442611408399 | (37.8029699659421, -122.404426114084) | |||
| 103272 | 103272 | 50960 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 65 Montclair Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47453 | 6007264.23528351 | 2120370.2610527 | 37.8025425319574 | -122.41905132385 | (37.8025425319574, -122.41905132385) | ||||
| 114598 | 114598 | 23558 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2900X Van Ness Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9x200 | 6005648.5023441 | 2120304.1415398 | 37.8022698669467 | -122.42463786565399 | (37.8022698669467, -122.424637865654) | |||
| 56479 | 56479 | 249994 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 230 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011548.30327 | 2120099.56234 | 37.8020395723386 | -122.404207166046 | (37.8020395723386, -122.404207166046) | |||
| 185402 | 185402 | 250219 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 310 Montgomery St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6011287.59722 | 2120080.15149 | 37.801971704085396 | -122.40510797016 | (37.8019717040854, -122.40510797016) | |||
| 105112 | 105112 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2620 Larkin St | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | Permit Number 56959 | 6006630.0 | 2120172.0 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | ||||
| 91730 | 91730 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1155@Sansome Battery St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | |||
| 83772 | 83772 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1160 Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.40155068012699 | (37.8018575696458, -122.401550680127) | |||
| 187651 | 187651 | 132200 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1151 Lombard St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6006710.22294 | 2120090.22803 | 37.801742419238 | -122.42094859269899 | (37.801742419238, -122.420948592699) | ||||
| 175533 | 175533 | 249825 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 391 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 6010996.75714 | 2119996.47458 | 37.801725684664795 | -122.406108520815 | (37.8017256846648, -122.406108520815) | |||
| 67218 | 67218 | 132208 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Union St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6012099.303230001 | 2119801.66278 | 37.8012523849575 | -122.402279475534 | (37.8012523849575, -122.402279475534) | ||||
| 159200 | 159200 | 132206 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Union St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6012038.33041 | 2119798.95957 | 37.8012415589072 | -122.4024902793 | (37.8012415589072, -122.4024902793) | ||||
| 183957 | 183957 | 132207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Union St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012049.27862 | 2119798.13006 | 37.8012398924644 | -122.40245233511001 | (37.8012398924644, -122.40245233511) | ||||
| 76954 | 76954 | 250209 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 212 Union St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 0ft | 6011754.82957 | 2119792.32643 | 37.8012075150685 | -122.403470855112 | (37.8012075150685, -122.403470855112) | |||
| 26474 | 26474 | 250207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 212 Union St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 6011784.78005 | 2119790.75424 | 37.801204871053706 | -122.40336710211399 | (37.8012048710537, -122.403367102114) | |||
| 29301 | 29301 | 250202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 203 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | |||
| 91956 | 91956 | 85282 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1283 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49571 | 6006751.0 | 2119761.0 | 37.8008407409326 | -122.42078409851001 | (37.8008407409326, -122.42078409851) | ||||
| 94528 | 94528 | 85283 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1283 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49571 | 6006751.0 | 2119761.0 | 37.8008407409326 | -122.42078409851001 | (37.8008407409326, -122.42078409851) | ||||
| 137692 | 137692 | 132201 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 95 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6008101.989159999 | 2119090.7979900003 | 37.7990765867616 | -122.41606160567801 | (37.7990765867616, -122.416061605678) | ||||
| 93109 | 93109 | 107611 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 470x Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 774041 | 6011286.02608 | 2118707.45024 | 37.7982025127238 | -122.40501669828998 | (37.7982025127238, -122.40501669829) | ||||
| 68976 | 68976 | 132202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 956 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 54 | 6008925.4683300005 | 2118706.00298 | 37.7980663000818 | -122.413184855205 | (37.7980663000818, -122.413184855205) | ||||
| 48106 | 48106 | 132203 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 941 Vallejo St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6008948.41749 | 2118683.7067 | 37.7980063683465 | -122.41310386677401 | (37.7980063683465, -122.413103866774) | ||||
| 101483 | 101483 | 113482 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2839 Pierce St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001345.0 | 2118077.0 | 37.7959107386074 | -122.43937030854799 | (37.7959107386074, -122.439370308548) | ||||||
| 164446 | 164446 | 250139 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2550x Lyon St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5999209.46456 | 2117608.80739 | 37.794503445131 | -122.446725934276 | (37.794503445131, -122.446725934276) | ||||
| 52273 | 52273 | 249719 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Broderick St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6000168.76533 | 2117405.83622 | 37.794000892281396 | -122.44339205841999 | (37.7940008922814, -122.44339205842) | ||||
| 60793 | 60793 | 249721 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Broderick St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6000189.90204 | 2117386.3039700002 | 37.7939484671928 | -122.443317519907 | (37.7939484671928, -122.443317519907) | ||||
| 147913 | 147913 | 249720 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Broderick St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6000174.4428900005 | 2117385.9513 | 37.7939466172975 | -122.44337098458 | (37.7939466172975, -122.44337098458) | ||||
| 109009 | 109009 | 121792 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2556 Broderick St | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 3x3 | 6000243.0 | 2117343.0 | 37.7938325936105 | -122.443130684772 | (37.7938325936105, -122.443130684772) | ||||
| 38481 | 38481 | 132197 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Priest St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6008332.13215 | 2117158.1014099997 | 37.7937828174649 | -122.415128352216 | (37.7937828174649, -122.415128352216) | |||
| 183287 | 183287 | 249688 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Baker St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5999721.2630900005 | 2117323.6721799998 | 37.793749761985396 | -122.444934546805 | (37.7937497619854, -122.444934546805) | ||||
| 27896 | 27896 | 132196 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Priest St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 10ft | 6008335.46638 | 2117136.84644 | 37.7937246439237 | -122.415115310227 | (37.7937246439237, -122.415115310227) | |||
| 51782 | 51782 | 249698 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Baker St | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 5999693.94716 | 2117283.58349 | 37.793638130036896 | -122.445026178739 | (37.7936381300369, -122.445026178739) | ||||
| 68870 | 68870 | 132195 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Priest St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6008338.31576 | 2117104.3343 | 37.7936355337159 | -122.415103148693 | (37.7936355337159, -122.415103148693) | |||
| 178034 | 178034 | 132194 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Priest St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 10ft | 6008339.232919999 | 2117055.47626 | 37.7935014331032 | -122.415096515291 | (37.7935014331032, -122.415096515291) | |||
| 135628 | 135628 | 132193 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Priest St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6008345.5033 | 2117049.6207 | 37.7934857075452 | -122.41507440455798 | (37.7934857075452, -122.415074404558) | |||
| 82967 | 82967 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 945 Sacramento St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.40810904235501 | (37.7928004918921, -122.408109042355) | ||||
| 115648 | 115648 | 107187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 945 Sacramento St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.40810904235501 | (37.7928004918921, -122.408109042355) | ||||
| 83538 | 83538 | 92871 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 3600 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53088 | 5997031.0 | 2116025.0 | 37.790030052590105 | -122.454149203806 | (37.7900300525901, -122.454149203806) | ||||
| 57778 | 57778 | 124704 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996074.417169999 | 2115943.0366 | 37.789750104458 | -122.457452946984 | (37.789750104458, -122.457452946984) | ||||
| 133994 | 133994 | 132192 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996086.73681 | 2115931.64437 | 37.789719532087396 | -122.457409497957 | (37.7897195320874, -122.457409497957) | ||||
| 35581 | 35581 | 132191 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3837 Washington St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5996517.22256 | 2115577.54353 | 37.7887719829951 | -122.455894459569 | (37.7887719829951, -122.455894459569) | |||
| 8010 | 8010 | 115555 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3897 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5996212.11985 | 2115219.4068 | 37.7877711202849 | -122.45692415093201 | (37.7877711202849, -122.456924150932) | |||
| 71820 | 71820 | 250649 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 142 El Camino Del Mar | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5988079.239440001 | 2115372.9404 | 37.7877223050946 | -122.485073297006 | (37.7877223050946, -122.485073297006) | |||
| 70053 | 70053 | 250650 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 142 El Camino Del Mar | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5988068.63131 | 2115372.88737 | 37.787721541568 | -122.48510999475401 | (37.787721541568, -122.485109994754) | |||
| 148317 | 148317 | 250651 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 142 El Camino Del Mar | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 4ft | 5988051.29763 | 2115371.58762 | 37.78771696311829 | -122.48516986981501 | (37.7877169631183, -122.485169869815) | |||
| 33366 | 33366 | 124269 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 9 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5994882.44582 | 2114964.8982 | 37.7869958645771 | -122.461506079992 | (37.7869958645771, -122.461506079992) | ||||
| 111961 | 111961 | 1 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 10 10th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.46898271049601 | (37.7866097734767, -122.468982710496) | |||
| 87085 | 87085 | 113937 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 800 EL CAMINO DEL MAR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 5985966.0 | 2115003.0 | 37.7865832348262 | -122.49235734524099 | (37.7865832348262, -122.492357345241) | ||||
| 82542 | 82542 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 156257 | 156257 | 250021 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Peter Yorke Way | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6005906.53716 | 2114478.7126700003 | 37.7862892740647 | -122.423330582061 | (37.7862892740647, -122.423330582061) | ||||
| 121014 | 121014 | 106903 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 20X MAYFAIR DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5998146.0 | 2114573.0 | 37.7861071180483 | -122.450186711437 | (37.7861071180483, -122.450186711437) | ||||
| 78763 | 78763 | 12819 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2160 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 14x5.5 | 5988722.6241 | 2114706.8097900003 | 37.78593075537871 | -122.48279849952401 | (37.7859307553787, -122.482798499524) | |||
| 92845 | 92845 | 114978 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 118399 | 118399 | 115436 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 144359 | 144359 | 115437 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 96978 | 96978 | 104261 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1556X O'Farrell St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003781.85581 | 2113525.38813 | 37.783551542878 | -122.430613377711 | (37.783551542878, -122.430613377711) | |||||
| 145060 | 145060 | 102056 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 332 19th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5990007.7 | 2113121.3 | 37.781652074321705 | -122.47823656971501 | (37.7816520743217, -122.478236569715) | |||||
| 119142 | 119142 | 116069 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 4150X CLEMENT ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | ||||
| 143181 | 143181 | 116070 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 4150X CLEMENT ST | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | ||||
| 26867 | 26867 | 117975 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 428 38th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 5984094.18326 | 2112936.79035 | 37.7808004176611 | -122.49868058079399 | (37.7808004176611, -122.498680580794) | |||
| 44986 | 44986 | 117976 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 428 38th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5984094.3285 | 2112929.06261 | 37.780779208054206 | -122.498679507315 | (37.7807792080542, -122.498679507315) | |||
| 68420 | 68420 | 117978 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 428 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5984094.13719 | 2112920.1060200003 | 37.780754604644606 | -122.49867950730301 | (37.7807546046446, -122.498679507303) | |||
| 154396 | 154396 | 124182 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 18 Almaden Ct | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 5995869.666259999 | 2112609.07722 | 37.780584182666395 | -122.45791999637699 | (37.7805841826664, -122.457919996377) | |||
| 38211 | 38211 | 118052 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 451 36th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 8ft | 5984675.38114 | 2112718.18403 | 37.7802342573005 | -122.496653827903 | (37.7802342573005, -122.496653827903) | |||
| 149391 | 149391 | 63257 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 465 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/1987 12:00:00 AM | 38 | Permit Number 23810 | 5984679.75149 | 2112668.94882 | 37.780099327718794 | -122.49663507465799 | (37.7800993277188, -122.496635074658) | ||
| 131480 | 131480 | 118634 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 5981640.48035 | 2112637.4972099997 | 37.779834435634896 | -122.507146773829 | (37.7798344356349, -122.507146773829) | ||||
| 131223 | 131223 | 118635 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 349 Point Lobos Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | 5981642.90919 | 2112624.80307 | 37.779799724333294 | -122.50713742957399 | (37.7797997243333, -122.507137429574) | ||||
| 162205 | 162205 | 118464 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 501 Point Lobos Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 5981239.04477 | 2112631.92257 | 37.779795477814105 | -122.508535077879 | (37.7797954778141, -122.508535077879) | ||||
| 118007 | 118007 | 24741 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 12x12 | 5982629.2221800005 | 2112591.8659099997 | 37.7797673297653 | -122.503722956534 | (37.7797673297653, -122.503722956534) | |||
| 74227 | 74227 | 96113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 229 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767768 | 5982054.02521 | 2112599.84865 | 37.779755411650704 | -122.505713372558 | (37.7797554116507, -122.505713372558) |
| 175941 | 175941 | 118463 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 545 Point Lobos Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 5981101.15577 | 2112608.26384 | 37.7797223901441 | -122.509010330711 | (37.7797223901441, -122.509010330711) | ||||
| 121907 | 121907 | 105755 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1100X Divisadero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001418.0 | 2112151.0 | 37.7796436231931 | -122.43869287533899 | (37.7796436231931, -122.438692875339) | |||||
| 122346 | 122346 | 87242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 4131 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 50271 | 5994116.9 | 2112250.5 | 37.779498769084604 | -122.46395756623998 | (37.7794987690846, -122.46395756624) | ||||
| 126828 | 126828 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5999865.0 | 2112093.0 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | ||||
| 90282 | 90282 | 118344 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 621x Gough St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005346.0 | 2111820.0 | 37.7789574535961 | -122.425080654997 | (37.7789574535961, -122.425080654997) | |||||
| 149914 | 149914 | 118489 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 8301 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 5981241.64042 | 2112313.06401 | 37.778920139734 | -122.508502421445 | (37.778920139734, -122.508502421445) | ||||
| 129750 | 129750 | 139478 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 416 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999096.682999999 | 2111385.8942 | 37.777410509995605 | -122.44666821868401 | (37.7774105099956, -122.446668218684) | |||
| 20371 | 20371 | 9649 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 110442 | 110442 | 9647 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 115010 | 115010 | 9648 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");