trees
27,746 rows where qCaretaker_id = 1 sorted by qSpecies_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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 264847 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010522 | 2093730 | 37.729577358437 | -122.405900044893 | (37.729577358437, -122.405900044893) | 10 | 3 | 7 | 309 | 28 | |||
| 4 | 264831 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | 6011678 | 2088870 | 37.7162973770842 | -122.401562170369 | (37.7162973770842, -122.401562170369) | 10 | 7 | 8 | 309 | 39 | ||
| 26 | 259857 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1255 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/01/2020 12:00:00 AM | 3 | 6011768.59367 | 2089078.72926 | 37.7168755602396 | -122.401263692233 | (37.7168755602396, -122.401263692233) | 10 | 7 | 8 | 309 | 39 | ||
| 49 | 261834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20x Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||
| 90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
| 679 | 258141 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 1x3 | 5998583.51543 | 2115521.94134 | 37.7887376884438 | -122.448741405189 | (37.7887376884438, -122.448741405189) | 13 | 6 | 1 | 54 | 31 | ||
| 805 | 259342 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6011093.06151 | 2093005.0494 | 37.7276187164247 | -122.403874822512 | (37.7276187164247, -122.403874822512) | 10 | 3 | 7 | 309 | 28 | ||
| 840 | 1046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.439703245137 | (37.7197661846273, -122.439703245137) | 9 | 7 | 6 | 28861 | 25 | ||
| 927 | 260891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 839 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985392.72943 | 2110161.55054 | 37.7732564760791 | -122.493983752439 | (37.7732564760791, -122.493983752439) | 11 | 6 | 2 | 55 | 26 | |||
| 951 | 258181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 332 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009802.23856 | 2094053.68877 | 37.7304258589231 | -122.408411167734 | (37.7304258589231, -122.408411167734) | 10 | 3 | 7 | 309 | 28 | ||
| 1020 | 256741 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1494 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 5987774.09162 | 2105131.6228 | 37.7595847299836 | -122.485377233769 | (37.7595847299836, -122.485377233769) | 1 | 8 | 3 | 56 | 35 | ||
| 1030 | 260915 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Waller St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5999454.48308 | 2108393.47297 | 37.7692145145226 | -122.445215277932 | (37.7692145145226, -122.445215277932) | 15 | 5 | 11 | 29492 | 9 | |||
| 1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 1138 | 260594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 1141 | 171735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1124 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007457.06473 | 2093337.1735 | 37.7283268529824 | -122.416468054284 | (37.7283268529824, -122.416468054284) | 9 | 3 | 7 | 309 | 5 | ||
| 1229 | 264907 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 1231 | 15974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2016 12:00:00 AM | 3 | 3X3 | 5996593.31856 | 2086313.84227 | 37.7084254991124 | -122.453517403906 | (37.7084254991124, -122.453517403906) | 9 | 7 | 6 | 28861 | 5 | ||
| 1253 | 86079 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2321 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987612.7621 | 2099475.5619 | 37.7440453083682 | -122.485520107247 | (37.7440453083682, -122.485520107247) | 1 | 8 | 3 | 29491 | 35 | ||
| 1291 | 122854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996671.62099 | 2087298.1542 | 37.7111326815096 | -122.453317797602 | (37.7111326815096, -122.453317797602) | 9 | 7 | 6 | 28861 | 25 | ||
| 1604 | 15896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5635 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5998509.62683 | 2087220.10589 | 37.7110235586697 | -122.446959612304 | (37.7110235586697, -122.446959612304) | 9 | 7 | 6 | 28861 | 5 | ||
| 1721 | 86502 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987758.3934 | 2105633.7162 | 37.7609624268951 | -122.48546837117 | (37.7609624268951, -122.48546837117) | 1 | 8 | 3 | 56 | 35 | ||
| 1999 | 18283 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/1994 12:00:00 AM | 6 | 4X4 | 6002545.1088 | 2114076.0503 | 37.7849933804768 | -122.434931434249 | (37.7849933804768, -122.434931434249) | 13 | 6 | 11 | 29490 | 13 | ||
| 2181 | 144909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 626 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 3ft | 5990056.22711 | 2111077.42304 | 37.7760429715406 | -122.477919227901 | (37.7760429715406, -122.477919227901) | 11 | 6 | 2 | 55 | 26 | ||
| 2227 | 28919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009994.1526974 | 2111207.6693813 | 37.7775376115192 | -122.408957547154 | (37.7775376115192, -122.408957547154) | 8 | 2 | 9 | 28853 | 34 | ||
| 2232 | 26076 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | 9 | 8 | 6 | 28861 | 24 | ||
| 2259 | 124122 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4500 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/1996 12:00:00 AM | 7 | Width 3ft | 5992964.88575 | 2112821.48622 | 37.7810000844067 | -122.467984383057 | (37.7810000844067, -122.467984383057) | 11 | 6 | 2 | 54 | 11 | ||
| 2284 | 122861 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996437.5077 | 2087153.60444 | 37.7107223595138 | -122.454116512475 | (37.7107223595138, -122.454116512475) | 9 | 7 | 6 | 28861 | 25 | ||
| 2334 | 15528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2792 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2018 12:00:00 AM | 3 | 3X3 | 6007034.2153 | 2102142.536 | 37.7524806306406 | -122.418554005951 | (37.7524806306406, -122.418554005951) | 2 | 4 | 7 | 28859 | 19 | ||
| 2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 2477 | 26317 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2045 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1997 12:00:00 AM | 3 | 3X3 | 5999556.95115 | 2091956.24005 | 37.7240876853785 | -122.443679842351 | (37.7240876853785, -122.443679842351) | 9 | 7 | 6 | 28861 | 25 | ||
| 2913 | 264905 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 3406 | 26232 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 705X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1997 12:00:00 AM | 8 | 3X3 | 6005809.35017 | 2099009.02543 | 37.7438076936648 | -122.422567155652 | (37.7438076936648, -122.422567155652) | 2 | 7 | 7 | 28859 | 2 | ||
| 3418 | 241507 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5235 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2016 07:34:00 AM | 1 | Width 2ft | 6001160.66626 | 2099296.94355 | 37.7443348933555 | -122.438661800724 | (37.7443348933555, -122.438661800724) | 2 | 7 | 5 | 63 | 22 | ||
| 3447 | 197 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002246.85388 | 2106423.49653 | 37.7639644352284 | -122.435415689679 | (37.7639644352284, -122.435415689679) | 15 | 5 | 5 | 28862 | 3 | |||
| 3521 | 1361 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/29/2016 12:00:00 AM | 3 | 3X3 | 5999192.9019 | 2100038.70061 | 37.7462594407353 | -122.445519216737 | (37.7462594407353, -122.445519216737) | 2 | 7 | 5 | 63 | 22 | ||
| 3555 | 89502 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4524 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984585.23275 | 2111791.9106 | 37.7776856960653 | -122.49689730367 | (37.7776856960653, -122.49689730367) | 11 | 6 | 2 | 55 | 26 | ||
| 3579 | 119169 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 720 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 5980759.87673 | 2110793.19365 | 37.7747186206505 | -122.510056058609 | (37.7747186206505, -122.510056058609) | 11 | 6 | 2 | 55 | 26 | |||
| 3593 | 89474 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4100 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985926.00184 | 2111839.74307 | 37.7778955032139 | -122.492262714551 | (37.7778955032139, -122.492262714551) | 11 | 6 | 2 | 55 | 26 | ||
| 3618 | 122859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:46:00 PM | 3 | 3x3 | 5996503.07173 | 2087192.19332 | 37.7108320750073 | -122.453892694613 | (37.7108320750073, -122.453892694613) | 9 | 7 | 6 | 28861 | 25 | ||
| 3648 | 262535 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6001472.85598 | 2090996.66296 | 37.7215619917613 | -122.43698819828 | (37.7215619917613, -122.43698819828) | 9 | 7 | 6 | 28861 | 5 | ||
| 3718 | 85909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2234 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988258.4084 | 2100094.7734 | 37.745783095491 | -122.483333016616 | (37.745783095491, -122.483333016616) | 1 | 8 | 3 | 29491 | 35 | ||
| 3960 | 28454 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5993123.43173 | 2093088.843 | 37.7268284984876 | -122.466001612774 | (37.7268284984876, -122.466001612774) | 9 | 8 | 4 | 59 | 40 | ||
| 4112 | 255223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 4232 | 264908 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 4287 | 85892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2450 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988312.1108 | 2098619.8624 | 37.7417365040241 | -122.483039240723 | (37.7417365040241, -122.483039240723) | 1 | 8 | 3 | 29491 | 35 | ||
| 4334 | 136909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6009830.0684 | 2121639.18274 | 37.8061708284786 | -122.410261867902 | (37.8061708284786, -122.410261867902) | 3 | 1 | 10 | 308 | 23 | |||
| 4386 | 24695 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7001 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2016 12:40:00 PM | 3 | 3X3 | 5985279 | 2112414 | 37.7794344025529 | -122.494543232684 | (37.7794344025529, -122.494543232684) | 11 | 6 | 2 | 55 | 26 | ||
| 4605 | 85901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2282 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988268.6501 | 2099782.4008 | 37.7449259990071 | -122.483274709024 | (37.7449259990071, -122.483274709024) | 1 | 8 | 3 | 29491 | 35 | ||
| 4837 | 115185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | 9 | 7 | 6 | 28861 | 25 | ||||
| 4843 | 260426 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6009322.86982 | 2092462.23119 | 37.726029197201 | -122.409956117368 | (37.726029197201, -122.409956117368) | 9 | 3 | 7 | 309 | 28 | ||
| 4920 | 12041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 4943 | 260913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 482 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997348.59542 | 2107447.85511 | 37.7664976608583 | -122.452431145559 | (37.7664976608583, -122.452431145559) | 15 | 5 | 11 | 29492 | 9 | |||
| 4994 | 260596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3116x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | 4x6 | 6013747 | 2090444 | 37.7207345013838 | -122.394520802284 | (37.7207345013838, -122.394520802284) | 10 | 3 | 8 | 58 | 1 | |
| 5055 | 89478 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4120 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985848.51867 | 2111837.86338 | 37.7778858121287 | -122.492530613758 | (37.7778858121287, -122.492530613758) | 11 | 6 | 2 | 55 | 26 | ||
| 5072 | 26211 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005561.1813783 | 2098469.3096841 | 37.7423117528593 | -122.423386905565 | (37.7423117528593, -122.423386905565) | 2 | 7 | 5 | 28859 | 22 | |||
| 5139 | 19520 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 127 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6000564 | 2112525 | 37.7806219117946 | -122.44167407009 | (37.7806219117946, -122.44167407009) | 15 | 5 | 1 | 29490 | 16 | |||
| 5190 | 19521 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 130X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000722.7955642 | 2112514.8377136 | 37.7806030550121 | -122.441123992492 | (37.7806030550121, -122.441123992492) | 15 | 5 | 1 | 29490 | 41 | |||
| 5298 | 16892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 311 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2011 12:00:00 AM | 6 | 3X3 | 6005385.8444 | 2110257.3545 | 37.7746690605587 | -122.424831616025 | (37.7746690605587, -122.424831616025) | 7 | 9 | 11 | 28852 | 10 | ||
| 5402 | 259405 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1140 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6013491.54198 | 2090383.23631 | 37.7205534514179 | -122.395399593578 | (37.7205534514179, -122.395399593578) | 10 | 3 | 8 | 58 | 1 | ||
| 5481 | 112239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 4 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:41:00 AM | 3 | 5999153.8915 | 2088963.97845 | 37.7158486246797 | -122.444858161098 | (37.7158486246797, -122.444858161098) | 9 | 7 | 6 | 28861 | 25 | |||
| 5493 | 264903 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 5520 | 66956 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2253 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1992 12:00:00 AM | 18 | 4x4 | Permit Number 30287 | 6003206.54821 | 2116495.06774 | 37.7916729207242 | -122.432815936723 | (37.7916729207242, -122.432815936723) | 13 | 9 | 1 | 29490 | 27 | |
| 5765 | 112237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 10/27/2015 08:35:00 AM | 3 | 5999175.75859 | 2088985.62206 | 37.71590930104 | -122.444784133402 | (37.71590930104, -122.444784133402) | 9 | 7 | 6 | 28861 | 25 | |||
| 5773 | 180020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1800x Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 2ft | 6001294.85354 | 2091604.85507 | 37.7232218307036 | -122.437647038084 | (37.7232218307036, -122.437647038084) | 9 | 7 | 6 | 28861 | 25 | |||
| 5973 | 89587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4645 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984204.99021 | 2111721.97383 | 37.7774713817851 | -122.498207505516 | (37.7774713817851, -122.498207505516) | 11 | 6 | 2 | 55 | 26 | ||
| 6573 | 262162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | ||
| 6640 | 255204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 6707 | 15866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5425 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999452.41338 | 2088067.62767 | 37.7134044805159 | -122.443761975638 | (37.7134044805159, -122.443761975638) | 9 | 7 | 6 | 28861 | 5 | ||
| 6742 | 264909 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 6815 | 26065 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 252 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5994463.9745 | 2088114.2994 | 37.7132468380661 | -122.461007025599 | (37.7132468380661, -122.461007025599) | 9 | 8 | 6 | 28861 | 24 | |||
| 6874 | 258105 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Naglee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5998652.17813 | 2087511.67596 | 37.7118322871785 | -122.446487885746 | (37.7118322871785, -122.446487885746) | 9 | 7 | 6 | 28861 | 25 | |||||
| 6945 | 259738 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 659 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/09/2018 12:00:00 AM | 3 | 6005639.64346 | 2105140.6799 | 37.760634224683 | -122.423589815732 | (37.760634224683, -122.423589815732) | 2 | 4 | 5 | 28859 | 19 | ||
| 6972 | 259353 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 242 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010364.72852 | 2093515.77495 | 37.7289803445436 | -122.40642866223 | (37.7289803445436, -122.40642866223) | 10 | 3 | 7 | 309 | 28 | ||
| 6981 | 259867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 7148 | 172130 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301 Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | Width 2ft | 6010555.51143 | 2093279.58738 | 37.7283424940077 | -122.405752478307 | (37.7283424940077, -122.405752478307) | 10 | 3 | 7 | 309 | 28 | ||
| 7189 | 90402 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100X McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006023.914808 | 2109144.349895 | 37.7716490364194 | -122.422545294145 | (37.7716490364194, -122.422545294145) | 8 | 2 | 9 | 28853 | 19 | ||
| 7262 | 260931 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 939 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/30/2020 12:00:00 AM | 3 | 3x3 | 5997175 | 2107208 | 37.7658291329236 | -122.453014262165 | (37.7658291329236, -122.453014262165) | 15 | 5 | 11 | 29492 | 12 | |
| 7279 | 12251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 512 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2014 12:00:00 AM | 3 | 3X3 | 6005037.9059 | 2110678.2828 | 37.77580516874 | -122.426065177531 | (37.77580516874, -122.426065177531) | 7 | 9 | 11 | 28852 | 10 | ||
| 7336 | 29544 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2900X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2019 12:00:00 AM | 3 | 3X3 | 6014624.5697 | 2090476.0215 | 37.7208711738855 | -122.39148952766 | (37.7208711738855, -122.39148952766) | 10 | 3 | 8 | 58 | 1 | ||
| 7473 | 122856 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:13:00 PM | 3 | 3x3 | 5996611.63138 | 2087256.15424 | 37.7110139206266 | -122.45352210466 | (37.7110139206266, -122.45352210466) | 9 | 7 | 6 | 28861 | 25 | ||
| 7475 | 260914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1165 Oak St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 6001427.67727 | 2109710.45692 | 37.7729430567741 | -122.438484490103 | (37.7729430567741, -122.438484490103) | 15 | 5 | 11 | 29492 | 9 | |||
| 7480 | 180280 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1204x Alemany Blvd | 18 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6002728.35558 | 2094064.39346 | 37.7300565721367 | -122.432867327564 | (37.7300565721367, -122.432867327564) | 9 | 7 | 6 | 28861 | 25 | |||
| 7587 | 259089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 7674 | 259377 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1486 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015207.81311 | 2093285.95013 | 37.7286190359645 | -122.389669569097 | (37.7286190359645, -122.389669569097) | 10 | 3 | 8 | 58 | 1 | ||
| 7777 | 90321 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2031 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989223.3962 | 2111222.92813 | 37.776394115845 | -122.480810832316 | (37.776394115845, -122.480810832316) | 11 | 6 | 2 | 55 | 26 | ||
| 7969 | 85906 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2254 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988263.956 | 2099971.0192 | 37.7454436220707 | -122.483304764 | (37.7454436220707, -122.483304764) | 1 | 8 | 3 | 29491 | 35 | ||
| 8074 | 86491 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1610 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.6185 | 2104298.7956 | 37.7572997330502 | -122.485214007697 | (37.7572997330502, -122.485214007697) | 1 | 8 | 3 | 56 | 35 | ||
| 8097 | 26292 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900X San Jose Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999828.34203 | 2092450.55637 | 37.725460439341 | -122.442777166756 | (37.725460439341, -122.442777166756) | 9 | 7 | 6 | 28861 | 25 | ||
| 8151 | 112241 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:34:00 AM | 3 | 5999126.802 | 2088939.36005 | 37.71577948212 | -122.444950025942 | (37.71577948212, -122.444950025942) | 9 | 7 | 6 | 28861 | 25 | |||
| 8196 | 255225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Bacon St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 8231 | 258103 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4001 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5994656.53411 | 2112804.2386 | 37.7810502710743 | -122.462130924837 | (37.7810502710743, -122.462130924837) | 11 | 6 | 2 | 54 | 11 | |||||
| 8267 | 119175 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 8ft | 5980756.90149 | 2110662.55033 | 37.7743597371632 | -122.510056642513 | (37.7743597371632, -122.510056642513) | 11 | 6 | 2 | 55 | 26 | |||
| 8488 | 255224 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011054.35236 | 2091069.46331 | 37.7223018348516 | -122.403872494592 | (37.7223018348516, -122.403872494592) | 10 | 3 | 7 | 309 | 28 | ||
| 8493 | 10021 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 274 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2018 12:00:00 AM | 3 | 3x4 | 6005443.44254 | 2107417.66285 | 37.7668752034469 | -122.424430347706 | (37.7668752034469, -122.424430347706) | 8 | 4 | 5 | 28853 | 19 | ||
| 8506 | 258378 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1100 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x5 | 6007594.19766 | 2093376.79647 | 37.7284433601031 | -122.415996783146 | (37.7284433601031, -122.415996783146) | 9 | 3 | 7 | 309 | 5 | |||
| 8832 | 260593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 8882 | 86419 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2315 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988234.1046 | 2099528.0173 | 37.7442255186266 | -122.483375515142 | (37.7442255186266, -122.483375515142) | 1 | 8 | 3 | 29491 | 35 | ||
| 8909 | 259799 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011890.92519 | 2088681.18109 | 37.7157907972077 | -122.400812935252 | (37.7157907972077, -122.400812935252) | 10 | 7 | 8 | 309 | 39 | |||
| 8985 | 26035 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 32 Broad St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1997 12:00:00 AM | 12 | 3X3 | 5996388.1269 | 2088087.32843 | 37.713283317556 | -122.454354585517 | (37.713283317556, -122.454354585517) | 9 | 8 | 6 | 28861 | 24 | ||
| 9032 | 93400 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999886.3903 | 2111916.5396 | 37.7789126049307 | -122.443974507336 | (37.7789126049307, -122.443974507336) | 15 | 5 | 11 | 29490 | 16 |
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) );