trees
69 rows where Police Districts = 5 and qSpecies_id = 6
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
664 | 262379 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 925 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2020 12:00:00 AM | 3 | 3x3 | 5998032 | 2106999 | 37.7653043483693 | -122.450035028723 | (37.7653043483693, -122.450035028723) | 15 | 5 | 11 | 29492 | 9 | |
1972 | 64568 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1888 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51776 | 6000584.4368 | 2111720.243 | 37.7784134187795 | -122.441545602938 | (37.7784134187795, -122.441545602938) | 15 | 5 | 11 | 29490 | 41 | |
2314 | 227584 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 660 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002549.44678 | 2108867.98451 | 37.7706935809695 | -122.434543909369 | (37.7706935809695, -122.434543909369) | 15 | 5 | 11 | 29492 | 9 | |||
3613 | 227144 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997515.89511 | 2105898.72706 | 37.7622537322474 | -122.451740727559 | (37.7622537322474, -122.451740727559) | 15 | 5 | 11 | 29492 | 9 | |||
8734 | 227141 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997670.57496 | 2105917.36363 | 37.7623137611024 | -122.451207095032 | (37.7623137611024, -122.451207095032) | 15 | 5 | 11 | 29492 | 9 | |||
19677 | 39613 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 577 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42206 | 5996839.91957309 | 2107330.11638831 | 37.7661452244472 | -122.454182049235 | (37.7661452244472, -122.454182049235) | 15 | 5 | 11 | 29492 | 12 | ||
24082 | 88257 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536 | 2106665 | 37.76441609532 | -122.448267765661 | (37.76441609532, -122.448267765661) | 15 | 5 | 11 | 29492 | 9 | ||
24170 | 41808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999945.6987 | 2112165.7027 | 37.7796001259133 | -122.443787242166 | (37.7796001259133, -122.443787242166) | 15 | 5 | 1 | 29490 | 16 | |
25262 | 227146 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997461.46496 | 2105891.36034 | 37.7622303876487 | -122.451928448466 | (37.7622303876487, -122.451928448466) | 15 | 5 | 11 | 29492 | 9 | |||
29694 | 248531 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997658.268 | 2107761.8815 | 37.7673776340728 | -122.451382700243 | (37.7673776340728, -122.451382700243) | 15 | 5 | 11 | 29492 | 9 | |||
29952 | 137671 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | 15 | 5 | 11 | 29490 | 16 | |||
32912 | 94410 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 63 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2010 12:00:00 AM | 3x3 | Permit Number 53650 | 6001682.9 | 2108449.6 | 37.7694955715896 | -122.437511336741 | (37.7694955715896, -122.437511336741) | 15 | 5 | 5 | 29492 | 9 | ||
34441 | 227139 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 280 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997445.29759 | 2106455.57152 | 37.7637786424842 | -122.452025073424 | (37.7637786424842, -122.452025073424) | 15 | 5 | 11 | 29492 | 9 | |||
35869 | 140696 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 162 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997358.0622 | 2109907.9029 | 37.7732528619693 | -122.452575957146 | (37.7732528619693, -122.452575957146) | 15 | 5 | 11 | 29492 | 16 | |||
37187 | 227140 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997729.62744 | 2105927.06337 | 37.7623437750648 | -122.451003555094 | (37.7623437750648, -122.451003555094) | 15 | 5 | 11 | 29492 | 9 | |||
37946 | 227574 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 11 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002707.53405 | 2106779.67068 | 37.764968555288 | -122.433847795453 | (37.764968555288, -122.433847795453) | 15 | 5 | 5 | 28862 | 3 | |||
40176 | 254849 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 4x4 | 5998281 | 2110435 | 37.7747529724027 | -122.449421390814 | (37.7747529724027, -122.449421390814) | 15 | 5 | 11 | 29492 | 16 | ||
41094 | 51607 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) | 15 | 5 | 11 | 29492 | 9 |
41803 | 48448 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 238 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | 7 | Permit Number 45820 | 5997868.1487 | 2109737.2703 | 37.7728135614974 | -122.45079920227 | (37.7728135614974, -122.45079920227) | 15 | 5 | 11 | 29492 | 16 | ||
44290 | 140758 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.7815689287559 | -122.442554464995 | (37.7815689287559, -122.442554464995) | 15 | 5 | 1 | 29490 | 16 | |||
50352 | 227104 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 35 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998773.50017 | 2105374.28879 | 37.7608857006352 | -122.447353415547 | (37.7608857006352, -122.447353415547) | 15 | 5 | 11 | 29492 | 12 | |||
60778 | 227145 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997490.50245 | 2105894.70205 | 37.7622412262784 | -122.451828260367 | (37.7622412262784, -122.451828260367) | 15 | 5 | 11 | 29492 | 9 | |||
63992 | 39614 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 577 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42206 | 5996839.91957309 | 2107330.11638831 | 37.7661452244472 | -122.454182049235 | (37.7661452244472, -122.454182049235) | 15 | 5 | 11 | 29492 | 12 | ||
65509 | 247762 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 61 Alpine Ter | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6001652.09386 | 2108463.90123 | 37.7695330877219 | -122.437618918075 | (37.7695330877219, -122.437618918075) | 15 | 5 | 5 | 29492 | 9 | |||
77162 | 102385 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
77482 | 248399 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 115 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998223.6499 | 2108104.3812 | 37.7683504092774 | -122.449451812394 | (37.7683504092774, -122.449451812394) | 15 | 5 | 11 | 29492 | 9 | |||
79351 | 227582 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 288 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000368.64642 | 2106819.94984 | 37.7649461504603 | -122.441940289115 | (37.7649461504603, -122.441940289115) | 15 | 5 | 5 | 28862 | 3 | |||
80935 | 207042 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 40 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995660.33467 | 2100048.89738 | 37.746085134133 | -122.457735064227 | (37.746085134133, -122.457735064227) | 1 | 5 | 4 | 59 | 40 | |||
85418 | 227105 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998543.73083 | 2106633.91182 | 37.7643311769734 | -122.448238788212 | (37.7643311769734, -122.448238788212) | 15 | 5 | 11 | 29492 | 9 | |||
87404 | 88256 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536 | 2106665 | 37.76441609532 | -122.448267765661 | (37.76441609532, -122.448267765661) | 15 | 5 | 11 | 29492 | 9 | ||
99415 | 51233 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.7637059584567 | -122.452316160446 | (37.7637059584567, -122.452316160446) | 15 | 5 | 11 | 29492 | 9 | |||
100769 | 254857 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1353 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 5x5 | 6001388 | 2110371 | 37.7747544855289 | -122.438669077925 | (37.7747544855289, -122.438669077925) | 15 | 5 | 11 | 29492 | 10 | |
103947 | 51230 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.7637059584567 | -122.452316160446 | (37.7637059584567, -122.452316160446) | 15 | 5 | 11 | 29492 | 9 | |||
106631 | 51232 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.7637059584567 | -122.452316160446 | (37.7637059584567, -122.452316160446) | 15 | 5 | 11 | 29492 | 9 | |||
108856 | 88244 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4330 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51231 | 6000585 | 2105809 | 37.7621826583789 | -122.441119442302 | (37.7621826583789, -122.441119442302) | 15 | 5 | 5 | 28862 | 3 | |||
111372 | 105757 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1278 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2014 12:00:00 AM | 10 | 3x3 | Permit Number 771070 | 5999104.9 | 2105310.4 | 37.7607292094813 | -122.446202658218 | (37.7607292094813, -122.446202658218) | 15 | 5 | 5 | 28862 | 3 | |
112736 | 227106 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998542.97606 | 2106650.29925 | 37.7643761295797 | -122.448242578852 | (37.7643761295797, -122.448242578852) | 15 | 5 | 11 | 29492 | 9 | |||
114201 | 227581 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4330 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000546.38941 | 2105812.04672 | 37.7621888245883 | -122.441253199888 | (37.7621888245883, -122.441253199888) | 15 | 5 | 5 | 28862 | 3 | |||
114382 | 102384 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
117364 | 88527 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1501 06th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51477 | 5994255.6 | 2105256.2 | 37.7603022580943 | -122.462970154312 | (37.7603022580943, -122.462970154312) | 1 | 5 | 4 | 56 | 12 | |||
117490 | 227576 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 31 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001461.49083 | 2108058.43392 | 37.768408936048 | -122.438249153978 | (37.768408936048, -122.438249153978) | 15 | 5 | 5 | 29492 | 3 | |||
121708 | 227138 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 280 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997418.34488 | 2106450.27883 | 37.7637625662163 | -122.452117912216 | (37.7637625662163, -122.452117912216) | 15 | 5 | 11 | 29492 | 9 | |||
125420 | 245893 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001728.4463 | 2109399.5631 | 37.772106523732 | -122.437421829009 | (37.772106523732, -122.437421829009) | 15 | 5 | 11 | 29492 | 9 | |||
126848 | 41809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 2 | Permit Number 42201 | 5999967.3577 | 2112168.7485 | 37.7796097242619 | -122.443712533479 | (37.7796097242619, -122.443712533479) | 15 | 5 | 1 | 29490 | 16 | |
134071 | 227103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998021.55452 | 2105968.74453 | 37.7624749295086 | -122.449996897152 | (37.7624749295086, -122.449996897152) | 15 | 5 | 11 | 29492 | 9 | |||
139732 | 88255 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 115 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51240 | 5998220 | 2108137 | 37.7684397634087 | -122.44946678759 | (37.7684397634087, -122.44946678759) | 15 | 5 | 11 | 29492 | 9 | |||
142495 | 88724 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1009 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742 | 2109408 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | 15 | 5 | 11 | 29492 | 9 | ||
145798 | 140302 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 143 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997780.8586 | 2110053.3207 | 37.773676357183 | -122.451123943319 | (37.773676357183, -122.451123943319) | 15 | 5 | 11 | 29492 | 16 | |||
146189 | 227583 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002133.89525 | 2108814.30402 | 37.7705225892763 | -122.435977464701 | (37.7705225892763, -122.435977464701) | 15 | 5 | 11 | 29492 | 9 | |||
149331 | 227142 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997609.1285 | 2105909.8393 | 37.7622895828302 | -122.451419071551 | (37.7622895828302, -122.451419071551) | 15 | 5 | 11 | 29492 | 9 | |||
155024 | 83961 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 180 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50859 | 5997460.19616594 | 2106774.33360384 | 37.7646547355545 | -122.451996543237 | (37.7646547355545, -122.451996543237) | 15 | 5 | 11 | 29492 | 9 | ||
156644 | 41807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999913.2102 | 2112161.3032 | 37.7795861928813 | -122.443899317319 | (37.7795861928813, -122.443899317319) | 15 | 5 | 1 | 29490 | 16 | |
158383 | 206998 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 223 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994252.21923 | 2105280.12164 | 37.7603677459862 | -122.462983582339 | (37.7603677459862, -122.462983582339) | 1 | 5 | 4 | 56 | 12 | |||
159564 | 247309 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 220 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002790.9139 | 2109368.8454 | 37.7720825259473 | -122.433744475031 | (37.7720825259473, -122.433744475031) | 15 | 5 | 11 | 29492 | 9 | |||
162838 | 227575 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001460.70601 | 2108045.90078 | 37.7683744785129 | -122.43825097062 | (37.7683744785129, -122.43825097062) | 15 | 5 | 5 | 29492 | 3 | |||
163537 | 227137 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 180 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997464.66679 | 2106771.33887 | 37.7646467688489 | -122.451980864539 | (37.7646467688489, -122.451980864539) | 15 | 5 | 11 | 29492 | 9 | |||
163976 | 140699 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 224 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998816.4363 | 2109919.7991 | 37.7733689769062 | -122.447532121663 | (37.7733689769062, -122.447532121663) | 15 | 5 | 11 | 29492 | 16 | |||
164479 | 88270 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 288 States St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51256 | 6000346 | 2106829 | 37.7649697094425 | -122.442019266807 | (37.7649697094425, -122.442019266807) | 15 | 5 | 5 | 28862 | 3 | ||
166863 | 140780 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.443550757384 | (37.7796937331341, -122.443550757384) | 15 | 5 | 1 | 29490 | 16 | |||
175230 | 59241 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | Permit Number 18570 | 5998056.20401336 | 2105984.36092392 | 37.7625197907884 | -122.449878183328 | (37.7625197907884, -122.449878183328) | 15 | 5 | 11 | 29492 | 9 | ||
175496 | 64570 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1624 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51014 | 6000044.787 | 2110256.6597 | 37.7743640319269 | -122.443307297711 | (37.7743640319269, -122.443307297711) | 15 | 5 | 11 | 29492 | 16 | |
175521 | 41812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | 15 | 5 | 1 | 29490 | 16 | |
175735 | 247385 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 355 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002203.8017 | 2109776.7723 | 37.7731692596784 | -122.435804531936 | (37.7731692596784, -122.435804531936) | 15 | 5 | 11 | 29492 | 9 | |||
175874 | 52129 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 220 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51660 | 6002806.0471416 | 2109304.34219127 | 37.7719062747483 | -122.433687517115 | (37.7719062747483, -122.433687517115) | 15 | 5 | 11 | 29492 | 9 | ||
176426 | 227107 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 39 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998391.27095 | 2106242.70654 | 37.7632483086886 | -122.448737922716 | (37.7632483086886, -122.448737922716) | 15 | 5 | 11 | 29492 | 9 | |||
180314 | 227143 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997579.79251 | 2105906.80731 | 37.7622795778675 | -122.45152031451 | (37.7622795778675, -122.45152031451) | 15 | 5 | 11 | 29492 | 9 | |||
187106 | 227136 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1536 Willard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996925.1738 | 2105904.39227 | 37.7622354382362 | -122.453784207601 | (37.7622354382362, -122.453784207601) | 15 | 5 | 11 | 29492 | 12 | |||
192746 | 88723 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001771 | 2109412 | 37.7721430915073 | -122.437275523238 | (37.7721430915073, -122.437275523238) | 15 | 5 | 11 | 29492 | 9 | ||
193498 | 47037 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | Permit Number 776491 | 6002280.60768666 | 2108833.96933031 | 37.7705849188534 | -122.435471392977 | (37.7705849188534, -122.435471392977) | 15 | 5 | 11 | 29492 | 9 |
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) );