Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 9836 | 9836 | 6755 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2017 06:41:00 AM | 3 | 3x3 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 505 | 505 | 6741 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:50:00 PM | 3 | 3x3 | 6016924.03316 | 2097256.8815900004 | 37.739617439282604 | -122.38401284003099 | (37.7396174392826, -122.384012840031) | ||
| 500 | 500 | 6742 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.500630001 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | ||
| 123675 | 123675 | 113269 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1328 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774425 | 6016744.9 | 2093624.7 | 37.7296342890732 | -122.384379303046 | (37.7296342890732, -122.384379303046) | |||
| 81549 | 81549 | 8225 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500X Galvez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:37:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 116957 | 116957 | 8230 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500X Galvez Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:33:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 143719 | 143719 | 8223 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500X Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:24:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 528 | 528 | 248942 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500x Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/18/2017 12:56:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
| 1063 | 1063 | 248924 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201x Cashmere St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/29/2017 10:39:00 AM | 3 | 3x3 | 6016272.0 | 2096170.0 | 37.7365970133228 | -122.38619155869101 | (37.7365970133228, -122.386191558691) | |
| 135931 | 135931 | 193323 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1189 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015597.773159999 | 2103545.2289400003 | 37.7568105190107 | -122.38903745483299 | (37.7568105190107, -122.389037454833) | |||
| 13472 | 13472 | 110653 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1189 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2015 12:00:00 AM | 3 | 3x4 | 6015597.65588 | 2103555.7138400003 | 37.7568393018153 | -122.38903859247101 | (37.7568393018153, -122.389038592471) | ||
| 167402 | 167402 | 193327 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1398 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015585.429769999 | 2102602.25227 | 37.7542206208044 | -122.38901430715799 | (37.7542206208044, -122.389014307158) | |||
| 48794 | 48794 | 193328 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6015574.56777 | 2102562.74505 | 37.7541115402303 | -122.389049112743 | (37.7541115402303, -122.389049112743) | |||
| 15260 | 15260 | 116923 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015559.42731 | 2102560.4848599997 | 37.7541044949445 | -122.389101314797 | (37.7541044949445, -122.389101314797) | ||
| 13608 | 13608 | 116924 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015542.44799 | 2102559.60008 | 37.754101124282606 | -122.389159972153 | (37.7541011242826, -122.389159972153) | ||
| 14797 | 14797 | 116925 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015524.58204 | 2102559.09611 | 37.7540987500629 | -122.389221722302 | (37.7540987500629, -122.389221722302) | ||
| 52442 | 52442 | 59600 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1116 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 9 | Permit Number 19001 | 6015518.08801 | 2103793.04215 | 37.757486543884 | -122.389330342431 | (37.757486543884, -122.389330342431) | ||
| 14030 | 14030 | 116926 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015510.15678 | 2102558.1918900004 | 37.7540954675573 | -122.389271545654 | (37.7540954675573, -122.389271545654) | ||
| 16727 | 16727 | 116927 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015494.24319 | 2102557.91546 | 37.7540938262957 | -122.38932655988899 | (37.7540938262957, -122.389326559889) | ||
| 14678 | 14678 | 59614 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1014 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767137 | 6015492.62077 | 2104343.80938 | 37.7589974211239 | -122.389456881532 | (37.7589974211239, -122.389456881532) | |
| 16512 | 16512 | 116928 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015476.82973 | 2102557.66932 | 37.754092185022394 | -122.38938676319599 | (37.7540921850224, -122.389386763196) | ||
| 16892 | 16892 | 116929 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015461.93425 | 2102556.8401200003 | 37.7540890823654 | -122.38943821792401 | (37.7540890823654, -122.389438217924) | ||
| 14067 | 14067 | 116930 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015446.80292 | 2102557.08015 | 37.7540889024884 | -122.389490562948 | (37.7540889024884, -122.389490562948) | ||
| 123276 | 123276 | 113270 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1570 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 773602 | 6015432.5 | 2094545.1 | 37.732088865659705 | -122.38898068227199 | (37.7320888656597, -122.388980682272) | |||
| 16017 | 16017 | 116931 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015431.47773 | 2102556.1938099996 | 37.754085619065705 | -122.38954349973301 | (37.7540856190657, -122.389543499733) | ||
| 16611 | 16611 | 116932 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015412.75293 | 2102554.60022 | 37.7540802051572 | -122.38960814389799 | (37.7540802051572, -122.389608143898) | ||
| 65070 | 65070 | 78191 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 680 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 1 | 6015407.71241 | 2105894.14692 | 37.7632496064147 | -122.389858829046 | (37.7632496064147, -122.389858829046) | ||
| 16552 | 16552 | 116933 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1275 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015369.147890001 | 2102590.92817 | 37.7541775360745 | -122.38976147920799 | (37.7541775360745, -122.389761479208) | ||
| 15996 | 15996 | 116935 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1275 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015368.355880001 | 2102637.50716 | 37.7543053881926 | -122.389767471397 | (37.7543053881926, -122.389767471397) | ||
| 15315 | 15315 | 116934 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1275 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015367.98495 | 2102613.01131 | 37.7542381072096 | -122.38976704331999 | (37.7542381072096, -122.38976704332) | ||
| 18361 | 18361 | 99292 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 103935 | 103935 | 99293 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 109870 | 109870 | 99290 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 110433 | 110433 | 99294 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 145185 | 145185 | 99291 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 186500 | 186500 | 193340 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1280 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015310.01646 | 2102516.50346 | 37.753969902388796 | -122.38996077348 | (37.7539699023888, -122.38996077348) | |||
| 59718 | 59718 | 193339 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1278 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015309.7122 | 2102531.15535 | 37.7540101165005 | -122.389962849121 | (37.7540101165005, -122.389962849121) | |||
| 147780 | 147780 | 193338 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1270 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015308.81376 | 2102546.1179299997 | 37.754051150748 | -122.389967001302 | (37.754051150748, -122.389967001302) | |||
| 30570 | 30570 | 193337 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1270 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015308.479069999 | 2102559.27559 | 37.7540872603324 | -122.389969077812 | (37.7540872603324, -122.389969077812) | |||
| 165822 | 165822 | 193336 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1270 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015307.256519999 | 2102573.04925 | 37.7541250120819 | -122.38997426781499 | (37.7541250120819, -122.389974267815) | |||
| 51630 | 51630 | 193333 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015305.27356 | 2102653.19148 | 37.7543449556813 | -122.389986723422 | (37.7543449556813, -122.389986723422) | |||
| 54895 | 54895 | 193335 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1260 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015305.18557 | 2102619.11987 | 37.7542513973846 | -122.389984647787 | (37.7542513973846, -122.389984647787) | |||
| 60313 | 60313 | 193334 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015304.94166 | 2102636.75923 | 37.7542998178001 | -122.38998672342 | (37.7542998178001, -122.38998672342) | |||
| 35331 | 35331 | 193332 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015304.05705 | 2102667.26372 | 37.7543835276007 | -122.38999191341999 | (37.7543835276007, -122.38999191342) | |||
| 184199 | 184199 | 193331 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015302.57075 | 2102682.83592 | 37.754426203129 | -122.38999814121 | (37.754426203129, -122.38999814121) | |||
| 137932 | 137932 | 193330 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015302.53629 | 2102695.98751 | 37.7544623126945 | -122.389999179039 | (37.7544623126945, -122.389999179039) | |||
| 161946 | 161946 | 193329 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1240 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015301.017030001 | 2102739.65572 | 37.7545821320765 | -122.390007483381 | (37.7545821320765, -122.390007483381) | |||
| 53186 | 53186 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 188 The Embarcadero | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | |||
| 61328 | 61328 | 193352 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1707 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014777.576230001 | 2096343.32459 | 37.736990099615 | -122.39137057769199 | (37.736990099615, -122.391370577692) | |||
| 23030 | 23030 | 17382 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | |
| 185939 | 185939 | 193350 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1752 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014471.5284 | 2095248.21375 | 37.7339661589078 | -122.39235215802799 | (37.7339661589078, -122.392352158028) | |||
| 174129 | 174129 | 193351 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1752 Quesada Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014452.02014 | 2095263.45344 | 37.734006920685204 | -122.392420670182 | (37.7340069206852, -122.392420670182) | |||
| 65040 | 65040 | 84492 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1726 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50144 | 6014424.88297 | 2094914.9156 | 37.733048399857005 | -122.392490121246 | (37.733048399857, -122.392490121246) | |
| 82853 | 82853 | 88479 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1751 Newcomb Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51431 | 6014386.0 | 2096253.8 | 37.7367225430205 | -122.392718181551 | (37.7367225430205, -122.392718181551) | ||
| 173077 | 173077 | 193354 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Latona St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014363.50892 | 2094164.90475 | 37.7309856140862 | -122.392649861509 | (37.7309856140862, -122.392649861509) | |||
| 181425 | 181425 | 193353 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Latona St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6014356.71381 | 2094130.9148900001 | 37.730891907436295 | -122.392670976684 | (37.7308919074363, -122.392670976684) | |||
| 45272 | 45272 | 98453 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768642 | 6014340.87186 | 2104676.4561900003 | 37.7598468721503 | -122.393463482668 | (37.7598468721503, -122.393463482668) | |
| 165491 | 165491 | 193346 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014187.49963 | 2105244.21667 | 37.761397296172 | -122.394033672633 | (37.761397296172, -122.394033672633) | |||
| 187472 | 187472 | 193345 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014171.26133 | 2105242.63423 | 37.7613920486234 | -122.394089723782 | (37.7613920486234, -122.394089723782) | |||
| 164563 | 164563 | 61691 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 61 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 4 | Permit Number 31258 | 6014147.06906 | 2093799.2682599998 | 37.7299696274983 | -122.393372558494 | (37.7299696274983, -122.393372558494) | |
| 153849 | 153849 | 193344 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014141.435 | 2105240.8231200003 | 37.761385417914205 | -122.394192754591 | (37.7613854179142, -122.394192754591) | |||
| 150941 | 150941 | 193359 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 208 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014052.912819999 | 2116289.5789400004 | 37.7917178877279 | -122.39527291503299 | (37.7917178877279, -122.395272915033) | |||
| 160153 | 160153 | 193360 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 208 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014042.14131 | 2116274.34783 | 37.7916754675957 | -122.395309117238 | (37.7916754675957, -122.395309117238) | |||
| 33199 | 33199 | 193347 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 444 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6014042.11061 | 2105043.11718 | 37.760837039231205 | -122.394522434371 | (37.7608370392312, -122.394522434371) | |||
| 34611 | 34611 | 45681 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 440 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2001 12:00:00 AM | 8 | Permit Number 44368 | 6014041.208930001 | 2105068.9613799998 | 37.760907951647795 | -122.39452736264099 | (37.7609079516478, -122.394527362641) | ||
| 127114 | 127114 | 193361 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 246 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014025.95999 | 2116259.22664 | 37.7916330483898 | -122.39536404513599 | (37.7916330483898, -122.395364045136) | |||
| 159964 | 159964 | 193358 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 62 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014021.3474 | 2116423.46881 | 37.79208376250261 | -122.395391515812 | (37.7920837625026, -122.395391515812) | |||
| 66770 | 66770 | 193362 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 246 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014011.61838 | 2116245.86436 | 37.7915955610366 | -122.39541273082399 | (37.7915955610366, -122.395412730824) | |||
| 134536 | 134536 | 193357 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 62 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014010.133090001 | 2116432.89008 | 37.7921090073852 | -122.395430978058 | (37.7921090073852, -122.395430978058) | |||
| 169527 | 169527 | 193363 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 246 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014000.9996 | 2116238.17517 | 37.791573857707704 | -122.39544893303801 | (37.7915738577077, -122.395448933038) | |||
| 57463 | 57463 | 193356 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 60 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014000.33626 | 2116445.25726 | 37.7921424198756 | -122.395465742269 | (37.7921424198756, -122.395465742269) | |||
| 39423 | 39423 | 193355 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 60 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013990.6766 | 2116456.52969 | 37.792172834057496 | -122.39549995516701 | (37.7921728340575, -122.395499955167) | |||
| 53678 | 53678 | 193364 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 260 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013990.639330001 | 2116225.4508599997 | 37.791538343481605 | -122.395483887876 | (37.7915383434816, -122.395483887876) | |||
| 66339 | 66339 | 84782 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 228 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2007 12:00:00 AM | 5 | Permit No. 49243 | 6013990.15625 | 2105982.3752200003 | 37.763413148108505 | -122.394767902514 | (37.7634131481085, -122.394767902514) | ||
| 137475 | 137475 | 84780 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 224 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | 4 | Permit No. 49287 | 6013987.25375 | 2106041.39506 | 37.7635750422708 | -122.39478207494899 | (37.7635750422708, -122.394782074949) | ||
| 49125 | 49125 | 84779 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 224 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | 3 | Permit No. 49287 | 6013986.61648 | 2106050.38487 | 37.7635996908854 | -122.394784908699 | (37.7635996908854, -122.394784908699) | ||
| 130079 | 130079 | 193365 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 260 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6013979.60171 | 2116214.89575 | 37.7915087476865 | -122.39552133835899 | (37.7915087476865, -122.395521338359) | |||
| 186109 | 186109 | 193366 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 260 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013970.035680001 | 2116205.7483599996 | 37.7914830990039 | -122.395553795767 | (37.7914830990039, -122.395553795767) | |||
| 134263 | 134263 | 193367 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 262 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013957.97413 | 2116198.08841 | 37.791461395664896 | -122.395594991931 | (37.7914613956649, -122.395594991931) | |||
| 54394 | 54394 | 193368 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 262 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013947.275280001 | 2116186.44855 | 37.79142884020779 | -122.395631194149 | (37.7914288402078, -122.395631194149) | |||
| 32841 | 32841 | 193369 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 262 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013943.1918 | 2116180.78279 | 37.791413056208704 | -122.39564492587601 | (37.7914130562087, -122.395644925876) | |||
| 133388 | 133388 | 193370 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 262 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013935.48002 | 2116174.11264 | 37.791394312559596 | -122.39567114113001 | (37.7913943125596, -122.39567114113) | |||
| 172126 | 172126 | 193371 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 264 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013926.2454699995 | 2116163.52102 | 37.791364716756 | -122.395702350277 | (37.791364716756, -122.395702350277) | |||
| 14233 | 14233 | 33800 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013865.37275 | 2116161.97621 | 37.7913570887062 | -122.39591286179899 | (37.7913570887062, -122.395912861799) | |
| 16533 | 16533 | 33792 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013856.54517 | 2116173.60161 | 37.7913885182281 | -122.395944220262 | (37.7913885182281, -122.395944220262) | |
| 16231 | 16231 | 33782 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013852.02109 | 2116179.41654 | 37.7914042329729 | -122.395960281264 | (37.7914042329729, -122.395960281264) | |
| 14247 | 14247 | 33783 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013842.9233800005 | 2116188.62598 | 37.7914290137913 | -122.395992405042 | (37.7914290137913, -122.395992405042) | |
| 16526 | 16526 | 33774 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013834.28126 | 2116198.48682 | 37.791455608540396 | -122.396022998165 | (37.7914556085404, -122.396022998165) | |
| 13895 | 13895 | 33780 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013824.14126 | 2116210.79912 | 37.7914888510795 | -122.39605894586 | (37.7914888510795, -122.39605894586) | |
| 45125 | 45125 | 193342 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 401 Texas St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013812.69862 | 2105193.07398 | 37.7612360315304 | -122.39532637971901 | (37.7612360315304, -122.395326379719) | |||
| 13642 | 13642 | 33785 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013812.6799 | 2116223.3583 | 37.7915226979635 | -122.39609948281701 | (37.7915226979635, -122.396099482817) | |
| 14755 | 14755 | 33779 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013803.37475 | 2116233.23226 | 37.79154929181811 | -122.396132371028 | (37.7915492918181, -122.396132371028) | |
| 156067 | 156067 | 193372 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 61 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013792.54079 | 2116244.01793 | 37.791578303941705 | -122.39617061288999 | (37.7915783039417, -122.39617061289) | |||
| 54081 | 54081 | 193373 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 61 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013783.27133 | 2116255.65231 | 37.7916097334637 | -122.39620350109699 | (37.7916097334637, -122.396203501097) | |||
| 35824 | 35824 | 131007 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013687.07221 | 2117423.5151299997 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | |||
| 25560 | 25560 | 131008 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013685.844769999 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | |||
| 54511 | 54511 | 131009 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013684.354719999 | 2117443.2289299998 | 37.794865035532396 | -122.396629040522 | (37.7948650355324, -122.396629040522) | |||
| 134885 | 134885 | 102443 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 514 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2013 12:00:00 AM | 1 | Permit Number 770339 | 6013518.76597 | 2104573.81866 | 37.7595193399709 | -122.396299571184 | (37.7595193399709, -122.396299571184) | ||
| 42961 | 42961 | 193318 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 136 Hawthorne St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6013332.96782 | 2113640.4980900004 | 37.7844040630434 | -122.397578060899 | (37.7844040630434, -122.397578060899) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");