Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
148698 | 148698 | 211010 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 27 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991339.1010300005 | 2093646.61822 | 37.728256910008895 | -122.47221057976601 | (37.7282569100089, -122.472210579766) | |||
37669 | 37669 | 211009 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 25 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991341.559830001 | 2093667.8062200001 | 37.728315229259 | -122.472203623507 | (37.728315229259, -122.472203623507) | |||
92148 | 92148 | 87013 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1184 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49946 | 6017813.5 | 2093492.6 | 37.7293305991048 | -122.380675823117 | (37.7293305991048, -122.380675823117) | |||
3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
83316 | 83316 | 87018 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1200 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | |||
120538 | 120538 | 87017 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1200 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | |||
77629 | 77629 | 87016 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
101397 | 101397 | 87015 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
122533 | 122533 | 87014 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
100839 | 100839 | 111575 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1x SUNSET BLVD OFF RAMP | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 3x3 | 5984955.0 | 2095624.0 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | |||
120471 | 120471 | 2028 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 600X Bosworth St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
58287 | 58287 | 200617 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 58 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6016444.7184 | 2095097.4319 | 37.7336615146436 | -122.385519666546 | (37.7336615146436, -122.385519666546) | |||
71190 | 71190 | 91505 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
88999 | 88999 | 94233 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
107755 | 107755 | 94230 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Everglade Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
44978 | 44978 | 211007 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 600x Bosworth St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 6002197.80666 | 2095393.39137 | 37.7336755906519 | -122.43479650017001 | (37.7336755906519, -122.43479650017) | |||
164960 | 164960 | 200615 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 56 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016438.8423 | 2095106.2461 | 37.7336853915549 | -122.38554059619301 | (37.7336853915549, -122.385540596193) | |||
136924 | 136924 | 200613 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6016431.4971 | 2095119.9571 | 37.733722632810604 | -122.38556694616501 | (37.7337226328106, -122.385566946165) | |||
18019 | 18019 | 111271 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 42 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
79179 | 79179 | 111279 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 17 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
142951 | 142951 | 111265 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 20 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
33946 | 33946 | 211008 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700x Bosworth St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 10ft | 6002060.330030001 | 2095430.49234 | 37.7337696552405 | -122.435274449372 | (37.7337696552405, -122.435274449372) | |||
93367 | 93367 | 2045 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X Bosworth St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
82351 | 82351 | 111514 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
85854 | 85854 | 111516 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 14 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
89050 | 89050 | 111507 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 18 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
100466 | 100466 | 111508 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 18 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
18734 | 18734 | 94234 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
80059 | 80059 | 91504 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
81272 | 81272 | 87834 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
84102 | 84102 | 94231 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
86211 | 86211 | 91503 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
106088 | 106088 | 91502 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
114533 | 114533 | 87835 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
116587 | 116587 | 94232 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
141881 | 141881 | 94235 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 27 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
100574 | 100574 | 111558 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 36 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 15 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
111551 | 111551 | 111555 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 33 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
115460 | 115460 | 111557 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 35 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
126284 | 126284 | 111553 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 31 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
140665 | 140665 | 111554 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 32 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 26 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
63231 | 63231 | 185118 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2850 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 0ft | 5985615.0479 | 2096000.8357 | 37.734388044102204 | -122.49217185843099 | (37.7343880441022, -122.492171858431) | |||
173673 | 173673 | 211035 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6001198.5187 | 2095714.51341 | 37.7345005324595 | -122.438274321504 | (37.7345005324595, -122.438274321504) | ||||
58985 | 58985 | 211040 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6001161.45161 | 2095717.9227900002 | 37.7345077855016 | -122.43840271862899 | (37.7345077855016, -122.438402718629) | ||||
156955 | 156955 | 211039 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6001157.31367 | 2095726.26325 | 37.7345304511011 | -122.438417622186 | (37.7345304511011, -122.438417622186) | ||||
66679 | 66679 | 211036 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001192.69302 | 2095737.41742 | 37.7345630902121 | -122.438296103083 | (37.7345630902121, -122.438296103083) | ||||
158981 | 158981 | 211037 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6001183.29295 | 2095747.84811 | 37.734591195811795 | -122.438329349227 | (37.7345911958118, -122.438329349227) | ||||
169856 | 169856 | 200573 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016335.7649 | 2095440.4518 | 37.734597349697104 | -122.385920256211 | (37.7345973496971, -122.385920256211) | |||
41214 | 41214 | 211038 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6001171.81546 | 2095754.02956 | 37.7346075158123 | -122.43836947339199 | (37.7346075158123, -122.438369473392) | ||||
153781 | 153781 | 200572 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 42 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6016330.8681 | 2095450.735 | 37.73462531430871 | -122.385937902813 | (37.7346253143087, -122.385937902813) | |||
137881 | 137881 | 200571 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016326.461 | 2095462.4873 | 37.7346573398722 | -122.385953958726 | (37.7346573398722, -122.385953958726) | |||
86719 | 86719 | 109347 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 59x BURNSIDE AVE | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | ||||
165671 | 165671 | 200567 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 39 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016322.0539 | 2095480.6054 | 37.7347068446432 | -122.38597045824699 | (37.7347068446432, -122.385970458247) | |||
66847 | 66847 | 200559 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016309.6626 | 2095501.1365 | 37.7347625331555 | -122.38601473032 | (37.7347625331555, -122.38601473032) | |||
158905 | 158905 | 200558 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016305.3951 | 2095506.8264 | 37.734777920300004 | -122.38602988117901 | (37.7347779203, -122.386029881179) | |||
184099 | 184099 | 200557 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016298.6383 | 2095516.7839 | 37.734804887646796 | -122.386053935891 | (37.7348048876468, -122.386053935891) | |||
34685 | 34685 | 200547 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016201.7309 | 2095635.0286 | 37.7351242000527 | -122.386397222999 | (37.7351242000527, -122.386397222999) | |||
35365 | 35365 | 186855 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985186.2801 | 2096278.9071 | 37.735126479902895 | -122.49367471051 | (37.7351264799029, -122.49367471051) | |||
45126 | 45126 | 200542 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016191.4179 | 2095647.8311 | 37.735158782265394 | -122.38643377144 | (37.7351587822654, -122.38643377144) | |||
79809 | 79809 | 21491 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2792X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
163106 | 163106 | 185033 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2701 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985049.8565 | 2096299.4419 | 37.7351748809707 | -122.494147882197 | (37.7351748809707, -122.494147882197) | |||
45572 | 45572 | 200536 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016175.6148 | 2095666.5235 | 37.7352092330314 | -122.38648971191002 | (37.7352092330314, -122.38648971191) | |||
177231 | 177231 | 200533 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016162.6096 | 2095677.4311 | 37.7352384631645 | -122.38653543635799 | (37.7352384631645, -122.386535436358) | |||
157592 | 157592 | 185023 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2701 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985046.0879999995 | 2096329.59 | 37.735257439095705 | -122.49416313243499 | (37.7352574390957, -122.494163132435) | |||
177190 | 177190 | 200529 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 6016150.0239 | 2095691.2754 | 37.7352757800904 | -122.386579915171 | (37.7352757800904, -122.386579915171) | |||
52015 | 52015 | 200528 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6016143.3115 | 2095696.7293 | 37.7352903838014 | -122.38660350279801 | (37.7352903838014, -122.386603502798) | |||
53065 | 53065 | 200527 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6016132.8234 | 2095707.6369 | 37.7353197532414 | -122.386640524716 | (37.7353197532414, -122.386640524716) | |||
181713 | 181713 | 200526 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6016126.5305 | 2095710.5736 | 37.735327468440204 | -122.386662486514 | (37.7353274684402, -122.386662486514) | |||
39074 | 39074 | 186875 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985206.2214 | 2096387.7822 | 37.7354265885186 | -122.493613787113 | (37.7354265885186, -122.493613787113) | |||
20409 | 20409 | 4367 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 973 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001101.12966 | 2096102.69208 | 37.7355608412513 | -122.438638832041 | (37.7355608412513, -122.438638832041) | |||
147538 | 147538 | 186878 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985170.4646 | 2096439.5838 | 37.7355667300556 | -122.493741225987 | (37.7355667300556, -122.493741225987) | |||
159660 | 159660 | 186880 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5985201.1788 | 2096460.2128 | 37.73562516865071 | -122.49363655642 | (37.7356251686507, -122.49363655642) | |||
164388 | 164388 | 234478 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 398 Surrey St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 5ft | 6001098.400769999 | 2096167.19905 | 37.7357378071451 | -122.43865288754 | (37.7357378071451, -122.43865288754) | |||
115433 | 115433 | 186889 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985183.3004 | 2096502.846 | 37.7357411821318 | -122.49370150858101 | (37.7357411821318, -122.493701508581) | |||
173075 | 173075 | 186890 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985200.262 | 2096503.3044 | 37.7357434330648 | -122.493642900348 | (37.7357434330648, -122.493642900348) | |||
160627 | 160627 | 186893 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985181.9251 | 2096557.8565 | 37.7358921458374 | -122.493710315825 | (37.7358921458374, -122.493710315825) | |||
135334 | 135334 | 184982 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2701 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984985.373 | 2096691.7859999998 | 37.7362483795762 | -122.494399733702 | (37.7362483795762, -122.494399733702) | |||
141886 | 141886 | 21459 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2701X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
84289 | 84289 | 115997 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 20X Park St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 08/30/2016 09:25:00 AM | 3 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | |||
84253 | 84253 | 21431 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2692X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
117137 | 117137 | 21429 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2692X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
63191 | 63191 | 234475 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 378 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007368.44216 | 2096501.6263599999 | 37.7370107660349 | -122.41699854724101 | (37.7370107660349, -122.416998547241) | |||
170060 | 170060 | 185310 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984962.2385 | 2097256.121 | 37.737796538483295 | -122.494521307154 | (37.7377965384833, -122.494521307154) | |||
38117 | 38117 | 185308 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985001.1798 | 2097292.5499 | 37.737898841519105 | -122.494389354717 | (37.7378988415191, -122.494389354717) | |||
164480 | 164480 | 185307 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984973.1253 | 2097316.8359 | 37.7379638824881 | -122.494488141215 | (37.7379638824881, -122.494488141215) | |||
137509 | 137509 | 187121 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985174.7424 | 2097328.4139 | 37.7380074703554 | -122.493791914706 | (37.7380074703554, -122.493791914706) | |||
153955 | 153955 | 185290 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984983.8028 | 2097379.2257 | 37.738135813056005 | -122.494455822202 | (37.738135813056, -122.494455822202) | |||
28677 | 28677 | 187129 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 0ft | 5985149.8207 | 2097410.2322 | 37.738230663406604 | -122.493884107972 | (37.7382306634066, -122.493884107972) | |||
53718 | 53718 | 187133 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985163.4571 | 2097445.4987 | 37.738328293602294 | -122.493839558913 | (37.7383282936023, -122.493839558913) | |||
120091 | 120091 | 234474 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 72 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006078.82979 | 2097595.56477 | 37.739941848150394 | -122.421534992063 | (37.7399418481504, -122.421534992063) | |||
89948 | 89948 | 98838 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1101X Portola Dr | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5994967.957909999 | 2097979.30417 | 37.740362747150996 | -122.459979297607 | (37.740362747151, -122.459979297607) | |||
103200 | 103200 | 112912 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 480X BEACON ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 30 | 6002571.0 | 2098077.0 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | ||||
107428 | 107428 | 101036 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1010X Portola Dr | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||
118896 | 118896 | 101040 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1010X Portola Dr | 14 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||
144225 | 144225 | 101034 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1010X Portola Dr | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
185213 | 185213 | 187193 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2301 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984945.2043 | 2099085.395 | 37.7428182353231 | -122.49471502746701 | (37.7428182353231, -122.494715027467) |
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");