trees
1,011 rows where qLegalStatus_id = 2
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
132587 | 199504 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | 14 | 2 | 9 | 28853 | 34 | |
132870 | 118376 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
133371 | 255306 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1163 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | 3x6 | Permit Number 777039 | 6008085.276 | 2101160.09095 | 37.7498421745418 | -122.414849724814 | (37.7498421745418, -122.414849724814) | 2 | 4 | 7 | 28859 | 19 | |
133424 | 254076 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 416 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2017 12:00:00 AM | 3 | 3x3 | 6003139 | 2099532 | 37.7450926486102 | -122.431837924964 | (37.7450926486102, -122.431837924964) | 2 | 7 | 5 | 63 | 22 | ||
133882 | 187944 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015109.7038 | 2115276.55289 | 37.7889950679055 | -122.391545539018 | (37.7889950679055, -122.391545539018) | 6 | 2 | 9 | 28855 | 6 | ||||
133945 | 14312 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2190X Market St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782146 | 6003624.7851 | 2107240.8343 | 37.7662868072343 | -122.430708166736 | (37.7662868072343, -122.430708166736) | 7 | 4 | 5 | 28862 | 3 | |
134197 | 201699 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6010014.86815 | 2109861.25987 | 37.7738418457656 | -122.408790872027 | (37.7738418457656, -122.408790872027) | 8 | 2 | 9 | 28853 | 34 | |
134654 | 152810 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009973.24314 | 2101608.01571 | 37.7511779795992 | -122.408352609887 | (37.7511779795992, -122.408352609887) | 2 | 4 | 7 | 28859 | 19 | |
134719 | 253755 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 41x Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
134726 | 113241 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 329 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3 | 3x4 | Permit Number 770912 | 6014742.36618 | 2112476.99378 | 37.7812877223957 | -122.39262057329 | (37.7812877223957, -122.39262057329) | 6 | 2 | 9 | 28856 | 6 | |
134738 | 115357 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 270 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2016 12:00:00 AM | 3 | 3x6 | 5999894.51999 | 2091641.88128 | 37.7232437759734 | -122.442490363056 | (37.7232437759734, -122.442490363056) | 9 | 7 | 6 | 28861 | 25 | ||
134827 | 255697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
134962 | 147590 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990251.14725 | 2113004.86394 | 37.7813465020817 | -122.477385854376 | (37.7813465020817, -122.477385854376) | 11 | 6 | 2 | 55 | 26 | |
135281 | 253476 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
135790 | 256689 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2825 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2018 12:00:00 AM | 3 | Permit Number 772474 | 5986729.50015 | 2114421.37847 | 37.7850308764656 | -122.489673069254 | (37.7850308764656, -122.489673069254) | 11 | 6 | 1 | 55 | 33 | ||
135842 | 115529 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007327.31765 | 2111347.52577 | 37.777771876795 | -122.418192961161 | (37.777771876795, -122.418192961161) | 7 | 9 | 9 | 28852 | 36 | |
135896 | 114985 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 1188 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 773128 | 6003158.9 | 2101346.9 | 37.7500770674438 | -122.43189868142 | (37.7500770674438, -122.43189868142) | 2 | 4 | 5 | 28862 | 22 | |||
135960 | 103695 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006027.79546 | 2103458.18152 | 37.7560363783091 | -122.422127839194 | (37.7560363783091, -122.422127839194) | 2 | 4 | 5 | 28859 | 19 | |
135962 | 187674 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
136198 | 255789 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2240 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003983 | 2116665 | 37.7921835181407 | -122.430141547967 | (37.7921835181407, -122.430141547967) | 13 | 9 | 1 | 29490 | 27 | ||||
136423 | 122426 | Planning Code 138.1 required 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 2655 Bush St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | 15 | 6 | 1 | 29490 | 27 | |
136714 | 65940 | Planning Code 138.1 required 2 | Liquidambar styraciflua :: American Sweet Gum 37 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.7833233693217 | -122.417975883707 | (37.7833233693217, -122.417975883707) | 7 | 9 | 9 | 28858 | 36 | |
136966 | 116777 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1106 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008763.52683 | 2117990.43413 | 37.7960924320727 | -122.413694581941 | (37.7960924320727, -122.413694581941) | 5 | 1 | 10 | 308 | 21 | ||
137347 | 116851 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 83 Panorama Dr | 3 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
137539 | 113649 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
138593 | 56707 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 782197 | 5983170.4061 | 2103643.307 | 37.7552289545408 | -122.501188731534 | (37.7552289545408, -122.501188731534) | 1 | 8 | 3 | 56 | 35 | |||
138609 | 251178 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
139116 | 255407 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
139366 | 172746 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006038.86692 | 2120389.38612 | 37.8025259652646 | -122.423293075825 | (37.8025259652646, -122.423293075825) | 5 | 9 | 1 | 28858 | 32 |
139476 | 113655 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 901X JESSIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 3x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
139506 | 254366 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
139523 | 254363 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 634 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 772779 | 5981973.79907 | 2111426.3014 | 37.7765284742444 | -122.505903875162 | (37.7765284742444, -122.505903875162) | 11 | 6 | 2 | 55 | 26 | |
139534 | 253737 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
139833 | 198581 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013801.3988 | 2107146.90693 | 37.7666001988537 | -122.395502349162 | (37.7666001988537, -122.395502349162) | 14 | 3 | 8 | 28856 | 20 | |
139844 | 121546 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
140218 | 256881 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 25th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x10 | Permit Number 781920 | 5988824.60597 | 2094879.63635 | 37.7314966214822 | -122.480993433312 | (37.7314966214822, -122.480993433312) | 1 | 8 | 4 | 64 | 35 | |
141327 | 253287 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1237 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780510 | 6016839.12241 | 2092718.79414 | 37.7271520593202 | -122.383990506478 | (37.7271520593202, -122.383990506478) | 10 | 3 | 8 | 58 | 1 | |
141915 | 225774 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002400.68275 | 2104833.82508 | 37.7596083179996 | -122.434769956692 | (37.7596083179996, -122.434769956692) | 2 | 4 | 5 | 28862 | 3 | ||
142538 | 253747 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
142552 | 120109 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 555 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | 3x3 | 5997970 | 2087042 | 37.7105036758619 | -122.448811863159 | (37.7105036758619, -122.448811863159) | 9 | 7 | 6 | 28861 | 25 | ||
142606 | 199438 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 189 Hubbell St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013354.61019 | 2107458.2254 | 37.7674301489953 | -122.397069554541 | (37.7674301489953, -122.397069554541) | 14 | 3 | 8 | 28856 | 20 | |
142797 | 115805 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 872 Kansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.7585117443173 | -122.403098033012 | (37.7585117443173, -122.403098033012) | 10 | 3 | 8 | 28856 | 29 | |||
143851 | 249555 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 1 | : | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005893.0868 | 2115064.96247 | 37.7878982115887 | -122.423418809148 | (37.7878982115887, -122.423418809148) | 13 | 9 | 1 | 28858 | 41 | |
144520 | 43569 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | 3x3 | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | ||
144548 | 254740 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1814 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779958 | 5983225 | 2102757 | 37.752798609062 | -122.500934388909 | (37.752798609062, -122.500934388909) | 1 | 8 | 3 | 56 | 35 | |
145251 | 108356 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.7984161192732 | -122.436618162405 | (37.7984161192732, -122.436618162405) | 13 | 9 | 1 | 57 | 17 | |
145605 | 183545 | Planning Code 138.1 required 2 | Agonis flexuosa :: Peppermint Willow 65 | 2580 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | 4x4 | Permit Number 777874 | 5988340.9772 | 2097760.0505 | 37.7393773655768 | -122.482876432223 | (37.7393773655768, -122.482876432223) | 1 | 8 | 3 | 29491 | 35 | |
145785 | 253796 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.7331586170673 | -122.400946899168 | (37.7331586170673, -122.400946899168) | 10 | 3 | 8 | 58 | 1 | ||
145856 | 254700 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
145930 | 44005 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
146537 | 173613 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2955 20th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.44954 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | 1 | 8 | 4 | 64 | 35 | |
146805 | 121136 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1875 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/04/2017 12:00:00 AM | 3 | 3x3 | 6006784.10346 | 2107469.87255 | 37.7670941752111 | -122.419796914586 | (37.7670941752111, -122.419796914586) | 8 | 4 | 7 | 28853 | 19 | |
147146 | 256033 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1459 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015639 | 2093574 | 37.7294338636754 | -122.388199012441 | (37.7294338636754, -122.388199012441) | 10 | 3 | 8 | 58 | 1 | ||||
147582 | 166259 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2880 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6008980.17665 | 2103937.78959 | 37.7575193538388 | -122.41195137385 | (37.7575193538388, -122.41195137385) | 2 | 4 | 7 | 28859 | 19 | |||
147840 | 170500 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 1178 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003320.2391 | 2094320.37512 | 37.7307929928046 | -122.430839374365 | (37.7307929928046, -122.430839374365) | 9 | 7 | 5 | 28861 | 25 | |
147853 | 64697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006319.44787647 | 2103419.18592492 | 37.7559457511246 | -122.421116437378 | (37.7559457511246, -122.421116437378) | 2 | 4 | 5 | 28859 | 19 | |
148641 | 253378 | Planning Code 138.1 required 2 | :: 45 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001556 | 2108661 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | 15 | 5 | 5 | 29492 | 9 | ||||
148677 | 121464 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001140 | 2119261 | 37.7991500226194 | -122.440164592168 | (37.7991500226194, -122.440164592168) | 13 | 9 | 1 | 57 | 17 | ||||
148701 | 115559 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2539 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001373.79142 | 2117611.09107 | 37.7946331129763 | -122.439237274207 | (37.7946331129763, -122.439237274207) | 13 | 9 | 1 | 57 | 27 | |||
148882 | 159485 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 Farragut Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782109 | 5997299.08146 | 2087363.42174 | 37.7113478362182 | -122.451153855174 | (37.7113478362182, -122.451153855174) | 9 | 7 | 6 | 28861 | 25 | |
149074 | 255412 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
149325 | 187946 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015145.56326 | 2115239.56325 | 37.7888954931699 | -122.391418882079 | (37.7888954931699, -122.391418882079) | 6 | 2 | 9 | 28855 | 6 | ||||
149634 | 118361 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.76538 | 2115716.99395 | 37.7896817924241 | -122.423878022401 | (37.7896817924241, -122.423878022401) | 13 | 9 | 1 | 28858 | 41 | ||
149736 | 121282 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
149769 | 121517 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
150292 | 109461 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 773752 | 6013397.07251 | 2109454.07559 | 37.7729126707161 | -122.397062640549 | (37.7729126707161, -122.397062640549) | 14 | 2 | 9 | 310 | 20 | ||
151100 | 81972 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1822 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774361 | 5989407.90008391 | 2102936.76390687 | 37.7536532824256 | -122.479566183797 | (37.7536532824256, -122.479566183797) | 1 | 8 | 3 | 56 | 35 | |
151446 | 170486 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 121 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003308.3245 | 2094432.02915 | 37.7310988944888 | -122.430888530379 | (37.7310988944888, -122.430888530379) | 9 | 7 | 5 | 28861 | 25 | |
151779 | 249556 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 2 | : | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005884.08324 | 2115105.79396 | 37.7880098165527 | -122.423452863778 | (37.7880098165527, -122.423452863778) | 13 | 9 | 1 | 28858 | 41 | |
152002 | 121279 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
152102 | 109458 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | Permit Number 773752 | 6013450.12112 | 2109506.07563 | 37.7730584040491 | -122.396882784219 | (37.7730584040491, -122.396882784219) | 14 | 2 | 9 | 310 | 20 | ||
152110 | 239088 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.40071 | 37.748496089722 | -122.426200479689 | (37.748496089722, -122.426200479689) | 2 | 4 | 5 | 63 | 22 | ||
152203 | 152615 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
152218 | 152308 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3420 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6006693.54336 | 2105565.92746 | 37.7618612870018 | -122.419975023524 | (37.7618612870018, -122.419975023524) | 8 | 4 | 7 | 28859 | 19 | |||
152234 | 255608 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 949 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002910 | 2110236 | 37.7744702748436 | -122.433394524315 | (37.7744702748436, -122.433394524315) | 15 | 5 | 11 | 29492 | 10 | ||||
152599 | 121532 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
152719 | 113648 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
152753 | 115349 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014896.08459 | 2114567.05321 | 37.7870350854597 | -122.392234997951 | (37.7870350854597, -122.392234997951) | 6 | 2 | 9 | 28855 | 6 | |
152864 | 124718 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 610 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.7389386461297 | -122.415817669649 | (37.7389386461297, -122.415817669649) | 2 | 7 | 7 | 28859 | 2 | |
152958 | 258304 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2946 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008567 | 2103911 | 37.7574226061115 | -122.413378415329 | (37.7574226061115, -122.413378415329) | 2 | 4 | 7 | 28859 | 19 | ||||
153036 | 256778 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1231 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 782672 | 6001926.50082 | 2110819.32275 | 37.7760160870933 | -122.436838397294 | (37.7760160870933, -122.436838397294) | 15 | 5 | 11 | 29492 | 10 | ||
153202 | 115351 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014858.41874 | 2114606.67601 | 37.7871417890985 | -122.392368086818 | (37.7871417890985, -122.392368086818) | 6 | 2 | 9 | 28855 | 6 | |
154592 | 109464 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013338.99753 | 2109402.36294 | 37.7727674463814 | -122.39725990323 | (37.7727674463814, -122.39725990323) | 14 | 2 | 9 | 310 | 20 | ||
154892 | 113645 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
155417 | 106315 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
155799 | 256869 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009287.99434 | 2098069.06568 | 37.7414224065761 | -122.410472416169 | (37.7414224065761, -122.410472416169) | 10 | 7 | 7 | 28859 | 2 | |
155834 | 203210 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 189 Hubbell St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013290.07277 | 2107397.08786 | 37.7672586860712 | -122.397288494465 | (37.7672586860712, -122.397288494465) | 14 | 3 | 8 | 28856 | 20 | |
156097 | 253105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1295 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
156122 | 115979 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011610.19593 | 2091240.25279 | 37.7228018257296 | -122.401963063449 | (37.7228018257296, -122.401963063449) | 10 | 3 | 7 | 309 | 28 | |||
156271 | 253867 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1628 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 56289 | 6006959.29312 | 2116755.16361 | 37.7925992053311 | -122.419849904466 | (37.7925992053311, -122.419849904466) | 13 | 9 | 10 | 28858 | 32 | |
156329 | 253868 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1628 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 56289 | 6006959.29312 | 2116755.16361 | 37.7925992053311 | -122.419849904466 | (37.7925992053311, -122.419849904466) | 13 | 9 | 10 | 28858 | 32 | |
156678 | 255580 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 384 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778885 | 6003411.13256 | 2099532.22132 | 37.7451086791398 | -122.430896954644 | (37.7451086791398, -122.430896954644) | 2 | 7 | 5 | 63 | 22 | |
157324 | 32045 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2979 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | Permit Number 781325 | 5999951.23823 | 2116389.65594 | 37.7911983214916 | -122.444071670681 | (37.7911983214916, -122.444071670681) | 13 | 6 | 1 | 29490 | 27 | ||
157692 | 249558 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 4 | : | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005877.98213 | 2115146.79048 | 37.7881220384566 | -122.423476888259 | (37.7881220384566, -122.423476888259) | 13 | 9 | 1 | 28858 | 41 | |
158086 | 15247 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007902.55668 | 2110326.57547 | 37.7750009522643 | -122.416130681693 | (37.7750009522643, -122.416130681693) | 8 | 2 | 9 | 28853 | 34 | |
158236 | 116267 | Planning Code 138.1 required 2 | Acer japonicum :: Japanese Maple 124 | 717 PARIS ST | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001138 | 2089523 | 37.7174966063475 | -122.438040195581 | (37.7174966063475, -122.438040195581) | 9 | 7 | 6 | 28861 | 5 | ||||
158426 | 256673 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 1 | Side Yard : Cutout | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
158442 | 254367 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
158600 | 160369 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001700.06015 | 2088961.7176 | 37.7159873981889 | -122.436057273237 | (37.7159873981889, -122.436057273237) | 9 | 7 | 6 | 28861 | 5 | |
158751 | 115978 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011623.9012 | 2091244.95295 | 37.7228154963084 | -122.40191601721 | (37.7228154963084, -122.40191601721) | 10 | 3 | 7 | 309 | 28 |
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) );