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) | ||
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) | ||
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) | ||
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) | |
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
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) | ||
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) | ||
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) | |
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) | ||
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) | |
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) | |
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) | ||
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) | |
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) | |
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) | |
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) | ||
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) | ||
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) | |
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) | |
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) | |
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) | ||
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) | |
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) | ||
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) | |
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) | ||
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) |
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) |
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) | ||
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) | |
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) | ||
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) | |
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) | ||
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) | |
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) | ||
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) | |
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) | ||
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) | ||
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) | ||
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) | |
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) | |
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) | |
34901 | 34901 | 108776 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
80279 | 80279 | 108768 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
80792 | 80792 | 108763 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
84811 | 84811 | 108770 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
97559 | 97559 | 108774 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
103563 | 103563 | 108764 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
103669 | 103669 | 108777 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
103975 | 103975 | 108778 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
114658 | 114658 | 108766 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
115794 | 115794 | 108772 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
115978 | 115978 | 108771 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
122059 | 122059 | 108765 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
126629 | 126629 | 108762 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
127494 | 127494 | 108775 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
128675 | 128675 | 108767 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
144398 | 144398 | 108769 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
145235 | 145235 | 108773 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
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) | |
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) | ||
12503 | 12503 | 93870 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012462.01959 | 2086667.4072599998 | 37.7102932120209 | -122.398697717749 | (37.7102932120209, -122.398697717749) |
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) | ||
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) | |
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) | ||
13070 | 13070 | 93869 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012466.99875 | 2086683.8296 | 37.7103385819422 | -122.398681660343 | (37.7103385819422, -122.398681660343) |
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
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) | ||
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) |
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");