trees
6,344 rows where qSpecies_id = 19 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5470 | 137605 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1241 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002263.8485 | 2112857.1338 | 37.7816305713373 | -122.435817261163 | (37.7816305713373, -122.435817261163) | 15 | 5 | 11 | 29490 | 41 | |||
| 5556 | 208569 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1226 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990812.99154 | 2107022.03649 | 37.7649518737544 | -122.475005306654 | (37.7649518737544, -122.475005306654) | 11 | 8 | 11 | 56 | 12 | |||
| 5791 | 171860 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 909 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009090.60075 | 2091384.92035 | 37.7230581082272 | -122.410683014136 | (37.7230581082272, -122.410683014136) | 9 | 3 | 7 | 309 | 28 | |||
| 5807 | 2413 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2773 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2013 12:00:00 AM | 3 | 5x5 | 6009870 | 2101176 | 37.7499859781013 | -122.408679163531 | (37.7499859781013, -122.408679163531) | 2 | 4 | 7 | 28859 | 19 | ||
| 5932 | 70322 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997855.1178 | 2109822.7379 | 37.7730474875653 | -122.45085044117 | (37.7730474875653, -122.45085044117) | 15 | 5 | 11 | 29492 | 16 | |||
| 5958 | 102480 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.91154 | 37.8020306879258 | -122.427302455863 | (37.8020306879258, -122.427302455863) | 13 | 9 | 1 | 57 | 17 | |
| 6063 | 69315 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1518 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 7 | Permit Number 33394 | 5986230.6468 | 2104875.9024 | 37.7587925526495 | -122.490696346344 | (37.7587925526495, -122.490696346344) | 1 | 8 | 3 | 56 | 35 | |
| 6083 | 60590 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 14 | 4x4 | Permit Number 20209 | 6000481 | 2111039 | 37.7765370051793 | -122.441854521628 | (37.7765370051793, -122.441854521628) | 15 | 5 | 11 | 29492 | 16 |
| 6116 | 38816 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 211 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | 4 | Permit Number 40652 | 5994893.15717 | 2114075.07126 | 37.7845532569028 | -122.461404489499 | (37.7845532569028, -122.461404489499) | 11 | 6 | 2 | 54 | 11 | |
| 6152 | 68969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3343 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 9 | Permit Number 32959 | 5999787.27845 | 2120075.09917 | 37.8013082157737 | -122.44490400674 | (37.8013082157737, -122.44490400674) | 13 | 9 | 1 | 57 | 17 | |
| 6196 | 33080 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
| 6248 | 21612 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005218.1717 | 2114795.8159 | 37.7871210866889 | -122.4257347292 | (37.7871210866889, -122.4257347292) | 13 | 9 | 11 | 28858 | 27 | |||
| 6342 | 264855 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
| 6389 | 138549 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2130 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002048.753 | 2114005.8939 | 37.7847725542056 | -122.436643640876 | (37.7847725542056, -122.436643640876) | 13 | 6 | 11 | 29490 | 13 | |||
| 6574 | 65759 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3016 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 13 | Permit Number 28722 | 6003857.62455 | 2119183.89761 | 37.7990926630433 | -122.430755182511 | (37.7990926630433, -122.430755182511) | 13 | 9 | 1 | 57 | 17 | |
| 6642 | 114245 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 54 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5996571 | 2114184 | 37.7849487713586 | -122.455607632252 | (37.7849487713586, -122.455607632252) | 11 | 6 | 1 | 54 | 31 | |||
| 6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
| 6736 | 53162 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1123@ HAWES Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 1 | Permit Number 49083 | 6014891.3438 | 2089966.2272 | 37.71948618255 | -122.390531758785 | (37.71948618255, -122.390531758785) | 10 | 3 | 8 | 58 | 1 | |
| 6949 | 230168 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 279 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6003584.36382 | 2106666.87413 | 37.764708561268 | -122.430807012236 | (37.764708561268, -122.430807012236) | 8 | 4 | 5 | 28862 | 3 | |||
| 6970 | 230089 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 160 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007184.87556 | 2098217.41585 | 37.741711615892 | -122.417754802436 | (37.741711615892, -122.417754802436) | 2 | 7 | 7 | 28859 | 2 | |||
| 7062 | 60350 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19928 | 6017464.7861 | 2093286.0419 | 37.7287441803863 | -122.381867009636 | (37.7287441803863, -122.381867009636) | 10 | 3 | 8 | 58 | 1 | |
| 7077 | 208685 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Margaret Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997050.0175 | 2089737.60379 | 37.7178525273547 | -122.452185875792 | (37.7178525273547, -122.452185875792) | 9 | 8 | 6 | 28861 | 24 | |||
| 7133 | 229642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 97 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007320.40243 | 2098793.80149 | 37.7433018681988 | -122.417327030917 | (37.7433018681988, -122.417327030917) | 2 | 7 | 7 | 28859 | 2 | |||
| 7201 | 5637 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1266 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6005132.21095 | 2100956.30175 | 37.7491162433305 | -122.425047067669 | (37.7491162433305, -122.425047067669) | 2 | 4 | 5 | 28862 | 22 | |||
| 7224 | 230106 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 47 Montezuma St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007653.59945 | 2099775.01516 | 37.7460148026546 | -122.416244399181 | (37.7460148026546, -122.416244399181) | 2 | 7 | 7 | 28859 | 2 | |||
| 7297 | 130697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2311 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999746.50713 | 2116862.80854 | 37.7924857927226 | -122.444814057435 | (37.7924857927226, -122.444814057435) | 13 | 6 | 1 | 29490 | 27 | |||
| 7409 | 79285 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994906.63121 | 2110258.22071 | 37.7740739800962 | -122.46108112387 | (37.7740739800962, -122.46108112387) | 11 | 6 | 2 | 54 | 11 | |||
| 7439 | 193102 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1298 Fairfax Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6017232.41157 | 2097031.5064 | 37.7390156480633 | -122.382930908836 | (37.7390156480633, -122.382930908836) | 10 | 3 | 8 | 58 | 1 | |||
| 7452 | 60592 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 613 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 10 | Permit Number 20211 | 6000545.2975 | 2111100.6046 | 37.7767098193279 | -122.44163652073 | (37.7767098193279, -122.44163652073) | 15 | 5 | 11 | 29492 | 16 | |
| 7550 | 71272 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2477 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6000730.11 | 2114120.4408 | 37.785012045879 | -122.441213921365 | (37.785012045879, -122.441213921365) | 15 | 6 | 11 | 29490 | 13 | |||
| 7592 | 229319 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3423 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006759.7758 | 2104940.35562 | 37.7601473437483 | -122.419701563095 | (37.7601473437483, -122.419701563095) | 2 | 4 | 7 | 28859 | 19 | |||
| 7596 | 137880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2148 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003654.0545 | 2115274.6949 | 37.7883474575543 | -122.431180423335 | (37.7883474575543, -122.431180423335) | 13 | 9 | 1 | 29490 | 27 | |||
| 7602 | 5107 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2680 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6002305.28224 | 2096351.99681 | 37.736313802225 | -122.434493443022 | (37.736313802225, -122.434493443022) | 2 | 7 | 5 | 63 | 7 | ||
| 7764 | 251735 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 338 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 02:05:00 PM | 3 | 3x3 | 6002437 | 2086534 | 37.7093632573177 | -122.433336687258 | (37.7093632573177, -122.433336687258) | 9 | 7 | 6 | 28861 | 5 | ||
| 7798 | 52068 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2005 12:00:00 AM | Permit Number 48263 | 6002387.64911421 | 2104013.98805982 | 37.7573565030376 | -122.434756406645 | (37.7573565030376, -122.434756406645) | 2 | 4 | 5 | 28862 | 3 | |||
| 7815 | 78721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 115 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008722.75942 | 2087395.11673 | 37.7120823080297 | -122.411672802567 | (37.7120823080297, -122.411672802567) | 9 | 7 | 8 | 309 | 39 | |||
| 7937 | 47337 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779205 | 5992952.66327787 | 2090462.04360939 | 37.7196060953775 | -122.466401119038 | (37.7196060953775, -122.466401119038) | 9 | 8 | 6 | 64 | 24 | |
| 7986 | 180642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 56 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6001992.8038 | 2087466.28016 | 37.7118978840556 | -122.4349385283 | (37.7118978840556, -122.4349385283) | 9 | 7 | 6 | 28861 | 5 | |||
| 8008 | 260640 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3936 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776281 | 6004258 | 2100777 | 37.7485745007292 | -122.428057323873 | (37.7485745007292, -122.428057323873) | 2 | 4 | 5 | 28862 | 22 | |
| 8047 | 229934 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 602 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002630.53663 | 2098906.06974 | 37.7433451534675 | -122.433551376193 | (37.7433451534675, -122.433551376193) | 2 | 7 | 5 | 63 | 22 | |||
| 8073 | 64439 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1988 12:00:00 AM | 15 | Permit Number 25301 | 6009724.66306 | 2110846.10571 | 37.7765297431014 | -122.409864276736 | (37.7765297431014, -122.409864276736) | 8 | 2 | 9 | 28853 | 34 | |
| 8096 | 59801 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1035 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1981 12:00:00 AM | 3 | Permit Number 19252 | 6008957.26664 | 2115956.46154 | 37.7905185185761 | -122.412880324992 | (37.7905185185761, -122.412880324992) | 5 | 1 | 10 | 28858 | 21 | |
| 8191 | 74104 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 189 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6006471.06973 | 2093054.28635 | 37.7274946077702 | -122.419856624186 | (37.7274946077702, -122.419856624186) | 9 | 7 | 7 | 309 | 5 | |||
| 8419 | 85699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010993.40445 | 2112488.15858 | 37.7811094596721 | -122.405590993329 | (37.7811094596721, -122.405590993329) | 14 | 2 | 9 | 28853 | 34 | ||
| 8528 | 5525 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 875 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/09/2015 07:32:00 AM | 3 | 8x8 | 6005129 | 2103286 | 37.7555128725534 | -122.425223924554 | (37.7555128725534, -122.425223924554) | 2 | 4 | 5 | 28859 | 19 | ||
| 8615 | 81216 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1490 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5989947.3486 | 2105228.4272 | 37.7599768999261 | -122.477868186468 | (37.7599768999261, -122.477868186468) | 1 | 8 | 3 | 56 | 35 | |||
| 8620 | 230618 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 293 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003249.58488 | 2101526.98547 | 37.7505766802717 | -122.431597943511 | (37.7505766802717, -122.431597943511) | 2 | 4 | 5 | 28862 | 22 | |||
| 8647 | 146616 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | Permit Number 783073 | 6005474.41066 | 2120313.40732 | 37.8022854748664 | -122.425240967805 | (37.8022854748664, -122.425240967805) | 13 | 9 | 1 | 57 | 17 | ||
| 8769 | 32194 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1995 12:00:00 AM | 2 | Permit Number 35521 | 6000876.834 | 2109176.6725 | 37.7714460698883 | -122.440351630177 | (37.7714460698883, -122.440351630177) | 15 | 5 | 11 | 29492 | 9 | |
| 8813 | 229976 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1983 12:00:00 AM | 13 | Width 2ft | Permit Number 20257 | 6003460.20133 | 2096023.86311 | 37.7354783140686 | -122.430477003328 | (37.7354783140686, -122.430477003328) | 2 | 7 | 5 | 63 | 7 | |
| 8865 | 248498 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998302.5369 | 2107853.4873 | 37.7676660307619 | -122.449160873661 | (37.7676660307619, -122.449160873661) | 15 | 5 | 11 | 29492 | 9 | |||
| 8884 | 4658 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:50:00 PM | 3 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | 3 | 1 | 10 | 308 | 23 | ||
| 8967 | 18314 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 180 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782360 | 6010236.79256 | 2107510.48621 | 37.7673995909374 | -122.407857396411 | (37.7673995909374, -122.407857396411) | 8 | 4 | 8 | 28853 | 19 | |
| 8977 | 61589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 912 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 11 | Permit Number 21556 | 6012739.7847 | 2103229.26142 | 37.7557841029764 | -122.398899324171 | (37.7557841029764, -122.398899324171) | 10 | 3 | 8 | 28856 | 29 | |
| 9118 | 120468 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988384.0014 | 2115083.94801 | 37.7869465618324 | -122.483997692017 | (37.7869465618324, -122.483997692017) | 11 | 6 | 1 | 55 | 33 | |||
| 9133 | 229721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3345 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 768018 | 6007953.43646 | 2104421.40603 | 37.7587895958797 | -122.415536504129 | (37.7587895958797, -122.415536504129) | 2 | 4 | 7 | 28859 | 19 | ||
| 9142 | 28298 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 637 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2003 12:00:00 AM | 3 | 3X3 | 6010087.47543 | 2115987.95406 | 37.7906683645059 | -122.408972077304 | (37.7906683645059, -122.408972077304) | 5 | 1 | 10 | 28857 | 21 | ||
| 9233 | 17847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2082 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003983.5737 | 2115317.762 | 37.7884843766402 | -122.430043414021 | (37.7884843766402, -122.430043414021) | 13 | 9 | 11 | 29490 | 27 | |||
| 9273 | 28375 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3014 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | 3 | 3x3 | Permit Number 54020 | 6000248.59092 | 2115494.6796 | 37.7887579085949 | -122.442978542939 | (37.7887579085949, -122.442978542939) | 13 | 6 | 1 | 29490 | 27 | |
| 9373 | 71806 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2567 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988291.4423 | 2097857.1501 | 37.7396410933419 | -122.483054814949 | (37.7396410933419, -122.483054814949) | 1 | 8 | 3 | 29491 | 35 | |||
| 9422 | 80211 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 340 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008650.63461 | 2108952.54787 | 37.7712702289655 | -122.413445714359 | (37.7712702289655, -122.413445714359) | 8 | 2 | 9 | 28853 | 19 | |||
| 9503 | 109132 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 124 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6008117 | 2098031 | 37.7412521699945 | -122.414518628477 | (37.7412521699945, -122.414518628477) | 2 | 7 | 7 | 28859 | 2 | ||||
| 9593 | 70541 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1830 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6000327.1082 | 2111334.4422 | 37.777339444143 | -122.442408091617 | (37.777339444143, -122.442408091617) | 15 | 5 | 11 | 29490 | 16 | |||
| 9683 | 13057 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2014 12:00:00 AM | 3 | 2x2 | 6009630.8999 | 2120542.6321 | 37.8031488074681 | -122.410873631329 | (37.8031488074681, -122.410873631329) | 3 | 1 | 10 | 308 | 23 | ||
| 9744 | 19850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10ST | |||||||||||||
| 9796 | 72145 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001088.11474 | 2092709.73665 | 37.72624382708 | -122.438440814794 | (37.72624382708, -122.438440814794) | 9 | 7 | 6 | 28861 | 25 | |||
| 9869 | 5383 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 325X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/06/2009 12:00:00 AM | 3 | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | ||
| 9918 | 74256 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1126X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6009656.55619 | 2111209.09392 | 37.7775226063216 | -122.410125511783 | (37.7775226063216, -122.410125511783) | 8 | 2 | 9 | 28853 | 34 | |||
| 10003 | 264730 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 748 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | 6002983.4557 | 2109619.25261 | 37.7727810060219 | -122.433096352422 | (37.7727810060219, -122.433096352422) | 15 | 5 | 11 | 29492 | 9 | |||
| 10007 | 264696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 782245 | 5999562.003 | 2108407.0589 | 37.7692579547157 | -122.444844350278 | (37.7692579547157, -122.444844350278) | 15 | 5 | 11 | 29492 | 9 | |
| 10046 | 48825 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 550 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | 6 | Permit Number 46050 | 5988463.29715 | 2112242.22119 | 37.7791485995736 | -122.483514940107 | (37.7791485995736, -122.483514940107) | 11 | 6 | 2 | 55 | 26 | ||
| 10060 | 262273 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2470 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 6002133 | 2097220 | 37.738687356955 | -122.435151157914 | (37.738687356955, -122.435151157914) | 2 | 7 | 5 | 63 | 7 | ||||
| 10136 | 41571 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 331 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2000 12:00:00 AM | 6 | 4x4 | Permit Number 42086 | 5989933.46596 | 2113143.03075 | 37.7817074314288 | -122.478494971039 | (37.7817074314288, -122.478494971039) | 11 | 6 | 2 | 55 | 26 |
| 10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
| 10210 | 46620 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1566 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 4 | 3x3 | Permit Number 44746 | 6015560.90449 | 2096875.62072 | 37.7384951204397 | -122.388699385265 | (37.7384951204397, -122.388699385265) | 10 | 3 | 8 | 58 | 1 |
| 10226 | 237496 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3927 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2017 12:00:00 AM | 8 | Width 3ft | 6003620.49393 | 2101843.48933 | 37.7514667420033 | -122.430337889878 | (37.7514667420033, -122.430337889878) | 2 | 4 | 5 | 28862 | 22 | ||
| 10244 | 82748 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1434-1436 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008231.53118 | 2109847.29583 | 37.7737034553791 | -122.414958754439 | (37.7737034553791, -122.414958754439) | 8 | 2 | 9 | 28853 | 34 | |||
| 10273 | 73717 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1512 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6x6 | 6013119.6515 | 2105226.52414 | 37.7612893091654 | -122.397725698092 | (37.7612893091654, -122.397725698092) | 10 | 3 | 8 | 28856 | 29 | ||
| 10462 | 85563 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1186 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017119.22187 | 2093617.04426 | 37.7296339591237 | -122.383084687511 | (37.7296339591237, -122.383084687511) | 10 | 3 | 8 | 58 | 1 | ||
| 10500 | 99636 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2201@Vallejo Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006351.46016 | 2118390.69708 | 37.7970557085202 | -122.422069273873 | (37.7970557085202, -122.422069273873) | 13 | 9 | 10 | 28858 | 32 | |||
| 10710 | 10015 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 232 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2019 12:00:00 AM | 3 | 3x3 | 6005430.70254 | 2107623.59079 | 37.7674399129618 | -122.424489062615 | (37.7674399129618, -122.424489062615) | 8 | 4 | 5 | 28853 | 19 | ||
| 10717 | 73755 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 592 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 4x4 | 6010721.4091 | 2118959.281 | 37.7988624001506 | -122.406988209463 | (37.7988624001506, -122.406988209463) | 3 | 1 | 10 | 308 | 23 | ||
| 10845 | 30838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1995 12:00:00 AM | 8 | Permit Number 34709 | 6007559.44902 | 2097564.28674 | 37.739939339931 | -122.416413397076 | (37.739939339931, -122.416413397076) | 2 | 7 | 7 | 28859 | 2 | ||
| 10952 | 230635 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3936 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003520.29568 | 2102463.05796 | 37.7531622554484 | -122.430728595871 | (37.7531622554484, -122.430728595871) | 2 | 4 | 5 | 28862 | 22 | |||
| 10970 | 60364 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1397 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19942 | 6015971.722 | 2094398.676 | 37.7317166892309 | -122.387106247473 | (37.7317166892309, -122.387106247473) | 10 | 3 | 8 | 58 | 1 | |
| 11013 | 60619 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 209 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20243 | 6004834.14454804 | 2097168.79499693 | 37.7386997741774 | -122.425808230058 | (37.7386997741774, -122.425808230058) | 2 | 7 | 5 | 63 | 7 | ||
| 11033 | 70684 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6010365.45358 | 2111155.37964 | 37.7774148279639 | -122.407669399445 | (37.7774148279639, -122.407669399445) | 14 | 2 | 9 | 28853 | 34 | |||
| 11043 | 73644 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007593.08329 | 2115418.15258 | 37.7889637868037 | -122.417562159565 | (37.7889637868037, -122.417562159565) | 13 | 1 | 10 | 28858 | 21 | |||
| 11241 | 30330 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2820 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1990 12:00:00 AM | 9 | Permit Number 28881 | 5999458.41568 | 2118085.66723 | 37.795826993587 | -122.445898848463 | (37.795826993587, -122.445898848463) | 13 | 9 | 1 | 57 | 17 | ||
| 11316 | 120672 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3819 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004118 | 2105356 | 37.7611394347307 | -122.42886784279 | (37.7611394347307, -122.42886784279) | 2 | 4 | 5 | 28862 | 3 | ||||
| 11422 | 229497 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004419.76792 | 2103195.09232 | 37.7552231688176 | -122.427670192252 | (37.7552231688176, -122.427670192252) | 2 | 4 | 5 | 28862 | 22 | |||
| 11447 | 49551 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1084REVISED Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2020 01:56:00 PM | 3 | Permit Number 46441 | 6009968.28689 | 2111507.46699 | 37.7783593364429 | -122.409068185146 | (37.7783593364429, -122.409068185146) | 14 | 2 | 9 | 28853 | 34 | ||
| 11507 | 71409 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1510 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015375.9848 | 2094913.1689 | 37.7330963758454 | -122.389201760959 | (37.7330963758454, -122.389201760959) | 10 | 3 | 8 | 58 | 1 | |||
| 11746 | 57593 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1976 12:00:00 AM | 3 | Permit Number 16461 | 6003141.6397 | 2110360.8759 | 37.7748262921144 | -122.432602160624 | (37.7748262921144, -122.432602160624) | 15 | 9 | 11 | 29492 | 10 | |
| 11758 | 41190 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2518 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2020 12:00:00 AM | 3 | Permit Number 782407 | 6003669.72123 | 2117044.16503 | 37.7932068601533 | -122.431252574158 | (37.7932068601533, -122.431252574158) | 13 | 9 | 1 | 29490 | 27 | ||
| 11765 | 65228 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 736 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 10 | Permit Number 28015 | 6003178.33467 | 2089873.36869 | 37.7185744644174 | -122.431012691703 | (37.7185744644174, -122.431012691703) | 9 | 7 | 6 | 28861 | 5 | |
| 11909 | 29249 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010557.0875047 | 2086190.1499449 | 37.7088764405738 | -122.405248002787 | (37.7088764405738, -122.405248002787) | 9 | 7 | 8 | 309 | 39 | ||
| 11917 | 77997 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009714.16253 | 2086968.85209 | 37.7109674364637 | -122.408216166539 | (37.7109674364637, -122.408216166539) | 9 | 7 | 8 | 309 | 39 | |||
| 11940 | 230621 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 225 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003663.82541 | 2101551.33139 | 37.7506669991978 | -122.430167203953 | (37.7506669991978, -122.430167203953) | 2 | 4 | 5 | 28862 | 22 | |||
| 12072 | 10326 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 819 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2007 12:00:00 AM | 3 | 3X3 | 6002207.57646 | 2109118.35989 | 37.7713616369503 | -122.43574435864 | (37.7713616369503, -122.43574435864) | 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) );