Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| 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) | ||||
| 77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
| 84244 | 84244 | 105061 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 163 10TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 4x3 | 5992696.3 | 2114396.0 | 37.785307754338 | -122.46902816717301 | (37.785307754338, -122.469028167173) | ||||
| 91425 | 91425 | 89009 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Chestnut St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2008 12:00:00 AM | Permit Number 51761 | 6007996.0 | 2120667.0 | 37.8033984824 | -122.41654007794399 | (37.8033984824, -122.416540077944) | ||||
| 96282 | 96282 | 104677 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 65 ZIRCON PL | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770985 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 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) | ||||
| 115200 | 115200 | 89149 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 941 North Point St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51802 | 6006240.0 | 2121411.0 | 37.805342404746796 | -122.42266969571199 | (37.8053424047468, -122.422669695712) | |||
| 118422 | 118422 | 112428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2819 JACKSON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | 3x3 | 6000608.0 | 2116457.0 | 37.7914206746057 | -122.441804136035 | (37.7914206746057, -122.441804136035) | ||||
| 119445 | 119445 | 88345 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 347 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51330 | 6003917.0 | 2091407.0 | 37.7228273068445 | -122.428568687279 | (37.7228273068445, -122.428568687279) | |||
| 120786 | 120786 | 88742 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 11 Surrey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51677 | 6002796.0 | 2095846.0 | 37.7349522946532 | -122.432760693841 | (37.7349522946532, -122.432760693841) | |||
| 122925 | 122925 | 88701 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 738 Hayes St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51651 | 6004318.0 | 2110848.0 | 37.7762304564773 | -122.428567615262 | (37.7762304564773, -122.428567615262) | |||
| 124271 | 124271 | 107940 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 960 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | Permit Number 768645 | 6011630.15925 | 2111363.9344099998 | 37.7780581861375 | -122.403309017255 | (37.7780581861375, -122.403309017255) | |||
| 126458 | 126458 | 97252 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4391 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768116 | 6001406.8 | 2100528.2 | 37.747729630859496 | -122.43789889633001 | (37.7477296308595, -122.43789889633) | |||||
| 139222 | 139222 | 111092 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 801 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 2 | Permit Number 775593 | 5988333.0 | 2089769.0 | 37.717435525652704 | -122.48231868452 | (37.7174355256527, -122.48231868452) | |||
| 143587 | 143587 | 104820 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 CASTRO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002463.2 | 2104094.7 | 37.757582407620504 | -122.434500892974 | (37.7575824076205, -122.434500892974) | ||||
| 145649 | 145649 | 107453 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1817 JACKSON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774262 | 6005381.0 | 2117121.5 | 37.793516032231395 | -122.425336940693 | (37.7935160322314, -122.425336940693) | |||
| 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) | ||
| 28 | 28 | 21823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2741 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 4x4 | 6008229.33947 | 2122327.41953 | 37.8079706947476 | -122.415850241604 | (37.8079706947476, -122.415850241604) | ||
| 33 | 33 | 2889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1545 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6006951.47041 | 2116025.01423 | 37.79059395549061 | -122.419825138035 | (37.7905939554906, -122.419825138035) | |||
| 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) | |||
| 203 | 203 | 134565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 15 | Width 4ft | 6007431.26589 | 2111583.6583 | 37.7784260904314 | -122.41785010990299 | (37.7784260904314, -122.417850109903) | |||
| 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) | |||
| 356 | 356 | 5230 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1051 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2004 12:00:00 AM | 3 | 4x4 | 6001389.4157 | 2112056.3671 | 37.7793821590717 | -122.43878497743201 | (37.7793821590717, -122.438784977432) | ||
| 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) | |||
| 408 | 408 | 23369 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 6006387.07969 | 2115184.64805 | 37.788254707334 | -122.421718185767 | (37.788254707334, -122.421718185767) | |||
| 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) | |||
| 422 | 422 | 23174 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 5 | 3x3 | 6006908.21847 | 2111432.04348 | 37.777980343250796 | -122.419648771078 | (37.7779803432508, -122.419648771078) | |||
| 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) | ||
| 476 | 476 | 174954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4xt | Permit Number 779898 | 6007316.0 | 2110809.0 | 37.776292577113104 | -122.418193923043 | (37.7762925771131, -122.418193923043) | |||
| 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) | |||
| 521 | 521 | 5204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 777 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/21/2016 12:00:00 AM | 3 | 4X4 | 6001528.9942 | 2111019.6475 | 37.7765435284866 | -122.438227828795 | (37.7765435284866, -122.438227828795) | |
| 534 | 534 | 2998 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2314 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003265.59996 | 2115577.92692 | 37.7891580349704 | -122.43254607984501 | (37.7891580349704, -122.432546079845) | |||
| 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) | |||
| 550 | 550 | 3006 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2380 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002989.49365 | 2115542.57517 | 37.7890453067372 | -122.433498845012 | (37.7890453067372, -122.433498845012) | |||
| 567 | 567 | 195068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
| 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) | |||
| 777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
| 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) | |||
| 861 | 861 | 109545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006870.4118800005 | 2111707.44564 | 37.778734401395205 | -122.419799104459 | (37.7787344013952, -122.419799104459) | |||
| 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) | |||
| 1061 | 1061 | 7724 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 211 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 767727 | 6006415.79653 | 2110907.1088900003 | 37.7765112494182 | -122.421314949539 | (37.7765112494182, -122.421314949539) | |
| 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) | ||
| 1085 | 1085 | 245467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3286 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2004 12:00:00 AM | 6 | Width 0ft | 6006306.9956 | 2099162.9834 | 37.7442584900037 | -122.42085734017799 | (37.7442584900037, -122.420857340178) | ||
| 1136 | 1136 | 3286 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4620 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5993188.57682 | 2114188.1560400003 | 37.784765502430794 | -122.467309935148 | (37.7847655024308, -122.467309935148) | |||
| 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) | |||
| 1198 | 1198 | 3004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2361 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003049.1023 | 2115481.5645 | 37.788881168762295 | -122.433288245694 | (37.7888811687623, -122.433288245694) | |||
| 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) | |||
| 1415 | 1415 | 9957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 165X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 4x4 | 6007023.214790001 | 2111521.59802 | 37.778232715494205 | -122.41925731148399 | (37.7782327154942, -122.419257311484) | |||
| 1478 | 1478 | 2891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1555 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6006907.6574099995 | 2116020.89539 | 37.7905801778777 | -122.419976436385 | (37.7905801778777, -122.419976436385) | |||
| 1506 | 1506 | 3068 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2848 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000738.310819999 | 2115229.75603 | 37.788058406004296 | -122.441265170758 | (37.7880584060043, -122.441265170758) | |||
| 1584 | 1584 | 3173 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3506 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1992 12:00:00 AM | 6 | 3X3 | 5997608.68374 | 2114790.70836 | 37.786674124564 | -122.45206138623301 | (37.786674124564, -122.452061386233) | ||
| 1586 | 1586 | 98725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006216.75471 | 2111460.37935 | 37.7780191723707 | -122.42204280683501 | (37.7780191723707, -122.422042806835) | |||
| 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 | |||||||||
| 1692 | 1692 | 2957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2045 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004590.8896 | 2115694.3359 | 37.7895527302687 | -122.427969040021 | (37.7895527302687, -122.427969040021) | |||
| 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) | |||
| 1733 | 1733 | 200858 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
| 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) | ||
| 1888 | 1888 | 100797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2471 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002362.24857 | 2116725.90576 | 37.7922588209311 | -122.435753725979 | (37.7922588209311, -122.435753725979) | |||
| 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) | ||
| 1925 | 1925 | 2958 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2055 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004523.0139999995 | 2115687.6045 | 37.7895304073237 | -122.428203402517 | (37.7895304073237, -122.428203402517) | |||
| 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) | |||
| 2088 | 2088 | 3013 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2450 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002627.84431 | 2115492.11411 | 37.7888862283618 | -122.43474649336599 | (37.7888862283618, -122.434746493366) | |||
| 2114 | 2114 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001231.007069999 | 2116743.47753 | 37.7922427464694 | -122.43966909537599 | (37.7922427464694, -122.439669095376) | |||
| 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) | |||
| 2167 | 2167 | 3158 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3410 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998012.98689 | 2114846.6357400003 | 37.7868508368504 | -122.45066663485201 | (37.7868508368504, -122.450666634852) |
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");