Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4693 | 4693 | 253655 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1048 Ingalls St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6018024.0 | 2094000.0 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | ||||
| 2071 | 2071 | 252870 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 716 McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | ||||
| 433 | 433 | 251301 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 2 | Back Yard : Yard 13 | Tree 1 | Mayor Office of Housing 7 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 474 | 474 | 251300 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 37030 | 37030 | 250127 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1798 Pine St | 4 | : 4 | Tree 1 | Private 1 | 22 | Width 5ft | 6005361.6989 | 2115505.86135 | 37.789078803778295 | -122.425288702018 | (37.7890788037783, -122.425288702018) | |||
| 188187 | 188187 | 250125 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1730 Pine St | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005649.1110000005 | 2115549.12657 | 37.7892138324921 | -122.424297370338 | (37.7892138324921, -122.424297370338) | |||
| 158273 | 158273 | 250109 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 5 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005867.157869999 | 2115579.68143 | 37.7893100383746 | -122.42354512700899 | (37.7893100383746, -122.423545127009) | |||
| 130217 | 130217 | 250108 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005895.20899 | 2115581.5118400003 | 37.7893166475034 | -122.423448203486 | (37.7893166475034, -122.423448203486) | |||
| 35112 | 35112 | 250107 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005911.45005 | 2115583.3816299997 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | |||
| 40055 | 40055 | 250106 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005930.7358800005 | 2115585.60481 | 37.7893298908963 | -122.42332557552601 | (37.7893298908963, -122.423325575526) | |||
| 26804 | 26804 | 250105 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6005949.70174 | 2115586.76552 | 37.7893341482864 | -122.423260038317 | (37.7893341482864, -122.423260038317) | |||
| 169546 | 169546 | 250104 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6006039.94152 | 2115602.86884 | 37.789383456327705 | -122.422948963731 | (37.7893834563277, -122.422948963731) | |||
| 183607 | 183607 | 250103 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6006023.8446 | 2115600.71368 | 37.7893766304877 | -122.423004504073 | (37.7893766304877, -122.423004504073) | |||
| 63679 | 63679 | 250102 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6006004.13239 | 2115596.49895 | 37.7893639455439 | -122.42307240646099 | (37.7893639455439, -122.423072406461) | |||
| 159517 | 159517 | 250101 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6005978.51572 | 2115593.66659 | 37.78935472300171 | -122.42316083590299 | (37.7893547230017, -122.423160835903) | |||
| 133083 | 133083 | 250094 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 8 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005324.767440001 | 2115623.21527 | 37.789398941767004 | -122.425424835102 | (37.789398941767, -122.425424835102) | |||
| 149297 | 149297 | 248615 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 446 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997626.0167 | 2107489.4868 | 37.7666278609206 | -122.451474603078 | (37.7666278609206, -122.451474603078) | |||
| 131150 | 131150 | 248583 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 832 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997671.8953 | 2107653.4687 | 37.7670807404856 | -122.45132774569099 | (37.7670807404856, -122.451327745691) | |||
| 155601 | 155601 | 248526 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 75 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997669.6241 | 2107795.1927 | 37.7674697483814 | -122.451345824031 | (37.7674697483814, -122.451345824031) | |||
| 164518 | 164518 | 248513 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 23 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997819.2217 | 2107818.3592 | 37.767541922496 | -122.450830059129 | (37.767541922496, -122.450830059129) | |||
| 41887 | 41887 | 248497 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 114 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997504.128 | 2107818.662 | 37.7675247113964 | -122.45191994324699 | (37.7675247113964, -122.451919943247) | |||
| 177148 | 177148 | 248496 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 110 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 0ft | 5997529.2628 | 2107821.3875 | 37.7675336345309 | -122.451833202371 | (37.7675336345309, -122.451833202371) | |||
| 41393 | 41393 | 248493 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 748 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997645.2464 | 2107858.3326 | 37.7676417185294 | -122.451434697353 | (37.7676417185294, -122.451434697353) | |||
| 67715 | 67715 | 248403 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1713 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997457.4924 | 2108113.6175 | 37.7683319124677 | -122.452102532521 | (37.7683319124677, -122.452102532521) | |||
| 187024 | 187024 | 248372 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1609 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997820.1302 | 2108164.6442 | 37.768492784741895 | -122.450851888359 | (37.7684927847419, -122.450851888359) | |||
| 4288 | 4288 | 248328 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998322.9779 | 2108222.7874 | 37.768681204074895 | -122.44911677876101 | (37.7686812040749, -122.449116778761) | |||
| 4228 | 4228 | 248327 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5998303.294 | 2108219.7591 | 37.768671763303104 | -122.449184645334 | (37.7686717633031, -122.449184645334) | |||
| 4299 | 4299 | 248326 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998285.1242 | 2108217.0336 | 37.768663240508 | -122.44924729658001 | (37.768663240508, -122.44924729658) | |||
| 4294 | 4294 | 248325 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 19 | Width 0ft | Permit Number 17699 | 5998266.3488 | 2108214.611 | 37.7686555147255 | -122.44931206435 | (37.7686555147255, -122.44931206435) | |
| 181489 | 181489 | 247933 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010316.772530001 | 2098765.05298 | 37.7433910575536 | -122.40696428417601 | (37.7433910575536, -122.406964284176) | ||||
| 30472 | 30472 | 247853 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009574.28658 | 2098178.5899099996 | 37.7417391819242 | -122.40949024059401 | (37.7417391819242, -122.409490240594) | ||||
| 29793 | 29793 | 247852 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6009577.25002 | 2098193.0016099997 | 37.741778919360705 | -122.409481010838 | (37.7417789193607, -122.409481010838) | ||||
| 39572 | 39572 | 247122 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6002767.913930001 | 2098805.6060200003 | 37.743077097036796 | -122.433069184902 | (37.7430770970368, -122.433069184902) | ||||
| 56034 | 56034 | 247100 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6002747.30855 | 2098672.19693 | 37.7427096178655 | -122.433130902689 | (37.7427096178655, -122.433130902689) | ||||
| 58504 | 58504 | 247099 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6002747.27026 | 2098651.7988 | 37.742653607170894 | -122.433129577966 | (37.7426536071709, -122.433129577966) | ||||
| 74211 | 74211 | 247098 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6002743.01525 | 2098640.44771 | 37.7426221983472 | -122.433143479687 | (37.7426221983472, -122.433143479687) | ||||
| 181295 | 181295 | 247092 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6002754.09625 | 2098614.08678 | 37.742550445936395 | -122.43310328180901 | (37.7425504459364, -122.433103281809) | ||||
| 131355 | 131355 | 247086 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6002759.04691 | 2098591.69247 | 37.7424892371899 | -122.43308456422501 | (37.7424892371899, -122.433084564225) | ||||
| 168669 | 168669 | 247078 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6002758.90176 | 2098529.69857 | 37.7423190081102 | -122.433080637766 | (37.7423190081102, -122.433080637766) | ||||
| 84093 | 84093 | 247077 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6002764.89351 | 2098516.6039400003 | 37.7422833931736 | -122.433058984778 | (37.7422833931736, -122.433058984778) | ||||
| 70104 | 70104 | 247076 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6002768.97997 | 2098508.28835 | 37.742260792292704 | -122.43304426108 | (37.7422607922927, -122.43304426108) | ||||
| 178257 | 178257 | 247074 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6002773.69931 | 2098494.22235 | 37.7422224380182 | -122.43302693833799 | (37.7422224380182, -122.433026938338) | ||||
| 169526 | 169526 | 247073 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6002776.09275 | 2098476.71227 | 37.742174495166395 | -122.433017411837 | (37.7421744951664, -122.433017411837) | ||||
| 40266 | 40266 | 246174 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1602 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5997866.0088 | 2108213.3997 | 37.768629281127296 | -122.45069671469 | (37.7686292811273, -122.45069671469) | |||
| 187175 | 187175 | 246156 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 658 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997926.8774 | 2108272.4514 | 37.7687949060021 | -122.450490433762 | (37.7687949060021, -122.450490433762) | |||
| 150366 | 150366 | 246155 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1644 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997687.6425 | 2108190.0819 | 37.768555044956 | -122.45131198438801 | (37.768555044956, -122.451311984388) | |||
| 157373 | 157373 | 246154 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1730 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997434.1745 | 2108152.8339 | 37.768438254928704 | -122.45218601649401 | (37.7684382549287, -122.452186016494) | |||
| 4178 | 4178 | 246147 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1504 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998476.2094 | 2108299.706 | 37.768901165807705 | -122.448592305739 | (37.7689011658077, -122.448592305739) | |||
| 188809 | 188809 | 246135 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1556 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 5998164.5983 | 2108256.0986 | 37.7687636084249 | -122.449666999674 | (37.7687636084249, -122.449666999674) | |||
| 2951 | 2951 | 246120 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1285 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 17 | Width 0ft | Permit Number 17675 | 5999562.003 | 2108407.0589 | 37.769257954715705 | -122.44484435027799 | (37.7692579547157, -122.444844350278) | |
| 1150 | 1150 | 246081 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1390 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999109.7278 | 2108387.5264 | 37.769178502070204 | -122.44640733565201 | (37.7691785020702, -122.446407335652) | |||
| 151958 | 151958 | 246078 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 646 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5998541.3176 | 2108402.6679 | 37.7691875956286 | -122.44837451744 | (37.7691875956286, -122.44837451744) | |||
| 3022 | 3022 | 246073 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1209 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 18 | Width 0ft | Permit Number 17669 | 5999896.6292 | 2108453.3917 | 37.7694042640863 | -122.44369022814199 | (37.7694042640863, -122.443690228142) | |
| 59213 | 59213 | 246051 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1426 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5998854.4429 | 2108351.1869 | 37.7690641391097 | -122.44728773272101 | (37.7690641391097, -122.447287732721) | |||
| 166362 | 166362 | 246047 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1260 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999598.1911 | 2108456.8743 | 37.769396800404 | -122.44472275905599 | (37.769396800404, -122.444722759056) | |||
| 46757 | 46757 | 244461 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 402 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6003240.6392 | 2109670.6251 | 37.772936647465 | -122.43221039578 | (37.772936647465, -122.43221039578) | |||
| 149232 | 149232 | 244110 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5997524.2657 | 2108863.6995 | 37.7703952699374 | -122.451925692038 | (37.7703952699374, -122.451925692038) | |||
| 180713 | 180713 | 244109 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997547.3781 | 2108866.1758 | 37.770403393000606 | -122.45184592528099 | (37.7704033930006, -122.451845925281) | |||
| 153010 | 153010 | 224448 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 36 McCoppin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 6006371.64374 | 2109173.2323 | 37.7717479515507 | -122.421344528235 | (37.7717479515507, -122.421344528235) | |||
| 188093 | 188093 | 224447 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 40 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003872.78638 | 2108597.53578 | 37.770026027713 | -122.42994716323 | (37.770026027713, -122.42994716323) | |||
| 136960 | 136960 | 224446 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 40 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003874.09282 | 2108583.13838 | 37.7699865699439 | -122.42994161713001 | (37.7699865699439, -122.42994161713) | |||
| 70134 | 70134 | 224445 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 50 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003875.0564 | 2108571.54256 | 37.7699547852142 | -122.42993745685301 | (37.7699547852142, -122.429937456853) | |||
| 31211 | 31211 | 224444 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 50 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003894.23838 | 2108432.6331700003 | 37.7695744601141 | -122.42986119705 | (37.7695744601141, -122.42986119705) | |||
| 60526 | 60526 | 224443 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 198 Corbin Pl | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6000083.78895 | 2105729.05454 | 37.76193458623221 | -122.442847194237 | (37.7619345862322, -122.442847194237) | |||
| 70330 | 70330 | 224442 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3550 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004507.26096 | 2105443.66869 | 37.761402176779704 | -122.427527801669 | (37.7614021767797, -122.427527801669) | |||
| 171481 | 171481 | 224441 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 310 Liberty St | 41 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6003891.83885 | 2103931.1825 | 37.757214421627395 | -122.42954842002399 | (37.7572144216274, -122.429548420024) | |||
| 168302 | 168302 | 224440 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 680 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6003015.35914 | 2104247.09039 | 37.75803216346179 | -122.43260218946301 | (37.7580321634618, -122.432602189463) | |||
| 48142 | 48142 | 224439 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3883 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003903.27581 | 2102441.01038 | 37.7531234083377 | -122.429402602143 | (37.7531234083377, -122.429402602143) | |||
| 188255 | 188255 | 224438 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 177 Powhattan Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6008219.66372 | 2098116.4731099997 | 37.7414926273921 | -122.414169698278 | (37.7414926273921, -122.414169698278) | |||
| 27587 | 27587 | 224437 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6006291.67485 | 2097655.32793 | 37.7401179434992 | -122.420803302726 | (37.7401179434992, -122.420803302726) | |||
| 162370 | 162370 | 224436 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 98 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6006240.51388 | 2097682.8061900004 | 37.7401905088725 | -122.42098214730801 | (37.7401905088725, -122.420982147308) | |||
| 74021 | 74021 | 224435 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 425 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 6007117.8206400005 | 2097842.00465 | 37.7406770466051 | -122.41796005021901 | (37.7406770466051, -122.417960050219) | |||
| 45323 | 45323 | 224434 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 11 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6007430.10011 | 2098092.51153 | 37.741382453248896 | -122.416898048032 | (37.7413824532489, -122.416898048032) | |||
| 176220 | 176220 | 224433 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 280 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009053.875 | 2096083.33646 | 37.7359568981934 | -122.411141689959 | (37.7359568981934, -122.411141689959) | |||
| 59795 | 59795 | 224432 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 111 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002272.00576 | 2096248.81682 | 37.736028604724005 | -122.434601117971 | (37.736028604724, -122.434601117971) | |||
| 136677 | 136677 | 224431 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 111 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6002252.13649 | 2096208.5785299998 | 37.7359169916712 | -122.434666937538 | (37.7359169916712, -122.434666937538) | |||
| 54419 | 54419 | 224430 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 55 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001828.253819999 | 2096840.59955 | 37.7376283017023 | -122.436177680756 | (37.7376283017023, -122.436177680756) | |||
| 80052 | 80052 | 224429 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 55 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6001826.44815 | 2096826.2196900002 | 37.737588715353496 | -122.436182895046 | (37.7375887153535, -122.436182895046) | |||
| 44357 | 44357 | 224428 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 74 Arbor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001850.79221 | 2096807.3936 | 37.737538406363 | -122.436097379408 | (37.737538406363, -122.436097379408) | |||
| 172515 | 172515 | 224427 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 74 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001884.73387 | 2096844.23678 | 37.7376414974551 | -122.435982662785 | (37.7376414974551, -122.435982662785) | |||
| 42606 | 42606 | 224426 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 74 Arbor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001898.6057400005 | 2096858.66767 | 37.7376819093764 | -122.435935733463 | (37.7376819093764, -122.435935733463) | |||
| 75042 | 75042 | 224425 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 74 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001911.23419 | 2096871.3219 | 37.7377173723477 | -122.435892976098 | (37.7377173723477, -122.435892976098) | |||
| 1197 | 1197 | 224424 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2500X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002246.98159 | 2097281.36199 | 37.738862314555 | -122.43476145089501 | (37.738862314555, -122.434761450895) | |||
| 69013 | 69013 | 224423 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 210 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004160.549319999 | 2097137.95677 | 37.73857701091271 | -122.42813500683 | (37.7385770109127, -122.42813500683) | |||
| 41379 | 41379 | 224035 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1619 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003374.882069999 | 2098756.34444 | 37.7429762470666 | -122.430966938682 | (37.7429762470666, -122.430966938682) | |||
| 164748 | 164748 | 224034 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 5210 Diamond Heights Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001015.66904 | 2099302.9649400003 | 37.7443431769966 | -122.439163600842 | (37.7443431769966, -122.439163600842) | |||
| 171025 | 171025 | 224033 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 309 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6006492.3244199995 | 2098046.7122 | 37.7412039045359 | -122.42013730619499 | (37.7412039045359, -122.420137306195) | |||
| 187560 | 187560 | 224032 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 149 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 2ft | 6008847.93319 | 2097848.3204900003 | 37.7407916085566 | -122.411978404795 | (37.7407916085566, -122.411978404795) | |||
| 154600 | 154600 | 224031 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 822 Clayton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 4ft | 5998688.13035 | 2107403.24761 | 37.766451833222604 | -122.447794742535 | (37.7664518332226, -122.447794742535) | |||
| 150144 | 150144 | 224030 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 56 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5998290.39945 | 2106258.63265 | 37.7632862690788 | -122.44908794966899 | (37.7632862690788, -122.449087949669) | |||
| 150829 | 150829 | 224029 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 56 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5998311.99153 | 2106260.3659 | 37.7632922630546 | -122.44901339496799 | (37.7632922630546, -122.449013394968) | |||
| 135072 | 135072 | 224028 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1420 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5997836.6848 | 2105808.46526 | 37.7620242630195 | -122.450624734548 | (37.7620242630195, -122.450624734548) | |||
| 49495 | 49495 | 224027 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1350 Noe St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6003197.19524 | 2100390.33495 | 37.7474527349542 | -122.431697967013 | (37.7474527349542, -122.431697967013) | ||||
| 58936 | 58936 | 224026 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3902 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 6004448.76336 | 2100465.8103 | 37.7477308368081 | -122.42737550149499 | (37.7477308368081, -122.427375501495) | |||
| 157239 | 157239 | 224025 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1193 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6004485.645169999 | 2101988.85608 | 37.7519148526121 | -122.427356445766 | (37.7519148526121, -122.427356445766) | |||
| 41851 | 41851 | 224024 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003500.27869 | 2095632.3533400001 | 37.7344055874315 | -122.43031051723801 | (37.7344055874315, -122.430310517238) | ||||
| 176279 | 176279 | 224023 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003511.08148 | 2095643.96545 | 37.734438083547104 | -122.430273996654 | (37.7344380835471, -122.430273996654) | ||||
| 152279 | 152279 | 224022 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6003540.82213 | 2095652.97051 | 37.7344644939234 | -122.43017181569999 | (37.7344644939234, -122.4301718157) | ||||
| 188666 | 188666 | 224021 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6003548.3510300005 | 2095664.8984299998 | 37.734497671711296 | -122.430146636467 | (37.7344976717113, -122.430146636467) | ||||
| 38019 | 38019 | 224020 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003561.5892199995 | 2095667.7300200001 | 37.7345061963941 | -122.430101069605 | (37.7345061963941, -122.430101069605) |
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");