Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 7171 | 7171 | 9447 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 3 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005622.1957 | 2112431.3933 | 37.780651788182794 | -122.424168675479 | (37.7806517881828, -122.424168675479) | |||
| 7570 | 7570 | 9448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 4 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6005590.2441 | 2112426.5193 | 37.78063660125729 | -122.424278864743 | (37.7806366012573, -122.424278864743) | ||
| 8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
| 7676 | 7676 | 9450 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 6 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.780617614602896 | -122.424439561439 | (37.7806176146029, -122.424439561439) | |||
| 40015 | 40015 | 58273 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 211 Brighton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/20/1978 12:00:00 AM | Permit Number 17285 | 5996205.3244984 | 2091294.13562794 | 37.722077972487504 | -122.455218010255 | (37.7220779724875, -122.455218010255) | |||
| 113085 | 113085 | 65849 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Rico Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50013 | 6001352.95008446 | 2121456.09779386 | 37.8051893002679 | -122.439585161616 | (37.8051893002679, -122.439585161616) | ||
| 83450 | 83450 | 68449 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4054 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 04/24/1999 12:00:00 AM | Permit Number 32307 | 6003251.17179249 | 2104206.64930012 | 37.757934492021604 | -122.431783761852 | (37.7579344920216, -122.431783761852) | ||
| 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) | ||
| 81071 | 81071 | 78107 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 970 GUERRERO ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005649.9 | 2103318.5 | 37.755631523761394 | -122.42342479955799 | (37.7556315237614, -122.423424799558) | ||||
| 3031 | 3031 | 78440 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 953 Key Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/12/2002 12:00:00 AM | 31 | 6013574.75289 | 2089557.5945599999 | 37.7182910313742 | -122.395054157617 | (37.7182910313742, -122.395054157617) | |||
| 119438 | 119438 | 78519 | Significant Tree 6 | Tree(s) :: 17 | 12 Sumner St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 3x3 | 6009421.0 | 2110873.0 | 37.776586565695894 | -122.41091663866501 | (37.7765865656959, -122.410916638665) | |||
| 63995 | 63995 | 80365 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 500 Campbell Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 1 | 6010298.5826900005 | 2088549.9300799998 | 37.7153414628213 | -122.406307590233 | (37.7153414628213, -122.406307590233) | ||
| 18877 | 18877 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | |||
| 84800 | 84800 | 84935 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | |||
| 142739 | 142739 | 84936 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | |||||
| 140164 | 140164 | 84937 | Significant Tree 6 | Tree(s) :: 17 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770120 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
| 46601 | 46601 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
| 86608 | 86608 | 85093 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | |||
| 122763 | 122763 | 86746 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 41 Nevada St | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49711 | 6009063.0 | 2098235.0 | 37.7418654099413 | -122.411262090685 | (37.7418654099413, -122.411262090685) | |||||
| 106619 | 106619 | 86895 | Significant Tree 6 | Tree(s) :: 17 | 321 Haight St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | Permit Number 49844 | 6004599.9 | 2109420.1 | 37.7723257406977 | -122.427490696784 | (37.7723257406977, -122.427490696784) | ||||
| 162383 | 162383 | 86947 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 283 Athens St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Permit Number 49915 | 6004370.91908 | 2091607.61661 | 37.7234038337052 | -122.42701386610099 | (37.7234038337052, -122.427013866101) | |||
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 126839 | 126839 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 88091 | 88091 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 103866 | 103866 | 87188 | Significant Tree 6 | Tree(s) :: 17 | 2119 Bush St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | Permit Number 50204 | 6002998.0 | 2114831.0 | 37.787091984974104 | -122.433418544226 | (37.7870919849741, -122.433418544226) | ||||
| 89763 | 89763 | 87191 | Significant Tree 6 | Tree(s) :: 17 | 640 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | Permit Number 50212 | 5995439.0 | 2093622.0 | 37.7284257331327 | -122.458035371987 | (37.7284257331327, -122.458035371987) | |||
| 83923 | 83923 | 87197 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 617 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50213 | 6003760.0 | 2104634.0 | 37.7591367256626 | -122.43005450480699 | (37.7591367256626, -122.430054504807) | ||||
| 125951 | 125951 | 87199 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 71 Mansfield St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/31/2008 12:00:00 AM | 3x3 | Permit Number 50216 | 6005338.0 | 2091826.0 | 37.7240581044071 | -122.423686361989 | (37.7240581044071, -122.423686361989) | |||
| 94387 | 94387 | 87294 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2087 28th Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/20/2008 12:00:00 AM | Permit Number 50307 | 5987541.6 | 2101099.3 | 37.7484995140672 | -122.48588532379298 | (37.7484995140672, -122.485885323793) | ||||
| 88059 | 88059 | 88281 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 935 Ulloa St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51275 | 5993125.0 | 2098282.0 | 37.7410877064311 | -122.466373457073 | (37.7410877064311, -122.466373457073) | ||
| 112295 | 112295 | 88288 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 74 Lobos St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | Permit Number 51290 | 5996341.0 | 2088696.0 | 37.7149518852461 | -122.454561415793 | (37.7149518852461, -122.454561415793) | |||
| 148579 | 148579 | 88446 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1629 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 51411 | 6005229.98772 | 2118491.64787 | 37.7972695780743 | -122.42595703411301 | (37.7972695780743, -122.425957034113) | ||
| 2184 | 2184 | 89309 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 2169 | 2169 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 117541 | 117541 | 91106 | Significant Tree 6 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | On campus | Permit Number 51996 | 5995208.0 | 2110277.0 | 37.774142880877704 | -122.46004000497801 | (37.7741428808777, -122.460040004978) | ||
| 95122 | 95122 | 91107 | Significant Tree 6 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | On campus | Permit Number 51996 | 5995208.0 | 2110277.0 | 37.774142880877704 | -122.46004000497801 | (37.7741428808777, -122.460040004978) | ||
| 103103 | 103103 | 91108 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 100224 | 100224 | 91109 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 110474 | 110474 | 91110 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On Campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 146331 | 146331 | 91111 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | On Campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 81268 | 81268 | 92013 | Permitted Site 1 | Tree(s) :: 17 | 360 04th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/02/2009 12:00:00 AM | Permit Number 52163 | 6012527.0 | 2112512.0 | 37.781260557947704 | -122.40028716013201 | (37.7812605579477, -122.400287160132) | |||
| 86232 | 86232 | 92014 | Permitted Site 1 | Tree(s) :: 17 | 360 04th St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/02/2009 12:00:00 AM | Permit Number 52163 | 6012527.0 | 2112512.0 | 37.781260557947704 | -122.40028716013201 | (37.7812605579477, -122.400287160132) | |||
| 84656 | 84656 | 92048 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2323 Cesar Chavez St | Front Yard : Yard 7 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 107985 | 107985 | 92049 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Yard 7 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 106998 | 106998 | 92755 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 124823 | 124823 | 92756 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 144843 | 144843 | 92757 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 140658 | 140658 | 92758 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 96352 | 96352 | 92759 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 77391 | 77391 | 92760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 86127 | 86127 | 92761 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 78407 | 78407 | 92764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 127045 | 127045 | 92765 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 116515 | 116515 | 92766 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 113684 | 113684 | 92767 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 125036 | 125036 | 92852 | Significant Tree 6 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 3794 16th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901.0 | 2106436.0 | 37.76397911869721 | -122.436612788339 | (37.7639791186972, -122.436612788339) | |||
| 140721 | 140721 | 92853 | Significant Tree 6 | Cercis occidentalis :: Western Redbud 246 | 3794 16th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901.0 | 2106436.0 | 37.76397911869721 | -122.436612788339 | (37.7639791186972, -122.436612788339) | |||
| 144783 | 144783 | 92909 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | 11 | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | ||
| 121713 | 121713 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | ||||
| 92434 | 92434 | 93037 | Permitted Site 1 | Tree(s) :: 17 | 1220 45th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/14/2010 12:00:00 AM | Permit Number 53146 | 5982155.6 | 2106783.3 | 37.7637908375908 | -122.504930842514 | (37.7637908375908, -122.504930842514) | |||
| 16457 | 16457 | 93053 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | |||||||||
| 128128 | 128128 | 93153 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 222 Sadowa St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 3x24 | 5994796.0 | 2087777.0 | 37.7123397937745 | -122.45983502172301 | (37.7123397937745, -122.459835021723) | |||
| 120656 | 120656 | 93194 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 442 Campbell Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010752.9 | 2088369.0 | 37.7148700691491 | -122.404724531269 | (37.7148700691491, -122.404724531269) | |||||
| 139394 | 139394 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 103620 | 103620 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 75294 | 75294 | 93205 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 118374 | 118374 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 86337 | 86337 | 93221 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788.0 | 2100441.0 | 37.7470540096767 | -122.46423776520399 | (37.7470540096767, -122.464237765204) | |||
| 79722 | 79722 | 93222 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788.0 | 2100441.0 | 37.7470540096767 | -122.46423776520399 | (37.7470540096767, -122.464237765204) | |||
| 117976 | 117976 | 93229 | Permitted Site 1 | Tree(s) :: 17 | 804 Steiner St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/02/2010 12:00:00 AM | Permit Number 53218 | 6003047.9 | 2111017.2 | 37.7766230788836 | -122.432973325779 | (37.7766230788836, -122.432973325779) | |||
| 129273 | 129273 | 93580 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 94297 | 94297 | 93581 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 100016 | 100016 | 93582 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 118586 | 118586 | 93583 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 116154 | 116154 | 93584 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 107776 | 107776 | 93585 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 142360 | 142360 | 93586 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 80809 | 80809 | 93587 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 108434 | 108434 | 93588 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 122811 | 122811 | 93589 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 98020 | 98020 | 93590 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 91873 | 91873 | 93591 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 116804 | 116804 | 93592 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 89087 | 89087 | 93593 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 124345 | 124345 | 93594 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 127517 | 127517 | 93595 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99163 | 99163 | 93596 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 79033 | 79033 | 93597 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 117214 | 117214 | 93598 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 112533 | 112533 | 93599 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 139090 | 139090 | 93600 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81657 | 81657 | 93601 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 95611 | 95611 | 93602 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 89383 | 89383 | 93603 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 110791 | 110791 | 93604 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 103097 | 103097 | 93605 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81728 | 81728 | 93606 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) |
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");