trees
3,965 rows where qSpecies_id = 70 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71561 | 6553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1275 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6017462.04156 | 2097126.15561 | 37.7392882208803 | -122.382143528109 | (37.7392882208803, -122.382143528109) | 10 | 3 | 8 | 58 | 1 | |||
| 54548 | 28654 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1275 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | 3 | 6x3 | 6017442.42343 | 2097139.52518 | 37.739323847514 | -122.38221228939 | (37.739323847514, -122.38221228939) | 10 | 3 | 8 | 58 | 1 | ||
| 42718 | 6479 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017436.11701 | 2097265.30001 | 37.7396688516514 | -122.382242842132 | (37.7396688516514, -122.382242842132) | 10 | 3 | 8 | 58 | 1 | |||
| 152895 | 188672 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1224 Fairfax Ave | 3 | : | Tree | Private 2 | 14 | Width 4ft | 6017423.58872 | 2096888.36438 | 37.7386331699882 | -122.382259943553 | (37.7386331699882, -122.382259943553) | 10 | 3 | 8 | 58 | 1 | |||
| 192020 | 6747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1215 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017390.63175 | 2096829.56918 | 37.7384699097667 | -122.382369804725 | (37.7384699097667, -122.382369804725) | 10 | 3 | 8 | 58 | 1 | |||
| 156185 | 188654 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 12 | Median : Yard | Tree | DPW 1 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | 10 | 3 | 8 | 58 | 1 | ||||
| 32564 | 187777 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1215 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6017388.24402 | 2096830.64368 | 37.7384727282386 | -122.382378135159 | (37.7384727282386, -122.382378135159) | 10 | 3 | 8 | 58 | 1 | |||
| 110537 | 188653 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 13 | Median : Yard | Tree | DPW 1 | 1 | 6017421.68385 | 2098629.86939 | 37.7434148869 | -122.382387660761 | (37.7434148869, -122.382387660761) | 10 | 3 | 8 | 58 | 1 | ||||
| 140188 | 188673 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1224 Fairfax Ave | 6 | : | Tree | Private 2 | 17 | Width 3ft | 6017369.13061 | 2096930.52417 | 37.7387459242774 | -122.382451168193 | (37.7387459242774, -122.382451168193) | 10 | 3 | 8 | 58 | 1 | |||
| 114994 | 188652 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 14 | Median : Yard | Tree | DPW 1 | 19 | 6017392.84765 | 2098647.15958 | 37.7434607693943 | -122.382488572792 | (37.7434607693943, -122.382488572792) | 10 | 3 | 8 | 58 | 1 | ||||
| 176568 | 188674 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1270 Fairfax Ave | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6017349.18345 | 2096943.80807 | 37.7387812973263 | -122.382521060803 | (37.7387812973263, -122.382521060803) | 10 | 3 | 8 | 58 | 1 | |||
| 121884 | 188651 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 15 | Median : Yard | Tree | DPW 1 | 6 | 6017373.96429 | 2098663.52344 | 37.7435046581055 | -122.382555005724 | (37.7435046581055, -122.382555005724) | 10 | 3 | 8 | 58 | 1 | ||||
| 52580 | 187748 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1322 Hudson Ave | 49 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017296.56701 | 2095239.40453 | 37.734098438398 | -122.382584422552 | (37.734098438398, -122.382584422552) | 10 | 3 | 8 | 58 | 1 | |||
| 9851 | 187722 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6017248.25374 | 2094957.00254 | 37.7333203494413 | -122.382731813344 | (37.7333203494413, -122.382731813344) | 10 | 3 | 8 | 58 | 1 | |||
| 82195 | 188689 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 42 | : | Tree | Private 2 | 11 | Width 3ft | 6017291.85289 | 2097369.22431 | 37.7399462377322 | -122.382748880668 | (37.7399462377322, -122.382748880668) | 10 | 3 | 8 | 58 | 1 | |||
| 155744 | 6486 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017283.44001 | 2097385.77201 | 37.7399912095936 | -122.382779120446 | (37.7399912095936, -122.382779120446) | 10 | 3 | 8 | 58 | 1 | |||
| 188731 | 24220 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 52 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017233.65569 | 2094997.27182 | 37.7334301143948 | -122.38278508468 | (37.7334301143948, -122.38278508468) | 10 | 3 | 8 | 58 | 1 | |||
| 176691 | 187721 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6017221.17911 | 2094948.917 | 37.7332966523177 | -122.382824856279 | (37.7332966523177, -122.382824856279) | 10 | 3 | 8 | 58 | 1 | |||
| 30838 | 188697 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 13 | : | Tree | DPW 1 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291 | (37.7397338556296, -122.38293388291) | 10 | 3 | 8 | 58 | 1 | |||
| 152157 | 187720 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6017189.12097 | 2094942.52157 | 37.7332773204746 | -122.382935246271 | (37.7332773204746, -122.382935246271) | 10 | 3 | 8 | 58 | 1 | |||
| 15006 | 6568 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017234.1596238 | 2097288.6286052 | 37.7397217505579 | -122.382942754401 | (37.7397217505579, -122.382942754401) | 10 | 3 | 8 | 58 | 1 | |||
| 153144 | 6771 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1275 Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6017217.4089567 | 2096970.3613046 | 37.7388469269577 | -122.382978527185 | (37.7388469269577, -122.382978527185) | 10 | 3 | 8 | 58 | 1 | |||
| 85871 | 24225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.40196 | 2094982.30239 | 37.7333853506538 | -122.383013103287 | (37.7333853506538, -122.383013103287) | 10 | 3 | 8 | 58 | 1 | ||
| 101376 | 187719 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 6017160.21772 | 2094934.24591 | 37.7332530001163 | -122.383034597962 | (37.7332530001163, -122.383034597962) | 10 | 3 | 8 | 58 | 1 | |||
| 35108 | 3688 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 2 | Median : Cutout | Tree | Port 6 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 35347 | 3691 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 5 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 35762 | 3690 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 4 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 104325 | 3689 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 3 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 179402 | 3687 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 48195 | 24226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6017135.66368 | 2094974.09134 | 37.7333610509772 | -122.383122261179 | (37.7333610509772, -122.383122261179) | 10 | 3 | 8 | 58 | 1 | |||
| 140409 | 188696 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 12 | : | Tree | Private 2 | 20 | Width 4ft | 6017175.78475 | 2097338.59897 | 37.7398557335482 | -122.383148069031 | (37.7398557335482, -122.383148069031) | 10 | 3 | 8 | 58 | 1 | |||
| 29162 | 188675 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1298 Fairfax Ave | 5 | : | Tree | Private 2 | 21 | Width 4ft | 6017168.99246 | 2097078.35566 | 37.739140782423 | -122.383153445176 | (37.739140782423, -122.383153445176) | 10 | 3 | 8 | 58 | 1 | |||
| 173948 | 6569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1303 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017171.79019 | 2097333.44943 | 37.7398413732106 | -122.38316152235 | (37.7398413732106, -122.38316152235) | 10 | 3 | 8 | 58 | 1 | |||
| 38953 | 3694 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017199.673909 | 2098835.752969 | 37.7439679357533 | -122.383169649574 | (37.7439679357533, -122.383169649574) | 10 | 3 | 8 | 58 | 1 | |||
| 131193 | 24228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6017105.82846 | 2094967.47212 | 37.7333412272151 | -122.383224950289 | (37.7333412272151, -122.383224950289) | 10 | 3 | 8 | 58 | 1 | |||
| 92090 | 188695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 10 | : | Tree | Private 2 | 15 | Width 3ft | 6017144.28131 | 2097363.3609 | 37.739921983914 | -122.383258718941 | (37.739921983914, -122.383258718941) | 10 | 3 | 8 | 58 | 1 | |||
| 152216 | 188676 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1298 Fairfax Ave | 8 | : | Tree | Private 2 | 19 | Width 4ft | 6017117.52195 | 2097116.26843 | 37.7392420388994 | -122.383334047038 | (37.7392420388994, -122.383334047038) | 10 | 3 | 8 | 58 | 1 | |||
| 153892 | 6491 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017120.02701 | 2097502.66601 | 37.7403031472893 | -122.383352275591 | (37.7403031472893, -122.383352275591) | 10 | 3 | 8 | 58 | 1 | |||
| 175633 | 6571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017110.8649657 | 2097380.9593528 | 37.7399684589918 | -122.383375484618 | (37.7399684589918, -122.383375484618) | 10 | 3 | 8 | 58 | 1 | |||
| 103549 | 188694 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 8 | : | Tree | Private 2 | 14 | Width 3ft | 6017109.80778 | 2097388.18297 | 37.7399882351628 | -122.38337964268 | (37.7399882351628, -122.38337964268) | 10 | 3 | 8 | 58 | 1 | |||
| 158947 | 6731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.47437 | 37.7392827179327 | -122.383402261517 | (37.7392827179327, -122.383402261517) | 10 | 3 | 8 | 58 | 1 | ||
| 85436 | 6572 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1327 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017100.6753245 | 2097388.5899931 | 37.7399888480471 | -122.383411247575 | (37.7399888480471, -122.383411247575) | 10 | 3 | 8 | 58 | 1 | |||
| 106506 | 6492 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017102.13601 | 2097515.78601 | 37.7403381833964 | -122.383415049232 | (37.7403381833964, -122.383415049232) | 10 | 3 | 8 | 58 | 1 | |||
| 149256 | 187776 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Lane St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6017085.14253 | 2097027.72746 | 37.7389971337102 | -122.383439839679 | (37.7389971337102, -122.383439839679) | 10 | 3 | 8 | 58 | 1 | |||
| 19890 | 3695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | 10 | 3 | 8 | 58 | 1 | |||
| 110062 | 6573 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1329 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6017090.4856833 | 2097396.2206334 | 37.7400092370914 | -122.383447010551 | (37.7400092370914, -122.383447010551) | 10 | 3 | 8 | 58 | 1 | |||
| 160704 | 6732 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6017081.22678 | 2097144.85805 | 37.7393185343335 | -122.383461530425 | (37.7393185343335, -122.383461530425) | 10 | 3 | 8 | 58 | 1 | |||
| 40653 | 6493 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 12 | 3x3 | 6017084.24401 | 2097528.90701 | 37.7403732221604 | -122.38347782646 | (37.7403732221604, -122.38347782646) | 10 | 3 | 8 | 58 | 1 | ||
| 102039 | 188659 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 3 | Median : Yard | Tree | DPW 1 | 2 | 6017103.6349 | 2098887.87453 | 37.744105743386 | -122.383505361577 | (37.744105743386, -122.383505361577) | 10 | 3 | 8 | 58 | 1 | ||||
| 143417 | 187775 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Lane St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6017053.32881 | 2096987.93599 | 37.7388861160087 | -122.383547068563 | (37.7388861160087, -122.383547068563) | 10 | 3 | 8 | 58 | 1 | |||
| 86464 | 6772 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1353 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017054.96873 | 2097078.54071 | 37.7391349889858 | -122.383547704374 | (37.7391349889858, -122.383547704374) | 10 | 3 | 8 | 58 | 1 | ||
| 76607 | 188660 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 4 | Median : Yard | Tree | DPW 1 | 22 | 6017087.32908 | 2098898.60664 | 37.7441343103446 | -122.383562491039 | (37.7441343103446, -122.383562491039) | 10 | 3 | 8 | 58 | 1 | ||||
| 158606 | 187774 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Lane St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6017047.63402 | 2096978.70465 | 37.738860453847 | -122.383566116201 | (37.738860453847, -122.383566116201) | 10 | 3 | 8 | 58 | 1 | |||
| 76377 | 187724 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6017001.33944 | 2094943.49204 | 37.7332696078935 | -122.383584532495 | (37.7332696078935, -122.383584532495) | 10 | 3 | 8 | 58 | 1 | |||
| 43411 | 6580 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1337 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017048.7081546 | 2097427.5062586 | 37.7400928320588 | -122.383593638958 | (37.7400928320588, -122.383593638958) | 10 | 3 | 8 | 58 | 1 | |||
| 126345 | 6578 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1337 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017048.7081546 | 2097427.5062586 | 37.7400928320588 | -122.383593638958 | (37.7400928320588, -122.383593638958) | 10 | 3 | 8 | 58 | 1 | |||
| 116777 | 187773 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 3ft | 6017040.80621 | 2097089.42063 | 37.7391640802698 | -122.383597429682 | (37.7391640802698, -122.383597429682) | 10 | 3 | 8 | 58 | 1 | |||
| 91391 | 6775 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017039.80382 | 2097089.47454 | 37.7391641728912 | -122.383600899281 | (37.7391641728912, -122.383600899281) | 10 | 3 | 8 | 58 | 1 | ||
| 128771 | 187725 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6016988.86725 | 2094945.03684 | 37.733273160235 | -122.383627760212 | (37.733273160235, -122.383627760212) | 10 | 3 | 8 | 58 | 1 | |||
| 170737 | 187718 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016979.12184 | 2094899.73634 | 37.7331482353903 | -122.383658300306 | (37.7331482353903, -122.383658300306) | 10 | 3 | 8 | 58 | 1 | |||
| 144610 | 188568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 24th St | 24 | : Yard | Tree | Private 2 | 38 | 6017120.70508 | 2102612.37668 | 37.7543334029878 | -122.383705595635 | (37.7543334029878, -122.383705595635) | 10 | 3 | 8 | 28856 | 29 | ||||
| 71055 | 187717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6016962.05106 | 2094901.44283 | 37.7331519774826 | -122.383717437926 | (37.7331519774826, -122.383717437926) | 10 | 3 | 8 | 58 | 1 | |||
| 157395 | 188569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 24th St | 26 | : Yard | Tree | Private 2 | 5 | 6017110.36972 | 2102585.17266 | 37.7542581351188 | -122.383739444343 | (37.7542581351188, -122.383739444343) | 10 | 3 | 8 | 28856 | 29 | ||||
| 64263 | 6567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2004 12:00:00 AM | 5 | 3X3 | 6017004.85053 | 2097463.70294 | 37.7401897966309 | -122.383747801739 | (37.7401897966309, -122.383747801739) | 10 | 3 | 8 | 58 | 1 | ||
| 67591 | 187716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 3ft | 6016950.63846 | 2094900.99132 | 37.7331501068758 | -122.383756863312 | (37.7331501068758, -122.383756863312) | 10 | 3 | 8 | 58 | 1 | |||
| 140578 | 6566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/02/1992 12:00:00 AM | 19 | 3X3 | 6016992.23508 | 2097474.99816 | 37.7402201136747 | -122.383792207542 | (37.7402201136747, -122.383792207542) | 10 | 3 | 8 | 58 | 1 | ||
| 111877 | 187726 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 76 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6016892.38136 | 2094959.59167 | 37.7333077913283 | -122.383962354797 | (37.7333077913283, -122.383962354797) | 10 | 3 | 8 | 58 | 1 | |||
| 155250 | 6502 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016937.53001 | 2097643.41501 | 37.7406795281671 | -122.383993082034 | (37.7406795281671, -122.383993082034) | 10 | 3 | 8 | 58 | 1 | |||
| 33139 | 188693 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1350 Evans Ave | 2 | : | Tree | Private 2 | 20 | Width 4ft | 6016935.69851 | 2097636.39062 | 37.7406601393594 | -122.383998925709 | (37.7406601393594, -122.383998925709) | 10 | 3 | 8 | 58 | 1 | |||
| 28295 | 3742 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6016957.733924 | 2099023.86587 | 37.7444710828997 | -122.38401932754 | (37.7444710828997, -122.38401932754) | 10 | 3 | 8 | 58 | 1 | |||
| 113270 | 187727 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 76 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6016865.11612 | 2094968.38741 | 37.7333304353331 | -122.384057231462 | (37.7333304353331, -122.384057231462) | 10 | 3 | 8 | 58 | 1 | |||
| 75803 | 6795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016906.37547 | 2097191.59326 | 37.7394371944809 | -122.384069348045 | (37.7394371944809, -122.384069348045) | 10 | 3 | 8 | 58 | 1 | |||
| 57172 | 6797 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 3 | 6016896.75135 | 2097199.75019 | 37.7394590596789 | -122.384103192232 | (37.7394590596789, -122.384103192232) | 10 | 3 | 8 | 58 | 1 | |||
| 61212 | 187715 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6016846.76971 | 2094930.10872 | 37.7332243153459 | -122.384117995955 | (37.7332243153459, -122.384117995955) | 10 | 3 | 8 | 58 | 1 | |||
| 107088 | 188661 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400x Cargo Way | 8 | Median : Yard | Tree | DPW 1 | 20 | 6016926.49281 | 2099019.67279 | 37.7444578423491 | -122.384127062023 | (37.7444578423491, -122.384127062023) | 10 | 3 | 8 | 58 | 1 | ||||
| 62386 | 187723 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 57 Progress St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6016846.42344 | 2095098.5772 | 37.7336868771302 | -122.384130920999 | (37.7336868771302, -122.384130920999) | 10 | 3 | 8 | 58 | 1 | |||
| 78655 | 6794 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.45833 | 2097207.36346 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | 10 | 3 | 8 | 58 | 1 | ||
| 57615 | 188567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500 24th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | 3 | 8 | 28856 | 29 | |||||
| 81345 | 187714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6016776.4454 | 2094960.14046 | 37.7333028882004 | -122.384363219486 | (37.7333028882004, -122.384363219486) | 10 | 3 | 8 | 58 | 1 | |||
| 75999 | 3827 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 130 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016793.8666003 | 2095959.0590849 | 37.736046682619 | -122.384372537421 | (37.736046682619, -122.384372537421) | 10 | 3 | 8 | 58 | 1 | |||
| 110379 | 187728 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 82 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016765.26263 | 2095017.29072 | 37.7334591930792 | -122.384405860861 | (37.7334591930792, -122.384405860861) | 10 | 3 | 8 | 58 | 1 | |||
| 115021 | 187729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6016756.98827 | 2095025.70414 | 37.7334818371106 | -122.384435053735 | (37.7334818371106, -122.384435053735) | 10 | 3 | 8 | 58 | 1 | |||
| 175125 | 187730 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016747.91216 | 2095034.61845 | 37.7335058121437 | -122.384467053408 | (37.7335058121437, -122.384467053408) | 10 | 3 | 8 | 58 | 1 | |||
| 156766 | 6776 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
| 173030 | 6777 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1355 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
| 162562 | 6789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1390 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
| 75058 | 187731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016728.56547 | 2095062.09483 | 37.733580186956 | -122.384535854255 | (37.733580186956, -122.384535854255) | 10 | 3 | 8 | 58 | 1 | |||
| 185107 | 187732 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6016720.53621 | 2095079.35768 | 37.7336271432802 | -122.384564816022 | (37.7336271432802, -122.384564816022) | 10 | 3 | 8 | 58 | 1 | |||
| 164474 | 24141 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.7337286308528 | -122.38459886076 | (37.7337286308528, -122.38459886076) | 10 | 3 | 8 | 58 | 1 | |||
| 33296 | 24143 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016705.20951 | 2095147.06572 | 37.7338122084672 | -122.38462252012 | (37.7338122084672, -122.38462252012) | 10 | 3 | 8 | 58 | 1 | |||
| 162265 | 24144 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.384635938 | (37.7338509755474, -122.384635938) | 10 | 3 | 8 | 58 | 1 | |||
| 105726 | 3685 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout | Tree | Port 6 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767872 | (37.744924332395, -122.38470767872) | 10 | 3 | 8 | 58 | 1 | |||
| 166809 | 97222 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 2 | Median : Cutout | Tree | DPW 1 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | |||
| 145665 | 188656 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Cargo Way | 122 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6016757.25377 | 2099196.6677 | 37.7449344758533 | -122.384724588679 | (37.7449344758533, -122.384724588679) | 10 | 3 | 8 | 58 | 1 | ||||
| 79885 | 187734 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 97 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6016672.47216 | 2095023.06594 | 37.7334699192814 | -122.384727069019 | (37.7334699192814, -122.384727069019) | 10 | 3 | 8 | 58 | 1 | |||
| 30744 | 187733 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 97 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6016669.55687 | 2095074.42086 | 37.7336107684215 | -122.384740724326 | (37.7336107684215, -122.384740724326) | 10 | 3 | 8 | 58 | 1 | |||
| 49519 | 188657 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Cargo Way | 123 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6016750.16767 | 2099204.87087 | 37.7449566081772 | -122.384749662688 | (37.7449566081772, -122.384749662688) | 10 | 3 | 8 | 58 | 1 | ||||
| 163065 | 97223 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 3 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | 10 | 3 | 8 | 58 | 1 | ||
| 28712 | 97224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.04222 | 2094950.9325 | 37.733270780627 | -122.384789221155 | (37.733270780627, -122.384789221155) | 10 | 3 | 8 | 58 | 1 | ||
| 39400 | 97226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.12769 | 37.7332433315076 | -122.384821485239 | (37.7332433315076, -122.384821485239) | 10 | 3 | 8 | 58 | 1 |
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) );