Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, 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) | |||
| 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) | |||
| 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) | |||
| 10756 | 10756 | 110237 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Winston Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | 6x18 | 5989487.1744800005 | 2093569.3277200002 | 37.7279373404144 | -122.47860704469 | (37.7279373404144, -122.47860704469) | |||
| 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) | ||
| 18237 | 18237 | 203 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2912 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/02/1994 12:00:00 AM | 20 | 2X3 | 5990600.62302 | 2095815.8473599998 | 37.7341702996075 | -122.474921777626 | (37.7341702996075, -122.474921777626) | ||
| 17759 | 17759 | 220 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2950 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 10 | 3X3 | 5990607.61646 | 2095564.18629 | 37.7334797075204 | -122.474879236111 | (37.7334797075204, -122.474879236111) | ||
| 21117 | 21117 | 216 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2944 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 20 | 3X3 | 5990608.35114 | 2095598.99571 | 37.7335753279252 | -122.474879236093 | (37.7335753279252, -122.474879236093) | ||
| 20642 | 20642 | 248 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3050 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1994 12:00:00 AM | 20 | 2 | 5990629.27539 | 2094902.6887400001 | 37.7316646579979 | -122.474756091044 | (37.7316646579979, -122.474756091044) | ||
| 21787 | 21787 | 249 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3060 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1994 12:00:00 AM | 7 | 2 | 5990633.958819999 | 2094848.4163099998 | 37.7315159110224 | -122.47473593992201 | (37.7315159110224, -122.474735939922) | ||
| 20224 | 20224 | 254 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3080 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 12:00:00 AM | 13 | 2 | 5990635.11986 | 2094780.67442 | 37.7313299761991 | -122.474726983585 | (37.7313299761991, -122.474726983585) | ||
| 20338 | 20338 | 260 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4x4 | 5990641.60602 | 2094627.68915 | 37.730910293152796 | -122.474693398398 | (37.7309102931528, -122.474693398398) | |||
| 18283 | 18283 | 274 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3210 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 20 | 2X3 | 5990651.757780001 | 2094310.81175 | 37.730040816024704 | -122.47463518438101 | (37.7300408160247, -122.474635184381) | ||
| 85264 | 85264 | 261 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 12 | 2X3 | 5990658.74483 | 2094624.5636900002 | 37.730902704527395 | -122.474633919299 | (37.7309027045274, -122.474633919299) | ||
| 22098 | 22098 | 275 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3210 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 20 | 2X3 | 5990662.18152 | 2094375.08558 | 37.7302178997362 | -122.47460383761299 | (37.7302178997362, -122.474603837613) | ||
| 23110 | 23110 | 3325 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5241 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 2X2 | 5991316.3344 | 2114063.4230400003 | 37.784314761260205 | -122.47377811069401 | (37.7843147612602, -122.473778110694) | |||
| 21948 | 21948 | 413 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3854 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 8 | 2X3 | 5990824.06176 | 2090161.99601 | 37.7186591841634 | -122.47373697479401 | (37.7186591841634, -122.473736974794) | ||
| 105305 | 105305 | 104205 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 710X Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | ||||
| 113961 | 113961 | 104204 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 710X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | ||||
| 44181 | 44181 | 11759 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 126341 | 126341 | 11756 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 901X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 83981 | 83981 | 24017 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2000X 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 5991632.9262082 | 2101795.580568 | 37.7506488866129 | -122.47178846043998 | (37.7506488866129, -122.47178846044) | |||
| 110691 | 110691 | 3317 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5026 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3x3 | 5991959.38732 | 2114142.23783 | 37.7845683882136 | -122.471559138911 | (37.7845683882136, -122.471559138911) | |||
| 90383 | 90383 | 3318 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5027 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5991981.84742 | 2114090.3697599997 | 37.7844272721595 | -122.47147765453501 | (37.7844272721595, -122.471477654535) | |||
| 107832 | 107832 | 3314 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5000 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | 5992057.37454 | 2114146.49591 | 37.7845857480743 | -122.471220449792 | (37.7845857480743, -122.471220449792) | |||
| 62492 | 62492 | 2793 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5000 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 5992060.78894 | 2114166.03609 | 37.784639597517 | -122.471210061358 | (37.784639597517, -122.471210061358) | |||
| 16960 | 16960 | 24010 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 398 West Portal Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5991871.0543 | 2096731.9947 | 37.7367593513498 | -122.470596240632 | (37.7367593513498, -122.470596240632) | |||
| 22212 | 22212 | 24013 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 393 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5991924.8305 | 2096676.2373 | 37.7366093650749 | -122.470406255119 | (37.7366093650749, -122.470406255119) | |||
| 87851 | 87851 | 2794 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4925X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 5992356.55886 | 2114105.92278 | 37.7844916465572 | -122.470182426959 | (37.7844916465572, -122.470182426959) | |||
| 13182 | 13182 | 1306 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4001 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X6 | 5991941.83628 | 2087094.05513 | 37.7103000369794 | -122.469650093897 | (37.7103000369794, -122.469650093897) | |||
| 120813 | 120813 | 3306 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4844 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5992514.19125 | 2114192.3825 | 37.784738153030894 | -122.469643374035 | (37.7847381530309, -122.469643374035) | |||
| 78175 | 78175 | 24527 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 5992179.0560126 | 2097293.8308773 | 37.7383198170672 | -122.469572241334 | (37.7383198170672, -122.469572241334) | |||
| 96182 | 96182 | 24526 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 5992179.0560126 | 2097293.8308773 | 37.7383198170672 | -122.469572241334 | (37.7383198170672, -122.469572241334) | |||
| 117770 | 117770 | 24525 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 5992179.0560126 | 2097293.8308773 | 37.7383198170672 | -122.469572241334 | (37.7383198170672, -122.469572241334) | |||
| 125284 | 125284 | 24524 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5992179.0560126 | 2097293.8308773 | 37.7383198170672 | -122.469572241334 | (37.7383198170672, -122.469572241334) | |||
| 21180 | 21180 | 23998 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3x3 | 5992266.4507 | 2097161.921 | 37.737962676439295 | -122.46926047776199 | (37.7379626764393, -122.469260477762) | |||
| 13236 | 13236 | 23997 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 5992278.9042 | 2097174.0914 | 37.7379968129136 | -122.469218305818 | (37.7379968129136, -122.469218305818) | |||
| 22201 | 22201 | 24003 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 307 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3x3 | 5992304.2356 | 2097084.7947 | 37.7377530904378 | -122.46912422627899 | (37.7377530904378, -122.469124226279) | |||
| 21030 | 21030 | 24005 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 305 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992312.7265 | 2097093.0026 | 37.7377761178769 | -122.46909546659201 | (37.7377761178769, -122.469095466592) | |||
| 110072 | 110072 | 18 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2801X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5992314.354430901 | 2097139.1969018 | 37.737903049839396 | -122.469093199098 | (37.7379030498394, -122.469093199098) | |||
| 114915 | 114915 | 19 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2801X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5992314.354430901 | 2097139.1969018 | 37.737903049839396 | -122.469093199098 | (37.7379030498394, -122.469093199098) | |||
| 20436 | 20436 | 24004 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 305 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992316.406 | 2097102.9088 | 37.737803530407795 | -122.469083465646 | (37.7378035304078, -122.469083465646) | |||
| 86375 | 86375 | 24528 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2790X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992325.8515201 | 2097200.951756 | 37.7380732773929 | -122.469057941466 | (37.7380732773929, -122.469057941466) | |||
| 17105 | 17105 | 23993 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 288 West Portal Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | 5992331.2652 | 2097223.6221 | 37.738135837236705 | -122.469040873258 | (37.7381358372367, -122.469040873258) |
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");