Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
| 29143 | 29143 | 248220 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007112.652530001 | 2099342.90806 | 37.7447979012027 | -122.41808429785499 | (37.7447979012027, -122.418084297855) | ||||
| 30481 | 30481 | 247913 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Franconia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009968.0552900005 | 2098803.93583 | 37.743478301698296 | -122.40817280665001 | (37.7434783016983, -122.40817280665) | ||||
| 35294 | 35294 | 177823 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009246.7312 | 2086449.12039 | 37.7095141743011 | -122.409795064007 | (37.7095141743011, -122.409795064007) | |||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 45261 | 45261 | 177822 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | Width 3ft | 6009243.51838 | 2086439.4286099998 | 37.7094873825954 | -122.40980548443899 | (37.7094873825954, -122.409805484439) | |||
| 48879 | 48879 | 177820 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009221.96633 | 2086380.57337 | 37.7093245702546 | -122.409875820418 | (37.7093245702546, -122.409875820418) | |||
| 52499 | 52499 | 248193 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007342.31013 | 2098763.52222 | 37.74321996062879 | -122.417249134357 | (37.7432199606288, -122.417249134357) | ||||
| 52509 | 52509 | 177834 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6005075.62014 | 2092583.76802 | 37.7261239546294 | -122.424647248878 | (37.7261239546294, -122.424647248878) | ||||
| 56892 | 56892 | 248221 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6007127.43713 | 2099336.46972 | 37.744781055094705 | -122.418032719051 | (37.7447810550947, -122.418032719051) | ||||
| 65111 | 65111 | 248192 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007348.90224 | 2098760.26711 | 37.7432113936915 | -122.41722610990101 | (37.7432113936915, -122.417226109901) | ||||
| 65623 | 65623 | 177843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6005078.05129 | 2092608.48476 | 37.726191958666796 | -122.424640601997 | (37.7261919586668, -122.424640601997) | ||||
| 70150 | 70150 | 248180 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007468.18996 | 2098662.76578 | 37.7429503870626 | -122.416806737143 | (37.7429503870626, -122.416806737143) | ||||
| 119320 | 119320 | 177821 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009239.86768 | 2086426.74333 | 37.7094523468075 | -122.40981720709101 | (37.7094523468075, -122.409817207091) | |||
| 130946 | 130946 | 177832 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6005040.015980001 | 2092604.7564 | 37.7261795732245 | -122.424771822965 | (37.7261795732245, -122.424771822965) | ||||
| 134143 | 134143 | 247904 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 582 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009836.26109 | 2098719.48806 | 37.743239046039 | -122.408622563902 | (37.743239046039, -122.408622563902) | ||||
| 153822 | 153822 | 177840 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 655 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6005146.609019999 | 2092568.42927 | 37.7260858467747 | -122.424400753697 | (37.7260858467747, -122.424400753697) | ||||
| 154289 | 154289 | 177842 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6005092.77094 | 2092617.82642 | 37.726218440119 | -122.42459038114599 | (37.726218440119, -122.424590381146) | ||||
| 164474 | 164474 | 177818 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009189.876619999 | 2086285.53025 | 37.7090618027185 | -122.409980023068 | (37.7090618027185, -122.409980023068) | |||
| 165962 | 165962 | 210573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998016.4865 | 2095547.09873 | 37.7338593545253 | -122.449263553965 | (37.7338593545253, -122.449263553965) | ||||
| 168100 | 168100 | 177841 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6005100.14116 | 2092616.6598200002 | 37.726215653124704 | -122.424564819721 | (37.7262156531247, -122.424564819721) | ||||
| 168635 | 168635 | 177817 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009184.18934 | 2086265.3806200002 | 37.7090061571804 | -122.409998257729 | (37.7090061571804, -122.409998257729) | |||
| 172858 | 172858 | 187572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010864.17104 | 2089487.4487 | 37.7179473203875 | -122.404418609237 | (37.7179473203875, -122.404418609237) | ||||
| 175058 | 175058 | 177833 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6005045.58694 | 2092601.1582099998 | 37.726170008036 | -122.42475230858601 | (37.726170008036, -122.424752308586) | ||||
| 182180 | 182180 | 210572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998021.954 | 2095543.6754599998 | 37.7338502677764 | -122.449244404708 | (37.7338502677764, -122.449244404708) | ||||
| 182795 | 182795 | 177819 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009193.28856 | 2086304.97531 | 37.709115386123 | -122.40996960262501 | (37.709115386123, -122.409969602625) | |||
| 188202 | 188202 | 248243 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 296 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006794.0541900005 | 2099005.53684 | 37.743853618456995 | -122.41916202653299 | (37.743853618457, -122.419162026533) | ||||
| 189026 | 189026 | 248177 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007380.96811 | 2098703.14115 | 37.743056342490796 | -122.417111187331 | (37.7430563424908, -122.417111187331) | ||||
| 33505 | 33505 | 193829 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Phelps St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | Width 8ft | 6014453.31745 | 2096931.20635 | 37.738586300018504 | -122.392532803946 | (37.7385863000185, -122.392532803946) | |||
| 34172 | 34172 | 247998 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 346 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6009778.5557 | 2099261.40313 | 37.7447237943804 | -122.408860320375 | (37.7447237943804, -122.408860320375) | ||||
| 136135 | 136135 | 247996 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 344 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009762.11603 | 2099283.17525 | 37.7447826549975 | -122.408918701663 | (37.7447826549975, -122.408918701663) | ||||
| 187624 | 187624 | 248183 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 216 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 6007446.150909999 | 2098698.08371 | 37.743046122577894 | -122.416885444016 | (37.7430461225779, -122.416885444016) | ||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 9694 | 9694 | 173632 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3300X Market St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | ||||||||||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 24680 | 24680 | 187543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6011384.82868 | 2088240.1087599997 | 37.714551459646394 | -122.402531250636 | (37.7145514596464, -122.402531250636) | ||||
| 29239 | 29239 | 211277 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 5998792.56249 | 2095483.7387400002 | 37.7337297433315 | -122.44657587878599 | (37.7337297433315, -122.446575878786) | ||||
| 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) | |||
| 31259 | 31259 | 201730 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6013762.45417 | 2095926.0507 | 37.7357879596321 | -122.39485111951001 | (37.7357879596321, -122.39485111951) | ||||
| 37557 | 37557 | 178348 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 99 Bowdoin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 6008413.681059999 | 2094760.49373 | 37.732288735333796 | -122.413261587147 | (37.7322887353338, -122.413261587147) | ||||
| 39341 | 39341 | 218152 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 22 Ashton Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5994167.21256 | 2090073.13732 | 37.71860825915 | -122.46217470241601 | (37.71860825915, -122.462174702416) | ||||
| 44680 | 44680 | 247950 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 7 Joy St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6010415.94161 | 2098863.8955 | 37.7436680064781 | -122.406628345115 | (37.7436680064781, -122.406628345115) | ||||
| 48330 | 48330 | 178340 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 72 La Grande Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6005229.68605 | 2091771.5142599999 | 37.7239023836832 | -122.424056914098 | (37.7239023836832, -122.424056914098) | ||||
| 49965 | 49965 | 114038 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2x Moffitt St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6002767.774130001 | 2096661.3136900002 | 37.737189358209704 | -122.43291650912201 | (37.7371893582097, -122.432916509122) | ||||
| 51094 | 51094 | 201728 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6013736.51011 | 2095944.0047900002 | 37.7358358152635 | -122.394942076023 | (37.7358358152635, -122.394942076023) | ||||
| 52032 | 52032 | 248226 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 71 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6007119.30754 | 2099366.9898200002 | 37.7448643988822 | -122.418062992935 | (37.7448643988822, -122.418062992935) | ||||
| 54571 | 54571 | 211276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 49 | 5998791.497719999 | 2095472.56851 | 37.7336990117025 | -122.446578756609 | (37.7336990117025, -122.446578756609) | ||||
| 59496 | 59496 | 247995 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 344 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6009760.7197 | 2099297.4948 | 37.744821895131395 | -122.408924540052 | (37.7448218951314, -122.408924540052) | ||||
| 60768 | 60768 | 247951 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 7 Joy St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010431.49543 | 2098860.4670599997 | 37.7436594629209 | -122.406574321963 | (37.7436594629209, -122.406574321963) | ||||
| 72602 | 72602 | 187584 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 747 University St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6008737.4209199995 | 2090741.8815799998 | 37.721272650900396 | -122.411858473006 | (37.7212726509004, -122.411858473006) | ||||
| 120316 | 120316 | 121151 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1X Payson St | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 25 | 3x3 | 5992041.0 | 2087761.0 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 132613 | 132613 | 248191 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 216 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 33 | 6007363.38842 | 2098751.31764 | 37.743187635412205 | -122.417175386353 | (37.7431876354122, -122.417175386353) | ||||
| 132929 | 132929 | 248176 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 218 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6007352.57269 | 2098728.04066 | 37.7431231135451 | -122.41721113529499 | (37.7431231135451, -122.417211135295) | ||||
| 136091 | 136091 | 178347 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 99 Bowdoin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6008416.70539 | 2094741.77162 | 37.7322374982533 | -122.413249807854 | (37.7322374982533, -122.413249807854) | ||||
| 138080 | 138080 | 247822 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3514 Folsom St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6008510.026459999 | 2098371.0987299997 | 37.7422080785429 | -122.413183721146 | (37.7422080785429, -122.413183721146) | ||||
| 138174 | 138174 | 233332 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Saturn St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6000503.342180001 | 2106030.7905200003 | 37.7627869888479 | -122.44141778031201 | (37.7627869888479, -122.441417780312) | |||
| 149294 | 149294 | 201731 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6013749.92034 | 2095926.84789 | 37.7357894516288 | -122.394894510001 | (37.7357894516288, -122.394894510001) | ||||
| 150599 | 150599 | 194489 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1750 22nd St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6012793.88135 | 2103795.98527 | 37.7573432171426 | -122.398752009817 | (37.7573432171426, -122.398752009817) | ||||
| 152037 | 152037 | 211278 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 5998798.56109 | 2095521.95863 | 37.733835028746796 | -122.44655788876301 | (37.7338350287468, -122.446557888763) | ||||
| 154391 | 154391 | 248188 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 216 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 33 | 6007407.05518 | 2098723.69858 | 37.7431142561228 | -122.417022441339 | (37.7431142561228, -122.417022441339) | ||||
| 154482 | 154482 | 201729 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013763.5505 | 2095932.04649 | 37.735804483793004 | -122.394847748824 | (37.735804483793, -122.394847748824) | ||||
| 159005 | 159005 | 248175 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 218 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | 6007339.081730001 | 2098714.17306 | 37.743084277216894 | -122.417256801054 | (37.7430842772169, -122.417256801054) | ||||
| 162601 | 162601 | 178307 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 623 Brotherhood Way | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 5990951.00825 | 2088079.7183700001 | 37.712949111472604 | -122.473146401692 | (37.7129491114726, -122.473146401692) | |||
| 168432 | 168432 | 248087 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 14 Montcalm St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010655.20977 | 2100360.58155 | 37.747790964577 | -122.40590641976699 | (37.747790964577, -122.405906419767) | ||||
| 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) | |||
| 176020 | 176020 | 178272 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | Width 3ft | 6009218.69223 | 2086367.8804 | 37.709289534449894 | -122.409886240875 | (37.7092895344499, -122.409886240875) | |||
| 176645 | 176645 | 178270 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009167.93697 | 2086263.08528 | 37.7089989437285 | -122.41005426658701 | (37.7089989437285, -122.410054266587) | |||
| 178075 | 178075 | 178250 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 287 Hester Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6012202.6988699995 | 2087794.30309 | 37.713372992543896 | -122.39967306036199 | (37.7133729925439, -122.399673060362) | ||||
| 179933 | 179933 | 248234 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 299 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6006807.51712 | 2099039.75283 | 37.7439483260488 | -122.419117901273 | (37.7439483260488, -122.419117901273) | ||||
| 181069 | 181069 | 248060 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 18 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010688.173909999 | 2099371.0284599997 | 37.7450757107928 | -122.40572274042201 | (37.7450757107928, -122.405722740422) | ||||
| 184172 | 184172 | 178271 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6009176.170940001 | 2086260.2904299998 | 37.7089917311415 | -122.41002561149901 | (37.7089917311415, -122.410025611499) | |||
| 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) | ||||
| 133137 | 133137 | 191429 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2399 Lane St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6013991.75526 | 2092879.9064599997 | 37.7274366158882 | -122.393845172923 | (37.7274366158882, -122.393845172923) | ||||
| 188033 | 188033 | 226640 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 10 Crescent Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6005282.96903 | 2095902.7994400002 | 37.7352489878562 | -122.42416639485799 | (37.7352489878562, -122.424166394858) | |||
| 23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
| 25663 | 25663 | 188593 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010961.38996 | 2104652.9831 | 37.759594070921004 | -122.40514986509899 | (37.759594070921, -122.405149865099) | ||||
| 31230 | 31230 | 187779 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Middle Point Rd | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 6ft | 6018271.33931 | 2096490.0449 | 37.737586251210104 | -122.379301134458 | (37.7375862512101, -122.379301134458) | |||
| 44107 | 44107 | 188705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1998 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013030.362000001 | 2095929.4873 | 37.7357566623473 | -122.397382506903 | (37.7357566623473, -122.397382506903) | ||||
| 49102 | 49102 | 248109 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 138 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010416.26244 | 2099462.28287 | 37.7453110660681 | -122.406669396477 | (37.7453110660681, -122.406669396477) | ||||
| 53119 | 53119 | 175069 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011573.1556 | 2092162.2260200002 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | ||||
| 56158 | 56158 | 247931 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010377.81236 | 2098773.8118 | 37.7434185228518 | -122.406753840137 | (37.7434185228518, -122.406753840137) | ||||
| 65626 | 65626 | 247850 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 42 | 6009080.756440001 | 2098231.91815 | 37.7418579436943 | -122.41120047681801 | (37.7418579436943, -122.411200476818) | ||||
| 66596 | 66596 | 248070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010599.59932 | 2099402.0661 | 37.745155979779504 | -122.406031203374 | (37.7451559797795, -122.406031203374) | ||||
| 69221 | 69221 | 247529 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000073.75314 | 2108487.72588 | 37.7695086378454 | -122.44308003233499 | (37.7695086378454, -122.443080032335) | ||||
| 130643 | 130643 | 247527 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000059.53834 | 2108484.86365 | 37.769499968379705 | -122.443128995021 | (37.7694999683797, -122.443128995021) | ||||
| 132984 | 132984 | 175066 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Thornton Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010981.076169999 | 2094029.55145 | 37.73042552801979 | -122.40433403878599 | (37.7304255280198, -122.404334038786) | ||||
| 133560 | 133560 | 247858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 82 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009570.7437 | 2098077.6511 | 37.7414618274161 | -122.40949536852501 | (37.7414618274161, -122.409495368525) | ||||
| 156377 | 156377 | 247522 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6000010.6242 | 2108472.60358 | 37.7694635161602 | -122.443297305835 | (37.7694635161602, -122.443297305835) | ||||
| 159551 | 159551 | 247520 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6000003.99995 | 2108482.26842 | 37.7694896756401 | -122.443320913055 | (37.7694896756401, -122.443320913055) | ||||
| 165964 | 165964 | 175067 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Thornton Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6010979.40226 | 2094033.66945 | 37.730436741644894 | -122.404340115499 | (37.7304367416449, -122.404340115499) | ||||
| 172072 | 172072 | 187778 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Middle Point Rd | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 6ft | 6018276.18855 | 2096495.79876 | 37.7376023175876 | -122.37928476769899 | (37.7376023175876, -122.379284767699) | |||
| 172088 | 172088 | 125288 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 943 Green St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.41407270821101 | (37.7988459853112, -122.414072708211) | ||||
| 176347 | 176347 | 125277 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6006721.71386 | 2119753.35883 | 37.800818109519206 | -122.420884898228 | (37.8008181095192, -122.420884898228) | ||||
| 179049 | 179049 | 175068 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6011564.90281 | 2092154.99462 | 37.7253109908919 | -122.402183913575 | (37.7253109908919, -122.402183913575) | ||||
| 181186 | 181186 | 175070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Woolsey St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6011561.993480001 | 2092186.33195 | 37.725396874350096 | -122.40219617312599 | (37.7253968743501, -122.402196173126) |
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");