trees
963 rows where qCaretaker_id = 2 and qSpecies_id = 53 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28234 | 109001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
65899 | 109000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 circle | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | |||
130690 | 109005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
140999 | 109004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
141541 | 109003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
184960 | 109002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
142433 | 486 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2708 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010515.41751 | 2102258.44338 | 37.7529942564805 | -122.406523532023 | (37.7529942564805, -122.406523532023) | 10 | 4 | 7 | 28859 | 19 | |||
23368 | 512 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.408007140426 | (37.7529955768562, -122.408007140426) | 2 | 4 | 7 | 28859 | 19 | |||
64711 | 488 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
16900 | 485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010468.2249 | 2102315.41281 | 37.7531480416193 | -122.406690748371 | (37.7531480416193, -122.406690748371) | 10 | 4 | 7 | 28859 | 19 | |||
61113 | 57802 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.7532392091702 | -122.440756591601 | (37.7532392091702, -122.440756591601) | 2 | 4 | 5 | 28862 | 22 | |
117076 | 102235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
90722 | 56236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 147 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | 24 | Permit Number 12362 | 6006719.97734959 | 2102927.77810186 | 37.7546190293471 | -122.419696406291 | (37.7546190293471, -122.419696406291) | 2 | 4 | 7 | 28859 | 19 | ||
165793 | 39111 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 145 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | 20 | Permit Number 40799 | 6006719.36046982 | 2102938.94159671 | 37.7546496469874 | -122.41969933167 | (37.7546496469874, -122.41969933167) | 2 | 4 | 7 | 28859 | 19 | |
66076 | 112051 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3748x 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003448 | 2103060 | 37.7547972209553 | -122.431021210073 | (37.7547972209553, -122.431021210073) | 2 | 4 | 5 | 28862 | 22 | |||
99827 | 109850 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3250x 22ND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
155548 | 115216 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 3x3 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | ||
4294 | 117126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
113469 | 117124 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
188536 | 117125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | ||||
62161 | 109596 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3332 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6006085.3 | 2103802.1 | 37.7569839418566 | -122.421953398845 | (37.7569839418566, -122.421953398845) | 2 | 4 | 5 | 28859 | 19 | |||
32408 | 54027 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778679 | 6004696.3346429 | 2103995.33974478 | 37.7574361004301 | -122.426770728763 | (37.7574361004301, -122.426770728763) | 2 | 4 | 5 | 28862 | 3 | |
106094 | 117567 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2498 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6008843 | 2103923 | 37.7574710478396 | -122.41242474225 | (37.7574710478396, -122.41242474225) | 2 | 4 | 7 | 28859 | 19 | |||
118796 | 65046 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2498 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1989 12:00:00 AM | 18 | Permit Number 26099 | 6008837.93100399 | 2103923.47328543 | 37.7574720629103 | -122.412442306383 | (37.7574720629103, -122.412442306383) | 2 | 4 | 7 | 28859 | 19 | ||
139295 | 59013 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3755 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1980 12:00:00 AM | 20 | Permit Number 18304 | 6005291.98683548 | 2104267.80164023 | 37.7582178764875 | -122.424730106513 | (37.7582178764875, -122.424730106513) | 2 | 4 | 5 | 28859 | 19 | ||
63978 | 119667 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 699x Missouri St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
60853 | 97999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
85172 | 98001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
171840 | 69122 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3744 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1994 12:00:00 AM | 22 | 5x9 | Permit Number 33140 | 6005352.36529805 | 2104323.23161765 | 37.7583734841408 | -122.424525234112 | (37.7583734841408, -122.424525234112) | 2 | 4 | 5 | 28859 | 19 | |
51092 | 109603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | ||||
97918 | 102451 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | |||
55414 | 61158 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) | 2 | 4 | 7 | 28859 | 19 |
10859 | 102456 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
64858 | 102457 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
119605 | 102455 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
133761 | 102454 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
21359 | 87146 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
111614 | 87145 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
172669 | 87144 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
100042 | 40805 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 585 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41753 | 6013296.02646982 | 2104345.28151099 | 37.758879430057 | -122.397053895785 | (37.758879430057, -122.397053895785) | 10 | 3 | 8 | 28856 | 29 | ||||
71888 | 102035 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2400 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | 6008197 | 2104472 | 37.7589422028837 | -122.414697726814 | (37.7589422028837, -122.414697726814) | 2 | 4 | 7 | 28859 | 19 | |||
139754 | 98643 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2391 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008222 | 2104509 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | 2 | 4 | 7 | 28859 | 19 | |||
111149 | 53710 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4067 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1970 12:00:00 AM | 14 | Permit Number 6657 | 6002578.30950532 | 2104703.42856113 | 37.7592603634983 | -122.434146313573 | (37.7592603634983, -122.434146313573) | 2 | 4 | 5 | 28862 | 3 | ||
189703 | 66879 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.7592879918503 | -122.439106757133 | (37.7592879918503, -122.439106757133) | 2 | 4 | 5 | 28862 | 3 | ||
20709 | 109328 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1349 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2015 12:00:00 AM | 3 | 3x3 | 5999000.5 | 2104870.1 | 37.7595142924854 | -122.446532051538 | (37.7595142924854, -122.446532051538) | 15 | 5 | 5 | 28862 | 12 | ||
138351 | 107659 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1324 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5999078.1 | 2104991.6 | 37.759852333413 | -122.446272413537 | (37.759852333413, -122.446272413537) | 15 | 5 | 5 | 28862 | 3 | |||
135877 | 109331 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1325 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
188517 | 109332 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
27436 | 107660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1316 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999083.9 | 2105040.7 | 37.7599874810533 | -122.446255886285 | (37.7599874810533, -122.446255886285) | 15 | 5 | 5 | 28862 | 3 | |||
158811 | 225015 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780170 | 6002699.82559 | 2104972.04176 | 37.7600048066089 | -122.433745251143 | (37.7600048066089, -122.433745251143) | 2 | 4 | 5 | 28862 | 3 | |
75176 | 173949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1306 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999102 | 2105133 | 37.7602419475954 | -122.446199926833 | (37.7602419475954, -122.446199926833) | 15 | 5 | 5 | 28862 | 3 | ||||
66858 | 173948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1300 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999106 | 2105162 | 37.7603218028196 | -122.446188178838 | (37.7603218028196, -122.446188178838) | 15 | 5 | 5 | 28862 | 3 | ||||
18675 | 101715 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
54784 | 101716 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
87085 | 101725 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
105989 | 101717 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
138070 | 101722 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
138887 | 101721 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
143637 | 101724 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
158929 | 101720 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
169319 | 101719 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
176915 | 101718 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
179159 | 101726 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
177096 | 51793 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 65 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2005 12:00:00 AM | Permit Number 48042 | 6005279.64463313 | 2105087.60921781 | 37.7604681781651 | -122.42483111417 | (37.7604681781651, -122.42483111417) | 2 | 4 | 5 | 28859 | 19 | |||
107245 | 58071 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4545 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1977 12:00:00 AM | 13 | Permit Number 17041 | 6000791.5456109 | 2105188.83821507 | 37.7604916091053 | -122.440360603481 | (37.7604916091053, -122.440360603481) | 2 | 4 | 5 | 28862 | 3 | ||
190159 | 225029 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4543 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 17041 | 6000793.7951 | 2105198.47261 | 37.7605181908718 | -122.440353514511 | (37.7605181908718, -122.440353514511) | 2 | 4 | 5 | 28862 | 3 | |
21841 | 111225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
56413 | 111223 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
61037 | 111219 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
110191 | 111226 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
135014 | 111218 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
142406 | 111224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
188189 | 111222 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
72782 | 58078 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4624 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1977 12:00:00 AM | Permit Number 17049 | 6000401 | 2105218 | 37.7605494356876 | -122.441713410467 | (37.7605494356876, -122.441713410467) | 15 | 4 | 5 | 28862 | 3 | |||
71942 | 50566 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
111853 | 99974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
115348 | 50571 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
173070 | 50573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
24098 | 50784 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4425@ EUREKA 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2004 12:00:00 AM | Permit Number 47310 | 6001319.3692016 | 2105218.84665198 | 37.760604043869 | -122.438537258087 | (37.760604043869, -122.438537258087) | 2 | 4 | 5 | 28862 | 3 | |||
155693 | 110274 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4624 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6000413 | 2105241 | 37.7606132717498 | -122.4416735587 | (37.7606132717498, -122.4416735587) | 15 | 4 | 5 | 28862 | 3 | |||
60410 | 111206 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
63970 | 111213 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
64312 | 111215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
173047 | 71507 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1988 12:00:00 AM | 12 | 6008781.55607863 | 2105099.68545767 | 37.7606985097306 | -122.412720425202 | (37.7606985097306, -122.412720425202) | 2 | 4 | 7 | 28859 | 19 | |||
94921 | 109333 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1317 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||
114066 | 54117 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4356 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 3x3 | Permit Number 52105 | 6001531.81835159 | 2105282.89107801 | 37.7607919769606 | -122.437807081492 | (37.7607919769606, -122.437807081492) | 15 | 4 | 5 | 28862 | 3 | ||
51694 | 173776 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 89 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001439 | 2105287 | 37.7607979807122 | -122.438128392537 | (37.7607979807122, -122.438128392537) | 15 | 4 | 5 | 28862 | 3 | ||||
140006 | 173777 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 89 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001439 | 2105287 | 37.7607979807122 | -122.438128392537 | (37.7607979807122, -122.438128392537) | 15 | 4 | 5 | 28862 | 3 | ||||
128105 | 109334 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1313 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999032 | 2105350 | 37.7608337776961 | -122.446457634643 | (37.7608337776961, -122.446457634643) | 15 | 5 | 5 | 28862 | 12 | |||
44509 | 60715 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 30 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1983 12:00:00 AM | 24 | 3x3 | Permit Number 20368 | 6005215.9296478 | 2105282.4178358 | 37.7609994776864 | -122.425065336381 | (37.7609994776864, -122.425065336381) | 2 | 4 | 5 | 28859 | 19 | |
170556 | 87134 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 65 Mars St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50103 | 5999603 | 2105413 | 37.7610393570971 | -122.444487333455 | (37.7610393570971, -122.444487333455) | 15 | 5 | 5 | 28862 | 3 | |||
173374 | 98862 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 25 OAKWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005344.6 | 2105317.5 | 37.7611030726424 | -122.424622816907 | (37.7611030726424, -122.424622816907) | 2 | 4 | 5 | 28859 | 19 | ||||
112940 | 106936 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 98X EUREKA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x5 | 6001388 | 2105433 | 37.7611959604452 | -122.438315238354 | (37.7611959604452, -122.438315238354) | 15 | 4 | 5 | 28862 | 3 | |||
8269 | 99967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
149401 | 55522 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | Permit Number 11483 | 6003594.27279224 | 2105459.16759406 | 37.7613930510814 | -122.430686551957 | (37.7613930510814, -122.430686551957) | 15 | 4 | 5 | 28862 | 3 | |||
32305 | 173934 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x9 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||||
78273 | 45427 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||
132675 | 45428 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | |||
145968 | 45426 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 |
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) );