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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12371 | 12371 | 37111 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.3894 | 2106160.9583 | 37.762061102870796 | -122.50611669707199 | (37.7620611028708, -122.506116697072) |
| 12388 | 12388 | 108548 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 231 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773712 | 6001628.81735 | 2093873.1155299998 | 37.7294689416254 | -122.436654875418 | (37.7294689416254, -122.436654875418) |
| 12410 | 12410 | 65623 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 185 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 18 | 3x3 | Permit Number 28530 | 6004571.295580001 | 2094064.8852900001 | 37.730162278453 | -122.426496085951 | (37.730162278453, -122.426496085951) |
| 12722 | 12722 | 117443 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 134 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778577 | 6004618.40487 | 2092601.87765 | 37.72614784693 | -122.42622910508601 | (37.72614784693, -122.426229105086) | ||
| 12946 | 12946 | 37109 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.7427 | 2106129.159 | 37.761973811904795 | -122.506113117253 | (37.7619738119048, -122.506113117253) |
| 13138 | 13138 | 117433 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 157 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776957 | 6000554.87359 | 2091671.7956400001 | 37.72336353237829 | -122.440209797466 | (37.7233635323783, -122.440209797466) | ||
| 13487 | 13487 | 108687 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.1046599997 | 37.756177459246295 | -122.400883423742 | (37.7561774592463, -122.400883423742) | |
| 13538 | 13538 | 42043 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 13680 | 13680 | 39555 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 15 | Permit Number 40979 | 6013094.503190001 | 2106943.24687 | 37.766001649682 | -122.397933106026 | (37.766001649682, -122.397933106026) | ||
| 13811 | 13811 | 3566 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018911.95106 | 2097439.80241 | 37.740229404572396 | -122.377152086609 | (37.7402294045724, -122.377152086609) | ||
| 13814 | 13814 | 10604 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 18 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6017010.864569999 | 2095475.59177 | 37.73473117440221 | -122.383588632512 | (37.7347311744022, -122.383588632512) | ||
| 13816 | 13816 | 3563 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018859.49817 | 2097478.39151 | 37.7403324731777 | -122.37733612657401 | (37.7403324731777, -122.377336126574) | ||
| 13846 | 13846 | 35283 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 14102 | 14102 | 3562 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018842.999 | 2097491.0611 | 37.7403663524293 | -122.37739405370701 | (37.7403663524293, -122.377394053707) | ||
| 14104 | 14104 | 39557 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013095.63903 | 2106895.18187 | 37.7658697371335 | -122.39792580534599 | (37.7658697371335, -122.397925805346) | ||
| 14191 | 14191 | 12216 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1523 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1992 12:00:00 AM | 15 | 3X3 | 6015935.5625 | 2095820.8342 | 37.735619647499 | -122.387330428498 | (37.735619647499, -122.387330428498) | ||
| 14314 | 14314 | 3560 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018809.63786 | 2097515.71259 | 37.7404322025979 | -122.377511114855 | (37.7404322025979, -122.377511114855) | ||
| 14614 | 14614 | 22513 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6424 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013017.34088 | 2090082.06317 | 37.7197001044495 | -122.39701766186 | (37.7197001044495, -122.39701766186) | |||
| 14684 | 14684 | 39553 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.35036 | 2107006.086 | 37.7661739606766 | -122.39795187847601 | (37.7661739606766, -122.397951878476) | ||
| 14754 | 14754 | 3564 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018876.34975 | 2097465.88877 | 37.740299071447794 | -122.377276992562 | (37.7402990714478, -122.377276992562) | ||
| 15040 | 15040 | 22433 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6000 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1992 12:00:00 AM | 3 | 3X3 | 6013569.5341 | 2091525.6902 | 37.723694738350396 | -122.395209983132 | (37.7236947383504, -122.395209983132) | ||
| 15055 | 15055 | 113527 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6013095.17315 | 2106916.8102 | 37.7659290977746 | -122.39792893408001 | (37.7659290977746, -122.39792893408) | ||||
| 15266 | 15266 | 39554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.01553 | 2106989.57845 | 37.7661286159676 | -122.397951878486 | (37.7661286159676, -122.397951878486) | ||
| 15269 | 15269 | 39556 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013089.54039 | 2107025.61956 | 37.7662275503778 | -122.397956050431 | (37.7662275503778, -122.397956050431) | ||
| 15519 | 15519 | 38776 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 660 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/2017 12:00:00 AM | 3 | Permit Number 779488 | 6014510.81012 | 2111730.04342 | 37.7792239033058 | -122.39336936232999 | (37.7792239033058, -122.39336936233) | |
| 15904 | 15904 | 42044 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16074 | 16074 | 22377 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5538 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014067.3893 | 2092832.2588 | 37.7273099879691 | -122.393580370471 | (37.7273099879691, -122.393580370471) | |||
| 16143 | 16143 | 3559 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018791.21625 | 2097528.24687 | 37.7404656043104 | -122.377575679878 | (37.7404656043104, -122.377575679878) | ||
| 16144 | 16144 | 3565 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018894.06666 | 2097453.02118 | 37.740264715549 | -122.37721484129601 | (37.740264715549, -122.377214841296) | ||
| 16190 | 16190 | 22512 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6424 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013020.80961 | 2090093.5041 | 37.719731712041 | -122.397006473368 | (37.719731712041, -122.397006473368) | |||
| 16213 | 16213 | 35285 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 16322 | 16322 | 42042 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16362 | 16362 | 22376 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5538 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014077.5103 | 2092853.4647 | 37.7273687774645 | -122.39354686543601 | (37.7273687774645, -122.393546865436) | |||
| 16500 | 16500 | 42041 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16594 | 16594 | 22437 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6025 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013597.3212 | 2091386.3105 | 37.7233135750036 | -122.39510416905 | (37.7233135750036, -122.39510416905) | |||
| 16775 | 16775 | 110930 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6013101.5791 | 2106846.11839 | 37.7657353505351 | -122.397901817734 | (37.7657353505351, -122.397901817734) | ||||
| 16886 | 16886 | 39481 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 17053 | 17053 | 10375 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1296 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2007 12:00:00 AM | 12 | 3X3 | 6000028.8313 | 2108866.5222 | 37.7705461558325 | -122.443262625265 | (37.7705461558325, -122.443262625265) | ||
| 17159 | 17159 | 18616 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992096.2291 | 2088496.6198 | 37.7141600639726 | -122.46921850171199 | (37.7141600639726, -122.469218501712) | |||
| 17161 | 17161 | 26495 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2007 12:00:00 AM | 6 | 3x3 | 6008885.38363 | 2102897.90727 | 37.754658753403504 | -122.412205713815 | (37.7546587534035, -122.412205713815) | ||
| 17218 | 17218 | 26701 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1055 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2002 12:00:00 AM | 3 | 3X3 | 6004445.56166 | 2102766.22763 | 37.754047066024704 | -122.427550437605 | (37.7540470660247, -122.427550437605) | ||
| 17238 | 17238 | 27425 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1296 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1999 12:00:00 AM | 12 | 3X3 | 6000045.435 | 2108867.471 | 37.7705497077728 | -122.44320526125601 | (37.7705497077728, -122.443205261256) | ||
| 17331 | 17331 | 26496 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008886.0848199995 | 2102878.04826 | 37.7546042643838 | -122.412201885424 | (37.7546042643838, -122.412201885424) | ||
| 17502 | 17502 | 18578 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 114 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993641.4878 | 2088544.8235 | 37.7143815912468 | -122.463881030417 | (37.7143815912468, -122.463881030417) | |||
| 17690 | 17690 | 18609 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 601 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5992399.8764 | 2088496.7733 | 37.714178026974395 | -122.468168999945 | (37.7141780269744, -122.468168999945) | |||
| 17855 | 17855 | 18594 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 400 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992917.5472 | 2088553.0754 | 37.7143625030062 | -122.466383834117 | (37.7143625030062, -122.466383834117) | |||
| 17955 | 17955 | 10276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004948.0554599995 | 2109498.71961 | 37.7725612966014 | -122.42629199289699 | (37.7725612966014, -122.426291992897) | |||
| 17981 | 17981 | 17200 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200X Olive St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006498.358440001 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | |||
| 18147 | 18147 | 56051 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.768410964941104 | -122.43229368198 | (37.7684109649411, -122.43229368198) | ||
| 18149 | 18149 | 60477 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1343 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | Permit Number 20072 | 6002221.27409585 | 2113110.91985101 | 37.7823249851452 | -122.435982713361 | (37.7823249851452, -122.435982713361) | ||
| 18440 | 18440 | 24552 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 400 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2002 12:00:00 AM | 18 | 3X3 | 6007194.9047 | 2097268.97601 | 37.739107975142495 | -122.41765291735202 | (37.7391079751425, -122.417652917352) | ||
| 18458 | 18458 | 17241 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 17X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993905.3882 | 2088478.8088 | 37.714215535169004 | -122.46296410647699 | (37.714215535169, -122.462964106477) | |||
| 18726 | 18726 | 4427 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1153-1157 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6004477.3384 | 2102149.60518 | 37.752355762318395 | -122.427396622076 | (37.7523557623184, -122.427396622076) | ||
| 18794 | 18794 | 46753 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.717519344442294 | -122.465247516931 | (37.7175193444423, -122.465247516931) | ||
| 18915 | 18915 | 45453 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
| 19497 | 19497 | 39128 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 755 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40809 | 6007359.12700155 | 2102919.00118427 | 37.7546309134503 | -122.41748542832899 | (37.7546309134503, -122.417485428329) | ||
| 19548 | 19548 | 4335 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 858 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2002 12:00:00 AM | 6 | 3X3 | 6001687.38643 | 2095877.23382 | 37.734975118199394 | -122.436595789974 | (37.7349751181994, -122.436595789974) | ||
| 19552 | 19552 | 50938 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4752 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | Permit Number 48543 | 5998450.03825367 | 2105698.06494287 | 37.7617562199837 | -122.44849544098601 | (37.7617562199837, -122.448495440986) | ||
| 19601 | 19601 | 64294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 369 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1988 12:00:00 AM | 11 | Permit Number 25100 | 6004186.81103281 | 2098943.74928531 | 37.743536789999396 | -122.428172863442 | (37.7435367899994, -122.428172863442) | |
| 19896 | 19896 | 26494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2007 12:00:00 AM | 6 | 3x3 | 6008885.74395 | 2102915.53934 | 37.7547071873106 | -122.412205713825 | (37.7547071873106, -122.412205713825) | ||
| 20014 | 20014 | 10374 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1292 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2001 12:00:00 AM | 6 | 3X3 | 6000060.6155 | 2108870.7918 | 37.7705596914501 | -122.44315299047199 | (37.7705596914501, -122.443152990472) | ||
| 20751 | 20751 | 18600 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1992 12:00:00 AM | 6 | 3X3 | 5992650.7421 | 2088555.8456 | 37.7143547106063 | -122.467306211311 | (37.7143547106063, -122.467306211311) | ||
| 20963 | 20963 | 10267 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 229X Haight St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | 6004928.575180001 | 2109497.01592 | 37.7725555175436 | -122.4263592559 | (37.7725555175436, -122.4263592559) | |||
| 21348 | 21348 | 26497 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2007 12:00:00 AM | 6 | 3x3 | 6008887.42951 | 2102862.58596 | 37.754561883845795 | -122.412196142362 | (37.7545618838458, -122.412196142362) | ||
| 21515 | 21515 | 18601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 509 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992650.5887 | 2088494.9319999998 | 37.7141874476643 | -122.467302314998 | (37.7141874476643, -122.467302314998) | |||
| 21751 | 21751 | 23680 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 322 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1996 12:00:00 AM | 6 | 3X3 | 6006869.809669999 | 2098126.1241900004 | 37.741443214134 | -122.418837724678 | (37.741443214134, -122.418837724678) | ||
| 22295 | 22295 | 41955 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2636 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | Permit Number 42312 | 5995181.79826 | 2110315.10722 | 37.7742460062216 | -122.460133402127 | (37.7742460062216, -122.460133402127) | |
| 22374 | 22374 | 9065 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5537 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989786.9858 | 2112602.3503 | 37.7802143684845 | -122.478962158407 | (37.7802143684845, -122.478962158407) | |||
| 22436 | 22436 | 9115 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5757 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989122.1167 | 2112578.7748 | 37.7801110053489 | -122.48126049209499 | (37.7801110053489, -122.481260492095) | |||
| 22442 | 22442 | 9062 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5525 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989837.7609 | 2112604.3144 | 37.7802227097378 | -122.478786649669 | (37.7802227097378, -122.478786649669) | |||
| 22458 | 22458 | 9163 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988313.9515 | 2112548.4697 | 37.7799807782466 | -122.484054045264 | (37.7799807782466, -122.484054045264) | |||
| 22523 | 22523 | 9112 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5731 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989195.2404 | 2112580.9255 | 37.7801211615255 | -122.481007684457 | (37.7801211615255, -122.481007684457) | |||
| 22568 | 22568 | 17777 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1770 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6005493.72272 | 2115526.88149 | 37.78914397766071 | -122.424833412132 | (37.7891439776607, -122.424833412132) | |||
| 22578 | 22578 | 17770 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1739 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2000 12:00:00 AM | 8 | 3x3 | 6005615.05829 | 2115496.7522400003 | 37.789068102766 | -122.42441146191999 | (37.789068102766, -122.42441146192) | ||
| 22613 | 22613 | 9164 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988336.7568 | 2112550.1465 | 37.779986709952794 | -122.48397527547199 | (37.7799867099528, -122.483975275472) | |||
| 22627 | 22627 | 17769 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1739 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6005596.16237 | 2115493.24585 | 37.789057408033294 | -122.42447658992901 | (37.7890574080333, -122.424476589929) | |||
| 22665 | 22665 | 9165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988358.8914 | 2112549.8112 | 37.779987077901204 | -122.48389867831101 | (37.7799870779012, -122.483898678311) | |||
| 22686 | 22686 | 9063 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5529 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989797.972999999 | 2112602.4325 | 37.7802152322039 | -122.478924155076 | (37.7802152322039, -122.478924155076) | |||
| 22688 | 22688 | 17767 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2000 12:00:00 AM | 4 | 3x3 | 6005655.45235 | 2115499.57318 | 37.7890781293118 | -122.424271904233 | (37.7890781293118, -122.424271904233) | ||
| 22703 | 22703 | 17768 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1731 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2000 12:00:00 AM | 5 | 3x3 | 6005639.06035 | 2115498.93652 | 37.7890754556083 | -122.424328573211 | (37.7890754556083, -122.424328573211) | ||
| 22722 | 22722 | 9130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5843 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988875.3243 | 2112569.0967 | 37.780070081021705 | -122.48211353976002 | (37.7800700810217, -122.48211353976) | |||
| 22740 | 22740 | 9192 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6138 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 5987910.6661 | 2112635.8342 | 37.780197169187296 | -122.485455585501 | (37.7801971691873, -122.485455585501) | |||
| 22752 | 22752 | 9190 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6128 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5987955.2707 | 2112636.8403 | 37.7802025302416 | -122.48530135353799 | (37.7802025302416, -122.485301353538) | |||
| 22758 | 22758 | 8985 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5133 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5991037.8127 | 2112647.8841 | 37.78041194791 | -122.474638342176 | (37.78041194791, -122.474638342176) | |||
| 22765 | 22765 | 9129 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5843 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988848.4406 | 2112566.946 | 37.7800626121426 | -122.482206383921 | (37.7800626121426, -122.482206383921) | |||
| 22791 | 22791 | 9166 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988380.3553 | 2112551.8234 | 37.7799938523312 | -122.483824573547 | (37.7799938523312, -122.483824573547) | |||
| 22842 | 22842 | 37547 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 830 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 12 | Permit Number 39987 | 6008602.44706 | 2115263.43418 | 37.788595711371 | -122.414058934193 | (37.788595711371, -122.414058934193) | |
| 22962 | 22962 | 110498 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1281 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774952 | 5987664.5 | 2106571.7 | 37.763532402594706 | -122.48586195153 | (37.7635324025947, -122.48586195153) | |
| 24041 | 24041 | 37545 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 830 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 7 | Permit Number 39987 | 6008632.80064 | 2115264.4241 | 37.788600134235 | -122.413953985086 | (37.788600134235, -122.413953985086) | |
| 24225 | 24225 | 50246 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1287 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 0 | Permit Number 46951 | 5985199.39967199 | 2106457.48369728 | 37.7630748403476 | -122.49437940567101 | (37.7630748403476, -122.494379405671) | |
| 24471 | 24471 | 42601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2554 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42671 | 6005368.83302 | 2118821.0293400004 | 37.798181821601894 | -122.425500047192 | (37.7981818216019, -122.425500047192) | |
| 24666 | 24666 | 32343 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | |||
| 25529 | 25529 | 81905 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2999 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50026 | 5999847.61488 | 2116692.12916 | 37.7920229215711 | -122.44445195079099 | (37.7920229215711, -122.444451950791) | |
| 25590 | 25590 | 32671 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 452 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51345 | 6011114.30345 | 2112004.56404 | 37.779788381657504 | -122.40513867842199 | (37.7797883816575, -122.405138678422) | |
| 26541 | 26541 | 89147 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1976 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51800 | 6004073.6651 | 2114987.5033 | 37.7875826714129 | -122.429708147405 | (37.7875826714129, -122.429708147405) | |
| 27072 | 27072 | 56279 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 315 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 13 | Permit Number 12405 | 5992132.31983 | 2113284.5962099996 | 37.7822235433325 | -122.470898359757 | (37.7822235433325, -122.470898359757) | ||
| 27324 | 27324 | 50494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 821 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2014 12:00:00 AM | 1 | Permit Number 772457 | 6003014.84349 | 2089242.8830799998 | 37.7168340244398 | -122.43153282718201 | (37.7168340244398, -122.431532827182) | |
| 27428 | 27428 | 42837 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1258 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2000 12:00:00 AM | 14 | Permit Number 42769 | 6005846.592759999 | 2120362.4898099997 | 37.8024412617221 | -122.423956527271 | (37.8024412617221, -122.423956527271) | ||
| 27488 | 27488 | 56319 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 255 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 11 | Permit Number 12454 | 5993047.12459 | 2113743.61417 | 37.7835367452404 | -122.467766966515 | (37.7835367452404, -122.467766966515) |
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");