trees
7,322 rows where qSpecies_id = 1 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 191624 | 30542 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011709.31572 | 2086131.9776 | 37.7087810622767 | -122.401261631812 | (37.7087810622767, -122.401261631812) | 10 | 3 | 8 | 309 | 1 | ||
| 191613 | 242281 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 97 Surrey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002436.28815 | 2096209.43112 | 37.7359297854187 | -122.434030313749 | (37.7359297854187, -122.434030313749) | 2 | 7 | 5 | 63 | 7 | |||
| 191560 | 218518 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 313 Vernon St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992449.51413 | 2089938.14589 | 37.7181385540341 | -122.468102219449 | (37.7181385540341, -122.468102219449) | 9 | 8 | 6 | 64 | 24 | |||
| 191428 | 182560 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2406 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5988921.7777 | 2098919.1965 | 37.7425938548503 | -122.480953150756 | (37.7425938548503, -122.480953150756) | 1 | 8 | 3 | 29491 | 35 | |||
| 191360 | 26055 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 208 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 12 | 3X3 | 5994913.3827 | 2088108.904 | 37.7132578740277 | -122.459453336762 | (37.7132578740277, -122.459453336762) | 9 | 8 | 6 | 28861 | 24 | ||
| 191345 | 241496 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5343 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001795.3495 | 2098758.70429 | 37.7428931002319 | -122.436428688729 | (37.7428931002319, -122.436428688729) | 2 | 7 | 5 | 63 | 22 | |||
| 191323 | 218646 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2535 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992035.59264 | 2098183.49132 | 37.7407543064593 | -122.470133027142 | (37.7407543064593, -122.470133027142) | 1 | 8 | 4 | 59 | 40 | |||
| 191311 | 180377 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4225 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003448.49458 | 2093862.26026 | 37.7295423784809 | -122.43036330204 | (37.7295423784809, -122.43036330204) | 9 | 7 | 6 | 28861 | 5 | |||
| 191310 | 218658 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Montecito Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995766.17765 | 2093995.939 | 37.729471272674 | -122.456931345522 | (37.729471272674, -122.456931345522) | 9 | 7 | 4 | 28861 | 40 | |||
| 191300 | 120100 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2533 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5987545.43953 | 2114607.53447 | 37.785589611835 | -122.486863889097 | (37.785589611835, -122.486863889097) | 11 | 6 | 1 | 55 | 26 | |||
| 191190 | 29005 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/2015 07:53:00 AM | 3 | 3x3 | 6008208.2208875 | 2110209.5743773 | 37.7746968767058 | -122.41506503651 | (37.7746968767058, -122.41506503651) | 8 | 2 | 9 | 28853 | 34 | ||
| 191144 | 36931 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | 2 | 4 | 5 | 28862 | 22 | ||
| 191137 | 38184 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 103 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011280.82748459 | 2091572.16346792 | 37.7236947961561 | -122.403124961994 | (37.7236947961561, -122.403124961994) | 10 | 3 | 7 | 309 | 28 | ||
| 191102 | 241850 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007580.50764 | 2095766.23952 | 37.7350034819312 | -122.416213271832 | (37.7350034819312, -122.416213271832) | 2 | 7 | 7 | 28859 | 2 | |||
| 191061 | 25274 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1800 Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | ||
| 191005 | 46317 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 223 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 2 | Permit Number 770321 | 5997090.07617 | 2115477.21547 | 37.788529370173 | -122.453905230236 | (37.788529370173, -122.453905230236) | 11 | 6 | 1 | 54 | 31 | ||
| 190984 | 6894 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290X Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6006033.4892 | 2110743.33668 | 37.7760400091506 | -122.42262582137 | (37.7760400091506, -122.42262582137) | 7 | 9 | 11 | 28852 | 10 | ||
| 190970 | 44732 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Quintara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 4 | Permit Number 43848 | 5989535.4536 | 2101093.9541 | 37.7486008227669 | -122.478990298749 | (37.7486008227669, -122.478990298749) | 1 | 8 | 3 | 29491 | 35 | |
| 190945 | 41231 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3710 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 7 | Permit Number 41936 | 6002578.78066 | 2121369.73196 | 37.8050218537344 | -122.435336848833 | (37.8050218537344, -122.435336848833) | 13 | 9 | 1 | 57 | 17 | |
| 190944 | 143054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1731 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010429.028 | 2120490.458 | 37.8030502706615 | -122.408107992666 | (37.8030502706615, -122.408107992666) | 3 | 1 | 10 | 308 | 23 | |||
| 190904 | 103387 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 42 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2013 12:00:00 AM | 3x3 | Permit Number 769958 | 5995374.8 | 2090202.8 | 37.7190337388046 | -122.458009970496 | (37.7190337388046, -122.458009970496) | 9 | 8 | 6 | 28861 | 24 | ||
| 190903 | 242173 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3819 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004201.56268 | 2104798.41226 | 37.7596131608338 | -122.428539089324 | (37.7596131608338, -122.428539089324) | 2 | 4 | 5 | 28862 | 3 | |||
| 190880 | 214870 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1572 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993712.20671 | 2104792.35709 | 37.7589973509571 | -122.464815797229 | (37.7589973509571, -122.464815797229) | 1 | 8 | 4 | 56 | 12 | |||
| 190875 | 86091 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2511 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987659.1568 | 2098185.1971 | 37.7405050107247 | -122.485265023683 | (37.7405050107247, -122.485265023683) | 1 | 8 | 3 | 29491 | 35 | ||
| 190853 | 241479 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 622 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002483.32884 | 2098895.95708 | 37.7433090330768 | -122.434059659549 | (37.7433090330768, -122.434059659549) | 2 | 7 | 5 | 63 | 22 | |||
| 190851 | 65703 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 218 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 8 | Permit Number 28632 | 6000082.25042 | 2087566.75873 | 37.7120651111999 | -122.441549123596 | (37.7120651111999, -122.441549123596) | 9 | 7 | 6 | 28861 | 5 | |
| 190850 | 85982 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2326 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987662.5102 | 2099444.7655 | 37.7439636479591 | -122.485345832299 | (37.7439636479591, -122.485345832299) | 1 | 8 | 3 | 29491 | 35 | ||
| 190825 | 29081 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2230 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2006 12:00:00 AM | 6 | 3x3 | 6009630 | 2104353 | 37.7586958643533 | -122.409733320805 | (37.7586958643533, -122.409733320805) | 2 | 4 | 7 | 28859 | 19 | ||
| 190767 | 242114 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 102 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6004092.37068 | 2102414.1734 | 37.7530604243187 | -122.428746761659 | (37.7530604243187, -122.428746761659) | 2 | 4 | 5 | 28862 | 22 | |||
| 190755 | 25249 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Ocean Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | 6 | 3x3 | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |
| 190724 | 198010 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 213 Clara St | 1 | : | Tree | Private 2 | 1 | Width 3ft | Permit Number 779305 | 6011863.46506 | 2111836.26557 | 37.7793681257663 | -122.402535146491 | (37.7793681257663, -122.402535146491) | 14 | 2 | 9 | 28856 | 34 | ||
| 190702 | 253537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1000 Cayuga Ave | 5 | Back Yard : Yard | Tree | DPW 1 | 10/05/2017 04:02:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
| 190699 | 137672 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1680 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001130.8124 | 2111447.6233 | 37.777695987238 | -122.43963593997 | (37.777695987238, -122.43963593997) | 15 | 5 | 11 | 29490 | 41 | |||
| 190687 | 46159 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1596 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2006 12:00:00 AM | 3 | Permit Number 48875 | 6007667.62571 | 2109222.921 | 37.7719573667581 | -122.416865151707 | (37.7719573667581, -122.416865151707) | 8 | 2 | 9 | 28853 | 19 | ||
| 190647 | 180157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 579 Madrid St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6002506.03817 | 2090671.05856 | 37.7207266257051 | -122.433393514622 | (37.7207266257051, -122.433393514622) | 9 | 7 | 6 | 28861 | 5 | |||
| 190629 | 201483 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801 Arelious Walker Dr | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6019824.35428 | 2094127.54266 | 37.7311847977227 | -122.373767989919 | (37.7311847977227, -122.373767989919) | 10 | 3 | 8 | 58 | 1 | |||
| 190614 | 181570 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1367 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5984292.8213 | 2105883.0171 | 37.761444419695 | -122.497472491039 | (37.761444419695, -122.497472491039) | 1 | 8 | 3 | 56 | 35 | |||
| 190587 | 242163 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 356 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001121.33765 | 2104284.90061 | 37.7580283890033 | -122.439155218261 | (37.7580283890033, -122.439155218261) | 2 | 4 | 5 | 28862 | 38 | |||
| 190544 | 26245 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1539 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005940.72977 | 2100031.08147 | 37.7466214385308 | -122.422185472598 | (37.7466214385308, -122.422185472598) | 2 | 7 | 5 | 28859 | 22 | |||
| 190543 | 97795 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 825X Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
| 190538 | 217622 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1850 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 5 | Width 0ft | 5994270.3042 | 2092509.6423 | 37.7253042506178 | -122.461994949718 | (37.7253042506178, -122.461994949718) | 9 | 8 | 4 | 28861 | 40 | ||
| 190516 | 136809 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001664.41277 | 2117108.48379 | 37.7932696175395 | -122.438195665917 | (37.7932696175395, -122.438195665917) | 13 | 6 | 1 | 29490 | 27 | |||
| 190474 | 241488 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1274 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003208.53998 | 2100825.48703 | 37.7486482037563 | -122.431689801146 | (37.7486482037563, -122.431689801146) | 2 | 4 | 5 | 28862 | 22 | |||
| 190468 | 183844 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2233 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987596.537 | 2100060.2075 | 37.7456496444996 | -122.485619107431 | (37.7456496444996, -122.485619107431) | 1 | 8 | 3 | 29491 | 35 | |||
| 190434 | 214923 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 21 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5995745.65075 | 2100095.28463 | 37.746217402809 | -122.457443409606 | (37.746217402809, -122.457443409606) | 1 | 5 | 4 | 59 | 40 | |||
| 190404 | 24694 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7015 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2005 12:00:00 AM | 3 | 3X3 | 5985229.89769 | 2112446.70725 | 37.7795213333023 | -122.494715507853 | (37.7795213333023, -122.494715507853) | 11 | 6 | 2 | 55 | 26 | ||
| 190386 | 89488 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4240X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985419.65784 | 2111821.23422 | 37.7778150691874 | -122.494012946242 | (37.7778150691874, -122.494012946242) | 11 | 6 | 2 | 55 | 26 | ||
| 190361 | 241773 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6004953.18714 | 2099282.95557 | 37.7445115049156 | -122.425547059274 | (37.7445115049156, -122.425547059274) | 2 | 7 | 5 | 63 | 22 | |||
| 190350 | 241646 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 508 Oak St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6004431.60341 | 2110177.48427 | 37.7743958128512 | -122.428126834705 | (37.7743958128512, -122.428126834705) | 7 | 9 | 11 | 28852 | 10 | |||
| 190322 | 182698 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1601 Moraga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989298.5697 | 2103745.5783 | 37.7558677195289 | -122.480003454553 | (37.7558677195289, -122.480003454553) | 1 | 8 | 3 | 56 | 35 | |||
| 190313 | 182152 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1604 Moraga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989263.5313 | 2103804.6776 | 37.7560279545749 | -122.48012895245 | (37.7560279545749, -122.48012895245) | 1 | 8 | 3 | 56 | 35 | |||
| 190292 | 116775 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1106 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008794.04431 | 2117993.28546 | 37.7961019747828 | -122.413589186808 | (37.7961019747828, -122.413589186808) | 5 | 1 | 10 | 308 | 21 | ||
| 190288 | 179987 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 765 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998296.14725 | 2087014.5042 | 37.7104468243386 | -122.447682654627 | (37.7104468243386, -122.447682654627) | 9 | 7 | 6 | 28861 | 5 | |||
| 190270 | 31503 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 213 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35063 | 6002220.45956 | 2119302.10567 | 37.7993243409999 | -122.436428783179 | (37.7993243409999, -122.436428783179) | 13 | 9 | 1 | 57 | 17 | ||
| 190266 | 32588 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1283 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 6 | 4.5x6.5 | Permit Number 37057 | 5985512.5122 | 2106502.2804 | 37.7632161587588 | -122.49329977169 | (37.7632161587588, -122.49329977169) | 1 | 8 | 3 | 56 | 35 |
| 190221 | 251737 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 228 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 08:13:00 AM | 3 | 3x3 | 6002872 | 2086877 | 37.7103297297312 | -122.431857732336 | (37.7103297297312, -122.431857732336) | 9 | 7 | 6 | 28861 | 5 | ||
| 190178 | 218753 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 489 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998723.56547 | 2097660.10591 | 37.7397015879464 | -122.446970981521 | (37.7397015879464, -122.446970981521) | 9 | 7 | 4 | 59 | 40 | |||
| 190158 | 15913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5694X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997872.74609 | 2086897.52065 | 37.7101014064224 | -122.44913759044 | (37.7101014064224, -122.44913759044) | 9 | 7 | 6 | 28861 | 25 | ||
| 190129 | 214960 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 96 San Andreas Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993567.2652 | 2095228.36715 | 37.7327287007546 | -122.464622594975 | (37.7327287007546, -122.464622594975) | 9 | 8 | 4 | 59 | 40 | |||
| 190109 | 30548 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011718.12319 | 2086532.40482 | 37.709881047334 | -122.401259311572 | (37.709881047334, -122.401259311572) | 10 | 3 | 8 | 309 | 1 | ||
| 190106 | 106334 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010616.31462 | 2110545.36774 | 37.7757539168402 | -122.406758583146 | (37.7757539168402, -122.406758583146) | 8 | 2 | 9 | 28853 | 34 | |||
| 190075 | 89505 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4550X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984502.23561 | 2111789.09375 | 37.7776730981355 | -122.49718420673 | (37.7776730981355, -122.49718420673) | 11 | 6 | 2 | 55 | 26 | ||
| 190044 | 34063 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1960 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37964 | 6008029.26997895 | 2107027.39297988 | 37.7659492963405 | -122.415458730511 | (37.7659492963405, -122.415458730511) | 8 | 4 | 7 | 28853 | 19 | ||
| 190020 | 88219 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 701 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51217 | 6001578 | 2110798 | 37.7759377272515 | -122.438042423333 | (37.7759377272515, -122.438042423333) | 15 | 5 | 11 | 29492 | 10 | ||
| 189990 | 16961 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 723 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2002 12:00:00 AM | 3 | 3X3 | 6003543.3083 | 2109997.8741 | 37.7738523489886 | -122.431186790219 | (37.7738523489886, -122.431186790219) | 15 | 9 | 11 | 29492 | 10 | ||
| 189943 | 41956 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2638 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 2 | Permit Number 42313 | 5995153.74506 | 2110296.58825 | 37.7741935444233 | -122.460229100557 | (37.7741935444233, -122.460229100557) | 11 | 6 | 2 | 54 | 11 | |
| 189919 | 22639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2005 12:00:00 AM | 3 | 3X3 | 6004184.7636 | 2112567.9201 | 37.780945391127 | -122.429151179613 | (37.780945391127, -122.429151179613) | 7 | 9 | 11 | 29490 | 41 | ||
| 189916 | 218763 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 209 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999378.30493 | 2095752.84874 | 37.7345020963916 | -122.444570136128 | (37.7345020963916, -122.444570136128) | 9 | 7 | 4 | 59 | 40 | |||
| 189882 | 136760 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2280 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002172.95643 | 2118116.93001 | 37.7960674587999 | -122.436508285929 | (37.7960674587999, -122.436508285929) | 13 | 9 | 1 | 57 | 17 | |||
| 189852 | 180332 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001039.3923 | 2092600.001 | 37.7259397465019 | -122.438601386045 | (37.7259397465019, -122.438601386045) | 9 | 7 | 6 | 28861 | 25 | |||
| 189806 | 81446 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 52 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50706 | 6010805.49165 | 2088612.3292 | 37.7155411410853 | -122.404559870256 | (37.7155411410853, -122.404559870256) | 9 | 7 | 8 | 309 | 39 | |
| 189805 | 124129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3575 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5995834.16554 | 2112818.80396 | 37.781157996859 | -122.458057991997 | (37.781157996859, -122.458057991997) | 11 | 6 | 2 | 54 | 16 | |||
| 189768 | 17002 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2028 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999484.07976 | 2121214.10704 | 37.8044183160192 | -122.446035175776 | (37.8044183160192, -122.446035175776) | 13 | 9 | 1 | 57 | 17 | |||
| 189763 | 37148 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 27th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.421428163818 | (37.7471576573064, -122.421428163818) | 2 | 7 | 7 | 28859 | 2 | ||
| 189761 | 27151 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1725 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2013 12:00:00 AM | 3 | 3X3 | 6011106.67473 | 2095144.47702 | 37.7334938972176 | -122.403978254127 | (37.7334938972176, -122.403978254127) | 10 | 3 | 8 | 58 | 1 | ||
| 189715 | 15678 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3976 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1995 12:00:00 AM | 6 | 3X3 | 6004719.66421 | 2095527.6567 | 37.7341871082851 | -122.426087249435 | (37.7341871082851, -122.426087249435) | 2 | 7 | 5 | 28861 | 2 | ||
| 189689 | 241605 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 713 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008134.60104 | 2095608.2473 | 37.7346008104632 | -122.4142863934 | (37.7346008104632, -122.4142863934) | 2 | 7 | 7 | 28859 | 2 | |||
| 189683 | 93480 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356- 1360 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2014 12:00:00 AM | 12 | 3x2 | Permit Number 770976 | 6008293.46712 | 2116608.96674 | 37.7922728557673 | -122.415223246858 | (37.7922728557673, -122.415223246858) | 5 | 1 | 10 | 28858 | 21 | |
| 189679 | 28486 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2001 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 3x3 | 5993567.6407 | 2092778.7575 | 37.7260026959954 | -122.464443501251 | (37.7260026959954, -122.464443501251) | 9 | 8 | 4 | 59 | 40 | ||
| 189670 | 33032 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 478 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37313 | 6006774.69968148 | 2100997.87391321 | 37.7493230359253 | -122.419370259903 | (37.7493230359253, -122.419370259903) | 2 | 4 | 7 | 28859 | 19 | |||
| 189655 | 137757 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Saint Joseph's Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000706.9785 | 2112308.1782 | 37.7800347197931 | -122.441163879701 | (37.7800347197931, -122.441163879701) | 15 | 5 | 1 | 29490 | 16 | |||
| 189622 | 242044 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1552 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005861.63405 | 2099896.39573 | 37.7462471604881 | -122.422449409208 | (37.7462471604881, -122.422449409208) | 2 | 7 | 5 | 28859 | 22 | |||
| 189606 | 218729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 23 Sherwood Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996716.88159 | 2096333.13387 | 37.7359431952195 | -122.453813398695 | (37.7359431952195, -122.453813398695) | 9 | 7 | 4 | 59 | 40 | |||
| 189584 | 217603 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2013 12:00:00 AM | 4 | Width 0ft | 5996021.554 | 2091899.8976 | 37.723730705687 | -122.455897025164 | (37.723730705687, -122.455897025164) | 9 | 8 | 4 | 28861 | 24 | ||
| 189566 | 94177 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 763 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53591 | 6011590.4038 | 2104788.03706 | 37.7600000437731 | -122.402983908204 | (37.7600000437731, -122.402983908204) | 10 | 3 | 8 | 28856 | 29 | |
| 189450 | 88673 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 189440 | 88583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 666 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51526 | 5988492.75781 | 2111460.25568 | 37.7770032560271 | -122.483355686755 | (37.7770032560271, -122.483355686755) | 11 | 6 | 2 | 55 | 26 | ||
| 189340 | 36699 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 59 Brosnan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39494 | 6005719.03532156 | 2108043.7058392 | 37.7686097271445 | -122.423521628772 | (37.7686097271445, -122.423521628772) | 8 | 4 | 5 | 28853 | 19 | ||
| 189326 | 139587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6000732.3602 | 2112121.031 | 37.7795223070318 | -122.441062642932 | (37.7795223070318, -122.441062642932) | 15 | 5 | 1 | 29490 | 16 | |||
| 189325 | 15914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5694X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/1995 12:00:00 AM | 8 | 3x3 | 5997854.28803 | 2086889.62487 | 37.71007867067 | -122.449200816374 | (37.71007867067, -122.449200816374) | 9 | 7 | 6 | 28861 | 25 | ||
| 189322 | 245111 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1521 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999734.9952 | 2109465.2082 | 37.7721732365134 | -122.44432203368 | (37.7721732365134, -122.44432203368) | 15 | 5 | 11 | 29492 | 9 | |||
| 189288 | 251601 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2679 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/1997 12:00:00 AM | 3x3 | 5997280 | 2088608 | 37.7147640690056 | -122.45130950851 | (37.7147640690056, -122.45130950851) | 9 | 8 | 6 | 28861 | 24 | |||
| 189266 | 242068 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4399 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001342.92109 | 2101130.79915 | 37.7493805918394 | -122.438162946775 | (37.7493805918394, -122.438162946775) | 2 | 4 | 5 | 28862 | 22 | |||
| 189259 | 99893 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 715 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997893.2 | 2108079.1 | 37.7682620848422 | -122.450592979377 | (37.7682620848422, -122.450592979377) | 15 | 5 | 11 | 29492 | 9 | |||||
| 189246 | 115785 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 112X Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776402 | 6006834.59164 | 2098690.08898 | 37.7429897522087 | -122.418999487845 | (37.7429897522087, -122.418999487845) | 2 | 7 | 7 | 28859 | 2 | ||
| 189240 | 180185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010852.50351 | 2086625.63078 | 37.7100886954045 | -122.404257627902 | (37.7100886954045, -122.404257627902) | 10 | 3 | 8 | 309 | 1 | |||
| 189211 | 245435 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2525 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6009065.9837 | 2106826.8769 | 37.7654569414617 | -122.41185876653 | (37.7654569414617, -122.41185876653) | 8 | 4 | 7 | 28859 | 19 | |||
| 189166 | 136768 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3320 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5998880.28079 | 2115960.67774 | 37.7899593084295 | -122.44774624121 | (37.7899593084295, -122.44774624121) | 13 | 6 | 1 | 54 | 31 | |||
| 189139 | 39749 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 22 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50794 | 6003462.36685257 | 2105681.2498321 | 37.761995361704 | -122.431158611362 | (37.761995361704, -122.431158611362) | 15 | 4 | 5 | 28862 | 3 | ||
| 189117 | 95800 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2132 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767544 | 6011808 | 2103749 | 37.7571592263593 | -122.4021582929 | (37.7571592263593, -122.4021582929) | 10 | 3 | 8 | 28856 | 29 |
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) );