Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82277 | 82277 | 3411 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6535 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X3 | 5987339.6073 | 2113923.58255 | 37.7836996729153 | -122.487525738493 | (37.7836996729153, -122.487525738493) | |||
| 117370 | 117370 | 3406 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6509 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5987365.26176 | 2113921.59773 | 37.783695719333004 | -122.487436839088 | (37.783695719333, -122.487436839088) | |||
| 160139 | 160139 | 120037 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 854 28th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5987294.40591 | 2110207.04941 | 37.7734924883925 | -122.487409025464 | (37.7734924883925, -122.487409025464) | |||
| 136723 | 136723 | 120036 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 854 28th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5987295.49688 | 2110185.40666 | 37.773433127092794 | -122.487403661604 | (37.7734331270928, -122.487403661604) | |||
| 161768 | 161768 | 120035 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 854 28th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5987295.863059999 | 2110158.83782 | 37.773360197862104 | -122.48740044295201 | (37.7733601978621, -122.487400442952) | |||
| 77128 | 77128 | 120034 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 854 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 2ft | 5987296.86905 | 2110133.18169 | 37.7732898119884 | -122.487395078202 | (37.7732898119884, -122.487395078202) | |||
| 28770 | 28770 | 120033 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 854 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 2ft | 5987298.51459 | 2110108.4388099997 | 37.7732219709389 | -122.48738756829799 | (37.7732219709389, -122.487387568298) | |||
| 53487 | 53487 | 120032 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 854 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 2ft | 5987298.75417 | 2110090.52019 | 37.773172785402004 | -122.487385423111 | (37.773172785402, -122.487385423111) | |||
| 109945 | 109945 | 3407 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6509 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5987381.40448 | 2113921.43328 | 37.7836962092086 | -122.487380980037 | (37.7836962092086, -122.487380980037) | |||
| 101146 | 101146 | 103209 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987181.0332 | 2104341.2684 | 37.757380064215795 | -122.487370243421 | (37.7573800642158, -122.487370243421) | |||
| 46862 | 46862 | 103223 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987183.9948 | 2104224.5811 | 37.7570598454095 | -122.487351430278 | (37.7570598454095, -122.487351430278) | |||
| 32299 | 32299 | 103222 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987186.3641 | 2104162.3873 | 37.7568892163494 | -122.487338668246 | (37.7568892163494, -122.487338668246) | |||
| 61312 | 61312 | 103208 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987188.7333 | 2104102.5628 | 37.7567250927297 | -122.487326080643 | (37.7567250927297, -122.487326080643) | |||
| 45897 | 45897 | 103220 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987192.8796 | 2103980.5446 | 37.756390305765706 | -122.48730277925199 | (37.7563903057657, -122.487302779252) | |||
| 186533 | 186533 | 103207 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987194.6566 | 2103923.6817 | 37.756234279341896 | -122.487292457342 | (37.7562342793419, -122.487292457342) | |||
| 24234 | 24234 | 103219 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987198.2105 | 2103866.2266 | 37.7560767305116 | -122.48727594694401 | (37.7560767305116, -122.487275946944) | |||
| 74287 | 74287 | 103218 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987199.9875 | 2103809.956 | 37.755922330371796 | -122.48726566863701 | (37.7559223303718, -122.487265668637) | |||
| 46034 | 46034 | 103206 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987202.3567 | 2103753.0931 | 37.7557663384655 | -122.487253298879 | (37.7557663384655, -122.487253298879) | |||
| 131166 | 131166 | 37240 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 10 | Permit Number 39797 | 5987223.0879999995 | 2103734.1389 | 37.7557155042777 | -122.48718021225599 | (37.7557155042777, -122.487180212256) | ||
| 189074 | 189074 | 184106 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2299 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5987259.8119 | 2104360.815 | 37.757438327672205 | -122.487099234581 | (37.7574383276722, -122.487099234581) | |||
| 44516 | 44516 | 184107 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2299 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987278.1739 | 2104361.4073 | 37.757441024619496 | -122.487035775789 | (37.7574410246195, -122.487035775789) | |||
| 51809 | 51809 | 37233 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 10 | Permit Number 39797 | 5987275.2123 | 2103735.3235 | 37.755721796170796 | -122.487000039163 | (37.7557217961708, -122.487000039163) | ||
| 102620 | 102620 | 700 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6440X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5987497.2290900005 | 2113983.68287 | 37.783873882692795 | -122.48698484907699 | (37.7838738826928, -122.486984849077) | |||
| 149331 | 149331 | 120102 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6491 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5987513.52414 | 2113927.8285 | 37.7837214725966 | -122.486924371786 | (37.7837214725966, -122.486924371786) | |||
| 160686 | 160686 | 184108 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2299 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987315.4901 | 2104361.9997 | 37.757444826919105 | -122.486906766666 | (37.7574448269191, -122.486906766666) | |||
| 112196 | 112196 | 3405 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6469 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5987528.04768 | 2113893.30009 | 37.7836275141903 | -122.486871590011 | (37.7836275141903, -122.486871590011) | |||
| 95184 | 95184 | 103170 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987326.2 | 2104050.0 | 37.7565887850833 | -122.48684681689801 | (37.7565887850833, -122.486846816898) | ||||
| 101321 | 101321 | 103169 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987326.2 | 2104050.0 | 37.7565887850833 | -122.48684681689801 | (37.7565887850833, -122.486846816898) | ||||
| 103219 | 103219 | 103173 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987326.2 | 2104050.0 | 37.7565887850833 | -122.48684681689801 | (37.7565887850833, -122.486846816898) | ||||
| 121523 | 121523 | 103172 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987326.2 | 2104050.0 | 37.7565887850833 | -122.48684681689801 | (37.7565887850833, -122.486846816898) | ||||
| 44159 | 44159 | 37237 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 11 | Permit Number 39797 | 5987327.3366 | 2103738.2851 | 37.755732966947896 | -122.486819996525 | (37.7557329669479, -122.486819996525) | ||
| 57045 | 57045 | 181721 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1212 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987399.3466 | 2107057.8939 | 37.7648519023124 | -122.486814726163 | (37.7648519023124, -122.486814726163) | |||
| 145876 | 145876 | 3403 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6434 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3PL | 5987566.03315 | 2113985.09722 | 37.7838817775015 | -122.48674691948798 | (37.7838817775015, -122.486746919488) | |||
| 145704 | 145704 | 3404 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6433 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5987570.06398 | 2113929.5082 | 37.78372938088871 | -122.48672889119699 | (37.7837293808887, -122.486728891197) | |||
| 45594 | 45594 | 184109 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2299 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987368.7991 | 2104364.9613 | 37.7574560666161 | -122.486722622725 | (37.7574560666161, -122.486722622725) | |||
| 174609 | 174609 | 184110 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2299 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5987381.8302 | 2104364.9613 | 37.7574568262941 | -122.48667755655799 | (37.7574568262941, -122.486677556558) | |||
| 137928 | 137928 | 181723 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2645 Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987467.2595 | 2107089.7834 | 37.764943421213495 | -122.48658217754299 | (37.7649434212135, -122.486582177543) | |||
| 107422 | 107422 | 3402 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6427 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5987613.69484 | 2113929.51427 | 37.783731941045 | -122.48657794726999 | (37.783731941045, -122.48657794727) | |||
| 144501 | 144501 | 3401 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6418 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3PL | 5987629.863 | 2113987.14017 | 37.7838911078316 | -122.486526244723 | (37.7838911078316, -122.486526244723) | |||
| 160030 | 160030 | 120045 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 855 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 5987560.38952 | 2110240.5290900003 | 37.7735999222489 | -122.48649141976401 | (37.7735999222489, -122.486491419764) | |||
| 70705 | 70705 | 120044 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 855 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 2ft | 5987560.8192300005 | 2110219.65608 | 37.77354263585371 | -122.486488400522 | (37.7735426358537, -122.486488400522) | |||
| 58338 | 58338 | 120043 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 855 27th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 2ft | 5987561.7468 | 2110191.3833 | 37.7734650607809 | -122.48648311573 | (37.7734650607809, -122.48648311573) | |||
| 36515 | 36515 | 120042 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 855 27th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 2ft | 5987562.19522 | 2110171.37929 | 37.7734101615057 | -122.48648009559601 | (37.7734101615057, -122.486480095596) | |||
| 168406 | 168406 | 181718 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2631 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5987497.3773 | 2107089.1929 | 37.764943555497204 | -122.486477965644 | (37.7649435554972, -122.486477965644) | |||
| 177553 | 177553 | 120041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 855 27th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 2ft | 5987564.26402 | 2110145.4730599998 | 37.7733391508378 | -122.486471036988 | (37.7733391508378, -122.486471036988) | |||
| 154392 | 154392 | 120040 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 855 27th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 2ft | 5987564.80136 | 2110119.38183 | 37.7732675429408 | -122.486467262272 | (37.7732675429408, -122.486467262272) | |||
| 48425 | 48425 | 120039 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 855 27th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 2ft | 5987565.05941 | 2110100.68571 | 37.7732162236667 | -122.486464996708 | (37.7732162236667, -122.486464996708) | |||
| 28004 | 28004 | 103180 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987448.1702 | 2104354.2995 | 37.757431419068496 | -122.486447346513 | (37.7574314190685, -122.486447346513) | |||
| 165655 | 165655 | 103189 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987449.3548 | 2104293.8827 | 37.7572656000244 | -122.48643881405899 | (37.7572656000244, -122.486438814059) | |||
| 133698 | 133698 | 103182 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987451.7241 | 2104232.2812 | 37.757096597166296 | -122.48642609757201 | (37.7570965971663, -122.486426097572) | |||
| 43434 | 43434 | 103190 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987454.6857 | 2104172.4568 | 37.7569325082599 | -122.486411463243 | (37.7569325082599, -122.486411463243) | |||
| 183697 | 183697 | 103183 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987454.6857 | 2104156.4641 | 37.756888596653496 | -122.486410289114 | (37.7568885966535, -122.486410289114) | |||
| 50310 | 50310 | 103191 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987457.055 | 2104097.8243 | 37.7567277258047 | -122.48639779019199 | (37.7567277258047, -122.486397790192) | |||
| 101740 | 101740 | 103168 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 9 | 3x4 | 5987451.7241 | 2103743.616 | 37.7557548552633 | -122.486390221731 | (37.7557548552633, -122.486390221731) | |||
| 68744 | 68744 | 103184 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987458.2396 | 2104042.7384 | 37.75657654394 | -122.48638964930001 | (37.75657654394, -122.4863896493) | |||
| 78445 | 78445 | 3400 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6409 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 5987669.913269999 | 2113931.4906 | 37.78374064449 | -122.48638360034501 | (37.78374064449, -122.486383600345) | |||
| 163633 | 163633 | 181719 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2625 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5987526.9046 | 2107090.374 | 37.7649485195953 | -122.48637592618601 | (37.7649485195953, -122.486375926186) | |||
| 44221 | 44221 | 103193 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987467.1245 | 2103820.0255 | 37.755965552668705 | -122.486342572342 | (37.7559655526687, -122.486342572342) | |||
| 144188 | 144188 | 121413 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2548 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5987616.0 | 2110573.0 | 37.774516035705204 | -122.486323470467 | (37.7745160357052, -122.486323470467) | |||
| 59227 | 59227 | 119987 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2512 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5987624.39432 | 2110538.98245 | 37.7744231223131 | -122.486291935366 | (37.7744231223131, -122.486291935366) | |||
| 27576 | 27576 | 103186 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 30617 | 30617 | 103185 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 87182 | 87182 | 103211 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 90017 | 90017 | 103176 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 92761 | 92761 | 103201 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 98449 | 98449 | 103215 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 107221 | 107221 | 103214 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 108349 | 108349 | 103203 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 110740 | 110740 | 103217 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 111672 | 111672 | 103212 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 119345 | 119345 | 103179 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 124904 | 124904 | 103177 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 126040 | 126040 | 103213 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 140247 | 140247 | 103204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 142111 | 142111 | 103178 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 142495 | 142495 | 103187 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 142733 | 142733 | 103174 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 146418 | 146418 | 120361 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6370 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5987804.81715 | 2113993.35945 | 37.783918381065796 | -122.48592143240101 | (37.7839183810658, -122.485921432401) | |||
| 94738 | 94738 | 3399 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6365X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5987823.49966 | 2113939.15914 | 37.7837706511265 | -122.485852819091 | (37.7837706511265, -122.485852819091) | |||
| 101564 | 101564 | 3398 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6365 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5987823.49966 | 2113939.15914 | 37.7837706511265 | -122.485852819091 | (37.7837706511265, -122.485852819091) | |||
| 77774 | 77774 | 696 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6337X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5987881.546 | 2113941.91653 | 37.7837816044506 | -122.485652205518 | (37.7837816044506, -122.485652205518) | |||
| 95526 | 95526 | 695 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6350X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5987883.41225 | 2113998.48777 | 37.7839370417256 | -122.485649902252 | (37.7839370417256, -122.485649902252) | |||
| 24473 | 24473 | 250486 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 220 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5987923.25995 | 2115358.25633 | 37.7876728999176 | -122.485611871313 | (37.7876728999176, -122.485611871313) | |||
| 127940 | 127940 | 3397 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6324 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5987932.77238 | 2113999.00859 | 37.7839413476536 | -122.48547917473499 | (37.7839413476536, -122.485479174735) | |||
| 27716 | 27716 | 250485 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 220 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5987961.74395 | 2115359.72592 | 37.7876791771886 | -122.485478833689 | (37.7876791771886, -122.485478833689) | |||
| 127016 | 127016 | 3396 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6321 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 5987935.30769 | 2113942.8269700003 | 37.783787236607296 | -122.485466279403 | (37.7837872366073, -122.485466279403) | |||
| 155951 | 155951 | 250484 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 220 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5987976.085519999 | 2115359.42161 | 37.7876791771865 | -122.485429192915 | (37.7876791771865, -122.485429192915) | |||
| 139413 | 139413 | 3395 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6310 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5987994.77671 | 2114001.6139599998 | 37.783952113511205 | -122.485264856466 | (37.7839521135112, -122.485264856466) | |||
| 176522 | 176522 | 120202 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 866 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5987918.9162800005 | 2110080.04526 | 37.773180170797204 | -122.485239459282 | (37.7731801707972, -122.485239459282) | |||
| 177367 | 177367 | 120203 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 866 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5987919.08307 | 2110067.03683 | 37.773144462992896 | -122.485237927661 | (37.7731444629929, -122.485237927661) | |||
| 42895 | 42895 | 120204 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 866 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5987919.36205 | 2110059.31636 | 37.77312328098721 | -122.485236396046 | (37.7731232809872, -122.485236396046) | |||
| 151128 | 151128 | 120232 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 130 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5988054.85126 | 2115121.2354200003 | 37.7870297745434 | -122.48513919923501 | (37.7870297745434, -122.485139199235) | |||
| 62263 | 62263 | 120233 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 130 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5988055.32763 | 2115108.91887 | 37.7869959845645 | -122.485136647097 | (37.7869959845645, -122.485136647097) | |||
| 161799 | 161799 | 120389 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5988121.9698 | 2115307.57202 | 37.7875453111265 | -122.484920662468 | (37.7875453111265, -122.484920662468) | |||
| 47973 | 47973 | 60229 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6242 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1982 12:00:00 AM | 13 | Permit Number 19780 | 5988145.31285 | 2114007.56926 | 37.783977233395 | -122.484744500147 | (37.783977233395, -122.484744500147) | ||
| 166978 | 166978 | 120486 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6239 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5988162.24056 | 2113950.69251 | 37.783822051832104 | -122.484681763608 | (37.7838220518321, -122.484681763608) | |||
| 85152 | 85152 | 3394 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6242 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 2X2 | 5988194.47177 | 2114010.9703900004 | 37.783989434808504 | -122.48457467993299 | (37.7839894348085, -122.484574679933) | |||
| 92944 | 92944 | 3392 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6235 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5988206.6436 | 2113951.80198 | 37.783827683957796 | -122.484528228961 | (37.7838276839578, -122.484528228961) | |||
| 54727 | 54727 | 120210 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 688 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5988189.72459 | 2111347.59136 | 37.7766762704864 | -122.484395694197 | (37.7766762704864, -122.484395694197) | |||
| 91713 | 91713 | 3388 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6200 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5988247.75648 | 2114010.88597 | 37.7839923058885 | -122.48439033038099 | (37.7839923058885, -122.484390330381) |
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");