Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 8280 | 8280 | 109193 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | |||||
| 9566 | 9566 | 95785 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 347 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767529 | ||||||
| 11029 | 11029 | 67936 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 78 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31649 | |||||||
| 11717 | 11717 | 61760 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3739 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21774 | |||||||
| 12866 | 12866 | 108593 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | |||||
| 15243 | 15243 | 109931 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2822 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775171 | |||||
| 22409 | 22409 | 249318 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 142348 | 142348 | 37363 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 399 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39869 | 5999946.93855513 | 2086126.88642813 | 37.7081038333344 | -122.441913518536 | (37.7081038333344, -122.441913518536) | ||
| 90821 | 90821 | 44385 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 185 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43746 | 6002329.42862952 | 2086131.81061029 | 37.708252829485296 | -122.433679745726 | (37.7082528294853, -122.433679745726) | ||
| 112948 | 112948 | 44386 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 185 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43746 | 6002329.42862952 | 2086131.81061029 | 37.708252829485296 | -122.433679745726 | (37.7082528294853, -122.433679745726) | ||
| 52762 | 52762 | 71598 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 126 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994743.91592 | 2086305.62835 | 37.70829675666771 | -122.45990852057301 | (37.7082967566677, -122.459908520573) | ||
| 72925 | 72925 | 37362 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 389 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | Permit Number 39868 | 5999904.39956 | 2086205.97532 | 37.7083185697068 | -122.44206621039899 | (37.7083185697068, -122.442066210399) | |
| 35802 | 35802 | 71599 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.45997012143101 | (37.7083363538073, -122.459970121431) | ||
| 161932 | 161932 | 72806 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 382 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 6 | 5999864.9815 | 2086214.70068 | 37.70834028115829 | -122.44220306922399 | (37.7083402811583, -122.442203069224) | ||
| 137279 | 137279 | 73608 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 14 | 5994710.3414 | 2086333.6948099998 | 37.7083718896252 | -122.46002658894899 | (37.7083718896252, -122.460026588949) | ||
| 159957 | 159957 | 71600 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994689.24707 | 2086354.8441299999 | 37.708428747449204 | -122.460101024051 | (37.7084287474492, -122.460101024051) | ||
| 165215 | 165215 | 44743 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 306 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 5 | Permit Number 43861 | 5992021.82053 | 2086414.86847 | 37.7084397758389 | -122.469324250627 | (37.7084397758389, -122.469324250627) | |
| 63245 | 63245 | 71602 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 149 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994628.01123 | 2086360.41662 | 37.7084405258897 | -122.46031306439899 | (37.7084405258897, -122.460313064399) | ||
| 55464 | 55464 | 74182 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994679.00139 | 2086362.0842900001 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | ||
| 65128 | 65128 | 73960 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994666.9696 | 2086372.6899 | 37.7084764663958 | -122.46017930913601 | (37.7084764663958, -122.460179309136) | ||
| 136095 | 136095 | 71601 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994653.0975 | 2086384.07363 | 37.708506925528795 | -122.46022807666401 | (37.7085069255288, -122.460228076664) | ||
| 132730 | 132730 | 71684 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 163 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994555.12862 | 2086427.38157 | 37.7086202032335 | -122.46056980286501 | (37.7086202032335, -122.460569802865) | ||
| 58676 | 58676 | 49770 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 333 Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | ||
| 77656 | 77656 | 49766 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 333 Schwerin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | ||
| 179770 | 179770 | 71586 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | ||
| 4189 | 4189 | 44396 | Permitted Site 1 | Platanus occidentalis :: American sycamore 222 | 559 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/2017 01:07:00 PM | 3 | Permit Number 43752 | 6002175.43694 | 2086285.4696900002 | 37.708666004812606 | -122.43422293503599 | (37.7086660048126, -122.434222935036) | |
| 140169 | 140169 | 44397 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 565 Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43752 | 6002176.67433037 | 2086290.72530889 | 37.708680505828205 | -122.43421903392901 | (37.7086805058282, -122.434219033929) | ||
| 57495 | 57495 | 71603 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 171 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994523.67906 | 2086453.64687 | 37.708690512219206 | -122.460680397897 | (37.7086905122192, -122.460680397897) | ||
| 170302 | 170302 | 71651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 177 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994505.19973 | 2086471.6739 | 37.7087389470079 | -122.46074556997101 | (37.7087389470079, -122.460745569971) | ||
| 68899 | 68899 | 71587 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 129 Goethe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994891.94658 | 2086476.6908099998 | 37.7087749666595 | -122.459409293405 | (37.7087749666595, -122.459409293405) | ||
| 165253 | 165253 | 73605 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 129 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994880.25496 | 2086485.81008 | 37.7087993338054 | -122.459450360941 | (37.7087993338054, -122.459450360941) | ||
| 184578 | 184578 | 71588 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 133 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994866.39831 | 2086497.9329400002 | 37.7088318236054 | -122.45949912847999 | (37.7088318236054, -122.45949912848) | ||
| 131950 | 131950 | 71605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 178 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994512.31694 | 2086511.3564 | 37.7088483153534 | -122.46072384594 | (37.7088483153534, -122.46072384594) | ||
| 87790 | 87790 | 32047 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
| 140871 | 140871 | 32046 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
| 174882 | 174882 | 71606 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 182 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 13 | 5994495.515430001 | 2086527.6412 | 37.708892062899 | -122.460783093263 | (37.708892062899, -122.460783093263) | ||
| 58862 | 58862 | 37345 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39853 | 5998100.18965 | 2086460.63765 | 37.7089148310191 | -122.448320064445 | (37.7089148310191, -122.448320064445) | |
| 61136 | 61136 | 71581 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 237 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994022.886390001 | 2086563.0023 | 37.70896195100121 | -122.46241911655301 | (37.7089619510012, -122.462419116553) | ||
| 180245 | 180245 | 44388 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 11 | Permit Number 43748 | 6002261.2315 | 2086392.26553 | 37.708964112084104 | -122.433934046742 | (37.7089641120841, -122.433934046742) | |
| 41117 | 41117 | 71607 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 190 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 5994457.91424 | 2086560.2946 | 37.708979557936104 | -122.46091541234199 | (37.7089795579361, -122.460915412342) | ||
| 156176 | 156176 | 44741 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 271 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 3 | Permit Number 43859 | 5992054.55445 | 2086618.7004799999 | 37.7090013413078 | -122.46922594483601 | (37.7090013413078, -122.469225944836) | |
| 34347 | 34347 | 44742 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 276 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43860 | 5992023.15498 | 2086637.27235 | 37.7090505207416 | -122.469335815893 | (37.7090505207416, -122.469335815893) | |
| 106047 | 106047 | 44443 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 287 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43774 | 6003431.81812286 | 2086404.88677332 | 37.7090651281705 | -122.429889231519 | (37.7090651281705, -122.429889231519) | ||
| 138881 | 138881 | 109056 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 340 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772773 | 5999449.8 | 2086496.1 | 37.7090892698694 | -122.443658181084 | (37.7090892698694, -122.443658181084) |
| 160291 | 160291 | 44444 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 287 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 9 | Permit Number 43774 | 6003411.70926 | 2086434.98288 | 37.7091466267865 | -122.429960876109 | (37.7091466267865, -122.429960876109) | |
| 179575 | 179575 | 49771 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46559 | 6008634.11039 | 2086335.4029299999 | 37.70916757830379 | -122.411904362692 | (37.7091675783038, -122.411904362692) | |
| 162722 | 162722 | 44442 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 287 South Hill Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 14 | Permit Number 43774 | 6003408.0203599995 | 2086444.2343400002 | 37.7091718203864 | -122.429974284999 | (37.7091718203864, -122.429974284999) | |
| 174356 | 174356 | 48963 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 525 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 6 | Permit Number 46149 | 6002117.50475 | 2086471.6865299998 | 37.7091740273275 | -122.434436461075 | (37.7091740273275, -122.434436461075) | |
| 113751 | 113751 | 31059 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34810 | 6001654.06728241 | 2086489.02532865 | 37.7091953182451 | -122.43603940951598 | (37.7091953182451, -122.436039409516) |
| 140557 | 140557 | 109055 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 320 Hanover St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772693 | 5999569.6 | 2086544.4 | 37.70922872292179 | -122.443247602414 | (37.7092287229218, -122.443247602414) | |
| 30981 | 30981 | 71589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994699.454059999 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | ||
| 146572 | 146572 | 73606 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 40 Rhine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994431.8230800005 | 2086668.6372599998 | 37.7092755401168 | -122.461013433922 | (37.7092755401168, -122.461013433922) | ||
| 35468 | 35468 | 49765 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46559 | 6008653.27394 | 2086377.17589 | 37.7092833534188 | -122.411841080097 | (37.7092833534188, -122.411841080097) | |
| 157475 | 157475 | 78846 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 259 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2001 12:00:00 AM | 4 | 5992056.72748 | 2086721.95578 | 37.7092849811889 | -122.46922594483101 | (37.7092849811889, -122.469225944831) | ||
| 68733 | 68733 | 31023 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34788 | 6002794.80361 | 2086503.3822400002 | 37.7092994800486 | -122.43209787574 | (37.7092994800486, -122.43209787574) | |
| 163068 | 163068 | 71608 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 250 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994331.5401 | 2086682.33238 | 37.7093073724942 | -122.46136101741502 | (37.7093073724942, -122.461361017415) | ||
| 55122 | 55122 | 71593 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 34 Rhine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994443.94493 | 2086683.2861799998 | 37.70931646014839 | -122.46097260021001 | (37.7093164601484, -122.46097260021) | ||
| 31008 | 31008 | 49769 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46559 | 6008658.89925 | 2086391.1157900002 | 37.70932194511621 | -122.411822622426 | (37.7093219451162, -122.411822622426) | |
| 166100 | 166100 | 71685 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994260.16312 | 2086694.7455400003 | 37.7093373478025 | -122.461608605251 | (37.7093373478025, -122.461608605251) | ||
| 178402 | 178402 | 31022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34788 | 6002783.56511 | 2086520.12567 | 37.7093448166924 | -122.43213791266001 | (37.7093448166924, -122.43213791266) | |
| 59244 | 59244 | 71583 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5993925.4185 | 2086705.1573599998 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | ||
| 47789 | 47789 | 73626 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994249.9774400005 | 2086699.51142 | 37.7093498474797 | -122.461644153659 | (37.7093498474797, -122.461644153659) | ||
| 157971 | 157971 | 49772 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 6 | Permit Number 46559 | 6008665.3182 | 2086406.55888 | 37.7093647087858 | -122.41180152792299 | (37.7093647087858, -122.411801527923) | |
| 4393 | 4393 | 71591 | Undocumented 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 187 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 11:19:00 AM | 3 | 5994642.6055 | 2086698.5979 | 37.709369932055004 | -122.460287110874 | (37.709369932055, -122.460287110874) | ||
| 131156 | 131156 | 44387 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 330 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 13 | Permit Number 43747 | 6002496.67334 | 2086552.28846 | 37.7094168586614 | -122.433131752528 | (37.7094168586614, -122.433131752528) | |
| 24972 | 24972 | 49768 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 7 | Permit Number 46559 | 6008671.05987 | 2086426.1944 | 37.7094189460104 | -122.411783070238 | (37.7094189460104, -122.411783070238) | |
| 70259 | 70259 | 71645 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 193 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994617.0264 | 2086718.3617900002 | 37.7094227276519 | -122.460376946856 | (37.7094227276519, -122.460376946856) | ||
| 110069 | 110069 | 44384 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 55 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43745 | 6003000.77537648 | 2086551.46572633 | 37.709443182460106 | -122.43138943502399 | (37.7094431824601, -122.431389435024) | ||
| 112825 | 112825 | 44383 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 55 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43745 | 6003000.77537648 | 2086551.46572633 | 37.709443182460106 | -122.43138943502399 | (37.7094431824601, -122.431389435024) | ||
| 33600 | 33600 | 49767 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 7 | Permit Number 46559 | 6008676.28834 | 2086439.38255 | 37.7094554512839 | -122.41176593097 | (37.7094554512839, -122.41176593097) | |
| 135069 | 135069 | 71610 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 265 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994208.54554 | 2086740.2113599998 | 37.7094592149285 | -122.46179029709499 | (37.7094592149285, -122.461790297095) | ||
| 64137 | 64137 | 75992 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 188 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994660.40681 | 2086732.9831599998 | 37.7094653698917 | -122.46022807666401 | (37.7094653698917, -122.460228076664) | ||
| 126555 | 126555 | 44445 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 41 Toyon Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43775 | 6003205.02185069 | 2086565.08055066 | 37.7094921393696 | -122.430684496452 | (37.7094921393696, -122.430684496452) | ||
| 73045 | 73045 | 31021 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 317 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34787 | 6002776.11429 | 2086581.1916200002 | 37.7095120680942 | -122.432168021935 | (37.7095120680942, -122.432168021935) | |
| 178309 | 178309 | 31056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Toyon Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34808 | 6003244.645880001 | 2086572.31488 | 37.7095142480656 | -122.430548065039 | (37.7095142480656, -122.430548065039) | |
| 135030 | 135030 | 75408 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994441.08765 | 2086786.6315099997 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | ||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 149098 | 149098 | 75250 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994476.95751 | 2086787.3271700002 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | ||
| 36293 | 36293 | 71578 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 94X De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 13 | 5994610.40755 | 2086820.2353700001 | 37.709702067873 | -122.460407199135 | (37.709702067873, -122.460407199135) | ||
| 11149 | 11149 | 61515 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 84 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 21471 | 5994704.395 | 2086819.71376 | 37.7097060419596 | -122.46008232624901 | (37.7097060419596, -122.460082326249) |
| 10329 | 10329 | 109051 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772570 | 5995048.30925 | 2086814.9244099997 | 37.7097126663738 | -122.45889335865 | (37.7097126663738, -122.45889335865) |
| 58904 | 58904 | 44740 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 235 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 5 | Permit Number 43858 | 5992059.17709 | 2086878.10482 | 37.7097138705641 | -122.469228836168 | (37.7097138705641, -122.469228836168) | |
| 175458 | 175458 | 31001 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34778 | 6002746.71825 | 2086679.2341 | 37.709779604712 | -122.43227661689899 | (37.709779604712, -122.432276616899) | |
| 148621 | 148621 | 37360 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 256 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | Permit Number 39866 | 5999649.26348 | 2086749.4239700001 | 37.7097962152035 | -122.44298698756 | (37.7097962152035, -122.44298698756) | |
| 111474 | 111474 | 98267 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994599.8 | 2086859.2 | 37.7098084453918 | -122.460446681932 | (37.7098084453918, -122.460446681932) | |||
| 84745 | 84745 | 31004 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | ||
| 99162 | 99162 | 31003 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | ||
| 113292 | 113292 | 31002 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | ||
| 72054 | 72054 | 31019 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 239 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 7 | Permit Number 43764 | 6002675.61901 | 2086708.2112 | 37.7098551378742 | -122.43252441698401 | (37.7098551378742, -122.432524416984) | |
| 67527 | 67527 | 31020 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 239 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 7 | Permit Number 43764 | 6002665.06815 | 2086718.08858 | 37.70988166068479 | -122.432561587743 | (37.7098816606848, -122.432561587743) | |
| 179704 | 179704 | 44738 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 224 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 6 | Permit Number 43855 | 5992028.811919999 | 2086945.8058900002 | 37.7098980067533 | -122.46933870721901 | (37.7098980067533, -122.469338707219) | |
| 134606 | 134606 | 44739 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 227 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 11 | Permit Number 43856 | 5992060.248430001 | 2086948.89288 | 37.709908299502004 | -122.469230282263 | (37.709908299502, -122.469230282263) | |
| 82368 | 82368 | 31007 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34781 | 6001462.17793128 | 2086756.21041895 | 37.7099180463866 | -122.43672172056601 | (37.7099180463866, -122.436721720566) | ||
| 116313 | 116313 | 52513 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48618 | 5997208.37126376 | 2086857.00593017 | 37.709952140530895 | -122.451430868837 | (37.7099521405309, -122.451430868837) | ||
| 40596 | 40596 | 69408 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33513 | 6001538.598040001 | 2086768.9797900002 | 37.7099574510375 | -122.43645851206301 | (37.7099574510375, -122.436458512063) | |
| 117477 | 117477 | 37344 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 571 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39852 | 5999120.28976365 | 2086823.35415522 | 37.7099690371181 | -122.444820521553 | (37.7099690371181, -122.444820521553) | ||
| 10689 | 10689 | 44737 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 220 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 10 | Permit Number 43854 | 5992028.1183 | 2086972.4785799999 | 37.7099712034746 | -122.469343044645 | (37.7099712034746, -122.469343044645) | |
| 169684 | 169684 | 81047 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 961 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 2 | 6001634.7016900005 | 2086773.55642 | 37.7099754779527 | -122.436126687404 | (37.7099754779527, -122.436126687404) |
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");