trees
979 rows where qSpecies_id = 13 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5226 | 259803 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
12808 | 254368 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 590X Orizaba Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
15038 | 259861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
15229 | 259804 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
19358 | 259860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
30764 | 97025 | Property Tree 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
83365 | 6755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/2017 06:41:00 AM | 3 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
52659 | 6741 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:50:00 PM | 3 | 3x3 | 6016924.03316 | 2097256.88159 | 37.7396174392826 | -122.384012840031 | (37.7396174392826, -122.384012840031) | 10 | 3 | 8 | 58 | 1 | ||
147550 | 113269 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1328 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774425 | 6016744.9 | 2093624.7 | 37.7296342890732 | -122.384379303046 | (37.7296342890732, -122.384379303046) | 10 | 3 | 8 | 58 | 1 | |||
39534 | 8225 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:37:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
163849 | 8230 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:33:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
183758 | 8223 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:24:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
154786 | 248942 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:56:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
191282 | 248924 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Cashmere St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/29/2017 10:39:00 AM | 3 | 3x3 | 6016272 | 2096170 | 37.7365970133228 | -122.386191558691 | (37.7365970133228, -122.386191558691) | 10 | 3 | 8 | 58 | 1 | |
895 | 56729 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | 10 | 3 | 8 | 58 | 1 | ||
137832 | 113270 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1570 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 773602 | 6015432.5 | 2094545.1 | 37.7320888656597 | -122.388980682272 | (37.7320888656597, -122.388980682272) | 10 | 3 | 8 | 58 | 1 | |||
32359 | 193327 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1398 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015585.42977 | 2102602.25227 | 37.7542206208044 | -122.389014307158 | (37.7542206208044, -122.389014307158) | 10 | 3 | 8 | 28856 | 29 | |||
101891 | 193323 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1189 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015597.77316 | 2103545.22894 | 37.7568105190107 | -122.389037454833 | (37.7568105190107, -122.389037454833) | 10 | 3 | 8 | 28856 | 29 | |||
116145 | 110653 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1189 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2015 12:00:00 AM | 3 | 3x4 | 6015597.65588 | 2103555.71384 | 37.7568393018153 | -122.389038592471 | (37.7568393018153, -122.389038592471) | 10 | 3 | 8 | 28856 | 29 | ||
171459 | 193328 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015574.56777 | 2102562.74505 | 37.7541115402303 | -122.389049112743 | (37.7541115402303, -122.389049112743) | 10 | 3 | 8 | 28856 | 29 | |||
190103 | 116923 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015559.42731 | 2102560.48486 | 37.7541044949445 | -122.389101314797 | (37.7541044949445, -122.389101314797) | 10 | 3 | 8 | 28856 | 29 | ||
33479 | 116924 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015542.44799 | 2102559.60008 | 37.7541011242826 | -122.389159972153 | (37.7541011242826, -122.389159972153) | 10 | 3 | 8 | 28856 | 29 | ||
74463 | 116925 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015524.58204 | 2102559.09611 | 37.7540987500629 | -122.389221722302 | (37.7540987500629, -122.389221722302) | 10 | 3 | 8 | 28856 | 29 | ||
127182 | 116926 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015510.15678 | 2102558.19189 | 37.7540954675573 | -122.389271545654 | (37.7540954675573, -122.389271545654) | 10 | 3 | 8 | 28856 | 29 | ||
34828 | 116927 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015494.24319 | 2102557.91546 | 37.7540938262957 | -122.389326559889 | (37.7540938262957, -122.389326559889) | 10 | 3 | 8 | 28856 | 29 | ||
171907 | 59600 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1116 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 9 | Permit Number 19001 | 6015518.08801 | 2103793.04215 | 37.757486543884 | -122.389330342431 | (37.757486543884, -122.389330342431) | 10 | 3 | 8 | 28856 | 29 | ||
134984 | 116928 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015476.82973 | 2102557.66932 | 37.7540921850224 | -122.389386763196 | (37.7540921850224, -122.389386763196) | 10 | 3 | 8 | 28856 | 29 | ||
66389 | 116929 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015461.93425 | 2102556.84012 | 37.7540890823654 | -122.389438217924 | (37.7540890823654, -122.389438217924) | 10 | 3 | 8 | 28856 | 29 | ||
155964 | 59614 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1014 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767137 | 6015492.62077 | 2104343.80938 | 37.7589974211239 | -122.389456881532 | (37.7589974211239, -122.389456881532) | 10 | 3 | 8 | 28856 | 29 | |
55068 | 116930 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015446.80292 | 2102557.08015 | 37.7540889024884 | -122.389490562948 | (37.7540889024884, -122.389490562948) | 10 | 3 | 8 | 28856 | 29 | ||
80977 | 116931 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015431.47773 | 2102556.19381 | 37.7540856190657 | -122.389543499733 | (37.7540856190657, -122.389543499733) | 10 | 3 | 8 | 28856 | 29 | ||
63967 | 116932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015412.75293 | 2102554.60022 | 37.7540802051572 | -122.389608143898 | (37.7540802051572, -122.389608143898) | 10 | 3 | 8 | 28856 | 29 | ||
48719 | 116933 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1275 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015369.14789 | 2102590.92817 | 37.7541775360745 | -122.389761479208 | (37.7541775360745, -122.389761479208) | 10 | 3 | 8 | 28856 | 29 | ||
87088 | 116934 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1275 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015367.98495 | 2102613.01131 | 37.7542381072096 | -122.38976704332 | (37.7542381072096, -122.38976704332) | 10 | 3 | 8 | 28856 | 29 | ||
18550 | 116935 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1275 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015368.35588 | 2102637.50716 | 37.7543053881926 | -122.389767471397 | (37.7543053881926, -122.389767471397) | 10 | 3 | 8 | 28856 | 29 | ||
2501 | 78191 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 680 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6015407.71241 | 2105894.14692 | 37.7632496064147 | -122.389858829046 | (37.7632496064147, -122.389858829046) | 14 | 3 | 8 | 28856 | 29 | |||
9598 | 99292 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
124348 | 99290 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
124691 | 99293 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
142962 | 99294 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
193973 | 99291 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
186106 | 193340 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1280 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015310.01646 | 2102516.50346 | 37.7539699023888 | -122.38996077348 | (37.7539699023888, -122.38996077348) | 10 | 3 | 8 | 28856 | 29 | |||
166544 | 193339 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1278 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015309.7122 | 2102531.15535 | 37.7540101165005 | -122.389962849121 | (37.7540101165005, -122.389962849121) | 10 | 3 | 8 | 28856 | 29 | |||
113479 | 193338 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1270 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015308.81376 | 2102546.11793 | 37.754051150748 | -122.389967001302 | (37.754051150748, -122.389967001302) | 10 | 3 | 8 | 28856 | 29 | |||
25069 | 193337 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1270 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015308.47907 | 2102559.27559 | 37.7540872603324 | -122.389969077812 | (37.7540872603324, -122.389969077812) | 10 | 3 | 8 | 28856 | 29 | |||
41578 | 193336 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1270 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015307.25652 | 2102573.04925 | 37.7541250120819 | -122.389974267815 | (37.7541250120819, -122.389974267815) | 10 | 3 | 8 | 28856 | 29 | |||
178999 | 193335 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1260 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015305.18557 | 2102619.11987 | 37.7542513973846 | -122.389984647787 | (37.7542513973846, -122.389984647787) | 10 | 3 | 8 | 28856 | 29 | |||
131140 | 193334 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015304.94166 | 2102636.75923 | 37.7542998178001 | -122.38998672342 | (37.7542998178001, -122.38998672342) | 10 | 3 | 8 | 28856 | 29 | |||
26858 | 193333 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015305.27356 | 2102653.19148 | 37.7543449556813 | -122.389986723422 | (37.7543449556813, -122.389986723422) | 10 | 3 | 8 | 28856 | 29 | |||
181497 | 193332 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015304.05705 | 2102667.26372 | 37.7543835276007 | -122.38999191342 | (37.7543835276007, -122.38999191342) | 10 | 3 | 8 | 28856 | 29 | |||
32889 | 193331 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015302.57075 | 2102682.83592 | 37.754426203129 | -122.38999814121 | (37.754426203129, -122.38999814121) | 10 | 3 | 8 | 28856 | 29 | |||
122527 | 193330 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1258 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015302.53629 | 2102695.98751 | 37.7544623126945 | -122.389999179039 | (37.7544623126945, -122.389999179039) | 10 | 3 | 8 | 28856 | 29 | |||
174684 | 193329 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1240 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015301.01703 | 2102739.65572 | 37.7545821320765 | -122.390007483381 | (37.7545821320765, -122.390007483381) | 10 | 3 | 8 | 28856 | 29 | |||
192930 | 193352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1707 McKinnon Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014777.57623 | 2096343.32459 | 37.736990099615 | -122.391370577692 | (37.736990099615, -122.391370577692) | 10 | 3 | 8 | 58 | 1 | |||
20416 | 17382 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | 10 | 3 | 8 | 58 | 1 | |
9218 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 188 The Embarcadero | 1 | Front Yard : Yard | Tree | Private 2 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | 12 | 2 | 9 | 28855 | 6 | |||
117325 | 30768 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.7278377210513 | -122.391915390574 | (37.7278377210513, -122.391915390574) | 10 | 3 | 8 | 58 | 1 | |
12863 | 154063 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1781 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014599.10763 | 2096821.84485 | 37.7382941111836 | -122.392021081628 | (37.7382941111836, -122.392021081628) | 10 | 3 | 8 | 58 | 1 |
152301 | 193350 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1752 Quesada Ave | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6014471.5284 | 2095248.21375 | 37.7339661589078 | -122.392352158028 | (37.7339661589078, -122.392352158028) | 10 | 3 | 8 | 58 | 1 | |||
107537 | 193351 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1752 Quesada Ave | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6014452.02014 | 2095263.45344 | 37.7340069206852 | -122.392420670182 | (37.7340069206852, -122.392420670182) | 10 | 3 | 8 | 58 | 1 | |||
24379 | 84492 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1726 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50144 | 6014424.88297 | 2094914.9156 | 37.733048399857 | -122.392490121246 | (37.733048399857, -122.392490121246) | 10 | 3 | 8 | 58 | 1 | |
151472 | 193354 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 75 Latona St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6014363.50892 | 2094164.90475 | 37.7309856140862 | -122.392649861509 | (37.7309856140862, -122.392649861509) | 10 | 3 | 8 | 58 | 1 | |||
54957 | 193353 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 75 Latona St | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6014356.71381 | 2094130.91489 | 37.7308919074363 | -122.392670976684 | (37.7308919074363, -122.392670976684) | 10 | 3 | 8 | 58 | 1 | |||
45035 | 88479 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1751 Newcomb Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51431 | 6014386 | 2096253.8 | 37.7367225430205 | -122.392718181551 | (37.7367225430205, -122.392718181551) | 10 | 3 | 8 | 58 | 1 | ||
150561 | 150166 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 0 | Width 3ft | 6014482.7986 | 2105256.28423 | 37.7614468389081 | -122.393013193016 | (37.7614468389081, -122.393013193016) | 10 | 3 | 8 | 28856 | 29 | ||
22156 | 150165 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 3 | Width 3ft | 6014460.64342 | 2105255.76526 | 37.7614441832169 | -122.39308978288 | (37.7614441832169, -122.39308978288) | 10 | 3 | 8 | 28856 | 29 | ||
79462 | 150164 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 3 | Width 3ft | 6014439.46295 | 2105255.42016 | 37.7614420590332 | -122.393163013761 | (37.7614420590332, -122.393163013761) | 10 | 3 | 8 | 28856 | 29 | ||
131049 | 150163 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 0 | Width 3ft | 6014400.34034 | 2105251.569 | 37.7614293111323 | -122.393298054181 | (37.7614293111323, -122.393298054181) | 10 | 3 | 8 | 28856 | 29 | ||
123198 | 61691 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 61 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 4 | Permit Number 31258 | 6014147.06906 | 2093799.26826 | 37.7299696274983 | -122.393372558494 | (37.7299696274983, -122.393372558494) | 10 | 3 | 8 | 58 | 1 | |
30093 | 98453 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768642 | 6014340.87186 | 2104676.45619 | 37.7598468721503 | -122.393463482668 | (37.7598468721503, -122.393463482668) | 10 | 3 | 8 | 28856 | 29 | |
59269 | 193346 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1133 19th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6014187.49963 | 2105244.21667 | 37.761397296172 | -122.394033672633 | (37.761397296172, -122.394033672633) | 10 | 3 | 8 | 28856 | 29 | |||
104011 | 193345 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1133 19th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6014171.26133 | 2105242.63423 | 37.7613920486234 | -122.394089723782 | (37.7613920486234, -122.394089723782) | 10 | 3 | 8 | 28856 | 29 | |||
172647 | 193344 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1133 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6014141.435 | 2105240.82312 | 37.7613854179142 | -122.394192754591 | (37.7613854179142, -122.394192754591) | 10 | 3 | 8 | 28856 | 29 | |||
102407 | 193347 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 444 Mississippi St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6014042.11061 | 2105043.11718 | 37.7608370392312 | -122.394522434371 | (37.7608370392312, -122.394522434371) | 10 | 3 | 8 | 28856 | 29 | |||
81489 | 45681 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 440 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2001 12:00:00 AM | 8 | Permit Number 44368 | 6014041.20893 | 2105068.96138 | 37.7609079516478 | -122.394527362641 | (37.7609079516478, -122.394527362641) | 10 | 3 | 8 | 28856 | 29 | ||
40064 | 84782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 228 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | 5 | Permit No. 49243 | 6013990.15625 | 2105982.37522 | 37.7634131481085 | -122.394767902514 | (37.7634131481085, -122.394767902514) | 14 | 3 | 8 | 28856 | 29 | ||
48899 | 84780 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 224 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | 4 | Permit No. 49287 | 6013987.25375 | 2106041.39506 | 37.7635750422708 | -122.394782074949 | (37.7635750422708, -122.394782074949) | 14 | 3 | 8 | 28856 | 29 | ||
119003 | 84779 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 224 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | 3 | Permit No. 49287 | 6013986.61648 | 2106050.38487 | 37.7635996908854 | -122.394784908699 | (37.7635996908854, -122.394784908699) | 14 | 3 | 8 | 28856 | 29 | ||
154921 | 193359 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 208 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014052.91282 | 2116289.57894 | 37.7917178877279 | -122.395272915033 | (37.7917178877279, -122.395272915033) | 12 | 2 | 9 | 28855 | 6 | |||
183737 | 193360 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 208 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014042.14131 | 2116274.34783 | 37.7916754675957 | -122.395309117238 | (37.7916754675957, -122.395309117238) | 12 | 2 | 9 | 28855 | 6 | |||
71219 | 193342 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 401 Texas St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013812.69862 | 2105193.07398 | 37.7612360315304 | -122.395326379719 | (37.7612360315304, -122.395326379719) | 10 | 3 | 8 | 28856 | 29 | |||
134523 | 193361 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014025.95999 | 2116259.22664 | 37.7916330483898 | -122.395364045136 | (37.7916330483898, -122.395364045136) | 12 | 2 | 9 | 28855 | 6 | |||
170760 | 193358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 62 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014021.3474 | 2116423.46881 | 37.7920837625026 | -122.395391515812 | (37.7920837625026, -122.395391515812) | 12 | 2 | 9 | 28855 | 6 | |||
95844 | 193362 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014011.61838 | 2116245.86436 | 37.7915955610366 | -122.395412730824 | (37.7915955610366, -122.395412730824) | 12 | 2 | 9 | 28855 | 6 | |||
103563 | 193357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 62 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014010.13309 | 2116432.89008 | 37.7921090073852 | -122.395430978058 | (37.7921090073852, -122.395430978058) | 12 | 2 | 9 | 28855 | 6 | |||
131934 | 193363 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014000.9996 | 2116238.17517 | 37.7915738577077 | -122.395448933038 | (37.7915738577077, -122.395448933038) | 12 | 2 | 9 | 28855 | 6 | |||
147690 | 193356 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 60 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014000.33626 | 2116445.25726 | 37.7921424198756 | -122.395465742269 | (37.7921424198756, -122.395465742269) | 12 | 2 | 9 | 28855 | 6 | |||
145435 | 193364 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013990.63933 | 2116225.45086 | 37.7915383434816 | -122.395483887876 | (37.7915383434816, -122.395483887876) | 12 | 2 | 9 | 28855 | 6 | |||
67172 | 193355 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 60 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013990.6766 | 2116456.52969 | 37.7921728340575 | -122.395499955167 | (37.7921728340575, -122.395499955167) | 12 | 2 | 9 | 28855 | 6 | |||
115148 | 193365 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6013979.60171 | 2116214.89575 | 37.7915087476865 | -122.395521338359 | (37.7915087476865, -122.395521338359) | 12 | 2 | 9 | 28855 | 6 | |||
132863 | 193366 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013970.03568 | 2116205.74836 | 37.7914830990039 | -122.395553795767 | (37.7914830990039, -122.395553795767) | 12 | 2 | 9 | 28855 | 6 | |||
187279 | 193367 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013957.97413 | 2116198.08841 | 37.7914613956649 | -122.395594991931 | (37.7914613956649, -122.395594991931) | 12 | 2 | 9 | 28855 | 6 | |||
90120 | 193368 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013947.27528 | 2116186.44855 | 37.7914288402078 | -122.395631194149 | (37.7914288402078, -122.395631194149) | 12 | 2 | 9 | 28855 | 6 | |||
147236 | 193369 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013943.1918 | 2116180.78279 | 37.7914130562087 | -122.395644925876 | (37.7914130562087, -122.395644925876) | 12 | 2 | 9 | 28855 | 6 | |||
146551 | 193370 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013935.48002 | 2116174.11264 | 37.7913943125596 | -122.39567114113 | (37.7913943125596, -122.39567114113) | 12 | 2 | 9 | 28855 | 6 | |||
90501 | 193371 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 264 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013926.24547 | 2116163.52102 | 37.791364716756 | -122.395702350277 | (37.791364716756, -122.395702350277) | 12 | 2 | 9 | 28855 | 6 | |||
104923 | 33800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013865.37275 | 2116161.97621 | 37.7913570887062 | -122.395912861799 | (37.7913570887062, -122.395912861799) | 12 | 2 | 9 | 28855 | 6 | |
134517 | 33792 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013856.54517 | 2116173.60161 | 37.7913885182281 | -122.395944220262 | (37.7913885182281, -122.395944220262) | 12 | 2 | 9 | 28855 | 6 | |
97909 | 33782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013852.02109 | 2116179.41654 | 37.7914042329729 | -122.395960281264 | (37.7914042329729, -122.395960281264) | 12 | 2 | 9 | 28855 | 6 |
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) );