Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCaretaker, qCareAssistant, DBH, PlotSize
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3441 | 3441 | 32703 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 890 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37106 | 6007477.85623 | 2114415.95786 | 37.7862055211206 | -122.417889760126 | (37.7862055211206, -122.417889760126) |
| 18075 | 18075 | 32820 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37179 | 6001652.66778496 | 2102313.08223681 | 37.7526444703409 | -122.43717647687599 | (37.7526444703409, -122.437176476876) | ||
| 18702 | 18702 | 32730 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 431 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.5889800005 | 2088651.07748 | 37.714752948278104 | -122.459108206688 | (37.7147529482781, -122.459108206688) | |
| 18921 | 18921 | 32751 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 19029 | 19029 | 32731 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 431 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.91433 | 2088666.6169099999 | 37.7147956345921 | -122.45910820668699 | (37.7147956345921, -122.459108206687) | |
| 19423 | 19423 | 32825 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4388 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37183 | 6000688.62823937 | 2102311.71658566 | 37.752585873246005 | -122.440510188354 | (37.752585873246, -122.440510188354) | ||
| 20625 | 20625 | 32725 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 431 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.24753 | 2088599.26436 | 37.714610662038204 | -122.45910563733999 | (37.7146106620382, -122.45910563734) | |
| 22123 | 22123 | 32728 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 431 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.59612 | 2088615.9136299998 | 37.714656397048 | -122.45910563732599 | (37.714656397048, -122.459105637326) | |
| 22207 | 22207 | 32727 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 431 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.97569 | 2088634.0427 | 37.7147061970204 | -122.459105637321 | (37.7147061970204, -122.459105637321) | |
| 24685 | 24685 | 32723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1082 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 12 | Permit Number 37114 | 6007012.43686 | 2114697.78275 | 37.786953139214894 | -122.419519994465 | (37.7869531392149, -122.419519994465) | |
| 24747 | 24747 | 32784 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 722 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37151 | 5999634.6045 | 2111035.6277 | 37.7764794805822 | -122.444782194549 | (37.7764794805822, -122.444782194549) | |
| 26152 | 26152 | 32747 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 267 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 3 | Permit Number 37129 | 5994353.06343 | 2089312.7062799998 | 37.7165309960889 | -122.461477197213 | (37.7165309960889, -122.461477197213) | |
| 26530 | 26530 | 32698 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 665 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37104 | 6008567.49434 | 2114513.32482 | 37.7865341297888 | -122.41412677632799 | (37.7865341297888, -122.414126776328) | |
| 26569 | 26569 | 32778 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.775491837653796 | -122.43967909765101 | (37.7754918376538, -122.439679097651) | |
| 31350 | 31350 | 32756 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 548 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37134 | 5995923.97988 | 2088945.4822 | 37.7156129780405 | -122.456020830504 | (37.7156129780405, -122.456020830504) | |
| 31598 | 31598 | 32719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1059 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 15 | Permit Number 37112 | 6008120.91675 | 2116143.25856 | 37.7909844366445 | -122.415787285469 | (37.7909844366445, -122.415787285469) | |
| 32729 | 32729 | 32786 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1659 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37153 | 5999840.0614 | 2110872.9364 | 37.7760444944885 | -122.444059770227 | (37.7760444944885, -122.444059770227) | |
| 35374 | 35374 | 32812 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 421 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 5x5 | Permit Number 37171 | 6000142.4606 | 2110508.5779 | 37.7750613046635 | -122.442987522526 | (37.7750613046635, -122.442987522526) |
| 40005 | 40005 | 32827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4107 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | 3x3 | Permit Number 37185 | 6002480.53446063 | 2101776.94850735 | 37.751219399221604 | -122.434275246016 | (37.7512193992216, -122.434275246016) |
| 40290 | 40290 | 32745 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 148 Montana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | Permit Number 37127 | 5995448.12919 | 2089342.0569999998 | 37.7166745548685 | -122.45769425390101 | (37.7166745548685, -122.457694253901) | |
| 40828 | 40828 | 32785 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1903 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 5 | Permit Number 37152 | 6001293.802 | 2112456.0686 | 37.780474197878796 | -122.43914439989099 | (37.7804741978788, -122.439144399891) | ||
| 41626 | 41626 | 32797 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1768 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37160 | 5999343.0073 | 2110507.9142 | 37.7750138693543 | -122.445752948617 | (37.7750138693543, -122.445752948617) | |
| 47968 | 47968 | 32809 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1751 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 4 | Permit Number 37168 | 5999480.3938992005 | 2110124.82771126 | 37.773969854749105 | -122.445250151374 | (37.7739698547491, -122.445250151374) | |
| 48650 | 48650 | 32713 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1105 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 5 | Permit Number 37110 | 6007292.26872 | 2115149.22414 | 37.7882084444054 | -122.418583862255 | (37.7882084444054, -122.418583862255) | |
| 48937 | 48937 | 32762 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 118 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 4 | Permit Number 37137 | 5995714.520930001 | 2089647.57349 | 37.7175287309449 | -122.456795559591 | (37.7175287309449, -122.456795559591) | |
| 58505 | 58505 | 32742 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 27 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 4 | 3x3 | Permit Number 37125 | 5996375.5789 | 2089291.73885 | 37.7165896282782 | -122.454484907162 | (37.7165896282782, -122.454484907162) | |
| 63652 | 63652 | 32704 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 890 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37106 | 6007466.88018988 | 2114411.93310855 | 37.7861938524183 | -122.417927449032 | (37.7861938524183, -122.417927449032) | ||
| 66744 | 66744 | 32694 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3732 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | Permit Number 37102 | 6004840.63533052 | 2102540.6946209 | 37.7534501432299 | -122.426168121736 | (37.7534501432299, -122.426168121736) | |||
| 71231 | 71231 | 32716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008229.60793 | 2115679.81731 | 37.7897180499914 | -122.41537839431801 | (37.7897180499914, -122.415378394318) |
| 72216 | 72216 | 32816 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3770 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37175 | 6003302.6047116 | 2103041.70072149 | 37.7547387357637 | -122.43152272046301 | (37.7547387357637, -122.431522720463) | ||
| 73199 | 73199 | 32800 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1798 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 17 | Permit Number 37162 | 5999302.9591 | 2110503.3456 | 37.7749990384826 | -122.44589115485701 | (37.7749990384826, -122.445891154857) | |
| 75056 | 75056 | 32770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37143 | 6000719.0381 | 2110275.1768 | 37.7744533006426 | -122.440976272213 | (37.7744533006426, -122.440976272213) | |
| 76001 | 76001 | 32811 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1777 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37170 | 5999370.6282 | 2110118.0103 | 37.7739448697265 | -122.44562935764601 | (37.7739448697265, -122.445629357646) | |
| 76450 | 76450 | 32769 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37143 | 6000722.0176 | 2110255.3136 | 37.7743989310052 | -122.440964540315 | (37.7743989310052, -122.440964540315) | |
| 78778 | 78778 | 32819 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4226 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37178 | 6001698.63208525 | 2102367.69069452 | 37.7527970247899 | -122.437021433816 | (37.7527970247899, -122.437021433816) | ||
| 79610 | 79610 | 32821 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4251 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.43763927134898 | (37.7526166065877, -122.437639271349) | ||
| 79951 | 79951 | 32740 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 139 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37123 | 5995564.95354615 | 2088674.66529796 | 37.7148487646576 | -122.457242200681 | (37.7148487646576, -122.457242200681) | ||
| 79953 | 79953 | 32787 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1661 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37153 | 5999823.76126907 | 2110867.52212558 | 37.7760286983996 | -122.444115767373 | (37.7760286983996, -122.444115767373) | ||
| 82804 | 82804 | 32738 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 621 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37121 | 5995721.30828491 | 2089878.27647078 | 37.718162576672704 | -122.456788775002 | (37.7181625766727, -122.456788775002) | ||
| 84009 | 84009 | 32818 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4221 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37177 | 6001720.00837009 | 2102316.78849399 | 37.7526584745372 | -122.43694386703699 | (37.7526584745372, -122.436943867037) | ||
| 86699 | 86699 | 32726 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 20 | 6x9 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
| 86890 | 86890 | 32789 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1704 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 87175 | 87175 | 32705 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 890 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37106 | 6007466.88018988 | 2114411.93310855 | 37.7861938524183 | -122.417927449032 | (37.7861938524183, -122.417927449032) | ||
| 87697 | 87697 | 32782 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 562 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37150 | 5999722.28182672 | 2110402.40308686 | 37.7747458103684 | -122.444433375827 | (37.7747458103684, -122.444433375827) | ||
| 87708 | 87708 | 32729 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
| 90795 | 90795 | 32709 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 92432 | 92432 | 32708 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 94228 | 94228 | 32815 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3776 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37174 | 6003265.68805759 | 2103039.66308916 | 37.7547310484609 | -122.431650242785 | (37.7547310484609, -122.431650242785) | ||
| 94737 | 94737 | 32824 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4364 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37182 | 6000831.63245029 | 2102319.68885253 | 37.7526159050982 | -122.44001622789101 | (37.7526159050982, -122.440016227891) | ||
| 95253 | 95253 | 32807 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1686 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943364999 | (37.7742503589901, -122.44417943365) | ||
| 96226 | 96226 | 32739 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 137 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37122 | 5995581.47746257 | 2088674.4560737 | 37.7148491391882 | -122.45718507236099 | (37.7148491391882, -122.457185072361) | ||
| 96365 | 96365 | 32699 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 665 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37104 | 6008544.39382175 | 2114510.13304212 | 37.7865240684083 | -122.41420647278099 | (37.7865240684083, -122.414206472781) | ||
| 97938 | 97938 | 32702 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 890 Geary St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37106 | 6007466.88018988 | 2114411.93310855 | 37.7861938524183 | -122.417927449032 | (37.7861938524183, -122.417927449032) | ||
| 100833 | 100833 | 32757 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 100875 | 100875 | 32792 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1704 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 103254 | 103254 | 32781 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 562 Central Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | Permit Number 37150 | 5999722.28182672 | 2110402.40308686 | 37.7747458103684 | -122.444433375827 | (37.7747458103684, -122.444433375827) | |||
| 103890 | 103890 | 32822 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4251 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.43763927134898 | (37.7526166065877, -122.437639271349) | ||
| 105349 | 105349 | 32783 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 562 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | Permit Number 37150 | 5999722.28182672 | 2110402.40308686 | 37.7747458103684 | -122.444433375827 | (37.7747458103684, -122.444433375827) | |||
| 105848 | 105848 | 32749 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 108363 | 108363 | 32760 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) |
| 109535 | 109535 | 31636 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2542 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37115 | 5981513.83287394 | 2097774.63274006 | 37.73901780088121 | -122.506482350919 | (37.7390178008812, -122.506482350919) | ||
| 112161 | 112161 | 32720 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 644 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | |
| 112519 | 112519 | 32780 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 511 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | Permit Number 37149 | 5999694.36971508 | 2110224.65158975 | 37.774256157368896 | -122.444517151405 | (37.7742561573689, -122.444517151405) | |||
| 113295 | 113295 | 32826 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4452 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37184 | 6000342.06225756 | 2102290.12696939 | 37.7525068530823 | -122.44170712073601 | (37.7525068530823, -122.441707120736) | ||
| 113776 | 113776 | 32791 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1704 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 113946 | 113946 | 32761 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 33 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37136 | 5996219.65696769 | 2089595.16443256 | 37.7174138200875 | -122.455045760827 | (37.7174138200875, -122.455045760827) | ||
| 114187 | 114187 | 32724 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1082 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37114 | 6006978.17320306 | 2114692.47231461 | 37.786936628069796 | -122.419638162258 | (37.7869366280698, -122.419638162258) | ||
| 115718 | 115718 | 32721 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 644 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | |
| 118275 | 118275 | 32798 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1775 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37161 | 5999319.69882917 | 2110451.09414755 | 37.7748565251647 | -122.44582949005199 | (37.7748565251647, -122.445829490052) | ||
| 119045 | 119045 | 32752 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5995934.0 | 2088667.0 | 37.714848906239204 | -122.455966075921 | (37.7148489062392, -122.455966075921) | ||
| 119662 | 119662 | 32765 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 274 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | Permit Number 37139 | 5995268.23997636 | 2113729.87048347 | 37.783627009033395 | -122.46008182215401 | (37.7836270090334, -122.460081822154) | |||
| 121603 | 121603 | 32795 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1701 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37158 | 5999667.64263466 | 2110499.43513135 | 37.7750091179441 | -122.444629358923 | (37.7750091179441, -122.444629358923) | ||
| 121896 | 121896 | 32794 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1684 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37157 | 5999753.65885933 | 2110563.88510843 | 37.775190989119004 | -122.444336443795 | (37.775190989119, -122.444336443795) | ||
| 121957 | 121957 | 32817 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4206 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37176 | 6001816.47810923 | 2102374.17664459 | 37.7528215312962 | -122.436614365652 | (37.7528215312962, -122.436614365652) | ||
| 123867 | 123867 | 32734 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.71753977051271 | -122.45898327191601 | (37.7175397705127, -122.458983271916) | ||
| 124807 | 124807 | 32759 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 126457 | 126457 | 32748 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 128245 | 128245 | 32766 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1425 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | Permit Number 37140 | 5992392.88696964 | 2105748.05411767 | 37.7615452897816 | -122.469448152287 | (37.7615452897816, -122.469448152287) | |||
| 128278 | 128278 | 32806 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1686 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943364999 | (37.7742503589901, -122.44417943365) | ||
| 128770 | 128770 | 32764 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 274 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | Permit Number 37139 | 5995268.23997636 | 2113729.87048347 | 37.783627009033395 | -122.46008182215401 | (37.7836270090334, -122.460081822154) | |||
| 129508 | 129508 | 32801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1640 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37163 | 5999986.448 | 2110250.0303 | 37.7743425023806 | -122.443508626239 | (37.7743425023806, -122.443508626239) | |
| 132044 | 132044 | 32700 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 825 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 2 | Permit Number 37105 | 6007737.65529 | 2114399.67855 | 37.78617543968429 | -122.41698976718901 | (37.7861754396843, -122.416989767189) | |
| 135781 | 135781 | 32701 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 825 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 2 | Permit Number 37105 | 6007751.12413 | 2114399.04954 | 37.7861744702126 | -122.416943123843 | (37.7861744702126, -122.416943123843) | |
| 136490 | 136490 | 32775 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 538 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37145 | 6001149.8671 | 2110593.8127 | 37.7753527233612 | -122.439508802271 | (37.7753527233612, -122.439508802271) | |
| 138166 | 138166 | 32744 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 148 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | Permit Number 37127 | 5995478.73081 | 2089341.7479 | 37.716675464066604 | -122.457588457653 | (37.7166754640666, -122.457588457653) | |
| 138532 | 138532 | 32735 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 809 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37118 | 5995029.96287257 | 2089665.49407684 | 37.7175386053384 | -122.45916304432801 | (37.7175386053384, -122.459163044328) | ||
| 140772 | 140772 | 32771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.774318351022295 | -122.440968898129 | (37.7743183510223, -122.440968898129) | ||
| 141694 | 141694 | 32790 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1704 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 142172 | 142172 | 32696 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1106 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37103 | 6008183.16928689 | 2115554.72994823 | 37.7893719804943 | -122.415530208183 | (37.7893719804943, -122.415530208183) | ||
| 143853 | 143853 | 32707 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 145468 | 145468 | 32758 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 148766 | 148766 | 32714 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1105 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 14 | Permit Number 37110 | 6007282.5299 | 2115198.67905 | 37.7883436871578 | -122.418621065405 | (37.7883436871578, -122.418621065405) | |
| 151972 | 151972 | 32802 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1640 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | Permit Number 37163 | 5999966.1178 | 2110245.6106 | 37.7743292075557 | -122.443578634389 | (37.7743292075557, -122.443578634389) | |
| 152589 | 152589 | 32693 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3732 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37102 | 6004859.3884 | 2102538.49197 | 37.7534451551954 | -122.42610311279199 | (37.7534451551954, -122.426103112792) | ||
| 159116 | 159116 | 32706 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | |
| 160534 | 160534 | 32737 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 223 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 5 | Permit Number 37120 | 5994748.23288 | 2088380.2046599998 | 37.713993304422495 | -122.460043789395 | (37.7139933044225, -122.460043789395) | |
| 160619 | 160619 | 32715 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1105 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37110 | 6007284.26243 | 2115178.29888 | 37.788287825756704 | -122.418613625325 | (37.7882878257567, -122.418613625325) | |
| 162089 | 162089 | 32712 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1105 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 9 | Permit Number 37110 | 6007293.288380001 | 2115120.29233 | 37.788129062163 | -122.41857828198 | (37.788129062163, -122.41857828198) | |
| 164639 | 164639 | 32733 | Permitted Site 1 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 808 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 3 | Permit Number 37117 | 5995079.85691 | 2089730.42471 | 37.717719757737896 | -122.458995283333 | (37.7177197577379, -122.458995283333) | |
| 167083 | 167083 | 32805 | Permitted Site 1 | Tristania conferta :: 79 | 1690 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 18 | Permit Number 37166 | 5999795.9625 | 2110223.9545 | 37.774260039648 | -122.444165674595 | (37.774260039648, -122.444165674595) |
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");