trees
246 rows where qSpecies_id = 20 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 146900 | 177291 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 400 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003906.05607 | 2090945.99002 | 37.7215608557421 | -122.428573672752 | (37.7215608557421, -122.428573672752) | 9 | 7 | 6 | 28861 | 5 | |||
| 149031 | 177298 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988403.4281 | 2091243.72009 | 37.721488831717 | -122.482183231171 | (37.721488831717, -122.482183231171) | 1 | 8 | 4 | 64 | 14 | ||||
| 150998 | 229239 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009149.94921 | 2098041.78953 | 37.7413397723193 | -122.410947804196 | (37.7413397723193, -122.410947804196) | 10 | 7 | 7 | 28859 | 2 | |||
| 159254 | 38335 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 444 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | Permit Number 47950 | 5983475.92441 | 2112817.71297 | 37.7804371865901 | -122.500810595919 | (37.7804371865901, -122.500810595919) | 11 | 6 | 2 | 55 | 26 | ||
| 160329 | 117201 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 298 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6013997.02726 | 2105851.29667 | 37.7630536171528 | -122.394734957662 | (37.7630536171528, -122.394734957662) | 14 | 3 | 8 | 28856 | 29 | |||
| 160538 | 17695 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1100X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2004 12:00:00 AM | 3 | 3X3 | 6002388.932052 | 2112303.174651 | 37.7801166436013 | -122.435344894499 | (37.7801166436013, -122.435344894499) | 15 | 5 | 11 | 29490 | 41 | ||
| 161934 | 114095 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 424 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2015 12:00:00 AM | 3 | 3x3 | 5998448.01058 | 2087544.4934 | 37.7119107326703 | -122.44719590289 | (37.7119107326703, -122.44719590289) | 9 | 7 | 6 | 28861 | 25 | ||
| 171270 | 208540 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1205 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995843.60881 | 2092100.29717 | 37.7242707405805 | -122.456526632611 | (37.7242707405805, -122.456526632611) | 9 | 7 | 4 | 28861 | 40 | |||
| 174917 | 229234 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 909 Elizabeth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6000533.75366 | 2101957.19594 | 37.751603625115 | -122.441020338428 | (37.751603625115, -122.441020338428) | 2 | 4 | 5 | 28862 | 22 | |||
| 177265 | 21847 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 202X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 3 | 3X3 | 5994968.90714 | 2110807.33222 | 37.7755852784786 | -122.460905507707 | (37.7755852784786, -122.460905507707) | 11 | 6 | 2 | 54 | 11 | ||
| 180489 | 208541 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1201 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995841.38448 | 2092081.24928 | 37.7242183119117 | -122.456532944957 | (37.7242183119117, -122.456532944957) | 9 | 7 | 4 | 28861 | 40 | |||
| 186826 | 254204 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1766 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781022 | 5982566.32735 | 2103096.10961 | 37.7536910129268 | -122.503237266994 | (37.7536910129268, -122.503237266994) | 1 | 8 | 3 | 56 | 35 | |
| 125928 | 10081 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 630 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6005564.83767 | 2105271.62168 | 37.7609895372482 | -122.42385784647 | (37.7609895372482, -122.42385784647) | 2 | 4 | 5 | 28859 | 19 | |||
| 53686 | 26853 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 624 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1998 12:00:00 AM | 24 | 3X3 | 6005561.83223 | 2105304.71691 | 37.7610802392886 | -122.423870594369 | (37.7610802392886, -122.423870594369) | 2 | 4 | 5 | 28859 | 19 | ||
| 19323 | 81173 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001918.1505 | 2090237.98214 | 37.7195041241905 | -122.435394694117 | (37.7195041241905, -122.435394694117) | 9 | 7 | 6 | 28861 | 5 | |||
| 19604 | 78246 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1447 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5999064.52078 | 2089547.19331 | 37.7174448988403 | -122.445208973141 | (37.7174448988403, -122.445208973141) | 9 | 7 | 6 | 28861 | 25 | |||
| 25342 | 7018 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1055 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 2 | 3X3 | 6002378.8301 | 2110180.8206 | 37.7742886166676 | -122.435227992558 | (37.7742886166676, -122.435227992558) | 15 | 5 | 11 | 29492 | 10 | ||
| 36895 | 229248 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 436 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003539.13196 | 2102171.5132 | 37.7523628094001 | -122.430642653946 | (37.7523628094001, -122.430642653946) | 2 | 4 | 5 | 28862 | 22 | |||
| 37036 | 177300 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001639.62994 | 2087602.93432 | 37.7122530470215 | -122.436168967218 | (37.7122530470215, -122.436168967218) | 9 | 7 | 6 | 28861 | 5 | |||
| 73392 | 177301 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001599.00625 | 2087595.59489 | 37.7122305864419 | -122.436308849585 | (37.7122305864419, -122.436308849585) | 9 | 7 | 6 | 28861 | 5 | |||
| 76828 | 177295 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001002.00553 | 2087880.82642 | 37.7129798296258 | -122.438392678593 | (37.7129798296258, -122.438392678593) | 9 | 7 | 6 | 28861 | 5 | |||
| 92543 | 183390 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2673 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989554.4883 | 2097163.7436 | 37.7378105948151 | -122.478637096313 | (37.7378105948151, -122.478637096313) | 1 | 8 | 3 | 29491 | 35 | |||
| 103730 | 30933 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 515 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 2 | Permit Number 34746 | 5995238.05278 | 2091207.05999 | 37.7217833398997 | -122.458555307998 | (37.7217833398997, -122.458555307998) | 9 | 8 | 6 | 28861 | 24 | |
| 107681 | 111163 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003374.28365 | 2119810.99129 | 37.8007871036097 | -122.432472518919 | (37.8007871036097, -122.432472518919) | 13 | 9 | 1 | 57 | 17 | |||
| 115190 | 97119 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
| 125651 | 229245 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1604 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005879.33617 | 2099593.72705 | 37.7454170997346 | -122.422366695864 | (37.7454170997346, -122.422366695864) | 2 | 7 | 5 | 28859 | 22 | |||
| 126173 | 111165 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003411.20248 | 2119815.94235 | 37.8008027913768 | -122.432345118256 | (37.8008027913768, -122.432345118256) | 13 | 9 | 1 | 57 | 17 | |||
| 135372 | 229238 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 35 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007492.54577 | 2099921.15591 | 37.7464070149728 | -122.416811654632 | (37.7464070149728, -122.416811654632) | 2 | 7 | 7 | 28859 | 2 | |||
| 142205 | 200499 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1082 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6013591.41 | 2089958.2062 | 37.7193919575312 | -122.395024624648 | (37.7193919575312, -122.395024624648) | 10 | 3 | 8 | 58 | 1 | |||
| 159248 | 177299 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001664.56674 | 2087607.40628 | 37.7122667427937 | -122.43608309818 | (37.7122667427937, -122.43608309818) | 9 | 7 | 6 | 28861 | 5 | |||
| 164546 | 208548 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 150 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5995469.48283 | 2089658.18964 | 37.7175438071807 | -122.457643306389 | (37.7175438071807, -122.457643306389) | 9 | 8 | 6 | 28861 | 24 | |||
| 178625 | 192813 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1251 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013542.5057 | 2106139.39713 | 37.7638193961669 | -122.396327198343 | (37.7638193961669, -122.396327198343) | 14 | 3 | 8 | 28856 | 29 | |||
| 185492 | 44220 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2139 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2001 12:00:00 AM | 2 | Permit Number 43665 | 5987262.4786 | 2100698.6187 | 37.74738308124 | -122.486821088856 | (37.74738308124, -122.486821088856) | 1 | 8 | 3 | 29491 | 35 | ||
| 48773 | 229219 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1342 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 15 | Width 2ft | Permit Number 42176 | 6006959.38912 | 2107664.54838 | 37.7676385821924 | -122.419204437651 | (37.7676385821924, -122.419204437651) | 8 | 4 | 7 | 28853 | 19 | |
| 58877 | 208545 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 12 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5996523.6042 | 2089967.17912 | 37.7184527177873 | -122.454022014425 | (37.7184527177873, -122.454022014425) | 9 | 8 | 6 | 28861 | 24 | |||
| 31077 | 177293 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 570 Edinburgh St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002594.98621 | 2090406.02371 | 37.7200039448969 | -122.433067122761 | (37.7200039448969, -122.433067122761) | 9 | 7 | 6 | 28861 | 5 | |||
| 184176 | 208546 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 12 Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5996523.78627 | 2089975.89779 | 37.7184766676518 | -122.454022014422 | (37.7184766676518, -122.454022014422) | 9 | 8 | 6 | 28861 | 24 | |||
| 645 | 38285 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 27 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1998 12:00:00 AM | 12 | 3x12 | Permit Number 40369 | 6007338.83954453 | 2106937.08827094 | 37.7656625095236 | -122.417840391728 | (37.7656625095236, -122.417840391728) | 8 | 4 | 7 | 28853 | 19 |
| 23151 | 229229 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 25 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007282.8727 | 2106946.56107 | 37.7656853698119 | -122.41803464088 | (37.7656853698119, -122.41803464088) | 8 | 4 | 7 | 28853 | 19 | |||
| 28410 | 177294 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 570 Edinburgh St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002574.43441 | 2090375.15322 | 37.7199180155891 | -122.433135958685 | (37.7199180155891, -122.433135958685) | 9 | 7 | 6 | 28861 | 5 | |||
| 31440 | 229253 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 245 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000709.62827 | 2106546.14051 | 37.7642137623885 | -122.440741279694 | (37.7642137623885, -122.440741279694) | 15 | 5 | 5 | 28862 | 3 | |||
| 136599 | 208554 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 447 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5993467.66599 | 2088853.99323 | 37.7152204788151 | -122.464504257677 | (37.7152204788151, -122.464504257677) | 9 | 8 | 6 | 64 | 24 | |||
| 137574 | 16869 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 251 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52092 | 6005763.06398 | 2110312.25693 | 37.774841108223 | -122.423530640295 | (37.774841108223, -122.423530640295) | 7 | 9 | 11 | 28852 | 10 | |
| 159123 | 1680 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 400 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 12 | 3X3 | 5994348.50119 | 2111464.79497 | 37.7773547778944 | -122.463099340943 | (37.7773547778944, -122.463099340943) | 11 | 6 | 2 | 54 | 11 | ||
| 187508 | 229254 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 157 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001282.99504 | 2106223.75237 | 37.7633611996826 | -122.438735069383 | (37.7633611996826, -122.438735069383) | 15 | 5 | 5 | 28862 | 3 | |||
| 152788 | 229249 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 310 Liberty St | 52 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003824.40718 | 2103923.16543 | 37.7571885904097 | -122.429781053062 | (37.7571885904097, -122.429781053062) | 2 | 4 | 5 | 28862 | 3 | |||
| 22549 | 229216 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 33 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005800.05935 | 2107051.19883 | 37.7658891121107 | -122.423170814787 | (37.7658891121107, -122.423170814787) | 8 | 4 | 5 | 28853 | 19 | |||
| 30847 | 229218 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 154 Julian Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006411.90444 | 2106966.83782 | 37.7656919861306 | -122.42104857575 | (37.7656919861306, -122.42104857575) | 8 | 4 | 7 | 28853 | 19 | |||
| 5938 | 229255 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 260 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003887.38012 | 2097809.34417 | 37.7404050277631 | -122.429127352938 | (37.7404050277631, -122.429127352938) | 2 | 7 | 5 | 63 | 7 | |||
| 30930 | 192814 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1251 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013571.38168 | 2106139.70119 | 37.7638218378314 | -122.396227345714 | (37.7638218378314, -122.396227345714) | 14 | 3 | 8 | 28856 | 29 | |||
| 38714 | 229260 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1325 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009552.03774 | 2101426.1917 | 37.7506551353331 | -122.409796356326 | (37.7506551353331, -122.409796356326) | 2 | 4 | 7 | 28859 | 19 | |||
| 42561 | 130436 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2201 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007584.36539 | 2119972.20513 | 37.8014675927187 | -122.417915277469 | (37.8014675927187, -122.417915277469) | 5 | 1 | 1 | 28858 | 32 | |||
| 45226 | 229225 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 4015 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003754.02498 | 2100677.61604 | 37.7482730893484 | -122.42979297446 | (37.7482730893484, -122.42979297446) | 2 | 4 | 5 | 63 | 22 | |||
| 53505 | 229257 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 210 Moffitt St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002381.14665 | 2097165.58245 | 37.7385520268501 | -122.434289296035 | (37.7385520268501, -122.434289296035) | 2 | 7 | 5 | 63 | 7 | |||
| 60221 | 50521 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47159 | 5996798.3759 | 2112040.3174 | 37.7790758310411 | -122.454666063431 | (37.7790758310411, -122.454666063431) | 15 | 6 | 2 | 54 | 16 | |
| 62848 | 177296 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 Newton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000995.34675 | 2087902.8646 | 37.7130399628101 | -122.438417271438 | (37.7130399628101, -122.438417271438) | 9 | 7 | 6 | 28861 | 5 | |||
| 77081 | 44219 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2139 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 43665 | 5987260.984 | 2100720.2895 | 37.7474424963194 | -122.486827848138 | (37.7474424963194, -122.486827848138) | 1 | 8 | 3 | 29491 | 35 | |||
| 77741 | 229223 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 587 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1988 12:00:00 AM | 1 | Width 2ft | Permit Number 25015 | 6002801.67142 | 2098869.60801 | 37.7432547464139 | -122.432957032239 | (37.7432547464139, -122.432957032239) | 2 | 7 | 5 | 63 | 22 | |
| 79567 | 137580 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1150 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002381.2868 | 2112341.0686 | 37.7802202566686 | -122.435374054285 | (37.7802202566686, -122.435374054285) | 15 | 5 | 11 | 29490 | 41 | |||
| 80365 | 229259 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 269 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003857.56826 | 2097789.37323 | 37.7403485044927 | -122.429229006915 | (37.7403485044927, -122.429229006915) | 2 | 7 | 5 | 63 | 7 | |||
| 81612 | 117729 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 444 40th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5983475.64973 | 2112834.36493 | 37.7804828918797 | -122.500812777933 | (37.7804828918797, -122.500812777933) | 11 | 6 | 2 | 55 | 26 | |||
| 123138 | 229256 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 260 Randall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003866.23298 | 2097822.81814 | 37.7404408270718 | -122.429201431925 | (37.7404408270718, -122.429201431925) | 2 | 7 | 5 | 63 | 7 | |||
| 138978 | 229236 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 34 Natick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003050.62642 | 2095609.57771 | 37.7343175708005 | -122.431863485408 | (37.7343175708005, -122.431863485408) | 2 | 7 | 5 | 63 | 7 | |||
| 141863 | 130437 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2201 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007591.42221 | 2119948.52727 | 37.8014029764228 | -122.417889178244 | (37.8014029764228, -122.417889178244) | 5 | 1 | 1 | 28858 | 32 | |||
| 157092 | 97121 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
| 164273 | 208552 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Vernon St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5992432.90306 | 2088632.12991 | 37.7145515909498 | -122.468064688039 | (37.7145515909498, -122.468064688039) | 9 | 8 | 6 | 64 | 24 | |||
| 165989 | 229228 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 588 Ogden Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6007775.88717 | 2096147.34568 | 37.7360609002791 | -122.415564747312 | (37.7360609002791, -122.415564747312) | 2 | 7 | 7 | 28859 | 2 | |||
| 171110 | 177290 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 231 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004061.30791 | 2089085.46996 | 37.7164610594049 | -122.427904501587 | (37.7164610594049, -122.427904501587) | 9 | 7 | 6 | 28861 | 5 | |||
| 176947 | 130433 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 550 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004538.94577 | 2111043.55474 | 37.776779903004 | -122.427817240371 | (37.776779903004, -122.427817240371) | 7 | 9 | 11 | 28852 | 10 | |||
| 184259 | 97120 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
| 80382 | 37200 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1523 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 0 | Permit Number 39767 | 5986185.22517174 | 2104866.53832379 | 37.7587641880882 | -122.490852744095 | (37.7587641880882, -122.490852744095) | 1 | 8 | 3 | 56 | 35 | |
| 3119 | 264752 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
| 4560 | 47095 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 356 Willard North St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45077 | 5996301.73927169 | 2110554.62831554 | 37.7749680212207 | -122.456276668944 | (37.7749680212207, -122.456276668944) | 11 | 6 | 2 | 54 | 16 | ||
| 7535 | 264754 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
| 18449 | 264755 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
| 20559 | 38286 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 29 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40899 | 6007332.77993019 | 2106936.7520651 | 37.7656612453629 | -122.417861326827 | (37.7656612453629, -122.417861326827) | 8 | 4 | 7 | 28853 | 19 | |||
| 22680 | 46900 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1357 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44956 | 5991106.29954004 | 2106174.99705817 | 37.7626431240146 | -122.473929035532 | (37.7626431240146, -122.473929035532) | 1 | 8 | 11 | 56 | 12 | ||
| 28278 | 49981 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
| 28736 | 36479 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 541 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39372 | 5996872.5215496 | 2093815.84341283 | 37.7290402419627 | -122.45309363195 | (37.7290402419627, -122.45309363195) | 9 | 7 | 4 | 28861 | 40 | ||
| 30898 | 254205 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1766 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982566.32735 | 2103096.10961 | 37.7536910129268 | -122.503237266994 | (37.7536910129268, -122.503237266994) | 1 | 8 | 3 | 56 | 35 | ||||
| 30911 | 39141 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1088 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40819 | 6007414.12012463 | 2100977.25645313 | 37.7493024177021 | -122.417157664156 | (37.7493024177021, -122.417157664156) | 2 | 4 | 7 | 28859 | 19 | ||
| 33104 | 49982 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
| 38852 | 85278 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 506 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49567 | 6004562 | 2110191 | 37.7744403005412 | -122.427676731417 | (37.7744403005412, -122.427676731417) | 7 | 9 | 11 | 28852 | 10 | |||
| 40861 | 85261 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2998 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989779.1 | 2095328.3 | 37.7327839760928 | -122.477726384657 | (37.7327839760928, -122.477726384657) | 1 | 8 | 4 | 64 | 35 | |||
| 41793 | 253689 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 60 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005848 | 2109690 | 37.7731373345919 | -122.423192587546 | (37.7731373345919, -122.423192587546) | 7 | 9 | 11 | 28852 | 10 | ||||
| 42332 | 38291 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
| 44112 | 40458 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41543 | 6008355.36167983 | 2098222.23165667 | 37.7417906382072 | -122.413707978506 | (37.7417906382072, -122.413707978506) | 2 | 7 | 7 | 28859 | 2 | ||
| 48134 | 88833 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51715 | 6009115.5 | 2098028.9 | 37.7413024486906 | -122.41106600773 | (37.7413024486906, -122.41106600773) | 10 | 7 | 7 | 28859 | 2 | ||
| 48201 | 42814 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3944 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42759 | 6003333.22216153 | 2105381.87042866 | 37.7611660186553 | -122.431583898012 | (37.7611660186553, -122.431583898012) | 15 | 4 | 5 | 28862 | 3 | ||
| 48235 | 38441 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2591 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1998 12:00:00 AM | Permit Number 40466 | 5992043.6333811 | 2097820.82323466 | 37.7397589768558 | -122.470078824326 | (37.7397589768558, -122.470078824326) | 1 | 8 | 4 | 59 | 40 | |||
| 49181 | 36477 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 531 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39371 | 5996915.79992705 | 2093810.02039561 | 37.7290267336025 | -122.452943595903 | (37.7290267336025, -122.452943595903) | 9 | 7 | 4 | 28861 | 40 | ||
| 52550 | 38836 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 254 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
| 53896 | 42075 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 125 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2005 12:00:00 AM | Permit Number 42387 | 6009870.15357172 | 2099865.41345763 | 37.7463874047531 | -122.408586191488 | (37.7463874047531, -122.408586191488) | 2 | 7 | 7 | 28859 | 2 | ||
| 53984 | 45168 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
| 54737 | 84949 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1305 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1983 12:00:00 AM | 3x3 | Permit Number 49351 | 6009354 | 2101579 | 37.7510636126747 | -122.410491979069 | (37.7510636126747, -122.410491979069) | 2 | 4 | 7 | 28859 | 19 | ||
| 54872 | 50865 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 238 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/2004 12:00:00 AM | Permit Number 47380 | 6007739.99301992 | 2097997.57355167 | 37.741139201026 | -122.415819822319 | (37.741139201026, -122.415819822319) | 2 | 7 | 7 | 28859 | 2 | ||
| 55419 | 41289 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 27 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41965 | 6005808.60053678 | 2107097.83336605 | 37.76601764148 | -122.42314458768 | (37.76601764148, -122.42314458768) | 8 | 4 | 5 | 28853 | 19 | ||
| 59467 | 41687 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 124 Saturn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42140 | 5999927.88161805 | 2106008.33179804 | 37.7626925227356 | -122.443406475957 | (37.7626925227356, -122.443406475957) | 15 | 5 | 5 | 28862 | 3 | ||
| 61067 | 41292 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 46 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2000 12:00:00 AM | Permit Number 41968 | 6005763.36283856 | 2106987.3220579 | 37.7657116506856 | -122.423293199372 | (37.7657116506856, -122.423293199372) | 8 | 4 | 5 | 28853 | 19 | |||
| 63595 | 37844 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40136 | 6010376.80138594 | 2099288.55656196 | 37.7448318435542 | -122.406793605579 | (37.7448318435542, -122.406793605579) | 2 | 7 | 7 | 28859 | 2 |
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) );