Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |
168258 | 168258 | 54165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 833 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 17 | Permit Number 9900 | 6009194.94472 | 2090308.5759700001 | 37.720108541469706 | -122.41024635908 | (37.7201085414697, -122.41024635908) | ||
74046 | 74046 | 54163 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 809 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 14 | Permit Number 9898 | 6009163.7285 | 2090404.08715 | 37.7203690453816 | -122.410361003783 | (37.7203690453816, -122.410361003783) | ||
60808 | 60808 | 54162 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 801 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 13 | Permit Number 9897 | 6009157.0985199995 | 2090431.1488700002 | 37.720442979550796 | -122.410385831368 | (37.7204429795508, -122.410385831368) | ||
149245 | 149245 | 54044 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1802 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1972 12:00:00 AM | 10 | Permit Number 9766 | 6004429.1474 | 2115067.6282 | 37.7878227969866 | -122.428483962143 | (37.7878227969866, -122.428483962143) | ||
92692 | 92692 | 53963 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1034 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 3x3 | Permit Number 9678 | 5999077.6651474 | 2106402.81511165 | 37.7637271532356 | -122.446375440222 | (37.7637271532356, -122.446375440222) | ||
112843 | 112843 | 53753 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 119 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2005 12:00:00 AM | Permit Number 9433 | 6007101.960026401 | 2098736.7446672 | 37.7431329104844 | -122.418078305823 | (37.7431329104844, -122.418078305823) | ||
1711 | 1711 | 233792 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 628 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780007 | 6002673.122880001 | 2108886.30409 | 37.7707509019602 | -122.434117422087 | (37.7707509019602, -122.434117422087) | |
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) | |
111086 | 111086 | 51622 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3930 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778611 | 5995951.35255 | 2115552.09499 | 37.7886696148448 | -122.457850434437 | (37.7886696148448, -122.457850434437) | ||
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) | ||
94935 | 94935 | 117378 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 542 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778550 | 5988820.4 | 2111615.1 | 37.7774474783179 | -122.4822336318 | (37.7774474783179, -122.4822336318) | ||
100094 | 100094 | 117379 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 542 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778550 | 5988820.4 | 2111615.1 | 37.7774474783179 | -122.4822336318 | (37.7774474783179, -122.4822336318) | ||
48364 | 48364 | 116504 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2760 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x9 | Permit Number 778455 | 6000656.78206 | 2117825.56802 | 37.7951811832278 | -122.441733613209 | (37.7951811832278, -122.441733613209) | ||
149251 | 149251 | 116503 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2760 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6x6 | Permit Number 778455 | 6000656.844930001 | 2117814.48231 | 37.795150748366 | -122.441732599688 | (37.795150748366, -122.441732599688) | ||
158020 | 158020 | 116505 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2760 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x6 | Permit Number 778455 | 6000651.52761 | 2117840.55365 | 37.7952220304384 | -122.441752870393 | (37.7952220304384, -122.441752870393) | ||
116310 | 116310 | 58765 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4628 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2016 12:00:00 AM | 3 | Permit Number 778149 | 6000409.0 | 2105213.0 | 37.7605361627336 | -122.44168538336099 | (37.7605361627336, -122.441685383361) | ||
187162 | 187162 | 68554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 735 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 777390 | 5982265.00656 | 2110745.36563 | 37.7746759600384 | -122.504846052747 | (37.7746759600384, -122.504846052747) | |
15538 | 15538 | 114498 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 506 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777227 | 6013489.27726 | 2111373.9955599997 | 37.778189468908 | -122.39687832179199 | (37.778189468908, -122.396878321792) | |
68313 | 68313 | 114759 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1655 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 2 | Permit Number 777139 | 6003927.970290001 | 2120048.85434 | 37.801471595584296 | -122.43057351497299 | (37.8014715955843, -122.430573514973) | ||
32796 | 32796 | 114752 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1633 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777131 | 6006558.502230001 | 2092052.0855400001 | 37.7247477068349 | -122.41948329761101 | (37.7247477068349, -122.419483297611) | ||
11822 | 11822 | 117429 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 418 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 777101 | 6000919.46363 | 2092339.69207 | 37.72521817457061 | -122.43899732339099 | (37.7252181745706, -122.438997323391) | ||
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) | ||
188620 | 188620 | 83763 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 361 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2006 12:00:00 AM | 4 | Permit Number 776681 | 5993691.54318 | 2113064.28499 | 37.781708680288205 | -122.465488178701 | (37.7817086802882, -122.465488178701) | |
1854 | 1854 | 58389 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1364 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3 | Permit Number 776620 | 6006427.83864 | 2119405.514 | 37.799846446913705 | -122.42187710853999 | (37.7998464469137, -122.42187710854) | ||
123706 | 123706 | 112614 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1799x 22ND ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 3 | Permit Number 776524 | 6012792.0 | 2103743.0 | 37.7571976263526 | -122.398754797925 | (37.7571976263526, -122.398754797925) | ||
113298 | 113298 | 115372 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 401X 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776192 | 5989679.4476 | 2112297.64854 | 37.7793714969674 | -122.47931188100901 | (37.7793714969674, -122.479311881009) | ||
119788 | 119788 | 115373 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 401X 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776192 | 5989679.4476 | 2112297.64854 | 37.7793714969674 | -122.47931188100901 | (37.7793714969674, -122.479311881009) | ||
144829 | 144829 | 18910 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2606 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | Permit Number 776094 | 6002223.7217 | 2115788.31992 | 37.7896765820735 | -122.436165905566 | (37.7896765820735, -122.436165905566) | ||
115036 | 115036 | 114984 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 742 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 776077 | 5997484.7 | 2098018.8 | 37.7406156184733 | -122.451280290868 | (37.7406156184733, -122.451280290868) | |||
85464 | 85464 | 114955 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 50 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | Permit Number 776076 | 6001248.1 | 2094471.5 | 37.7310903246371 | -122.43801389501199 | (37.7310903246371, -122.438013895012) | |||
39071 | 39071 | 114959 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 517 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 1 | Permit Number 776031 | 6002108.88292 | 2086505.1138400002 | 37.7092653220046 | -122.43446864782801 | (37.7092653220046, -122.434468647828) | ||
79836 | 79836 | 115296 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1715 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776029 | 5993685.8 | 2103804.5 | 37.756283428586705 | -122.464835383865 | (37.7562834285867, -122.464835383865) | |||
13498 | 13498 | 60261 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.41226881345301 | (37.7575442102667, -122.412268813453) | |
162549 | 162549 | 113075 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3456 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775955 | 5999259.12859 | 2120682.68554 | 37.8029463281663 | -122.446775374497 | (37.8029463281663, -122.446775374497) | |
6830 | 6830 | 112118 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1816 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775883 | 5999532.43444 | 2115241.7678400003 | 37.7880226220009 | -122.445438140154 | (37.7880226220009, -122.445438140154) | |
103067 | 103067 | 115238 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 589 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775584 | 5981901.6 | 2111755.2 | 37.777427283208496 | -122.506178021462 | (37.7774272832085, -122.506178021462) | |||
111274 | 111274 | 115231 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 326 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775467 | 5986882.9 | 2113733.3 | 37.7831505651894 | -122.489091757795 | (37.7831505651894, -122.489091757795) | |||
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) | ||
81828 | 81828 | 43571 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 112 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2015 12:00:00 AM | 3 | Permit Number 775305 | 6004416.34834396 | 2101055.04037426 | 37.749346892667205 | -122.42752956289101 | (37.7493468926672, -122.427529562891) | |
110664 | 110664 | 115227 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 22 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775148 | 5988276.3 | 2115892.0 | 37.7891589710102 | -122.484429598969 | (37.7891589710102, -122.484429598969) | |||
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) | |
101292 | 101292 | 109291 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 286 Cumberland St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774872 | 6003752.6 | 2104537.4 | 37.7588710659743 | -122.4300732064 | (37.7588710659743, -122.4300732064) | |
81004 | 81004 | 70844 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 179 Hamerton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/19/2015 12:00:00 AM | 3 | Permit Number 774723 | 6001345.45815513 | 2095262.03450684 | 37.733266486381396 | -122.437733908358 | (37.7332664863814, -122.437733908358) | ||
126500 | 126500 | 108790 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 964 Avalon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774648 | 6005260.71538 | 2092108.7788900002 | 37.7248301904685 | -122.423973622591 | (37.7248301904685, -122.423973622591) | |
10913 | 10913 | 54811 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 179 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774552 | 6009584.74153 | 2095040.5771599999 | 37.7331234617736 | -122.409232703537 | (37.7331234617736, -122.409232703537) | |
102004 | 102004 | 111035 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 927 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 774368 | 5999163.7 | 2106974.1 | 37.765300671793604 | -122.446118968287 | (37.7653006717936, -122.446118968287) | ||||
100503 | 100503 | 39854 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 417-419 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774348 | 5992779.946719999 | 2112593.86448 | 37.7803644154992 | -122.46860760635599 | (37.7803644154992, -122.468607606356) | |
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) | |
85538 | 85538 | 50358 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774276 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |
6083 | 6083 | 108032 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001036.4090599995 | 2120513.75887 | 37.802583868119896 | -122.440612955426 | (37.8025838681199, -122.440612955426) | ||
8073 | 8073 | 108033 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001051.57629 | 2120515.71183 | 37.802590094109604 | -122.440560609499 | (37.8025900941096, -122.440560609499) | ||
8890 | 8890 | 108034 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001070.0116 | 2120518.4067 | 37.8025985432527 | -122.440497007638 | (37.8025985432527, -122.440497007638) | ||
110265 | 110265 | 112433 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 774101 | 5995479.0 | 2115773.8 | 37.7892512085361 | -122.45950075691601 | (37.7892512085361, -122.459500756916) | |||
113413 | 113413 | 112434 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774101 | 5995479.0 | 2115773.8 | 37.7892512085361 | -122.45950075691601 | (37.7892512085361, -122.459500756916) | |||
99781 | 99781 | 112425 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Arguello Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3x3 | Permit Number 774100 | 5995478.7 | 2115781.3 | 37.789271784254495 | -122.45950233827601 | (37.7892717842545, -122.459502338276) | ||
88888 | 88888 | 113602 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
90793 | 90793 | 113600 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | |
122830 | 122830 | 113601 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
48675 | 48675 | 30331 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 146 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 2 | Permit Number 773837 | 6007384.6010300005 | 2098241.57686 | 37.741789194105 | -122.417065928069 | (37.741789194105, -122.417065928069) | ||
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) |
86801 | 86801 | 108496 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1331 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773640 | 5992376.99621 | 2106387.92207 | 37.7633012798944 | -122.469549692534 | (37.7633012798944, -122.469549692534) |
126391 | 126391 | 108974 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3059 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773634 | 6009172.8 | 2101543.2 | 37.750955153861604 | -122.411116061085 | (37.7509551538616, -122.411116061085) |
64066 | 64066 | 107684 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
80467 | 80467 | 107678 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
84616 | 84616 | 107683 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
84784 | 84784 | 107682 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
103560 | 103560 | 107681 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
112302 | 112302 | 107685 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
119990 | 119990 | 107679 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
141739 | 141739 | 107686 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
1374 | 1374 | 97285 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2321 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773461 | 6003155.0 | 2116788.0 | 37.7924743139296 | -122.433015230869 | (37.7924743139296, -122.433015230869) | |
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) | |
83842 | 83842 | 66643 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2707 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2015 12:00:00 AM | 3 | Permit Number 773016 | 6009896.39828948 | 2103938.11827711 | 37.7575716176323 | -122.408782719932 | (37.7575716176323, -122.408782719932) | |
120661 | 120661 | 2007 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Bosworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 772999 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | ||
43551 | 43551 | 106546 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 644 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 772940 | 5982289.0297300005 | 2111361.80008 | 37.7763699221041 | -122.504808639708 | (37.7763699221041, -122.504808639708) | |
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) | |
110566 | 110566 | 114803 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 273 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 772863 | 5990214.8 | 2113578.4 | 37.7829191632935 | -122.477553529871 | (37.7829191632935, -122.477553529871) | |||
128502 | 128502 | 66394 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x4 | Permit Number 772815 | 6007447.25872729 | 2096493.62336554 | 37.7369932248849 | -122.41672547553001 | (37.7369932248849, -122.41672547553) | |
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) | |
8964 | 8964 | 115754 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3157 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772142 | 5999354.88302 | 2119687.6663900004 | 37.8002197429071 | -122.446372392773 | (37.8002197429071, -122.446372392773) | ||
115149 | 115149 | 104315 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 501X 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2015 12:00:00 AM | 18 | 3x3 | Permit Number 771760 | 5988094.434669999 | 2112469.19466 | 37.779750328743894 | -122.48480762567301 | (37.7797503287439, -122.484807625673) | |
4790 | 4790 | 158406 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 50 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 12:00:00 AM | 3 | 3X3 | Permit Number 770857 | 6001789.37716 | 2096842.5543 | 37.7376314601307 | -122.436312235543 | (37.7376314601307, -122.436312235543) | |
71191 | 71191 | 105059 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500X 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987202.10059 | 2112208.93891 | 37.77898372892879 | -122.487875431883 | (37.7789837289288, -122.487875431883) | ||
89261 | 89261 | 105052 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 501X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.6423299997 | 37.779031128568796 | -122.48680778308001 | (37.7790311285688, -122.48680778308) | ||
111234 | 111234 | 105058 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500X 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987202.10059 | 2112208.93891 | 37.77898372892879 | -122.487875431883 | (37.7789837289288, -122.487875431883) | ||
115361 | 115361 | 105057 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500X 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987202.10059 | 2112208.93891 | 37.77898372892879 | -122.487875431883 | (37.7789837289288, -122.487875431883) | ||
121448 | 121448 | 105054 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 501X 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.6423299997 | 37.779031128568796 | -122.48680778308001 | (37.7790311285688, -122.48680778308) | ||
72844 | 72844 | 103626 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2729 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770186 | 5999911.183999999 | 2118103.33782 | 37.79590135493 | -122.444333461525 | (37.79590135493, -122.444333461525) | |
41200 | 41200 | 104071 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 590 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770130 | 5985063.180319999 | 2111850.11147 | 37.777873493280296 | -122.495248237578 | (37.7778734932803, -122.495248237578) | |
48781 | 48781 | 102913 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2848 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/2013 12:00:00 AM | 10 | 3x3 | Permit Number 770041 | 5999375.629509999 | 2118076.9363599997 | 37.7957982935174 | -122.446184674607 | (37.7957982935174, -122.446184674607) | |
11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
52523 | 52523 | 101291 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1573 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769634 | 6005984.6308 | 2118253.95583 | 37.7966595553549 | -122.423328868831 | (37.7966595553549, -122.423328868831) | |
166834 | 166834 | 101294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1573 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769634 | 6006047.51921 | 2118262.74897 | 37.7966872481687 | -122.423111885821 | (37.7966872481687, -122.423111885821) | |
47607 | 47607 | 101528 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 819 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769457 | 5981975.18641 | 2110162.57659 | 37.773058737344996 | -122.505805367237 | (37.773058737345, -122.505805367237) | |
174564 | 174564 | 101713 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3337 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769456 | 5998828.122819999 | 2115578.65478 | 37.788907393020295 | -122.447899187116 | (37.7889073930203, -122.447899187116) | |
3623 | 3623 | 101130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1477 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x3 | Permit Number 769344 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||
67794 | 67794 | 53955 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 186 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2012 12:00:00 AM | 5 | Permit Number 769056 | 6009535.31937 | 2095068.1425700001 | 37.7331963815106 | -122.409405514576 | (37.7331963815106, -122.409405514576) | ||
103811 | 103811 | 55519 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4228 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | Permit Number 769010 | 6001686.84749041 | 2102367.04209993 | 37.7527945740635 | -122.437062140592 | (37.7527945740635, -122.437062140592) |
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");