trees
979 rows where qSpecies_id = 13 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5226 | 259803 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 12808 | 254368 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 590X Orizaba Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
| 15038 | 259861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15229 | 259804 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
| 19358 | 259860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 11800 | 262282 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 4724 | 262586 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
| 15827 | 262585 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
| 117667 | 177448 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1022 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001291.58576 | 2086844.22821 | 37.7101500273691 | -122.437317616421 | (37.7101500273691, -122.437317616421) | 9 | 7 | 6 | 28861 | 5 | |||
| 144821 | 114986 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1028 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 1 | Permit Number 770492 | 6001259.4385 | 2086848.65908 | 37.7101603659725 | -122.437429040618 | (37.7101603659725, -122.437429040618) | 9 | 7 | 6 | 28861 | 5 | ||
| 142552 | 120109 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 555 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | 3x3 | 5997970 | 2087042 | 37.7105036758619 | -122.448811863159 | (37.7105036758619, -122.448811863159) | 9 | 7 | 6 | 28861 | 25 | ||
| 145652 | 177449 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 324 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001907.37494 | 2086972.38446 | 37.7105369040276 | -122.435198489929 | (37.7105369040276, -122.435198489929) | 9 | 7 | 6 | 28861 | 5 | |||
| 111096 | 83771 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50981 | 6009720.30690757 | 2087000.33290755 | 37.7110542204407 | -122.408197148869 | (37.7110542204407, -122.408197148869) | 9 | 7 | 8 | 309 | 39 | |
| 24131 | 177447 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 762 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002442.74838 | 2087164.23323 | 37.7110940664123 | -122.433361825211 | (37.7110940664123, -122.433361825211) | 9 | 7 | 6 | 28861 | 5 | |||
| 10378 | 163649 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 07/01/2020 12:00:00 AM | 3 | 3x4 | Permit Number 784460 | 5994737.04022 | 2087470.63166 | 37.71149518743 | -122.460016622663 | (37.71149518743, -122.460016622663) | 9 | 8 | 6 | 28861 | 24 |
| 50794 | 69419 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 168 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 9 | Permit Number 33524 | 6001328.44378 | 2087365.87339 | 37.7115844451475 | -122.437227553813 | (37.7115844451475, -122.437227553813) | 9 | 7 | 6 | 28861 | 5 | |
| 149130 | 180633 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:31:00 AM | 3 | Width 6ft | 6002463.83622 | 2087495.39703 | 37.7120045661395 | -122.433312589106 | (37.7120045661395, -122.433312589106) | 9 | 7 | 6 | 28861 | 5 | ||
| 52918 | 177393 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1657 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006855.18138 | 2087491.99559 | 37.7122433757141 | -122.418134570866 | (37.7122433757141, -122.418134570866) | 9 | 7 | 8 | 309 | 39 | |||
| 5720 | 80737 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 186 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6000043.55254 | 2087718.30936 | 37.7124790304587 | -122.44169374357 | (37.7124790304587, -122.44169374357) | 9 | 7 | 6 | 28861 | 5 | |||
| 69271 | 177392 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1654 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6006773.14965 | 2087593.0806 | 37.7125163163365 | -122.418425260531 | (37.7125163163365, -122.418425260531) | 9 | 7 | 8 | 309 | 39 | |||
| 11300 | 159230 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 144 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 5998399.17588 | 2087828.03812 | 37.712686491475 | -122.44738508425 | (37.712686491475, -122.44738508425) | 9 | 7 | 6 | 28861 | 25 | |||
| 26944 | 105800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 207 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2014 12:00:00 AM | 3 | Permit Number 769635 | 6010004.04754 | 2087785.06673 | 37.71322482385 | -122.407271751589 | (37.71322482385, -122.407271751589) | 9 | 7 | 8 | 309 | 39 | ||
| 4347 | 174997 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 61 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 4ft | 6000632.91251 | 2088182.32659 | 37.7137866806885 | -122.43968998482 | (37.7137866806885, -122.43968998482) | 9 | 7 | 6 | 28861 | 5 | ||
| 140432 | 177425 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1764 Cayuga Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 5997936.35064 | 2088551.93116 | 37.7146476772225 | -122.449036862763 | (37.7146476772225, -122.449036862763) | 9 | 7 | 6 | 28861 | 25 | |||
| 45409 | 114908 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 281 LOBOS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994225 | 2088676 | 37.714775380269 | -122.461873702271 | (37.714775380269, -122.461873702271) | 9 | 8 | 6 | 28861 | 24 | ||||
| 32076 | 208848 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 281 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994210.24416 | 2088699.7294 | 37.7148396860693 | -122.461926423875 | (37.7148396860693, -122.461926423875) | 9 | 8 | 6 | 28861 | 24 | |||
| 66805 | 258499 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
| 85859 | 258498 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
| 76797 | 177417 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1x Rolph St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 4ft | 6000503.4246 | 2088653.73075 | 37.7150736797726 | -122.440171325345 | (37.7150736797726, -122.440171325345) | 9 | 7 | 6 | 28861 | 5 | |||
| 16524 | 84225 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1361 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50686 | 6011917.47723073 | 2088615.29524593 | 37.7156113688947 | -122.400716532679 | (37.7156113688947, -122.400716532679) | 10 | 7 | 8 | 309 | 39 | ||
| 165840 | 177401 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 263 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003956.36283 | 2088919.05641 | 37.7159981864394 | -122.428255390086 | (37.7159981864394, -122.428255390086) | 9 | 7 | 6 | 28861 | 5 | |||
| 65658 | 83995 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51873 | 6003949.05097 | 2088987.25376 | 37.7161850277922 | -122.428285520976 | (37.7161850277922, -122.428285520976) | 9 | 7 | 6 | 28861 | 5 | |
| 17107 | 82354 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50649 | 6004015.90676212 | 2089097.25184538 | 37.7164908413301 | -122.428062269463 | (37.7164908413301, -122.428062269463) | 9 | 7 | 6 | 28861 | 5 | ||
| 106193 | 177394 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 833 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6003056.79218 | 2089215.78313 | 37.7167619914586 | -122.431385897768 | (37.7167619914586, -122.431385897768) | 9 | 7 | 6 | 28861 | 5 | |||
| 18162 | 83433 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 760 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000998.571 | 2089370.50235 | 37.7170699516967 | -122.438511216421 | (37.7170699516967, -122.438511216421) | 9 | 7 | 6 | 28861 | 5 | |||
| 167956 | 177400 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1112 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003994.8137 | 2089359.31728 | 37.7172092225078 | -122.428153843121 | (37.7172092225078, -122.428153843121) | 9 | 7 | 6 | 28861 | 5 | |||
| 143819 | 108839 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1112 Russia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770758 | 6003955.6442 | 2089384.80901 | 37.7172770009516 | -122.428291049376 | (37.7172770009516, -122.428291049376) | 9 | 7 | 6 | 28861 | 5 | |
| 84671 | 88351 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 700 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51333 | 6002622.22718 | 2089414.56654 | 37.7172831683531 | -122.432902166399 | (37.7172831683531, -122.432902166399) | 9 | 7 | 6 | 28861 | 5 | |
| 182368 | 177398 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 650 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002590.58454 | 2089466.88592 | 37.7174250310079 | -122.433015275935 | (37.7174250310079, -122.433015275935) | 9 | 7 | 6 | 28861 | 5 | |||
| 58397 | 177397 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 650 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002573.73742 | 2089477.35526 | 37.7174528218741 | -122.433074256169 | (37.7174528218741, -122.433074256169) | 9 | 7 | 6 | 28861 | 5 | |||
| 126282 | 177396 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 650 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002554.32379 | 2089489.05378 | 37.7174838421787 | -122.433142195459 | (37.7174838421787, -122.433142195459) | 9 | 7 | 6 | 28861 | 5 | |||
| 194454 | 160418 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 645 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 04:39:00 PM | 3 | Width 0ft | 6002625.21582 | 2089488.77592 | 37.7174871004251 | -122.432897134702 | (37.7174871004251, -122.432897134702) | 9 | 7 | 6 | 28861 | 5 | |
| 29701 | 88320 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 645 France Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.7175073196157 | -122.432824059512 | (37.7175073196157, -122.432824059512) | 9 | 7 | 6 | 28861 | 5 | |||
| 125422 | 88322 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 645 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.7175073196157 | -122.432824059512 | (37.7175073196157, -122.432824059512) | 9 | 7 | 6 | 28861 | 5 | ||
| 39763 | 177405 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 688 Vienna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002677.69306 | 2089500.91725 | 37.7175234141583 | -122.432716611994 | (37.7175234141583, -122.432716611994) | 9 | 7 | 6 | 28861 | 5 | |||
| 66627 | 104506 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 631 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6002582.75614 | 2089515.1433 | 37.7175570910528 | -122.43304578096 | (37.7175570910528, -122.43304578096) | 9 | 7 | 6 | 28861 | 5 | ||
| 188530 | 177404 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 688 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002686.6432 | 2089516.61033 | 37.7175670114817 | -122.432686795869 | (37.7175670114817, -122.432686795869) | 9 | 7 | 6 | 28861 | 5 | |||
| 36556 | 88319 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 631 France Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51310 | 6002604.8 | 2089521.8 | 37.7175766192591 | -122.432970060785 | (37.7175766192591, -122.432970060785) | 9 | 7 | 6 | 28861 | 5 | |||
| 139581 | 177403 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 688 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002695.84369 | 2089531.77748 | 37.7176091789075 | -122.432656076817 | (37.7176091789075, -122.432656076817) | 9 | 7 | 6 | 28861 | 5 | |||
| 42370 | 83565 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 647 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769747 | 6003095.84203 | 2089582.30789 | 37.7177706009018 | -122.431277069882 | (37.7177706009018, -122.431277069882) | 9 | 7 | 6 | 28861 | 5 |
| 18090 | 177402 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 670 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002753.39847 | 2089622.73249 | 37.7178621851574 | -122.432463629087 | (37.7178621851574, -122.432463629087) | 9 | 7 | 6 | 28861 | 5 | |||
| 190236 | 177399 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 908 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003531.7567 | 2089652.07353 | 37.7179868563895 | -122.429775281212 | (37.7179868563895, -122.429775281212) | 9 | 7 | 6 | 28861 | 5 | |||
| 10118 | 108815 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 474 Munich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774652 | 6003779.44726 | 2089723.38143 | 37.7181966752665 | -122.428924204145 | (37.7181966752665, -122.428924204145) | 9 | 7 | 6 | 28861 | 5 | |
| 137473 | 177411 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 474 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003775.47727 | 2089725.4167 | 37.7182020389599 | -122.42893807173 | (37.7182020389599, -122.42893807173) | 9 | 7 | 6 | 28861 | 5 | |||
| 141788 | 83366 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 618 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003144.47467 | 2089738.55732 | 37.7182023834052 | -122.431120114827 | (37.7182023834052, -122.431120114827) | 9 | 7 | 6 | 28861 | 5 | |
| 7003 | 177395 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 715 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001937.65614 | 2089768.77997 | 37.7182169074587 | -122.435293726344 | (37.7182169074587, -122.435293726344) | 9 | 7 | 6 | 28861 | 5 | |||
| 179997 | 177410 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 470 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003782.11139 | 2089736.37793 | 37.7182325116063 | -122.428915921448 | (37.7182325116063, -122.428915921448) | 9 | 7 | 6 | 28861 | 5 | |||
| 106480 | 83673 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 618 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003154.77373 | 2089756.30482 | 37.7182516977425 | -122.431085781405 | (37.7182516977425, -122.431085781405) | 9 | 7 | 6 | 28861 | 5 | |
| 183971 | 108814 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 470 Munich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774651 | 6003792.96606 | 2089744.94608 | 37.7182566522639 | -122.42887901198 | (37.7182566522639, -122.42887901198) | 9 | 7 | 6 | 28861 | 5 | |
| 109882 | 88306 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 575 Athens St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51300 | 6003350 | 2089985 | 37.718890705147 | -122.430427275663 | (37.718890705147, -122.430427275663) | 9 | 7 | 6 | 28861 | 5 | |||
| 164921 | 177414 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 575 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003352.28846 | 2089985.19468 | 37.7188913693287 | -122.430419379246 | (37.7188913693287, -122.430419379246) | 9 | 7 | 6 | 28861 | 5 | |||
| 44564 | 177412 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 539 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6003697.34204 | 2090030.0653 | 37.719034114214 | -122.429229863064 | (37.719034114214, -122.429229863064) | 9 | 7 | 6 | 28861 | 5 | |||
| 66514 | 177408 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 638 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6002397.88484 | 2090069.70643 | 37.7190693100882 | -122.433724409363 | (37.7190693100882, -122.433724409363) | 9 | 7 | 6 | 28861 | 5 | |||
| 168146 | 177409 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 659 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002137.16843 | 2090084.38724 | 37.719094822945 | -122.434626653316 | (37.719094822945, -122.434626653316) | 9 | 7 | 6 | 28861 | 5 | |||
| 151486 | 88332 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 659 Madrid St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51320 | 6002140 | 2090092 | 37.7191158866353 | -122.434617409737 | (37.7191158866353, -122.434617409737) | 9 | 7 | 6 | 28861 | 5 | |||
| 17706 | 264746 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 300x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2020 12:00:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
| 133746 | 177407 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 626 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6002434.78266 | 2090132.2743 | 37.7192432011957 | -122.433601337127 | (37.7192432011957, -122.433601337127) | 9 | 7 | 6 | 28861 | 5 | |||
| 28421 | 95734 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 626 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767481 | 6002384.8 | 2090170.7 | 37.7193458734928 | -122.433776853042 | (37.7193458734928, -122.433776853042) | 9 | 7 | 6 | 28861 | 5 | |
| 38674 | 177406 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 618 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002461.15734 | 2090172.80832 | 37.7193559950662 | -122.433513065093 | (37.7193559950662, -122.433513065093) | 9 | 7 | 6 | 28861 | 5 | |||
| 98601 | 88326 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 559 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911 | 2090236 | 37.7194982755804 | -122.435419269027 | (37.7194982755804, -122.435419269027) | 9 | 7 | 6 | 28861 | 5 | |||
| 152806 | 88327 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911 | 2090236 | 37.7194982755804 | -122.435419269027 | (37.7194982755804, -122.435419269027) | 9 | 7 | 6 | 28861 | 5 | ||
| 15021 | 160935 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 528 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001887.44706 | 2090275.94834 | 37.7196066271205 | -122.435503539072 | (37.7196066271205, -122.435503539072) | 9 | 7 | 6 | 28861 | 5 | |||
| 139506 | 254366 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
| 158442 | 254367 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
| 100635 | 177413 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003506.69699 | 2090312.38662 | 37.7197985118857 | -122.429908976214 | (37.7197985118857, -122.429908976214) | 9 | 7 | 6 | 28861 | 5 | |||
| 38498 | 88312 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Athens St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51303 | 6003514 | 2090320 | 37.7198198301278 | -122.429884275062 | (37.7198198301278, -122.429884275062) | 9 | 7 | 6 | 28861 | 5 | |||
| 194426 | 211685 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780277 | 5995307.7579 | 2090507.37878 | 37.7198661876486 | -122.458263740606 | (37.7198661876486, -122.458263740606) | 9 | 8 | 6 | 28861 | 24 | |
| 7661 | 83659 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001685.54257 | 2090383.45339 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | 9 | 7 | 6 | 28861 | 5 | |||
| 194433 | 211684 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780277 | 5995309.61761 | 2090529.04665 | 37.7199257893373 | -122.458258879737 | (37.7199257893373, -122.458258879737) | 9 | 8 | 6 | 28861 | 24 | |
| 76864 | 208847 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995505.44933 | 2090582.52466 | 37.7200838784427 | -122.457585828931 | (37.7200838784427, -122.457585828931) | 9 | 8 | 6 | 28861 | 24 | |||
| 23346 | 177418 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6009516.77243 | 2090302.76478 | 37.7201106197971 | -122.409133494811 | (37.7201106197971, -122.409133494811) | 9 | 3 | 7 | 309 | 28 | |||
| 2708 | 50426 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2014 12:00:00 AM | 3 | Permit Number 773627 | 5997303.25557645 | 2090612.9654569 | 37.7202705700793 | -122.45137364778 | (37.7202705700793, -122.45137364778) | 9 | 8 | 6 | 28861 | 24 | |
| 88916 | 95123 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 75 Oneida Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54050 | 6000595.4 | 2090675.6 | 37.7206305128633 | -122.439998309146 | (37.7206305128633, -122.439998309146) | 9 | 7 | 6 | 28861 | 25 | |
| 104312 | 108448 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 90-98X Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004670.84101 | 2090640.56593 | 37.7207654791334 | -122.425908286356 | (37.7207654791334, -122.425908286356) | 9 | 7 | 6 | 28861 | 5 | |
| 103258 | 95762 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 417 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004100.38912 | 2090668.84671 | 37.720810876907 | -122.427882177716 | (37.720810876907, -122.427882177716) | 9 | 7 | 6 | 28861 | 5 |
| 179923 | 122379 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 466 Vernon St | 1 | Front Yard : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521 | 2090937 | 37.7208852925782 | -122.467927737968 | (37.7208852925782, -122.467927737968) | 9 | 8 | 6 | 64 | 24 | ||
| 73041 | 177416 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 538 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002518.22292 | 2090772.40994 | 37.7210056052925 | -122.433358634398 | (37.7210056052925, -122.433358634398) | 9 | 7 | 6 | 28861 | 5 | |||
| 163069 | 178826 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 927 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2017 01:53:00 PM | 4 | Width 3ft | 6004356.8834 | 2090741.47649 | 37.7210248094256 | -122.427000725205 | (37.7210248094256, -122.427000725205) | 9 | 7 | 6 | 28861 | 5 | ||
| 153621 | 178827 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 927 Brazil Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004338.08735 | 2090755.04432 | 37.7210610008535 | -122.427066663506 | (37.7210610008535, -122.427066663506) | 9 | 7 | 6 | 28861 | 5 | |||
| 11517 | 72252 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 531 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6002585.93283 | 2090796.9641 | 37.7210768666757 | -122.433126335006 | (37.7210768666757, -122.433126335006) | 9 | 7 | 6 | 28861 | 5 | |||
| 172950 | 87071 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 2 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 188216 | 87070 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 87006 | 113267 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 83 Exeter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | 2 | Permit Number 774551 | 6012507.04437 | 2090789.37208 | 37.7216138123142 | -122.398831200496 | (37.7216138123142, -122.398831200496) | 10 | 3 | 8 | 58 | 1 | ||
| 108693 | 179536 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1880 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 10:42:00 AM | 3 | Width 3ft | 6000969.55481 | 2091096.39532 | 37.7218072142025 | -122.438735113438 | (37.7218072142025, -122.438735113438) | 9 | 7 | 6 | 28861 | 25 | ||
| 9933 | 264897 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 405 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 772749 | 6002446.89331 | 2091087.07144 | 37.7218655485653 | -122.433627676211 | (37.7218655485653, -122.433627676211) | 9 | 7 | 6 | 28861 | 5 | |
| 166729 | 177415 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 451 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003094.68687 | 2091098.44191 | 37.7219335042119 | -122.431389232421 | (37.7219335042119, -122.431389232421) | 9 | 7 | 6 | 28861 | 5 | |||
| 128293 | 108377 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | Permit Number 773810 | 6004631.19295 | 2091083.05863 | 37.7219782266077 | -122.426076821998 | (37.7219782266077, -122.426076821998) | 9 | 7 | 6 | 28861 | 5 |
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) );