trees
339 rows where qSpecies_id = 30 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80816 | 221527 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005790.21854 | 2101800.81566 | 37.7514722323764 | -122.422831677752 | (37.7514722323764, -122.422831677752) | 2 | 4 | 5 | 28859 | 19 | |||
109163 | 221526 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005792.85635 | 2101748.62489 | 37.7513290773756 | -122.422818847126 | (37.7513290773756, -122.422818847126) | 2 | 4 | 5 | 28859 | 19 | |||
126324 | 221520 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005805.49109 | 2101500.8171 | 37.7506493670819 | -122.422757545722 | (37.7506493670819, -122.422757545722) | 2 | 4 | 5 | 28859 | 19 | |||
182549 | 221521 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005805.66932 | 2101529.55059 | 37.7507282726947 | -122.422758971142 | (37.7507282726947, -122.422758971142) | 2 | 4 | 5 | 28859 | 19 | |||
136051 | 221508 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1201 San Jose Ave | 15 | Front Yard : Yard | Tree | Private 2 | 1 | 6004291.81357 | 2095940.5809 | 37.7352967139782 | -122.427595874056 | (37.7352967139782, -122.427595874056) | 2 | 7 | 5 | 28861 | 2 | ||||
192188 | 221509 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1201 San Jose Ave | 38 | Front Yard : Yard | Tree | Private 2 | 2 | 6004439.44088 | 2096038.01178 | 37.7355725864019 | -122.427092409311 | (37.7355725864019, -122.427092409311) | 2 | 7 | 5 | 28861 | 2 | ||||
2332 | 91282 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
2731 | 91284 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
63421 | 91285 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
90377 | 91287 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
145226 | 91283 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
162959 | 91286 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
173380 | 91281 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
147940 | 91288 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1250x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005751 | 2101683 | 37.7511465247873 | -122.422958927632 | (37.7511465247873, -122.422958927632) | 2 | 4 | 5 | 28859 | 19 | |||
94820 | 91289 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1258x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005785.088369 | 2101640.018452 | 37.7510304308024 | -122.422837991942 | (37.7510304308024, -122.422837991942) | 2 | 4 | 5 | 28859 | 19 | |||
59581 | 91291 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1282x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005761 | 2101495 | 37.7506308843168 | -122.422910986406 | (37.7506308843168, -122.422910986406) | 2 | 4 | 5 | 28859 | 19 | |||
57604 | 91292 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1286x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005762 | 2101471 | 37.7505650422621 | -122.422905822788 | (37.7505650422621, -122.422905822788) | 2 | 4 | 5 | 28859 | 19 | |||
121825 | 91294 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1286x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005762 | 2101471 | 37.7505650422621 | -122.422905822788 | (37.7505650422621, -122.422905822788) | 2 | 4 | 5 | 28859 | 19 | |||
1947 | 240678 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005819.90053 | 2101295.53343 | 37.7500865182761 | -122.422693129992 | (37.7500865182761, -122.422693129992) | 2 | 4 | 5 | 28859 | 19 | ||
2506 | 240677 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | Permit Number 56125 | 6005825.90541 | 2101167.17913 | 37.7497344256173 | -122.422663244623 | (37.7497344256173, -122.422663244623) | 2 | 4 | 5 | 28859 | 19 | ||
9125 | 240676 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005837.06183 | 2100943.32688 | 37.7491204080812 | -122.42260876008 | (37.7491204080812, -122.42260876008) | 2 | 4 | 5 | 28859 | 19 | ||
40155 | 221518 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005823.14172 | 2101242.96968 | 37.7499423731511 | -122.422678186848 | (37.7499423731511, -122.422678186848) | 2 | 4 | 5 | 28859 | 19 | |||
45689 | 221513 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005831.83209 | 2101056.03846 | 37.7494295931996 | -122.422634853028 | (37.7494295931996, -122.422634853028) | 2 | 4 | 5 | 28859 | 19 | |||
68247 | 221515 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005828.19442 | 2101110.33186 | 37.7495784651962 | -122.422651289924 | (37.7495784651962, -122.422651289924) | 2 | 4 | 5 | 28859 | 19 | |||
84262 | 221514 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005830.22915 | 2101083.18072 | 37.7495040291878 | -122.42264232458 | (37.7495040291878, -122.42264232458) | 2 | 4 | 5 | 28859 | 19 | |||
100554 | 221519 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005822.79049 | 2101267.93468 | 37.7500109014944 | -122.422681175305 | (37.7500109014944, -122.422681175305) | 2 | 4 | 5 | 28859 | 19 | |||
118210 | 221517 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005823.4134 | 2101214.1336 | 37.7498632112216 | -122.422675198428 | (37.7498632112216, -122.422675198428) | 2 | 4 | 5 | 28859 | 19 | |||
128979 | 221516 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6005827.473 | 2101138.31675 | 37.749655264584 | -122.422655773047 | (37.749655264584, -122.422655773047) | 2 | 4 | 5 | 28859 | 19 | |||
174659 | 221511 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005835.54562 | 2100976.57743 | 37.7492116209326 | -122.422616365666 | (37.7492116209326, -122.422616365666) | 2 | 4 | 5 | 28859 | 19 | |||
185467 | 221510 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005838.80296 | 2100921.02333 | 37.7490592658716 | -122.422601154533 | (37.7490592658716, -122.422601154533) | 2 | 4 | 5 | 28859 | 19 | |||
185643 | 221512 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005835.43443 | 2101000.02463 | 37.7492759952973 | -122.422618416129 | (37.7492759952973, -122.422618416129) | 2 | 4 | 5 | 28859 | 19 | |||
112972 | 88538 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1306 York St | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x12 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
152774 | 221559 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1306 York St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6010039.89073 | 2101557.14399 | 37.7510420290671 | -122.408118546954 | (37.7510420290671, -122.408118546954) | 2 | 4 | 7 | 28859 | 19 | |||
131495 | 56924 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 140 Tingley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 3 | Permit Number 14167 | 6002240.5096 | 2093994.70553 | 37.7298375431559 | -122.434548888919 | (37.7298375431559, -122.434548888919) | 9 | 7 | 5 | 28861 | 25 | ||
6358 | 208585 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1424 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784722 | 5993062.7204 | 2105752.14993 | 37.7615952234535 | -122.467131790705 | (37.7615952234535, -122.467131790705) | 1 | 8 | 4 | 56 | 12 | |
190176 | 184203 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1466 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983430.71 | 2105161.519 | 37.7594128206633 | -122.500400782356 | (37.7594128206633, -122.500400782356) | 1 | 8 | 3 | 56 | 35 | |||
162980 | 96193 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1640 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
44991 | 187786 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1650 Galvez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6015560.61147 | 2097934.79581 | 37.7414033822515 | -122.388774319486 | (37.7414033822515, -122.388774319486) | 10 | 3 | 8 | 58 | 1 | ||||
48962 | 187787 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1650 Galvez Ave | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6015518.87332 | 2097965.19798 | 37.7414845469671 | -122.388920758811 | (37.7414845469671, -122.388920758811) | 10 | 3 | 8 | 58 | 1 | ||||
22553 | 187785 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1740 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012766.00153 | 2104746.33455 | 37.7599511143744 | -122.398915128835 | (37.7599511143744, -122.398915128835) | 10 | 3 | 8 | 28856 | 29 | |||
83971 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 30 | 1808 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.7962754378239 | -122.427440299436 | (37.7962754378239, -122.427440299436) | 13 | 9 | 1 | 57 | 17 | |||
3421 | 221449 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005469.95975 | 2107527.18332 | 37.767177417921 | -122.424346419355 | (37.767177417921, -122.424346419355) | 8 | 4 | 5 | 28853 | 19 | |||
31053 | 221448 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:52:00 PM | 1 | Width 3ft | 6005473.21673 | 2107488.56627 | 37.7670715686321 | -122.42433240701 | (37.7670715686321, -122.42433240701) | 8 | 4 | 5 | 28853 | 19 | ||
31367 | 115513 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:41:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
55166 | 115517 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:52:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
67411 | 221445 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 02/09/2016 10:50:00 AM | 1 | Width 3ft | 6005479.31495 | 2107369.20417 | 37.7667441731271 | -122.424302823815 | (37.7667441731271, -122.424302823815) | 8 | 4 | 5 | 28853 | 19 | ||
69768 | 221446 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:45:00 AM | 1 | Width 3ft | 6005477.30623 | 2107402.8649 | 37.7668364840384 | -122.424312165974 | (37.7668364840384, -122.424312165974) | 8 | 4 | 5 | 28853 | 19 | ||
71684 | 221447 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:33:00 PM | 1 | Width 3ft | 6005477.00515 | 2107432.00792 | 37.7669164868187 | -122.424315280345 | (37.7669164868187, -122.424315280345) | 8 | 4 | 5 | 28853 | 19 | ||
73685 | 115518 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:33:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
80455 | 115520 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 02/09/2016 10:50:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
88305 | 221454 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:48:00 PM | 1 | Width 3ft | 6005462.2492 | 2107712.58298 | 37.7676860457059 | -122.424386277315 | (37.7676860457059, -122.424386277315) | 8 | 4 | 5 | 28853 | 19 | ||
98181 | 221451 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:36:00 AM | 1 | Width 3ft | 6005468.55001 | 2107589.96825 | 37.7673497307443 | -122.424355761536 | (37.7673497307443, -122.424355761536) | 8 | 4 | 5 | 28853 | 19 | ||
101099 | 115516 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||||
118820 | 115519 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:45:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
126359 | 221444 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005482.04836 | 2107327.01142 | 37.7666284762413 | -122.424290368213 | (37.7666284762413, -122.424290368213) | 8 | 4 | 5 | 28853 | 19 | |||
128664 | 115510 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:55:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
131382 | 115515 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:34:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
142764 | 221453 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:40:00 PM | 1 | Width 3ft | 6005462.88888 | 2107675.99901 | 37.7675856309877 | -122.424381462352 | (37.7675856309877, -122.424381462352) | 8 | 4 | 5 | 28853 | 19 | ||
162498 | 221455 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:55:00 PM | 1 | Width 3ft | 6005458.87953 | 2107745.71785 | 37.7677768358576 | -122.424400289657 | (37.7677768358576, -122.424400289657) | 8 | 4 | 5 | 28853 | 19 | ||
162604 | 115521 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||||
169041 | 115511 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:48:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
171592 | 221452 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:41:00 AM | 1 | Width 3ft | 6005465.56003 | 2107641.57919 | 37.7674912732207 | -122.424369774755 | (37.7674912732207, -122.424369774755) | 8 | 4 | 5 | 28853 | 19 | ||
187472 | 221450 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:34:00 AM | 1 | Width 3ft | 6005469.47774 | 2107557.31332 | 37.7672601204903 | -122.424350229795 | (37.7672601204903, -122.424350229795) | 8 | 4 | 5 | 28853 | 19 | ||
190513 | 115514 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:36:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
124564 | 257893 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 23 Canyon Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003365 | 2086282 | 37.7087239233851 | -122.430111404197 | (37.7087239233851, -122.430111404197) | 9 | 7 | 6 | 28861 | 5 | ||||
49439 | 37574 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 30 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/2014 12:00:00 AM | 3 | Permit Number 773155 | 6001973.00287599 | 2105680.02476784 | 37.7619074866084 | -122.436309645561 | (37.7619074866084, -122.436309645561) | 15 | 4 | 5 | 28862 | 3 | |
24729 | 110768 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:21:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
50290 | 110764 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:37:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
77201 | 110769 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:17:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
82341 | 110771 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 13 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:10:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
83735 | 110770 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:14:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
98754 | 110766 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:29:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
102626 | 110765 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:33:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
104966 | 110763 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:41:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
135342 | 110761 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:49:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
158366 | 110767 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:25:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
166262 | 110762 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:45:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
170287 | 110760 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:54:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
176441 | 110759 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:59:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
10894 | 221460 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:41:00 AM | 2 | 3x3 | Permit Number 56125 | 6005499.89777 | 2107004.0817 | 37.7657427960049 | -122.424205661071 | (37.7657427960049, -122.424205661071) | 8 | 4 | 5 | 28853 | 19 | |
12213 | 221456 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:59:00 AM | 2 | 3x3 | Permit Number 56125 | 6005491.36744 | 2107155.48275 | 37.7661580255906 | -122.424245934501 | (37.7661580255906, -122.424245934501) | 8 | 4 | 5 | 28853 | 19 | |
16547 | 221467 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:14:00 AM | 1 | 3x3 | Permit Number 56125 | 6005513.55753 | 2106751.9184 | 37.765051186799 | -122.424140480012 | (37.765051186799, -122.424140480012) | 8 | 4 | 5 | 28853 | 19 | |
20744 | 221466 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:17:00 AM | 2 | Width 3ft | 6005511.21858 | 2106780.74139 | 37.7651301958204 | -122.424150619866 | (37.7651301958204, -122.424150619866) | 8 | 4 | 5 | 28853 | 19 | ||
23245 | 221461 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:37:00 AM | 2 | Width 3ft | 6005500.86915 | 2106969.86586 | 37.7656489022957 | -122.424199867634 | (37.7656489022957, -122.424199867634) | 8 | 4 | 5 | 28853 | 19 | ||
27676 | 221462 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:33:00 AM | 1 | Width 3ft | 6005503.98521 | 2106938.10792 | 37.7655618784892 | -122.424186831055 | (37.7655618784892, -122.424186831055) | 8 | 4 | 5 | 28853 | 19 | ||
53571 | 221464 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:25:00 AM | 2 | Width 3ft | 6005509.87291 | 2106837.48432 | 37.7652859224425 | -122.42415931 | (37.7652859224425, -122.42415931) | 8 | 4 | 5 | 28853 | 19 | ||
112321 | 221457 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:54:00 AM | 1 | Width 3ft | 6005492.07657 | 2107122.67642 | 37.7660679872613 | -122.424241148308 | (37.7660679872613, -122.424241148308) | 8 | 4 | 5 | 28853 | 19 | ||
129525 | 221459 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:45:00 AM | 3 | Width 3ft | 6005495.53604 | 2107056.71588 | 37.7658870706576 | -122.424224491084 | (37.7658870706576, -122.424224491084) | 8 | 4 | 5 | 28853 | 19 | ||
129550 | 221465 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:21:00 AM | 2 | Width 3ft | 6005511.34873 | 2106807.42823 | 37.7652034788903 | -122.424152067776 | (37.7652034788903, -122.424152067776) | 8 | 4 | 5 | 28853 | 19 | ||
154412 | 221458 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:49:00 AM | 2 | Width 3ft | 6005493.2574 | 2107088.45627 | 37.7659740935515 | -122.424234630048 | (37.7659740935515, -122.424234630048) | 8 | 4 | 5 | 28853 | 19 | ||
175781 | 221463 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 06/08/2017 12:00:00 AM | 3 | Width 3ft | 6005505.30672 | 2106900.54865 | 37.7654588242817 | -122.424179588833 | (37.7654588242817, -122.424179588833) | 8 | 4 | 5 | 28853 | 19 | ||
96242 | 221567 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 324 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004154.58593 | 2103373.98314 | 37.7556993571514 | -122.428600021096 | (37.7556993571514, -122.428600021096) | 2 | 4 | 5 | 28862 | 22 | |||
180105 | 221568 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 359 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001813.22675 | 2103761.96483 | 37.7566318794794 | -122.436724942504 | (37.7566318794794, -122.436724942504) | 2 | 4 | 5 | 28862 | 3 | |||
36635 | 110623 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:20:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
36834 | 110620 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:30:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
42708 | 110627 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:29:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
47290 | 110626 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 04/29/2015 09:37:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
52461 | 110625 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:13:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
62248 | 110628 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:18:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
65226 | 110621 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:27:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );