Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantDate
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 589 | 589 | 26916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002555.1851 | 2113680.9302 | 37.783909052953 | -122.43486830704398 | (37.783909052953, -122.434868307044) | |||
| 1964 | 1964 | 238618 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 14 | Width 4ft | 6001078.53558 | 2101746.02342 | 37.751054810249 | -122.439121284114 | (37.751054810249, -122.439121284114) | |||
| 1974 | 1974 | 238616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001186.94921 | 2101750.3744 | 37.7510729252903 | -122.43874669133301 | (37.7510729252903, -122.438746691333) | |||
| 1975 | 1975 | 238619 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001066.93276 | 2101745.60422 | 37.7510529990026 | -122.43916137771099 | (37.7510529990026, -122.439161377711) | |||
| 2024 | 2024 | 139198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | Width 0ft | 6001803.3539 | 2113704.6103 | 37.783931357581395 | -122.437471057097 | (37.7839313575814, -122.437471057097) | |||
| 2033 | 2033 | 139199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | |||
| 5555 | 5555 | 8527 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002529.8149 | 2113677.2092 | 37.7838973955703 | -122.434955812258 | (37.7838973955703, -122.434955812258) | |||
| 6893 | 6893 | 8489 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002220.6585 | 2113766.2282 | 37.7841242607304 | -122.436031749589 | (37.7841242607304, -122.436031749589) | |||
| 7635 | 7635 | 8487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002304.7836 | 2113777.2973 | 37.7841594324943 | -122.43574149958401 | (37.7841594324943, -122.435741499584) | |||
| 8794 | 8794 | 8525 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002439.1587 | 2113663.3402 | 37.7838541670365 | -122.43526845642201 | (37.7838541670365, -122.435268456422) | |||
| 17375 | 17375 | 24541 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3x3 | 6007668.223019999 | 2097198.66884 | 37.7389415501992 | -122.416011415406 | (37.7389415501992, -122.416011415406) | |||
| 18045 | 18045 | 24537 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6007586.10322 | 2097213.8581 | 37.738978639151505 | -122.416296424042 | (37.7389786391515, -122.416296424042) | |||
| 19899 | 19899 | 24538 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6007606.23219 | 2097211.71423 | 37.7389738844263 | -122.416226675338 | (37.7389738844263, -122.416226675338) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 31420 | 31420 | 102369 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | Permit Number 769895 | 5984151.59861 | 2110096.53732 | 37.773005270668 | -122.49827212221099 | (37.773005270668, -122.498272122211) | |||
| 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) | |||
| 38057 | 38057 | 102379 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 5984156.57881 | 2110013.67242 | 37.772778039448106 | -122.49824877411999 | (37.7727780394481, -122.49824877412) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 77594 | 77594 | 8501 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 77843 | 77843 | 98421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 79290 | 79290 | 102162 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4300X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 5x5 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | |||
| 79428 | 79428 | 8492 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 80331 | 80331 | 102161 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4300X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 5x5 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | |||
| 80827 | 80827 | 8522 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 80842 | 80842 | 20504 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/1991 12:00:00 AM | 18 | 10 | 5984781.8902056 | 2107224.2505442 | 37.7651557239541 | -122.495879974111 | (37.7651557239541, -122.495879974111) | ||
| 81016 | 81016 | 27773 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 81037 | 81037 | 101512 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||||
| 81054 | 81054 | 2804 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 81945 | 81945 | 98430 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||||
| 82040 | 82040 | 8500 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 82310 | 82310 | 102159 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4300X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 34 | 6x6 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | |||
| 82553 | 82553 | 8498 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 83356 | 83356 | 98424 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||||
| 84542 | 84542 | 27772 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 85228 | 85228 | 8494 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 87002 | 87002 | 8502 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 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) | ||||
| 87286 | 87286 | 8528 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 88004 | 88004 | 27771 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 88529 | 88529 | 2808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3x3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 88707 | 88707 | 8482 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 89154 | 89154 | 8481 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 89735 | 89735 | 27770 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 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) | ||||
| 90660 | 90660 | 8490 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 90745 | 90745 | 98428 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||||
| 92516 | 92516 | 101511 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||||
| 92526 | 92526 | 98417 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 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) | ||||
| 94964 | 94964 | 8519 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 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) | ||||
| 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) | ||||
| 98915 | 98915 | 8499 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 99261 | 99261 | 98426 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 103189 | 103189 | 8504 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 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) | ||||
| 105834 | 105834 | 27768 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 105973 | 105973 | 8485 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 106245 | 106245 | 98420 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||||
| 106827 | 106827 | 98419 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||||
| 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) | ||||
| 107253 | 107253 | 20476 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 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) | ||||
| 109159 | 109159 | 2806 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 110591 | 110591 | 8497 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 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) | ||||
| 114003 | 114003 | 8493 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 115535 | 115535 | 8495 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 115677 | 115677 | 2805 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 65 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 115969 | 115969 | 20467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 116461 | 116461 | 8488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 117327 | 117327 | 98429 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||||
| 117568 | 117568 | 27769 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 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) | ||||
| 121289 | 121289 | 8496 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 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) | ||||
| 122255 | 122255 | 8484 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 123293 | 123293 | 102368 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4 | Permit Number 769895 | 5984151.13176 | 2110133.93549 | 37.7731079279349 | -122.49827649972 | (37.7731079279349, -122.49827649972) | |||
| 124222 | 124222 | 8479 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 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) | ||||
| 125042 | 125042 | 98427 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | |||
| 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) | ||||
| 126954 | 126954 | 2807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 128189 | 128189 | 8478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 128867 | 128867 | 101513 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) |
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");