1,011 rows where qLegalStatus_id = 2 sorted by PermitNotes

View and edit SQL

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)
107276 121511 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
108115 242845 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 1559 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2018 12:00:00 AM 3 3x3   6004609.7731 2099770.4554 37.7458306574531 -122.426769226215 (37.7458306574531, -122.426769226215) 2 7 5 63 22
108346 255693 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 3 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
108535 255409 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 5 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
109022 255406 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 2 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
109444 255700 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 510 Townsend St 10 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
110069 116528 Planning Code 138.1 required 2 :: 45 125 CROWN TER 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5998841 2104182 37.7576158290564 -122.447034160915 (37.7576158290564, -122.447034160915) 2 5 5 28862 3
110801 187940 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6015048.62855 2115342.19505 37.7891719160015 -122.391761444649 (37.7891719160015, -122.391761444649) 6 2 9 28855 6
111570 254719 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
112949 244834 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1875 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2017 12:00:00 AM 3 Width 3ft   6006796.01232 2107481.11788 37.7671257231045 -122.419756521569 (37.7671257231045, -122.419756521569) 8 4 7 28853 19
114018 254721 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
115253 251524 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
115977 258090 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1223 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2019 12:00:00 AM 3 4x6   6013685 2090528 37.7209617016481 -122.394740998302 (37.7209617016481, -122.394740998302) 10 3 8 58 1
116197 253754 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 8 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
117838 121542 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
118314 120115 Planning Code 138.1 required 2 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2225 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6000127.23839 2120216.52423 37.8017159270068 -122.443737765003 (37.8017159270068, -122.443737765003) 13 9 1 57 17
120065 258340 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 121 Peabody St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2019 12:00:00 AM 3 3x3   6010033.53413 2086907.42536 37.7108166491636 -122.407108010284 (37.7108166491636, -122.407108010284) 9 7 8 309 39
120199 116966 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6010311.67872 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703) 8 4 8 28859 19
120636 121503 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 3 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014412.49464 2115075.87435 37.7884053276005 -122.393943755694 (37.7884053276005, -122.393943755694) 6 2 9 28855 6
121031 253742 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 8 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
121157 257909 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20
122606 187947 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 8 Sidewalk: Curb side : Yard Tree Private 2     3     6015161.72984 2115222.99296 37.7888508922136 -122.391361788631 (37.7888508922136, -122.391361788631) 6 2 9 28855 6
123272 256677 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 2 Sidewalk: Curb side : 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
123458 253739 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 5 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
124352 255410 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 6 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
125325 256910 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 835 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2019 12:00:00 AM 3 3x3   6007598 2104806 37.7598256170474 -122.416793017555 (37.7598256170474, -122.416793017555) 2 4 7 28859 19
125559 120527 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1672 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2016 12:00:00 AM 3 3x3   5981030 2103685 37.7552175094175 -122.508593851446 (37.7552175094175, -122.508593851446) 1 8 3 56 35
126016 254720 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
126056 255417 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6007395 2111066 37.7770026839515 -122.417938862064 (37.7770026839515, -122.417938862064) 7 9 9 28852 36
126952 175423 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 175 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2017 12:00:00 AM 3 Width 3ft   6004547.44022 2093795.9618 37.7294225258266 -122.426559415306 (37.7294225258266, -122.426559415306) 9 7 6 28861 5
127405 256685 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 10 Back Yard : Yard 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
129120 246406 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
129348 251179 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
129695 116776 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008776.88904 2117992.21481 37.7960980717264 -122.413648471894 (37.7960980717264, -122.413648471894) 5 1 10 308 21
130074 255415 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 11 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
130529 256674 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 2 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
130781 255652 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 949 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002910 2110236 37.7744702748436 -122.433394524315 (37.7744702748436, -122.433394524315) 15 5 11 29492 10
131987 254722 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
132560 251521 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
160718 117479 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
160771 187941 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 2 Sidewalk: Curb side : Yard Tree Private 2     3     6015065.49236 2115322.58848 37.7891190169896 -122.391701726057 (37.7891190169896, -122.391701726057) 6 2 9 28855 6
160922 121508 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 3 Sidewalk: Property side : Cutout Tree Private 2     6 3x3   6012258.9126 2112729.3972 37.7818425275943 -122.401229897449 (37.7818425275943, -122.401229897449) 6 2 9 28856 34
161626 255692 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 2 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
161826 256678 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 4 Sidewalk: Curb side : 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
162006 254723 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
163114 253748 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 2x Rhode Island St 2 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
163344 115976 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757) 10 3 7 309 28
164050 114792 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 10 Linares Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x10   5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
164068 254716 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
164459 116850 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 83 Panorama Dr 2 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
164769 255405 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 1 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
165057 255376 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
165093 251522 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
165740 255404 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 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
166298 251296 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 2 Sidewalk: Curb side : Cutout Tree Private 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
166329 117480 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
167011 254235 Planning Code 138.1 required 2 Syzygium australe :: Eugenia 228 454 Ralston St 1 Unaccepted Street : Cutout Tree Private 2       10x10   5992261 2090872 37.7206918008503 -122.468821743954 (37.7206918008503, -122.468821743954) 9 8 6 64 24
167550 255408 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 4 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
167666 173650 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Entrada Ct 2 Sidewalk: Property side : Yard Tree Private 2   12/21/2016 12:00:00 AM 3 4x10   5992424.45657 2092194.59394 37.7243327619491 -122.468352901223 (37.7243327619491, -122.468352901223) 9 8 4 59 40
168121 121519 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
169143 114980 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 281 32ND AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   5985853 2114037 37.7839242715215 -122.492677119536 (37.7839242715215, -122.492677119536) 11 6 1 55 33
169946 187675 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 3 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
170182 258184 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 95 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003372 2097903 37.74063299685 -122.430916015884 (37.74063299685, -122.430916015884) 2 7 5 63 7
170258 121530 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
170362 187678 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 6 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
171370 121537 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);