Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43784 | 43784 | 83046 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.37751250161399 | (37.740707968002, -122.377512501614) | |||
50103 | 50103 | 76775 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
55368 | 55368 | 105009 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 7 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
57286 | 57286 | 105011 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
63991 | 63991 | 115203 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2056 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3 | Permit Number 775522 | 6001029.7 | 2112838.5 | 37.781509225585104 | -122.44008548171301 | (37.7815092255851, -122.440085481713) | ||
66027 | 66027 | 115194 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 4150 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002684.1 | 2104186.2 | 37.757846181761295 | -122.433743471638 | (37.7578461817613, -122.433743471638) | |||
78461 | 78461 | 113802 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 806 SHOTWELL ST | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007931.0 | 2103220.0 | 37.755489548438 | -122.41552904166201 | (37.755489548438, -122.415529041662) | |||||
79092 | 79092 | 115287 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1526 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776185 | 5992489.2 | 2105046.7 | 37.759625121297795 | -122.469064003389 | (37.7596251212978, -122.469064003389) | |||
80109 | 80109 | 76804 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
80243 | 80243 | 56898 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1886 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775792 | 5985700.55899725 | 2102390.4838018003 | 37.751937297297395 | -122.492346587933 | (37.7519372972974, -122.492346587933) | |||
80757 | 80757 | 76789 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
83317 | 83317 | 76761 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
88959 | 88959 | 115768 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.709055747846705 | -122.43588629224399 | (37.7090557478467, -122.435886292244) | ||
89928 | 89928 | 115438 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2500X Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777506 | 6006688.6 | 2119773.1 | 37.8008704472237 | -122.421000888697 | (37.8008704472237, -122.421000888697) | ||
90402 | 90402 | 84929 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1500@Polk Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49344 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | |||
91422 | 91422 | 76793 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
91935 | 91935 | 115289 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1425 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775512 | 5991747.8 | 2105705.5 | 37.761391146048496 | -122.47167612106001 | (37.7613911460485, -122.47167612106) | |||
92225 | 92225 | 55721 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 62 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/1973 12:00:00 AM | 30 | Permit Number 11744 | 6003135.04861118 | 2107940.94065447 | 37.768181370821 | -122.432452080859 | (37.768181370821, -122.432452080859) | ||
93755 | 93755 | 115008 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | Permit Number 774445 | 5985969.5 | 2110831.9 | 37.775130796003204 | -122.49203801834601 | (37.7751307960032, -122.492038018346) | |||
94581 | 94581 | 95578 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 501@ 6th Ave Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994244.0 | 2106639.0 | 37.764098399310704 | -122.463110607355 | (37.7640983993107, -122.463110607355) | |||||
96543 | 96543 | 76813 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
100236 | 100236 | 76809 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
104270 | 104270 | 75029 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
104340 | 104340 | 74892 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
108737 | 108737 | 50468 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 10 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778534 | 5995312.36828974 | 2100223.18422456 | 37.7465436862786 | -122.45895089565501 | (37.7465436862786, -122.458950895655) | |
110148 | 110148 | 92047 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2323 Cesar Chavez St | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
111637 | 111637 | 55048 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 3791 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2012 12:00:00 AM | Permit Number 768924 | 6003127.14535424 | 2103564.68904381 | 37.756164790986205 | -122.43216685295299 | (37.7561647909862, -122.432166852953) | |||
111851 | 111851 | 60027 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 41 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/2013 12:00:00 AM | Permit Number 769856 | 6014655.81368733 | 2112837.99803451 | 37.7822741509003 | -122.392945269869 | (37.7822741509003, -122.392945269869) | ||
112897 | 112897 | 30786 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 477 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2011 12:00:00 AM | Permit Number 768077 | 6013986.79222779 | 2112639.44439925 | 37.781691783585 | -122.395245890478 | (37.781691783585, -122.395245890478) | ||
114097 | 114097 | 76766 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
114161 | 114161 | 56806 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 806 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | Permit Number 14035 | 5999139.37670373 | 2107622.75358893 | 37.7670803223615 | -122.44624976103901 | (37.7670803223615, -122.446249761039) | |||
118834 | 118834 | 76746 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
119048 | 119048 | 76753 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
121335 | 121335 | 115253 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 20 Edgar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 772988 | 5997135.3 | 2090888.7 | 37.7210180538388 | -122.451974094521 | (37.7210180538388, -122.451974094521) | |||
122477 | 122477 | 112777 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1899X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | |||
124233 | 124233 | 114680 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 54 Colby St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774571 | 6007954.9 | 2093861.0 | 37.729793151999395 | -122.414784067206 | (37.7297931519994, -122.414784067206) | |||
124414 | 124414 | 115297 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775683 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | |||
125123 | 125123 | 112779 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1899X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | |||
128131 | 128131 | 115769 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.709055747846705 | -122.43588629224399 | (37.7090557478467, -122.435886292244) | ||
128947 | 128947 | 46881 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2300@Green Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2012 12:00:00 AM | Permit Number 768822 | 6006358.85800747 | 2118685.04678939 | 37.797864335812704 | -122.422064597009 | (37.7978643358127, -122.422064597009) | |||
135481 | 135481 | 105010 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
142546 | 142546 | 76799 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
143278 | 143278 | 76782 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
150717 | 150717 | 100949 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1561 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2012 12:00:00 AM | 1 | Permit Number 769342 | 5982149.6 | 2104456.5 | 37.7574017552939 | -122.504779173294 | (37.7574017552939, -122.504779173294) | |
2783 | 2783 | 252852 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | ||||
2784 | 2784 | 252854 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | ||||
2788 | 2788 | 252853 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | ||||
80767 | 80767 | 37127 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1501 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403113998 | (37.7584868087664, -122.50582403114) | ||
123028 | 123028 | 18540 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 60 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 2x2 | Permit Number 778371 | 5999060.658518599 | 2099832.0947892 | 37.745684600557794 | -122.445961639207 | (37.7456846005578, -122.445961639207) | ||
143361 | 143361 | 37129 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1501 46th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403113998 | (37.7584868087664, -122.50582403114) | ||
105204 | 105204 | 104605 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 10X Russell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.434880001 | 2118959.67619 | 37.798660985130795 | -122.419469576763 | (37.7986609851308, -122.419469576763) | ||
108555 | 108555 | 104604 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 10X Russell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.434880001 | 2118959.67619 | 37.798660985130795 | -122.419469576763 | (37.7986609851308, -122.419469576763) | ||
120598 | 120598 | 104603 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 10X Russell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.434880001 | 2118959.67619 | 37.798660985130795 | -122.419469576763 | (37.7986609851308, -122.419469576763) | ||
138577 | 138577 | 103085 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) | ||
140547 | 140547 | 104606 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 30 Russell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007173.0 | 2118980.0 | 37.798720087677104 | -122.419268364856 | (37.7987200876771, -122.419268364856) | ||
141309 | 141309 | 103086 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) | ||
1599 | 1599 | 13014 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 412 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2016 02:25:00 PM | 3 | 3X3 | 6010343.163 | 2120639.8328 | 37.803455608926704 | -122.408415674405 | (37.8034556089267, -122.408415674405) | ||
4295 | 4295 | 12999 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 349 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 09:03:00 AM | 3 | 3X3 | 6010644.3554 | 2120634.1907 | 37.803456979280796 | -122.407372982577 | (37.8034569792808, -122.407372982577) | ||
4303 | 4303 | 9125 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 5827 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 11:55:00 AM | 3 | 3X3 | 5988965.7697498 | 2112572.6420628 | 37.780085075713295 | -122.481800911494 | (37.7800850757133, -122.481800911494) | ||
4321 | 4321 | 12988 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 324 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 06:56:00 AM | 3 | 3X3 | 6010748.7594 | 2120699.4941 | 37.803642129208605 | -122.407016292062 | (37.8036421292086, -122.407016292062) | ||
4886 | 4886 | 17862 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.43099633374901 | (37.7882072868246, -122.430996333749) | ||
5406 | 5406 | 13016 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 407 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2016 02:31:00 PM | 3 | 3X3 | 6010356.171 | 2120603.3463 | 37.8033561544514 | -122.408368084374 | (37.8033561544514, -122.408368084374) | ||
5543 | 5543 | 13010 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 396 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:16:00 AM | 3 | 3X3 | 6010502.3453 | 2120665.4782 | 37.803534937788704 | -122.407866624342 | (37.8035349377887, -122.407866624342) | ||
5794 | 5794 | 13024 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 445 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/04/2014 02:58:00 PM | 3 | 3X3 | 6010214.1933 | 2120583.5975 | 37.8032939775537 | -122.40885801148998 | (37.8032939775537, -122.40885801149) | ||
5910 | 5910 | 13011 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 396 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:12:00 AM | 3 | 3X3 | 6010476.6325 | 2120660.3892 | 37.8035195251148 | -122.40795524597999 | (37.8035195251148, -122.40795524598) | ||
6621 | 6621 | 13040 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 515-519 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 07:26:00 AM | 3 | 3X3 | 6009890.5899 | 2120540.3695 | 37.8031571528751 | -122.409974803368 | (37.8031571528751, -122.409974803368) | ||
7217 | 7217 | 17911 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2321 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 10:58:00 AM | 3 | 3X3 | 6002821.482999999 | 2115107.812 | 37.7878420242306 | -122.434049048426 | (37.7878420242306, -122.434049048426) | ||
7645 | 7645 | 13025 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 451 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 07:02:00 AM | 3 | 3X3 | 6010198.7145 | 2120581.4625 | 37.8032872483458 | -122.40891142592 | (37.8032872483458, -122.40891142592) | ||
8514 | 8514 | 13017 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 416 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2016 12:00:00 AM | 3 | 3X3 | 6010320.6699 | 2120636.9765 | 37.8034465065935 | -122.408493311466 | (37.8034465065935, -122.408493311466) | ||
8564 | 8564 | 13015 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 407 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2016 12:00:00 AM | 12 | 3X3 | 6010332.686000001 | 2120602.2788 | 37.803351908204796 | -122.408449280112 | (37.8033519082048, -122.408449280112) | ||
9819 | 9819 | 13083 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 660 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 11:06:00 AM | 3 | 3X3 | 6009215.12 | 2120489.4566 | 37.8029794783612 | -122.412308693696 | (37.8029794783612, -122.412308693696) | ||
50090 | 50090 | 13071 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
81377 | 81377 | 683 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | |
96845 | 96845 | 13075 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/22/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774508 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |
125041 | 125041 | 13072 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2008 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
128494 | 128494 | 13022 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 431 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:20:00 AM | 3 | 3X3 | 6010276.62799 | 2120585.425 | 37.803302492372396 | -122.408642082138 | (37.8033024923724, -122.408642082138) | ||
145289 | 145289 | 25159 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2600X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 12:55:00 PM | 3 | 3X3 | 6001683.708124 | 2105708.1424058997 | 37.7619682491468 | -122.43731221388599 | (37.7619682491468, -122.437312213886) | ||
107527 | 107527 | 1444 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | ||
5683 | 5683 | 13042 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 515-519 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 07:23:00 AM | 3 | 3x3 | 6009844.8077 | 2120534.1734 | 37.8031375739168 | -122.410132796901 | (37.8031375739168, -122.410132796901) | ||
6283 | 6283 | 13055 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 08:41:00 AM | 3 | 3x3 | 6009605.5749 | 2120542.0431 | 37.8031457701614 | -122.410961227909 | (37.8031457701614, -122.410961227909) | ||
6371 | 6371 | 13043 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 526 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 11:51:00 AM | 3 | 3x3 | 6009812.0026 | 2120568.2515 | 37.803229305132604 | -122.41024872778401 | (37.8032293051326, -122.410248727784) | ||
6943 | 6943 | 13034 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 490 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2016 02:07:00 PM | 3 | 3x3 | 6010037.8987 | 2120598.0598 | 37.8033238110836 | -122.409469108899 | (37.8033238110836, -122.409469108899) | ||
7621 | 7621 | 29909 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 515-519 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 07:29:00 AM | 3 | 3x3 | 6009867.8709 | 2120537.6157 | 37.8031483182934 | -122.41005322890301 | (37.8031483182934, -122.410053228903) | ||
9756 | 9756 | 55923 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 530 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1973 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | 5992693.0422579 | 2103919.63429657 | 37.7565422691319 | -122.468277027995 | (37.7565422691319, -122.468277027995) | |
9791 | 9791 | 116717 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 690X 03RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 5 | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | ||
10102 | 10102 | 121489 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2 Judah St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | |||||||||
10105 | 10105 | 121488 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 750 Parnassus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5994725.7235199995 | 2106063.1570900003 | 37.762545022051796 | -122.461402729778 | (37.7625450220518, -122.461402729778) | ||||
11726 | 11726 | 54377 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1454 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774580 | 5984357.5042 | 2105265.8509 | 37.7597536454069 | -122.49720322400299 | (37.7597536454069, -122.497203224003) |
12866 | 12866 | 108593 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | |||||
22647 | 22647 | 9116 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 5757 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/2015 12:00:00 AM | 3 | 3x3 | 5989143.6236 | 2112579.8502 | 37.7801152084298 | -122.48118616959499 | (37.7801152084298, -122.481186169595) | ||
38625 | 38625 | 98846 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2400 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.48963946401501 | (37.753805142535, -122.489639464015) | |
43549 | 43549 | 43627 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2230 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | 0 | 3x3 | Permit Number 775700 | 5985470.85834553 | 2100027.42958295 | 37.7454355618475 | -122.49296686595899 | (37.7454355618475, -122.492966865959) |
66010 | 66010 | 90469 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 578 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988158.072517 | 2112047.558198 | 37.778596339842 | -122.48455654153601 | (37.778596339842, -122.484556541536) | |
66670 | 66670 | 98847 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2400 Noriega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.48963946401501 | (37.753805142535, -122.489639464015) | |
78192 | 78192 | 109745 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2730 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769296 | 6008568.6 | 2106948.2 | 37.7657621501348 | -122.413587690705 | (37.7657621501348, -122.413587690705) |
78961 | 78961 | 121107 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1391 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608.0 | 2106030.0 | 37.7623895873424 | -122.46526608917601 | (37.7623895873424, -122.465266089176) | ||
79381 | 79381 | 114695 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009121.0 | 2115613.0 | 37.7895846457112 | -122.41228952949498 | (37.7895846457112, -122.412289529495) | ||||
82486 | 82486 | 114696 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 799x TAYLOR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009121.0 | 2115613.0 | 37.7895846457112 | -122.41228952949498 | (37.7895846457112, -122.412289529495) | ||||
84703 | 84703 | 100649 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 50 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003141.0 | 2108015.0 | 37.76838505717971 | -122.432436785894 | (37.7683850571797, -122.432436785894) | ||||
86820 | 86820 | 104607 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1839 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 3x3 | Permit Number 770939 | 6009882.8 | 2120354.0 | 37.80264499181129 | -122.409988596173 | (37.8026449918113, -122.409988596173) |
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");