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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58727 | 58727 | 110212 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2978 CESAR CHAVEZ ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x4 | 6009700.7 | 2100638.5 | 37.7485006383082 | -122.409226689451 | (37.7485006383082, -122.409226689451) | ||||
| 103678 | 103678 | 108035 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 945 Market St | unknown : Cutout 12 | Tree 1 | DPW 2 | 3x3 | Permit Number 774370 | 6010085.9126699995 | 2113154.0076 | 37.782886937251796 | -122.408777465126 | (37.7828869372518, -122.408777465126) | ||||
| 25 | 25 | 23567 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/27/1992 12:00:00 AM | 3 | 3X3 | 6005531.337230001 | 2120589.48411 | 37.803046726686894 | -122.42506362870199 | (37.8030467266869, -122.425063628702) | ||
| 72 | 72 | 25725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 729 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004286.7153 | 2111148.1106 | 37.777052715887706 | -122.428697236196 | (37.7770527158877, -122.428697236196) | |||
| 178 | 178 | 2985 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2253 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6003588.0004 | 2115559.2302 | 37.789124975971106 | -122.431429279776 | (37.7891249759711, -122.431429279776) | |||
| 227 | 227 | 13622 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 562 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6012358.746590001 | 2115584.5782 | 37.789687756343604 | -122.401085198325 | (37.7896877563436, -122.401085198325) | |||
| 243 | 243 | 2928 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1834 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005568.20527 | 2115901.70542 | 37.7901773571486 | -122.42460238530501 | (37.7901773571486, -122.424602385305) | |||
| 319 | 319 | 3139 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3320 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5998401.91704 | 2114901.9804700003 | 37.7870250535005 | -122.449325021743 | (37.7870250535005, -122.449325021743) | |||
| 345 | 345 | 13664 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 648 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6011893.33766 | 2115132.41268 | 37.788420242855395 | -122.402663664993 | (37.7884202428554, -122.402663664993) | |||
| 353 | 353 | 13824 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009889.5706 | 2113199.7435 | 37.7830015179357 | -122.40945995866699 | (37.7830015179357, -122.409459958667) | |||
| 367 | 367 | 235603 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 715 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006265.7166 | 2105404.69213 | 37.7613944596986 | -122.42144325851002 | (37.7613944596986, -122.42144325851) | |||
| 370 | 370 | 3092 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2980 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000114.4381800005 | 2115142.33295 | 37.7877828069853 | -122.443417371621 | (37.7877828069853, -122.443417371621) | |||
| 405 | 405 | 13887 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1028 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009423.7082400005 | 2112763.96692 | 37.781778865529105 | -122.411040866943 | (37.7817788655291, -122.411040866943) | |||
| 419 | 419 | 13971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008925.3091 | 2112314.2981 | 37.780516220741 | -122.412733301341 | (37.780516220741, -122.412733301341) | |||
| 449 | 449 | 200971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1408 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | Permit Number 779898 | 6007408.8361 | 2110843.7597 | 37.7763932439775 | -122.417875241075 | (37.7763932439775, -122.417875241075) | ||
| 453 | 453 | 200966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1438 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | Permit Number 779897 | 6007276.3996 | 2110716.1923 | 37.776035520315205 | -122.418324330264 | (37.7760355203152, -122.418324330264) | ||
| 477 | 477 | 14079 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1420 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779898 | 6007326.0633 | 2110762.9345 | 37.7761666587056 | -122.418155844592 | (37.7761666587056, -122.418155844592) | ||
| 480 | 480 | 200973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1416 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 489 | 489 | 200974 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1422 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 494 | 494 | 14085 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007257.8975 | 2110700.6115 | 37.775991697649104 | -122.418387229062 | (37.7759916976491, -122.418387229062) | ||
| 502 | 502 | 18680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150X Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 15X15TR | 5999310.287959999 | 2119651.54595 | 37.8001180187875 | -122.446524108406 | (37.8001180187875, -122.446524108406) | |||
| 535 | 535 | 13638 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 576 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6012273.72895 | 2115490.3220900004 | 37.7894242082171 | -122.40137272597799 | (37.7894242082171, -122.401372725978) | |||
| 614 | 614 | 2880 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1477 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007321.86349 | 2116079.14078 | 37.7907634327304 | -122.41854743611 | (37.7907634327304, -122.41854743611) | |||
| 732 | 732 | 25708 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 586 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6012145.80041 | 2110254.86265 | 37.77504171494321 | -122.40144725460199 | (37.7750417149432, -122.401447254602) | |||
| 748 | 748 | 195045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 312 06th St | 1 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010980.17572 | 2111476.79231 | 37.7783317443601 | -122.40556550564501 | (37.7783317443601, -122.405565505645) | |||
| 761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
| 778 | 778 | 100816 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 261 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6010798.79921 | 2111766.85068 | 37.779118033309395 | -122.406213398837 | (37.7791180333094, -122.406213398837) | |||
| 779 | 779 | 14058 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6007799.3288 | 2111218.6717 | 37.7774446311696 | -122.416550977219 | (37.7774446311696, -122.416550977219) | |||
| 889 | 889 | 3094 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3006 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 5999959.6352699995 | 2115120.4195 | 37.7877138091859 | -122.443951383666 | (37.7877138091859, -122.443951383666) | |||
| 958 | 958 | 139734 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1451 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6004831.5288 | 2113994.8119 | 37.784899873448204 | -122.42701535739799 | (37.7848998734482, -122.427015357398) | |||
| 989 | 989 | 2976 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2187 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X2 | 6003939.8571 | 2115601.6948 | 37.7892615083399 | -122.43021493095699 | (37.7892615083399, -122.430214930957) | |||
| 1066 | 1066 | 23276 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 819 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4x4 | 6006534.60812 | 2113350.76252 | 37.7832276265901 | -122.421077496141 | (37.7832276265901, -122.421077496141) | |||
| 1075 | 1075 | 245468 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3290 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 9 | Width 0ft | 6006293.2609 | 2099139.2598 | 37.7441925761806 | -122.420903147917 | (37.7441925761806, -122.420903147917) | ||
| 1163 | 1163 | 2939 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1910 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6005122.54257 | 2115837.0032200003 | 37.789974522242105 | -122.42613973678499 | (37.7899745222421, -122.426139736785) | |||
| 1168 | 1168 | 218199 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 819 Ulloa St | 1 | : 4 | Tree 1 | DPW 2 | 13 | Width 3ft | 5993346.67502 | 2098141.32486 | 37.740714236277 | -122.46559677389799 | (37.740714236277, -122.465596773898) | |||
| 1218 | 1218 | 23334 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6006464.90313 | 2114643.01968 | 37.7867719177417 | -122.42141044944701 | (37.7867719177417, -122.421410449447) | |||
| 1238 | 1238 | 3124 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998922.57289 | 2114976.7733400003 | 37.7872601830687 | -122.44752906213199 | (37.7872601830687, -122.447529062132) | |||
| 1253 | 1253 | 3161 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3445 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5997946.3873 | 2114759.1135 | 37.7866067115462 | -122.450890739631 | (37.7866067115462, -122.450890739631) | |||
| 1284 | 1284 | 235428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2869 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | 3x3 | 6010306.81938 | 2100635.6894799997 | 37.74852686004171 | -122.40713053105101 | (37.7485268600417, -122.407130531051) | ||
| 1285 | 1285 | 234575 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2990 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009677.1610900005 | 2100624.0529099996 | 37.7484596510092 | -122.409307067568 | (37.7484596510092, -122.409307067568) | ||
| 1291 | 1291 | 234571 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2892 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x4 | 6010196.53099 | 2100680.54575 | 37.7486438528311 | -122.407515070373 | (37.7486438528311, -122.407515070373) | ||
| 1292 | 1292 | 3043 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2669 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6001621.1928 | 2115287.1562 | 37.7882662649831 | -122.43821467397 | (37.7882662649831, -122.43821467397) | |||
| 1330 | 1330 | 2943 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1946 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 4X4 | 6005029.19291 | 2115824.37334 | 37.7899345671834 | -122.426461819067 | (37.7899345671834, -122.426461819067) | |||
| 1588 | 1588 | 246373 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2248 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | 6003269.4472 | 2106896.8842 | 37.7653222658326 | -122.431912650355 | (37.7653222658326, -122.431912650355) | |||
| 1655 | 1655 | 13618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 554 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4x4 | 6012397.92719 | 2115620.9372799997 | 37.7897897754213 | -122.400952192186 | (37.7897897754213, -122.400952192186) | |||
| 1664 | 1664 | 26404 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996581.1026099995 | 2115987.02812 | 37.7898999837554 | -122.455703055979 | (37.7898999837554, -122.455703055979) | |||
| 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 | |||||||||
| 1732 | 1732 | 134349 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 4ft | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
| 1741 | 1741 | 28362 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3467 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 6 | 4x4 | 6005809.8912 | 2098114.7936 | 37.7413523657119 | -122.422501756572 | (37.7413523657119, -122.422501756572) | ||
| 1755 | 1755 | 13965 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1127 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008823.0 | 2112045.0 | 37.7797710494845 | -122.413068191044 | (37.7797710494845, -122.413068191044) | |||
| 1774 | 1774 | 3070 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2860 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000658.3248 | 2115217.6526099998 | 37.788020616507104 | -122.44154103868799 | (37.7880206165071, -122.441541038688) | |||
| 1831 | 1831 | 28370 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2005 12:00:00 AM | 3 | 2X3 | 6001320.7065 | 2112568.2554 | 37.780783765197604 | -122.43905936736999 | (37.7807837651976, -122.43905936737) | ||
| 1847 | 1847 | 23549 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2835 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2011 12:00:00 AM | 3 | 3x3 | 6005591.52339 | 2120155.8854900002 | 37.8018595757201 | -122.424824487257 | (37.8018595757201, -122.424824487257) | ||
| 1914 | 1914 | 99186 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1961 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:44:00 AM | 3 | 3x3 | 6005002.72434 | 2115722.82694 | 37.7896542499749 | -122.426546164276 | (37.7896542499749, -122.426546164276) | ||
| 2051 | 2051 | 3179 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3560 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X2 | 5997388.758280001 | 2114760.01365 | 37.7865772450958 | -122.45282005522101 | (37.7865772450958, -122.452820055221) | |||
| 2064 | 2064 | 23285 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 850 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006625.13758 | 2113482.84587 | 37.783595398064996 | -122.42077367996401 | (37.783595398065, -122.420773679964) | |||
| 2131 | 2131 | 2996 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6003308.145280001 | 2115585.18188 | 37.7891803678189 | -122.43239939681801 | (37.7891803678189, -122.432399396818) | |||
| 2203 | 2203 | 8461 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1877 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002698.7987 | 2113699.0733 | 37.7839670221208 | -122.43437275514 | (37.7839670221208, -122.43437275514) | |||
| 2285 | 2285 | 2664 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2018 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003759.2529 | 2114943.4782 | 37.78744398103571 | -122.430792808025 | (37.7874439810357, -122.430792808025) | |||
| 2468 | 2468 | 2848 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1275 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008247.47804 | 2116208.39434 | 37.7911703975462 | -122.415354000191 | (37.7911703975462, -122.415354000191) | |||
| 2556 | 2556 | 10689 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1230 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001934.2005 | 2110513.7359 | 37.775177459697396 | -122.436789881705 | (37.7751774596974, -122.436789881705) | |||
| 3000 | 3000 | 2847 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1271 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008300.20428 | 2116215.33736 | 37.791192424647 | -122.415172060143 | (37.791192424647, -122.415172060143) | |||
| 3055 | 3055 | 27261 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1430 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006341.72123 | 2115482.85367 | 37.789070948203296 | -122.421896309963 | (37.7890709482033, -122.421896309963) | |||
| 3110 | 3110 | 3090 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2970 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000158.190669999 | 2115149.23104 | 37.7878042423257 | -122.443266492369 | (37.7878042423257, -122.443266492369) | |||
| 3144 | 3144 | 18663 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 55 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999555.8589699995 | 2119313.6235700003 | 37.7992041978826 | -122.445650026744 | (37.7992041978826, -122.445650026744) | |||
| 3161 | 3161 | 13804 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6010106.2877 | 2113414.5576 | 37.7836034869676 | -122.408725362824 | (37.7836034869676, -122.408725362824) | |||
| 3216 | 3216 | 23266 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006650.95952 | 2113278.63532 | 37.7830361411562 | -122.42066984425301 | (37.7830361411562, -122.420669844253) | |||
| 3323 | 3323 | 23495 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2526 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005841.8244199995 | 2119085.6949400003 | 37.7989352394136 | -122.423882184811 | (37.7989352394136, -122.423882184811) | |||
| 3376 | 3376 | 21619 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005002.8394 | 2114768.031 | 37.7870326258746 | -122.42647775301799 | (37.7870326258746, -122.426477753018) | |||
| 3404 | 3404 | 9412 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006178.48219 | 2112500.02959 | 37.780871640264 | -122.422249088827 | (37.780871640264, -122.422249088827) | |||
| 3443 | 3443 | 23525 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2750 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005736.3490699995 | 2119811.18986 | 37.800921308526895 | -122.424298792155 | (37.8009213085269, -122.424298792155) | |||
| 3480 | 3480 | 23466 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2307 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6005840.38038 | 2118370.08378 | 37.796970271119 | -122.42383626993 | (37.796970271119, -122.42383626993) | |||
| 3507 | 3507 | 200856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1117 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | Permit Number 780155 | 6008896.2254 | 2112159.7462 | 37.7800902256084 | -122.412822986117 | (37.7800902256084, -122.412822986117) | ||
| 3515 | 3515 | 13941 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 780155 | 6008943.5856 | 2112207.5707 | 37.780224198497294 | -122.412662526962 | (37.7802241984973, -122.412662526962) | ||
| 3521 | 3521 | 2864 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1365 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6007820.57137 | 2116146.85538 | 37.790977423709606 | -122.416826726397 | (37.7909774237096, -122.416826726397) | |||
| 3536 | 3536 | 14030 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1240 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008102.1797 | 2111505.9419 | 37.77825043397171 | -122.415523656395 | (37.7782504339717, -122.415523656395) | |||
| 3578 | 3578 | 13841 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 974 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6009799.5639 | 2113118.5178 | 37.7827734478984 | -122.409765610889 | (37.7827734478984, -122.409765610889) | |||
| 3783 | 3783 | 3103 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3054 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999732.37649 | 2115089.7661599996 | 37.7876166770259 | -122.444735448586 | (37.7876166770259, -122.444735448586) | |||
| 3789 | 3789 | 13832 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 970 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009846.7625 | 2113163.5212 | 37.7828996614361 | -122.409605500316 | (37.7828996614361, -122.409605500316) | |||
| 3797 | 3797 | 2973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2174 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6004006.64752 | 2115684.29812 | 37.789492098924605 | -122.429989738932 | (37.7894920989246, -122.429989738932) | |||
| 3828 | 3828 | 3019 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2490 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6002471.3865 | 2115470.57138 | 37.7888181937655 | -122.43528627363999 | (37.7888181937655, -122.43528627364) | |||
| 3876 | 3876 | 5847 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 923 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005978.31191 | 2113111.7315700003 | 37.7825399312178 | -122.422985066108 | (37.7825399312178, -122.422985066108) | |||
| 4086 | 4086 | 29091 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 281 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6009517.223019999 | 2113949.77701 | 37.785040060898794 | -122.41080112117399 | (37.7850400608988, -122.410801121174) | ||
| 4232 | 4232 | 8321 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 11:49:00 AM | 3 | 3x5 | 6006287.59901 | 2114197.2943700003 | 37.785538067679795 | -122.421992205597 | (37.7855380676798, -122.421992205597) | ||
| 4461 | 4461 | 3010 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2408 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 12:00:00 AM | 30 | 3X3 | 6002770.31768 | 2115511.22109 | 37.788946778816296 | -122.434254922131 | (37.7889467788163, -122.434254922131) | ||
| 4574 | 4574 | 133622 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 45 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2014 02:11:00 PM | 2 | Width 3ft | 5999573.26075 | 2119295.26208 | 37.799154775636296 | -122.44558848973499 | (37.7991547756363, -122.445588489735) | ||
| 4609 | 4609 | 14021 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1212 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008197.125 | 2111596.9919 | 37.778505771849204 | -122.415201651543 | (37.7785057718492, -122.415201651543) | |||
| 4642 | 4642 | 195899 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Carpenter Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 5 | Width 3ft | 6016597.78422 | 2095457.48988 | 37.734658629697705 | -122.385015545451 | (37.7346586296977, -122.385015545451) | ||
| 4679 | 4679 | 13767 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010614.78099 | 2113901.0025400002 | 37.7849676168973 | -122.407000460322 | (37.7849676168973, -122.407000460322) | |||
| 4912 | 4912 | 2851 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1301 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008052.73879 | 2116180.4668400004 | 37.791082768494704 | -122.416025815338 | (37.7910827684947, -122.416025815338) | |||
| 5075 | 5075 | 2884 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007112.23244 | 2116045.7287 | 37.7906598875046 | -122.419270379518 | (37.7906598875046, -122.419270379518) | |||
| 5132 | 5132 | 22967 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 545 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1995 12:00:00 AM | 13 | 3x3 | 6006209.68052 | 2106410.0153 | 37.764151681274 | -122.421708472183 | (37.764151681274, -122.421708472183) | ||
| 5220 | 5220 | 3005 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2370 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6003025.35785 | 2115546.48182 | 37.7890580681313 | -122.43337503892599 | (37.7890580681313, -122.433375038926) | |||
| 5275 | 5275 | 2881 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1492 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007231.00292 | 2116132.4326400002 | 37.7909046433826 | -122.418865591085 | (37.7909046433826, -122.418865591085) | |||
| 5290 | 5290 | 3042 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2659 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X2 | 6001671.4248 | 2115295.2706 | 37.788291401826896 | -122.438041461404 | (37.7882914018269, -122.438041461404) | |||
| 5317 | 5317 | 13907 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1066X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6009309.59321 | 2112668.0666400003 | 37.7815091462639 | -122.411428875842 | (37.7815091462639, -122.411428875842) | |||
| 5364 | 5364 | 23306 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/21/2014 12:00:00 AM | 3 | 3x3 | 6006548.97728 | 2113995.14899 | 37.7849977639855 | -122.421073553515 | (37.7849977639855, -122.421073553515) | ||
| 5425 | 5425 | 23521 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005630.35639 | 2119875.62237 | 37.8010922381722 | -122.424670158212 | (37.8010922381722, -122.424670158212) | |||
| 5427 | 5427 | 13811 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 950 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6009945.3672 | 2113281.8965 | 37.7832302167434 | -122.40927272378201 | (37.7832302167434, -122.409272723782) | |||
| 5428 | 5428 | 24310 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2639 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 6006900.22287 | 2121405.53505 | 37.80536462583971 | -122.420384516339 | (37.8053646258397, -122.420384516339) |
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");