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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144929 | 144929 | 110773 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 03:06:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
145184 | 145184 | 91240 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
148070 | 148070 | 221507 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005699.48542 | 2103446.5929900003 | 37.755986035831704 | -122.42326242243999 | (37.7559860358317, -122.42326242244) | |||
158034 | 158034 | 221565 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001328.916669999 | 2102339.67059 | 37.7526990668325 | -122.438297967381 | (37.7526990668325, -122.438297967381) | |||
161335 | 161335 | 201715 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 726 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6015296.606380001 | 2088393.85947 | 37.715191240972 | -122.38902117888901 | (37.715191240972, -122.389021178889) | |||
169800 | 169800 | 221482 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005559.28434 | 2105952.19302 | 37.762857912083795 | -122.423925449408 | (37.7628579120838, -122.423925449408) | |||
177057 | 177057 | 221539 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005756.51513 | 2102435.1394700003 | 37.753212037416 | -122.422993308391 | (37.753212037416, -122.422993308391) | |||
179218 | 179218 | 201712 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 724 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015351.33364 | 2088303.0821 | 37.7149450173645 | -122.388825682463 | (37.7149450173645, -122.388825682463) | |||
189094 | 189094 | 221424 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005689.534530001 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | |||
772 | 772 | 221430 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | ||
3394 | 3394 | 118348 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 3 | ||||||||
4354 | 4354 | 221470 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:30:00 AM | 1 | Width 3ft | 6005530.44166 | 2106496.00345 | 37.7643494583795 | -122.42406388114401 | (37.7643494583795, -122.424063881144) | ||
4392 | 4392 | 221453 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:40:00 PM | 1 | Width 3ft | 6005462.88888 | 2107675.99901 | 37.7675856309877 | -122.424381462352 | (37.7675856309877, -122.424381462352) | ||
4403 | 4403 | 221458 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:49:00 AM | 2 | Width 3ft | 6005493.2574 | 2107088.45627 | 37.7659740935515 | -122.424234630048 | (37.7659740935515, -122.424234630048) | ||
4523 | 4523 | 221496 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 12:00:00 AM | 2 | Width 3ft | 6005594.03058 | 2105332.56679 | 37.761158526170895 | -122.423761214331 | (37.7611585261709, -122.423761214331) | ||
5114 | 5114 | 152414 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005626.99355 | 2104746.96336 | 37.7595524574982 | -122.423605573157 | (37.7595524574982, -122.423605573157) | |||
32785 | 32785 | 221538 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005757.68157 | 2102409.38047 | 37.7531413749784 | -122.422987443927 | (37.7531413749784, -122.422987443927) | |||
39265 | 39265 | 201713 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 724 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015343.41284 | 2088314.94317 | 37.7149771465452 | -122.38885388790001 | (37.7149771465452, -122.3888538879) | |||
47639 | 47639 | 221528 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005788.731319999 | 2101828.76193 | 37.7515488824818 | -122.422838806667 | (37.7515488824818, -122.422838806667) | |||
48258 | 48258 | 221518 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005823.14172 | 2101242.96968 | 37.7499423731511 | -122.42267818684799 | (37.7499423731511, -122.422678186848) | |||
55253 | 55253 | 203291 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 11 Jules Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994415.48252 | 2089998.39973 | 37.7184173393668 | -122.461311125716 | (37.7184173393668, -122.461311125716) | |||
71884 | 71884 | 221560 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.42459 | 2102519.64651 | 37.7534669142699 | -122.42159904898001 | (37.7534669142699, -122.42159904898) | |||
80584 | 80584 | 110774 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 03:02:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
82614 | 82614 | 91242 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 842x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 6005622.0 | 2104059.0 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | |||
84876 | 84876 | 91279 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1170x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005728.0 | 2102148.0 | 37.752422009696005 | -122.42307151190799 | (37.752422009696, -122.423071511908) | |||
112173 | 112173 | 43727 | Permitted Site 1 | Acacia stenophylla :: Shoestring Acacia 109 | 760 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | |||
113542 | 113542 | 110761 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:49:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
113634 | 113634 | 91283 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005738.0 | 2101906.0 | 37.7517580978369 | -122.42301973133999 | (37.7517580978369, -122.42301973134) | |||
115942 | 115942 | 221483 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005560.35948 | 2105916.5024900003 | 37.7627599750213 | -122.42391919281201 | (37.7627599750213, -122.423919192812) | |||
126273 | 126273 | 109695 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 12:00:00 AM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
128230 | 128230 | 110620 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:30:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
134735 | 134735 | 221425 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005689.68683 | 2103597.2936 | 37.7563992716189 | -122.42330702161301 | (37.7563992716189, -122.423307021613) | |||
135861 | 135861 | 221547 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005723.41397 | 2102999.7023 | 37.7547603282456 | -122.42314790545299 | (37.7547603282456, -122.423147905453) | |||
159637 | 159637 | 221417 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005673.16306 | 2103886.4908 | 37.7571924071266 | -122.42338472483101 | (37.7571924071266, -122.423384724831) | |||
179875 | 179875 | 221564 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001316.917769999 | 2102341.7359599997 | 37.7527040553705 | -122.438339609582 | (37.7527040553705, -122.438339609582) | |||
766 | 766 | 221431 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 1 | Width 3ft | 6005433.2519 | 2108280.1340799998 | 37.769242767658 | -122.424526951068 | (37.769242767658, -122.424526951068) | ||
1982 | 1982 | 118349 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 3 | ||||||||
4370 | 4370 | 221471 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:27:00 AM | 1 | Width 3ft | 6005532.14271 | 2106464.3538900004 | 37.764262652233704 | -122.42405574678301 | (37.7642626522337, -122.424055746783) | ||
4381 | 4381 | 221459 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:45:00 AM | 3 | Width 3ft | 6005495.536040001 | 2107056.71588 | 37.7658870706576 | -122.424224491084 | (37.7658870706576, -122.424224491084) | ||
4420 | 4420 | 221452 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:41:00 AM | 1 | Width 3ft | 6005465.56003 | 2107641.57919 | 37.7674912732207 | -122.42436977475501 | (37.7674912732207, -122.424369774755) | ||
4491 | 4491 | 221497 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:57:00 PM | 2 | Width 3ft | 6005595.06917 | 2105295.4476799998 | 37.761056664463204 | -122.42375498292499 | (37.7610566644632, -122.423754982925) | ||
5137 | 5137 | 152415 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005628.48676 | 2104715.95286 | 37.7594673942256 | -122.423598204106 | (37.7594673942256, -122.423598204106) | |||
18710 | 18710 | 91284 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005738.0 | 2101906.0 | 37.7517580978369 | -122.42301973133999 | (37.7517580978369, -122.42301973134) | |||
18919 | 18919 | 110775 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:57:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
47711 | 47711 | 187781 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6014331.70125 | 2106323.79299 | 37.7643695906061 | -122.393610496623 | (37.7643695906061, -122.393610496623) | ||||
65305 | 65305 | 221484 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005563.22827 | 2105880.05418 | 37.7626600585326 | -122.42390667874399 | (37.7626600585326, -122.423906678744) | |||
65787 | 65787 | 221527 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005790.21854 | 2101800.81566 | 37.7514722323764 | -122.422831677752 | (37.7514722323764, -122.422831677752) | |||
75755 | 75755 | 115513 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:41:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
88573 | 88573 | 109696 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:57:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
90408 | 90408 | 110621 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:27:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
111021 | 111021 | 43728 | Permitted Site 1 | Acacia stenophylla :: Shoestring Acacia 109 | 760 Lakeview Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | |||
122606 | 122606 | 110762 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:45:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
130218 | 130218 | 221537 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005757.84067 | 2102377.3752200003 | 37.753053504939 | -122.422984619142 | (37.753053504939, -122.422984619142) | |||
131374 | 131374 | 221548 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005727.072790001 | 2102965.9789400003 | 37.7546679382008 | -122.42313285530899 | (37.7546679382008, -122.423132855309) | |||
148793 | 148793 | 221561 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.81341 | 2102510.42937 | 37.7534416280528 | -122.42159704977 | (37.7534416280528, -122.42159704977) | |||
153605 | 153605 | 221517 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005823.4134 | 2101214.1336 | 37.7498632112216 | -122.422675198428 | (37.7498632112216, -122.422675198428) | |||
155379 | 155379 | 221559 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1306 York St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010039.89073 | 2101557.1439900002 | 37.7510420290671 | -122.408118546954 | (37.7510420290671, -122.408118546954) | |||
179284 | 179284 | 221563 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001305.60339 | 2102341.6071 | 37.752703058000705 | -122.438378727412 | (37.7527030580007, -122.438378727412) | |||
754 | 754 | 221432 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 1 | Width 3ft | 6005434.00046 | 2108253.10785 | 37.769168602384205 | -122.42452243915301 | (37.7691686023842, -122.424522439153) | ||
4332 | 4332 | 221460 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:41:00 AM | 2 | Width 3ft | 6005499.89777 | 2107004.0817 | 37.76574279600489 | -122.424205661071 | (37.7657427960049, -122.424205661071) | ||
4377 | 4377 | 221451 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:36:00 AM | 1 | Width 3ft | 6005468.550009999 | 2107589.96825 | 37.76734973074429 | -122.424355761536 | (37.7673497307443, -122.424355761536) | ||
4408 | 4408 | 221472 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:24:00 AM | 1 | Width 3ft | 6005534.310819999 | 2106426.8401 | 37.7641597706703 | -122.424045579956 | (37.7641597706703, -122.424045579956) | ||
5111 | 5111 | 152416 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005631.99539 | 2104658.5890900004 | 37.7593100848133 | -122.423581991114 | (37.7593100848133, -122.423581991114) | |||
5429 | 5429 | 118350 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 3 | ||||||||
44105 | 44105 | 221562 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.28805 | 2102498.9287799997 | 37.753410020459995 | -122.421598049829 | (37.75341002046, -122.421598049829) | |||
44886 | 44886 | 221418 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005666.2176 | 2103986.40391 | 37.757466353200996 | -122.423415847665 | (37.757466353201, -122.423415847665) | |||
46284 | 46284 | 221426 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005693.61577 | 2103548.6076700003 | 37.7562658131324 | -122.423289973179 | (37.7562658131324, -122.423289973179) | |||
73681 | 73681 | 221526 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005792.85635 | 2101748.62489 | 37.7513290773756 | -122.42281884712601 | (37.7513290773756, -122.422818847126) | |||
87539 | 87539 | 91285 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005738.0 | 2101906.0 | 37.7517580978369 | -122.42301973133999 | (37.7517580978369, -122.42301973134) | |||
95444 | 95444 | 109697 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:59:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
97820 | 97820 | 110763 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:41:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
97980 | 97980 | 110776 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:53:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
104357 | 104357 | 110622 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:24:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
146089 | 146089 | 115514 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:36:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
151865 | 151865 | 221485 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005566.92978 | 2105826.00789 | 37.762511869155105 | -122.42389003321101 | (37.7625118691551, -122.423890033211) | |||
168829 | 168829 | 221544 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005705.623380001 | 2103333.32509 | 37.755675374928295 | -122.423233144119 | (37.7556753749283, -122.423233144119) | |||
169550 | 169550 | 221558 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005728.5881 | 2102926.2105099997 | 37.754558828830106 | -122.423124788381 | (37.7545588288301, -122.423124788381) | |||
184414 | 184414 | 221498 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005599.77613 | 2105242.7413 | 37.7609122108583 | -122.423734955914 | (37.7609122108583, -122.423734955914) | |||
185218 | 185218 | 221536 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 6005762.1987 | 2102333.32685 | 37.75293280420979 | -122.422966417762 | (37.7529328042098, -122.422966417762) | |||
733 | 733 | 221433 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:32:00 AM | 1 | Width 3ft | 6005435.4614 | 2108218.9893400003 | 37.7690750036386 | -122.42451495861201 | (37.7690750036386, -122.424514958612) | ||
4325 | 4325 | 221461 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:37:00 AM | 2 | Width 3ft | 6005500.86915 | 2106969.86586 | 37.7656489022957 | -122.42419986763399 | (37.7656489022957, -122.424199867634) | ||
4374 | 4374 | 118351 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:32:00 AM | 3 | ||||||||
4386 | 4386 | 221473 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:20:00 AM | 1 | Width 3ft | 6005534.54232 | 2106397.63335 | 37.764079588928496 | -122.424042702116 | (37.7640795889285, -122.424042702116) | ||
4431 | 4431 | 221450 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:34:00 AM | 1 | Width 3ft | 6005469.47774 | 2107557.31332 | 37.7672601204903 | -122.424350229795 | (37.7672601204903, -122.424350229795) | ||
4499 | 4499 | 221499 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:01:00 PM | 2 | Width 3ft | 6005601.090469999 | 2105206.48742 | 37.760812740428904 | -122.42372783238899 | (37.7608127404289, -122.423727832389) | ||
5135 | 5135 | 152417 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005634.27087 | 2104624.16733 | 37.7592156991708 | -122.423571674116 | (37.7592156991708, -122.423571674116) | |||
32169 | 32169 | 221427 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005696.85287 | 2103501.5592 | 37.7561368116793 | -122.42327543382099 | (37.7561368116793, -122.423275433821) | |||
48249 | 48249 | 221525 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005795.99168 | 2101720.64475 | 37.7512524272579 | -122.422806016491 | (37.7512524272579, -122.422806016491) | |||
55100 | 55100 | 221486 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005569.00136 | 2105791.30468 | 37.7624166992856 | -122.423880400579 | (37.7624166992856, -122.423880400579) | |||
55774 | 55774 | 221419 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005664.4202 | 2104015.7148700003 | 37.7575467328056 | -122.423424147502 | (37.7575467328056, -122.423424147502) | |||
61658 | 61658 | 221543 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005707.0284 | 2103306.91954 | 37.7556029507207 | -122.42322640818999 | (37.7556029507207, -122.42322640819) | |||
82047 | 82047 | 110777 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:47:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
82356 | 82356 | 110764 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:37:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
91073 | 91073 | 109698 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:01:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
106984 | 106984 | 115515 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:34:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
120589 | 120589 | 91286 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005738.0 | 2101906.0 | 37.7517580978369 | -122.42301973133999 | (37.7517580978369, -122.42301973134) | |||
129058 | 129058 | 110623 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:20:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
129563 | 129563 | 221535 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005763.23809 | 2102308.0919 | 37.7528635735186 | -122.42296102995199 | (37.7528635735186, -122.422961029952) | |||
137049 | 137049 | 221516 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 6005827.472999999 | 2101138.31675 | 37.749655264584 | -122.42265577304701 | (37.749655264584, -122.422655773047) | |||
176764 | 176764 | 221549 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005728.89674 | 2102911.59468 | 37.7545187145683 | -122.423122682192 | (37.7545187145683, -122.423122682192) |
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");