trees
185 rows where Police Districts = 5 and qLegalStatus_id = 6 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180 | 110904 | Significant Tree 6 | Tree(s) :: 17 | 203 CORBETT AVE | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6000094 | 2105620 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | 15 | 5 | 5 | 28862 | 3 | |||
3462 | 233333 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 188 States St | 1 | Back Yard : Yard | Tree | Private 2 | 14 | Width 3ft | Permit Number 784841 | 6001049.9199 | 2106366.66768 | 37.763740347549 | -122.43955144426 | (37.763740347549, -122.43955144426) | 15 | 5 | 5 | 28862 | 3 | ||
5239 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
22915 | 92852 | Significant Tree 6 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 3794 16th St | 1 | Front Yard : Yard | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901 | 2106436 | 37.7639791186972 | -122.436612788339 | (37.7639791186972, -122.436612788339) | 15 | 5 | 5 | 28862 | 3 | |||
23199 | 112923 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
23924 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 4 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
24444 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 240 States St | 1 | Back Yard : Yard | Tree | Private 2 | 6001213 | 2106258 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | 15 | 5 | 5 | 28862 | 3 | |||||
36736 | 101527 | Significant Tree 6 | Ailanthus altissima :: Tree Of Heaven 333 | 151-153 Lower Ter | 1 | Front Yard : Yard | Tree | Private 2 | 18 | Permit Number 769490 | 6000139.7 | 2106146.6 | 37.7630842500585 | -122.4426838025 | (37.7630842500585, -122.4426838025) | 15 | 5 | 5 | 28862 | 3 | |||
38051 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | 5998985.48572 | 2105240.3128 | 37.7605299471227 | -122.446610614338 | (37.7605299471227, -122.446610614338) | 15 | 5 | 5 | 28862 | 12 | ||||||
38960 | 103564 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 878 14th St | 2 | Front Yard : Yard | Tree | Private 2 | 13 | Permit Number 770193 | 6002986 | 2107714 | 37.7675497941952 | -122.432951409123 | (37.7675497941952, -122.432951409123) | 15 | 5 | 5 | 28862 | 3 | |||
39128 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Clayton St | 1 | Side Yard : Yard | Tree | Private 2 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||||
50909 | 103563 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 878 14th St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Permit Number 770193 | 6002986 | 2107714 | 37.7675497941952 | -122.432951409123 | (37.7675497941952, -122.432951409123) | 15 | 5 | 5 | 28862 | 3 | |||
51579 | 251199 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 4 | Front Yard : Yard | Tree | Private 2 | 3X3 | 6002515 | 2107976 | 37.768242455455 | -122.434599270731 | (37.768242455455, -122.434599270731) | 15 | 5 | 5 | 28862 | 3 | ||||
53110 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
56286 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
58774 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 50X Noe St | 8 | Front Yard : Yard | Tree | Private 2 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | 15 | 5 | 5 | 28862 | 3 | ||
65651 | 112922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
68234 | 107718 | Significant Tree 6 | Tree(s) :: 17 | 1 DOUGLASS ST | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6001037.5 | 2106279.2 | 37.7634994759637 | -122.439588129958 | (37.7634994759637, -122.439588129958) | 15 | 5 | 5 | 28862 | 3 | ||||
74096 | 112921 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
77157 | 112924 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||||
87223 | 103565 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 878 14th St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | Permit Number 770193 | 6002986 | 2107714 | 37.7675497941952 | -122.432951409123 | (37.7675497941952, -122.432951409123) | 15 | 5 | 5 | 28862 | 3 | |||
106523 | 112930 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
119143 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 2 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
131738 | 92899 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 3 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
135834 | 102467 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 Saint Germain Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5997576.7 | 2104111.9 | 37.757351037011 | -122.451401547119 | (37.757351037011, -122.451401547119) | 15 | 5 | 4 | 28862 | 38 | |||||
139544 | 104085 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 1329 Stanyan St | 1 | Front Yard : Yard | Tree | Private 2 | 08/07/2013 12:00:00 AM | Permit Number 770194 | 5997530.4 | 2104741.3 | 37.7590765601241 | -122.451607069148 | (37.7590765601241, -122.451607069148) | 15 | 5 | 4 | 28862 | 12 | |||
145840 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
148103 | 112925 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
149146 | 105234 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 250 STATES ST | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6000595.6 | 2106681.2 | 37.7645781078798 | -122.441145360444 | (37.7645781078798, -122.441145360444) | 15 | 5 | 5 | 28862 | 3 | ||||
150406 | 251198 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 3 | Front Yard : Yard | Tree | Private 2 | 6002515 | 2107976 | 37.768242455455 | -122.434599270731 | (37.768242455455, -122.434599270731) | 15 | 5 | 5 | 28862 | 3 | |||||
151892 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 1 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
155327 | 107408 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 10 PEMBERTON PL | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 5998956.5 | 2104566.5 | 37.7586781689727 | -122.446662380642 | (37.7586781689727, -122.446662380642) | 15 | 5 | 5 | 28862 | 12 | ||||
157634 | 85365 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 66 Clarendon Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49641 | 5997837.8 | 2104660.2 | 37.7588714791444 | -122.450538092312 | (37.7588714791444, -122.450538092312) | 15 | 5 | 11 | 28862 | 12 | |||
158598 | 117249 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x GRAYSTONE TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999641 | 2104067 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | 2 | 5 | 5 | 28862 | 3 | |||
163659 | 102019 | Significant Tree 6 | Melaleuca quinquenervia :: Cajeput 10 | 3028 Market St | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 4x14 | 6000376.7 | 2105451.5 | 37.7611891846044 | -122.44181421161 | (37.7611891846044, -122.44181421161) | 15 | 5 | 5 | 28862 | 3 | |||
166722 | 112928 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
173581 | 251197 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 3 | Front Yard : Yard | Tree | Private 2 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779570 | 6002798.55883 | 2107703.57748 | 37.7675105430125 | -122.433598998019 | (37.7675105430125, -122.433598998019) | 15 | 5 | 5 | 28862 | 3 | ||
173974 | 251394 | Significant Tree 6 | Araucaria araucana :: Monkey puzzle 287 | 203 Corbett Ave | 1 | Front Yard : Yard | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779803 | 6000094 | 2105620 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | 15 | 5 | 5 | 28862 | 3 | |
175631 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 2 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
176305 | 112927 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
178096 | 117248 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x GRAYSTONE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999641 | 2104067 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | 2 | 5 | 5 | 28862 | 3 | ||||
179756 | 112920 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
180810 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 2 | Front Yard : Cutout | Tree | Private 2 | 03/22/2017 12:00:00 AM | 3 | 6002515 | 2107976 | 37.768242455455 | -122.434599270731 | (37.768242455455, -122.434599270731) | 15 | 5 | 5 | 28862 | 3 | |||
184408 | 92853 | Significant Tree 6 | Cercis occidentalis :: Western Redbud 136 | 3794 16th St | 2 | Front Yard : Yard | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901 | 2106436 | 37.7639791186972 | -122.436612788339 | (37.7639791186972, -122.436612788339) | 15 | 5 | 5 | 28862 | 3 | |||
186584 | 112926 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
190335 | 173903 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 675 Corbett Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999984 | 2103563 | 37.7559814441149 | -122.443036761048 | (37.7559814441149, -122.443036761048) | 2 | 5 | 5 | 28862 | 38 | |||||
35278 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999865 | 2112093 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | 15 | 5 | 1 | 29490 | 16 | ||||
38032 | 110839 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 | ||||
62810 | 110841 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 3 | Front Yard : Yard | Tree | Private 2 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 | |||||
68001 | 110840 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 2 | Front Yard : Yard | Tree | Private 2 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 | |||||
106559 | 110842 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 4 | Front Yard : Yard | Tree | Private 2 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 | |||||
119882 | 105045 | Significant Tree 6 | Tree(s) :: 17 | 1899X Eddy St | 3 | Front Yard : Yard | Tree | Private 2 | 02/21/2014 12:00:00 AM | Permit Number 772599 | 6001374.8 | 2112478.6 | 37.7805406719806 | -122.438865805362 | (37.7805406719806, -122.438865805362) | 15 | 5 | 11 | 29490 | 41 | |||
144656 | 255730 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002272 | 2111622 | 37.7782396679587 | -122.435700666763 | (37.7782396679587, -122.435700666763) | 15 | 5 | 11 | 29490 | 41 | ||||
147971 | 253973 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 2 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
155662 | 105755 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1100X Divisadero St | 1 | Front Yard : Yard | Tree | Private 2 | 6001418 | 2112151 | 37.7796436231931 | -122.438692875339 | (37.7796436231931, -122.438692875339) | 15 | 5 | 11 | 29490 | 41 | |||||
158054 | 105754 | Significant Tree 6 | Tree(s) :: 17 | 1899X Eddy St | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2014 12:00:00 AM | Permit Number 772599 | 6001374.8 | 2112478.6 | 37.7805406719806 | -122.438865805362 | (37.7805406719806, -122.438865805362) | 15 | 5 | 11 | 29490 | 41 | |||
163295 | 253972 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 1 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
193693 | 255496 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2100 Turk Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 5999950 | 2111978 | 37.7790849877594 | -122.443758873408 | (37.7790849877594, -122.443758873408) | 15 | 5 | 1 | 29490 | 16 | |||||
5712 | 258876 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1326 Hayes St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 0ft | 6001504 | 2110473 | 37.7750411502564 | -122.438275119801 | (37.7750411502564, -122.438275119801) | 15 | 5 | 11 | 29492 | 10 | ||||
10379 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard | Tree | Private 2 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177 | 2107098 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | 15 | 5 | 5 | 29492 | 3 | |||
13777 | 261032 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 438 Roosevelt Way | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6000030.97008 | 2106544.70148 | 37.7641711390149 | -122.443088453592 | (37.7641711390149, -122.443088453592) | 15 | 5 | 5 | 29492 | 3 | ||||
14733 | 255398 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 637 MASONIC AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 0ft | 5999139.3301 | 2110590.1819 | 37.7752281241925 | -122.446463429304 | (37.7752281241925, -122.446463429304) | 15 | 5 | 11 | 29492 | 16 | ||||
14822 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 184 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632 | 2105999 | 37.7624783944866 | -122.454805014883 | (37.7624783944866, -122.454805014883) | 15 | 5 | 11 | 29492 | 12 | |||
15509 | 258701 | Significant Tree 6 | Tree(s) :: 17 | 206 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783089 | 5996625 | 2105876 | 37.7621402663071 | -122.454820337862 | (37.7621402663071, -122.454820337862) | 15 | 5 | 11 | 29492 | 12 | |
15969 | 261831 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 1507 Cole St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5998279 | 2105297 | 37.7606452154312 | -122.449058098094 | (37.7606452154312, -122.449058098094) | 15 | 5 | 11 | 29492 | 12 | ||||
18711 | 262449 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 155 Baker St | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | 15 | 5 | 11 | 29492 | 9 | ||||
20293 | 254534 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 737 Buena Vista Ave West | 6 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
21449 | 255662 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1626 Shrader St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | Permit Number 782137 | 5998119 | 2105007 | 37.759839795982 | -122.44959056596 | (37.759839795982, -122.44959056596) | 15 | 5 | 11 | 29492 | 12 | |||
23401 | 114142 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6001906.1 | 2108188.4 | 37.7687910682296 | -122.436720598265 | (37.7687910682296, -122.436720598265) | 15 | 5 | 5 | 29492 | 3 | ||||||
25036 | 95137 | Significant Tree 6 | Tree(s) :: 17 | 2130 Fulton St | 127 | Front Yard : | Tree | Private 2 | 01/07/2011 12:00:00 AM | 3x3 | Permit Number 54069 | 5997590 | 2110608 | 37.7751884337973 | -122.451824172116 | (37.7751884337973, -122.451824172116) | 15 | 5 | 2 | 29492 | 16 | ||
25777 | 257968 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
32791 | 254539 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 737 Buena Vista Ave West | 5 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
33415 | 95138 | Significant Tree 6 | Tree(s) :: 17 | 2130 Fulton St | 128 | Front Yard : | Tree | Private 2 | 01/07/2011 12:00:00 AM | 3x3 | Permit Number 54069 | 5997590 | 2110608 | 37.7751884337973 | -122.451824172116 | (37.7751884337973, -122.451824172116) | 15 | 5 | 2 | 29492 | 16 | ||
34055 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 3 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
34533 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 7X CASTRO ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002014.1 | 2108690 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | 15 | 5 | 5 | 29492 | 9 | ||||
35186 | 100579 | Significant Tree 6 | Tree(s) :: 17 | 35 Lloyd St | 2 | Front Yard : Yard | Tree | Private 2 | 6002279.7 | 2108550 | 37.7698051576272 | -122.435454215606 | (37.7698051576272, -122.435454215606) | 15 | 5 | 5 | 29492 | 9 | |||||
35924 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399 | 2109002 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | 15 | 5 | 11 | 29492 | 9 | |
36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
37143 | 257967 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
37158 | 254238 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 3 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
37603 | 93205 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 3 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
40516 | 254236 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 1 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
43728 | 254538 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 737 Buena Vista Ave West | 4 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
49649 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||
59354 | 102987 | Significant Tree 6 | Quercus palustris :: Pin Oak 379 | 161 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 769930 | 5996558.2 | 2106100.3 | 37.7627523048829 | -122.455067580852 | (37.7627523048829, -122.455067580852) | 15 | 5 | 11 | 29492 | 12 | ||||
61598 | 99299 | Significant Tree 6 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 1457 Willard St | 1 | Front Yard : | Tree | Private 2 | 05/02/2012 12:00:00 AM | Permit Number 768720 | 5996809.7 | 2106270.3 | 37.763233506694 | -122.454210015753 | (37.763233506694, -122.454210015753) | 15 | 5 | 11 | 29492 | 12 | |||
63103 | 101204 | Significant Tree 6 | Tree(s) :: 17 | 1290 Stanyan St | 1 | Front Yard : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769288 | 5997580.9 | 2104992.4 | 37.7597689094704 | -122.451450528065 | (37.7597689094704, -122.451450528065) | 15 | 5 | 11 | 29492 | 12 | |||
64719 | 253770 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 234 Carl St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 770677 | 5997066 | 2107091 | 37.7655016335596 | -122.453382820195 | (37.7655016335596, -122.453382820195) | 15 | 5 | 11 | 29492 | 12 | |||
67290 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
73911 | 254536 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 737 Buena Vista Ave West | 2 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
74277 | 251372 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 Masonic Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779800 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | |
83112 | 93724 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 415 Belvedere St | Front Yard : Yard | Tree | Private 2 | 5998488 | 2106798 | 37.7647785355325 | -122.448443362436 | (37.7647785355325, -122.448443362436) | 15 | 5 | 11 | 29492 | 9 | ||||||
83943 | 118327 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 109 ALPINE TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x7 | 6001716.4 | 2108199.1 | 37.7688096651516 | -122.43737752181 | (37.7688096651516, -122.43737752181) | 15 | 5 | 5 | 29492 | 3 | ||||
85388 | 255663 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1626 Shrader St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | Permit Number 782137 | 5998119 | 2105007 | 37.759839795982 | -122.44959056596 | (37.759839795982, -122.44959056596) | 15 | 5 | 11 | 29492 | 12 | |||
86356 | 254240 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 5 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
88761 | 111358 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1637 OAK ST | 1 | Front Yard : Yard | Tree | Private 2 | 3x15 | 5999143 | 2109364 | 37.7718615511814 | -122.446362505197 | (37.7718615511814, -122.446362505197) | 15 | 5 | 11 | 29492 | 9 | ||||
89139 | 111359 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1637 OAK ST | 2 | Front Yard : Yard | Tree | Private 2 | 3x15 | 5999143 | 2109364 | 37.7718615511814 | -122.446362505197 | (37.7718615511814, -122.446362505197) | 15 | 5 | 11 | 29492 | 9 | ||||
94836 | 254241 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 6 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
98332 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
102398 | 105415 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 1 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 |
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) );