Data source: data.sfgov.org
This data as json, CSV (advanced)
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 1394 | 1394 | 2927 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1820 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6005591.4546 | 2115905.84085 | 37.7901900249849 | -122.424522238615 | (37.7901900249849, -122.424522238615) | |||
| 1575 | 1575 | 246375 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2248 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003217.3444 | 2106843.7794 | 37.765173499092995 | -122.43208906900499 | (37.765173499093, -122.432089069005) | |||
| 1576 | 1576 | 246374 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2248 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | 6003241.3918 | 2106872.8368 | 37.765254647007296 | -122.432007970015 | (37.7652546470073, -122.432007970015) | |||
| 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) | |||
| 1596 | 1596 | 14066 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007645.4688 | 2111067.7331 | 37.7770215357502 | -122.41707253353701 | (37.7770215357502, -122.417072533537) | |||
| 1612 | 1612 | 13833 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 970 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009828.1026 | 2113177.7906 | 37.782937796191504 | -122.40967106357901 | (37.7829377961915, -122.409671063579) | |||
| 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 | |||||||||
| 1671 | 1671 | 13627 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 570 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6012289.31562 | 2115520.12346 | 37.789506905374395 | -122.401320892642 | (37.7895069053744, -122.401320892642) | |||
| 1676 | 1676 | 23357 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/2017 12:00:00 AM | 3 | 3X3 | 6006405.911169999 | 2115051.67043 | 37.78789064557179 | -122.4216435834 | (37.7878906455718, -122.4216435834) | ||
| 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) | |||
| 1738 | 1738 | 13966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1127 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008823.0 | 2112045.0 | 37.7797710494845 | -122.413068191044 | (37.7797710494845, -122.413068191044) | |||
| 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) | ||
| 1743 | 1743 | 200855 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6008978.4093 | 2112218.7143 | 37.7802567505844 | -122.412542843301 | (37.7802567505844, -122.412542843301) | |||
| 1754 | 1754 | 245399 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3467 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6005818.4513 | 2098127.8856 | 37.7413887962973 | -122.42247308874201 | (37.7413887962973, -122.422473088742) | |||
| 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) | |||
| 1756 | 1756 | 13756 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
| 1761 | 1761 | 200862 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6008817.7245 | 2112082.7382 | 37.7798743734467 | -122.41308911055201 | (37.7798743734467, -122.413089110552) | |||
| 1762 | 1762 | 200860 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008794.0112 | 2112059.0249 | 37.779807931141 | -122.413169468366 | (37.779807931141, -122.413169468366) | |||
| 1763 | 1763 | 200861 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6008800.2278 | 2112051.2202 | 37.7797868502892 | -122.41314741030199 | (37.7797868502892, -122.413147410302) | |||
| 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) | ||
| 1890 | 1890 | 245384 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3243 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2005 12:00:00 AM | 5 | Width 0ft | 6006512.1787 | 2099413.785 | 37.7449586977694 | -122.420165655704 | (37.7449586977694, -122.420165655704) | ||
| 1901 | 1901 | 23857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6003664.511 | 2113605.5032 | 37.7837648703142 | -122.431025065183 | (37.7837648703142, -122.431025065183) | |||
| 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) | ||
| 1954 | 1954 | 20331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 2041 | 2041 | 13773 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4x4 | 6010487.82969 | 2113786.8175 | 37.7846469870112 | -122.407431620471 | (37.7846469870112, -122.407431620471) | |||
| 2048 | 2048 | 143400 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | 6008592.8234 | 2111992.2193 | 37.779613202213994 | -122.41386074083401 | (37.779613202214, -122.413860740834) | |||
| 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) | |||
| 2087 | 2087 | 252878 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | |||
| 2089 | 2089 | 195741 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 4ft | 6014483.0 | 2111149.0 | 37.7776269440566 | -122.39342489592899 | (37.7776269440566, -122.393424895929) | |||
| 2101 | 2101 | 143399 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008612.8747 | 2111976.4646 | 37.779571069624 | -122.413790259796 | (37.779571069624, -122.413790259796) | |||
| 2104 | 2104 | 140318 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1170 MARKET ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6008545.5594 | 2111947.8198 | 37.779488637316206 | -122.414021106074 | (37.7794886373162, -122.414021106074) | |||
| 2112 | 2112 | 13981 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008866.9651 | 2112266.4261 | 37.7803815007944 | -122.412931755866 | (37.7803815007944, -122.412931755866) | |||
| 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) |
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");