trees
3,587 rows where qSpecies_id = 28 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||||||||||||
| 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 | |||||||||||||||
| 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 | |||
| 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 | |||||||||||||
| 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 | |||||||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 9847 | 248795 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5175 Diamond Heights Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6000777.48804 | 2099988.6184 | 37.7462122622804 | -122.440036333505 | (37.7462122622804, -122.440036333505) | 2 | 4 | 5 | 63 | 22 | ||||
| 9867 | 18856 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004191.66186 | 2115995.22985 | 37.79035631503 | -122.429371791378 | (37.79035631503, -122.429371791378) | 13 | 9 | 1 | 29490 | 27 | |||
| 9872 | 19236 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 651 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002073.38012 | 2110681.82337 | 37.7756468948621 | -122.436320461165 | (37.7756468948621, -122.436320461165) | 15 | 5 | 11 | 29492 | 10 | |||
| 10052 | 14948 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016767.4558 | 2097838.85848 | 37.7412067724716 | -122.384594749942 | (37.7412067724716, -122.384594749942) | 10 | 3 | 8 | 58 | 1 | |||
| 10114 | 12679 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1302 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4x4 | 5991386.80092 | 2114799.39324 | 37.7863396121206 | -122.473588027094 | (37.7863396121206, -122.473588027094) | 11 | 6 | 1 | 54 | 33 | |||
| 10116 | 248844 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 38 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007344.42201 | 2099271.59206 | 37.7446151256805 | -122.417277828134 | (37.7446151256805, -122.417277828134) | 2 | 7 | 7 | 28859 | 2 | |||
| 10137 | 228617 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 576 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002640.85339 | 2103292.8906 | 37.7553909139673 | -122.43382918759 | (37.7553909139673, -122.43382918759) | 2 | 4 | 5 | 28862 | 22 | |||
| 10232 | 140742 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2001 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6001472.9963 | 2113178.7683 | 37.7824687423539 | -122.438576280753 | (37.7824687423539, -122.438576280753) | 15 | 5 | 11 | 29490 | 41 | |||
| 10238 | 255130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 10391 | 261268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999025.8241 | 2109069.656 | 37.771046664384 | -122.446746640696 | (37.771046664384, -122.446746640696) | 15 | 5 | 11 | 29492 | 9 | ||||
| 10613 | 56603 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4199@43rd Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 5982724.27515302 | 2106932.91664164 | 37.7642350821119 | -122.502975078628 | (37.7642350821119, -122.502975078628) | 1 | 8 | 3 | 56 | 35 | ||||
| 10635 | 255127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 10712 | 205508 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 620 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 5ft | 5991536.67412 | 2101158.90463 | 37.7488951701835 | -122.472074903552 | (37.7488951701835, -122.472074903552) | 1 | 8 | 4 | 29491 | 12 | |||
| 10799 | 212114 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1902x Monterey Blvd | 2 | Median : Yard | Tree | DPW 1 | 36 | Width 10ft | 5992265.63325 | 2095412.19532 | 37.7331583221951 | -122.469135994644 | (37.7331583221951, -122.469135994644) | 9 | 8 | 4 | 59 | 40 | |||
| 11020 | 261566 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 26th St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
| 11060 | 49693 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 23 | 5x5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |
| 11079 | 6325 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1895X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | 15 | 5 | 11 | 29490 | 41 | |||
| 11184 | 56634 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1917 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 6001626.77222134 | 2112852.27703888 | 37.7815810267112 | -122.438020890084 | (37.7815810267112, -122.438020890084) | 15 | 5 | 11 | 29490 | 41 | ||||
| 11261 | 117631 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3406 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 3x3 | 5998437.09993 | 2115571.11659 | 37.7888643370692 | -122.44925152374 | (37.7888643370692, -122.44925152374) | 13 | 6 | 1 | 54 | 31 | |||
| 11512 | 205516 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 309 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5992122.52237 | 2094864.24873 | 37.7316455276108 | -122.469590887926 | (37.7316455276108, -122.469590887926) | 9 | 8 | 4 | 59 | 40 |
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) );