trees
979 rows where qSpecies_id = 13 sorted by qAddress descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||||
| 187282 | 108632 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 ORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774601 | 6000898 | 2105859 | 37.7623377695764 | -122.440040482469 | (37.7623377695764, -122.440040482469) | 15 | 5 | 5 | 28862 | 3 |
| 184962 | 130966 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 Moulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002966.56472 | 2119407.57255 | 37.7996562924699 | -122.433854543963 | (37.7996562924699, -122.433854543963) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 180595 | 177435 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010088.68836 | 2091439.32967 | 37.7232634144668 | -122.407236642978 | (37.7232634144668, -122.407236642978) | 10 | 3 | 7 | 309 | 28 | |||
| 136561 | 96067 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 981 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767692 | 6008020 | 2102218 | 37.7527432860874 | -122.415150327914 | (37.7527432860874, -122.415150327914) | 2 | 4 | 7 | 28859 | 19 | |
| 136502 | 87851 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 97 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2013 12:00:00 AM | 3x3 | Permit Number 779093 | 6007313 | 2098782 | 37.7432690474632 | -122.417351790512 | (37.7432690474632, -122.417351790512) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 67330 | 96066 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 957 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767691 | 6008013 | 2102358 | 37.7531273009994 | -122.415184444517 | (37.7531273009994, -122.415184444517) | 2 | 4 | 7 | 28859 | 19 | |
| 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 | |
| 116185 | 52791 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 955@ MOSCOW Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48832 | 6004754.52241 | 2091271.39974 | 37.7225023397811 | -122.425663900979 | (37.7225023397811, -122.425663900979) | 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 | |
| 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 | |
| 84792 | 130969 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Heather Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5997355.4901 | 2113891.63765 | 37.7841910082488 | -122.452872452398 | (37.7841910082488, -122.452872452398) | 15 | 6 | 1 | 54 | 31 | ||||
| 106540 | 130968 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5997356.68218 | 2113906.91877 | 37.7842330344764 | -122.452869431598 | (37.7842330344764, -122.452869431598) | 15 | 6 | 1 | 54 | 31 | ||||
| 66254 | 51656 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 949 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50463 | 6003796.70592748 | 2102740.00151399 | 37.7539383334149 | -122.42979246605 | (37.7539383334149, -122.42979246605) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | ||
| 102454 | 131001 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.8022806446072 | -122.416822257668 | (37.8022806446072, -122.416822257668) | 5 | 1 | 10 | 308 | 32 | |||
| 104120 | 131002 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/09/2014 12:00:00 AM | 2 | Width 3ft | 6007919.06293 | 2120264.13988 | 37.8022880028424 | -122.416777764577 | (37.8022880028424, -122.416777764577) | 5 | 1 | 10 | 308 | 32 | ||
| 151875 | 177437 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 93 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010115.68283 | 2091447.62238 | 37.7232876952637 | -122.407143912081 | (37.7232876952637, -122.407143912081) | 10 | 3 | 7 | 309 | 28 | |||
| 168722 | 110031 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 92X Santa Ynez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774272 | 6000673.3536 | 2092054.19092 | 37.7244202473951 | -122.439827638683 | (37.7244202473951, -122.439827638683) | 9 | 7 | 6 | 28861 | 25 |
| 24293 | 94928 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 929#4 Broderick St | Sidewalk: Curb side : | Landscaping | Private 2 | 12/08/2010 12:00:00 AM | 3 | 26x6 | Permit Number 54775 | 6000937 | 2111843 | 37.7787705583514 | -122.440334763546 | (37.7787705583514, -122.440334763546) | 15 | 5 | 11 | 29490 | 41 | ||
| 114767 | 139661 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 929 BRODERICK ST | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/16/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 54775 | 6000928.5602 | 2111878.6364 | 37.7788679263138 | -122.440366516466 | (37.7788679263138, -122.440366516466) | 15 | 5 | 11 | 29490 | 41 | |
| 150666 | 139660 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 929 BRODERICK ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/16/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 54775 | 6000923.4839 | 2111907.7406 | 37.7789475500173 | -122.440386165203 | (37.7789475500173, -122.440386165203) | 15 | 5 | 11 | 29490 | 41 | |
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |||
| 33479 | 116924 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015542.44799 | 2102559.60008 | 37.7541011242826 | -122.389159972153 | (37.7541011242826, -122.389159972153) | 10 | 3 | 8 | 28856 | 29 | ||
| 34828 | 116927 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015494.24319 | 2102557.91546 | 37.7540938262957 | -122.389326559889 | (37.7540938262957, -122.389326559889) | 10 | 3 | 8 | 28856 | 29 | ||
| 55068 | 116930 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015446.80292 | 2102557.08015 | 37.7540889024884 | -122.389490562948 | (37.7540889024884, -122.389490562948) | 10 | 3 | 8 | 28856 | 29 | ||
| 63967 | 116932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015412.75293 | 2102554.60022 | 37.7540802051572 | -122.389608143898 | (37.7540802051572, -122.389608143898) | 10 | 3 | 8 | 28856 | 29 | ||
| 66389 | 116929 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015461.93425 | 2102556.84012 | 37.7540890823654 | -122.389438217924 | (37.7540890823654, -122.389438217924) | 10 | 3 | 8 | 28856 | 29 | ||
| 74463 | 116925 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015524.58204 | 2102559.09611 | 37.7540987500629 | -122.389221722302 | (37.7540987500629, -122.389221722302) | 10 | 3 | 8 | 28856 | 29 | ||
| 80977 | 116931 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015431.47773 | 2102556.19381 | 37.7540856190657 | -122.389543499733 | (37.7540856190657, -122.389543499733) | 10 | 3 | 8 | 28856 | 29 | ||
| 127182 | 116926 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015510.15678 | 2102558.19189 | 37.7540954675573 | -122.389271545654 | (37.7540954675573, -122.389271545654) | 10 | 3 | 8 | 28856 | 29 | ||
| 134984 | 116928 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015476.82973 | 2102557.66932 | 37.7540921850224 | -122.389386763196 | (37.7540921850224, -122.389386763196) | 10 | 3 | 8 | 28856 | 29 | ||
| 190103 | 116923 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015559.42731 | 2102560.48486 | 37.7541044949445 | -122.389101314797 | (37.7541044949445, -122.389101314797) | 10 | 3 | 8 | 28856 | 29 | ||
| 171459 | 193328 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015574.56777 | 2102562.74505 | 37.7541115402303 | -122.389049112743 | (37.7541115402303, -122.389049112743) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |
| 50268 | 120234 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 896 24th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5988543.40273 | 2109982.31108 | 37.7729481790861 | -122.483072139836 | (37.7729481790861, -122.483072139836) | 11 | 6 | 2 | 55 | 26 | |||
| 129691 | 114755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 89 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777135 | 6010155.72688 | 2091460.80739 | 37.7233261394813 | -122.407006415641 | (37.7233261394813, -122.407006415641) | 10 | 3 | 7 | 309 | 28 | ||
| 49485 | 95113 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 887 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54041 | 6001057 | 2091844.3 | 37.7238657652599 | -122.438486397461 | (37.7238657652599, -122.438486397461) | 9 | 7 | 6 | 28861 | 25 | |
| 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 | |||
| 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 | ||
| 78939 | 32526 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 871 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2015 12:00:00 AM | Permit Number 776214 | 6007576.4663397 | 2095282.92697428 | 37.7336761840288 | -122.416193025137 | (37.7336761840288, -122.416193025137) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 87755 | 4334 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 852 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001755.94767 | 2095865.71194 | 37.7349473777015 | -122.436357925586 | (37.7349473777015, -122.436357925586) | 2 | 7 | 5 | 63 | 7 | |||
| 44619 | 177424 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 85 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000559.94682 | 2092109.10715 | 37.7245645787726 | -122.440223605655 | (37.7245645787726, -122.440223605655) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | ||
| 68669 | 108662 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 842 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982646.66004 | 2110014.02816 | 37.7726903649612 | -122.503471692361 | (37.7726903649612, -122.503471692361) | 11 | 6 | 2 | 55 | 26 |
| 71691 | 108663 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 842 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982645.59315 | 2110033.99041 | 37.7727451127869 | -122.503476861251 | (37.7727451127869, -122.503476861251) | 11 | 6 | 2 | 55 | 26 |
| 1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
| 127507 | 107673 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 834 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772907 | 5983266.37919 | 2110104.76952 | 37.7729759278402 | -122.501334764681 | (37.7729759278402, -122.501334764681) | 11 | 6 | 2 | 55 | 26 | |
| 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 | |||
| 71703 | 130995 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 832 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008337.45548 | 2120371.32318 | 37.8026058250595 | -122.41533751024 | (37.8026058250595, -122.41533751024) | 5 | 1 | 10 | 308 | 32 | |||
| 145486 | 70167 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 831 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2015 12:00:00 AM | 3 | Permit Number 773700 | 5981976.78091 | 2110066.45395 | 37.772794906459 | -122.505792724366 | (37.772794906459, -122.505792724366) | 11 | 6 | 2 | 55 | 26 | |
| 139230 | 177438 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 83 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010165.7616 | 2091462.99776 | 37.7233327153139 | -122.406971881647 | (37.7233327153139, -122.406971881647) | 10 | 3 | 7 | 309 | 28 | |||
| 157732 | 114754 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 83 Karen Ct | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | Permit Number 777134 | 6010271.6 | 2091687.4 | 37.7239547991887 | -122.406621822462 | (37.7239547991887, -122.406621822462) | 10 | 3 | 7 | 309 | 28 | ||||
| 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 | ||
| 122005 | 230335 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 823 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002473.18997 | 2103401.0764 | 37.7556784506177 | -122.434416752458 | (37.7556784506177, -122.434416752458) | 2 | 4 | 5 | 28862 | 22 | |||
| 178602 | 230336 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 823 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002471.62973 | 2103413.82046 | 37.7557133541918 | -122.434423059382 | (37.7557133541918, -122.434423059382) | 2 | 4 | 5 | 28862 | 22 | |||
| 190891 | 230337 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 823 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002470.86224 | 2103420.79735 | 37.7557324674964 | -122.434426212412 | (37.7557324674964, -122.434426212412) | 2 | 4 | 5 | 28862 | 22 | |||
| 51580 | 109211 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 819 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773413 | 6011187.72328 | 2090968.52831 | 37.722032138266 | -122.403404362845 | (37.722032138266, -122.403404362845) | 10 | 3 | 7 | 309 | 28 | |
| 159524 | 118718 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 818 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982331.02075 | 2110159.51383 | 37.7730712650544 | -122.504574285424 | (37.7730712650544, -122.504574285424) | 11 | 6 | 2 | 55 | 26 | |||
| 49376 | 99539 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 801X Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.7769767308218 | -122.445040600733 | (37.7769767308218, -122.445040600733) | 15 | 5 | 11 | 29492 | 16 | |
| 108747 | 99540 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 801X Central Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.7769767308218 | -122.445040600733 | (37.7769767308218, -122.445040600733) | 15 | 5 | 11 | 29492 | 16 | ||
| 143762 | 99541 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 801X Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.7769767308218 | -122.445040600733 | (37.7769767308218, -122.445040600733) | 15 | 5 | 11 | 29492 | 16 | ||
| 156253 | 99542 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 801X Central Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.7769767308218 | -122.445040600733 | (37.7769767308218, -122.445040600733) | 15 | 5 | 11 | 29492 | 16 | ||
| 178675 | 99538 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 801X Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.7769767308218 | -122.445040600733 | (37.7769767308218, -122.445040600733) | 15 | 5 | 11 | 29492 | 16 | |
| 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 | |||
| 26576 | 173651 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 80 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.45657 | 2092194.59394 | 37.7243327619491 | -122.468352901223 | (37.7243327619491, -122.468352901223) | 9 | 8 | 4 | 59 | 40 | ||
| 76227 | 18413 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 799X Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2013 12:00:00 AM | 3 | 4X4 | 6010481.3464666 | 2104567.7087473 | 37.7593330783471 | -122.406804093165 | (37.7593330783471, -122.406804093165) | 10 | 4 | 8 | 28859 | 19 | ||
| 24096 | 105848 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | |||
| 60421 | 112587 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | ||||
| 193757 | 105847 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | |||
| 186074 | 177439 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010188.86492 | 2091471.00105 | 37.7233559834822 | -122.406892581232 | (37.7233559834822, -122.406892581232) | 10 | 3 | 7 | 309 | 28 | |||
| 79925 | 115368 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 ELSIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778647 | 6007415 | 2098925 | 37.7436674318334 | -122.417009230148 | (37.7436674318334, -122.417009230148) | 2 | 7 | 7 | 28859 | 2 | |
| 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 | ||
| 49638 | 123123 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992600.03768 | 2110148.99607 | 37.7736410746067 | -122.469052008303 | (37.7736410746067, -122.469052008303) | 11 | 6 | 2 | 54 | 11 | |||
| 68596 | 123366 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994765.69029 | 2110380.32738 | 37.7744011411578 | -122.461577514019 | (37.7744011411578, -122.461577514019) | 11 | 6 | 2 | 54 | 11 | |||
| 147619 | 123367 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994765.80276 | 2110367.1849 | 37.7743650618625 | -122.461576171928 | (37.7743650618625, -122.461576171928) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 138815 | 193376 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008940.99117 | 2110196.43665 | 37.7747019546579 | -122.41252929799 | (37.7747019546579, -122.41252929799) | 8 | 2 | 9 | 28853 | 34 | |||
| 165807 | 193375 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008954.62424 | 2110209.13379 | 37.7747375831097 | -122.412483035979 | (37.7747375831097, -122.412483035979) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 172708 | 107438 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 777 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773131 | 5994721.10495 | 2110354.7884 | 37.7743284514501 | -122.461729889857 | (37.7743284514501, -122.461729889857) | 11 | 6 | 2 | 54 | 11 | |
| 65512 | 108459 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 771 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | 11 | 6 | 2 | 54 | 11 | |||
| 175719 | 123126 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 771 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992555.29457 | 2110202.54859 | 37.7737855300786 | -122.469210678659 | (37.7737855300786, -122.469210678659) | 11 | 6 | 2 | 54 | 11 | |||
| 70116 | 88597 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Jordan Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51542 | 5996162.8 | 2114014.5 | 37.7844599367093 | -122.457007600103 | (37.7844599367093, -122.457007600103) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | |
| 27143 | 193373 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013783.27133 | 2116255.65231 | 37.7916097334637 | -122.396203501097 | (37.7916097334637, -122.396203501097) | 12 | 2 | 9 | 28855 | 6 | |||
| 81471 | 33774 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013834.28126 | 2116198.48682 | 37.7914556085404 | -122.396022998165 | (37.7914556085404, -122.396022998165) | 12 | 2 | 9 | 28855 | 6 | |
| 97909 | 33782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013852.02109 | 2116179.41654 | 37.7914042329729 | -122.395960281264 | (37.7914042329729, -122.395960281264) | 12 | 2 | 9 | 28855 | 6 | |
| 104923 | 33800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013865.37275 | 2116161.97621 | 37.7913570887062 | -122.395912861799 | (37.7913570887062, -122.395912861799) | 12 | 2 | 9 | 28855 | 6 | |
| 110549 | 193372 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013792.54079 | 2116244.01793 | 37.7915783039417 | -122.39617061289 | (37.7915783039417, -122.39617061289) | 12 | 2 | 9 | 28855 | 6 | |||
| 134517 | 33792 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013856.54517 | 2116173.60161 | 37.7913885182281 | -122.395944220262 | (37.7913885182281, -122.395944220262) | 12 | 2 | 9 | 28855 | 6 | |
| 169485 | 33779 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013803.37475 | 2116233.23226 | 37.7915492918181 | -122.396132371028 | (37.7915492918181, -122.396132371028) | 12 | 2 | 9 | 28855 | 6 | |
| 175026 | 33785 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013812.6799 | 2116223.3583 | 37.7915226979635 | -122.396099482817 | (37.7915226979635, -122.396099482817) | 12 | 2 | 9 | 28855 | 6 |
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) );