trees
3,587 rows where qSpecies_id = 28
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );