trees
2,365 rows where qSpecies_id = 31 sorted by qCaretaker_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108007 | 11876 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1501X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
118544 | 11877 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
176701 | 11878 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1501X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
33876 | 115549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | 10 | 3 | 8 | 28856 | 29 | ||
38426 | 115550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.390181786362 | (37.7584697654838, -122.390181786362) | 10 | 3 | 8 | 28856 | 29 | ||
97154 | 70472 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
129944 | 115551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.390190372193 | (37.7585616474178, -122.390190372193) | 10 | 3 | 8 | 28856 | 29 | ||
173056 | 122420 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2200 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
60 | 264971 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 150 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | 5990555.23468 | 2114396.47455 | 37.7851851170506 | -122.476435559205 | (37.7851851170506, -122.476435559205) | 11 | 6 | 2 | 54 | 26 | |||
96 | 137041 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009697.84819 | 2116804.05029 | 37.7928873337267 | -122.410377820179 | (37.7928873337267, -122.410377820179) | 3 | 1 | 10 | 28857 | 21 | ||
147 | 198543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | : | Tree | Private 2 | 3 | Width 0ft | 6014375.16951 | 2096346.21278 | 37.7369756879815 | -122.392762090617 | (37.7369756879815, -122.392762090617) | 10 | 3 | 8 | 58 | 1 | |||
820 | 41547 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 244 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2000 12:00:00 AM | Permit Number 42070 | 6001730.08855162 | 2104417.99791196 | 37.7584284625233 | -122.437059430993 | (37.7584284625233, -122.437059430993) | 2 | 4 | 5 | 28862 | 3 | |||
969 | 198677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010377.80869 | 2111537.89689 | 37.7784658224798 | -122.407653636128 | (37.7784658224798, -122.407653636128) | 14 | 2 | 9 | 28853 | 34 | |||
1367 | 242756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 188 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000188.06394 | 2105671.62419 | 37.7617828409166 | -122.442482425621 | (37.7617828409166, -122.442482425621) | 15 | 5 | 5 | 28862 | 3 | |||
1609 | 7556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2908 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2005 12:00:00 AM | 3 | 4X4 | 6008332.64418 | 2101445.38004 | 37.7506394106909 | -122.414014491473 | (37.7506394106909, -122.414014491473) | 2 | 4 | 7 | 28859 | 19 | ||
1850 | 138602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2660 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 02:03:00 PM | 3 | Width 0ft | 6001218.2318 | 2114936.9229 | 37.7872816882761 | -122.439583731447 | (37.7872816882761, -122.439583731447) | 13 | 6 | 1 | 29490 | 27 | ||
2080 | 51849 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4000 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.432677808926 | (37.7594924661239, -122.432677808926) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
2305 | 251465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008072 | 2112894 | 37.7820600122669 | -122.415726368353 | (37.7820600122669, -122.415726368353) | 7 | 10 | 9 | 28852 | 36 | ||||
2613 | 242693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4000 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002933 | 2104797 | 37.7595374124063 | -122.432926308416 | (37.7595374124063, -122.432926308416) | 2 | 4 | 5 | 28862 | 3 | |||
2661 | 123693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 9 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995461.17658 | 2113536.44974 | 37.7831070225625 | -122.459400327451 | (37.7831070225625, -122.459400327451) | 11 | 6 | 2 | 54 | 11 | |||
2748 | 51918 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.92432 | 2091688.24542 | 37.7233599872689 | -122.443166369055 | (37.7233599872689, -122.443166369055) | 9 | 7 | 6 | 28861 | 25 | |
2754 | 198688 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 165 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008649.71032 | 2110465.86433 | 37.7754253882045 | -122.413555960437 | (37.7754253882045, -122.413555960437) | 8 | 2 | 9 | 28853 | 34 | |||
3023 | 137045 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008938.66451 | 2116698.53363 | 37.7925550234358 | -122.412997178389 | (37.7925550234358, -122.412997178389) | 5 | 1 | 10 | 28857 | 21 | |||
3172 | 138586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2702 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000914.7508 | 2114889.5525 | 37.7871343442132 | -122.440630309715 | (37.7871343442132, -122.440630309715) | 13 | 6 | 1 | 29490 | 27 | |||
3281 | 18051 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2840 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1999 12:00:00 AM | 6 | 3X3PL | 6000336.3598 | 2114811.683 | 37.7868875811217 | -122.442625816895 | (37.7868875811217, -122.442625816895) | 13 | 6 | 1 | 29490 | 27 | ||
3398 | 30348 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 420 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1956 12:00:00 AM | 13 | Permit Number 31 | 6012919.88824 | 2105064.35635 | 37.7608329059296 | -122.398405220419 | (37.7608329059296, -122.398405220419) | 10 | 3 | 8 | 28856 | 29 | ||
3454 | 136963 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2590 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000644.64668 | 2118255.6964 | 37.7963615110306 | -122.441806488875 | (37.7963615110306, -122.441806488875) | 13 | 9 | 1 | 57 | 17 | |||
3611 | 242616 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Highland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
3772 | 215475 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993086.32041 | 2105916.03813 | 37.7620465797188 | -122.467062084267 | (37.7620465797188, -122.467062084267) | 1 | 8 | 4 | 56 | 12 | |||
3886 | 7433 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2515 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008263.61131 | 2103755.89394 | 37.7569796814773 | -122.414416682704 | (37.7569796814773, -122.414416682704) | 2 | 4 | 7 | 28859 | 19 | |||
3906 | 242754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 78 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001027.40301 | 2105958.45714 | 37.7626182202887 | -122.439600057097 | (37.7626182202887, -122.439600057097) | 15 | 5 | 5 | 28862 | 3 | |||
4054 | 61321 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1493 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 2 | Permit Number 21224 | 6011782.72959 | 2101393.64443 | 37.750690525464 | -122.40208010572 | (37.750690525464, -122.40208010572) | 10 | 3 | 8 | 28856 | 29 | |
4061 | 46914 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
4133 | 138411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002152.1984 | 2115012.2116 | 37.7875415238713 | -122.436357800436 | (37.7875415238713, -122.436357800436) | 13 | 6 | 11 | 29490 | 27 | |||
4146 | 242645 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3226 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008172.83241 | 2101552.12353 | 37.7509235272008 | -122.414574688189 | (37.7509235272008, -122.414574688189) | 2 | 4 | 7 | 28859 | 19 | |||
4228 | 254718 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
4429 | 97836 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
4576 | 137643 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1313 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002875.8523 | 2111640.465 | 37.7783246490231 | -122.43361304212 | (37.7783246490231, -122.43361304212) | 15 | 5 | 11 | 29492 | 41 | |||
4577 | 137042 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1228 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008994.19297 | 2117174.51361 | 37.7938650649634 | -122.412838714232 | (37.7938650649634, -122.412838714232) | 3 | 1 | 10 | 28857 | 21 | |||
4643 | 76181 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6009574.6956 | 2110252.7468 | 37.7748921128949 | -122.410341153951 | (37.7748921128949, -122.410341153951) | 8 | 2 | 9 | 28853 | 34 | |||
4645 | 107053 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450 Walnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.448562297399 | (37.7875132600186, -122.448562297399) | 13 | 6 | 1 | 54 | 31 | |||||
4702 | 198610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016166.07078 | 2108644.55968 | 37.7708436706185 | -122.387427776296 | (37.7708436706185, -122.387427776296) | 14 | 3 | 9 | 310 | 20 | ||||
4784 | 242408 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3711 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6005560.82063 | 2104287.7294 | 37.7582877732797 | -122.42380177823 | (37.7582877732797, -122.42380177823) | 2 | 4 | 5 | 28859 | 19 | |||
4812 | 198517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 2 | : | Tree | Private 2 | 5 | Width 7ft | 6014346.73951 | 2096322.78373 | 37.7369097775472 | -122.392858747949 | (37.7369097775472, -122.392858747949) | 10 | 3 | 8 | 58 | 1 | |||
4995 | 242611 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 121 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6006528.89277 | 2098549.54535 | 37.7425866319823 | -122.420046541223 | (37.7425866319823, -122.420046541223) | 2 | 7 | 7 | 28859 | 2 | |||
5056 | 248171 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 314 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010101.97177 | 2099246.95589 | 37.7447022358135 | -122.407740986359 | (37.7447022358135, -122.407740986359) | 2 | 7 | 7 | 28859 | 2 | |||
5182 | 242721 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 291 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6004399.96765 | 2103934.30493 | 37.7572517524893 | -122.427791335409 | (37.7572517524893, -122.427791335409) | 2 | 4 | 5 | 28862 | 3 | |||
5237 | 200943 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1595 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008270.8642 | 2108872.4279 | 37.7710289077095 | -122.41475368939 | (37.7710289077095, -122.41475368939) | 8 | 2 | 9 | 28853 | 19 | |||
5430 | 242594 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4317 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001015.759 | 2101696.42281 | 37.7509150466066 | -122.439334816464 | (37.7509150466066, -122.439334816464) | 2 | 4 | 5 | 28862 | 22 | |||
5503 | 7438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2525 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008265.55566 | 2103676.03648 | 37.7567605203109 | -122.414404308016 | (37.7567605203109, -122.414404308016) | 2 | 4 | 7 | 28859 | 19 | |||
5601 | 180565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 522 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004047.94044 | 2092448.57496 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | 9 | 7 | 6 | 28861 | 5 | |||
5767 | 237723 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 175 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6000298.26897 | 2105610.5096 | 37.7616213164011 | -122.442096884487 | (37.7616213164011, -122.442096884487) | 15 | 5 | 5 | 28862 | 3 | |||
5878 | 236882 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 150 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 5 | Width 3ft | Permit Number 772898 | 5999413.41178 | 2107340.88769 | 37.7663220358477 | -122.445281650937 | (37.7663220358477, -122.445281650937) | 15 | 5 | 5 | 29492 | 9 | |
5917 | 66634 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 963 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | 5 | 3x3 | Permit Number 29842 | 6010240.69544356 | 2103618.46143652 | 37.7567131899968 | -122.407569458435 | (37.7567131899968, -122.407569458435) | 10 | 4 | 7 | 28859 | 19 |
5992 | 115018 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4311 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000722 | 2105756 | 37.7620449359843 | -122.440641810954 | (37.7620449359843, -122.440641810954) | 15 | 5 | 5 | 28862 | 3 | |||
6194 | 198430 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 312 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010577.37661 | 2106819.14849 | 37.7655203963654 | -122.406630632998 | (37.7655203963654, -122.406630632998) | 8 | 4 | 8 | 28853 | 19 | |||
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 | ||
6477 | 215562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 244 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994036.57489 | 2096375.72 | 37.735906092783 | -122.463083305449 | (37.735906092783, -122.463083305449) | 9 | 8 | 4 | 59 | 40 | |||
6498 | 242573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2055 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5x9 | 6008115.25699 | 2106522.97754 | 37.7645691213862 | -122.415125610158 | (37.7645691213862, -122.415125610158) | 8 | 4 | 7 | 28859 | 19 | |||
6558 | 57073 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 958 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 17 | Permit Number 14340 | 6015221.7654 | 2104138.81007 | 37.7584195158777 | -122.390379311651 | (37.7584195158777, -122.390379311651) | 10 | 3 | 8 | 28856 | 29 | ||
6579 | 242676 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3937 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003536.02331 | 2102417.7982 | 37.7530388738604 | -122.430670977181 | (37.7530388738604, -122.430670977181) | 2 | 4 | 5 | 28862 | 22 | |||
6749 | 242499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008244.84467 | 2103100.98301 | 37.7551803907701 | -122.414435245603 | (37.7551803907701, -122.414435245603) | 2 | 4 | 7 | 28859 | 19 | |||
6913 | 215496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 69 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993975.72153 | 2097357.94979 | 37.7385995461283 | -122.463364953343 | (37.7385995461283, -122.463364953343) | 1 | 8 | 4 | 59 | 40 | |||
7090 | 52720 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 710@ 20th ST Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2006 12:00:00 AM | Permit Number 48773 | 6002386.64959974 | 2104032.25895211 | 37.757406613771 | -122.434761169877 | (37.757406613771, -122.434761169877) | 2 | 4 | 5 | 28862 | 3 | |||
7095 | 198444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015385.26433 | 2106283.84094 | 37.7643183769187 | -122.389963693588 | (37.7643183769187, -122.389963693588) | 14 | 3 | 9 | 310 | 29 | |||
7134 | 7508 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2733 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008332.69798 | 2102504.20303 | 37.7535467030383 | -122.414089204467 | (37.7535467030383, -122.414089204467) | 2 | 4 | 7 | 28859 | 19 | |||
7172 | 242618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007915.14616 | 2096519.82077 | 37.7370914621948 | -122.415109628301 | (37.7370914621948, -122.415109628301) | 2 | 7 | 7 | 28859 | 2 | |||
7235 | 74494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010764.33667 | 2106446.7054 | 37.7645082103165 | -122.405957737757 | (37.7645082103165, -122.405957737757) | 8 | 4 | 8 | 28859 | 19 | |||
7295 | 100582 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
7847 | 7489 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008322.6919 | 2102757.85565 | 37.7542426137298 | -122.414141751858 | (37.7542426137298, -122.414141751858) | 2 | 4 | 7 | 28859 | 19 | |||
8224 | 254835 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 250 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2019 12:00:00 AM | 3 | 4x3 | Permit Number 784635 | 5989365 | 2113673 | 37.7831295589045 | -122.480500378386 | (37.7831295589045, -122.480500378386) | 11 | 6 | 2 | 55 | 26 |
8303 | 180530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
8319 | 260505 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 760 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784870 | 6007464 | 2105234 | 37.7609932681872 | -122.417286789238 | (37.7609932681872, -122.417286789238) | 2 | 4 | 7 | 28859 | 19 | |
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 | |||
8560 | 242617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Bennington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007051.1369 | 2096685.57383 | 37.7374979908344 | -122.418108653317 | (37.7374979908344, -122.418108653317) | 2 | 7 | 7 | 28859 | 2 | |||
8701 | 200755 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5099 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014751.1238 | 2094745.6812 | 37.7326018284177 | -122.391350385093 | (37.7326018284177, -122.391350385093) | 10 | 3 | 8 | 58 | 1 | |||
8784 | 46303 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
9012 | 180529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
9031 | 74649 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010746.42629 | 2106444.22464 | 37.7645003969982 | -122.406019510419 | (37.7645003969982, -122.406019510419) | 8 | 4 | 8 | 28859 | 19 | |||
9121 | 46285 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
9179 | 215530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994021.33126 | 2097709.05499 | 37.7395662211057 | -122.463232727835 | (37.7395662211057, -122.463232727835) | 1 | 8 | 4 | 59 | 40 | |||
9357 | 106645 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 772901 | 6001633.7 | 2104049.1 | 37.7574100789152 | -122.437366369677 | (37.7574100789152, -122.437366369677) | 2 | 4 | 5 | 28862 | 3 | |||
9720 | 242385 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005896.47931 | 2107288.01777 | 37.7665448015394 | -122.422854150009 | (37.7665448015394, -122.422854150009) | 8 | 4 | 5 | 28853 | 19 | |||
9860 | 261981 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 853 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004377.23368 | 2103892.56966 | 37.7571358712273 | -122.427866984578 | (37.7571358712273, -122.427866984578) | 2 | 4 | 5 | 28862 | 3 | ||||
9906 | 46304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
9921 | 220013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 58 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005865.66076 | 2102301.94093 | 37.7528524632741 | -122.42260639579 | (37.7528524632741, -122.42260639579) | 2 | 4 | 5 | 28859 | 19 | |||
10022 | 46302 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
10187 | 242636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3357 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6008524.39622 | 2099125.83566 | 37.7442812262921 | -122.413187392191 | (37.7442812262921, -122.413187392191) | 2 | 7 | 7 | 28859 | 2 | |||
10264 | 137022 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003025.71137 | 2117483.5061 | 37.7943766605074 | -122.433512298867 | (37.7943766605074, -122.433512298867) | 13 | 9 | 1 | 29490 | 27 | |||
10265 | 242383 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005959.30946 | 2107292.9046 | 37.7665617645426 | -122.422637178672 | (37.7665617645426, -122.422637178672) | 8 | 4 | 5 | 28853 | 19 | |||
10305 | 98993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1919 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768862 | 6003810 | 2118645 | 37.7976102909597 | -122.430881499482 | (37.7976102909597, -122.430881499482) | 13 | 9 | 1 | 57 | 17 | |
10327 | 198443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015407.0439 | 2106284.70526 | 37.7643219580036 | -122.389888423915 | (37.7643219580036, -122.389888423915) | 14 | 3 | 9 | 310 | 29 | |||
10797 | 49734 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2940REVISED Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.7502358181357 | -122.413951255275 | (37.7502358181357, -122.413951255275) | 2 | 4 | 7 | 28859 | 19 | ||
11128 | 198446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015345.15707 | 2106282.18607 | 37.7643116086136 | -122.390102298884 | (37.7643116086136, -122.390102298884) | 14 | 3 | 9 | 310 | 29 | |||
11178 | 200944 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1595 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008285.8995 | 2108891.4726 | 37.771082044751 | -122.41470302964 | (37.771082044751, -122.41470302964) | 8 | 2 | 9 | 28853 | 19 | |||
11968 | 242397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1784 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x8 | 6005589.03646 | 2107271.34136 | 37.7664816601377 | -122.423916355479 | (37.7664816601377, -122.423916355479) | 8 | 4 | 5 | 28853 | 19 | |||
11978 | 7458 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2576 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2019 12:00:00 AM | 3 | 5x5 | 6008224.65711 | 2103426.0166 | 37.7560717250334 | -122.41452805924 | (37.7560717250334, -122.41452805924) | 2 | 4 | 7 | 28859 | 19 | ||
12015 | 242657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 502 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001803.26335 | 2102879.5886 | 37.7542085204161 | -122.436696239741 | (37.7542085204161, -122.436696239741) | 2 | 4 | 5 | 28862 | 22 | |||
12027 | 258891 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003970 | 2113206 | 37.7826852397237 | -122.429939681443 | (37.7826852397237, -122.429939681443) | 7 | 9 | 11 | 29490 | 41 |
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) );