trees
54 rows where Supervisor Districts = 9 and qSpecies_id = 2 sorted by SiteOrder
This data as json, CSV (advanced)
These facets timed out: Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8599 | 262043 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 245 11th St | : Cutout | Tree | Private 2 | FUF | 04/14/2020 12:00:00 AM | 3 | Permit Number 785251 | 6008265.74007 | 2109435.35593 | 37.7725742877847 | -122.414811260337 | (37.7725742877847, -122.414811260337) | 8 | 2 | 9 | 28853 | 34 | ||
56473 | 93743 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53322 | 6011367.4 | 2112778.7 | 37.7819281242694 | -122.40431760427 | (37.7819281242694, -122.40431760427) | 6 | 2 | 9 | 28853 | 34 | |||
22322 | 85732 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 901 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011193.193535 | 2112605.183477 | 37.7814419523203 | -122.404908060988 | (37.7814419523203, -122.404908060988) | 14 | 2 | 9 | 28853 | 34 | ||
43681 | 85727 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1025 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2007 12:00:00 AM | 3 | 3x3 | 6010365 | 2111820 | 37.7792396944918 | -122.40771784288 | (37.7792396944918, -122.40771784288) | 14 | 2 | 9 | 28853 | 34 | ||
59431 | 85827 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1345 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008580 | 2110114 | 37.7744553372704 | -122.413772211324 | (37.7744553372704, -122.413772211324) | 8 | 2 | 9 | 28853 | 34 | ||
60072 | 85828 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
94874 | 29047 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 244 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/2012 12:00:00 AM | 3 | 3x3 | 6008230.7231961 | 2109406.8924959 | 37.7724941663121 | -122.414930372766 | (37.7724941663121, -122.414930372766) | 8 | 2 | 9 | 28853 | 19 | ||
115917 | 85721 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1049 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010189 | 2111652 | 37.7787685519268 | -122.408314849736 | (37.7787685519268, -122.408314849736) | 14 | 2 | 9 | 28853 | 34 | ||
129205 | 103834 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
134990 | 85820 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1501 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6008072 | 2109608 | 37.7730374398788 | -122.415493654294 | (37.7730374398788, -122.415493654294) | 8 | 2 | 9 | 28853 | 19 | ||
137137 | 85817 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1581 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007957.739489 | 2109502.485486 | 37.7727412989479 | -122.415881423672 | (37.7727412989479, -122.415881423672) | 8 | 2 | 9 | 28853 | 19 | ||
143563 | 32720 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
144650 | 85708 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 964 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010738 | 2112218 | 37.7803533827236 | -122.406455527485 | (37.7803533827236, -122.406455527485) | 14 | 2 | 9 | 28853 | 34 | ||
158553 | 85822 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1499X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008077.269337 | 2109627.004998 | 37.7730899192917 | -122.415476772701 | (37.7730899192917, -122.415476772701) | 8 | 2 | 9 | 28853 | 34 | ||
165962 | 85737 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 843 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011572.165806 | 2112967.734183 | 37.7824586081659 | -122.40362250947 | (37.7824586081659, -122.40362250947) | 6 | 2 | 9 | 28853 | 34 | ||
167046 | 85824 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1399X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008422.422874 | 2109956.642426 | 37.7740144201285 | -122.414306166437 | (37.7740144201285, -122.414306166437) | 8 | 2 | 9 | 28853 | 34 | ||
168045 | 85818 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1525 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007957 | 2109502 | 37.7727399243445 | -122.415883947269 | (37.7727399243445, -122.415883947269) | 8 | 2 | 9 | 28853 | 19 | ||
179089 | 85719 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1175 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009405 | 2110901 | 37.7766625499179 | -122.410973965657 | (37.7766625499179, -122.410973965657) | 8 | 2 | 9 | 28853 | 34 | ||
184398 | 115346 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 398X HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854 | 2114630 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | 6 | 2 | 9 | 28855 | 6 | |
188346 | 85707 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 960 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010763 | 2112242 | 37.7804206796364 | -122.406370731962 | (37.7804206796364, -122.406370731962) | 14 | 2 | 9 | 28853 | 34 | ||
192832 | 85814 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1607 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007663 | 2109095 | 37.7716058657462 | -122.416872087793 | (37.7716058657462, -122.416872087793) | 8 | 2 | 9 | 28853 | 19 | ||
193856 | 85810 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1675 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516 | 2108769 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | 8 | 2 | 9 | 28853 | 19 | ||
193910 | 85695 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
41333 | 88753 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
7382 | 85829 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
10234 | 85811 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1675 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516 | 2108769 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | 8 | 2 | 9 | 28853 | 19 | ||
28890 | 85821 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1501 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6008072 | 2109608 | 37.7730374398788 | -122.415493654294 | (37.7730374398788, -122.415493654294) | 8 | 2 | 9 | 28853 | 19 | ||
29186 | 85712 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1144 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009550 | 2111081 | 37.7771649174601 | -122.410485079371 | (37.7771649174601, -122.410485079371) | 8 | 2 | 9 | 28853 | 34 | ||
29881 | 85825 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1399X Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008422.422874 | 2109956.642426 | 37.7740144201285 | -122.414306166437 | (37.7740144201285, -122.414306166437) | 8 | 2 | 9 | 28853 | 34 | ||
40281 | 103835 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
56510 | 85815 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1607 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007663 | 2109095 | 37.7716058657462 | -122.416872087793 | (37.7716058657462, -122.416872087793) | 8 | 2 | 9 | 28853 | 19 | ||
96508 | 115347 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 398X HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854 | 2114630 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | 6 | 2 | 9 | 28855 | 6 | |
113947 | 85720 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1133 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009666.355548 | 2111144.506481 | 37.777345813652 | -122.410087051507 | (37.777345813652, -122.410087051507) | 8 | 2 | 9 | 28853 | 34 | ||
138301 | 32721 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
138694 | 85696 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
171702 | 85728 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1025 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2007 12:00:00 AM | 3 | 3x3 | 6010365 | 2111820 | 37.7792396944918 | -122.40771784288 | (37.7792396944918, -122.40771784288) | 14 | 2 | 9 | 28853 | 34 | ||
173913 | 85733 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 901 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 4 | 3x3 | 6011193.193535 | 2112605.183477 | 37.7814419523203 | -122.404908060988 | (37.7814419523203, -122.404908060988) | 14 | 2 | 9 | 28853 | 34 | ||
43002 | 32722 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768334 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
73332 | 85812 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1675 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516 | 2108769 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | 8 | 2 | 9 | 28853 | 19 | ||
93337 | 85826 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1399X Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008422.422874 | 2109956.642426 | 37.7740144201285 | -122.414306166437 | (37.7740144201285, -122.414306166437) | 8 | 2 | 9 | 28853 | 34 | ||
184033 | 103836 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
192345 | 85697 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
193248 | 85830 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
73027 | 85698 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
114647 | 103837 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
179694 | 85831 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
183182 | 85813 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1675 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516 | 2108769 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | 8 | 2 | 9 | 28853 | 19 | ||
34950 | 103838 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
170951 | 85832 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
84916 | 85833 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
87848 | 88749 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
98572 | 88750 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
33153 | 88751 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
159193 | 88752 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 |
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) );