trees
979 rows where qSpecies_id = 13 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
194402 | 265049 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1595 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 5x5 | 5999367.57953 | 2109424.62482 | 37.7720408355473 | -122.445590032014 | (37.7720408355473, -122.445590032014) | 15 | 5 | 11 | 29492 | 9 | ||
194351 | 265046 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194094 | 124334 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 176 Palm Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 5995958.15323 | 2113125.95358 | 37.782008471168 | -122.457651289636 | (37.782008471168, -122.457651289636) | 11 | 6 | 1 | 54 | 31 | |||
193973 | 99291 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
192999 | 230348 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6004547.50076 | 2096560.53724 | 37.7370134334286 | -122.42675600438 | (37.7370134334286, -122.42675600438) | 2 | 7 | 5 | 63 | 7 | |||
192930 | 193352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1707 McKinnon Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014777.57623 | 2096343.32459 | 37.736990099615 | -122.391370577692 | (37.736990099615, -122.391370577692) | 10 | 3 | 8 | 58 | 1 | |||
192796 | 94708 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 696 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53846 | 5992270.38847 | 2110735.82166 | 37.7752332866791 | -122.470235046427 | (37.7752332866791, -122.470235046427) | 11 | 6 | 2 | 54 | 11 |
192567 | 51877 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4200 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50819 | 6002010.54318716 | 2105309.8458945 | 37.7608931983337 | -122.436153317055 | (37.7608931983337, -122.436153317055) | 15 | 4 | 5 | 28862 | 3 | ||
192239 | 107674 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 ELSIE ST | 1 | Front Yard : Yard | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | 6007164.4 | 2098513.7 | 37.742523993822 | -122.417846597438 | (37.742523993822, -122.417846597438) | 2 | 7 | 7 | 28859 | 2 | |||
192174 | 84410 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 745 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51564 | 5992859.62349 | 2110370.66867 | 37.7742647232802 | -122.468170197773 | (37.7742647232802, -122.468170197773) | 11 | 6 | 2 | 54 | 11 | |
191835 | 136108 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2160 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005089.07981 | 2116957.29381 | 37.7930486667182 | -122.426335311432 | (37.7930486667182, -122.426335311432) | 13 | 9 | 1 | 28858 | 27 | |
191282 | 248924 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Cashmere St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/29/2017 10:39:00 AM | 3 | 3x3 | 6016272 | 2096170 | 37.7365970133228 | -122.386191558691 | (37.7365970133228, -122.386191558691) | 10 | 3 | 8 | 58 | 1 | |
191056 | 130970 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002945.56276 | 2118345.79466 | 37.796739734404 | -122.433851284829 | (37.796739734404, -122.433851284829) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
190423 | 177420 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Cotter St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6001985.26237 | 2093449.72899 | 37.7283266686193 | -122.435392337892 | (37.7283266686193, -122.435392337892) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
190220 | 96333 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 11 Robblee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767342 | 6012676.77436 | 2095976.0416 | 37.7358647977189 | -122.398608271155 | (37.7358647977189, -122.398608271155) | 10 | 3 | 8 | 58 | 1 | |
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 | ||
190092 | 117275 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3431 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 6006713 | 2104938 | 37.7601382406988 | -122.419863171522 | (37.7601382406988, -122.419863171522) | 2 | 4 | 7 | 28859 | 19 | ||||
189937 | 108842 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010509.54502 | 2091864.19266 | 37.7244535448266 | -122.405811727659 | (37.7244535448266, -122.405811727659) | 10 | 3 | 7 | 309 | 28 | |
189780 | 95071 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 319 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767740 | 5990554.377 | 2113243.49278 | 37.7820193005134 | -122.476354274932 | (37.7820193005134, -122.476354274932) | 11 | 6 | 2 | 55 | 26 | |
189702 | 230349 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 222 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001969.40377 | 2096197.83075 | 37.73587142571 | -122.435643686718 | (37.73587142571, -122.435643686718) | 2 | 7 | 5 | 63 | 7 | |||
189600 | 103809 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
189587 | 230312 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2901 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009544.39548 | 2104509.50944 | 37.7591208063082 | -122.410040430547 | (37.7591208063082, -122.410040430547) | 2 | 4 | 7 | 28859 | 19 | |||
189398 | 130985 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2098 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999249.25927 | 2121180.66389 | 37.8043130782603 | -122.446845381305 | (37.8043130782603, -122.446845381305) | 13 | 9 | 1 | 57 | 17 | |||
189282 | 177442 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 67 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010267.21749 | 2091493.90642 | 37.7234232608607 | -122.406623343098 | (37.7234232608607, -122.406623343098) | 10 | 3 | 7 | 309 | 28 | |||
189101 | 47094 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 336 Willard North St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51142 | 5996292.61494047 | 2110619.69439374 | 37.7751461518448 | -122.456312937477 | (37.7751461518448, -122.456312937477) | 11 | 6 | 2 | 54 | 16 | ||
188951 | 115977 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011639.0005 | 2091249.90123 | 37.7228299259539 | -122.40186416949 | (37.7228299259539, -122.40186416949) | 10 | 3 | 7 | 309 | 28 | |||
188688 | 13238 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2322 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1998 12:00:00 AM | 3 | 3X3 | 6001219.43305 | 2119376.81704 | 37.7994725475626 | -122.439898035919 | (37.7994725475626, -122.439898035919) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
188424 | 143862 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3141 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5985712.91878 | 2113178.76157 | 37.781559604533 | -122.493098498008 | (37.781559604533, -122.493098498008) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
188023 | 130971 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6002947.99505 | 2118332.47012 | 37.7967032866916 | -122.43384191569 | (37.7967032866916, -122.43384191569) | 13 | 9 | 1 | 57 | 17 | |||
187624 | 246941 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 269 Frederick St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5998752.12288 | 2107600.57401 | 37.7669972990085 | -122.447587610674 | (37.7669972990085, -122.447587610674) | 15 | 5 | 11 | 29492 | 9 | |||
187553 | 230331 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 217 Montcalm St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 6ft | 6009886.65194 | 2099610.71375 | 37.745688979177 | -122.408511178357 | (37.745688979177, -122.408511178357) | 2 | 7 | 7 | 28859 | 2 | |||
187522 | 109253 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1355 46th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773041 | 5981790.7 | 2105864.5 | 37.7612466017789 | -122.506124767382 | (37.7612466017789, -122.506124767382) | 1 | 8 | 3 | 56 | 35 |
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 |
187279 | 193367 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013957.97413 | 2116198.08841 | 37.7914613956649 | -122.395594991931 | (37.7914613956649, -122.395594991931) | 12 | 2 | 9 | 28855 | 6 | |||
186900 | 208835 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1673 18th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990563.36006 | 2104017.9082 | 37.7566888695243 | -122.475649328274 | (37.7566888695243, -122.475649328274) | 1 | 8 | 4 | 56 | 12 | |||
186711 | 5393 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 347 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2014 12:00:00 AM | 3 | 6x7 | 6004928.4905 | 2106245.94468 | 37.7636288523174 | -122.426128059965 | (37.7636288523174, -122.426128059965) | 8 | 4 | 5 | 28859 | 19 | ||
186211 | 247777 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 240 30th St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005014.99439 | 2098457.52943 | 37.7422485651112 | -122.425274616848 | (37.7422485651112, -122.425274616848) | 2 | 7 | 5 | 63 | 22 | |||
186183 | 43147 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 249 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767437 | 6005979.23995 | 2092615.63792 | 37.7262624547464 | -122.421525745221 | (37.7262624547464, -122.421525745221) | 9 | 7 | 7 | 309 | 5 |
186179 | 230297 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008685.11737 | 2101744.284 | 37.7514799242568 | -122.412816735721 | (37.7514799242568, -122.412816735721) | 2 | 4 | 7 | 28859 | 19 | |||
186106 | 193340 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1280 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015310.01646 | 2102516.50346 | 37.7539699023888 | -122.38996077348 | (37.7539699023888, -122.38996077348) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
185828 | 230353 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 210 Moffitt St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002369.42033 | 2097177.7522 | 37.7385847765781 | -122.434330709794 | (37.7385847765781, -122.434330709794) | 2 | 7 | 5 | 63 | 7 | |||
185410 | 112790 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Joice St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 11 | 3x3 | 6010307.81813 | 2116296.03331 | 37.7915266163113 | -122.408231437935 | (37.7915266163113, -122.408231437935) | 5 | 1 | 10 | 28857 | 21 | |||
185258 | 230286 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3714 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005720.70834 | 2100540.11628 | 37.748006719144 | -122.422982458079 | (37.748006719144, -122.422982458079) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
184918 | 120093 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 655 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5987822.40031 | 2111507.4982 | 37.7770939337825 | -122.485678099475 | (37.7770939337825, -122.485678099475) | 11 | 6 | 2 | 55 | 26 | |||
184756 | 98077 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 731 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6001992.2 | 2108216.2 | 37.7688722929253 | -122.436424775079 | (37.7688722929253, -122.436424775079) | 15 | 5 | 5 | 29492 | 3 | |||||
184577 | 89191 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
184483 | 105717 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 409 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5987766.35137 | 2113121.02315 | 37.7815209517603 | -122.485990454458 | (37.7815209517603, -122.485990454458) | 11 | 6 | 2 | 55 | 26 | |||
184401 | 95565 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239 | 2102086.6 | 37.7521126499553 | -122.431674496468 | (37.7521126499553, -122.431674496468) | 2 | 4 | 5 | 28862 | 22 | |
184096 | 99876 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1295X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003506.1 | 2095452.4 | 37.7339118061219 | -122.430277556689 | (37.7339118061219, -122.430277556689) | 2 | 7 | 5 | 28861 | 25 | |||
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 | |
183758 | 8223 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:24:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
183737 | 193360 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 208 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014042.14131 | 2116274.34783 | 37.7916754675957 | -122.395309117238 | (37.7916754675957, -122.395309117238) | 12 | 2 | 9 | 28855 | 6 | |||
183715 | 114593 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1 BRADFORD ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15 | 6x9 | 6009441 | 2096050 | 37.7358870660731 | -122.409800886333 | (37.7358870660731, -122.409800886333) | 10 | 7 | 7 | 28859 | 2 | |||
183036 | 230347 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1801 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004579.28935 | 2098353.48586 | 37.7419382603343 | -122.426773743522 | (37.7419382603343, -122.426773743522) | 2 | 7 | 5 | 63 | 7 | |||
182757 | 230303 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2784 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010083.7548 | 2102826.74916 | 37.7545305388726 | -122.408056386695 | (37.7545305388726, -122.408056386695) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
182336 | 33780 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013824.14126 | 2116210.79912 | 37.7914888510795 | -122.39605894586 | (37.7914888510795, -122.39605894586) | 12 | 2 | 9 | 28855 | 6 | |
182294 | 108925 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 770705 | 6009037.7 | 2097340 | 37.7394065164512 | -122.411286359806 | (37.7394065164512, -122.411286359806) | 10 | 7 | 7 | 28859 | 2 | ||
181538 | 87076 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2565 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006601.66741 | 2120051.34913 | 37.8016295480248 | -122.421321483111 | (37.8016295480248, -122.421321483111) | 5 | 9 | 1 | 28858 | 32 | |
181497 | 193332 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015304.05705 | 2102667.26372 | 37.7543835276007 | -122.38999191342 | (37.7543835276007, -122.38999191342) | 10 | 3 | 8 | 28856 | 29 | |||
180960 | 94054 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2010 12:00:00 AM | 3 | 3x9 | 6005268.81764 | 2109524.34557 | 37.7726497850887 | -122.425184266439 | (37.7726497850887, -122.425184266439) | 7 | 9 | 11 | 28852 | 10 | ||
180872 | 122238 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 5ft | 5990263.53816 | 2114709.99218 | 37.786029027112 | -122.477467650491 | (37.786029027112, -122.477467650491) | 11 | 6 | 2 | 55 | 26 | ||
180821 | 208839 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992959.48741 | 2098205.81206 | 37.74086896193 | -122.466940197353 | (37.74086896193, -122.466940197353) | 1 | 8 | 4 | 59 | 40 | |||
180648 | 57578 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1916 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1976 12:00:00 AM | 20 | 3x3 | Permit Number 16445 | 6012032 | 2105628 | 37.7623310447467 | -122.401515665193 | (37.7623310447467, -122.401515665193) | 8 | 3 | 8 | 28856 | 29 | |
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 | |||
180587 | 78302 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 575 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770704 | 5985015.95011 | 2111950.61478 | 37.7781466811201 | -122.49541903513 | (37.7781466811201, -122.49541903513) | 11 | 6 | 2 | 55 | 26 | |
180340 | 208846 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 36 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995163.31564 | 2091909.32906 | 37.7237073072365 | -122.45886447242 | (37.7237073072365, -122.45886447242) | 9 | 8 | 4 | 28861 | 24 | |||
179999 | 94820 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1227 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53900 | 5992334 | 2107055.2 | 37.7651309632558 | -122.469746983482 | (37.7651309632558, -122.469746983482) | 11 | 8 | 11 | 56 | 12 | |
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 | |||
179932 | 64577 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2011 12:00:00 AM | 3 | 4x4 1/2 | Permit Number 767979 | 6006252.59051018 | 2104959.36998238 | 37.7601709691535 | -122.42145702923 | (37.7601709691535, -122.42145702923) | 2 | 4 | 5 | 28859 | 19 | |
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 | ||
179834 | 99959 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 19 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2014 12:00:00 AM | 28 | 3x3 | Permit Number 772856 | 6009640 | 2110980 | 37.776892640268 | -122.410166607108 | (37.776892640268, -122.410166607108) | 8 | 2 | 9 | 28853 | 34 | |
179747 | 193343 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 698 Arkansas St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012989.11402 | 2103849.31958 | 37.7575005373464 | -122.398080555283 | (37.7575005373464, -122.398080555283) | 10 | 3 | 8 | 28856 | 29 | |||
179581 | 105038 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 46 Atalaya Ter | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2015 12:00:00 AM | 3 | 3X4 | Permit Number 771123 | 5998888.1 | 2110865.6 | 37.7759699989755 | -122.447352315284 | (37.7759699989755, -122.447352315284) | 15 | 6 | 2 | 29492 | 16 | ||
178999 | 193335 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1260 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015305.18557 | 2102619.11987 | 37.7542513973846 | -122.389984647787 | (37.7542513973846, -122.389984647787) | 10 | 3 | 8 | 28856 | 29 | |||
178911 | 99577 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 301X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2013 12:00:00 AM | 3x3 | 6002944.2 | 2106475.3 | 37.7641462544056 | -122.433007480488 | (37.7641462544056, -122.433007480488) | 15 | 4 | 5 | 28862 | 3 | |||
178900 | 121810 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 106 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5989928.89895 | 2114601.72994 | 37.7857123459232 | -122.478617478776 | (37.7857123459232, -122.478617478776) | 11 | 6 | 2 | 55 | 26 | |||
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 | |
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 | |||
177229 | 103802 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
177003 | 108358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.02459 | 2118966.98612 | 37.7983986535418 | -122.436741939704 | (37.7983986535418, -122.436741939704) | 13 | 9 | 1 | 57 | 17 | |
176927 | 130997 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007578.93915 | 2119952.78886 | 37.8014139751467 | -122.417932677574 | (37.8014139751467, -122.417932677574) | 5 | 1 | 1 | 28858 | 32 | |||
176838 | 70259 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 613 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2014 12:00:00 AM | 1 | 3x5 | Permit Number 771047 | 6009849.60881533 | 2105419.99624628 | 37.7616378989951 | -122.409049096462 | (37.7616378989951, -122.409049096462) | 2 | 4 | 8 | 28859 | 19 | |
176468 | 89189 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
176203 | 103811 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
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 | |||
175599 | 130981 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003397.35892 | 2118675.30556 | 37.7976701136348 | -122.432311513284 | (37.7976701136348, -122.432311513284) | 13 | 9 | 1 | 57 | 17 | |||
175503 | 255550 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 273 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006728 | 2104556 | 37.759090202488 | -122.419784187779 | (37.759090202488, -122.419784187779) | 2 | 4 | 7 | 28859 | 19 | ||||
175263 | 118073 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 449 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985293.2738 | 2112845.54418 | 37.7806201339604 | -122.494525675852 | (37.7806201339604, -122.494525675852) | 11 | 6 | 2 | 55 | 26 | |||
175085 | 89299 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2825 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51902 | 6000069.8 | 2117048.2 | 37.7930132732955 | -122.443708782466 | (37.7930132732955, -122.443708782466) | 13 | 6 | 1 | 29490 | 27 |
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) );