trees
400 rows where qSpecies_id = 43 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102213 | 99920 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
161440 | 9987 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | |||
64957 | 9986 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2007 12:00:00 AM | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | ||
122439 | 96990 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
135345 | 96989 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
108248 | 96988 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
67090 | 90956 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4645 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981155.43871 | 2110931.20899 | 37.7751208933778 | -122.508698002643 | (37.7751208933778, -122.508698002643) | 11 | 6 | 2 | 55 | 26 | ||
9754 | 82920 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5982872.9956 | 2103302.6049 | 37.7542760130661 | -122.502192036803 | (37.7542760130661, -122.502192036803) | 1 | 8 | 3 | 56 | 35 | |||
183661 | 79350 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1946 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767118 | 5983237.8759 | 2101878.6369 | 37.7503876245198 | -122.500824911735 | (37.7503876245198, -122.500824911735) | 1 | 8 | 3 | 29491 | 35 |
10339 | 73455 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 24 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009841.50181 | 2111066.87201 | 37.777142462881 | -122.409475680552 | (37.777142462881, -122.409475680552) | 8 | 2 | 9 | 28853 | 34 | |||
13763 | 72614 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1586 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987797.3449 | 2104500.8291 | 37.7578540967372 | -122.485250528016 | (37.7578540967372, -122.485250528016) | 1 | 8 | 3 | 56 | 35 | |||
10370 | 72596 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1551 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988056.3788 | 2104735.0481 | 37.7585122851486 | -122.484371869742 | (37.7585122851486, -122.484371869742) | 1 | 8 | 3 | 56 | 35 | |||
3187 | 70368 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.501507359539 | (37.7598111971708, -122.501507359539) | 1 | 8 | 3 | 56 | 35 | |||
29636 | 69317 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2122 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 6 | Permit Number 33397 | 5987643.2305 | 2104427.6901 | 37.7576442978234 | -122.485778145282 | (37.7576442978234, -122.485778145282) | 1 | 8 | 3 | 56 | 35 | |
190034 | 69279 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1935 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33350 | 5991240.95366227 | 2102241.42925325 | 37.7518503834746 | -122.473176432428 | (37.7518503834746, -122.473176432428) | 1 | 8 | 4 | 29491 | 12 | ||
67615 | 69146 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2479 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33181 | 5983616.53937475 | 2098288.7238606 | 37.7405529339472 | -122.499250248288 | (37.7405529339472, -122.499250248288) | 1 | 8 | 3 | 29491 | 35 | ||
23688 | 68883 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 59 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32855 | 6013060.20442694 | 2090777.05783105 | 37.721610806199 | -122.396918198144 | (37.721610806199, -122.396918198144) | 10 | 3 | 8 | 58 | 1 | ||
93886 | 68599 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.473171429533 | (37.7517787113613, -122.473171429533) | 1 | 8 | 4 | 29491 | 12 | ||
41684 | 68560 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32450 | 5981950.36786377 | 2112213.67297772 | 37.7786889858471 | -122.506043321809 | (37.7786889858471, -122.506043321809) | 11 | 6 | 2 | 55 | 26 | ||
162238 | 68548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.7783322447781 | -122.504940366327 | (37.7783322447781, -122.504940366327) | 11 | 6 | 2 | 55 | 26 | ||
68189 | 68517 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32397 | 5993053.91795071 | 2101210.30087773 | 37.7491239746497 | -122.466832052807 | (37.7491239746497, -122.466832052807) | 1 | 8 | 4 | 29491 | 12 | ||
178201 | 68496 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1822 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32372 | 5993466.35859208 | 2103074.11595722 | 37.7542653280544 | -122.465541223192 | (37.7542653280544, -122.465541223192) | 1 | 8 | 4 | 56 | 12 | ||
12226 | 68412 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | 9 | 8 | 4 | 59 | 40 | ||
160336 | 68399 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | 9 | 8 | 4 | 59 | 40 | ||
59370 | 68249 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | 13 | 9 | 1 | 57 | 17 | ||
34181 | 68180 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 75 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31952 | 5996329.36645327 | 2111693.70801186 | 37.7780972208044 | -122.456263479509 | (37.7780972208044, -122.456263479509) | 11 | 6 | 2 | 54 | 16 | ||
100897 | 68054 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1881 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31791 | 5993737.20481548 | 2102706.11474697 | 37.7532705090115 | -122.46457785688 | (37.7532705090115, -122.46457785688) | 1 | 8 | 4 | 56 | 12 | ||
115816 | 67467 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4078 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 30982 | 6003350.50488606 | 2101289.69360575 | 37.7499308522406 | -122.431232018452 | (37.7499308522406, -122.431232018452) | 2 | 4 | 5 | 28862 | 22 | ||
173394 | 64645 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856 | 37.7288421898975 | -122.460097287553 | (37.7288421898975, -122.460097287553) | 9 | 7 | 4 | 28861 | 40 | ||
155194 | 55092 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 535 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779353 | 5990916.44075 | 2111744.45268 | 37.7779243407011 | -122.474992253786 | (37.7779243407011, -122.474992253786) | 11 | 6 | 2 | 54 | 26 | ||
14145 | 52527 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.36388 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) | 9 | 7 | 6 | 28861 | 25 |
107910 | 51637 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 189 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47927 | 5996660.05636895 | 2089154.42395132 | 37.7162289049692 | -122.453491707846 | (37.7162289049692, -122.453491707846) | 9 | 8 | 6 | 28861 | 24 | |||
32857 | 47691 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2858 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45490 | 6001036.99468682 | 2116264.16139907 | 37.7909156246348 | -122.440305990836 | (37.7909156246348, -122.440305990836) | 13 | 6 | 1 | 29490 | 27 | ||
10411 | 47385 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45301 | 6001377.58877778 | 2100188.59270033 | 37.7467954887327 | -122.437975585037 | (37.7467954887327, -122.437975585037) | 2 | 4 | 5 | 63 | 22 | |||
29470 | 45414 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 845 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.463227804134 | (37.7226703098261, -122.463227804134) | 9 | 8 | 4 | 59 | 40 | ||
120572 | 45413 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 845 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.463227804134 | (37.7226703098261, -122.463227804134) | 9 | 8 | 4 | 59 | 40 | ||
79954 | 44818 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2745 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986255.58 | 2105005.7872 | 37.7591506369625 | -122.490619673159 | (37.7591506369625, -122.490619673159) | 1 | 8 | 3 | 56 | 35 | |
71470 | 44817 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2745 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986315.8836 | 2105009.2662 | 37.7591637116246 | -122.490411373273 | (37.7591637116246, -122.490411373273) | 1 | 8 | 3 | 56 | 35 | |
59456 | 44816 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2745 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986280.5132 | 2105006.9468 | 37.7591552772781 | -122.490533528729 | (37.7591552772781, -122.490533528729) | 1 | 8 | 3 | 56 | 35 | |
88126 | 43999 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 158 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43556 | 6009020.46100461 | 2099081.71622052 | 37.7441879209123 | -122.411468983209 | (37.7441879209123, -122.411468983209) | 2 | 7 | 7 | 28859 | 2 | |||
3049 | 43998 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43555 | 6008950.71046834 | 2099077.83692872 | 37.7441733566649 | -122.411709892219 | (37.7441733566649, -122.411709892219) | 2 | 7 | 7 | 28859 | 2 | |||
86212 | 43997 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43554 | 6008915.83516029 | 2099075.89728061 | 37.7441660743482 | -122.411830346827 | (37.7441660743482, -122.411830346827) | 2 | 7 | 7 | 28859 | 2 | |||
116835 | 43746 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 253 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | 9 | 8 | 6 | 28861 | 24 | ||
82374 | 43745 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 253 Summit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | 9 | 8 | 6 | 28861 | 24 | ||
169593 | 43744 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
147242 | 43743 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
162751 | 43695 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 754 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43339 | 5993219.60495236 | 2110339.98425191 | 37.7742012556984 | -122.466922735732 | (37.7742012556984, -122.466922735732) | 11 | 6 | 2 | 54 | 11 | ||
64036 | 43694 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 750 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43338 | 5993218.66242977 | 2110366.15850001 | 37.7742730687673 | -122.46692789928 | (37.7742730687673, -122.46692789928) | 11 | 6 | 2 | 54 | 11 | ||
132556 | 43498 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43178 | 6008355.55350511 | 2095881.30836855 | 37.7353629859312 | -122.413541790025 | (37.7353629859312, -122.413541790025) | 10 | 7 | 7 | 28859 | 2 | ||
134688 | 43251 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 270 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43039 | 6009534.75313896 | 2093131.57732831 | 37.727878953409 | -122.409270860276 | (37.727878953409, -122.409270860276) | 10 | 3 | 7 | 309 | 28 | ||
148461 | 43110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.7861399408742 | -122.411445668311 | (37.7861399408742, -122.411445668311) | 5 | 10 | 9 | 28852 | 36 | ||
114140 | 43109 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2004 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.7861399408742 | -122.411445668311 | (37.7861399408742, -122.411445668311) | 5 | 10 | 9 | 28852 | 36 | ||
150403 | 43108 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
176908 | 43107 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
128913 | 43106 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
69645 | 43105 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2004 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
110316 | 42870 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2554 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 5 | Permit Number 42793 | 5986474.4308 | 2097869.1881 | 37.73956824618 | -122.489338060188 | (37.73956824618, -122.489338060188) | 1 | 8 | 3 | 29491 | 35 | |
138527 | 42740 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 188 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42736 | 6012851.94955825 | 2087048.25997051 | 37.7113606761586 | -122.397376721388 | (37.7113606761586, -122.397376721388) | 10 | 3 | 8 | 309 | 1 | ||
190993 | 42556 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
28494 | 42555 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
143304 | 42554 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
75263 | 42277 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1718 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 7 | Permit Number 42514 | 5986906.0637 | 2103542.512 | 37.7551708577637 | -122.488262487214 | (37.7551708577637, -122.488262487214) | 1 | 8 | 3 | 56 | 35 | |
75146 | 42256 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1451 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42500 | 6014382.14951701 | 2101979.25998884 | 37.7524432441755 | -122.39313199334 | (37.7524432441755, -122.39313199334) | 10 | 3 | 8 | 28856 | 1 | |||
77362 | 42163 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4630 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42458 | 5989047.18920071 | 2109907.45432155 | 37.7727719459225 | -122.481324019174 | (37.7727719459225, -122.481324019174) | 11 | 6 | 2 | 55 | 26 | ||
129953 | 42147 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 490 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42443 | 5990026.73861506 | 2112033.51240967 | 37.7786664170583 | -122.478091152159 | (37.7786664170583, -122.478091152159) | 11 | 6 | 2 | 55 | 26 | |||
94534 | 42120 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 630 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/2002 12:00:00 AM | Permit Number 42417 | 5997254.13334531 | 2095296.10071131 | 37.7331265386983 | -122.451881123727 | (37.7331265386983, -122.451881123727) | 9 | 7 | 4 | 59 | 40 | ||
64456 | 42029 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42351 | 5994340.62872168 | 2093722.8989966 | 37.728639607369 | -122.461839780515 | (37.728639607369, -122.461839780515) | 9 | 8 | 4 | 59 | 40 | ||
23544 | 42023 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 110 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42346 | 5993552.23919225 | 2093678.6131862 | 37.7284725917152 | -122.464562053467 | (37.7284725917152, -122.464562053467) | 9 | 8 | 4 | 59 | 40 | ||
151050 | 42013 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 39 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42341 | 5993258.45652191 | 2093300.0310097 | 37.7274161576674 | -122.465550175008 | (37.7274161576674, -122.465550175008) | 9 | 8 | 4 | 59 | 40 | ||
36266 | 41842 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1459 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42231 | 5992090.13126179 | 2105515.92983571 | 37.7608904365533 | -122.470478344247 | (37.7608904365533, -122.470478344247) | 1 | 8 | 4 | 56 | 12 | ||
116814 | 41829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1406 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42215 | 5991820.03879919 | 2105845.80564429 | 37.7617805674142 | -122.471436503306 | (37.7617805674142, -122.471436503306) | 1 | 8 | 4 | 56 | 12 | ||
172957 | 40642 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 185 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41640 | 6009192.03574967 | 2099143.33903301 | 37.7443667457738 | -122.410880064189 | (37.7443667457738, -122.410880064189) | 2 | 7 | 7 | 28859 | 2 | |||
89415 | 40641 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41639 | 6009210.87994007 | 2099144.38708889 | 37.7443706801351 | -122.410814978675 | (37.7443706801351, -122.410814978675) | 2 | 7 | 7 | 28859 | 2 | |||
190933 | 40610 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1234 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 5 | Permit Number 41621 | 5983375.0645 | 2106732.8195 | 37.7637239007009 | -122.500709422357 | (37.7637239007009, -122.500709422357) | 1 | 8 | 3 | 56 | 35 | ||
157890 | 40555 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 215 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41596 | 5992664.70806244 | 2095313.38893204 | 37.7329100758329 | -122.467749114045 | (37.7329100758329, -122.467749114045) | 9 | 8 | 4 | 59 | 40 | ||
20587 | 40463 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 378 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41548 | 6007684.60346868 | 2097335.44684482 | 37.7393180333935 | -122.415964462581 | (37.7393180333935, -122.415964462581) | 2 | 7 | 7 | 28859 | 2 | ||
193933 | 40300 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | |||
152141 | 40299 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | ||
129093 | 40069 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1410 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | 10 | 3 | 8 | 58 | 1 | ||
146130 | 40068 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1410 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | 10 | 3 | 8 | 58 | 1 | ||
67064 | 40067 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1400 Thomas Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.387554479201 | (37.7283836150635, -122.387554479201) | 10 | 3 | 8 | 58 | 1 | ||
115401 | 40066 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1400 Thomas Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.387554479201 | (37.7283836150635, -122.387554479201) | 10 | 3 | 8 | 58 | 1 | ||
147085 | 40061 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
151562 | 40060 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
4468 | 40059 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
47665 | 40058 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
72685 | 40051 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1439 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41287 | 6015928.43712332 | 2093739.41771764 | 37.729904100557 | -122.387209925263 | (37.729904100557, -122.387209925263) | 10 | 3 | 8 | 58 | 1 | ||
36083 | 40050 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1439 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41287 | 6015928.43712332 | 2093739.41771764 | 37.729904100557 | -122.387209925263 | (37.729904100557, -122.387209925263) | 10 | 3 | 8 | 58 | 1 | ||
182131 | 40049 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1435 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41286 | 6015948.92421606 | 2093724.14562026 | 37.7298633009427 | -122.38713803352 | (37.7298633009427, -122.38713803352) | 10 | 3 | 8 | 58 | 1 | ||
119829 | 40038 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
49935 | 40037 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
85527 | 40036 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
90253 | 40035 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
149710 | 40034 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
47019 | 39910 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
150087 | 39909 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2001 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | ||
77186 | 39908 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
86961 | 39907 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
89820 | 39905 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
74322 | 39707 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 738 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41092 | 5997200.32170515 | 2095026.51323817 | 37.7323832338006 | -122.452047720375 | (37.7323832338006, -122.452047720375) | 9 | 7 | 4 | 59 | 40 |
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) );