trees
979 rows where qSpecies_id = 13 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 558 | 230313 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 968 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010194.52879 | 2103588.60829 | 37.7566286356186 | -122.407727015404 | (37.7566286356186, -122.407727015404) | 2 | 4 | 7 | 28859 | 19 | |||
| 741 | 262415 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 122 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003235 | 2094463 | 37.731179778599 | -122.431144235496 | (37.731179778599, -122.431144235496) | 9 | 7 | 5 | 28861 | 25 | ||
| 863 | 230293 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006188.70146 | 2104951.15176 | 37.7601448013679 | -122.421677407793 | (37.7601448013679, -122.421677407793) | 2 | 4 | 5 | 28859 | 19 | ||
| 895 | 56729 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | 10 | 3 | 8 | 58 | 1 | ||
| 1439 | 72311 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3769 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5996250.37824 | 2115874.50597 | 37.7895720432509 | -122.456839183887 | (37.7895720432509, -122.456839183887) | 11 | 6 | 1 | 54 | 31 | |||
| 1513 | 146932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 619 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:30:00 PM | 0 | Width 3ft | 5982546.66357 | 2111553.12275 | 37.7769103910512 | -122.503931600958 | (37.7769103910512, -122.503931600958) | 11 | 6 | 2 | 55 | 26 | ||
| 2106 | 193374 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008975.96564 | 2110229.86919 | 37.7747957152898 | -122.412410677425 | (37.7747957152898, -122.412410677425) | 8 | 2 | 9 | 28853 | 34 | |||
| 2285 | 95676 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.10714 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) | 10 | 3 | 7 | 309 | 28 |
| 2308 | 144457 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 566 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/2019 12:00:00 AM | 3 | 4x6 | 5987536.08738 | 2112106.24218 | 37.7787212290426 | -122.486712509289 | (37.7787212290426, -122.486712509289) | 11 | 6 | 2 | 55 | 26 | |
| 2501 | 78191 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 680 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6015407.71241 | 2105894.14692 | 37.7632496064147 | -122.389858829046 | (37.7632496064147, -122.389858829046) | 14 | 3 | 8 | 28856 | 29 | |||
| 2571 | 219957 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3933 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003591.26694 | 2101840.52548 | 37.7514569483989 | -122.430438748853 | (37.7514569483989, -122.430438748853) | 2 | 4 | 5 | 28862 | 22 | |||
| 3141 | 117754 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 406 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5983780.49053 | 2113060.07342 | 37.7811205143771 | -122.499774894109 | (37.7811205143771, -122.499774894109) | 11 | 6 | 2 | 55 | 26 | |||
| 3356 | 74692 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | 3 | 1 | 10 | 308 | 23 | |||
| 3743 | 193316 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6013300.83104 | 2113672.81478 | 37.7844910077044 | -122.397691511273 | (37.7844910077044, -122.397691511273) | 6 | 2 | 9 | 28856 | 6 | |||
| 3837 | 255657 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1421 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2018 12:00:00 AM | 3 | 6000959.70168 | 2111031.39919 | 37.7765434007218 | -122.44019801367 | (37.7765434007218, -122.44019801367) | 15 | 5 | 11 | 29492 | 10 | |||
| 3991 | 131008 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 3 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013685.84477 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | 4 | 1 | 10 | 28860 | 6 | |||
| 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 | ||
| 4490 | 224675 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007745.9196 | 2107233.93005 | 37.7665004685576 | -122.4164534151 | (37.7665004685576, -122.4164534151) | 8 | 4 | 7 | 28853 | 19 | |||
| 4664 | 171655 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007664.95872 | 2093252.16101 | 37.7281051161408 | -122.415743336498 | (37.7281051161408, -122.415743336498) | 9 | 3 | 7 | 309 | 5 | |||
| 4723 | 259742 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 259 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/11/2019 12:00:00 AM | 3 | 6005340.35583 | 2109906.90312 | 37.7737042366543 | -122.424964031136 | (37.7737042366543, -122.424964031136) | 7 | 9 | 11 | 28852 | 10 | ||
| 4879 | 260889 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981905.91133 | 2112171.65096 | 37.7785709887537 | -122.506193994794 | (37.7785709887537, -122.506193994794) | 11 | 6 | 2 | 55 | 26 | |||
| 4904 | 144219 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 876 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982678 | 2109818 | 37.7721539708604 | -122.503348768347 | (37.7721539708604, -122.503348768347) | 11 | 6 | 2 | 55 | 26 | ||
| 4996 | 255545 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201X San Carlos St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006716 | 2104916 | 37.7600780028247 | -122.419851234809 | (37.7600780028247, -122.419851234809) | 2 | 4 | 7 | 28859 | 19 | ||||
| 5106 | 147909 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 69 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5995874.31253 | 2112332.21787 | 37.7798242673223 | -122.45788388223 | (37.7798242673223, -122.45788388223) | 11 | 6 | 2 | 54 | 16 | |||
| 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 | ||||||||||||
| 5292 | 241594 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 687 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007646.0169 | 2096174.81068 | 37.7361290122323 | -122.416015706955 | (37.7361290122323, -122.416015706955) | 2 | 7 | 7 | 28859 | 2 | |||
| 5427 | 146424 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2131 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6000557.07663 | 2120624.21431 | 37.8028598421591 | -122.442279615007 | (37.8028598421591, -122.442279615007) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 5771 | 18021 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.7869282913907 | -122.441128056615 | (37.7869282913907, -122.441128056615) | 13 | 6 | 1 | 29490 | 27 | |||
| 5797 | 230342 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Chenery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004911.05921 | 2097907.10852 | 37.7407313620627 | -122.425594827655 | (37.7407313620627, -122.425594827655) | 2 | 7 | 5 | 63 | 7 | |||
| 6004 | 230296 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006123.35153 | 2104947.42015 | 37.7601308699707 | -122.421903157405 | (37.7601308699707, -122.421903157405) | 2 | 4 | 5 | 28859 | 19 | ||
| 6056 | 147742 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 175 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2019 12:00:00 AM | 3 | Width 4ft | 5993335.44452 | 2114350.58879 | 37.7852199756724 | -122.466813637549 | (37.7852199756724, -122.466813637549) | 11 | 6 | 2 | 54 | 11 | ||
| 6177 | 70542 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 657 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 6001053.4846 | 2110988.4642 | 37.7764308509595 | -122.439870513201 | (37.7764308509595, -122.439870513201) | 15 | 5 | 11 | 29492 | 10 | ||||
| 6589 | 44716 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1879 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/2020 12:00:00 AM | 3 | Permit Number 43838 | 5989679.8369 | 2102593.1522 | 37.7527256083507 | -122.478600649693 | (37.7527256083507, -122.478600649693) | 1 | 8 | 3 | 56 | 35 | |
| 6875 | 260888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 528 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981946.38688 | 2112159.7169 | 37.7785406040131 | -122.50605309173 | (37.7785406040131, -122.50605309173) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 7356 | 71615 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 536 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5983503.66193 | 2112151.1699 | 37.7786086821922 | -122.500665338334 | (37.7786086821922, -122.500665338334) | 11 | 6 | 2 | 55 | 26 | |||
| 7414 | 70266 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988762.33088 | 2112478.21963 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 8067 | 106254 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1912X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 770844 | 6012043 | 2105629 | 37.7623344042956 | -122.401477690357 | (37.7623344042956, -122.401477690357) | 8 | 3 | 8 | 28856 | 29 | ||
| 8309 | 55891 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1981 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1979 12:00:00 AM | 4 | Permit Number 17936 | 6003525.54431 | 2118603.6465 | 37.7974806237872 | -122.431862837898 | (37.7974806237872, -122.431862837898) | 13 | 9 | 1 | 57 | 17 | ||
| 8374 | 208843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 40 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997291.06099 | 2098595.63938 | 37.7421883896873 | -122.451991423486 | (37.7421883896873, -122.451991423486) | 9 | 7 | 4 | 59 | 40 | |||
| 8414 | 260883 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 122 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988999.56708 | 2114522.30916 | 37.7854402782048 | -122.481826844764 | (37.7854402782048, -122.481826844764) | 11 | 6 | 2 | 55 | 26 | ||
| 8981 | 233048 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3059 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6009171.33105 | 2101566.67381 | 37.751019525329 | -122.411122798801 | (37.751019525329, -122.411122798801) | 2 | 4 | 7 | 28859 | 19 | ||
| 9085 | 119446 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 885 32nd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5985992 | 2109886 | 37.7725349378609 | -122.491890533583 | (37.7725349378609, -122.491890533583) | 11 | 6 | 2 | 55 | 26 | |||
| 9101 | 149740 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 5x5 | 6010932.22924 | 2105459.16725 | 37.7618060416252 | -122.405307491047 | (37.7618060416252, -122.405307491047) | 10 | 3 | 8 | 28856 | 29 | |||
| 9116 | 229637 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009018.53484 | 2097336.36234 | 37.7393954533353 | -122.411352367829 | (37.7393954533353, -122.411352367829) | 10 | 7 | 7 | 28859 | 2 | |||
| 9277 | 85291 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 7350 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | 2 | 4x72 | Permit Number 49578 | 5984127.30348 | 2112512.4695 | 37.779637298343 | -122.498534651264 | (37.779637298343, -122.498534651264) | 11 | 6 | 2 | 55 | 26 | ||
| 9454 | 260881 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 751 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985678.2622 | 2110774.56948 | 37.7749563544765 | -122.493041236092 | (37.7749563544765, -122.493041236092) | 11 | 6 | 2 | 55 | 26 | |||
| 9768 | 225019 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779083 | 6001573.01872 | 2104694.86149 | 37.7591797334691 | -122.437622474895 | (37.7591797334691, -122.437622474895) | 2 | 4 | 5 | 28862 | 3 | |
| 10033 | 80634 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 577 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6013018.0309 | 2104352.7115 | 37.7588843520526 | -122.398015861652 | (37.7588843520526, -122.398015861652) | 10 | 3 | 8 | 28856 | 29 | |||
| 10157 | 124335 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 176 Palm Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 5995959.20478 | 2113110.98096 | 37.7819674207447 | -122.457646568088 | (37.7819674207447, -122.457646568088) | 11 | 6 | 1 | 54 | 31 | |||
| 10191 | 117755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 406 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2020 12:00:00 AM | 3 | Width 4ft | 5983780.25118 | 2113048.87393 | 37.7810897498012 | -122.499774894099 | (37.7810897498012, -122.499774894099) | 11 | 6 | 2 | 55 | 26 | ||
| 10512 | 230294 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006176.61067 | 2104951.77673 | 37.760145835588 | -122.421719268545 | (37.760145835588, -122.421719268545) | 2 | 4 | 5 | 28859 | 19 | ||
| 10679 | 259873 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2666 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5996410.48132 | 2110785.34876 | 37.7756077608376 | -122.455917191866 | (37.7756077608376, -122.455917191866) | 11 | 6 | 2 | 54 | 16 | ||
| 10935 | 230295 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006165.12102 | 2104950.71502 | 37.7601422724637 | -122.421758930432 | (37.7601422724637, -122.421758930432) | 2 | 4 | 5 | 28859 | 19 | ||
| 11103 | 149739 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6010931.02944 | 2105481.85704 | 37.7618682756098 | -122.405313238612 | (37.7618682756098, -122.405313238612) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 11453 | 130994 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 800 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008432.69085 | 2120383.1883 | 37.8026437557674 | -122.415008787324 | (37.8026437557674, -122.415008787324) | 5 | 1 | 10 | 308 | 32 | |||
| 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 | |||
| 11942 | 34949 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1246 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | Permit Number 38547 | 6007519.49351 | 2115461.74269 | 37.7890793334842 | -122.417819862092 | (37.7890793334842, -122.417819862092) | 13 | 1 | 10 | 28858 | 21 | ||
| 12009 | 162257 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6011373.11147 | 2091245.9028 | 37.7228041046152 | -122.402783015826 | (37.7228041046152, -122.402783015826) | 10 | 3 | 7 | 309 | 28 | |||
| 12106 | 112557 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 19 | |||
| 12150 | 31352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2359 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2020 11:52:00 AM | 3 | Permit Number 34962 | 5992611.19724 | 2099415.50216 | 37.7441703551938 | -122.468232424195 | (37.7441703551938, -122.468232424195) | 1 | 8 | 4 | 29491 | 40 | |
| 12319 | 149738 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6010928.54307 | 2105503.65431 | 37.7619279870025 | -122.405323373095 | (37.7619279870025, -122.405323373095) | 10 | 3 | 8 | 28856 | 29 | |||
| 12327 | 230292 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006199.95177 | 2104950.54929 | 37.7601437815195 | -122.421638455465 | (37.7601437815195, -122.421638455465) | 2 | 4 | 5 | 28859 | 19 | ||
| 12397 | 264812 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2270 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2020 12:00:00 AM | 3 | 3x3 | 5989815 | 2099915 | 37.745379953303 | -122.477937465434 | (37.745379953303, -122.477937465434) | 1 | 8 | 3 | 29491 | 35 | ||
| 13364 | 70607 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1256 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007485.00571 | 2115457.39575 | 37.7890654569562 | -122.417938877483 | (37.7890654569562, -122.417938877483) | 13 | 1 | 10 | 28858 | 21 | |||
| 13493 | 170483 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 118 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003249.09726 | 2094449.59806 | 37.7311437787481 | -122.431094542601 | (37.7311437787481, -122.431094542601) | 9 | 7 | 5 | 28861 | 25 | ||
| 14012 | 261007 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 566 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/2019 12:00:00 AM | 3 | 4x6 | 5987536.08738 | 2112106.24218 | 37.7787212290426 | -122.486712509289 | (37.7787212290426, -122.486712509289) | 11 | 6 | 2 | 55 | 26 | |
| 14077 | 70606 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007500.28626 | 2115460.0775 | 37.7890736803541 | -122.417886198793 | (37.7890736803541, -122.417886198793) | 13 | 1 | 10 | 28858 | 21 | |||
| 14232 | 90568 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1818 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2019 12:00:00 AM | 3 | 3x3 | 5989946.28172 | 2110622.60957 | 37.7747877973492 | -122.478266291409 | (37.7747877973492, -122.478266291409) | 11 | 6 | 2 | 55 | 26 | ||
| 14384 | 65195 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 277 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 2 | Permit Number 27179 | 6002900.88646 | 2091805.07241 | 37.7238627685341 | -122.432109587587 | (37.7238627685341, -122.432109587587) | 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 | |||
| 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 | ||||||||||||
| 15129 | 102443 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 514 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2013 12:00:00 AM | 1 | Permit Number 770339 | 6013518.76597 | 2104573.81866 | 37.7595193399709 | -122.396299571184 | (37.7595193399709, -122.396299571184) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | ||||||||||||
| 15592 | 261192 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007231 | 2095349 | 37.7338381748563 | -122.417392087376 | (37.7338381748563, -122.417392087376) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | |||||||||||||
| 15864 | 112555 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 19 | |||
| 15878 | 165756 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 673 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007653.4982 | 2096223.70099 | 37.7362636749309 | -122.415993302149 | (37.7362636749309, -122.415993302149) | 2 | 7 | 7 | 28859 | 2 | |||
| 15945 | 262454 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 230 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001065 | 2093436 | 37.7282366652571 | -122.438572735463 | (37.7282366652571, -122.438572735463) | 9 | 7 | 6 | 28861 | 25 | ||
| 16244 | 243490 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 956 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780577 | 6007549.93258 | 2104087.5144 | 37.7578501172959 | -122.416908354249 | (37.7578501172959, -122.416908354249) | 2 | 4 | 7 | 28859 | 19 | |
| 16255 | 130986 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3147 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004613.79741 | 2120397.19916 | 37.8024668888085 | -122.428225084716 | (37.8024668888085, -122.428225084716) | 13 | 9 | 1 | 57 | 17 | |||
| 16331 | 230075 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 710 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785519 | 6007486.86917 | 2097737.12894 | 37.7404098445288 | -122.41667658998 | (37.7404098445288, -122.41667658998) | 2 | 7 | 7 | 28859 | 2 | |
| 17426 | 261374 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 479 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | 3 | Width 3ft | 5985580 | 2112677 | 37.7801741370735 | -122.493521345038 | (37.7801741370735, -122.493521345038) | 11 | 6 | 2 | 55 | 26 | ||
| 17477 | 166394 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 842 Monterey Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/30/2019 12:00:00 AM | 3 | Width 3ft | 5996498.63435 | 2094752.41973 | 37.731590420751 | -122.454453810411 | (37.731590420751, -122.454453810411) | 9 | 7 | 4 | 59 | 40 | ||
| 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 | ||
| 18076 | 131000 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2014 12:00:00 AM | 2 | Width 3ft | 6007889.3393 | 2120258.19812 | 37.8022700164033 | -122.416880201885 | (37.8022700164033, -122.416880201885) | 5 | 1 | 10 | 308 | 32 | ||
| 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 | |||
| 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 | |||
| 18550 | 116935 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1275 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015368.35588 | 2102637.50716 | 37.7543053881926 | -122.389767471397 | (37.7543053881926, -122.389767471397) | 10 | 3 | 8 | 28856 | 29 | ||
| 18901 | 230332 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 73 Leese St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005526.20735 | 2096295.99594 | 37.736342348511 | -122.423353372654 | (37.736342348511, -122.423353372654) | 2 | 7 | 7 | 28859 | 2 | |||
| 19166 | 144984 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 718 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5990699.49046 | 2110468.54979 | 37.7744084860936 | -122.475649562098 | (37.7744084860936, -122.475649562098) | 11 | 6 | 2 | 54 | 26 | |||
| 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 | ||||||||||||
| 19852 | 33783 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013842.92338 | 2116188.62598 | 37.7914290137913 | -122.395992405042 | (37.7914290137913, -122.395992405042) | 12 | 2 | 9 | 28855 | 6 | |
| 20416 | 17382 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | 10 | 3 | 8 | 58 | 1 | |
| 20727 | 130987 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1332 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006981.76642 | 2115388.70116 | 37.7888485036088 | -122.419675148215 | (37.7888485036088, -122.419675148215) | 13 | 9 | 10 | 28858 | 21 | |||
| 21174 | 177436 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 Karen Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010107.2934 | 2091444.47715 | 37.7232785896114 | -122.407172691281 | (37.7232785896114, -122.407172691281) | 10 | 3 | 7 | 309 | 28 | |||
| 21267 | 177432 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 66 Gladstone Dr | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6006350.82649 | 2094014.80407 | 37.730125204807 | -122.420340452271 | (37.730125204807, -122.420340452271) | 9 | 7 | 7 | 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) );