trees
2,365 rows where qSpecies_id = 31 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
1683 | 85790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | 8 | 2 | 9 | 28853 | 34 | ||
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 | ||
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 | ||||
2469 | 260495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | |||
3271 | 260494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | |||
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 | ||||
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 | |||
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 | ||
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 | |||
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 | |||||
8039 | 260496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | |||
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 | |||
10535 | 258146 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1048 Folsom St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010642.12041 | 2111257.36423 | 37.7777103373451 | -122.406719502289 | (37.7777103373451, -122.406719502289) | 14 | 2 | 9 | 28853 | 34 | ||||
11086 | 242374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 6006546.0037 | 2109148.19709 | 37.7716890396519 | -122.420739627149 | (37.7716890396519, -122.420739627149) | 8 | 2 | 9 | 28853 | 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 | |||
14903 | 91162 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007112.34702 | 2112584.78934 | 37.7811570014217 | -122.419024399678 | (37.7811570014217, -122.419024399678) | 7 | 9 | 9 | 28852 | 36 | |
15550 | 32997 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013196.81609 | 2113721.08426 | 37.784617751847 | -122.398054757315 | (37.784617751847, -122.398054757315) | 6 | 2 | 9 | 28853 | 6 | |
15645 | 137035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 128 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008088.76932 | 2112909.47489 | 37.7821034452579 | -122.415669449996 | (37.7821034452579, -122.415669449996) | 7 | 10 | 9 | 28852 | 36 | |||
15703 | 74054 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 194X Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 5x5 | 6010549.99954 | 2111279.17691 | 37.7777650752333 | -122.407039719318 | (37.7777650752333, -122.407039719318) | 14 | 2 | 9 | 28853 | 34 | |||
16029 | 198662 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013921.99886 | 2107418.77263 | 37.7673533891782 | -122.395104256175 | (37.7673533891782, -122.395104256175) | 14 | 3 | 9 | 310 | 20 | |||
16163 | 32994 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.84928 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | 6 | 2 | 9 | 28853 | 6 | |
17062 | 198453 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015012.52649 | 2106269.21439 | 37.7642575368696 | -122.391251877095 | (37.7642575368696, -122.391251877095) | 14 | 3 | 9 | 310 | 29 | |||
17960 | 81238 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008758.1555 | 2109381.0971 | 37.7724529612773 | -122.41310410127 | (37.7724529612773, -122.41310410127) | 8 | 2 | 9 | 28853 | 34 | |||
18804 | 85789 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1157 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 8 | 3x3 | 6009966.4934 | 2110538.8397 | 37.7756996123582 | -122.409006027185 | (37.7756996123582, -122.409006027185) | 8 | 2 | 9 | 28853 | 34 | ||
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 | |||
20199 | 46505 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 1 | 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 | |||
20821 | 85762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1246 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009446.0112 | 2110126.3604 | 37.7745378709641 | -122.410777374473 | (37.7745378709641, -122.410777374473) | 8 | 2 | 9 | 28853 | 34 | ||
21138 | 198434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015605.2539 | 2106298.94966 | 37.7643720601453 | -122.389203859978 | (37.7643720601453, -122.389203859978) | 14 | 3 | 9 | 310 | 29 | |||
22011 | 198661 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013934.2668 | 2107404.04412 | 37.7673136301584 | -122.39506079103 | (37.7673136301584, -122.39506079103) | 14 | 3 | 9 | 310 | 20 | |||
22908 | 32995 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.26593 | 37.7844388182424 | -122.398280299215 | (37.7844388182424, -122.398280299215) | 6 | 2 | 9 | 28853 | 6 | |
22910 | 75248 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199X RUSS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1995 12:00:00 AM | 2 | 5x5 | 6010421 | 2111456 | 37.7782433704481 | -122.407498444933 | (37.7782433704481, -122.407498444933) | 14 | 2 | 9 | 28853 | 34 | ||
23450 | 91035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010666.0508 | 2111208.1223 | 37.7775764693736 | -122.406633247496 | (37.7775764693736, -122.406633247496) | 14 | 2 | 9 | 28853 | 34 | ||
23988 | 198459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014889.29769 | 2106275.30651 | 37.7642674249283 | -122.391678519967 | (37.7642674249283, -122.391678519967) | 14 | 3 | 9 | 310 | 29 | |||
24697 | 91031 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.148 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | 14 | 2 | 9 | 28853 | 34 | ||
26267 | 198618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015853.85549 | 2108626.75005 | 37.770777472425 | -122.388506502268 | (37.770777472425, -122.388506502268) | 14 | 3 | 9 | 310 | 20 | ||||
26333 | 85767 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008747.4583 | 2109466.0696 | 37.7726856753072 | -122.41314711365 | (37.7726856753072, -122.41314711365) | 8 | 2 | 9 | 28853 | 34 | ||
26663 | 85795 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 985 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 12 | 3x3 | 6011121.9774 | 2111644.9134 | 37.7788012938106 | -122.405086799447 | (37.7788012938106, -122.405086799447) | 14 | 2 | 9 | 28856 | 34 | ||
26836 | 198657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013998.08453 | 2107337.5024 | 37.7671344699085 | -122.394835392165 | (37.7671344699085, -122.394835392165) | 14 | 3 | 9 | 310 | 20 | |||
27935 | 253392 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | 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 | |
28247 | 91339 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 829 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52060 | 6012087.196 | 2112565.923 | 37.7813840839391 | -122.401812466037 | (37.7813840839391, -122.401812466037) | 6 | 2 | 9 | 28856 | 34 | |
28371 | 108235 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
28443 | 198576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014783.08484 | 2114165.12178 | 37.7859251988423 | -122.392597828542 | (37.7859251988423, -122.392597828542) | 6 | 2 | 9 | 28855 | 6 | |||
29360 | 201851 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1119 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010210.791 | 2110772.6508 | 37.7763552850367 | -122.408177430978 | (37.7763552850367, -122.408177430978) | 8 | 2 | 9 | 28853 | 34 | |||
29914 | 198681 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010294.84433 | 2111624.83118 | 37.7786998791448 | -122.407946774624 | (37.7786998791448, -122.407946774624) | 14 | 2 | 9 | 28853 | 34 | |||
30695 | 255050 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199x 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008753 | 2110574 | 37.7757281025158 | -122.413206304146 | (37.7757281025158, -122.413206304146) | 8 | 2 | 9 | 28853 | 34 | ||||
32856 | 198447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015324.46824 | 2106281.29518 | 37.7643080149349 | -122.390173794086 | (37.7643080149349, -122.390173794086) | 14 | 3 | 9 | 310 | 29 | |||
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 | ||||
33488 | 198652 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6016352.81609 | 2108774.30794 | 37.7712102720761 | -122.386790863815 | (37.7712102720761, -122.386790863815) | 14 | 3 | 9 | 310 | 20 | ||||
34182 | 198607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016227.74089 | 2108648.22285 | 37.7708571442621 | -122.387214711603 | (37.7708571442621, -122.387214711603) | 14 | 3 | 9 | 310 | 20 | ||||
35158 | 100568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 868 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011788.1802 | 2112369.4793 | 37.780828003664 | -122.40283310111 | (37.780828003664, -122.40283310111) | 6 | 2 | 9 | 28853 | 34 | |||
36117 | 198433 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015623.39252 | 2106299.43011 | 37.764374384886 | -122.38914115655 | (37.764374384886, -122.38914115655) | 14 | 3 | 9 | 310 | 29 | |||
37320 | 85785 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 5 | 3x3 | 6009541.3755 | 2110133.2543 | 37.7745621465765 | -122.410447976342 | (37.7745621465765, -122.410447976342) | 8 | 2 | 9 | 28853 | 34 | ||
37402 | 110633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013429.5241 | 2113847.0849 | 37.7849766786955 | -122.397258498892 | (37.7849766786955, -122.397258498892) | 6 | 2 | 9 | 28856 | 6 | |||
38035 | 85764 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1350 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008969.0729 | 2109678.3998 | 37.7732811230446 | -122.412395532912 | (37.7732811230446, -122.412395532912) | 8 | 2 | 9 | 28853 | 34 | ||
38457 | 85775 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1501 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008458.3046 | 2109095.9531 | 37.7716531852784 | -122.4141211414 | (37.7716531852784, -122.4141211414) | 8 | 2 | 9 | 28853 | 19 | ||
40054 | 198640 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015953.10569 | 2108752.97494 | 37.7711295579122 | -122.388172001232 | (37.7711295579122, -122.388172001232) | 14 | 3 | 9 | 310 | 20 | ||||
41142 | 49606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1245 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009457.5009 | 2110055.1245 | 37.7743429180698 | -122.410732597335 | (37.7743429180698, -122.410732597335) | 8 | 2 | 9 | 28853 | 34 | |
42968 | 100580 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
44496 | 198622 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015766.21634 | 2108621.93006 | 37.7707593807704 | -122.388809313913 | (37.7707593807704, -122.388809313913) | 14 | 3 | 9 | 310 | 20 | ||||
44552 | 198462 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014805.14744 | 2106272.79418 | 37.7642558551341 | -122.391969398478 | (37.7642558551341, -122.391969398478) | 14 | 3 | 9 | 310 | 29 | |||
44669 | 200957 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1346 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6009030.8344 | 2109737.7393 | 37.7734475210855 | -122.41218608535 | (37.7734475210855, -122.41218608535) | 8 | 2 | 9 | 28853 | 34 | |||
44812 | 198627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015673.13601 | 2108738.35245 | 37.7710738916798 | -122.389139413673 | (37.7710738916798, -122.389139413673) | 14 | 3 | 9 | 310 | 20 | ||||
45131 | 198642 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6016136.74684 | 2108760.92666 | 37.7711615647777 | -122.387537328991 | (37.7711615647777, -122.387537328991) | 14 | 3 | 9 | 310 | 20 | ||||
45264 | 198574 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6014815.04425 | 2114132.68239 | 37.7858379025473 | -122.392484987011 | (37.7858379025473, -122.392484987011) | 6 | 2 | 9 | 28855 | 6 | |||
45722 | 242776 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 50 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6006653.46745 | 2109553.97521 | 37.7728092657628 | -122.420396709346 | (37.7728092657628, -122.420396709346) | 8 | 2 | 9 | 28853 | 19 | |||
45948 | 198666 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013864.8595 | 2107478.20715 | 37.7675134055349 | -122.395306058649 | (37.7675134055349, -122.395306058649) | 14 | 3 | 9 | 310 | 20 | |||
46084 | 198654 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014045.10244 | 2107292.39517 | 37.7670132295924 | -122.394669603922 | (37.7670132295924, -122.394669603922) | 14 | 3 | 9 | 310 | 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 | |||
47321 | 198686 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 165 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008676.95515 | 2110436.09505 | 37.7753451785803 | -122.413459607989 | (37.7753451785803, -122.413459607989) | 8 | 2 | 9 | 28853 | 34 | |||
47528 | 198442 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015430.62355 | 2106285.94365 | 37.7643266659781 | -122.389806954341 | (37.7643266659781, -122.389806954341) | 14 | 3 | 9 | 310 | 29 | |||
47938 | 85786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009596.5259 | 2110188.4047 | 37.7747166682516 | -122.410261094209 | (37.7747166682516, -122.410261094209) | 8 | 2 | 9 | 28853 | 34 | ||
49804 | 198690 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 52 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008856.64566 | 2109825.7938 | 37.7736795226325 | -122.41279485791 | (37.7736795226325, -122.41279485791) | 8 | 2 | 9 | 28853 | 34 | |||
49834 | 85787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 4 | 3x3 | 6009621.8032 | 2110211.384 | 37.7747811809083 | -122.410175277249 | (37.7747811809083, -122.410175277249) | 8 | 2 | 9 | 28853 | 34 | ||
50791 | 85769 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008582.3574 | 2109309.4458 | 37.7722463531305 | -122.413707137147 | (37.7722463531305, -122.413707137147) | 8 | 2 | 9 | 28853 | 34 | ||
52055 | 85766 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2012 12:00:00 AM | 3 | 3x3 | 6008764.4124 | 2109484.6384 | 37.7727376126497 | -122.413089780599 | (37.7727376126497, -122.413089780599) | 8 | 2 | 9 | 28853 | 34 | ||
52805 | 198449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015277.30133 | 2106281.40363 | 37.7643056964809 | -122.390336940096 | (37.7643056964809, -122.390336940096) | 14 | 3 | 9 | 310 | 29 | |||
53253 | 198452 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015213.79848 | 2106277.63642 | 37.7642918298343 | -122.390556317147 | (37.7642918298343, -122.390556317147) | 14 | 3 | 9 | 310 | 29 | |||
54233 | 198676 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010397.30176 | 2111518.55677 | 37.7784138101995 | -122.407584837978 | (37.7784138101995, -122.407584837978) | 14 | 2 | 9 | 28853 | 34 | |||
54459 | 198563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014720.16797 | 2114187.47554 | 37.7859830827904 | -122.392817069764 | (37.7859830827904, -122.392817069764) | 6 | 2 | 9 | 28855 | 6 | |||
54713 | 91161 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007091.03056 | 2112582.20177 | 37.7811486961969 | -122.419097960601 | (37.7811486961969, -122.419097960601) | 7 | 9 | 9 | 28852 | 36 | |
56130 | 102719 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1681 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008087.4331 | 2108473.4904 | 37.7699232110184 | -122.41535993867 | (37.7699232110184, -122.41535993867) | 8 | 2 | 9 | 28853 | 19 | |||
56446 | 198623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015749.91564 | 2108621.24573 | 37.7707565982691 | -122.38886565105 | (37.7707565982691, -122.38886565105) | 14 | 3 | 9 | 310 | 20 | ||||
59292 | 242774 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 77 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006712.32772 | 2109620.22361 | 37.7729944847468 | -122.420197807195 | (37.7729944847468, -122.420197807195) | 8 | 2 | 9 | 28853 | 19 | |||
59407 | 198638 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015910.55807 | 2108750.53892 | 37.7711205116333 | -122.388319006239 | (37.7711205116333, -122.388319006239) | 14 | 3 | 9 | 310 | 20 | ||||
60183 | 198611 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6016143.32489 | 2108643.38282 | 37.7708391794209 | -122.387506373441 | (37.7708391794209, -122.387506373441) | 14 | 3 | 9 | 310 | 20 | ||||
60275 | 98855 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008612.62439 | 2110507.04759 | 37.7755363852191 | -122.413687163434 | (37.7755363852191, -122.413687163434) | 8 | 2 | 9 | 28853 | 34 | |||
60909 | 85783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1265 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009394.3077 | 2109993.0802 | 37.7741690156078 | -122.410946812123 | (37.7741690156078, -122.410946812123) | 8 | 2 | 9 | 28853 | 34 | ||
61371 | 198671 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 193 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010614.462 | 2111291.13573 | 37.7778015184645 | -122.406817563387 | (37.7778015184645, -122.406817563387) | 14 | 2 | 9 | 28853 | 34 | |||
61430 | 201186 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6013494.3037 | 2113910.8362 | 37.785155331286 | -122.397038852127 | (37.785155331286, -122.397038852127) | 6 | 2 | 9 | 28856 | 6 | |||
61963 | 198601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6016359.83761 | 2108655.37305 | 37.7708840915587 | -122.386758280474 | (37.7708840915587, -122.386758280474) | 14 | 3 | 9 | 310 | 20 | ||||
63920 | 32998 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.7846540898483 | -122.398013908317 | (37.7846540898483, -122.398013908317) | 6 | 2 | 9 | 28853 | 6 | |
64330 | 85794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1001 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010934.7813 | 2111463.5411 | 37.778292821216 | -122.405721608986 | (37.778292821216, -122.405721608986) | 14 | 2 | 9 | 28853 | 34 | ||
66944 | 198633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015806.09479 | 2108744.28476 | 37.7710975501444 | -122.388679914958 | (37.7710975501444, -122.388679914958) | 14 | 3 | 9 | 310 | 20 | ||||
67105 | 110634 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013451.1173 | 2113865.5933 | 37.7850287006154 | -122.397185091079 | (37.7850287006154, -122.397185091079) | 6 | 2 | 9 | 28856 | 6 | |||
67332 | 108237 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 |
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) );