3,587 rows where qSpecies_id = 28

View and edit SQL

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)
50 264964 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3641 California St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   5996989 2114619 37.7861671437011 -122.454192924446 (37.7861671437011, -122.454192924446) 11 6 1 54 31
69 126274 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1240 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 6ft   6006421.51674 2120105.21307 37.8017672864012 -122.421948716173 (37.8017672864012, -122.421948716173) 5 9 1 28858 32
79 121399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
100 255131 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree DPW 1                              
498 260403 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500X Brotherhood Way 1 Median : Yard Tree Private 2       30x30   5992691 2087881 37.712504070633 -122.467118029673 (37.712504070633, -122.467118029673) 9 8 6 64 24
600 35359 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 917 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 28 6x6 Permit Number 38821 6011905.65469 2104108.25722 37.7581511177091 -122.40184581615 (37.7581511177091, -122.40184581615) 10 3 8 28856 29
718 248748 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2179 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6008154.85604 2105734.66507 37.7624068229444 -122.414932848597 (37.7624068229444, -122.414932848597) 8 4 7 28859 19
903 212156 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 8 Keystone Way 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 2ft   5994073.78533 2092644.48269 37.7256631735017 -122.462684068539 (37.7256631735017, -122.462684068539) 9 8 4 59 40
1078 206334 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1795 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     47 Width 3ft   5993395.55114 2103268.51853 37.7547950231872 -122.465800214925 (37.7547950231872, -122.465800214925) 1 8 4 56 12
1111 99485 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 700X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
1342 189398 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1851 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6011885.07645 2106043.75786 37.7634644238751 -122.402053051422 (37.7634644238751, -122.402053051422) 8 3 8 28856 29
1661 126293 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009210.11859 2121881.78828 37.8068021921193 -122.412424475734 (37.8068021921193, -122.412424475734) 3 1 10 308 23
1663 27797 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
1723 19755 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY15 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
1845 20002 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY46 22 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
2050 50805 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1498 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2004 12:00:00 AM     Permit Number 47329 6000596.76427703 2111027.41746177 37.7765117981927 -122.441453229456 (37.7765117981927, -122.441453229456) 15 5 11 29492 41
2152 33675 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 469 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 13   Permit Number 37757 6005116.23557125 2111084.96150687 37.7769262359606 -122.425823168919 (37.7769262359606, -122.425823168919) 7 9 11 28852 10
2245 126164 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3404 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   5998411.11322 2115565.12364 37.7888463955847 -122.449341001806 (37.7888463955847, -122.449341001806) 13 6 1 54 31
2480 126159 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 240 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5998555.75349 2115712.4889 37.7892592941314 -122.448851187837 (37.7892592941314, -122.448851187837) 13 6 1 54 31
2496 331 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3402X 19th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/24/2008 12:00:00 AM 50 2X3   5990579.05408 2092494.42491 37.7250492609916 -122.474754004974 (37.7250492609916, -122.474754004974) 9 8 4 64 40
2519 175993 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Geneva Ave 12 Sidewalk: Property side : Yard Tree Private 2     23 Width 5ft   5998911.6853 2090582.51768 37.7202789369116 -122.445811669969 (37.7202789369116, -122.445811669969) 9 7 6 28861 25
2816 126194 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2323 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   6000797.30385 2116351.55373 37.7911419313024 -122.441141581441 (37.7911419313024, -122.441141581441) 13 6 1 29490 27
2868 255125 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 3 Sidewalk: Property side : Yard Tree DPW 1                              
2970 183328 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1216 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   5982775 2106802 37.7638786035994 -122.5027899471 (37.7638786035994, -122.5027899471) 1 8 3 56 35
2993 140841 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 128 JORDAN AVE 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 0ft   5996252.84 2113531.7423 37.7831395829214 -122.456661169882 (37.7831395829214, -122.456661169882) 11 6 1 54 31
3026 142443 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 58 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5997409.7349 2114492.5218 37.7858439854294 -122.452728168531 (37.7858439854294, -122.452728168531) 11 6 1 54 31
3319 255128 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 6 Sidewalk: Property side : Yard Tree DPW 1                              
3325 11719 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
3449 19754 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY15 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
3464 26465 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300X Keith St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017600.4401851 2096710.4383408 37.7381543871139 -122.381636098386 (37.7381543871139, -122.381636098386) 10 3 8 58 1
3585 14577 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1135 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     80 3X3   5999374.0888 2108906.7208 37.7706191740488 -122.445530268097 (37.7706191740488, -122.445530268097) 15 5 11 29492 9
3631 260410 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400X Brotherhood Way 10 Side Yard : Yard Tree Private 2       30x30   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
3647 140646 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 103 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   5997289.8373 2110082.6858 37.7737288612874 -122.452824572833 (37.7737288612874, -122.452824572833) 15 5 2 29492 16
3684 98923 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3527 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   5997962.31773 2115134.58282 37.7876385629149 -122.450862707746 (37.7876385629149, -122.450862707746) 11 6 1 54 31
3706 248884 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2250 Harrison St 16 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008760.77661 2105142.80494 37.760815739663 -122.412795340833 (37.760815739663, -122.412795340833) 2 4 7 28859 19
3865 105892 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1100 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
3974 2063 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 800X Bosworth St 10 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6001908.8431877 2095495.9697002 37.7339408370986 -122.435802866841 (37.7339408370986, -122.435802866841) 9 7 5 63 7
4083 19998 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY46 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
4157 52083 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 770 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2005 12:00:00 AM     Permit Number 48281 6010080.56543171 2116389.03640526 37.7917692527785 -122.409024297587 (37.7917692527785, -122.409024297587) 5 1 10 28857 21
4413 106528 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2100 Baker St 4 Sidewalk: Curb side : Cutout Tree Private 2     23     5999888.51189 2116174.57366 37.7906041834903 -122.444273238422 (37.7906041834903, -122.444273238422) 13 6 1 29490 27
4470 19187 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 125 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003528.70248 2107586.69801 37.7672310211182 -122.431065186025 (37.7672310211182, -122.431065186025) 7 9 5 28862 3
4977 11672 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 710X Junipero Serra Blvd 9 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 6X6   5991310.6193982 2092985.752428 37.7264406890913 -122.472260886614 (37.7264406890913, -122.472260886614) 9 8 4 64 40
5016 29966 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500x Junipero Serra Blvd 10 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3x3   5991400.88182 2093544.5626 37.7279802659702 -122.471989567778 (37.7279802659702, -122.471989567778) 9 8 4 59 40
5059 255129 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 7 Sidewalk: Property side : Yard Tree DPW 1                              
5073 212283 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 751 Junipero Serra Blvd 31 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5991413.76911 2093002.29122 37.726492069641 -122.47190551083 (37.726492069641, -122.47190551083) 9 8 4 59 40
5129 255126 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 4 Sidewalk: Property side : Yard Tree DPW 1                              
5246 262331 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 2140 Wawona St 1 Back Yard : Cutout Tree Private 2       3x3   5986390 2097232 37.7378137677629 -122.489583137449 (37.7378137677629, -122.489583137449) 1 8 3 29491 35
5273 218292 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 16 Sidewalk: Curb side : Yard Tree Private 2     39     5991223.38049 2095418.74528 37.7331160279643 -122.472739784911 (37.7331160279643, -122.472739784911) 1 8 4 64 40
5274 212748 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1583 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   5992725 2104704 37.7586977784353 -122.468223565677 (37.7586977784353, -122.468223565677) 1 8 4 56 12
5281 189460 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400 Keith St 6 : Tree Private 2     23 Width 3ft   6017666.55512 2096787.33958 37.7383691928822 -122.38141284964 (37.7383691928822, -122.38141284964) 10 3 8 58 1
5305 5766 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 414 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6003770.1384677 2108392.97573 37.769458541933 -122.430287624255 (37.769458541933, -122.430287624255) 15 9 5 29492 10
5505 175991 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Geneva Ave 5 Sidewalk: Property side : Yard Tree Private 2     14 Width 5ft   5998793.12652 2090644.11661 37.7204413031987 -122.44622591569 (37.7204413031987, -122.44622591569) 9 7 6 28861 25
5510 104813 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X Portola Dr 5 Front Yard : Yard Tree Private 2                              
5631 50066 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 406 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46794 6003569.14495563 2105912.6827965 37.7626368713078 -122.430805824209 (37.7626368713078, -122.430805824209) 15 4 5 28862 3
5676 122158 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 515 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 6ft   5991239.57046 2111867.63351 37.7782812827035 -122.473883434468 (37.7782812827035, -122.473883434468) 11 6 2 54 26
5844 99991 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
6068 244550 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1544 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   5999032 2109089 37.7711001308876 -122.446726670211 (37.7711001308876, -122.446726670211) 15 5 11 29492 9
6176 217849 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 4 Sidewalk: Curb side : Yard Tree Private 2     33     5991387.06493 2095679.62189 37.7338418033391 -122.47219289908 (37.7338418033391, -122.47219289908) 1 8 4 64 40
6191 244986 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1443 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5999693.832 2109119.8472 37.7712226140057 -122.44443959552 (37.7712226140057, -122.44443959552) 15 5 11 29492 9
6376 206322 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1580 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5992477.65617 2104709.18498 37.7586977265366 -122.469079363447 (37.7586977265366, -122.469079363447) 1 8 4 56 12
6425 102410 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 55X Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2           6000310.8 2109142 37.7713186232103 -122.442307075209 (37.7713186232103, -122.442307075209) 15 5 11 29492 9
6473 48743 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
6508 14990 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Mendell St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016422.44289 2097376.45794 37.7399180286864 -122.385755471644 (37.7399180286864, -122.385755471644) 10 3 8 58 1
6611 262204 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 907 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001442 2095927 37.735097816857 -122.437447738546 (37.735097816857, -122.437447738546) 2 7 5 63 7
6726 2033 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 700X Bosworth St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002154.6210393 2095431.8532492 37.7337787461998 -122.434948555048 (37.7337787461998, -122.434948555048) 2 7 5 63 7
6862 248858 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 890x Jarboe Ave 3 Sidewalk: Curb side : Yard Tree Private 2     32 Width 3ft   6009086.77002 2096874.94764 37.7381323357451 -122.411083856354 (37.7381323357451, -122.411083856354) 10 7 7 28859 2
6987 249466 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 900x Van Ness Ave 4 Median : Yard Tree DPW 1     25     6006522.49711 2113836.87509 37.7845616899264 -122.421153924138 (37.7845616899264, -122.421153924138) 7 9 11 28858 36
7147 260402 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10X Arch St 1 Median : Yard Tree DPW 1       3X5   5992587 2087523 37.7115150847083 -122.467451465905 (37.7115150847083, -122.467451465905) 9 8 4 64 24
7199 5759 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     27 3X3   6003976.63728 2108405.62354 37.7695049641016 -122.42957425574 (37.7695049641016, -122.42957425574) 7 9 5 29492 10
7215 140951 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2060 Ofarrell St 9 Sidewalk: Property side : Cutout Tree Private 2     15 Width 0ft   6001488 2113369 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913) 15 5 11 29490 41
7358 108758 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1449 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2           5999638.3 2109087.9 37.7711317264146 -122.444629385712 (37.7711317264146, -122.444629385712) 15 5 11 29492 9
7374 48751 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
7450 140945 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2060 Ofarrell St 3 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   6001488 2113369 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913) 15 5 11 29490 41
7629 248826 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 187 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6007246.75289 2097900.1277 37.7408438951347 -122.417518368874 (37.7408438951347, -122.417518368874) 2 7 7 28859 2
7755 126345 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 504 Clay St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6011901.4963 2117456.13794 37.7948010955445 -122.402798926636 (37.7948010955445, -122.402798926636) 3 1 10 28860 4
7848 54566 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1312 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/1972 12:00:00 AM   3x3 Permit Number 10364 6000274.16247872 2109249.10106233 37.7716106075543 -122.44244149612 (37.7716106075543, -122.44244149612) 15 5 11 29492 9
7881 260404 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500X Brotherhood Way 2 Median : Yard Tree Private 2       30x30   5992691 2087881 37.712504070633 -122.467118029673 (37.712504070633, -122.467118029673) 9 8 6 64 24
7909 244126 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1777 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 0ft   5998100.8363 2108896.3044 37.7705178019644 -122.449933692773 (37.7705178019644, -122.449933692773) 15 5 11 29492 9
7933 142422 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 37 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5997618.0335 2114520.9492 37.7859339729155 -122.452009568816 (37.7859339729155, -122.452009568816) 11 6 1 54 31
7991 16770 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1900X O'Farrell St 13 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6002203.1786904 2113328.4738156 37.7829213052255 -122.43606088796 (37.7829213052255, -122.43606088796) 13 5 11 29490 41
8101 248796 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Worth St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 Width 4ft   6000890.35954 2103205.50188 37.7550514765476 -122.439876646295 (37.7550514765476, -122.439876646295) 2 4 5 28862 22
8104 140395 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1270 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 0ft   6004643.5766 2113229.4094 37.7827876389021 -122.427611060911 (37.7827876389021, -122.427611060911) 7 9 11 29490 41
8313 248765 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2601 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008962 2103248 37.7556243278629 -122.411965491523 (37.7556243278629, -122.411965491523) 2 4 7 28859 19
8333 126339 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6012176.42228 2117479.41237 37.7948803483084 -122.401849275842 (37.7948803483084, -122.401849275842) 3 1 10 28860 4
8604 48746 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
8612 255133 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 11 Sidewalk: Property side : Yard Tree DPW 1                              
8634 176044 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     21     5990534.22824 2089263.30634 37.7161748133009 -122.474673246391 (37.7161748133009, -122.474673246391) 1 8 4 64 14
8782 22575 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 799X Turk St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6006314.95978 2112814.99848 37.7817441651975 -122.421799324385 (37.7817441651975, -122.421799324385) 7 9 11 28852 41
8893 50823 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
8922 222961 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 36 McCoppin St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 4ft   6006486.54397 2109181.00608 37.771775773859 -122.420947632224 (37.771775773859, -122.420947632224) 8 2 9 28853 19
9073 205507 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1518 05th Ave 1 Sidewalk: Curb side : Pot Tree Private 2     24     5994641.65352 2105137.30281 37.7599980266194 -122.46162636506 (37.7599980266194, -122.46162636506) 15 5 4 56 12
9117 228585 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3235 19th St 4 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6007970.58084 2105049.92867 37.7605163382874 -122.415521709372 (37.7605163382874, -122.415521709372) 2 4 7 28859 19
9139 12607 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 653 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     125 9x7   5993406.40366 2114819.71467 37.7865121620391 -122.466602254029 (37.7865121620391, -122.466602254029) 11 6 2 54 11
9174 182756 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1770 31st Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5986605.7278 2103174.4256 37.7541426657227 -122.489274060805 (37.7541426657227, -122.489274060805) 1 8 3 56 35
9226 99970 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
9240 126178 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2413 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6000282.738 2119543.98555 37.7998781830919 -122.44315133689 (37.7998781830919, -122.44315133689) 13 9 1 57 17
9354 121493 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 800x De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012099.85909 2104630.58778 37.7595961582563 -122.401210873181 (37.7595961582563, -122.401210873181) 10 3 8 28856 29
9696 248880 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3180 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2020 12:00:00 AM 3 Width 3ft   6008273.77565 2105652.37394 37.7621875520344 -122.414515725045 (37.7621875520344, -122.414515725045) 8 4 7 28859 19
9800 212749 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1583 11th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5992738.61571 2104699.348 37.7586857916279 -122.46817613833 (37.7586857916279, -122.46817613833) 1 8 4 56 12
9809 120740 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 682 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   5989760.03773 2110677.58416 37.7749279292467 -122.478914562404 (37.7749279292467, -122.478914562404) 11 6 2 55 26

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