trees
185 rows where Police Districts = 5 and qLegalStatus_id = 6 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172555 | 120560 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 76 | 17X Castro St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002113 | 2108564 | 37.7698341292575 | -122.436031827668 | (37.7698341292575, -122.436031827668) | 15 | 5 | 5 | 29492 | 9 | ||||
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 | ||||
178383 | 254277 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 105 Gladeview Way | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | Permit Number 781296 | 5997754 | 2101950 | 37.7514251480437 | -122.450632514859 | (37.7514251480437, -122.450632514859) | 1 | 5 | 4 | 63 | 38 | |||
178948 | 117208 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 25 MIDCREST WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 5997992 | 2100464 | 37.7473585772285 | -122.44970241305 | (37.7473585772285, -122.44970241305) | 1 | 5 | 4 | 63 | 38 | ||||
180131 | 115391 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 21X BELMONT AVE | 1 | Front Yard : Yard | Tree | Private 2 | 48 | 5996611 | 2106266 | 37.7632103037359 | -122.454896938495 | (37.7632103037359, -122.454896938495) | 15 | 5 | 11 | 29492 | 12 | ||||
180522 | 98301 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
190157 | 117273 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 17 PEREGO TER | 1 | Back Yard : Yard | Tree | Private 2 | 5999542 | 2101494 | 37.7502752643571 | -122.444416651791 | (37.7502752643571, -122.444416651791) | 2 | 5 | 5 | 63 | 38 | |||||
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 | |||||
193192 | 99376 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 1088 Ashbury St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 768767 | 5998994 | 2106195 | 37.7631517661679 | -122.446649857914 | (37.7631517661679, -122.446649857914) | 15 | 5 | 5 | 29492 | 9 | ||||
193245 | 254239 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 4 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
193618 | 254237 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 2 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
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 | |||||
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 | |
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 | |
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 | ||
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 | ||
58512 | 253898 | Significant Tree 6 | Tree(s) :: 17 | 201X Oak Park Dr | 2 | Back Yard : Yard | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780818 | 5996124 | 2103402 | 37.7553185401494 | -122.45637419556 | (37.7553185401494, -122.45637419556) | 1 | 5 | 4 | 63 | 12 | |
183899 | 253897 | Significant Tree 6 | Tree(s) :: 17 | 201X Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780818 | 5996124 | 2103402 | 37.7553185401494 | -122.45637419556 | (37.7553185401494, -122.45637419556) | 1 | 5 | 4 | 63 | 12 | |
111867 | 115459 | Significant Tree 6 | Tree(s) :: 17 | 80 Crestline Dr | 1 | Back Yard : Yard | Tree | Private 2 | 02/02/2016 12:00:00 AM | 3 | Permit Number 776150 | 5999012.8 | 2102131.7 | 37.7519960240451 | -122.446292521132 | (37.7519960240451, -122.446292521132) | 2 | 5 | 5 | 63 | 38 | ||
179476 | 115460 | Significant Tree 6 | Tree(s) :: 17 | 80 Crestline Dr | 2 | Back Yard : Yard | Tree | Private 2 | 02/02/2016 12:00:00 AM | 3 | Permit Number 776150 | 5999012.8 | 2102131.7 | 37.7519960240451 | -122.446292521132 | (37.7519960240451, -122.446292521132) | 2 | 5 | 5 | 63 | 38 | ||
37092 | 254109 | Significant Tree 6 | Tree(s) :: 17 | 38X Starview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 6x6 | Permit Number 781050 | 5997469 | 2101545 | 37.7502968010125 | -122.451588863361 | (37.7502968010125, -122.451588863361) | 1 | 5 | 4 | 63 | 38 | |
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 | |||
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 | |||
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 | |||
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 | |||
158156 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 4 | 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 | |||
180298 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 2 | 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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
103639 | 254535 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 737 Buena Vista Ave West | 1 | 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 | ||
109929 | 254537 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 737 Buena Vista Ave West | 3 | 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 | ||||
80420 | 105436 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2014 12:00:00 AM | 15 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120329 | -122.459940260935 | (37.762927120329, -122.459940260935) | 15 | 5 | 11 | 56 | 12 | ||
155656 | 105435 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2014 12:00:00 AM | 16 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120329 | -122.459940260935 | (37.762927120329, -122.459940260935) | 15 | 5 | 11 | 56 | 12 | ||
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 | |||
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 | ||
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 | |||
166922 | 103307 | Significant Tree 6 | Pyrus spp :: Pear Tree 281 | 1467 Willard St | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2013 12:00:00 AM | 5 | 6x6 | Permit Number 768689 | 5996817.5 | 2106175 | 37.7629722844649 | -122.454176154627 | (37.7629722844649, -122.454176154627) | 15 | 5 | 11 | 29492 | 12 | |
124217 | 109412 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 24 DELMAR ST | 1 | Front Yard : Yard | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774367 | 5999307.7 | 2108197.1 | 37.7686669444558 | -122.445708866914 | (37.7686669444558, -122.445708866914) | 15 | 5 | 11 | 29492 | 9 | |
55746 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
172767 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 3 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
175269 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 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 | |||
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 | |
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 | |
107510 | 89309 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 1 | 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 | |
17429 | 103965 | Significant Tree 6 | Tree(s) :: 17 | 141 Marview Way | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2013 12:00:00 AM | Permit Number 770303 | 5998318.6 | 2103174 | 37.7548182509721 | -122.448768222318 | (37.7548182509721, -122.448768222318) | 1 | 5 | 4 | 63 | 38 | |||
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 | |||
178069 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 520X Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||
128997 | 109708 | Significant Tree 6 | Tree(s) :: 17 | 621 Laguna Honda Blvd | 3 | Front Yard : Cutout | Tree | Private 2 | FUF | 07/29/2015 12:00:00 AM | Permit Number 774799 | 5995723.9 | 2099907.4 | 37.7457002690083 | -122.457505029341 | (37.7457002690083, -122.457505029341) | 1 | 5 | 4 | 59 | 40 | ||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
96515 | 253513 | Significant Tree 6 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 | 1545 05th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/14/2012 12:00:00 AM | 3x3 | Permit Number 768941 | 5994803.92058 | 2105050.88998 | 37.7597700982665 | -122.461058902115 | (37.7597700982665, -122.461058902115) | 1 | 5 | 4 | 56 | 12 | ||
167818 | 99950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1545 05th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/14/2012 12:00:00 AM | Permit Number 768941 | 5994712.1 | 2105033.7 | 37.7597176147703 | -122.461375215787 | (37.7597176147703, -122.461375215787) | 1 | 5 | 4 | 56 | 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 | |||
153784 | 99733 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 1 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
163794 | 100464 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 3 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
168323 | 99734 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 2 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |
77181 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
93603 | 95230 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 6 | Front Yard : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 27 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
122339 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 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 | |
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 | |||
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 | |||
8580 | 261010 | Significant Tree 6 | Tree(s) :: 17 | 91 Parkridge Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784979 | 5998980 | 2102204 | 37.7521926688144 | -122.446411148664 | (37.7521926688144, -122.446411148664) | 2 | 5 | 5 | 63 | 38 | |
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 |
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) );