trees

11,635 rows where qSpecies_id = 27 sorted by qLegalStatus_id

✎ View and edit SQL

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2558 134571 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 30 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007831.94374 2111562.01758 37.7783892110202 -122.416462477559 (37.7783892110202, -122.416462477559) 7 9 9 28852 36
2564 20333 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
2584 249512 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1233 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6006339.71107 2114788.40183 37.7871640419323 -122.42185391595 (37.7871640419323, -122.42185391595) 13 9 1 28858 41
2650 133366 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1800 Chestnut St 12 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6003170.63079 2119991.74188 37.8012718471789 -122.433190164415 (37.8012718471789, -122.433190164415) 13 9 1 57 17
2672 134477 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 3 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   6007817.15292 2111847.04957 37.7791710087729 -122.416533840565 (37.7791710087729, -122.416533840565) 7 9 9 28852 36
2711 69872 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 799x 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6 3x3   5985114.18885 2110476.07325 37.7741037641519 -122.494970443436 (37.7741037641519, -122.494970443436) 11 6 2 55 26
2718 235560 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1105 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007668.45252 2103157.12414 37.7553021446047 -122.416432560735 (37.7553021446047, -122.416432560735) 2 4 7 28859 19
2719 135295 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 701 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6010513.55959 2116175.58705 37.7912074181307 -122.407511076491 (37.7912074181307, -122.407511076491) 5 1 10 28857 21
2776 195101 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 975 Indiana St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6015008.39905 2103995.03774 37.7580129098927 -122.391107184248 (37.7580129098927, -122.391107184248) 10 3 8 28856 29
2782 133756 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2818 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 3ft   6001092.40626 2115942.5947 37.790035840725 -122.44009120116 (37.790035840725, -122.44009120116) 13 6 1 29490 27
2790 135344 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 400 Market St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6013433 2116569 37.7924506166945 -122.397437429611 (37.7924506166945, -122.397437429611) 4 2 10 28860 6
2807 195472 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 450x The Embarcadero 8 Median : Yard Tree DPW 1     7     6014582.56054 2117381.49578 37.7947454787808 -122.393516774681 (37.7947454787808, -122.393516774681) 12 2 10 28860 6
2839 262241 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 341 30th Ave 6 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5986508.67785 2113597.38194 37.7827555237835 -122.490376395298 (37.7827555237835, -122.490376395298) 11 6 2 55 26
2841 9956 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 155 Grove St 1 Sidewalk: Curb side : Cutout Tree Mayor Office of Housing 11     12 4X4   6007076.05273 2111529.8614 37.7782583803491 -122.419075111548 (37.7782583803491, -122.419075111548) 7 9 9 28852 36
2850 178600 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200 Winston Dr 6 : Tree Private 2     6 Width 0ft   5989476.93903 2093627.59215 37.7280967254778 -122.478646687712 (37.7280967254778, -122.478646687712) 1 8 4 64 14
2869 260926 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999531 2110546 37.7751291750369 -122.445105382083 (37.7751291750369, -122.445105382083) 15 5 11 29492 16
2880 133619 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 220 Richardson Ave 8 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5999075.60684 2119862.33326 37.8006833766814 -122.447351372295 (37.8006833766814, -122.447351372295) 13 9 1 57 17
2888 13930 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1095 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/16/1994 12:00:00 AM 12 4X4   6009061.9861 2112312.9703 37.7805202452284 -122.412260375327 (37.7805202452284, -122.412260375327) 14 2 9 28853 34
2923 138606 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2725 CALIFORNIA ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     16 Width 0ft   6001407.3919 2115257.3022 37.7881721314677 -122.438952247661 (37.7881721314677, -122.438952247661) 13 6 1 29490 27

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);