Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140480 | 140480 | 87306 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 145818 | 145818 | 87304 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 100335 | 100335 | 87288 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096.0 | 2105951.0 | 37.762430467017204 | -122.44973813994801 | (37.7624304670172, -122.449738139948) | ||
| 106821 | 106821 | 87287 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096.0 | 2105951.0 | 37.762430467017204 | -122.44973813994801 | (37.7624304670172, -122.449738139948) | ||
| 88936 | 88936 | 87143 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2405 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50131 | 6008226.0 | 2104427.0 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | |
| 91804 | 91804 | 63541 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2405 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50131 | 6008226.96496954 | 2104416.66761012 | 37.758791956333795 | -122.414590178015 | (37.7587919563338, -122.414590178015) | |
| 172012 | 172012 | 49872 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1918 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49768 | 6003420.3009 | 2115360.353 | 37.7885694038243 | -122.431995291423 | (37.7885694038243, -122.431995291423) | |
| 101334 | 101334 | 86696 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 248 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2007 12:00:00 AM | Permit Number 49695 | 6006131.0 | 2101708.4 | 37.7512377023769 | -122.42164664917601 | (37.7512377023769, -122.421646649176) | |||
| 37105 | 37105 | 51255 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2485 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | 8 | Permit Number 49056 | 6001759.16032 | 2117307.5117200003 | 37.7938214847188 | -122.437882095676 | (37.7938214847188, -122.437882095676) | ||
| 135957 | 135957 | 51918 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.924319999 | 2091688.24542 | 37.72335998726889 | -122.443166369055 | (37.7233599872689, -122.443166369055) | |
| 84762 | 84762 | 40174 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 801 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2006 12:00:00 AM | 8 | Permit Number 48884 | 6002465.36284573 | 2103545.36770604 | 37.756074195699206 | -122.43445413726101 | (37.7560741956992, -122.434454137261) | |
| 88397 | 88397 | 48676 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4930 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2006 12:00:00 AM | Permit Number 48856 | 5997717.95296797 | 2105658.6000715 | 37.7616059742438 | -122.451024572529 | (37.7616059742438, -122.451024572529) | ||
| 142355 | 142355 | 52726 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 169 ROOSEVELT Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2006 12:00:00 AM | Permit Number 48781 | 6001418.20285712 | 2107376.9010813 | 37.76653515331179 | -122.438350049909 | (37.7665351533118, -122.438350049909) | |||
| 66017 | 66017 | 52720 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 710@ 20th ST Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2006 12:00:00 AM | Permit Number 48773 | 6002386.64959974 | 2104032.25895211 | 37.757406613771 | -122.43476116987699 | (37.757406613771, -122.434761169877) | |||
| 97468 | 97468 | 52332 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.45929215094101 | (37.7353714395789, -122.459292150941) | ||||
| 117959 | 117959 | 52081 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 477 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2005 12:00:00 AM | Permit Number 48278 | 5998529.03039776 | 2106418.21564482 | 37.763738089155105 | -122.448274099423 | (37.7637380891551, -122.448274099423) | |||
| 104545 | 104545 | 51892 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48104 | 6004381.23162594 | 2089955.54800101 | 37.7188681982632 | -122.42686061692 | (37.7188681982632, -122.42686061692) | |||
| 38337 | 38337 | 51849 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4000 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.43267780892599 | (37.7594924661239, -122.432677808926) | |||
| 88211 | 88211 | 51850 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4000 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.43267780892599 | (37.7594924661239, -122.432677808926) | |||
| 5219 | 5219 | 242740 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4081 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | 5 | Width 2ft | Permit Number 47860 | 6001797.68474 | 2105832.52045 | 37.7623162396305 | -122.43692691855 | (37.7623162396305, -122.43692691855) | |
| 93066 | 93066 | 51562 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4083 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | 18 | Permit Number 47860 | 6001768.0 | 2105813.0 | 37.7622609540043 | -122.43702818916701 | (37.7622609540043, -122.437028189167) | ||
| 97275 | 97275 | 34988 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 25 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47856 | 6004110.40789501 | 2102908.72400582 | 37.754419364925205 | -122.428719637491 | (37.7544193649252, -122.428719637491) | |||
| 87420 | 87420 | 51550 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1247 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2005 12:00:00 AM | Permit Number 47849 | 5999742.39026173 | 2108428.18336747 | 37.7693262500826 | -122.444221920277 | (37.7693262500826, -122.444221920277) | |||
| 41952 | 41952 | 51434 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.724636968819205 | -122.433701359735 | (37.7246369688192, -122.433701359735) | ||
| 176942 | 176942 | 51159 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | 4 | Permit Number 47564 | 6000498.9523 | 2114920.078 | 37.7871944727635 | -122.44207106941002 | (37.7871944727635, -122.44207106941) | ||
| 83953 | 83953 | 50808 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 499 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2006 12:00:00 AM | Permit Number 47332 | 6008981.38895406 | 2105919.05287132 | 37.762959519157704 | -122.412087198232 | (37.7629595191577, -122.412087198232) | ||
| 93203 | 93203 | 50430 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 53REVISED Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2004 12:00:00 AM | Permit Number 47083 | 5998656.22086914 | 2105364.79387751 | 37.76085292760639 | -122.447758347691 | (37.7608529276064, -122.447758347691) | ||
| 114560 | 114560 | 50047 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 622 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46778 | 6002356.09000511 | 2104575.82706483 | 37.7588973859125 | -122.434905729534 | (37.7588973859125, -122.434905729534) | |||
| 124491 | 124491 | 50045 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3928 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3x3 | Permit Number 46776 | 6003593.46976323 | 2102471.5753466 | 37.753189787602 | -122.430476153053 | (37.753189787602, -122.430476153053) | |
| 143300 | 143300 | 49790 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2862 & YORK 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46574 | 6010228.54978873 | 2101669.78710325 | 37.7513618837191 | -122.40747408248001 | (37.7513618837191, -122.40747408248) | |||
| 51546 | 51546 | 49734 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2940REVISED Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.75023581813571 | -122.413951255275 | (37.7502358181357, -122.413951255275) | ||
| 90128 | 90128 | 49733 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2940REVISED Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.75023581813571 | -122.413951255275 | (37.7502358181357, -122.413951255275) | ||
| 14176 | 14176 | 49606 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1245 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009457.5009 | 2110055.1245 | 37.7743429180698 | -122.410732597335 | (37.7743429180698, -122.410732597335) | |
| 15618 | 15618 | 49607 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1245 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009479.3313 | 2110073.508 | 37.7743946188288 | -122.41065838012199 | (37.7743946188288, -122.410658380122) | |
| 19273 | 19273 | 48943 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1344 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46130 | 6010846.48741491 | 2102064.8294817 | 37.7524811515419 | -122.40536498901001 | (37.7524811515419, -122.40536498901) | ||
| 7586 | 7586 | 48883 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1515 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2002 12:00:00 AM | 4 | 5x4 | Permit Number 46089 | 6000106.0163 | 2114246.8974 | 37.7853236932557 | -122.44338216691901 | (37.7853236932557, -122.443382166919) | |
| 70270 | 70270 | 48869 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 375 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | 23 | Permit Number 46077 | 6013801.17849 | 2105352.33133 | 37.7616726766835 | -122.39537738027501 | (37.7616726766835, -122.395377380275) | ||
| 116642 | 116642 | 34293 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2868 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 7 | Permit Number 45961 | 6010202.37211243 | 2101668.36098933 | 37.7513565026505 | -122.407564507802 | (37.7513565026505, -122.407564507802) | |
| 115214 | 115214 | 48645 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45938 | 5993372.07519062 | 2104329.12614097 | 37.7577058229285 | -122.465958462939 | (37.7577058229285, -122.465958462939) | ||
| 101498 | 101498 | 36930 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | Permit Number 45859 | 6001519.66406839 | 2103540.62826183 | 37.756007454894096 | -122.437724334797 | (37.7560074548941, -122.437724334797) | ||
| 40339 | 40339 | 48429 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2460 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 10 | Permit Number 45807 | 6001230.18864 | 2118334.23878 | 37.7966105144187 | -122.439786028808 | (37.7966105144187, -122.439786028808) | |
| 162592 | 162592 | 48353 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2085 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 45762 | 6001879.23455 | 2119763.86307 | 37.8005728104329 | -122.437642626012 | (37.8005728104329, -122.437642626012) | |||
| 121291 | 121291 | 47711 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.73697948454021 | -122.435360375218 | (37.7369794845402, -122.435360375218) | ||
| 55580 | 55580 | 41342 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 965 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | 4 | 3x3 | Permit Number 45442 | 6011232.3538 | 2111749.1886 | 37.77909377896079 | -122.40471230492099 | (37.7790937789608, -122.404712304921) |
| 19810 | 19810 | 47528 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.42641232227899 | (37.7468583456276, -122.426412322279) | ||
| 92898 | 92898 | 47527 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.42641232227899 | (37.7468583456276, -122.426412322279) | ||
| 48967 | 48967 | 47103 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3173 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 9 | Permit Number 45084 | 5995821.54315 | 2111362.39485 | 37.777158358184295 | -122.45799622921801 | (37.7771583581843, -122.457996229218) | ||
| 17976 | 17976 | 46914 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 120581 | 120581 | 46913 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 144802 | 144802 | 46912 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 8472 | 8472 | 46875 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) |
| 80552 | 80552 | 46874 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1360 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44937 | 6008040.39641169 | 2117081.79459414 | 37.793556898770795 | -122.416132380604 | (37.7935568987708, -122.416132380604) | ||
| 132509 | 132509 | 46780 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 6 | Permit Number 44871 | 6002511.8819 | 2093449.26082 | 37.7283552769641 | -122.43357175935301 | (37.7283552769641, -122.433571759353) | |
| 59286 | 59286 | 46632 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.728578532365496 | -122.389527911332 | (37.7285785323655, -122.389527911332) |
| 120457 | 120457 | 35492 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3711 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44720 | 6005570.32724281 | 2104283.24490329 | 37.7582759965632 | -122.423768581299 | (37.7582759965632, -122.423768581299) | ||
| 86647 | 86647 | 46504 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 110843 | 110843 | 46502 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 111255 | 111255 | 46503 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 124709 | 124709 | 46505 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 144741 | 144741 | 46506 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 6092 | 6092 | 46303 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 7478 | 7478 | 46291 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 10371 | 10371 | 46304 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11759 | 11759 | 46302 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 13945 | 13945 | 46285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 104223 | 104223 | 46210 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3720 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 44526 | 6003610.24375185 | 2103058.68100506 | 37.7548027913083 | -122.43046003253201 | (37.7548027913083, -122.430460032532) | |||
| 108477 | 108477 | 45798 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Clipper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2001 12:00:00 AM | Permit Number 44433 | 5999675.79411068 | 2100284.35240189 | 37.7469614974882 | -122.44386708589701 | (37.7469614974882, -122.443867085897) | |||
| 84805 | 84805 | 45714 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4096 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 44384 | 6001696.66920871 | 2105876.07387076 | 37.7624300847566 | -122.437279411511 | (37.7624300847566, -122.437279411511) | ||
| 132643 | 132643 | 45690 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1932 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2001 12:00:00 AM | 7 | Permit Number 44375 | 5999944.86656 | 2121277.56514 | 37.8046188567315 | -122.44444515193999 | (37.8046188567315, -122.44444515194) | ||
| 87124 | 87124 | 45652 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 87858 | 87858 | 45651 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 88823 | 88823 | 45650 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 125787 | 125787 | 45653 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 69045 | 69045 | 30575 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 262 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 9 | Permit Number 43817 | 6004015.932680001 | 2108728.78356 | 37.7703945078227 | -122.429461383638 | (37.7703945078227, -122.429461383638) | |
| 113790 | 113790 | 44268 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 125148 | 125148 | 44267 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 82805 | 82805 | 44113 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 91822 | 91822 | 44116 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 102982 | 102982 | 44114 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 123175 | 123175 | 44112 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 151264 | 151264 | 44079 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 172 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2000 12:00:00 AM | 4 | Permit Number 43600 | 6010499.79752 | 2111352.59578 | 37.777963856872795 | -122.40721856300699 | (37.7779638568728, -122.407218563007) | ||
| 156401 | 156401 | 43942 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3885 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2000 12:00:00 AM | 11 | Permit Number 43530 | 5995636.78457 | 2115791.89347 | 37.789309959494204 | -122.45895615544701 | (37.7893099594942, -122.458956155447) | ||
| 83623 | 83623 | 33935 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1932 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1997 12:00:00 AM | Permit Number 43529 | 6003424.24641356 | 2115332.27843331 | 37.7884925418667 | -122.43197963503201 | (37.7884925418667, -122.431979635032) | |||
| 110663 | 110663 | 43563 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 511 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43224 | 6003260.27136522 | 2098892.12079733 | 37.7433425627255 | -122.431372921103 | (37.7433425627255, -122.431372921103) | ||
| 111376 | 111376 | 43394 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 625 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43137 | 6002354.2327444 | 2102058.9743147 | 37.751986605483395 | -122.434732175811 | (37.7519866054834, -122.434732175811) | ||
| 121897 | 121897 | 43393 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 621 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43136 | 6002378.82516016 | 2102060.30692007 | 37.7519916606466 | -122.434647227061 | (37.7519916606466, -122.434647227061) | ||
| 144361 | 144361 | 43363 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4147 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43113 | 6002235.09605777 | 2101760.99319187 | 37.751161655763894 | -122.435122856595 | (37.7511616557639, -122.435122856595) | ||
| 128211 | 128211 | 41906 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42269 | 6003134.36765804 | 2107953.23072837 | 37.7682150777502 | -122.43245531412902 | (37.7682150777502, -122.432455314129) | ||
| 90615 | 90615 | 41880 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 126 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42256 | 6004087.67177215 | 2108230.12497736 | 37.7690293739028 | -122.429177676408 | (37.7690293739028, -122.429177676408) | |
| 52918 | 52918 | 41547 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 244 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | Permit Number 42070 | 6001730.08855162 | 2104417.99791196 | 37.7584284625233 | -122.437059430993 | (37.7584284625233, -122.437059430993) | |||
| 115943 | 115943 | 41185 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3440 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 2 | Permit Number 41903 | 6001280.224090001 | 2120345.1134900004 | 37.8021346936235 | -122.439757137177 | (37.8021346936235, -122.439757137177) | |
| 121453 | 121453 | 40844 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 66 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41772 | 6003136.41051744 | 2107916.36050667 | 37.7681139569619 | -122.432445614329 | (37.7681139569619, -122.432445614329) | ||||
| 98502 | 98502 | 40800 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 167 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1999 12:00:00 AM | Permit Number 41749 | 5995317.58858632 | 2087395.72139247 | 37.711322874409596 | -122.458004690935 | (37.7113228744096, -122.458004690935) | |||
| 107430 | 107430 | 40378 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 211 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | Permit Number 41491 | 6005458.18007856 | 2102476.17721451 | 37.7533078785176 | -122.424027930453 | (37.7533078785176, -122.424027930453) | |||
| 139998 | 139998 | 38953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3204 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40748 | 6008411.48904152 | 2100134.52641769 | 37.747044527767 | -122.41364913267701 | (37.747044527767, -122.413649132677) | |||
| 110800 | 110800 | 38063 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1805X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40255 | 6000940.99475203 | 2111717.60117276 | 37.77842647246 | -122.440311948792 | (37.77842647246, -122.440311948792) | |
| 142125 | 142125 | 37290 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 12 | 3x3 | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.756122133683704 | -122.43445869367399 | (37.7561221336837, -122.434458693674) |
| 146136 | 146136 | 37289 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.756122133683704 | -122.43445869367399 | (37.7561221336837, -122.434458693674) | |||
| 149318 | 149318 | 36939 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.78649992768511 | -122.461372345087 | (37.7864999276851, -122.461372345087) | |
| 159168 | 159168 | 36885 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2914 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | Permit Number 39542 | 6000200.3438800005 | 2116470.40485 | 37.79143424424 | -122.443215577236 | (37.79143424424, -122.443215577236) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");