trees
213 rows where SiteOrder = 3 and qSpecies_id = 31 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7980 | 260398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
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 | ||||||||||||||
30156 | 198691 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016677.93992 | 2094927.14945 | 37.7332068541071 | -122.384701486 | (37.7332068541071, -122.384701486) | 10 | 3 | 8 | 58 | 1 | |||
90577 | 198693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 97 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016661.34411 | 2095009.85168 | 37.733433020107 | -122.384764621992 | (37.733433020107, -122.384764621992) | 10 | 3 | 8 | 58 | 1 | |||
39111 | 200598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.7329562777939 | -122.385302911931 | (37.7329562777939, -122.385302911931) | 10 | 3 | 8 | 58 | 1 | |||
61263 | 16420 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016497.09656 | 2094873.12693 | 37.7330485158596 | -122.385322953325 | (37.7330485158596, -122.385322953325) | 10 | 3 | 8 | 58 | 1 | |||
160975 | 16434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1299X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016431.779935 | 2094795.010481 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | 10 | 3 | 8 | 58 | 1 | |||
111256 | 16440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
88315 | 198603 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016318.41228 | 2108651.0285 | 37.7708698687754 | -122.386901269979 | (37.7708698687754, -122.386901269979) | 14 | 3 | 9 | 310 | 20 | ||||
33215 | 198644 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016180.11848 | 2108766.38719 | 37.7711789603624 | -122.387387684488 | (37.7711789603624, -122.387387684488) | 14 | 3 | 9 | 310 | 20 | ||||
78156 | 198614 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015943.0209 | 2108631.53953 | 37.7707955640939 | -122.388198408934 | (37.7707955640939, -122.388198408934) | 14 | 3 | 9 | 310 | 20 | ||||
171282 | 198629 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015714.39108 | 2108739.80049 | 37.7710801545587 | -122.388996810881 | (37.7710801545587, -122.388996810881) | 14 | 3 | 9 | 310 | 20 | ||||
84939 | 200792 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1582 McKinnon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6015444.6863 | 2095914.5624 | 37.7358498081793 | -122.389034132513 | (37.7358498081793, -122.389034132513) | 10 | 3 | 8 | 58 | 1 | |||
148627 | 198435 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015582.58309 | 2106296.4914 | 37.7643640534737 | -122.389282101 | (37.7643640534737, -122.389282101) | 14 | 3 | 9 | 310 | 29 | |||
125652 | 117152 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.7285509455903 | -122.389513905896 | (37.7285509455903, -122.389513905896) | 10 | 3 | 8 | 58 | 1 | |||
28621 | 198494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015476.06266 | 2104658.66701 | 37.7598610346751 | -122.389536136987 | (37.7598610346751, -122.389536136987) | 10 | 3 | 8 | 28856 | 29 | |||
142223 | 103419 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
126663 | 198465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015348.3409 | 2105766.19544 | 37.7628949866348 | -122.390055238278 | (37.7628949866348, -122.390055238278) | 14 | 3 | 8 | 28856 | 29 | |||
20869 | 198471 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015348.95336 | 2105815.25959 | 37.7630297401524 | -122.390056547668 | (37.7630297401524, -122.390056547668) | 14 | 3 | 8 | 28856 | 29 | |||
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 | ||
127376 | 105993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 980 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015232.0353 | 2104000.80366 | 37.7580411495011 | -122.390334151305 | (37.7580411495011, -122.390334151305) | 10 | 3 | 8 | 28856 | 29 | |||
107524 | 97834 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
142251 | 198484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6015200.57665 | 2104577.87924 | 37.7596239302292 | -122.390483271483 | (37.7596239302292, -122.390483271483) | 10 | 3 | 8 | 28856 | 29 | |||
74815 | 198475 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015192.04095 | 2104775.13196 | 37.7601650702756 | -122.390526575643 | (37.7601650702756, -122.390526575643) | 10 | 3 | 8 | 28856 | 29 | |||
69763 | 200749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5099 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6014757.0105 | 2094768.5741 | 37.7326650143875 | -122.391331632933 | (37.7326650143875, -122.391331632933) | 10 | 3 | 8 | 58 | 1 | |||
157204 | 198455 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014981.91793 | 2106268.05786 | 37.7642526625648 | -122.391357663427 | (37.7642526625648, -122.391357663427) | 14 | 3 | 9 | 310 | 29 | |||
86976 | 22316 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
83633 | 200746 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014691.6022 | 2094572.3492 | 37.732122590278 | -122.391544053582 | (37.732122590278, -122.391544053582) | 10 | 3 | 8 | 58 | 1 | |||
34642 | 198561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014636.30194 | 2096168.28095 | 37.7365016238531 | -122.391846793904 | (37.7365016238531, -122.391846793904) | 10 | 3 | 8 | 58 | 1 | |||
125460 | 198527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014634.66691 | 2096168.32121 | 37.7365016436308 | -122.391852449756 | (37.7365016436308, -122.391852449756) | 10 | 3 | 8 | 58 | 1 | |||
78591 | 198554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | : | Tree | Private 2 | 2 | Width 0ft | 6014551.87687 | 2096170.80222 | 37.7365038595638 | -122.392138865814 | (37.7365038595638, -122.392138865814) | 10 | 3 | 8 | 58 | 1 | |||
163268 | 198575 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6014794.5907 | 2114154.82505 | 37.7858975653617 | -122.392557300594 | (37.7858975653617, -122.392557300594) | 6 | 2 | 9 | 28855 | 6 | |||
92342 | 198565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014744.18848 | 2114165.67532 | 37.7859245585079 | -122.392732439056 | (37.7859245585079, -122.392732439056) | 6 | 2 | 9 | 28855 | 6 | |||
183902 | 253394 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
109770 | 201908 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.394643789789 | (37.7284270698286, -122.394643789789) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
24826 | 198583 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013760.46871 | 2107146.56354 | 37.7665969793027 | -122.395643896153 | (37.7665969793027, -122.395643896153) | 14 | 3 | 8 | 28856 | 20 | |
46833 | 110635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013464.4845 | 2113882.0453 | 37.7850746181572 | -122.397139998491 | (37.7850746181572, -122.397139998491) | 6 | 2 | 9 | 28856 | 6 | |||
143260 | 198595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013296.53525 | 2107120.49149 | 37.7664995737224 | -122.397246743447 | (37.7664995737224, -122.397246743447) | 14 | 3 | 8 | 28856 | 20 | |||
16269 | 198600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1050 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013090.52825 | 2107110.01033 | 37.7664593236741 | -122.397958554166 | (37.7664593236741, -122.397958554166) | 14 | 3 | 8 | 28856 | 20 | |||
79347 | 32996 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.02247 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | 6 | 2 | 9 | 28853 | 6 | |
157109 | 3749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 934 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012421.5071398 | 2103592.6632765 | 37.756764184951 | -122.400025556542 | (37.756764184951, -122.400025556542) | 10 | 3 | 8 | 28856 | 29 | |||
25561 | 101710 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
77331 | 198504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 785 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011870.75445 | 2104712.89725 | 37.7598093776163 | -122.402009022396 | (37.7598093776163, -122.402009022396) | 10 | 3 | 8 | 28856 | 29 | |||
180728 | 137057 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011992.2179 | 2118432.89222 | 37.7974880935481 | -122.402553733674 | (37.7974880935481, -122.402553733674) | 3 | 1 | 10 | 308 | 23 | |||
190372 | 137058 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 440 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011933.40589 | 2118423.08303 | 37.7974578763363 | -122.402756549698 | (37.7974578763363, -122.402756549698) | 3 | 1 | 10 | 308 | 23 | |||
116258 | 137062 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 462 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011753.78546 | 2118398.85013 | 37.7973813080638 | -122.40337638132 | (37.7973813080638, -122.40337638132) | 3 | 1 | 10 | 308 | 23 | |||
116030 | 35674 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 490 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.7973863786405 | -122.403547515196 | (37.7973863786405, -122.403547515196) | 3 | 1 | 10 | 308 | 23 | |
2974 | 260217 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010872 | 2093992 | 37.7303163237311 | -122.404708489988 | (37.7303163237311, -122.404708489988) | 10 | 3 | 7 | 309 | 28 | ||||
163070 | 36147 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2201 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | 8 | 4 | 8 | 28859 | 19 | ||
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 | |||
160710 | 180536 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010343.05054 | 2092296.39853 | 37.7256309795628 | -122.406417719414 | (37.7256309795628, -122.406417719414) | 10 | 3 | 7 | 309 | 28 | |||
105551 | 91033 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010628.8889 | 2111172.6244 | 37.7774769212136 | -122.406759301284 | (37.7774769212136, -122.406759301284) | 14 | 2 | 9 | 28853 | 34 | ||
170581 | 72754 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 181 RUSS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1998 12:00:00 AM | 3 | 5x5 | 6010587 | 2111361.1 | 37.7779920873886 | -122.40691749682 | (37.7779920873886, -122.40691749682) | 14 | 2 | 9 | 28853 | 34 | ||
110224 | 198670 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 194 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010573.77225 | 2111256.57135 | 37.7777043359308 | -122.406955887221 | (37.7777043359308, -122.406955887221) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
179870 | 112877 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 300x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x2 | 6010100 | 2099291 | 37.7448230609493 | -122.407750909418 | (37.7448230609493, -122.407750909418) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
155936 | 102761 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.408218187711 | (37.7785759102049, -122.408218187711) | 14 | 2 | 9 | 28853 | 34 |
119476 | 98272 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | ||
147272 | 137039 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009772.70737 | 2116813.88249 | 37.7929185267084 | -122.410119497111 | (37.7929185267084, -122.410119497111) | 3 | 1 | 10 | 28857 | 21 | |||
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 | ||
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 | ||
118557 | 198684 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009045.18869 | 2110977.41659 | 37.7768521887265 | -122.412224065387 | (37.7768521887265, -122.412224065387) | 8 | 2 | 9 | 28853 | 34 | |||
69505 | 46504 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.412275670972 | (37.7768559207247, -122.412275670972) | 8 | 2 | 9 | 28853 | 34 | |||
99200 | 242647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008809.14525 | 2102757.20392 | 37.7542681355747 | -122.412459422473 | (37.7542681355747, -122.412459422473) | 2 | 4 | 7 | 28859 | 19 | |||
114039 | 44114 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
166644 | 242459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 434 Banks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008569.03881 | 2096702.15608 | 37.7376288403924 | -122.412861705413 | (37.7376288403924, -122.412861705413) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
191098 | 255052 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199x 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008753 | 2110574 | 37.7757281025158 | -122.413206304146 | (37.7757281025158, -122.413206304146) | 8 | 2 | 9 | 28853 | 34 | ||||
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 | |||
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 | |||
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 | ||
180073 | 7610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3201X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008468.12704 | 2100135.33382 | 37.7470499250079 | -122.413453339725 | (37.7470499250079, -122.413453339725) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
44141 | 242625 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3198X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008400.82271 | 2100348.16336 | 37.747630528223 | -122.413701124526 | (37.747630528223, -122.413701124526) | 2 | 7 | 7 | 28859 | 2 | |||
43146 | 7599 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3106 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6008391.53469 | 2100462.67214 | 37.7479444222008 | -122.413741340393 | (37.7479444222008, -122.413741340393) | 2 | 7 | 7 | 28859 | 2 | |||
106451 | 18526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
79927 | 7583 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
19980 | 98857 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008572.87311 | 2110548.2851 | 37.77564738136 | -122.413827590795 | (37.77564738136, -122.413827590795) | 8 | 2 | 9 | 28853 | 34 | |||
110810 | 101949 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769636 | 6008537 | 2110562 | 37.7756830245653 | -122.413952655551 | (37.7756830245653, -122.413952655551) | 8 | 2 | 9 | 28853 | 34 | |
107317 | 242514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2948 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008345.17157 | 2101253.04618 | 37.7501120086795 | -122.413957566206 | (37.7501120086795, -122.413957566206) | 2 | 4 | 7 | 28859 | 19 | |||
135105 | 98860 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008529.07758 | 2110594.62185 | 37.7757721514991 | -122.413982369511 | (37.7757721514991, -122.413982369511) | 8 | 2 | 9 | 28853 | 34 | |||
61272 | 608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2785X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6008346.15887 | 2102213.06871 | 37.7527480699909 | -122.414022059281 | (37.7527480699909, -122.414022059281) | 2 | 4 | 7 | 28859 | 19 | |||
90005 | 7488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6008316.60225 | 2102810.93946 | 37.7543880278024 | -122.414166566835 | (37.7543880278024, -122.414166566835) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
51129 | 242492 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2507 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6008258.15624 | 2103821.5698 | 37.7571597059716 | -122.414440195483 | (37.7571597059716, -122.414440195483) | 2 | 4 | 7 | 28859 | 19 | |||
97382 | 137049 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008515.90058 | 2116780.94571 | 37.7927575660663 | -122.414465794683 | (37.7927575660663, -122.414465794683) | 5 | 1 | 10 | 28858 | 21 | |||
155571 | 200942 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1595 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008302.9396 | 2108913.0233 | 37.7711421752939 | -122.414645612489 | (37.7711421752939, -122.414645612489) | 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 | ||
129015 | 242568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2121 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008133.25009 | 2106138.47369 | 37.7635143740114 | -122.415036159087 | (37.7635143740114, -122.415036159087) | 8 | 4 | 7 | 28859 | 19 | |||
95943 | 108135 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2055 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008137.2 | 2106486.4 | 37.7644699210537 | -122.415047125765 | (37.7644699210537, -122.415047125765) | 8 | 4 | 7 | 28859 | 19 | ||||
142346 | 242571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2075 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008126.47482 | 2106341.38137 | 37.7640711307933 | -122.415073955818 | (37.7640711307933, -122.415073955818) | 8 | 4 | 7 | 28859 | 19 | |||
185130 | 30619 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1645 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 4 | Permit Number 34580 | 6008146.3215 | 2108637.1249 | 37.7703758225592 | -122.415167828975 | (37.7703758225592, -122.415167828975) | 8 | 2 | 9 | 28853 | 19 | |
91758 | 200948 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1665 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008110.2367 | 2108543.9059 | 37.7701178370902 | -122.415286046702 | (37.7701178370902, -122.415286046702) | 8 | 2 | 9 | 28853 | 19 | |||
165025 | 30641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 80x 13th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34584 | 6008099.08967 | 2108395.87431 | 37.7697107505788 | -122.415314123362 | (37.7697107505788, -122.415314123362) | 8 | 4 | 9 | 28853 | 19 | |
102300 | 113801 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 806 SHOTWELL ST | 3 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
62676 | 32534 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
21183 | 254244 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
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 |
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) );