trees
11,635 rows where qSpecies_id = 27
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45 | 134298 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1948 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 4ft | 6004784.56446 | 2117433.72769 | 37.7943396156388 | -122.427422908337 | (37.7943396156388, -122.427422908337) | 13 | 9 | 1 | 28858 | 27 | ||
| 58 | 195132 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 825 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | Width 3ft | 6015253.79115 | 2104691.52976 | 37.7599389420381 | -122.390307168065 | (37.7599389420381, -122.390307168065) | 10 | 3 | 8 | 28856 | 29 | ||
| 59 | 195131 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 Minnesota St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | Width 3ft | 6015252.45033 | 2104672.28083 | 37.7598860142382 | -122.390310460464 | (37.7598860142382, -122.390310460464) | 10 | 3 | 8 | 28856 | 29 | ||
| 118 | 236256 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 151 Valencia St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6006073.15075 | 2108915.83898 | 37.7710243776945 | -122.422358744984 | (37.7710243776945, -122.422358744984) | 8 | 2 | 9 | 28853 | 19 | |||
| 278 | 247719 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 12 Broderick St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6001402.47389 | 2108783.95066 | 37.770397668046 | -122.438505276404 | (37.770397668046, -122.438505276404) | 15 | 5 | 11 | 29492 | 9 | |||
| 424 | 13666 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 653 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/21/2014 12:00:00 AM | 3 | 4x4 | 6011846.3206496 | 2114969.3004876 | 37.7879697501429 | -122.402814861202 | (37.7879697501429, -122.402814861202) | 12 | 2 | 9 | 28855 | 6 | ||
| 478 | 104347 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 417 31st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 4x9 | 5986214.92159 | 2113090.52274 | 37.7813466727453 | -122.49135533617 | (37.7813466727453, -122.49135533617) | 11 | 6 | 2 | 55 | 26 | |||
| 497 | 133485 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Spruce St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5997070.63549 | 2115917.82612 | 37.7897380545196 | -122.454004325646 | (37.7897380545196, -122.454004325646) | 11 | 6 | 1 | 54 | 31 | |||
| 502 | 251299 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4X4 | 6003624.7851 | 2107240.8343 | 37.7662868072343 | -122.430708166736 | (37.7662868072343, -122.430708166736) | 7 | 4 | 5 | 28862 | 3 | ||||
| 507 | 195311 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013845.70185 | 2116893.75953 | 37.7933653000223 | -122.396032227918 | (37.7933653000223, -122.396032227918) | 12 | 2 | 9 | 28855 | 6 | |||
| 508 | 113374 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 88 HOWARD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014757 | 2116474 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | 12 | 2 | 9 | 28855 | 6 | ||||
| 525 | 33087 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
| 555 | 133914 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2830 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000461.7314 | 2116836.01303 | 37.7924530097486 | -122.442337442312 | (37.7924530097486, -122.442337442312) | 13 | 6 | 1 | 29490 | 27 | |||
| 563 | 100819 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2430X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6002728 | 2116798 | 37.7924775418689 | -122.434493377265 | (37.7924775418689, -122.434493377265) | 13 | 9 | 1 | 29490 | 27 | |||
| 582 | 20409 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10 | |||||||||||||
| 597 | 134036 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2520 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6001831.99307 | 2117026.11949 | 37.7930529960553 | -122.437609926666 | (37.7930529960553, -122.437609926666) | 13 | 6 | 1 | 29490 | 27 | |||
| 631 | 62744 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1440 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1986 12:00:00 AM | 3x3 | Permit Number 23091 | 6009114.80137277 | 2108930.88306921 | 37.7712367935343 | -122.411838604602 | (37.7712367935343, -122.411838604602) | 8 | 2 | 9 | 28853 | 34 | |
| 637 | 35060 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 5545 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | Permit Number 41350 | 6014167.69706675 | 2092844.73590691 | 37.7273498207281 | -122.393234476852 | (37.7273498207281, -122.393234476852) | 10 | 3 | 8 | 58 | 1 | |||
| 654 | 110662 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 650 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003107.0213 | 2110612.8975 | 37.7755163177511 | -122.43273991983 | (37.7755163177511, -122.43273991983) | 15 | 9 | 11 | 29492 | 10 | |||
| 673 | 134853 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 767 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6007674.44825 | 2120926.53218 | 37.8040930033612 | -122.417671229348 | (37.8040930033612, -122.417671229348) | 5 | 1 | 1 | 308 | 32 | |||
| 684 | 260585 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
| 755 | 133562 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3600 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997557.82497 | 2115448.22108 | 37.7884765664739 | -122.452284806617 | (37.7884765664739, -122.452284806617) | 11 | 6 | 1 | 54 | 31 | |||
| 760 | 112380 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3250 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6007972 | 2100641 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | 2 | 4 | 7 | 28859 | 19 | |||
| 782 | 149288 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3512 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5997585.96576 | 2114787.85095 | 37.7866649775452 | -122.452139778342 | (37.7866649775452, -122.452139778342) | 11 | 6 | 1 | 54 | 31 | |||
| 787 | 110793 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 900 CALIFORNIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009776 | 2116634 | 37.7924247975925 | -122.410095399183 | (37.7924247975925, -122.410095399183) | 5 | 1 | 10 | 28857 | 21 | ||||
| 791 | 238711 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 57 Patton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6005625.70322 | 2096800.60962 | 37.7377335196827 | -122.423045228967 | (37.7377335196827, -122.423045228967) | 2 | 7 | 7 | 28859 | 2 | |||
| 824 | 262410 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1975 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 880 | 139222 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1898 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002698.0428 | 2113854.5755 | 37.7843939489044 | -122.434386491808 | (37.7843939489044, -122.434386491808) | 13 | 9 | 11 | 29490 | 13 | |||
| 886 | 73449 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 238 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004263.46084 | 2092033.98232 | 37.7245684629353 | -122.427415688595 | (37.7245684629353, -122.427415688595) | 9 | 7 | 6 | 28861 | 5 | |||
| 898 | 262453 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2005 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003839 | 2115372 | 37.7886251115209 | -122.43054748798 | (37.7886251115209, -122.43054748798) | 13 | 9 | 1 | 29490 | 27 | ||||
| 911 | 133385 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3560 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997729.83892 | 2115800.21541 | 37.7894529019824 | -122.4517150699 | (37.7894529019824, -122.4517150699) | 11 | 6 | 1 | 54 | 31 | |||
| 946 | 133881 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | Permit Number 782825 | 5999916.99907 | 2117104.86853 | 37.7931601538699 | -122.444241554422 | (37.7931601538699, -122.444241554422) | 13 | 9 | 1 | 57 | 27 | ||
| 957 | 235520 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 995x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6007870.56575 | 2097734.66697 | 37.740424657282 | -122.415349740103 | (37.740424657282, -122.415349740103) | 2 | 7 | 7 | 28859 | 2 | |||
| 1101 | 245920 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1828 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005542.6546 | 2109064.0833 | 37.7714014816775 | -122.424204294394 | (37.7714014816775, -122.424204294394) | 7 | 2 | 5 | 28852 | 10 | |||
| 1134 | 262481 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2001 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004735 | 2108212 | 37.769016230753 | -122.426937316023 | (37.769016230753, -122.426937316023) | 8 | 4 | 5 | 28862 | 3 | ||||
| 1191 | 34003 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37940 | |||||||||||||||
| 1206 | 133791 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2700 Jackson St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000994.64018 | 2116583.48439 | 37.7917899908621 | -122.440475447294 | (37.7917899908621, -122.440475447294) | 13 | 6 | 1 | 29490 | 27 | |||
| 1223 | 97704 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 900 North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2008 12:00:00 AM | 6 | 4x8 | Permit Number 56162 | 6006190.09828 | 2121459.17568 | 37.8054718673026 | -122.422845813285 | (37.8054718673026, -122.422845813285) | 5 | 1 | 1 | 28858 | 32 | |
| 1227 | 46197 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
| 1265 | 120363 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6118 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5988496.49362 | 2114018.15896 | 37.7840267560995 | -122.483530334528 | (37.7840267560995, -122.483530334528) | 11 | 6 | 2 | 55 | 26 | |||
| 1302 | 14133 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1642X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006458.8907635 | 2109942.5653128 | 37.773865274364 | -122.421097370447 | (37.773865274364, -122.421097370447) | 7 | 2 | 11 | 28852 | 10 | |||
| 1305 | 235593 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 883 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006318.42093 | 2104453.15009 | 37.7587847188469 | -122.421193406146 | (37.7587847188469, -122.421193406146) | 2 | 4 | 7 | 28859 | 19 | |||
| 1311 | 23384 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1451X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6006248.25114 | 2115440.18145 | 37.7889485091226 | -122.42221667202 | (37.7889485091226, -122.42221667202) | 13 | 9 | 1 | 28858 | 41 | |||
| 1315 | 13622 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 562 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6012358.74659 | 2115584.5782 | 37.7896877563436 | -122.401085198325 | (37.7896877563436, -122.401085198325) | 4 | 2 | 10 | 28854 | 6 | |||
| 1325 | 139508 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1394 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001101.7668 | 2111099.6584 | 37.7767389104061 | -122.439711465512 | (37.7767389104061, -122.439711465512) | 15 | 5 | 11 | 29492 | 41 | |||
| 1400 | 23567 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2975 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/27/1992 12:00:00 AM | 3 | 3X3 | 6005531.33723 | 2120589.48411 | 37.8030467266869 | -122.425063628702 | (37.8030467266869, -122.425063628702) | 13 | 9 | 1 | 28858 | 17 | ||
| 1414 | 135215 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1500 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011722.83075 | 2121216.32362 | 37.8051156764096 | -122.403681836968 | (37.8051156764096, -122.403681836968) | 3 | 1 | 10 | 28860 | 23 | |||
| 1449 | 13614 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 555 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4X4 | 6012641.55561 | 2115729.4469 | 37.7901013041673 | -122.400116879409 | (37.7901013041673, -122.400116879409) | 12 | 2 | 9 | 28855 | 6 | |||
| 1467 | 259815 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
| 1469 | 234740 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Henry St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001945.99496 | 2107361.26282 | 37.7665222204537 | -122.436523394556 | (37.7665222204537, -122.436523394556) | 15 | 5 | 5 | 28862 | 3 | |||
| 1490 | 135348 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 400 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6013433 | 2116569 | 37.7924506166945 | -122.397437429611 | (37.7924506166945, -122.397437429611) | 4 | 2 | 10 | 28860 | 6 | |||
| 1501 | 27903 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 33 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015937.152 | 2112771.705 | 37.7821632154212 | -122.388507741674 | (37.7821632154212, -122.388507741674) | 6 | 2 | 9 | 28856 | 6 | |||
| 1505 | 106993 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 160 HENRY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002480.9 | 2107459.2 | 37.766821513471 | -122.434680259747 | (37.766821513471, -122.434680259747) | 15 | 5 | 5 | 28862 | 3 | |||
| 1524 | 28207 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 1534 | 28217 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 1605 | 35819 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 980 Houston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39055 | |||||||||||||
| 1607 | 263607 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 6750 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5986674 | 2113924 | 37.7836619775759 | -122.489828487098 | (37.7836619775759, -122.489828487098) | 11 | 6 | 2 | 55 | 26 | ||||
| 1612 | 11759 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
| 1625 | 27599 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2012 12:00:00 AM | 30 | 4X4 | Permit Number 769284 | 6014195.968415 | 2117306.152584 | 37.7945171162452 | -122.394849166766 | (37.7945171162452, -122.394849166766) | 4 | 2 | 10 | 28855 | 6 | |
| 1644 | 134665 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 941 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009507.53925 | 2116615.63337 | 37.7923593165687 | -122.41102298664 | (37.7923593165687, -122.41102298664) | 5 | 1 | 10 | 28857 | 21 | |||
| 1655 | 238744 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 788 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007924.68197 | 2103394.11791 | 37.7559672813937 | -122.415563218463 | (37.7559672813937, -122.415563218463) | 2 | 4 | 7 | 28859 | 19 | |||
| 1672 | 9818 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005621.8341 | 2113520.56064 | 37.783642353453 | -122.424247412091 | (37.783642353453, -122.424247412091) | 7 | 9 | 11 | 28858 | 41 | |||
| 1708 | 135351 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 400 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6013433 | 2116569 | 37.7924506166945 | -122.397437429611 | (37.7924506166945, -122.397437429611) | 4 | 2 | 10 | 28860 | 6 | |||
| 1724 | 134353 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 826 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006643.13761 | 2113330.8233 | 37.7831789957579 | -122.420700610947 | (37.7831789957579, -122.420700610947) | 7 | 9 | 9 | 28858 | 36 | |||
| 1765 | 73918 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004497.3871 | 2111109.5855 | 37.776958856214 | -122.42796571067 | (37.776958856214, -122.42796571067) | 7 | 9 | 11 | 28852 | 10 | |||
| 1779 | 246274 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2370 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002462.6074 | 2106119.7801 | 37.7631427546126 | -122.434647744484 | (37.7631427546126, -122.434647744484) | 15 | 4 | 5 | 28862 | 3 | |||
| 1792 | 195241 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400x Evans Ave | 17 | Median : Yard | Tree | DPW 1 | 5 | 6016370.1217 | 2098002.92096 | 37.7416352733631 | -122.385980035973 | (37.7416352733631, -122.385980035973) | 10 | 3 | 8 | 58 | 1 | ||||
| 1808 | 134289 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2416 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6004999.06299 | 2117994.49764 | 37.7958914767778 | -122.426720670937 | (37.7958914767778, -122.426720670937) | 13 | 9 | 1 | 28858 | 27 | |||
| 1833 | 139191 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900 GEARY BLVD | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6002000.3837 | 2113732.652 | 37.7840195526567 | -122.436791415675 | (37.7840195526567, -122.436791415675) | 13 | 5 | 11 | 29490 | 13 | |||
| 1852 | 24074 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 161X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016395.7853594 | 2095946.5828375 | 37.735990405317 | -122.385748008424 | (37.735990405317, -122.385748008424) | 10 | 3 | 8 | 58 | 1 | |||
| 1862 | 23733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X Webster St | 8 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6003923.026 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | 7 | 9 | 11 | 29490 | 41 | |||
| 1902 | 261997 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 1946 | 3109 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3101 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5999491.6257 | 2114988.3354 | 37.7873244331103 | -122.44556109944 | (37.7873244331103, -122.44556109944) | 15 | 6 | 1 | 29490 | 31 | |||
| 1954 | 250815 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 66 Sea View Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5986156.52823 | 2114164.57331 | 37.784292294401 | -122.491636432381 | (37.784292294401, -122.491636432381) | 11 | 6 | 1 | 55 | 33 | |||
| 1965 | 195920 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 15 Baldwin Ct | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 4x4 | Permit Number 784616 | 6017944.92051 | 2093525.02511 | 37.7294268839465 | -122.380223738131 | (37.7294268839465, -122.380223738131) | 10 | 3 | 8 | 58 | 1 | ||
| 2000 | 246610 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3100 Harrison St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 5ft | 6009018.5431 | 2100356.10126 | 37.7476869930583 | -122.411565635751 | (37.7476869930583, -122.411565635751) | 2 | 7 | 7 | 28859 | 2 | |||
| 2016 | 134492 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 199 Fulton St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008187.17961 | 2111997.187 | 37.7796040530222 | -122.415264393538 | (37.7796040530222, -122.415264393538) | 7 | 10 | 9 | 28852 | 36 | |||
| 2053 | 9801 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1010 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005681.92309 | 2113158.17696 | 37.7826507298416 | -122.424013748222 | (37.7826507298416, -122.424013748222) | 7 | 9 | 11 | 28858 | 41 | |||
| 2079 | 263595 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
| 2082 | 195047 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 06th St | 2 | : | Tree | DPW 1 | 02/25/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.7776732094966 | -122.404737337955 | (37.7776732094966, -122.404737337955) | 14 | 2 | 9 | 28853 | 34 | |
| 2084 | 3028 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2549 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 65 | 3X3 | 6002165 | 2115339 | 37.7884395284954 | -122.436336906157 | (37.7884395284954, -122.436336906157) | 13 | 6 | 1 | 29490 | 27 | |||
| 2097 | 12450 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
| 2129 | 134818 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 995 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007124.95237 | 2120498.06243 | 37.8028855978618 | -122.419542385778 | (37.8028855978618, -122.419542385778) | 5 | 1 | 1 | 28858 | 32 | |||
| 2131 | 140415 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6003782.7679 | 2112770.1424 | 37.7814778785376 | -122.430556314217 | (37.7814778785376, -122.430556314217) | 15 | 9 | 11 | 29490 | 41 | |||
| 2137 | 134250 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1851 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006058.4702 | 2116853.96653 | 37.7928197038277 | -122.422973813809 | (37.7928197038277, -122.422973813809) | 13 | 9 | 1 | 28858 | 27 | |||
| 2209 | 134782 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2222 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006396 | 2118554 | 37.7975066091486 | -122.421926761206 | (37.7975066091486, -122.421926761206) | 13 | 9 | 10 | 28858 | 32 | |||
| 2224 | 236583 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 2243 | 134920 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2618 Taylor St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6008362.41303 | 2121791.60977 | 37.8065069770658 | -122.415351749199 | (37.8065069770658, -122.415351749199) | 3 | 1 | 10 | 308 | 23 | |||
| 2250 | 123674 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4800 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5992682.29919 | 2114168.82501 | 37.7846831852621 | -122.46906006622 | (37.7846831852621, -122.46906006622) | 11 | 6 | 2 | 54 | 11 | |||
| 2257 | 134060 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2434 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001939.59837 | 2117387.98791 | 37.7940527103301 | -122.43726352939 | (37.7940527103301, -122.43726352939) | 13 | 9 | 1 | 57 | 27 | |||
| 2264 | 195906 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017536.51639 | 2095200.72855 | 37.7340054943619 | -122.381752144972 | (37.7340054943619, -122.381752144972) | 10 | 3 | 8 | 58 | 1 | |||
| 2271 | 37958 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 701 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | Permit Number 40528 | 6015227.36686 | 2105129.80279 | 37.7611408796801 | -122.390429180864 | (37.7611408796801, -122.390429180864) | 10 | 3 | 8 | 28856 | 29 | |
| 2322 | 218250 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2751 14th Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 5992235.80201 | 2097238.62713 | 37.738171520993 | -122.469372026199 | (37.738171520993, -122.469372026199) | 1 | 8 | 4 | 59 | 40 | |||
| 2326 | 238831 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1940 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008651.60454 | 2107166.74351 | 37.7663668805475 | -122.413316051008 | (37.7663668805475, -122.413316051008) | 8 | 4 | 7 | 28853 | 19 | |||
| 2385 | 195415 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 214 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014352.77069 | 2115553.8784 | 37.7897144967647 | -122.394183871097 | (37.7897144967647, -122.394183871097) | 6 | 2 | 9 | 28855 | 6 | |||
| 2433 | 134877 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2431 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6007945.45112 | 2120891.7188 | 37.8040126606302 | -122.416730934203 | (37.8040126606302, -122.416730934203) | 5 | 1 | 1 | 308 | 32 | |||
| 2454 | 46118 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44476 | 6015543.8 | 2115940.8 | 37.7908430231508 | -122.390090033136 | (37.7908430231508, -122.390090033136) | 6 | 2 | 9 | 28855 | 6 | |||
| 2468 | 14078 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007428.1196287 | 2110750.9276325 | 37.7761394345379 | -122.417801951992 | (37.7761394345379, -122.417801951992) | 8 | 2 | 9 | 28853 | 34 | |||
| 2497 | 134970 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2100 The Embarcadero | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6009821.57971 | 2122377.99729 | 37.8081989525817 | -122.41034344359 | (37.8081989525817, -122.41034344359) | 3 | 1 | 10 | 308 | 23 | ||||
| 2529 | 135347 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 400 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6013433 | 2116569 | 37.7924506166945 | -122.397437429611 | (37.7924506166945, -122.397437429611) | 4 | 2 | 10 | 28860 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );