Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 36 | 36 | 13434 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014136.36792 | 2117295.16476 | 37.7944836321678 | -122.39505462349199 | (37.7944836321678, -122.395054623492) | |||
| 55 | 55 | 2909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6006037.49643 | 2115968.63965 | 37.7903876339283 | -122.422983431149 | (37.7903876339283, -122.422983431149) | |||
| 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) | |||
| 75 | 75 | 138824 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 729 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6004305.1004 | 2111150.1162 | 37.77705926326529 | -122.428633779399 | (37.7770592632653, -122.428633779399) | |||
| 111 | 111 | 7749 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6006371.15759 | 2111615.2483900003 | 37.7784531123456 | -122.421519673008 | (37.7784531123456, -122.421519673008) | |||
| 157 | 157 | 3193 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3698 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5996969.37189 | 2114704.2549799997 | 37.7864001056199 | -122.454266992435 | (37.7864001056199, -122.454266992435) | |||
| 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) | |||
| 180 | 180 | 18700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999457.6873699995 | 2119517.78462 | 37.799759164102895 | -122.44600442526199 | (37.7997591641029, -122.446004425262) | |||
| 200 | 200 | 134567 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 07/06/2011 12:00:00 AM | 4 | Width 4ft | 6007561.6986 | 2111595.58464 | 37.778466176805296 | -122.417399738421 | (37.7784661768053, -122.417399738421) | ||
| 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) | |||
| 205 | 205 | 134566 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 14 | Width 4ft | 6007493.55732 | 2111589.9734900002 | 37.7784469358085 | -122.417635067622 | (37.7784469358085, -122.417635067622) | |||
| 209 | 209 | 134568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 5 | Width 4ft | 6007669.37768 | 2111613.23365 | 37.778520694605795 | -122.41702848568501 | (37.7785206946058, -122.417028485685) | ||
| 210 | 210 | 13438 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2002 12:00:00 AM | 6 | 4x4 | 6014077.43398 | 2117238.82075 | 37.794325647358704 | -122.395254594939 | (37.7943256473587, -122.395254594939) | ||
| 214 | 214 | 251244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/29/2013 12:00:00 AM | 6007340.02606 | 2111591.01475 | 37.778441154342296 | -122.41816626519301 | (37.7784411543423, -122.418166265193) | ||||
| 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) | |||
| 248 | 248 | 23733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6003923.026000001 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | |||
| 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) | |||
| 346 | 346 | 235602 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 721 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006265.751680001 | 2105377.56697 | 37.761319982338904 | -122.421441210755 | (37.7613199823389, -122.421441210755) | |||
| 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) | |||
| 418 | 418 | 23307 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2014 12:00:00 AM | 2 | 3x3 | 6006542.6232900005 | 2114014.0044299997 | 37.785049178209206 | -122.421096875635 | (37.7850491782092, -122.421096875635) | ||
| 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) | |||
| 423 | 423 | 109554 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006839.87541 | 2111919.81075 | 37.7793157843461 | -122.41991981597201 | (37.7793157843461, -122.419919815972) | |||
| 425 | 425 | 251299 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 428 | 428 | 14314 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6003589.1349 | 2107204.4091 | 37.766184772649495 | -122.430828874247 | (37.7661847726495, -122.430828874247) | |||
| 431 | 431 | 251298 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 432 | 432 | 251297 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 435 | 435 | 95185 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001223.4102 | 2113260.1588 | 37.78267801898829 | -122.43944557401699 | (37.7826780189883, -122.439445574017) | |||
| 446 | 446 | 251296 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 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) | ||
| 481 | 481 | 14087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.775888228839705 | -122.418499137854 | (37.7758882288397, -122.418499137854) | ||
| 488 | 488 | 2821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008831.67633 | 2116355.92064 | 37.7916082855564 | -122.41334312239701 | (37.7916082855564, -122.413343122397) | |||
| 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) | ||
| 493 | 493 | 14089 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 779892 | 6007243.2905 | 2110686.0046 | 37.7759507683181 | -122.418436722662 | (37.7759507683181, -122.418436722662) | ||
| 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) | |||
| 537 | 537 | 195070 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
| 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) | |||
| 584 | 584 | 14069 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007575.3554 | 2111000.5411 | 37.7768330981624 | -122.417310315452 | (37.7768330981624, -122.417310315452) | |||
| 589 | 589 | 26916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002555.1851 | 2113680.9302 | 37.783909052953 | -122.43486830704398 | (37.783909052953, -122.434868307044) | |||
| 612 | 612 | 23503 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2550 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005820.29029 | 2119236.56275 | 37.7993482683535 | -122.42396743424999 | (37.7993482683535, -122.42396743425) | |||
| 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) | |||
| 647 | 647 | 13705 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011215.546569999 | 2114485.16599 | 37.786605191509295 | -122.404963137048 | (37.7866051915093, -122.404963137048) | |||
| 730 | 730 | 195047 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 06th St | 2 | : 4 | Tree 1 | DPW 2 | 03/26/2005 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.777673209496605 | -122.404737337955 | (37.7776732094966, -122.404737337955) | |
| 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) | |||
| 803 | 803 | 5878 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1090 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005272.8038 | 2113070.2583 | 37.7823862204069 | -122.425422868476 | (37.7823862204069, -122.425422868476) | |||
| 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) | |||
| 917 | 917 | 8555 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2141 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 3X3 | 6001312.669 | 2113446.883 | 37.7831957953331 | -122.43915016448999 | (37.7831957953331, -122.43915016449) | |||
| 931 | 931 | 13827 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6009845.6649 | 2113195.3529 | 37.7829870022194 | -122.409611544992 | (37.7829870022194, -122.409611544992) | |||
| 942 | 942 | 139350 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6004774.9676 | 2114125.1051 | 37.785254427644404 | -122.427220325156 | (37.7852544276444, -122.427220325156) | |||
| 956 | 956 | 139346 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 GEARY BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6004901.3702 | 2114140.1368 | 37.7853028484475 | -122.426784081516 | (37.7853028484475, -122.426784081516) | |||
| 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) | |||
| 962 | 962 | 139345 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 GEARY BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6004932.8001 | 2114145.6028 | 37.7853196336912 | -122.426675732937 | (37.7853196336912, -122.426675732937) | |||
| 964 | 964 | 139348 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 GEARY BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6004841.9268 | 2114136.7205 | 37.7852901070824 | -122.426989494298 | (37.7852901070824, -122.426989494298) | |||
| 975 | 975 | 251421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/30/2014 01:37:00 PM | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | ||
| 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) | |||
| 997 | 997 | 95184 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001220.026000001 | 2113275.7262 | 37.7827205704951 | -122.439458398161 | (37.7827205704951, -122.439458398161) | |||
| 1023 | 1023 | 24311 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2639 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6006902.669840001 | 2121389.92308 | 37.8053218972443 | -122.420374939461 | (37.8053218972443, -122.420374939461) | ||||
| 1026 | 1026 | 13476 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6013666.75675 | 2116818.6011799998 | 37.7931489752948 | -122.396646124018 | (37.7931489752948, -122.396646124018) | |||
| 1028 | 1028 | 13480 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6013615.86639 | 2116768.91037 | 37.7930097035807 | -122.396818723722 | (37.7930097035807, -122.396818723722) | |||
| 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) | ||
| 1115 | 1115 | 2987 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2266X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003539.7936 | 2115618.85396 | 37.7892859554236 | -122.431600327591 | (37.7892859554236, -122.431600327591) | |||
| 1123 | 1123 | 28040 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011973.34792 | 2120976.9306 | 37.8044723526732 | -122.40279804081499 | (37.8044723526732, -122.402798040815) | ||
| 1133 | 1133 | 13945 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 12 | 4x4 | 6009115.3446 | 2112460.3733 | 37.7809279727613 | -122.412086202614 | (37.7809279727613, -122.412086202614) | ||
| 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) | |||
| 1147 | 1147 | 14071 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007529.5869 | 2110959.6416 | 37.7767182228199 | -122.41746574362101 | (37.7767182228199, -122.417465743621) | |||
| 1151 | 1151 | 13977 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008909.6011 | 2112263.4341 | 37.780375678658295 | -122.412784045926 | (37.7803756786583, -122.412784045926) | |||
| 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) |
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");