trees
185 rows where Police Districts = 5 and qLegalStatus_id = 6 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
139403 | 100171 | Significant Tree 6 | Quercus suber :: Cork Oak 78 | 109 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996563.8 | 2106359.1 | 37.763463224844 | -122.455066914463 | (37.763463224844, -122.455066914463) | 15 | 5 | 11 | 29492 | 12 | |||||
28871 | 100193 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
17949 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
80551 | 100195 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
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 | |||
145352 | 100578 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 35 Lloyd St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 56924 | 6002279.7 | 2108550 | 37.7698051576272 | -122.435454215606 | (37.7698051576272, -122.435454215606) | 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 | |||||
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 | |||
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 | |||
2352 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700X Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | 1 | 5 | 4 | 63 | 38 | |||||
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 | |||
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 | ||
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 | |||||
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 | ||||
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 | |
117472 | 103478 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 50 Gardenside Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770287 | 5999492 | 2102892 | 37.7541109784186 | -122.444690026478 | (37.7541109784186, -122.444690026478) | 2 | 5 | 5 | 63 | 38 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
158256 | 104037 | Significant Tree 6 | Tree(s) :: 17 | 520X Oak Park Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||||
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 | |||
151692 | 104169 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 470X Roosevelt Way | 1 | Front Yard : Yard | Tree | Private 2 | 5999944.58235 | 2106286.89423 | 37.7634583383964 | -122.443368723848 | (37.7634583383964, -122.443368723848) | 15 | 5 | 5 | 29492 | 3 | |||||
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 | |||
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 | ||||
108660 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.445678167683 | (37.7642451591147, -122.445678167683) | 15 | 5 | 5 | 29492 | 9 | ||||||
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 | |||||
114223 | 105416 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 2 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
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 | |||||
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 | ||
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 | ||
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 | |||
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 | |||||
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 | ||||
157045 | 105845 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||||
123285 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1060 Clayton St | 1 | Front Yard : Yard | Tree | Private 2 | 99 | 5998985 | 2106259 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | 15 | 5 | 5 | 29492 | 9 | ||||
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 | ||||
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 | ||||
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 | ||||||
132961 | 108177 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 201 PANORAMA DR | 1 | Front Yard : Yard | Tree | Private 2 | 22 | 3x3 | 5997273.1 | 2100946.6 | 37.7486425219839 | -122.452223122411 | (37.7486425219839, -122.452223122411) | 1 | 5 | 4 | 63 | 38 | |||
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 | |
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 | ||
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 | ||||
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 | ||||
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 | |||||
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 | |||||
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 | |||||
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 | |||
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 | ||||
115682 | 111766 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1860 HAYES ST | 4 | Front Yard : Yard | Tree | SFUSD 4 | 5998973 | 2110255 | 37.7742982989317 | -122.447014674672 | (37.7742982989317, -122.447014674672) | 15 | 5 | 11 | 29492 | 16 | |||||
160978 | 112451 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 MASONIC AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
125726 | 113380 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 63 Potomac St | 1 | Front Yard : Yard | Tree | Private 2 | 4x4 | Permit Number 776311 | 6003081 | 2108682.5 | 37.7702144463181 | -122.432692008068 | (37.7702144463181, -122.432692008068) | 15 | 5 | 5 | 29492 | 9 | |||
111048 | 113744 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 909 ASHBURY ST | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5999156 | 2107025 | 37.7654399906909 | -122.44614926226 | (37.7654399906909, -122.44614926226) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | ||||||
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 | ||||
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 | ||||
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 | ||
70573 | 116500 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 71X PARKRIDGE DR | 1 | Median : Yard | Tree | Private 2 | 45 | 3x3 | 5999012 | 2102131 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | 2 | 5 | 5 | 63 | 38 | |||
39106 | 116501 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 71X PARKRIDGE DR | 2 | Median : Yard | Tree | Private 2 | 40 | 3x3 | 5999012 | 2102131 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | 2 | 5 | 5 | 63 | 38 | |||
107819 | 116502 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 71X PARKRIDGE DR | 3 | Median : Yard | Tree | Private 2 | 28 | 3x3 | 5999012 | 2102131 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | 2 | 5 | 5 | 63 | 38 | |||
87199 | 116862 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 262X OAK PARK DR | 1 | Back Yard : Cutout | Tree | Private 2 | 10x10 | 5995091 | 2103085 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | 1 | 5 | 4 | 63 | 12 | ||||
86997 | 116863 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 262X OAK PARK DR | 2 | Back Yard : Cutout | Tree | Private 2 | 10x10 | 5995091 | 2103085 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | 1 | 5 | 4 | 63 | 12 | ||||
58933 | 116864 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 262X OAK PARK DR | 3 | Back Yard : Cutout | Tree | Private 2 | 10x10 | 5995091 | 2103085 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | 1 | 5 | 4 | 63 | 12 | ||||
164452 | 117027 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 731 CLAYTON ST | 1 | Front Yard : Cutout | Tree | Private 2 | 5998515 | 2108057 | 37.7682369747157 | -122.448440651351 | (37.7682369747157, -122.448440651351) | 15 | 5 | 11 | 29492 | 9 | |||||
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 | ||||
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 | ||||
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 | |||
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 | |||||
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 | ||||
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 | ||||
7026 | 121414 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150 Raccoon Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 36 | 3x3 | 5998776 | 2103987 | 37.7570766935068 | -122.447244922317 | (37.7570766935068, -122.447244922317) | 15 | 5 | 5 | 63 | 3 | |||
131538 | 173716 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1652 Fell St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999516 | 2109850 | 37.7732172801378 | -122.445107222354 | (37.7732172801378, -122.445107222354) | 15 | 5 | 11 | 29492 | 16 | |||||
3910 | 173844 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2X Crestline Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5999319 | 2101169 | 37.7493701671822 | -122.445164434644 | (37.7493701671822, -122.445164434644) | 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 | |||||
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 | |||||
77539 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 175 Raccoon Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5998689 | 2104063 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | 15 | 5 | 5 | 63 | 3 | |||||
134725 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997267 | 2099886 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | 1 | 5 | 4 | 59 | 38 | ||||
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 | ||
7245 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
10388 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
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 | |||
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 |
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) );