Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10358 | 10358 | 37108 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981801.156 | 2106110.4328 | 37.761922478322504 | -122.506106840747 | (37.7619224783225, -122.506106840747) |
| 10463 | 10463 | 37110 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981797.2694 | 2106191.6975 | 37.762145379104204 | -122.506126308526 | (37.7621453791042, -122.506126308526) |
| 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) |
| 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) |
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 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) | |
| 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) | |
| 22988 | 22988 | 70383 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | ||
| 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) | |
| 24362 | 24362 | 73557 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 15 | 5982628.313080001 | 2110748.29603 | 37.774705372511704 | -122.50358954053301 | (37.7747053725117, -122.503589540533) | ||
| 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) | |
| 26122 | 26122 | 70370 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.50148010954901 | (37.7594698688276, -122.501480109549) | ||
| 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) | |
| 28219 | 28219 | 37594 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 654 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 7 | Permit Number 40022 | 5992572.16946 | 2111004.39481 | 37.77598815854871 | -122.46921067863701 | (37.7759881585487, -122.469210678637) | |
| 28481 | 28481 | 48583 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1172 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | 6 | Permit Number 45898 | 6008021.61269 | 2118241.60717 | 37.7967404007911 | -122.41627955815599 | (37.7967404007911, -122.416279558156) | |
| 28604 | 28604 | 68272 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 507 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | Permit Number 32079 | 6008804.98345 | 2093624.18713 | 37.7291906419342 | -122.41182849499901 | (37.7291906419342, -122.411828494999) | |
| 29115 | 29115 | 68565 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 599 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32455 | 5981915.91303 | 2111733.97216 | 37.777369840379 | -122.50612693446101 | (37.777369840379, -122.506126934461) | |
| 29988 | 29988 | 43145 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 236 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42958 | 6005927.09779 | 2092636.0306099998 | 37.7263155084296 | -122.421707446054 | (37.7263155084296, -122.421707446054) | |
| 31721 | 31721 | 95829 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 174 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767563 | 6010460.23417 | 2110421.60059 | 37.775405346827 | -122.407289780317 | (37.775405346827, -122.407289780317) |
| 32005 | 32005 | 71215 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2143 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 7 | 5988194.3764 | 2100717.2109 | 37.747488416956394 | -122.483600053104 | (37.7474884169564, -122.483600053104) | ||
| 32054 | 32054 | 42625 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1844 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42683 | 6004409.1039 | 2115238.2303 | 37.7882900931927 | -122.42856547432 | (37.7882900931927, -122.42856547432) | |
| 32285 | 32285 | 43048 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2159 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 8 | Permit Number 42902 | 5983545.7781 | 2100465.2765 | 37.7465249999307 | -122.499655734442 | (37.7465249999307, -122.499655734442) | |
| 32735 | 32735 | 43177 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 350 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 10 | Permit Number 42983 | 6005845.02194 | 2093325.28285 | 37.72820341563 | -122.422040121459 | (37.72820341563, -122.422040121459) | |
| 32839 | 32839 | 68698 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 160 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 3 | Permit Number 32610 | 5991831.2696 | 2114389.80438 | 37.7852407247155 | -122.47202042920401 | (37.7852407247155, -122.472020429204) | |
| 33616 | 33616 | 69029 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1423 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 8 | Permit Number 33035 | 5984615.7707 | 2105488.0931 | 37.7603789927974 | -122.49632641947399 | (37.7603789927974, -122.496326419474) | |
| 33923 | 33923 | 88402 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 824 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53739 | 6009046.47564 | 2119079.80908 | 37.79909947181571 | -122.412792574519 | (37.7990994718157, -122.412792574519) |
| 34398 | 34398 | 47890 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | 3 | Permit Number 45634 | 5982786.5099 | 2105823.423 | 37.7611923862045 | -122.502677699679 | (37.7611923862045, -122.502677699679) | |
| 34894 | 34894 | 38426 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 126 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1999 12:00:00 AM | Permit Number 41732 | 6001233.109597 | 2094965.61225629 | 37.7324461904854 | -122.43810110094299 | (37.7324461904854, -122.438101100943) | ||
| 35431 | 35431 | 42872 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2571 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42796 | 5986433.5303 | 2097767.9425 | 37.739287865011605 | -122.48947203167299 | (37.7392878650116, -122.489472031673) | |
| 35629 | 35629 | 70375 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | ||
| 35658 | 35658 | 47179 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 201 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 5 | 4.5x6 | Permit Number 45142 | 5987713.91556 | 2114534.37085 | 37.785398546448995 | -122.486275645325 | (37.785398546449, -122.486275645325) |
| 36078 | 36078 | 43178 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1537 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42984 | 6006296.5432 | 2092934.0049700001 | 37.7271545075605 | -122.420451430388 | (37.7271545075605, -122.420451430388) | |
| 36317 | 36317 | 108395 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 311 Ordway St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6011028.372719999 | 2090050.89786 | 37.7195036115824 | -122.403890660433 | (37.7195036115824, -122.403890660433) | ||
| 36522 | 36522 | 43683 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 675 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 9 | Permit Number 43326 | 5994390.52222 | 2110930.65455 | 37.7758905913229 | -122.462915215949 | (37.7758905913229, -122.462915215949) | |
| 36837 | 36837 | 37619 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 522 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45363 | 5990650.98195 | 2111800.44887 | 37.7780627029466 | -122.475914650197 | (37.7780627029466, -122.475914650197) | |
| 36854 | 36854 | 61552 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1236 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2014 12:00:00 AM | 1 | Permit Number 772878 | 6012212.2651 | 2102631.23615 | 37.7541126481909 | -122.400681658131 | (37.7541126481909, -122.400681658131) | |
| 36870 | 36870 | 74231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2054 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 2 | 6009468.6226 | 2120763.8774 | 37.8037471914209 | -122.411450838489 | (37.8037471914209, -122.411450838489) | ||
| 36936 | 36936 | 78310 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 542 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 9 | 6002972.7622 | 2090478.24127 | 37.7202236600817 | -122.43176643509399 | (37.7202236600817, -122.431766435094) | ||
| 37757 | 37757 | 31048 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34804 | 6002823.26013 | 2087491.091 | 37.7120131267777 | -122.432070011132 | (37.7120131267777, -122.432070011132) | |
| 38009 | 38009 | 35479 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 810 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1998 12:00:00 AM | 11 | Permit Number 38891 | 6008353.20101 | 2093612.67362 | 37.7291336725688 | -122.413389536403 | (37.7291336725688, -122.413389536403) | |
| 39569 | 39569 | 43766 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 509 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43401 | 5990292.136609999 | 2111875.33871 | 37.778247517131796 | -122.477161485772 | (37.7782475171318, -122.477161485772) | |
| 40102 | 40102 | 35390 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 772 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 3 | Permit Number 38844 | 6012700.6062199995 | 2103940.5742099998 | 37.7577350292672 | -122.399084742776 | (37.7577350292672, -122.399084742776) | |
| 40385 | 40385 | 52938 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 46 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 6 | Permit Number 48925 | 6001865.98716 | 2092261.2406099997 | 37.7250565744922 | -122.43571968122299 | (37.7250565744922, -122.435719681223) | |
| 40489 | 40489 | 49942 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2422@ TARAVAL 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 5 | Permit Number 46700 | 5986754.8629 | 2098754.0466 | 37.742014198797 | -122.488433474546 | (37.742014198797, -122.488433474546) | |
| 40976 | 40976 | 78176 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 245 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53841 | 5992422.135430001 | 2113822.22224 | 37.783716473754 | -122.469934893245 | (37.783716473754, -122.469934893245) |
| 41012 | 41012 | 52441 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2231 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 7 | Permit Number 48552 | 6002319.04609 | 2115938.04243 | 37.7900930969695 | -122.43584681030501 | (37.7900930969695, -122.435846810305) | |
| 41105 | 41105 | 30844 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 238 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 9 | Permit Number 34692 | 5999056.13874 | 2115758.2343900003 | 37.7894135017764 | -122.44712321518499 | (37.7894135017764, -122.447123215185) | |
| 41369 | 41369 | 51276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 482 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 4 | Permit Number 47651 | 5990021.33138 | 2112081.55633 | 37.778798018484004 | -122.47811337118999 | (37.778798018484, -122.47811337119) | |
| 41686 | 41686 | 48671 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 753 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46610 | 6011587.55769 | 2104839.3424400003 | 37.7601407580013 | -122.40299736025 | (37.7601407580013, -122.40299736025) | |
| 41919 | 41919 | 50031 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 347 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 6 | Permit Number 46763 | 6008779.58166 | 2094534.76231 | 37.7316894612825 | -122.411980634224 | (37.7316894612825, -122.411980634224) | |
| 41953 | 41953 | 78551 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | ||
| 42009 | 42009 | 38710 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1996 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 6 | Permit Number 40615 | 5999645.261 | 2111241.3734 | 37.7770450137925 | -122.44476012317 | (37.7770450137925, -122.44476012317) | |
| 42364 | 42364 | 47180 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 201 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 6 | 4.5x6 | Permit Number 45142 | 5987712.19156 | 2114577.7012 | 37.7855174187324 | -122.48628479195601 | (37.7855174187324, -122.486284791956) |
| 42725 | 42725 | 78364 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 426 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6002109.01666 | 2091133.31338 | 37.721973341483995 | -122.43479893283701 | (37.721973341484, -122.434798932837) | ||
| 42941 | 42941 | 51398 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 409 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 7 | Permit Number 47725 | 6011224.1618 | 2112342.5923099997 | 37.780722669343206 | -122.404782432666 | (37.7807226693432, -122.404782432666) | |
| 42958 | 42958 | 49805 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1142SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 9 | Permit Number 46600 | 6014194.882780001 | 2105753.61687 | 37.7627964083541 | -122.394043799009 | (37.7627964083541, -122.394043799009) | |
| 43422 | 43422 | 47856 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1379 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | 4x8 | Permit Number 45615 | 5982744.6528 | 2105747.7948 | 37.7609822727886 | -122.502816864592 | (37.7609822727886, -122.502816864592) |
| 44376 | 44376 | 50205 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 615@ ANZA 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 6 | Permit Number 46913 | 5987501.56925 | 2111753.94334 | 37.777751903527104 | -122.486806042087 | (37.7777519035271, -122.486806042087) | |
| 45023 | 45023 | 45541 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3300 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44296 | 5988715.44051 | 2095267.2958099998 | 37.732554688228795 | -122.481399213927 | (37.7325546882288, -122.481399213927) | |
| 45253 | 45253 | 66571 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 269 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 9 | Permit Number 29760 | 6002938.60911 | 2091863.04833 | 37.7240240961129 | -122.431983324585 | (37.7240240961129, -122.431983324585) | |
| 47308 | 47308 | 31298 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1718 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 8 | Permit Number 43850 | 5989075.352000001 | 2103610.9593 | 37.7554851201375 | -122.480765550046 | (37.7554851201375, -122.480765550046) | |
| 47671 | 47671 | 47851 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1238 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 5 | Permit Number 45610 | 5983067.6301 | 2106694.7653 | 37.7636013609659 | -122.501769909969 | (37.7636013609659, -122.501769909969) | |
| 49173 | 49173 | 69441 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 598 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 7 | Permit Number 33548 | 6013520.05596 | 2111448.24133 | 37.7783950440445 | -122.39677705272699 | (37.7783950440445, -122.396777052727) | |
| 49226 | 49226 | 45516 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2975 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | Permit Number 44280 | 5988544.38188689 | 2095413.25132317 | 37.7329454972405 | -122.482001286035 | (37.7329454972405, -122.482001286035) | ||
| 49615 | 49615 | 61791 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1243 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 13 | Permit Number 21814 | 6011992.65884 | 2102590.77396 | 37.753989297192796 | -122.40143827126002 | (37.7539892971928, -122.40143827126) | |
| 49991 | 49991 | 45543 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3300 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44296 | 5988727.593669999 | 2095266.58975 | 37.7325534561717 | -122.481357146331 | (37.7325534561717, -122.481357146331) | |
| 50041 | 50041 | 65382 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.786327487826206 | -122.44189839388599 | (37.7863274878262, -122.441898393886) | |
| 50107 | 50107 | 35980 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 349 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39134 | 6006399.96537133 | 2097866.62265006 | 37.740704214618 | -122.420443871581 | (37.740704214618, -122.420443871581) | ||
| 51064 | 51064 | 35735 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 322 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | 10 | Permit Number 39010 | 6008978.78205 | 2094418.18322 | 37.7313805342643 | -122.411283723474 | (37.7313805342643, -122.411283723474) | |
| 51282 | 51282 | 38213 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 131 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 10 | Permit Number 40336 | 6011149.37196 | 2092494.3008700002 | 37.7262194527653 | -122.403644234494 | (37.7262194527653, -122.403644234494) | |
| 51960 | 51960 | 83691 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 8 | 6004196.42852 | 2092337.1873 | 37.725397205294705 | -122.427669003321 | (37.7253972052947, -122.427669003321) | ||
| 51984 | 51984 | 47234 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 327 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 5 | Permit Number 45177 | 6005796.76676 | 2092182.16383 | 37.725061938938296 | -122.422125764794 | (37.7250619389383, -122.422125764794) | |
| 52027 | 52027 | 79191 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1750 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 10 | 6011751.02985 | 2092731.7740599997 | 37.7269050958844 | -122.401581006276 | (37.7269050958844, -122.401581006276) | ||
| 52134 | 52134 | 45597 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1770 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2001 12:00:00 AM | 7 | Permit Number 44332 | 5985361.4044 | 2103173.351 | 37.7540670019119 | -122.493577094797 | (37.7540670019119, -122.493577094797) | |
| 52483 | 52483 | 50498 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 924 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 6 | Permit Number 47135 | 6002542.62317 | 2088276.7856400001 | 37.714154557357396 | -122.433096072852 | (37.7141545573574, -122.433096072852) | |
| 52664 | 52664 | 75651 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 594 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1993 12:00:00 AM | 7 | 5990000.19108 | 2111343.54291 | 37.7767704107746 | -122.47813253045 | (37.7767704107746, -122.47813253045) | ||
| 52965 | 52965 | 43154 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 175 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | 3 | Permit Number 45749 | 6006162.31236 | 2093033.7149099999 | 37.72742072396429 | -122.42092254204901 | (37.7274207239643, -122.420922542049) | |
| 54043 | 54043 | 42969 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1150 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 11 | Permit Number 42856 | 6007967.99482 | 2092048.35205 | 37.7248167450851 | -122.41461057472799 | (37.7248167450851, -122.414610574728) | |
| 54755 | 54755 | 71633 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 666 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983841.90754 | 2111286.39703 | 37.7762541180901 | -122.49943131186501 | (37.7762541180901, -122.499431311865) | ||
| 55778 | 55778 | 31100 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 23 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34830 | 6000065.10853 | 2093953.30855 | 37.729600144630496 | -122.44206650716801 | (37.7296001446305, -122.442066507168) | |
| 56980 | 56980 | 42624 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1838 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42682 | 6004413.9764 | 2115198.364 | 37.788180906101 | -122.42854577347201 | (37.788180906101, -122.428545773472) | |
| 57119 | 57119 | 30836 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 115 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | 2 | Permit Number 34685 | 6005037.93149 | 2099286.8892099997 | 37.744527093756396 | -122.425254310132 | (37.7445270937564, -122.425254310132) | |
| 57589 | 57589 | 64167 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | 1 | Permit Number 774327 | 5992846.00253 | 2111993.1861900003 | 37.77871893161171 | -122.468335378215 | (37.7787189316117, -122.468335378215) |
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");