Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1665 | 1665 | 251650 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | |||||||||
| 1954 | 1954 | 20331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 8246 | 8246 | 20349 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 9565 | 9565 | 20409 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 9606 | 9606 | 20333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 10242 | 10242 | 20328 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 11483 | 11483 | 20348 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 12000 | 12000 | 20347 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 8 | ||||||||
| 12183 | 12183 | 20411 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 12674 | 12674 | 20327 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 12828 | 12828 | 20459 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 495X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 14471 | 14471 | 20350 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 14576 | 14576 | 20410 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 18484 | 18484 | 12450 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 84810 | 84810 | 12452 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 104060 | 104060 | 12451 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 122168 | 122168 | 12453 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 127553 | 127553 | 12454 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 127742 | 127742 | 12455 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 103884 | 103884 | 21495 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2792X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 95597 | 95597 | 3437 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
| 128508 | 128508 | 3428 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6941 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5986006.25381 | 2113811.6066799997 | 37.783314366378995 | -122.492130323992 | (37.783314366379, -122.492130323992) | |||
| 117646 | 117646 | 724 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6933X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5986042.95345 | 2113873.6493599997 | 37.783486862959705 | -122.492007929 | (37.7834868629597, -122.492007929) | |||
| 91298 | 91298 | 722 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6920X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5986139.11309 | 2113930.71339 | 37.7836491646774 | -122.491679460735 | (37.7836491646774, -122.491679460735) | |||
| 82840 | 82840 | 720 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6910X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5986168.89485 | 2113931.77767 | 37.7836538273778 | -122.491576507002 | (37.7836538273778, -122.491576507002) | |||
| 114035 | 114035 | 719 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6910X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3 | 5986168.89485 | 2113931.77767 | 37.7836538273778 | -122.491576507002 | (37.7836538273778, -122.491576507002) | |||
| 117882 | 117882 | 717 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 5 | 5986305.22988 | 2113941.78658 | 37.783689275454705 | -122.49110558308901 | (37.7836892754547, -122.491105583089) | |||
| 138348 | 138348 | 716 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 5x33 | 5986347.76159 | 2113942.4719599998 | 37.783693642189 | -122.490958491989 | (37.783693642189, -122.490958491989) | |||
| 88068 | 88068 | 713 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 145405 | 145405 | 709 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 5 | 5986789.82302 | 2113953.9673099997 | 37.783751021306 | -122.489429993159 | (37.783751021306, -122.489429993159) | |||
| 81219 | 81219 | 117257 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1570 31ST AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 140211 | 140211 | 3387 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6200 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5988301.33129 | 2114012.10233 | 37.7839987651441 | -122.484205072614 | (37.7839987651441, -122.484205072614) | |||
| 139856 | 139856 | 3386 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6152 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5988425.935319999 | 2114057.38014 | 37.7841303393164 | -122.483777314335 | (37.7841303393164, -122.483777314335) | |||
| 78960 | 78960 | 3377 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6026 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5988824.08285 | 2114030.31598 | 37.784079197409 | -122.482397899402 | (37.784079197409, -122.482397899402) | |||
| 121762 | 121762 | 3376 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6017 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5988872.14094 | 2113977.9734 | 37.783938274924104 | -122.48222780161001 | (37.7839382749241, -122.48222780161) | |||
| 106082 | 106082 | 3375 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6014 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5988885.08306 | 2114033.4959299997 | 37.78409147689621 | -122.482187096251 | (37.7840914768962, -122.482187096251) | |||
| 104117 | 104117 | 3371 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5946 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5989086.17579 | 2114041.98015 | 37.784126466602004 | -122.481492017597 | (37.784126466602, -122.481492017597) | |||
| 107070 | 107070 | 200 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5604X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4x4 | 5990186.04567 | 2114081.13509 | 37.784297864805104 | -122.477689766774 | (37.7842978648051, -122.477689766774) | |||
| 117308 | 117308 | 3337 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5431 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 2x2 | 5990692.309280001 | 2114048.27624 | 37.784237010377495 | -122.475935890046 | (37.7842370103775, -122.475935890046) | |||
| 12562 | 12562 | 206 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2919 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 6 | 2X3 | 5990516.43657 | 2095785.37905 | 37.734081762249296 | -122.475210610191 | (37.7340817622493, -122.475210610191) | ||
| 13169 | 13169 | 226 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2965 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2X3 | 5990527.81867 | 2095496.22007 | 37.7332884648813 | -122.475150156876 | (37.7332884648813, -122.475150156876) | |||
| 11508 | 11508 | 231 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2000 12:00:00 AM | 16 | 2 | 5990528.9249599995 | 2095425.9012900002 | 37.7330954514847 | -122.475141200519 | (37.7330954514847, -122.475141200519) | ||
| 12538 | 12538 | 230 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2 | 5990529.537280001 | 2095454.9094099998 | 37.7331751359068 | -122.475141200505 | (37.7331751359068, -122.475141200505) | |||
| 104705 | 104705 | 17174 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2999X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2 | 5990529.29755 | 2095287.65599 | 37.732715886567995 | -122.475129823758 | (37.732715886568, -122.475129823758) | |||
| 11341 | 11341 | 241 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990539.35496 | 2095091.6143599998 | 37.73217818885811 | -122.47508074718701 | (37.7321781888581, -122.475080747187) | ||
| 11685 | 11685 | 242 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990541.155259999 | 2095054.1708099998 | 37.7320754826964 | -122.47507179083401 | (37.7320754826964, -122.475071790834) | ||
| 12400 | 12400 | 243 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3027 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990541.3262 | 2095031.59495 | 37.732013505011295 | -122.475069552433 | (37.7320135050113, -122.475069552433) | ||
| 11463 | 11463 | 244 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3027 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 20 | 2 | 5990542.03599 | 2095003.8484200002 | 37.731937361205 | -122.475065073818 | (37.731937361205, -122.475065073818) | ||
| 11923 | 11923 | 87592 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3039 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5990542.943940001 | 2094954.8149599999 | 37.731802780363104 | -122.475058356779 | (37.7318027803631, -122.475058356779) | ||||
| 5212 | 5212 | 291 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1994 12:00:00 AM | 20 | 2x10 | 5990518.299980001 | 2093633.8541299999 | 37.7281743270786 | -122.475047162015 | (37.7281743270786, -122.475047162015) | ||
| 11895 | 11895 | 292 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990518.982340001 | 2093604.8167400002 | 37.7280946372571 | -122.475042684288 | (37.7280946372571, -122.475042684288) | ||
| 5237 | 5237 | 290 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2017 12:00:00 AM | 25 | 2X2 | 5990524.87284 | 2093730.4583599998 | 37.728439958917704 | -122.47503148863001 | (37.7284399589177, -122.47503148863) | ||
| 10577 | 10577 | 289 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/1994 12:00:00 AM | 25 | 2 | 5990526.76624 | 2093758.79648 | 37.7285178779945 | -122.475027010894 | (37.7285178779945, -122.475027010894) | ||
| 12467 | 12467 | 288 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 18 | 2 | 5990528.50995 | 2093780.0430700001 | 37.7285763168388 | -122.475022533176 | (37.7285763168388, -122.475022533176) | ||
| 11974 | 11974 | 256 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3095 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990551.14028 | 2094790.83071 | 37.7313529961409 | -122.475018054557 | (37.7313529961409, -122.475018054557) | |||
| 12261 | 12261 | 285 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1998 12:00:00 AM | 20 | 2 | 5990533.55676 | 2093865.7150400002 | 37.728811842983106 | -122.47501133751999 | (37.7288118429831, -122.47501133752) | ||
| 13129 | 13129 | 286 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1998 12:00:00 AM | 20 | 2 | 5990533.76855 | 2093845.0720799998 | 37.728755174887795 | -122.475009099088 | (37.7287551748878, -122.475009099088) |
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");