trees
399 rows where qSpecies_id = 2 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86673 | 85578 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1388 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016034.726363 | 2094416.033185 | 37.7317678372886 | -122.386889636739 | (37.7317678372886, -122.386889636739) | 10 | 3 | 8 | 58 | 1 | ||
86741 | 5370 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 265 DOLORES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2015 03:03:00 PM | 3 | 3X3 | 6005008.2 | 2106862.7 | 37.765326820302 | -122.425896274391 | (37.765326820302, -122.425896274391) | 8 | 4 | 5 | 28853 | 19 | ||
87030 | 95566 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 168 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 772810 | 6004034 | 2101610 | 37.7508490487538 | -122.4288912915 | (37.7508490487538, -122.4288912915) | 2 | 4 | 5 | 28862 | 22 | |
87079 | 225503 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | 6x6 | 6004180.73654 | 2106512.8354 | 37.7643193787498 | -122.428733333891 | (37.7643193787498, -122.428733333891) | 8 | 4 | 5 | 28862 | 3 | |||
88499 | 67550 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31097 | 6011842.05192 | 2104248.01189 | 37.7585313034009 | -122.402075608207 | (37.7585313034009, -122.402075608207) | 10 | 3 | 8 | 28856 | 29 | |
89302 | 85567 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016640.49857 | 2093964.460415 | 37.7305614304838 | -122.384763892339 | (37.7305614304838, -122.384763892339) | 10 | 3 | 8 | 58 | 1 | ||
89928 | 103848 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1524 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006765.8 | 2116184.9 | 37.7910225007002 | -122.420478902042 | (37.7910225007002, -122.420478902042) | 13 | 9 | 10 | 28858 | 21 | ||
90052 | 91421 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2112 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102; tree 1 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 | 6003571 | 2107157 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | 7 | 4 | 5 | 28862 | 3 | ||
90555 | 94243 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2125 BRYANT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |
92580 | 18371 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 636 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 4 | 2X2 | 6010355.57301 | 2105342.69627 | 37.7614539813358 | -122.40729371394 | (37.7614539813358, -122.40729371394) | 10 | 4 | 8 | 28859 | 19 | ||
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 | ||
95100 | 112744 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 235 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2015 12:00:00 AM | Permit Number 774127 | 5993719.1 | 2088769.4 | 37.7150026970857 | -122.463629063261 | (37.7150026970857, -122.463629063261) | 9 | 8 | 6 | 64 | 24 | ||
96836 | 93282 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1383 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004535 | 2100841 | 37.7487658977962 | -122.427104019222 | (37.7487658977962, -122.427104019222) | 2 | 4 | 5 | 28862 | 22 | ||
97145 | 93284 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1347 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004523 | 2101050 | 37.7493390847523 | -122.427160399995 | (37.7493390847523, -122.427160399995) | 2 | 4 | 5 | 28862 | 22 | ||
97816 | 103845 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1540 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006747 | 2116248.1 | 37.7911949727431 | -122.420548437624 | (37.7911949727431, -122.420548437624) | 13 | 9 | 10 | 28858 | 21 | ||
98656 | 93259 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1234 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004459 | 2101704 | 37.7511311972424 | -122.427428297659 | (37.7511311972424, -122.427428297659) | 2 | 4 | 5 | 28862 | 22 | ||
98913 | 434 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010425.4291782 | 2104052.7086425 | 37.7579158746071 | -122.406961184613 | (37.7579158746071, -122.406961184613) | 10 | 4 | 7 | 28859 | 19 | ||
99446 | 86637 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2679 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009805.531856 | 2101750.09748 | 37.7515587115691 | -122.408942599671 | (37.7515587115691, -122.408942599671) | 2 | 4 | 7 | 28859 | 19 | ||
99625 | 93257 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1180X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004390.8 | 2101994.4 | 37.7519247103798 | -122.427684828837 | (37.7519247103798, -122.427684828837) | 2 | 4 | 5 | 28862 | 22 | ||
101718 | 93272 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1689 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004632 | 2099057 | 37.7438729293821 | -122.42664157265 | (37.7438729293821, -122.42664157265) | 2 | 7 | 5 | 63 | 22 | ||
101791 | 230380 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1450 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010406.10881 | 2100942.79845 | 37.7493756698697 | -122.406808829185 | (37.7493756698697, -122.406808829185) | 2 | 4 | 7 | 28859 | 19 | |||
102280 | 131010 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3099 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001935.38679 | 2118702.33437 | 37.7976613236686 | -122.437372261923 | (37.7976613236686, -122.437372261923) | 13 | 9 | 1 | 57 | 17 | |||
102956 | 85559 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 980 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018187.977749 | 2092810.892369 | 37.727479421244 | -122.379333871981 | (37.727479421244, -122.379333871981) | 10 | 3 | 8 | 58 | 1 | ||
103060 | 13103 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1516 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2008 12:00:00 AM | 3 | 3x3 | 6005111 | 2119918 | 37.8011792509168 | -122.426470375667 | (37.8011792509168, -122.426470375667) | 13 | 9 | 1 | 57 | 17 | ||
103120 | 87853 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50764 | 6007684 | 2096571 | 37.7372189966792 | -122.415912430403 | (37.7372189966792, -122.415912430403) | 2 | 7 | 7 | 28859 | 2 | ||
104815 | 93261 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1252 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004465 | 2101602 | 37.7508514683439 | -122.427400283526 | (37.7508514683439, -122.427400283526) | 2 | 4 | 5 | 28862 | 22 | ||
106231 | 96158 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767791 | 6003728 | 2095595 | 37.7343159198258 | -122.429520547314 | (37.7343159198258, -122.429520547314) | 2 | 7 | 5 | 28861 | 25 | |
107426 | 5406 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 392 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2012 12:00:00 AM | 5 | 3x3 | 6004848.6988147 | 2106052.9215434 | 37.7630943465887 | -122.426390290354 | (37.7630943465887, -122.426390290354) | 8 | 4 | 5 | 28859 | 3 | ||
108744 | 230393 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3420 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005567.36067 | 2103163.57677 | 37.7552014816894 | -122.423699232135 | (37.7552014816894, -122.423699232135) | 2 | 4 | 5 | 28859 | 19 | |||
109523 | 108761 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1350 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774645 | 6004491.73804 | 2101024.57628 | 37.7492675091862 | -122.427266693799 | (37.7492675091862, -122.427266693799) | 2 | 4 | 5 | 28862 | 22 |
110634 | 117395 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 544 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778554 | 5991215.4 | 2097083.4 | 37.7376862859043 | -122.47288871789 | (37.7376862859043, -122.47288871789) | 1 | 8 | 4 | 29491 | 40 | ||
111254 | 93275 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1607 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004606 | 2099539 | 37.7451949208192 | -122.42676579302 | (37.7451949208192, -122.42676579302) | 2 | 7 | 5 | 63 | 22 | ||
114396 | 95387 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 949 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767255 | 6001944 | 2101334 | 37.7499727001327 | -122.436098944037 | (37.7499727001327, -122.436098944037) | 2 | 4 | 5 | 28862 | 22 | |
115105 | 81753 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 565 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52385 | 6013577.35874 | 2104447.02049 | 37.7591744400611 | -122.396088040728 | (37.7591744400611, -122.396088040728) | 10 | 3 | 8 | 28856 | 29 | |
115916 | 94259 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2777X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.409573390285 | (37.7597963985886, -122.409573390285) | 2 | 4 | 8 | 28859 | 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 | ||
117680 | 149924 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 595 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 778997 | 6015473.11557 | 2106243.07147 | 37.764211304535 | -122.389656990574 | (37.764211304535, -122.389656990574) | 14 | 3 | 8 | 28856 | 29 | |
118417 | 93283 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1377 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004533 | 2100877 | 37.7488646323576 | -122.427113499044 | (37.7488646323576, -122.427113499044) | 2 | 4 | 5 | 28862 | 22 | ||
119339 | 96670 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1425 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2012 12:00:00 AM | 4 | 4x4 | 6015007.7446 | 2095379.2401 | 37.7343556918302 | -122.390507431087 | (37.7343556918302, -122.390507431087) | 10 | 3 | 8 | 58 | 1 | ||
121444 | 93256 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1120 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | Owner Michael Freethy signed agreement on 12/26/09 to maintain curb cut added within 4' of tree after tree was planted | 6004410 | 2102371 | 37.7529598520175 | -122.427645261537 | (37.7529598520175, -122.427645261537) | 2 | 4 | 5 | 28862 | 22 | |
122477 | 93276 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1603 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004604 | 2099562 | 37.7452579604553 | -122.426774346316 | (37.7452579604553, -122.426774346316) | 2 | 7 | 5 | 63 | 22 | ||
123120 | 193407 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 541 Missouri St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6013570.69062 | 2104547.33874 | 37.7594495210946 | -122.396118132954 | (37.7594495210946, -122.396118132954) | 10 | 3 | 8 | 28856 | 29 | |||
127073 | 85583 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1500 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015418.292964 | 2094875.921588 | 37.7329964475839 | -122.389052889382 | (37.7329964475839, -122.389052889382) | 10 | 3 | 8 | 58 | 1 | ||
128455 | 93274 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1613 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004607 | 2099503 | 37.7450961296299 | -122.426759771954 | (37.7450961296299, -122.426759771954) | 2 | 7 | 5 | 63 | 22 | ||
128665 | 95423 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767291 | 5989736.1 | 2100494 | 37.7469651560486 | -122.478252612879 | (37.7469651560486, -122.478252612879) | 1 | 8 | 3 | 29491 | 35 | |
128897 | 87882 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1771 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50853 | 6002283.00879 | 2120864.77597 | 37.8036185768076 | -122.436324238766 | (37.8036185768076, -122.436324238766) | 13 | 9 | 1 | 57 | 17 | |
129033 | 85569 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1260 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016711.517151 | 2093911.519633 | 37.7304199931233 | -122.384514682139 | (37.7304199931233, -122.384514682139) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
129758 | 5348 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004789.90631 | 2107160.01438 | 37.7661308355062 | -122.426672475382 | (37.7661308355062, -122.426672475382) | 8 | 4 | 5 | 28862 | 3 | |
132768 | 95660 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 431 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767422 | 6010656.7 | 2092697.9 | 37.7267509601998 | -122.40536171554 | (37.7267509601998, -122.40536171554) | 10 | 3 | 7 | 309 | 28 | |
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 | ||
135595 | 93285 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1289 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004504 | 2101389 | 37.7502688255514 | -122.427250247058 | (37.7502688255514, -122.427250247058) | 2 | 4 | 5 | 28862 | 22 | ||
136291 | 5477 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005026.79294 | 2104432.16218 | 37.7586541903676 | -122.425658960999 | (37.7586541903676, -122.425658960999) | 2 | 4 | 5 | 28859 | 19 | |||
136361 | 5577 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1041 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2010 12:00:00 AM | 3 | 3x3 | 6005148.8764838 | 2102292.2742932 | 37.7527854561506 | -122.425084482909 | (37.7527854561506, -122.425084482909) | 2 | 4 | 5 | 28859 | 19 | ||
136782 | 5343 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 180 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 02:20:00 PM | 3 | 3X3 | 6004776.79611 | 2107352.0132 | 37.7666572770255 | -122.426731495165 | (37.7666572770255, -122.426731495165) | 8 | 4 | 5 | 28862 | 3 | ||
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 | ||
138954 | 108977 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2970 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773794 | 6008402.2 | 2103930 | 37.7574655215329 | -122.413949705223 | (37.7574655215329, -122.413949705223) | 2 | 4 | 7 | 28859 | 19 |
139333 | 93290 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1071 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004519 | 2102665.5 | 37.7537746450798 | -122.427289295317 | (37.7537746450798, -122.427289295317) | 2 | 4 | 5 | 28862 | 22 | ||
139812 | 114762 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 27X Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2015 12:00:00 AM | Permit Number 46967 | 6005096.96871 | 2096699.60241 | 37.7374263260205 | -122.424866136467 | (37.7374263260205, -122.424866136467) | 2 | 7 | 5 | 28859 | 2 | |||
140577 | 93287 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1279 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004501 | 2101449 | 37.7504334019421 | -122.427264894728 | (37.7504334019421, -122.427264894728) | 2 | 4 | 5 | 28862 | 22 | ||
142124 | 88687 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 135 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2008 12:00:00 AM | Permit Number 51638 | 6003417 | 2105051 | 37.7602622759886 | -122.431270527939 | (37.7602622759886, -122.431270527939) | 2 | 4 | 5 | 28862 | 3 | |||
142517 | 93280 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1485 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004568 | 2100246 | 37.7471340314151 | -122.426947534581 | (37.7471340314151, -122.426947534581) | 2 | 7 | 5 | 63 | 22 | ||
143258 | 93294 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1037 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004436 | 2102861 | 37.7543067479004 | -122.427590255736 | (37.7543067479004, -122.427590255736) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |
144023 | 100465 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010498.9 | 2102571.5 | 37.7538529165301 | -122.40660271212 | (37.7538529165301, -122.40660271212) | 10 | 4 | 7 | 28859 | 19 | |||
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 | ||
147253 | 93292 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1059 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004443 | 2102732 | 37.7539529400822 | -122.427556858105 | (37.7539529400822, -122.427556858105) | 2 | 4 | 5 | 28862 | 22 | ||
147278 | 100431 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Stonecrest Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
147657 | 85568 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1264 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016691.22613 | 2093926.645569 | 37.7304604038472 | -122.384585884949 | (37.7304604038472, -122.384585884949) | 10 | 3 | 8 | 58 | 1 | ||
151915 | 63015 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 75 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/16/2014 12:00:00 AM | Permit Number 772837 | 6007421.64921795 | 2097871.12423845 | 37.7407740975251 | -122.416911586715 | (37.7407740975251, -122.416911586715) | 2 | 7 | 7 | 28859 | 2 | ||
152696 | 95786 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3431 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767530 | 6005503 | 2103116 | 37.7550672136514 | -122.423918427558 | (37.7550672136514, -122.423918427558) | 2 | 4 | 5 | 28859 | 19 | |
154650 | 11953 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1436 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 6 | 3X4 | 6015854.7568499 | 2096315.1604747 | 37.7369724919298 | -122.387644284768 | (37.7369724919298, -122.387644284768) | 10 | 3 | 8 | 58 | 1 | ||
155368 | 93268 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1574 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2015 05:47:00 AM | 3 | 3x3 | 6004569 | 2099722 | 37.7456953047191 | -122.42690676352 | (37.7456953047191, -122.42690676352) | 2 | 7 | 5 | 63 | 22 | ||
156287 | 117298 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1590 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778522 | 5993741.6 | 2104678.7 | 37.7586869726954 | -122.464705888807 | (37.7586869726954, -122.464705888807) | 1 | 8 | 4 | 56 | 12 | ||
157770 | 5356 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 220 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2015 03:17:00 PM | 3 | 6x6 | posted for removal 3/27/14 DPW | 6004796.95819 | 2107043.90776 | 37.7658124332187 | -122.426639815582 | (37.7658124332187, -122.426639815582) | 8 | 4 | 5 | 28862 | 3 | |
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 | ||
160902 | 85607 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1397 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015969.720597 | 2094414.600713 | 37.7317603044799 | -122.387114277117 | (37.7317603044799, -122.387114277117) | 10 | 3 | 8 | 58 | 1 | ||
163472 | 109142 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 342 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773572 | 5986886.5 | 2113633.7 | 37.7828773022088 | -122.489071978745 | (37.7828773022088, -122.489071978745) | 11 | 6 | 2 | 55 | 26 |
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 | ||
167714 | 98719 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1500 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2012 12:00:00 AM | Permit Number 768751 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||
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 | ||
168373 | 85597 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 6 | 3x3 | 6017523.881587 | 2093256.051678 | 37.7286650962772 | -122.381660625783 | (37.7286650962772, -122.381660625783) | 10 | 3 | 8 | 58 | 1 | ||
168926 | 85580 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1458 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015655.098903 | 2094699.254039 | 37.7325244779387 | -122.38822185678 | (37.7325244779387, -122.38822185678) | 10 | 3 | 8 | 58 | 1 | ||
171027 | 55516 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 299 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | Permit Number 772528 | 6001150.72264648 | 2104659.12373936 | 37.7590575866262 | -122.439080412698 | (37.7590575866262, -122.439080412698) | 2 | 4 | 5 | 28862 | 3 | |||
171845 | 93265 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1400X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004448.1 | 2100692.1 | 37.7483521384228 | -122.427393913264 | (37.7483521384228, -122.427393913264) | 2 | 4 | 5 | 63 | 22 | ||
173603 | 9306 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 240X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | 10 | 3 | 7 | 309 | 28 | ||
174678 | 86796 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
176520 | 85577 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1370 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016127.199744 | 2094347.098919 | 37.73158367729 | -122.386565129485 | (37.73158367729, -122.386565129485) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
179157 | 193406 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 746 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011525.03424 | 2104899.87784 | 37.7603034831294 | -122.403217858726 | (37.7603034831294, -122.403217858726) | 10 | 3 | 8 | 28856 | 29 | |||
179720 | 87673 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010582.741346 | 2086196.470906 | 37.708895230886 | -122.405159783861 | (37.708895230886, -122.405159783861) | 9 | 7 | 8 | 309 | 39 | ||
179751 | 72994 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 590 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2011 12:00:00 AM | 3x3 | Permit Number 768023 | 6001377.74978743 | 2100887.76679336 | 37.748715263692 | -122.438025102274 | (37.748715263692, -122.438025102274) | 2 | 4 | 5 | 28862 | 22 | ||
180008 | 2389 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2642X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009749.5258463 | 2101948.1671123 | 37.7520994293613 | -122.409150251369 | (37.7520994293613, -122.409150251369) | 2 | 4 | 7 | 28859 | 19 | ||
181273 | 84852 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1266 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | Permit No. 49294 | 6005132 | 2100972 | 37.7491593351889 | -122.425048913935 | (37.7491593351889, -122.425048913935) | 2 | 4 | 5 | 28862 | 22 | |||
181472 | 15056 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1441 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2012 12:00:00 AM | 3 | 4x4 | 6015002 | 2095363 | 37.7343107811298 | -122.390526157796 | (37.7343107811298, -122.390526157796) | 10 | 3 | 8 | 58 | 1 | ||
181972 | 18423 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 952 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2013 12:00:00 AM | 3 | 3x3 | 6010455.30853 | 2103703.28348 | 37.7569581031602 | -122.406833222372 | (37.7569581031602, -122.406833222372) | 10 | 4 | 7 | 28859 | 19 | ||
182836 | 91089 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3417X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736 | 2105525 | 37.7617513016467 | -122.419825278263 | (37.7617513016467, -122.419825278263) | 2 | 4 | 7 | 28859 | 19 | |
183063 | 18480 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1298 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2017 01:20:00 PM | 3 | 3x3 | 6010561.39126 | 2101710.28558 | 37.7514917080909 | -122.406325925618 | (37.7514917080909, -122.406325925618) | 10 | 4 | 7 | 28859 | 19 | ||
183177 | 93278 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1559 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004592 | 2099818 | 37.7459601990913 | -122.426834068489 | (37.7459601990913, -122.426834068489) | 2 | 7 | 5 | 63 | 22 |
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) );