Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106760 | 106760 | 99309 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.49918869137501 | (37.7494969779561, -122.499188691375) | ||
| 58682 | 58682 | 116625 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 6 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 84743 | 84743 | 116631 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 12 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 96632 | 96632 | 116628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 9 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 98906 | 98906 | 116629 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 10 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 100355 | 100355 | 116620 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 12 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | ||
| 113343 | 113343 | 116624 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 119101 | 119101 | 116621 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 123257 | 123257 | 116622 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 124339 | 124339 | 116630 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 11 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 125790 | 125790 | 116627 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 8 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 142683 | 142683 | 116623 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 61148 | 61148 | 85309 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |
| 140895 | 140895 | 85310 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |
| 12969 | 12969 | 76641 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 148X Paris St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002952.722159999 | 2092480.7640200001 | 37.7257210052939 | -122.43197862653 | (37.7257210052939, -122.43197862653) | |
| 84790 | 84790 | 76728 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 10 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 86703 | 86703 | 95460 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986585.7747 | 2111417.7398 | 37.77677535046679 | -122.489949313769 | (37.7767753504668, -122.489949313769) | |
| 87154 | 87154 | 95463 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986592.12306 | 2111264.12941 | 37.7763539505765 | -122.489916052727 | (37.7763539505765, -122.489916052727) | |
| 89093 | 89093 | 116527 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5732 GEARY BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | MTA 6 | DPW for City Agency 2 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 99793 | 99793 | 98885 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5994871.8 | 2088553.5 | 37.714476238810704 | -122.459629241673 | (37.7144762388107, -122.459629241673) | ||
| 107741 | 107741 | 95468 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 535X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 53267 | 5986556.7 | 2112284.6 | 37.7791538043677 | -122.49011366804301 | (37.7791538043677, -122.490113668043) |
| 108493 | 108493 | 76768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 109410 | 109410 | 76771 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 112829 | 112829 | 76757 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 115273 | 115273 | 95481 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | |
| 127043 | 127043 | 95458 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986582.44659 | 2111474.61787 | 37.7769313271764 | -122.48996501092199 | (37.7769313271764, -122.489965010922) | |
| 127891 | 127891 | 95465 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986594.5418 | 2111220.3413400003 | 37.7762338621769 | -122.489904464478 | (37.7762338621769, -122.489904464478) | ||
| 142922 | 142922 | 95471 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986558.17112 | 2112222.9767400003 | 37.778984690357 | -122.49010404497 | (37.778984690357, -122.49010404497) | ||
| 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) |
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");