trees
2,365 rows where qSpecies_id = 31 sorted by TreeID 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43704 | 88338 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 315 Paris St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541 | 2091742 | 37.7236691751532 | -122.433349150158 | (37.7236691751532, -122.433349150158) | 9 | 7 | 6 | 28861 | 5 | |||
| 87095 | 88329 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 120 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940 | 2092960 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | 9 | 7 | 6 | 28861 | 5 | |||
| 51352 | 87967 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51002 | 6000425.8 | 2112036.7 | 37.7792732897886 | -122.442117107328 | (37.7792732897886, -122.442117107328) | 15 | 5 | 1 | 29490 | 16 | ||
| 12615 | 87685 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 118 Virginia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 4x4 | Permit Number 776560 | 6006594.8 | 2098480.6 | 37.7424010366351 | -122.419813761733 | (37.7424010366351, -122.419813761733) | 2 | 7 | 7 | 28859 | 2 | |||
| 81839 | 87308 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
| 124451 | 87307 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
| 171620 | 87306 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
| 88739 | 87305 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
| 191306 | 87304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
| 111191 | 87288 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 131 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096 | 2105951 | 37.7624304670172 | -122.449738139948 | (37.7624304670172, -122.449738139948) | 15 | 5 | 11 | 29492 | 9 | ||
| 131687 | 87287 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096 | 2105951 | 37.7624304670172 | -122.449738139948 | (37.7624304670172, -122.449738139948) | 15 | 5 | 11 | 29492 | 9 | ||
| 59471 | 87143 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2405 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | |
| 107227 | 86696 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 248 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2007 12:00:00 AM | Permit Number 49695 | 6006131 | 2101708.4 | 37.7512377023769 | -122.421646649176 | (37.7512377023769, -122.421646649176) | 2 | 4 | 5 | 28859 | 19 | |||
| 66876 | 85884 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2994 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2015 12:00:00 AM | 3 | 3x3 | 6008392 | 2100977 | 37.7493566776481 | -122.41377610663 | (37.7493566776481, -122.41377610663) | 2 | 4 | 7 | 28859 | 19 | ||
| 124575 | 85858 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1608 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 8 | 3x3 | 6008131.7874 | 2108761.9182 | 37.7707176588514 | -122.415226937815 | (37.7707176588514, -122.415226937815) | 8 | 2 | 9 | 28853 | 19 | ||
| 107724 | 85857 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1530 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008243.2994 | 2108951.1128 | 37.7712434091602 | -122.414854606958 | (37.7712434091602, -122.414854606958) | 8 | 2 | 9 | 28853 | 19 | ||
| 152839 | 85856 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1530 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008268.3583 | 2108979.6799 | 37.7713232557148 | -122.414769948978 | (37.7713232557148, -122.414769948978) | 8 | 2 | 9 | 28853 | 19 | ||
| 77425 | 85855 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1530 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008286.9019 | 2109012.2565 | 37.771413745293 | -122.414708111421 | (37.771413745293, -122.414708111421) | 8 | 2 | 9 | 28853 | 19 | ||
| 128066 | 85854 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 858 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6011861.9039 | 2112442.745 | 37.7810332904479 | -122.402583207023 | (37.7810332904479, -122.402583207023) | 6 | 2 | 9 | 28853 | 34 | ||
| 159711 | 85809 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 875 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 4 | 3x3 | 6011790.9277 | 2112282.0183 | 37.7805880094908 | -122.402817443224 | (37.7805880094908, -122.402817443224) | 6 | 2 | 9 | 28856 | 34 | ||
| 103135 | 85799 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 951 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011299.4671 | 2111813.5286 | 37.7792741924758 | -122.404484661651 | (37.7792741924758, -122.404484661651) | 14 | 2 | 9 | 28856 | 34 | ||
| 159626 | 85797 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 969 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011197.4105 | 2111716.4639 | 37.7790019714524 | -122.404830884084 | (37.7790019714524, -122.404830884084) | 14 | 2 | 9 | 28856 | 34 | ||
| 26663 | 85795 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 985 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 12 | 3x3 | 6011121.9774 | 2111644.9134 | 37.7788012938106 | -122.405086799447 | (37.7788012938106, -122.405086799447) | 14 | 2 | 9 | 28856 | 34 | ||
| 64330 | 85794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1001 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010934.7813 | 2111463.5411 | 37.778292821216 | -122.405721608986 | (37.778292821216, -122.405721608986) | 14 | 2 | 9 | 28853 | 34 | ||
| 1683 | 85790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | 8 | 2 | 9 | 28853 | 34 | ||
| 18804 | 85789 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1157 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 8 | 3x3 | 6009966.4934 | 2110538.8397 | 37.7756996123582 | -122.409006027185 | (37.7756996123582, -122.409006027185) | 8 | 2 | 9 | 28853 | 34 | ||
| 118750 | 85788 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1161 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009943.5141 | 2110517.0093 | 37.775638383908 | -122.409083977926 | (37.775638383908, -122.409083977926) | 8 | 2 | 9 | 28853 | 34 | ||
| 49834 | 85787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 4 | 3x3 | 6009621.8032 | 2110211.384 | 37.7747811809083 | -122.410175277249 | (37.7747811809083, -122.410175277249) | 8 | 2 | 9 | 28853 | 34 | ||
| 47938 | 85786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009596.5259 | 2110188.4047 | 37.7747166682516 | -122.410261094209 | (37.7747166682516, -122.410261094209) | 8 | 2 | 9 | 28853 | 34 | ||
| 37320 | 85785 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 5 | 3x3 | 6009541.3755 | 2110133.2543 | 37.7745621465765 | -122.410447976342 | (37.7745621465765, -122.410447976342) | 8 | 2 | 9 | 28853 | 34 | ||
| 182519 | 85784 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1257 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2015 11:19:00 AM | 3 | 3x3 | 6009427.6278 | 2110025.2513 | 37.7742592182749 | -122.410833824093 | (37.7742592182749, -122.410833824093) | 8 | 2 | 9 | 28853 | 34 | ||
| 60909 | 85783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1265 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009394.3077 | 2109993.0802 | 37.7741690156078 | -122.410946812123 | (37.7741690156078, -122.410946812123) | 8 | 2 | 9 | 28853 | 34 | ||
| 140558 | 85781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1285 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2012 12:00:00 AM | 3 | 3x3 | 6009302.3903 | 2109906.9077 | 37.7739272514432 | -122.411258683374 | (37.7739272514432, -122.411258683374) | 8 | 2 | 9 | 28853 | 34 | ||
| 1830 | 85780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009172.9261 | 2109780.9319 | 37.7735740897245 | -122.411697620327 | (37.7735740897245, -122.411697620327) | 8 | 2 | 9 | 28853 | 34 | ||
| 6385 | 85779 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009155.5683 | 2109764.3815 | 37.7735276724734 | -122.411756494108 | (37.7735276724734, -122.411756494108) | 8 | 2 | 9 | 28853 | 34 | ||
| 139682 | 85778 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009142.6509 | 2109745.8127 | 37.7734759622446 | -122.411799865116 | (37.7734759622446, -122.411799865116) | 8 | 2 | 9 | 28853 | 34 | ||
| 73466 | 85777 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1355 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008992.8894 | 2109607.7576 | 37.7730884926028 | -122.412308154132 | (37.7730884926028, -122.412308154132) | 8 | 2 | 9 | 28853 | 34 | ||
| 38457 | 85775 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1501 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008458.3046 | 2109095.9531 | 37.7716531852784 | -122.4141211414 | (37.7716531852784, -122.4141211414) | 8 | 2 | 9 | 28853 | 19 | ||
| 50791 | 85769 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008582.3574 | 2109309.4458 | 37.7722463531305 | -122.413707137147 | (37.7722463531305, -122.413707137147) | 8 | 2 | 9 | 28853 | 34 | ||
| 187127 | 85768 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008662.6876 | 2109384.932 | 37.7724581311851 | -122.41343460644 | (37.7724581311851, -122.41343460644) | 8 | 2 | 9 | 28853 | 34 | ||
| 26333 | 85767 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008747.4583 | 2109466.0696 | 37.7726856753072 | -122.41314711365 | (37.7726856753072, -122.41314711365) | 8 | 2 | 9 | 28853 | 34 | ||
| 52055 | 85766 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2012 12:00:00 AM | 3 | 3x3 | 6008764.4124 | 2109484.6384 | 37.7727376126497 | -122.413089780599 | (37.7727376126497, -122.413089780599) | 8 | 2 | 9 | 28853 | 34 | ||
| 88949 | 85765 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1350 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008925.8803 | 2109636.8219 | 37.7731645359448 | -122.412542002878 | (37.7731645359448, -122.412542002878) | 8 | 2 | 9 | 28853 | 34 | ||
| 38035 | 85764 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1350 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008969.0729 | 2109678.3998 | 37.7732811230446 | -122.412395532912 | (37.7732811230446, -122.412395532912) | 8 | 2 | 9 | 28853 | 34 | ||
| 190115 | 85763 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1316 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009115.2013 | 2109815.2438 | 37.7736650638278 | -122.411899724934 | (37.7736650638278, -122.411899724934) | 8 | 2 | 9 | 28853 | 34 | ||
| 20821 | 85762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1246 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009446.0112 | 2110126.3604 | 37.7745378709641 | -122.410777374473 | (37.7745378709641, -122.410777374473) | 8 | 2 | 9 | 28853 | 34 | ||
| 87031 | 85761 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1228 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009463.2457 | 2110145.8929 | 37.7745924689532 | -122.410719136445 | (37.7745924689532, -122.410719136445) | 8 | 2 | 9 | 28853 | 34 | ||
| 165082 | 85760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1196 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009690.0521 | 2110363.0901 | 37.7752015556324 | -122.409949900924 | (37.7752015556324, -122.409949900924) | 8 | 2 | 9 | 28853 | 34 | ||
| 179272 | 85757 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 960 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011195.1919 | 2111802.9901 | 37.7792394282463 | -122.404844652616 | (37.7792394282463, -122.404844652616) | 14 | 2 | 9 | 28853 | 34 | ||
| 90769 | 85756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 956 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011236.2364 | 2111841.2613 | 37.7793468061687 | -122.404705356954 | (37.7793468061687, -122.404705356954) | 14 | 2 | 9 | 28853 | 34 | ||
| 119953 | 85744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 868 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011811.5337 | 2112389.6274 | 37.780884629613 | -122.402753726875 | (37.780884629613, -122.402753726875) | 6 | 2 | 9 | 28853 | 34 | ||
| 121876 | 85743 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 850 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011909.0687 | 2112486.2465 | 37.7811553685168 | -122.402423099291 | (37.7811553685168, -122.402423099291) | 6 | 2 | 9 | 28853 | 34 | ||
| 132072 | 84446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000457.5617 | 2112125.7689 | 37.7795196602627 | -122.442013625663 | (37.7795196602627, -122.442013625663) | 15 | 5 | 1 | 29490 | 16 | |||
| 2130 | 83476 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 674-680 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015406.08252 | 2105913.749 | 37.763303339101 | -122.389865835643 | (37.763303339101, -122.389865835643) | 14 | 3 | 8 | 28856 | 29 | |||
| 172075 | 83229 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1169 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52333 | 6005183.33361 | 2120915.83626 | 37.8039231412044 | -122.426291152916 | (37.8039231412044, -122.426291152916) | 13 | 9 | 1 | 28858 | 17 | |
| 105010 | 83024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1209 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52375 | 6013948.88284 | 2105690.73542 | 37.7626100742202 | -122.394890228324 | (37.7626100742202, -122.394890228324) | 10 | 3 | 8 | 28856 | 29 | |
| 93983 | 83010 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 507 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52387 | 6011806.26016 | 2105993.89934 | 37.763323124185 | -122.402322147448 | (37.763323124185, -122.402322147448) | 8 | 3 | 8 | 28856 | 29 | |
| 157733 | 82639 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 262 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52220 | 6007782.82233026 | 2105835.06197207 | 37.7626615773847 | -122.416226690034 | (37.7626615773847, -122.416226690034) | 8 | 4 | 7 | 28859 | 19 | ||
| 109774 | 82620 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 262 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52220 | 6007782.82233026 | 2105835.06197207 | 37.7626615773847 | -122.416226690034 | (37.7626615773847, -122.416226690034) | 8 | 4 | 7 | 28859 | 19 | ||
| 80710 | 81876 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1209 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52375 | 6013966.08986 | 2105691.70822 | 37.762613702073 | -122.394830783137 | (37.762613702073, -122.394830783137) | 10 | 3 | 8 | 28856 | 29 | |
| 96419 | 81863 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.7293018063197 | -122.459920577502 | (37.7293018063197, -122.459920577502) | 9 | 7 | 4 | 28861 | 40 | ||
| 17960 | 81238 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008758.1555 | 2109381.0971 | 37.7724529612773 | -122.41310410127 | (37.7724529612773, -122.41310410127) | 8 | 2 | 9 | 28853 | 34 | |||
| 8503 | 80188 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1435 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008710.7243 | 2109332.6568 | 37.7723172927739 | -122.413264744885 | (37.7723172927739, -122.413264744885) | 8 | 2 | 9 | 28853 | 34 | |||
| 146307 | 7665 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3355 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6008520.72042 | 2099166.26042 | 37.7443920173774 | -122.413202960365 | (37.7443920173774, -122.413202960365) | 2 | 7 | 7 | 28859 | 2 | |||
| 27901 | 7664 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3348 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008462.72403 | 2099121.09112 | 37.7442647363292 | -122.413400306703 | (37.7442647363292, -122.413400306703) | 2 | 7 | 7 | 28859 | 2 | |||
| 57212 | 7663 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3343 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008519.81594 | 2099195.42015 | 37.744472032765 | -122.413208149458 | (37.744472032765, -122.413208149458) | 2 | 7 | 7 | 28859 | 2 | |||
| 140465 | 7662 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3340 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4x4 | 6008466.34336 | 2099149.15248 | 37.7443419898261 | -122.413389775903 | (37.7443419898261, -122.413389775903) | 2 | 7 | 7 | 28859 | 2 | |||
| 116947 | 7661 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3340 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008464.3828 | 2099163.30287 | 37.7443807335859 | -122.413397555653 | (37.7443807335859, -122.413397555653) | 2 | 7 | 7 | 28859 | 2 | |||
| 43307 | 7660 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3340 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 01:35:00 PM | 3 | 4x4 | 6008461.08319 | 2099185.41304 | 37.7444412579547 | -122.413410528397 | (37.7444412579547, -122.413410528397) | 2 | 7 | 7 | 28859 | 2 | ||
| 61681 | 7659 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3339 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008524.12376 | 2099222.60541 | 37.7445469193178 | -122.413195175821 | (37.7445469193178, -122.413195175821) | 2 | 7 | 7 | 28859 | 2 | |||
| 43761 | 7658 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3335 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2010 12:00:00 AM | 3 | 3x3 | 6008522.8365 | 2099251.39925 | 37.7446259085611 | -122.41320166263 | (37.7446259085611, -122.41320166263) | 2 | 7 | 7 | 28859 | 2 | ||
| 26729 | 7657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3334 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008459.10706 | 2099217.21001 | 37.7445284544392 | -122.413419609751 | (37.7445284544392, -122.413419609751) | 2 | 7 | 7 | 28859 | 2 | |||
| 133700 | 7655 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3331 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | 3 | 4x4 | 6008519.80485 | 2099268.27363 | 37.7446720716725 | -122.41321333853 | (37.7446720716725, -122.41321333853) | 2 | 7 | 7 | 28859 | 2 | ||
| 106120 | 7654 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3325 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008517.34687 | 2099294.8498 | 37.7447449059562 | -122.413223716718 | (37.7447449059562, -122.413223716718) | 2 | 7 | 7 | 28859 | 2 | |||
| 77462 | 7652 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3316 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008450.59192 | 2099314.52137 | 37.7447951717692 | -122.413455934253 | (37.7447951717692, -122.413455934253) | 2 | 7 | 7 | 28859 | 2 | |||
| 151872 | 7650 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3309 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 4x4 | 6008515.39459 | 2099309.4605 | 37.7447849140984 | -122.413231500338 | (37.7447849140984, -122.413231500338) | 2 | 7 | 7 | 28859 | 2 | |||
| 163664 | 7649 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3305 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6008514.31351 | 2099348.33737 | 37.7448916006788 | -122.413237987153 | (37.7448916006788, -122.413237987153) | 2 | 7 | 7 | 28859 | 2 | |||
| 30219 | 7647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3302 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6008452.78429 | 2099390.30637 | 37.7450033836799 | -122.413453712108 | (37.7450033836799, -122.413453712108) | 2 | 7 | 7 | 28859 | 2 | |||
| 29302 | 7646 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3301 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6008513.44624 | 2099397.67081 | 37.745027010685 | -122.413244473962 | (37.745027010685, -122.413244473962) | 2 | 7 | 7 | 28859 | 2 | |||
| 115704 | 7645 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3299 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2008 12:00:00 AM | 3 | 4x4 | 6008510.32989 | 2099428.74367 | 37.7451121549133 | -122.413257446692 | (37.7451121549133, -122.413257446692) | 2 | 7 | 7 | 28859 | 2 | ||
| 169139 | 7644 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3297 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008507.04556 | 2099451.60062 | 37.7451747306403 | -122.413270419413 | (37.7451747306403, -122.413270419413) | 2 | 7 | 7 | 28859 | 2 | |||
| 127593 | 7643 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3292 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6008441.79801 | 2099489.92136 | 37.7452762874815 | -122.413498744673 | (37.7452762874815, -122.413498744673) | 2 | 7 | 7 | 28859 | 2 | |||
| 127699 | 7642 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3293 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008503.39373 | 2099474.83847 | 37.7452383315994 | -122.413284689843 | (37.7452383315994, -122.413284689843) | 2 | 7 | 7 | 28859 | 2 | |||
| 45723 | 7641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3289 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 4x4 | 6008504.24968 | 2099498.35818 | 37.7453029595644 | -122.413283393019 | (37.7453029595644, -122.413283393019) | 2 | 7 | 7 | 28859 | 2 | |||
| 58794 | 7638 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6008420.15681 | 2099616.94183 | 37.7456238423258 | -122.413582558723 | (37.7456238423258, -122.413582558723) | 2 | 7 | 7 | 28859 | 2 | |||
| 46405 | 7637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3274 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6008436.96279 | 2099620.40725 | 37.7456343012777 | -122.413524691037 | (37.7456343012777, -122.413524691037) | 2 | 7 | 7 | 28859 | 2 | |||
| 93625 | 7636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3268 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008436.93734 | 2099674.20606 | 37.7457820194342 | -122.41352858329 | (37.7457820194342, -122.41352858329) | 2 | 7 | 7 | 28859 | 2 | |||
| 137256 | 7635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3258 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6008433.89749 | 2099709.01316 | 37.7458774213094 | -122.413541556009 | (37.7458774213094, -122.413541556009) | 2 | 7 | 7 | 28859 | 2 | |||
| 44042 | 7634 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3256 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6008430.65908 | 2099734.11047 | 37.7459461511063 | -122.413554528742 | (37.7459461511063, -122.413554528742) | 2 | 7 | 7 | 28859 | 2 | |||
| 101944 | 7633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
| 84788 | 7632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
| 98114 | 7631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
| 193847 | 7630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008486.33548 | 2099778.1775 | 37.7460702755308 | -122.413365122515 | (37.7460702755308, -122.413365122515) | 2 | 7 | 7 | 28859 | 2 | |||
| 106629 | 7629 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008486.89529 | 2099750.51965 | 37.7459943646489 | -122.413361231161 | (37.7459943646489, -122.413361231161) | 2 | 7 | 7 | 28859 | 2 | |||
| 189661 | 7628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008489.95741 | 2099735.13949 | 37.7459523060695 | -122.41334955525 | (37.7459523060695, -122.41334955525) | 2 | 7 | 7 | 28859 | 2 | |||
| 171348 | 7627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3254 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008428.98919 | 2099762.53811 | 37.746024113322 | -122.413562313248 | (37.746024113322, -122.413562313248) | 2 | 7 | 7 | 28859 | 2 | |||
| 187572 | 7626 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3250 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6008427.33483 | 2099791.71253 | 37.7461041269002 | -122.413570096878 | (37.7461041269002, -122.413570096878) | 2 | 7 | 7 | 28859 | 2 | |||
| 146278 | 7625 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3244 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6008426.82761 | 2099840.29088 | 37.7462374837687 | -122.413575285989 | (37.7462374837687, -122.413575285989) | 2 | 7 | 7 | 28859 | 2 | |||
| 179354 | 7624 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3240 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6008423.54341 | 2099863.14752 | 37.746300058605 | -122.413588258702 | (37.746300058605, -122.413588258702) | 2 | 7 | 7 | 28859 | 2 | |||
| 100057 | 7623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3238 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 5x4.1 | 6008419.9299 | 2099888.25217 | 37.746368787483 | -122.413602529127 | (37.746368787483, -122.413602529127) | 2 | 7 | 7 | 28859 | 2 |
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) );