trees
979 rows where qSpecies_id = 13 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67350 | 56947 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 690 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 5 | Permit Number 14199 | 6012986.78866 | 2103864.51855 | 37.7575421408828 | -122.398089663624 | (37.7575421408828, -122.398089663624) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
86635 | 32310 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780021 | 6011490.21346 | 2105535.41825 | 37.7620465904907 | -122.403382999439 | (37.7620465904907, -122.403382999439) | 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 | ||
91046 | 89190 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
94823 | 102805 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780021 | 6011492.26434 | 2105507.65774 | 37.7619704808857 | -122.403373953167 | (37.7619704808857, -122.403373953167) | 10 | 3 | 8 | 28856 | 29 | |
98983 | 106257 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1938 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | Permit Number 770844 | 6011971 | 2105625 | 37.7623194035501 | -122.40172643178 | (37.7623194035501, -122.40172643178) | 8 | 3 | 8 | 28856 | 29 | ||
100555 | 89164 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||
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 | |||
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 | |||
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 | |||
109890 | 89170 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | |||
114696 | 193341 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1751 22nd St | 6 | Side Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6012847.48484 | 2103764.38864 | 37.7572594461781 | -122.398564409431 | (37.7572594461781, -122.398564409431) | 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 | ||
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 | ||
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 | |||
124343 | 89194 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | |||||
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 | ||
126713 | 53079 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780021 | 6011490.70702 | 2105522.94409 | 37.7620123668039 | -122.4033804148 | (37.7620123668039, -122.4033804148) | 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 | ||
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 | ||
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 | |||
131765 | 89188 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||
139876 | 89172 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||
143967 | 89185 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||
150870 | 193321 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2111 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011418.14714 | 2105550.13938 | 37.7620829860523 | -122.403633286154 | (37.7620829860523, -122.403633286154) | 10 | 3 | 8 | 28856 | 29 | |||
152829 | 89184 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
155635 | 61318 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1419 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/2014 12:00:00 AM | 1 | Permit Number 772899 | 6011764.55732 | 2101642.9103 | 37.7513739409742 | -122.402160470048 | (37.7513739409742, -122.402160470048) | 10 | 3 | 8 | 28856 | 29 | |
155829 | 89192 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||
155874 | 193320 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2111 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011400.26798 | 2105549.24377 | 37.7620795281598 | -122.403695060604 | (37.7620795281598, -122.403695060604) | 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 | |
166081 | 89187 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | |||
168316 | 193322 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2111 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011436.66428 | 2105551.33646 | 37.7620873073181 | -122.403569326371 | (37.7620873073181, -122.403569326371) | 10 | 3 | 8 | 28856 | 29 | |||
169387 | 89171 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | |||
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 | ||
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 | |||
173358 | 193319 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2111 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011383.02095 | 2105548.33564 | 37.7620760711709 | -122.403754647862 | (37.7620760711709, -122.403754647862) | 10 | 3 | 8 | 28856 | 29 | |||
173449 | 193315 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6013291.13873 | 2113684.88595 | 37.7845236126199 | -122.39772589056 | (37.7845236126199, -122.39772589056) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
174738 | 202868 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 721 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 0 | Width 3ft | 6011581.65303 | 2104944.91806 | 37.7604303154251 | -122.403025207773 | (37.7604303154251, -122.403025207773) | 10 | 3 | 8 | 28856 | 29 | ||
176468 | 89189 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | |||
179747 | 193343 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 698 Arkansas St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012989.11402 | 2103849.31958 | 37.7575005373464 | -122.398080555283 | (37.7575005373464, -122.398080555283) | 10 | 3 | 8 | 28856 | 29 | |||
180648 | 57578 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1916 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1976 12:00:00 AM | 20 | 3x3 | Permit Number 16445 | 6012032 | 2105628 | 37.7623310447467 | -122.401515665193 | (37.7623310447467, -122.401515665193) | 8 | 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 | |||
184577 | 89191 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | |||
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 | ||
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 | ||
10144 | 97101 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
50069 | 130988 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008672.99088 | 2115994.19666 | 37.7906061691929 | -122.41386657548 | (37.7906061691929, -122.41386657548) | 5 | 1 | 10 | 28857 | 21 | |||
74030 | 97099 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
84305 | 131006 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 25 Joice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010297.06637 | 2116294.60935 | 37.7915221044126 | -122.408268538566 | (37.7915221044126, -122.408268538566) | 5 | 1 | 10 | 28857 | 21 | |||
131626 | 84840 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1107 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | 7 | Permit No. 49267 | 6009440.82091 | 2117125.31431 | 37.7937550347318 | -122.411289855968 | (37.7937550347318, -122.411289855968) | 3 | 1 | 10 | 28857 | 21 | ||
172181 | 130989 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008668.89448 | 2116022.78913 | 37.7906844470866 | -122.413882772283 | (37.7906844470866, -122.413882772283) | 5 | 1 | 10 | 28857 | 21 | |||
185410 | 112790 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Joice St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 11 | 3x3 | 6010307.81813 | 2116296.03331 | 37.7915266163113 | -122.408231437935 | (37.7915266163113, -122.408231437935) | 5 | 1 | 10 | 28857 | 21 | |||
11942 | 34949 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1246 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | Permit Number 38547 | 6007519.49351 | 2115461.74269 | 37.7890793334842 | -122.417819862092 | (37.7890793334842, -122.417819862092) | 13 | 1 | 10 | 28858 | 21 | ||
13364 | 70607 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1256 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007485.00571 | 2115457.39575 | 37.7890654569562 | -122.417938877483 | (37.7890654569562, -122.417938877483) | 13 | 1 | 10 | 28858 | 21 | |||
14077 | 70606 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007500.28626 | 2115460.0775 | 37.7890736803541 | -122.417886198793 | (37.7890736803541, -122.417886198793) | 13 | 1 | 10 | 28858 | 21 | |||
16680 | 256664 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
19938 | 103781 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1237 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | 13 | 9 | 10 | 28858 | 21 | ||
20727 | 130987 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1332 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006981.76642 | 2115388.70116 | 37.7888485036088 | -122.419675148215 | (37.7888485036088, -122.419675148215) | 13 | 9 | 10 | 28858 | 21 | |||
23205 | 81367 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.419830397182 | (37.7858955407321, -122.419830397182) | 13 | 9 | 9 | 28858 | 36 | |||
23388 | 256663 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
24814 | 130998 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007580.24685 | 2119942.9983 | 37.8013871663302 | -122.417927457909 | (37.8013871663302, -122.417927457909) | 5 | 1 | 1 | 28858 | 32 | |||
27090 | 130990 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1465 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007716.27446 | 2117147.85171 | 37.7937200456874 | -122.417258554752 | (37.7937200456874, -122.417258554752) | 5 | 1 | 10 | 28858 | 32 | |||
33582 | 103859 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1475 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | 13 | 9 | 10 | 28858 | 21 | ||
33672 | 103773 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | |||
34100 | 103787 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1217 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006790.1 | 2115111 | 37.7880752061995 | -122.420318570601 | (37.7880752061995, -122.420318570601) | 13 | 9 | 10 | 28858 | 21 | ||
34827 | 103801 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
37490 | 113226 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006956 | 2114756 | 37.787109810462 | -122.419719385886 | (37.787109810462, -122.419719385886) | 13 | 9 | 10 | 28858 | 21 | ||||
38286 | 103800 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
42861 | 103782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1237 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | 13 | 9 | 10 | 28858 | 21 | ||
46000 | 130996 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 48 Bonita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006123.48756 | 2118486.00095 | 37.7973045284306 | -122.422864892409 | (37.7973045284306, -122.422864892409) | 13 | 9 | 10 | 28858 | 32 | |||
49967 | 130991 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006783.4642 | 2117013.95966 | 37.7932998878436 | -122.420476658169 | (37.7932998878436, -122.420476658169) | 13 | 9 | 10 | 28858 | 32 | |||
62298 | 103869 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
62327 | 103775 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | ||
64797 | 103852 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1507 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | 13 | 9 | 10 | 28858 | 21 | ||
64815 | 97108 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1472 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768373 | 6007110.85897 | 2117762.02293 | 37.795372327823 | -122.419396941128 | (37.795372327823, -122.419396941128) | 5 | 1 | 10 | 28858 | 32 |
70101 | 103767 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1323 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757 | 2115467 | 37.7890508291132 | -122.420458370284 | (37.7890508291132, -122.420458370284) | 13 | 9 | 10 | 28858 | 21 | ||
76327 | 109486 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1314 POLK ST | 1 | Sidewalk: Curb side : Pot | Landscaping | DPW 1 | 01/23/2016 04:50:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | 13 | 9 | 10 | 28858 | 21 | ||
89050 | 103865 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1424 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006775 | 2115831.4 | 37.7900523957484 | -122.420421968076 | (37.7900523957484, -122.420421968076) | 13 | 9 | 10 | 28858 | 21 | ||
91960 | 103860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1475 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | 13 | 9 | 10 | 28858 | 21 | ||
92614 | 109488 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1314 POLK ST | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 01/23/2016 04:53:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | 13 | 9 | 10 | 28858 | 21 | ||
94193 | 88841 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2008 12:00:00 AM | 3x3 | Permit Number 51719 | 6006820 | 2115342 | 37.788711160037 | -122.420231522803 | (37.788711160037, -122.420231522803) | 13 | 9 | 10 | 28858 | 21 | ||
94680 | 132274 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2160 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005107.40746 | 2116851.05926 | 37.7927580094371 | -122.426264329748 | (37.7927580094371, -122.426264329748) | 13 | 9 | 1 | 28858 | 27 | |
99113 | 87077 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2565 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006603.98041 | 2120038.08601 | 37.8015932612686 | -122.421312536668 | (37.8015932612686, -122.421312536668) | 5 | 9 | 1 | 28858 | 32 | |
101178 | 130993 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006795.77998 | 2117016.02483 | 37.7933062523213 | -122.4204341913 | (37.7933062523213, -122.4204341913) | 13 | 9 | 10 | 28858 | 32 | |||
102492 | 103866 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 |
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) );