trees
2,365 rows where qSpecies_id = 31 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |||
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 | |||
19935 | 242560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2331 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008202.94857 | 2104853.89142 | 37.7599911234086 | -122.414704179747 | (37.7599911234086, -122.414704179747) | 2 | 4 | 7 | 28859 | 19 | |||
20556 | 18546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Cutout | Tree | DPW 1 | 9 | 19 | 6014682.66084 | 2095048.92479 | 37.7334306737717 | -122.391608273909 | (37.7334306737717, -122.391608273909) | 10 | 3 | 8 | 58 | 1 | |||
23318 | 112503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 645 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5993489.26776 | 2113460.89025 | 37.7827859823771 | -122.46621678157 | (37.7827859823771, -122.46621678157) | 11 | 6 | 2 | 54 | 11 | |||
24025 | 242641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 262 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007759.04259 | 2106432.24164 | 37.764299956994 | -122.416351235928 | (37.764299956994, -122.416351235928) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
30064 | 242461 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 206 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006823.0502 | 2098332.30015 | 37.7420066942676 | -122.419014023301 | (37.7420066942676, -122.419014023301) | 2 | 7 | 7 | 28859 | 2 | |||
31708 | 198480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015199.5579 | 2104656.07032 | 37.7598385696177 | -122.390492258425 | (37.7598385696177, -122.390492258425) | 10 | 3 | 8 | 28856 | 29 | |||
37362 | 242429 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005025.33066 | 2109905.44475 | 37.7736824328302 | -122.426053649163 | (37.7736824328302, -122.426053649163) | 7 | 9 | 11 | 28852 | 10 | |||
38442 | 198473 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015189.15616 | 2104818.6313 | 37.7602843500682 | -122.39053959244 | (37.7602843500682, -122.39053959244) | 10 | 3 | 8 | 28856 | 29 | |||
42444 | 141884 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1385 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003856.0664 | 2112823.5735 | 37.7816287390929 | -122.43030655003 | (37.7816287390929, -122.43030655003) | 7 | 9 | 11 | 29490 | 41 | |||
42463 | 30575 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 262 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 9 | Permit Number 43817 | 6004015.93268 | 2108728.78356 | 37.7703945078227 | -122.429461383638 | (37.7703945078227, -122.429461383638) | 7 | 9 | 11 | 29492 | 10 | |
43824 | 246542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126 | (37.772505687922, -122.42377321126) | 7 | 9 | 11 | 28852 | 10 | |||
48210 | 242420 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 287 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005472.13068 | 2102064.63416 | 37.7521786642319 | -122.423950423591 | (37.7521786642319, -122.423950423591) | 2 | 4 | 5 | 28859 | 19 | |||
48921 | 36885 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2914 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39542 | 6000200.34388 | 2116470.40485 | 37.79143424424 | -122.443215577236 | (37.79143424424, -122.443215577236) | 13 | 6 | 1 | 29490 | 27 | |
54139 | 47103 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3173 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2002 12:00:00 AM | 9 | Permit Number 45084 | 5995821.54315 | 2111362.39485 | 37.7771583581843 | -122.457996229218 | (37.7771583581843, -122.457996229218) | 11 | 6 | 2 | 54 | 16 | ||
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 | |||
56016 | 51434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 277 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.7246369688192 | -122.433701359735 | (37.7246369688192, -122.433701359735) | 9 | 7 | 6 | 28861 | 5 | ||
61325 | 244354 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005594.4313 | 2110381.2151 | 37.7750209309426 | -122.424118881689 | (37.7750209309426, -122.424118881689) | 7 | 9 | 11 | 28852 | 10 | |||
65181 | 26273 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 9 | 3X3 | 6006790.88974 | 2098369.36034 | 37.742106642199 | -122.419127852295 | (37.742106642199, -122.419127852295) | 2 | 7 | 7 | 28859 | 2 | ||
69780 | 198573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014828.40077 | 2114123.03475 | 37.7858121540501 | -122.392438101754 | (37.7858121540501, -122.392438101754) | 6 | 2 | 9 | 28855 | 6 | |||
73412 | 215570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 96 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995600.39767 | 2096198.59734 | 37.7355097165874 | -122.457663772269 | (37.7355097165874, -122.457663772269) | 9 | 7 | 4 | 59 | 40 | |||
76275 | 198486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015201.9775 | 2104548.15133 | 37.7595423814855 | -122.390476349396 | (37.7595423814855, -122.390476349396) | 10 | 3 | 8 | 28856 | 29 | |||
79512 | 198570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014790.57868 | 2114116.0189 | 37.7857907897446 | -122.392568465686 | (37.7857907897446, -122.392568465686) | 6 | 2 | 9 | 28855 | 6 | |||
81842 | 242718 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 789 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002464.12594 | 2103621.85174 | 37.75628413232 | -122.434463883201 | (37.75628413232, -122.434463883201) | 2 | 4 | 5 | 28862 | 3 | |||
89717 | 112625 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1811 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008061 | 2107870 | 37.7682646820652 | -122.415408640275 | (37.7682646820652, -122.415408640275) | 8 | 4 | 7 | 28853 | 19 | |||
90967 | 33602 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 200X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | 9 | Permit Number 37716 | 6006727.64769195 | 2098397.31693347 | 37.7421798430719 | -122.419348506645 | (37.7421798430719, -122.419348506645) | 2 | 7 | 7 | 28859 | 2 | ||
96038 | 198683 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009066.22564 | 2110952.30823 | 37.7767844274995 | -122.412149517004 | (37.7767844274995, -122.412149517004) | 8 | 2 | 9 | 28853 | 34 | |||
97198 | 201906 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6013735.56827 | 2093268.69044 | 37.7284898973927 | -122.394758034254 | (37.7284898973927, -122.394758034254) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
100295 | 198472 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015328.96766 | 2105817.04022 | 37.7630335209151 | -122.390125796375 | (37.7630335209151, -122.390125796375) | 14 | 3 | 8 | 28856 | 29 | |||
102071 | 242390 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1752 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005758.82416 | 2107281.5797 | 37.7665193561146 | -122.42332981762 | (37.7665193561146, -122.42332981762) | 8 | 4 | 5 | 28853 | 19 | |||
102252 | 242553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2485 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008250.91524 | 2103984.58868 | 37.7576069118515 | -122.414476772712 | (37.7576069118515, -122.414476772712) | 2 | 4 | 7 | 28859 | 19 | |||
103111 | 46632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.7285785323655 | -122.389527911332 | (37.7285785323655, -122.389527911332) | 10 | 3 | 8 | 58 | 1 |
104116 | 137054 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 218 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6011688.33574 | 2119796.92138 | 37.8012164174502 | -122.403701277593 | (37.8012164174502, -122.403701277593) | 3 | 1 | 10 | 308 | 23 | |||
114660 | 200622 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016290.9677 | 2094932.3213 | 37.7331996459116 | -122.386039726783 | (37.7331996459116, -122.386039726783) | 10 | 3 | 8 | 58 | 1 | |||
114714 | 242384 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1716 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005916.49708 | 2107289.32235 | 37.7665495130686 | -122.422785004724 | (37.7665495130686, -122.422785004724) | 8 | 4 | 5 | 28853 | 19 | |||
115763 | 136983 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 404 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998629.55132 | 2115189.80864 | 37.7878283720209 | -122.448558198621 | (37.7878283720209, -122.448558198621) | 13 | 6 | 1 | 54 | 31 | |||
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 | |||
120365 | 136962 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2460 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001208.87225 | 2118332.01325 | 37.7966031903358 | -122.439859628443 | (37.7966031903358, -122.439859628443) | 13 | 9 | 1 | 57 | 17 | |||
120435 | 198647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6016245.34642 | 2108770.39329 | 37.7711935725654 | -122.387162335966 | (37.7711935725654, -122.387162335966) | 14 | 3 | 9 | 310 | 20 | ||||
121496 | 53398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1972 12:00:00 AM | 9 | Permit Number 9833 | 6008515.21769 | 2116802.84208 | 37.7928176497632 | -122.414469707612 | (37.7928176497632, -122.414469707612) | 5 | 1 | 10 | 28858 | 21 | ||
122746 | 242648 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008826.30295 | 2102756.85325 | 37.7542681355744 | -122.412400061838 | (37.7542681355744, -122.412400061838) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
132547 | 242604 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 5999041.21728 | 2105197.03695 | 37.7604143056979 | -122.446414751759 | (37.7604143056979, -122.446414751759) | 15 | 5 | 5 | 28862 | 12 | |||
140908 | 180569 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007329.33398 | 2093756.28906 | 37.729470469574 | -122.416939308919 | (37.729470469574, -122.416939308919) | 9 | 3 | 7 | 309 | 28 | |||
150176 | 123694 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 7 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995476.23138 | 2113538.07017 | 37.7831123374099 | -122.459348361697 | (37.7831123374099, -122.459348361697) | 11 | 6 | 2 | 54 | 11 | |||
157466 | 242377 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005394.26539 | 2103459.55666 | 37.7560044008961 | -122.424318897403 | (37.7560044008961, -122.424318897403) | 2 | 4 | 5 | 28859 | 19 | |||
163797 | 198485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015200.26669 | 2104562.53753 | 37.7595817879946 | -122.3904832715 | (37.7595817879946, -122.3904832715) | 10 | 3 | 8 | 28856 | 29 | |||
169213 | 137026 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2257 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003079.39439 | 2117445.17436 | 37.7942744570554 | -122.433323809051 | (37.7942744570554, -122.433323809051) | 13 | 9 | 1 | 29490 | 27 | |||
173249 | 242434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004879.95955 | 2109886.96936 | 37.773623486774 | -122.426555194781 | (37.773623486774, -122.426555194781) | 7 | 9 | 11 | 28852 | 10 | |||
173533 | 242467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3023 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008424.30032 | 2100880.90797 | 37.7490946442994 | -122.413657615312 | (37.7490946442994, -122.413657615312) | 2 | 4 | 7 | 28859 | 19 | |||
176412 | 137024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003051.10397 | 2117478.36483 | 37.7943639845568 | -122.433424069968 | (37.7943639845568, -122.433424069968) | 13 | 9 | 1 | 29490 | 27 | |||
177161 | 112747 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1262 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008734.43896 | 2116668.83333 | 37.7924620074572 | -122.413701706384 | (37.7924620074572, -122.413701706384) | 5 | 1 | 10 | 28857 | 21 | |||
178532 | 200623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016334.2945 | 2094904.0647 | 37.7331244567265 | -122.385887963991 | (37.7331244567265, -122.385887963991) | 10 | 3 | 8 | 58 | 1 | |||
181351 | 137048 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008515.8047 | 2116792.05002 | 37.7927880503911 | -122.414466912531 | (37.7927880503911, -122.414466912531) | 5 | 1 | 10 | 28858 | 21 | |||
182968 | 198502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900x Carolina St | 14 | Median : Yard | Tree | DPW 1 | 9 | 6012462.6007 | 2103568.62023 | 37.7567004590693 | -122.399881750743 | (37.7567004590693, -122.399881750743) | 10 | 3 | 8 | 28856 | 29 | ||||
189621 | 198539 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1774 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6014319.22336 | 2096405.90013 | 37.7371364696747 | -122.392959697748 | (37.7371364696747, -122.392959697748) | 10 | 3 | 8 | 58 | 1 | |||
191103 | 198481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015200.5956 | 2104639.69489 | 37.7597936637724 | -122.390487525273 | (37.7597936637724, -122.390487525273) | 10 | 3 | 8 | 28856 | 29 | |||
192245 | 242392 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1758 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005722.91625 | 2107278.54234 | 37.7665089896121 | -122.423453800862 | (37.7665089896121, -122.423453800862) | 8 | 4 | 5 | 28853 | 19 | |||
62831 | 25173 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3062 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6000161.42067 | 2105438.61683 | 37.7611415415605 | -122.44255784368 | (37.7611415415605, -122.44255784368) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
16481 | 242572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2075 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008125.16647 | 2106366.43702 | 37.7641398542804 | -122.415080254657 | (37.7641398542804, -122.415080254657) | 8 | 4 | 7 | 28859 | 19 | |||
16688 | 137060 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 462 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011807.58318 | 2118407.27 | 37.7974074315733 | -122.403190818824 | (37.7974074315733, -122.403190818824) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||
18889 | 242437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 155 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004941.65866 | 2098698.95529 | 37.7429073221216 | -122.425545367634 | (37.7429073221216, -122.425545367634) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
25402 | 242705 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 622 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002352.40846 | 2104549.28931 | 37.7588243106064 | -122.434916564156 | (37.7588243106064, -122.434916564156) | 2 | 4 | 5 | 28862 | 3 | |||
25694 | 242395 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1772 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005651.81735 | 2107273.82605 | 37.7664920266105 | -122.423699384137 | (37.7664920266105, -122.423699384137) | 8 | 4 | 5 | 28853 | 19 | |||
26952 | 137023 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003036.9655 | 2117481.25366 | 37.7943711144001 | -122.433473197238 | (37.7943711144001, -122.433473197238) | 13 | 9 | 1 | 29490 | 27 | |||
27123 | 242567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2121 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008134.5513 | 2106113.05528 | 37.7634446540583 | -122.415029859359 | (37.7634446540583, -122.415029859359) | 8 | 4 | 7 | 28859 | 19 | |||
28789 | 31076 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6006020.69113 | 2107294.38947 | 37.7665693044606 | -122.422424975532 | (37.7665693044606, -122.422424975532) | 8 | 4 | 5 | 28853 | 19 | |
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 | ||||
38292 | 200627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1360 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016371.342 | 2094881.4594 | 37.7330644372172 | -122.385758304658 | (37.7330644372172, -122.385758304658) | 10 | 3 | 8 | 58 | 1 | |||
41088 | 198525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014663.37225 | 2096146.01075 | 37.736441977204 | -122.391751642923 | (37.736441977204, -122.391751642923) | 10 | 3 | 8 | 58 | 1 | |||
41378 | 198530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1748 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014455.10696 | 2096302.51395 | 37.7368601394856 | -122.392482653249 | (37.7368601394856, -122.392482653249) | 10 | 3 | 8 | 58 | 1 | |||
43128 | 51255 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2485 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | 8 | Permit Number 49056 | 6001759.16032 | 2117307.51172 | 37.7938214847188 | -122.437882095676 | (37.7938214847188, -122.437882095676) | 13 | 9 | 1 | 29490 | 27 | ||
44282 | 55984 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1260 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1974 12:00:00 AM | 8 | Permit Number 12058 | 6008765.405 | 2116672.96891 | 37.7924751016038 | -122.41359485524 | (37.7924751016038, -122.41359485524) | 5 | 1 | 10 | 28857 | 21 | ||
46130 | 138170 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1800 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004432.7848 | 2115052.4725 | 37.7877813890787 | -122.428470296738 | (37.7877813890787, -122.428470296738) | 13 | 9 | 11 | 28858 | 27 | |||
50705 | 246545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | 7 | 9 | 11 | 28852 | 10 | |||
51760 | 242407 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3711 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005550.66093 | 2104286.71463 | 37.7582844134195 | -122.423836842808 | (37.7582844134195, -122.423836842808) | 2 | 4 | 5 | 28859 | 19 | |||
52070 | 198464 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015333.10926 | 2105765.07508 | 37.7628910655837 | -122.390107841403 | (37.7628910655837, -122.390107841403) | 14 | 3 | 8 | 28856 | 29 | |||
52678 | 242476 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2843 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008369.73896 | 2101880.11255 | 37.7518351717608 | -122.413916963601 | (37.7518351717608, -122.413916963601) | 2 | 4 | 7 | 28859 | 19 | |||
52684 | 30285 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1355 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1956 12:00:00 AM | 8 | Permit Number 132 | 6008895.30173 | 2117592.00623 | 37.7950058459972 | -122.413210424719 | (37.7950058459972, -122.413210424719) | 5 | 1 | 10 | 28857 | 21 | ||
52788 | 242566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2131 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008142.36427 | 2105996.45678 | 37.7631249405782 | -122.414994583457 | (37.7631249405782, -122.414994583457) | 8 | 4 | 7 | 28859 | 19 | |||
58392 | 215480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 55 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992620.87783 | 2096424.47164 | 37.7359583002413 | -122.467981434219 | (37.7359583002413, -122.467981434219) | 1 | 8 | 4 | 59 | 40 | |||
58932 | 31077 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6005999.97732 | 2107292.75552 | 37.7665636495047 | -122.422496504935 | (37.7665636495047, -122.422496504935) | 8 | 4 | 5 | 28853 | 19 | |
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 | ||||
61116 | 242528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1942 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008018.69066 | 2107110.79119 | 37.7661776937697 | -122.415501227304 | (37.7661776937697, -122.415501227304) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
62811 | 242570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2075 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008127.10713 | 2106318.8789 | 37.7640093797557 | -122.415070175952 | (37.7640093797557, -122.415070175952) | 8 | 4 | 7 | 28859 | 19 |
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) );