trees

11,635 rows where qSpecies_id = 27 sorted by SiteOrder

✎ 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)
18004 110212 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2978 CESAR CHAVEZ ST   Sidewalk: Curb side : Cutout Tree DPW 1     1 3x4   6009700.7 2100638.5 37.7485006383082 -122.409226689451 (37.7485006383082, -122.409226689451) 2 4 7 28859 19
29775 107940 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 960 Harrison St   Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3   Permit Number 768645 6011630.15925 2111363.93441 37.7780581861375 -122.403309017255 (37.7780581861375, -122.403309017255) 14 2 9 28856 34
29963 106965 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 63 BELLE AVE   Sidewalk: Property side : Yard Tree Private 2           5991753.8 2086471.1 37.7085786821221 -122.47025464516 (37.7085786821221, -122.47025464516) 9 8 4 64 24
31299 97252 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 4391 26th St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768116 6001406.8 2100528.2 37.7477296308595 -122.43789889633 (37.7477296308595, -122.43789889633) 2 4 5 63 22
49012 105061 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 163 10TH AVE   Sidewalk: Curb side : Cutout Tree Private 2     45 4x3   5992696.3 2114396 37.785307754338 -122.469028167173 (37.785307754338, -122.469028167173) 11 6 2 54 11
84307 104677 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 65 ZIRCON PL   Sidewalk: Property side : Yard Tree Private 2         Permit Number 770985 6002398.2 2098694.7 37.7427515964219 -122.434339626982 (37.7427515964219, -122.434339626982) 2 7 5 63 7
92906 89009 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 800 Chestnut St   Sidewalk: Curb side : Cutout Tree Private 2   09/29/2008 12:00:00 AM     Permit Number 51761 6007996 2120667 37.8033984824 -122.416540077944 (37.8033984824, -122.416540077944) 5 1 1 308 32
96062 108035 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 945 Market St   unknown : Cutout Tree DPW 1       3x3 Permit Number 774370 6010085.91267 2113154.0076 37.7828869372518 -122.408777465126 (37.7828869372518, -122.408777465126) 14 2 9 28853 34
141090 89149 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 941 North Point St   Sidewalk: Curb side : Cutout Tree Private 2   10/07/2008 12:00:00 AM   3x3 Permit Number 51802 6006240 2121411 37.8053424047468 -122.422669695712 (37.8053424047468, -122.422669695712) 5 1 1 28858 32
153149 88701 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 738 Hayes St   Sidewalk: Curb side : Cutout Tree Private 2   08/07/2008 12:00:00 AM   3x3 Permit Number 51651 6004318 2110848 37.7762304564773 -122.428567615262 (37.7762304564773, -122.428567615262) 7 9 11 28852 10
156975 88345 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 347 Vienna St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51330 6003917 2091407 37.7228273068445 -122.428568687279 (37.7228273068445, -122.428568687279) 9 7 6 28861 5
168326 88742 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 11 Surrey St   Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51677 6002796 2095846 37.7349522946532 -122.432760693841 (37.7349522946532, -122.432760693841) 2 7 5 63 7
170218 112428 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2819 JACKSON ST   Sidewalk: Curb side : Cutout Tree Private 2     33 3x3   6000608 2116457 37.7914206746057 -122.441804136035 (37.7914206746057, -122.441804136035) 13 6 1 29490 27
175909 111092 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 801 GONZALEZ DR   Sidewalk: Curb side : Yard Tree Private 2   06/04/2015 12:00:00 AM 2   Permit Number 775593 5988333 2089769 37.7174355256527 -122.48231868452 (37.7174355256527, -122.48231868452) 1 8 4 64 14
184704 104820 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 701 CASTRO ST   Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002463.2 2104094.7 37.7575824076205 -122.434500892974 (37.7575824076205, -122.434500892974) 2 4 5 28862 3
191705 107453 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1817 JACKSON ST   Sidewalk: Curb side : Cutout Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774262 6005381 2117121.5 37.7935160322314 -122.425336940693 (37.7935160322314, -122.425336940693) 13 9 1 28858 27
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2546 23472 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2356 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3 Permit Number 782620 6005919.56056 2118542.30149 37.7974476069742 -122.423574537547 (37.7974476069742, -122.423574537547) 13 9 10 28858 32
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
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
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
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
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
2964 22868 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 901X Ulloa St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5993173.81508 2098252.95685 37.7410107778213 -122.466202563499 (37.7410107778213, -122.466202563499) 1 8 4 59 40
3031 68691 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 4639 California St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM     Permit Number 32601 5993244.83438124 2114136.0623562 37.7846257148972 -122.467111515337 (37.7846257148972, -122.467111515337) 11 6 2 54 11
3067 211925 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 115 San Anselmo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 8ft   5993291.36421 2096622.21184 37.7365399421628 -122.465677676 (37.7365399421628, -122.465677676) 1 8 4 59 40
3147 59705 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3135 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/1981 12:00:00 AM 12   Permit Number 19135 5999682.98481 2116022.48652 37.7901748642281 -122.444973410102 (37.7901748642281, -122.444973410102) 13 6 1 29490 27
3181 103180 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1601X 28th Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     11 3x4   5987448.1702 2104354.2995 37.7574314190685 -122.486447346513 (37.7574314190685, -122.486447346513) 1 8 3 56 35
3190 142755 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1800 POWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6009592.3293 2119871.6258 37.8013042277799 -122.410959684909 (37.8013042277799, -122.410959684909) 3 1 10 308 23
3210 3122 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3171 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   5999239.7647 2114955.904 37.787221003016 -122.44643014826 (37.787221003016, -122.44643014826) 15 6 1 29490 31
3300 113370 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 88 HOWARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
3407 261413 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 784 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6009845.04505 2118484.93763 37.7975108909305 -122.409987225009 (37.7975108909305, -122.409987225009) 3 1 10 308 4
3499 30983 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2351 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 6   Permit Number 34770 6004127.32192 2116907.85743 37.7928585158547 -122.429659520472 (37.7928585158547, -122.429659520472) 13 9 1 29490 27
3538 249405 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 430 Turk St 1 : Tree Private 2     8 Width 4ft   6007893.39158 2113084.10787 37.7825719605735 -122.416357743418 (37.7825719605735, -122.416357743418) 7 10 9 28852 36
3544 79352 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2909 Bush St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   8 3x3   5999487.033 2114286.0485 37.785395874336 -122.445526470028 (37.785395874336, -122.445526470028) 15 6 1 29490 31
3709 33773 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2640 Baker St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 12/23/1996 12:00:00 AM 12   Permit Number 37820 5999639.77056 2117940.89784 37.7954398489265 -122.44526091526 (37.7954398489265, -122.44526091526) 13 9 1 57 17
3778 234570 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2888 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010218.25427 2100690.22553 37.7486716472971 -122.407440633481 (37.7486716472971, -122.407440633481) 2 4 7 28859 19
3858 23985 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 199 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5992667.0832 2097455.8503 37.7387928750296 -122.467896678698 (37.7387928750296, -122.467896678698) 1 8 4 59 40
3864 2928 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1834 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6005568.20527 2115901.70542 37.7901773571486 -122.424602385305 (37.7901773571486, -122.424602385305) 13 9 1 28858 27
3870 53578 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 123 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1970 12:00:00 AM 9   Permit Number 6502 5993941.76178 2114693.00762 37.7861951385831 -122.464740857622 (37.7861951385831, -122.464740857622) 11 6 2 54 11
3947 110556 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 600 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2019 12:00:00 AM 3 3x3 Permit Number 777830 5987238.02071 2111776.28729 37.7777978852393 -122.487719377224 (37.7777978852393, -122.487719377224) 11 6 2 55 26
3956 48783 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 201 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2002 12:00:00 AM 6   Permit Number 46038 6008763.21846 2113151.61883 37.7828062042714 -122.413353282927 (37.7828062042714, -122.413353282927) 7 10 9 28852 36
3979 13887 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1028 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6009423.70824 2112763.96692 37.7817788655291 -122.411040866943 (37.7817788655291, -122.411040866943) 14 2 9 28852 36
4075 99713 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6001685.4406 2113539.6106 37.7834716060779 -122.437867170922 (37.7834716060779, -122.437867170922) 15 5 11 29490 41
4087 264737 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2222 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6006396 2118554 37.7975066091486 -122.421926761206 (37.7975066091486, -122.421926761206) 13 9 10 28858 32
4097 28336 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3211 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/10/2004 12:00:00 AM 6 3X3   6006589.4855 2099557.2485 37.7453569717428 -122.419908520735 (37.7453569717428, -122.419908520735) 2 7 7 28859 2
4166 238733 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 10X Ogden Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6007494.00663 2096138.79584 37.7360215756409 -122.416538719384 (37.7360215756409, -122.416538719384) 2 7 7 28859 2
4167 234709 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 133 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002626.66594 2107357.19288 37.7665497010464 -122.434168786876 (37.7665497010464, -122.434168786876) 15 5 5 28862 3
4186 133880 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2864 Broadway 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 Width 4ft Permit Number 782825 5999941.97757 2117109.13743 37.7931733001669 -122.444155434443 (37.7931733001669, -122.444155434443) 13 9 1 57 27
4190 71445 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 60 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6013056.35208 2118942.99059 37.798948052957 -122.398907344312 (37.798948052957, -122.398907344312) 3 1 10 28860 6
4400 135044 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6010653.51415 2122133.031 37.8075729363076 -122.407447020463 (37.8075729363076, -122.407447020463) 3 1 10 308 23
4452 3272 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 4348 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   5994072.39789 2114299.50249 37.7851222112183 -122.464260315544 (37.7851222112183, -122.464260315544) 11 6 1 54 11
4477 57232 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 91 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/1975 12:00:00 AM     Permit Number 14519 6002939.30874382 2107370.92325937 37.7666051407068 -122.433088392926 (37.7666051407068, -122.433088392926) 15 5 5 28862 3
4653 14253 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2027 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004609.8473746 2108045.1512359 37.7685510269095 -122.427358323998 (37.7685510269095, -122.427358323998) 8 4 5 28862 3
4666 36564 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
4725 35344 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 822 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1998 12:00:00 AM 12   Permit Number 39079 6013033.1221 2103220.47445 37.7557763166346 -122.397884245859 (37.7557763166346, -122.397884245859) 10 3 8 28856 29
4938 260583 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
4974 139706 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 43 Cleary Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6005070.4283 2113762.4025 37.7842752408345 -122.426172290135 (37.7842752408345, -122.426172290135) 13 9 11 28858 41
5005 2976 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2187 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X2   6003939.8571 2115601.6948 37.7892615083399 -122.430214930957 (37.7892615083399, -122.430214930957) 13 9 11 29490 27
5036 52410 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1337 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2006 12:00:00 AM   3x3 Permit Number 48529 6007932.42258608 2116165.68067346 37.7910354039916 -122.416441058577 (37.7910354039916, -122.416441058577) 13 1 10 28858 21
5044 261415 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 787 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6009827.54432 2118442.11593 37.7973923321705 -122.410044757791 (37.7973923321705, -122.410044757791) 3 1 10 308 4
5071 254119 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 1 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
5107 135449 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 661 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6011377.91329 2117650.09103 37.7953043957415 -122.404624266194 (37.7953043957415, -122.404624266194) 3 1 10 28857 4
5255 133912 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2820 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6000502.17807 2116842.41263 37.7924728865637 -122.442197955664 (37.7924728865637, -122.442197955664) 13 6 1 29490 27
5256 20347 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 103X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 8                      
5349 3374 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6001 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     50 3X3   5988926.62731 2113977.75135 37.7839408343309 -122.482039284755 (37.7839408343309, -122.482039284755) 11 6 2 55 26
5359 22943 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 418 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/1995 12:00:00 AM 18 3X3   6006108.44593 2107152.36453 37.7661842876118 -122.422111355869 (37.7661842876118, -122.422111355869) 8 4 5 28853 19
5399 42533 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 616 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 10   Permit Number 42640 6009446.62137 2111558.04307 37.7784689692185 -122.410876400723 (37.7784689692185, -122.410876400723) 8 2 9 28853 34
5403 234597 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3808 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002970.74385 2103019.12696 37.754657938637 -122.432668772557 (37.754657938637, -122.432668772557) 2 4 5 28862 22
5635 907 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1206 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3x6   6003162.80838 2094269.92054 37.7306455348647 -122.431380036745 (37.7306455348647, -122.431380036745) 9 7 5 28861 25
5770 135182 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008631.75152 2122495.19515 37.8084539787355 -122.414469468391 (37.8084539787355, -122.414469468391) 3 1 10 308 23
5796 262396 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 470 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 3x3   6008904 2106030 37.7632598120529 -122.412362703349 (37.7632598120529, -122.412362703349) 8 4 7 28859 19
5863 18680 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 150X Richardson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 15X15TR   5999310.28796 2119651.54595 37.8001180187875 -122.446524108406 (37.8001180187875, -122.446524108406) 13 9 1 57 17

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