trees
3,587 rows where qSpecies_id = 28 sorted by PermitNotes descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80991 | 105000 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X SAN MARCOS AVE | 1 | Median : Cutout | Tree | DPW 1 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | 1 | 8 | 4 | 29491 | 40 | |||
| 59195 | 93735 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.7714793693282 | -122.44403704657 | (37.7714793693282, -122.44403704657) | 15 | 5 | 11 | 29492 | 9 | ||||
| 169352 | 103020 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 40X Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | See 61 Fair Ave property permits | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 | |
| 140857 | 54249 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1274 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1972 12:00:00 AM | 20 | Permit Number 9991 | 5988659.40013717 | 2106655.34316867 | 37.7638199891792 | -122.482427078169 | (37.7638199891792, -122.482427078169) | 1 | 8 | 3 | 56 | 35 | ||
| 177677 | 54185 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1526 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | 30 | 4x4 | Permit Number 9920 | 6015598.37895 | 2096494.31778 | 37.7374502170542 | -122.388543207207 | (37.7374502170542, -122.388543207207) | 10 | 3 | 8 | 58 | 1 | |
| 187399 | 54132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 461 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | 24 | Permit Number 9865 | 6012176.49549 | 2086499.28373 | 37.7098156657361 | -122.3996727573 | (37.7098156657361, -122.3996727573) | 10 | 3 | 8 | 309 | 1 | ||
| 67808 | 54126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 415 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | 16 | Permit Number 9859 | 6012243.80314 | 2086705.19326 | 37.7103848043898 | -122.399454574563 | (37.7103848043898, -122.399454574563) | 10 | 3 | 8 | 309 | 1 | ||
| 76985 | 53997 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 437 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1972 12:00:00 AM | 27 | Permit Number 9715 | 6012213.68621 | 2086616.77811 | 37.7101403551771 | -122.399552462203 | (37.7101403551771, -122.399552462203) | 10 | 3 | 8 | 309 | 1 | ||
| 131440 | 53996 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 409 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1972 12:00:00 AM | 33 | Permit Number 9714 | 6012251.58643 | 2086735.61671 | 37.7104687749864 | -122.399429808164 | (37.7104687749864, -122.399429808164) | 10 | 3 | 8 | 309 | 1 | ||
| 36380 | 206411 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 241 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | Permit Number 779935 | 5993240.35303 | 2102520.36003 | 37.752731819221 | -122.466282559112 | (37.752731819221, -122.466282559112) | 1 | 8 | 4 | 29491 | 12 | ||
| 100667 | 173939 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2017 12:00:00 AM | 3 | 5xt | Permit Number 779890 | 6014341 | 2104455 | 37.7592388085315 | -122.393447541112 | (37.7592388085315, -122.393447541112) | 10 | 3 | 8 | 28856 | 29 | |
| 192160 | 126134 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2829 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | Permit Number 779774 | 6000559.90395 | 2118036.87537 | 37.7957558571972 | -122.442084000781 | (37.7957558571972, -122.442084000781) | 13 | 9 | 1 | 57 | 17 | ||
| 151347 | 57857 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 491 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/1984 12:00:00 AM | 15 | Permit Number 779316 | 5992173.14952 | 2112167.29906 | 37.7791581122705 | -122.470675702426 | (37.7791581122705, -122.470675702426) | 11 | 6 | 2 | 54 | 11 | ||
| 46109 | 117119 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 447 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 5x9 | Permit Number 778563 | 5997182.09338 | 2114812.8648 | 37.7867105156148 | -122.45353887881 | (37.7867105156148, -122.45353887881) | 11 | 6 | 1 | 54 | 31 | |
| 146501 | 104806 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 101X4 Surrey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | Permit Number 776355 | 6002238.26788 | 2096221.16673 | 37.7359507686256 | -122.43471578665 | (37.7359507686256, -122.43471578665) | 2 | 7 | 5 | 63 | 7 | ||
| 150631 | 104803 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 101X5 Surrey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | Permit Number 776355 | 6002238.26788 | 2096221.16673 | 37.7359507686256 | -122.43471578665 | (37.7359507686256, -122.43471578665) | 2 | 7 | 5 | 63 | 7 | ||
| 60738 | 98320 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1811 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | |
| 177146 | 33677 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 455 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 773435 | 6005180.13897934 | 2111093.89138396 | 37.776954366261 | -122.425602743023 | (37.776954366261, -122.425602743023) | 7 | 9 | 11 | 28852 | 10 | |||
| 192542 | 106951 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 156 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2014 12:00:00 AM | 22 | 3x3 | Permit Number 773389 | 5987431.57269 | 2114958.38797 | 37.7865463157209 | -122.487283609867 | (37.7865463157209, -122.487283609867) | 11 | 6 | 1 | 55 | 33 | |
| 74316 | 106886 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 580 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2014 12:00:00 AM | 3 | Permit Number 772874 | 6011893.85928 | 2117261.69096 | 37.7942667642387 | -122.402811670039 | (37.7942667642387, -122.402811670039) | 3 | 1 | 10 | 28860 | 4 | ||
| 35906 | 99475 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 44 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
| 57864 | 99459 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 550X Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |
| 97346 | 99476 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
| 175997 | 1273 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3995X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 771193 | 5992398.03069 | 2087322.14949 | 37.7109526858011 | -122.468089986885 | (37.7109526858011, -122.468089986885) | 9 | 8 | 4 | 64 | 24 | ||
| 95752 | 62433 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4392 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 770962 | 6000030.87492783 | 2105785.85783865 | 37.7620875372244 | -122.443034282049 | (37.7620875372244, -122.443034282049) | 15 | 5 | 5 | 28862 | 3 | ||
| 14878 | 104430 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 73-75 MIRABEL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | Permit Number 770914 | 6007834 | 2100080 | 37.7468623651304 | -122.415642186435 | (37.7468623651304, -122.415642186435) | 2 | 7 | 7 | 28859 | 2 | ||
| 36198 | 39935 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/25/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770539 | 6010138.7177 | 2087941.04422 | 37.713660642495 | -122.406817269312 | (37.713660642495, -122.406817269312) | 9 | 7 | 8 | 309 | 39 |
| 15723 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | ||
| 179978 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1600X OAKDALE AVE | 1 | Front Yard : Yard | Tree | Arts Commission 19 | 13 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
| 9937 | 99488 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 1 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |
| 11098 | 99478 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 4 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
| 47424 | 99456 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Miramar Ave | 6 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.458120762721 | (37.7250639553871, -122.458120762721) | 9 | 7 | 4 | 28861 | 40 | |
| 57898 | 99471 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 7 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |
| 59487 | 99491 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 5 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |
| 100839 | 99490 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 4 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |
| 188566 | 99482 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 1 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |
| 179000 | 55340 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | Permit Number 769406 | 5992478.56101588 | 2104770.1953725 | 37.7588652973721 | -122.469080674313 | (37.7588652973721, -122.469080674313) | 1 | 8 | 4 | 56 | 12 | |||
| 152578 | 26455 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017718.24501 | 2096772.85897 | 37.7383322855952 | -122.381233122826 | (37.7383322855952, -122.381233122826) | 10 | 3 | 8 | 58 | 1 | ||
| 52388 | 99208 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | 9 | 7 | 8 | 309 | 39 | ||||
| 134772 | 99209 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | 9 | 7 | 8 | 309 | 39 | ||||
| 71042 | 98705 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1050 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768656 | 6007880.11955 | 2092984.06974 | 37.7273810881671 | -122.414980548629 | (37.7273810881671, -122.414980548629) | 9 | 3 | 7 | 309 | 5 | |
| 31529 | 97954 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 140 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 3x3 | Permit Number 768198 | 5995938.36032 | 2113419.39672 | 37.7828130508284 | -122.457741003486 | (37.7828130508284, -122.457741003486) | 11 | 6 | 1 | 54 | 31 | ||
| 174723 | 53624 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4330 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1970 12:00:00 AM | Permit Number 6555 | 6001727.50679504 | 2101199.57281892 | 37.7495912931369 | -122.436837965286 | (37.7495912931369, -122.436837965286) | 2 | 4 | 5 | 28862 | 22 | |||
| 172855 | 53614 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 157 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1970 12:00:00 AM | 25 | Permit Number 6545 | 5993950.70262 | 2114432.49008 | 37.7854803438469 | -122.464691000244 | (37.7854803438469, -122.464691000244) | 11 | 6 | 2 | 54 | 11 | ||
| 146349 | 53581 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 149 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1970 12:00:00 AM | 20 | Permit Number 6509 | 5993949.30457 | 2114483.86823 | 37.7856213336586 | -122.464699569266 | (37.7856213336586, -122.464699569266) | 11 | 6 | 2 | 54 | 11 | ||
| 149432 | 53401 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 730 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1969 12:00:00 AM | 19 | Permit Number 6300 | 5990392.09793 | 2110392.49513 | 37.7741818356132 | -122.476707321825 | (37.7741818356132, -122.476707321825) | 11 | 6 | 2 | 55 | 26 | ||
| 185735 | 92211 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.7243160320082 | -122.458116274775 | (37.7243160320082, -122.458116274775) | 9 | 8 | 4 | 28861 | 24 | ||
| 30283 | 94848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53927 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |
| 96830 | 92208 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.7243160320082 | -122.458116274775 | (37.7243160320082, -122.458116274775) | 9 | 8 | 4 | 28861 | 24 | ||
| 137719 | 92209 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.7243160320082 | -122.458116274775 | (37.7243160320082, -122.458116274775) | 9 | 8 | 4 | 28861 | 24 | ||
| 166309 | 41920 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 612 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52406 | 5995349.87473 | 2111350.37207 | 37.777098235843 | -122.459626997558 | (37.777098235843, -122.459626997558) | 11 | 6 | 2 | 54 | 11 | |
| 161476 | 85112 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4201 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51811 | 6001198 | 2102882 | 37.7541807256906 | -122.438789558922 | (37.7541807256906, -122.438789558922) | 2 | 4 | 5 | 28862 | 22 | |||
| 171233 | 81639 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 678 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 10 | 3x3 | Permit Number 51574 | 5994125.833 | 2110896.56875 | 37.7757817513518 | -122.463828362424 | (37.7757817513518, -122.463828362424) | 11 | 6 | 2 | 54 | 11 | |
| 187374 | 82865 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 614 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51572 | 5994112.63762 | 2111294.28874 | 37.7768730237535 | -122.463902883988 | (37.7768730237535, -122.463902883988) | 11 | 6 | 2 | 54 | 11 | |
| 36474 | 88364 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2559 33rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51343 | 5986101.6 | 2097823.5 | 37.739421027827 | -122.490623769288 | (37.739421027827, -122.490623769288) | 1 | 8 | 3 | 29491 | 35 | |||
| 111100 | 87974 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2160 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51010 | 5999212.8 | 2111613.6 | 37.7780423637934 | -122.446282917617 | (37.7780423637934, -122.446282917617) | 15 | 5 | 11 | 54 | 16 | ||
| 27213 | 87671 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50395 | 5987244 | 2115292 | 37.7874513785554 | -122.487957078163 | (37.7874513785554, -122.487957078163) | 11 | 6 | 1 | 55 | 33 | ||
| 85829 | 87052 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 Euclid Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 50168 | 5996764.3 | 2113789 | 37.7838752968943 | -122.454910329525 | (37.7838752968943, -122.454910329525) | 11 | 6 | 1 | 54 | 31 | |||
| 22089 | 86892 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
| 29279 | 86893 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | ||
| 121257 | 86891 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
| 136340 | 86890 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
| 80097 | 53212 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 132 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2006 12:00:00 AM | Permit Number 49185 | 6004089.5020644 | 2108196.64307491 | 37.7689375443291 | -122.42916895785 | (37.7689375443291, -122.42916895785) | 7 | 9 | 5 | 28862 | 3 | |||
| 88292 | 53058 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 235@ FOLSOM Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.7902200672067 | -122.392792095849 | (37.7902200672067, -122.392792095849) | 6 | 2 | 9 | 28855 | 6 | |||
| 124291 | 53057 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 235@ FOLSOM Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.7902200672067 | -122.392792095849 | (37.7902200672067, -122.392792095849) | 6 | 2 | 9 | 28855 | 6 | |||
| 129018 | 53059 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 235@ FOLSOM Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.7902200672067 | -122.392792095849 | (37.7902200672067, -122.392792095849) | 6 | 2 | 9 | 28855 | 6 | ||||
| 29844 | 53048 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 65@ APPLETON Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2006 12:00:00 AM | Permit Number 49026 | 6005683.68607987 | 2097324.15915168 | 37.7391743410359 | -122.422881952522 | (37.7391743410359, -122.422881952522) | 2 | 7 | 7 | 28859 | 2 | |||
| 175551 | 52775 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3006 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48821 | 6000400.26777078 | 2115518.80324345 | 37.7888327924103 | -122.442455496921 | (37.7888327924103, -122.442455496921) | 13 | 6 | 1 | 29490 | 27 | |||
| 53453 | 52252 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 237 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2005 12:00:00 AM | Permit Number 48419 | 6006717.04487845 | 2104738.84078637 | 37.7595916236736 | -122.419835049965 | (37.7595916236736, -122.419835049965) | 2 | 4 | 7 | 28859 | 19 | |||
| 100271 | 52239 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025REVISED Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2006 12:00:00 AM | 20 | Permit Number 48410 | 6011950.95504 | 2103369.42747 | 37.7561249819912 | -122.401637218391 | (37.7561249819912, -122.401637218391) | 10 | 3 | 8 | 28856 | 29 | |
| 44167 | 141431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 17 | Width 0ft | Permit Number 48304 | 6005404.7905 | 2110954.8993 | 37.7765854191309 | -122.424815713066 | (37.7765854191309, -122.424815713066) | 7 | 9 | 11 | 28852 | 10 | |
| 79926 | 52113 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 4x4 | Permit Number 48304 | 6005450.41519372 | 2110958.1148217 | 37.7765968250138 | -122.424658112662 | (37.7765968250138, -122.424658112662) | 7 | 9 | 11 | 28852 | 10 | |
| 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 | |||
| 125394 | 33517 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 148 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2005 12:00:00 AM | Permit Number 48274 | 6007365.58443644 | 2098215.69549509 | 37.7417170598475 | -122.417129847866 | (37.7417170598475, -122.417129847866) | 2 | 7 | 7 | 28859 | 2 | |||
| 139722 | 52036 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 551 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2005 12:00:00 AM | Permit Number 48248 | 6003933.03406109 | 2105071.04130005 | 37.7603465352707 | -122.429487238107 | (37.7603465352707, -122.429487238107) | 2 | 4 | 5 | 28862 | 3 | |||
| 56876 | 51669 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 852@ DIAMOND Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47947 | 6001771.23876172 | 2095874.53487777 | 37.7349724722871 | -122.436305690211 | (37.7349724722871, -122.436305690211) | 2 | 7 | 5 | 63 | 7 | |||
| 70393 | 51565 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3860 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47863 | 6004041.27502949 | 2102496.18556684 | 37.7532827184773 | -122.428929306917 | (37.7532827184773, -122.428929306917) | 2 | 4 | 5 | 28862 | 22 | |||
| 35363 | 51559 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 29 West Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691 | (37.7868031451511, -122.48266323691) | 11 | 6 | 1 | 55 | 33 | ||||
| 123608 | 51557 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 29 West Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2005 12:00:00 AM | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691 | (37.7868031451511, -122.48266323691) | 11 | 6 | 1 | 55 | 33 | |||
| 171368 | 51558 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 29 West Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2005 12:00:00 AM | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691 | (37.7868031451511, -122.48266323691) | 11 | 6 | 1 | 55 | 33 | |||
| 90029 | 46076 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3800 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.7889525925387 | -122.455658560713 | (37.7889525925387, -122.455658560713) | 11 | 6 | 1 | 54 | 31 | |||
| 29446 | 50634 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.7220575083684 | -122.393261977074 | (37.7220575083684, -122.393261977074) | 10 | 3 | 8 | 58 | 1 | ||
| 102301 | 50635 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.7220575083684 | -122.393261977074 | (37.7220575083684, -122.393261977074) | 10 | 3 | 8 | 58 | 1 | ||
| 118360 | 50633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 7 | Permit Number 47740 | 6014091.6306 | 2090874.9645 | 37.721936997211 | -122.393359654849 | (37.721936997211, -122.393359654849) | 10 | 3 | 8 | 58 | 1 | |
| 73514 | 51264 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 791 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2004 12:00:00 AM | 11 | Permit Number 47641 | 5991632.45779 | 2110058.1497 | 37.7733356814549 | -122.472392358685 | (37.7733356814549, -122.472392358685) | 11 | 6 | 2 | 54 | 26 | |
| 176127 | 51265 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 791 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2004 12:00:00 AM | 14 | Permit Number 47641 | 5991632.71365 | 2110039.25333 | 37.7732838119525 | -122.472390095818 | (37.7732838119525, -122.472390095818) | 11 | 6 | 2 | 54 | 26 | |
| 98709 | 51158 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2663DIVISADERO Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 47563 | 6000913.18019234 | 2117191.80900567 | 37.7934556526619 | -122.440800954263 | (37.7934556526619, -122.440800954263) | 13 | 9 | 1 | 29490 | 27 | |||
| 144582 | 51155 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2663DIVISADERO Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 47563 | 6000913.18019234 | 2117191.80900567 | 37.7934556526619 | -122.440800954263 | (37.7934556526619, -122.440800954263) | 13 | 9 | 1 | 29490 | 27 | |||
| 65316 | 50979 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Richardson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | 13 | 9 | 1 | 57 | 17 | ||
| 108722 | 50969 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3901 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 47462 | 6002458.87676393 | 2102943.00430693 | 37.7544198816731 | -122.43443350231 | (37.7544198816731, -122.43443350231) | 2 | 4 | 5 | 28862 | 22 | |||
| 111178 | 50878 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2506 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47388 | 6002262.04828144 | 2097251.96755917 | 37.7387824596371 | -122.434707255995 | (37.7387824596371, -122.434707255995) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | ||||||||||||||
| 11935 | 50824 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
| 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 | |||
| 160664 | 50804 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1498 Fulton St | 1 | 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 | |||
| 24910 | 50685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.7654709832109 | -122.446105453704 | (37.7654709832109, -122.446105453704) | 15 | 5 | 11 | 29492 | 9 | ||||
| 101637 | 50657 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 35 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2005 12:00:00 AM | Permit Number 47239 | 5995410.10661733 | 2114891.76691609 | 37.7868254226819 | -122.4596752059 | (37.7868254226819, -122.4596752059) | 11 | 6 | 1 | 54 | 11 | ||
| 24682 | 50574 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
| 121795 | 50567 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
| 158590 | 50572 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 |
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) );