trees
286 rows where qSpecies_id = 74 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
210 | 1023 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1925 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000937.4135 | 2090832.4174 | 37.7210805620079 | -122.438827310136 | (37.7210805620079, -122.438827310136) | 9 | 7 | 6 | 28861 | 25 | |||
8134 | 1169 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5996958.76452 | 2087574.18326 | 37.7119070481533 | -122.452345269826 | (37.7119070481533, -122.452345269826) | 9 | 7 | 6 | 28861 | 25 | |||
11616 | 21036 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
11663 | 242360 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 388 Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | Width 3ft | 6006031.24378 | 2097876.97394 | 37.7407118512751 | -122.421719507764 | (37.7407118512751, -122.421719507764) | 2 | 7 | 7 | 28859 | 2 | |||
14006 | 19096 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 265 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5994373.4122 | 2087391.66656 | 37.7112574471572 | -122.46126768668 | (37.7112574471572, -122.46126768668) | 9 | 8 | 6 | 28861 | 24 | |||
17513 | 1171 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5996917.80808 | 2087537.65552 | 37.7118044049283 | -122.452484191688 | (37.7118044049283, -122.452484191688) | 9 | 7 | 6 | 28861 | 25 | |||
21378 | 259 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3100 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X3 | 5990639.72639 | 2094599.99663 | 37.7308341475716 | -122.474697876125 | (37.7308341475716, -122.474697876125) | 9 | 8 | 4 | 64 | 40 | |||
34902 | 1084 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2155 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000026.48644 | 2089733.60344 | 37.7180116012293 | -122.441897283559 | (37.7180116012293, -122.441897283559) | 9 | 7 | 6 | 28861 | 25 | |||
36726 | 19098 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 277 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994301.47387 | 2087394.14332 | 37.7112601073303 | -122.461516501212 | (37.7112601073303, -122.461516501212) | 9 | 8 | 6 | 28861 | 24 | |||
42656 | 1176 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6x7 | 5996790.08186 | 2087431.57248 | 37.7115058066164 | -122.452917994084 | (37.7115058066164, -122.452917994084) | 9 | 7 | 6 | 28861 | 25 | |||
42845 | 19076 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 212 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5994913.18282 | 2087466.94262 | 37.711495187435 | -122.459407564904 | (37.711495187435, -122.459407564904) | 9 | 8 | 6 | 28861 | 24 | |||
42941 | 247 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3040 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990628.1224 | 2094940.11862 | 37.7317673641661 | -122.474762808054 | (37.7317673641661, -122.474762808054) | 1 | 8 | 4 | 64 | 40 | |||
53558 | 19092 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 253 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994541.9924055 | 2087407.5063683 | 37.7113106401579 | -122.46068618252 | (37.7113106401579, -122.46068618252) | 9 | 8 | 6 | 28861 | 24 | |||
53932 | 23637 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 116 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1998 12:00:00 AM | 10 | 3X3 | 6006587.56141 | 2098481.46204 | 37.7424029958148 | -122.419838851803 | (37.7424029958148, -122.419838851803) | 2 | 7 | 7 | 28859 | 2 | ||
57205 | 1207 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3141 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 5995985.58699 | 2086962.17792 | 37.710170822386 | -122.455664615342 | (37.710170822386, -122.455664615342) | 9 | 7 | 6 | 28861 | 25 | |||
60075 | 408 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3830 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2x3 | 5990724.80287 | 2090303.65489 | 37.7190423951686 | -122.474090399377 | (37.7190423951686, -122.474090399377) | 9 | 8 | 4 | 64 | 40 | |||
62832 | 119698 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
63663 | 21035 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
65958 | 1307 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4001 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X6 | 5991965.2566 | 2087108.33774 | 37.7103406072022 | -122.46957018822 | (37.7103406072022, -122.46957018822) | 9 | 8 | 4 | 64 | 24 | |||
71098 | 1020 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1871 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6001188.68996 | 2091314.66638 | 37.7224190014148 | -122.437993248302 | (37.7224190014148, -122.437993248302) | 9 | 7 | 6 | 28861 | 25 | |||
74552 | 19089 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 245 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994528.08002 | 2087391.0087 | 37.7112645409908 | -122.460733072089 | (37.7112645409908, -122.460733072089) | 9 | 8 | 6 | 28861 | 24 | |||
77772 | 1174 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5996843.31726 | 2087475.01833 | 37.7116281495005 | -122.452737133232 | (37.7116281495005, -122.452737133232) | 9 | 7 | 6 | 28861 | 25 | |||
79202 | 1022 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1909 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6000975.40411 | 2090904.61398 | 37.7212809588173 | -122.438701158651 | (37.7212809588173, -122.438701158651) | 9 | 7 | 6 | 28861 | 25 | |||
82287 | 1077 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2125 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6000118.83057 | 2089820.59476 | 37.7182557213131 | -122.44158433025 | (37.7182557213131, -122.44158433025) | 9 | 7 | 6 | 28861 | 25 | |||
87045 | 1018 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1867 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6001202.49586 | 2091340.5101 | 37.7224907475345 | -122.437947374798 | (37.7224907475345, -122.437947374798) | 9 | 7 | 6 | 28861 | 25 | |||
92095 | 17221 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1875X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6001098.52222 | 2091140.53503 | 37.7219357480204 | -122.438292468038 | (37.7219357480204, -122.438292468038) | 9 | 7 | 6 | 28861 | 25 | |||
94899 | 407 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3826 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 2X3 | 5990704.40844 | 2090329.91237 | 37.7191133102994 | -122.47416280918 | (37.7191133102994, -122.47416280918) | 9 | 8 | 4 | 64 | 40 | |||
97722 | 1082 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2149 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6000045.94187 | 2089750.00425 | 37.7180577427488 | -122.44183121126 | (37.7180577427488, -122.44183121126) | 9 | 7 | 6 | 28861 | 25 | |||
98169 | 1012 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1845 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6001257.97709 | 2091441.77631 | 37.7227719565453 | -122.437762838379 | (37.7227719565453, -122.437762838379) | 9 | 7 | 6 | 28861 | 25 | |||
104999 | 405 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3818 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X5 | 5990665.10533 | 2090381.89852 | 37.719253774519 | -122.474302455007 | (37.719253774519, -122.474302455007) | 9 | 8 | 4 | 64 | 40 | |||
109261 | 19049 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 129 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995630.2780118 | 2087392.9172085 | 37.7113331356468 | -122.456923761037 | (37.7113331356468, -122.456923761037) | 9 | 8 | 6 | 28861 | 24 | |||
113494 | 29962 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991375.88875 | 2094170.02081 | 37.729696171533 | -122.472121539675 | (37.729696171533, -122.472121539675) | 9 | 8 | 4 | 64 | 40 | ||
115165 | 19054 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 147 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5995468.13357 | 2087379.87793 | 37.7112880204961 | -122.457483227074 | (37.7112880204961, -122.457483227074) | 9 | 8 | 6 | 28861 | 24 | |||
116989 | 1313 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4055 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 4X6 | 5991770.79861 | 2086968.57426 | 37.7099456096734 | -122.470232098246 | (37.7099456096734, -122.470232098246) | 9 | 8 | 4 | 64 | 24 | |||
119775 | 233 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2980 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X4 | 5990616.42168 | 2095336.99138 | 37.7328563982031 | -122.474832216845 | (37.7328563982031, -122.474832216845) | 1 | 8 | 4 | 64 | 40 | |||
121628 | 1070 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3X3 | 6000193.5332 | 2089890.50062 | 37.7184519227936 | -122.441331128839 | (37.7184519227936, -122.441331128839) | 9 | 7 | 6 | 28861 | 25 | |||
122136 | 1192 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3047 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 1X2 | 5996542.59797 | 2087158.26518 | 37.710741182331 | -122.453753635137 | (37.710741182331, -122.453753635137) | 9 | 7 | 6 | 28861 | 25 | |||
122629 | 390 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3790X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2 | 5990465.39673 | 2090774.00996 | 37.7203188434295 | -122.475021373044 | (37.7203188434295, -122.475021373044) | 9 | 8 | 4 | 64 | 40 | |||
129619 | 17220 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1875X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6001085.65168 | 2091116.17371 | 37.7218681252969 | -122.438335213721 | (37.7218681252969, -122.438335213721) | 9 | 7 | 6 | 28861 | 25 | |||
131091 | 25430 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2118 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1997 12:00:00 AM | 6 | 3X3 | 6011929.29613 | 2087786.5725 | 37.7133365214367 | -122.400617498717 | (37.7133365214367, -122.400617498717) | 10 | 7 | 8 | 309 | 39 | ||
146696 | 21045 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
149356 | 403 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3810 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5990630.76678 | 2090432.7869 | 37.7193915120005 | -122.474424860828 | (37.7193915120005, -122.474424860828) | 9 | 8 | 4 | 64 | 40 | |||
155297 | 242361 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 388 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | Width 3ft | 6006038.37778 | 2097891.21022 | 37.7407513431918 | -122.421695851975 | (37.7407513431918, -122.421695851975) | 2 | 7 | 7 | 28859 | 2 | |||
156960 | 1829 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2155 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6011803.61651 | 2087487.56349 | 37.7125084922469 | -122.401030897272 | (37.7125084922469, -122.401030897272) | 10 | 3 | 8 | 309 | 1 | |||
159778 | 17219 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1875X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6001071.69008 | 2091082.82466 | 37.7217757622246 | -122.438381087239 | (37.7217757622246, -122.438381087239) | 9 | 7 | 6 | 28861 | 25 | |||
161011 | 1132 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2565 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 5998605.29781 | 2088582.84713 | 37.7147708016152 | -122.446726940623 | (37.7147708016152, -122.446726940623) | 9 | 7 | 6 | 28861 | 25 | |||
164594 | 410 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3840 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X6 | 5990764.11669 | 2090252.16515 | 37.7189032943325 | -122.473950753525 | (37.7189032943325, -122.473950753525) | 9 | 8 | 4 | 64 | 40 | |||
168524 | 1209 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3147 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 5995880.33209 | 2086940.05264 | 37.7101040306546 | -122.456026796619 | (37.7101040306546, -122.456026796619) | 9 | 7 | 6 | 28861 | 25 | |||
173118 | 258 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3100 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X3 | 5990642.03803 | 2094556.09253 | 37.7307137319489 | -122.474686681352 | (37.7307137319489, -122.474686681352) | 9 | 8 | 4 | 64 | 40 | |||
176249 | 1067 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2087X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000311.61814 | 2090004.87585 | 37.7187726974675 | -122.440931159865 | (37.7187726974675, -122.440931159865) | 9 | 7 | 6 | 28861 | 25 | |||
178351 | 19048 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 129 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5995630.2780118 | 2087392.9172085 | 37.7113331356468 | -122.456923761037 | (37.7113331356468, -122.456923761037) | 9 | 8 | 6 | 28861 | 24 | |||
181461 | 404 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3814 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X4 | 5990648.68908 | 2090407.57525 | 37.7193233254004 | -122.474361071922 | (37.7193233254004, -122.474361071922) | 9 | 8 | 4 | 64 | 40 | |||
188650 | 219533 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3794 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5 | Width 8ft | 5990481.81422 | 2090701.15077 | 37.7201197416248 | -122.474959308131 | (37.7201197416248, -122.474959308131) | 9 | 8 | 4 | 64 | 40 | |||
191275 | 411 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3850 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 15 | 2 | 5990800.34516 | 2090196.27007 | 37.7187519186484 | -122.473821451697 | (37.7187519186484, -122.473821451697) | 9 | 8 | 4 | 64 | 40 | ||
192840 | 1814 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2090 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1997 12:00:00 AM | 6 | 3X3 | 6012058.52275 | 2087947.72362 | 37.713786216629 | -122.400182154876 | (37.713786216629, -122.400182154876) | 10 | 7 | 8 | 309 | 39 | ||
826 | 249957 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 283 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 31 | Width 0ft | 6011535.00763 | 2120075.1046 | 37.8019716744259 | -122.404251453143 | (37.8019716744259, -122.404251453143) | 3 | 1 | 10 | 308 | 23 | |||
3254 | 242351 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 387 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005504.19236 | 2101491.23714 | 37.7506060584433 | -122.423798781707 | (37.7506060584433, -122.423798781707) | 2 | 4 | 5 | 28859 | 19 | |||
4588 | 219476 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 20 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992566.29417 | 2096756.25819 | 37.7368661505438 | -122.468194278545 | (37.7368661505438, -122.468194278545) | 1 | 8 | 4 | 59 | 40 | |||
4684 | 219541 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5991386.1412 | 2094492.53294 | 37.7305823023089 | -122.472109594875 | (37.7305823023089, -122.472109594875) | 9 | 8 | 4 | 64 | 40 | |||
7578 | 136957 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2411 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002488.64673 | 2117068.27748 | 37.7932060642605 | -122.435340887694 | (37.7932060642605, -122.435340887694) | 13 | 9 | 1 | 29490 | 27 | |||
9533 | 219459 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 125 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992643.39064 | 2095794.64887 | 37.7342302645957 | -122.467857804419 | (37.7342302645957, -122.467857804419) | 9 | 8 | 4 | 59 | 40 | |||
9797 | 219544 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 28 | : | Tree | Private 2 | 19 | Width 0ft | 5991391.01152 | 2094448.55765 | 37.7304618390337 | -122.472089553508 | (37.7304618390337, -122.472089553508) | 9 | 8 | 4 | 64 | 40 | |||
12368 | 180506 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1985 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 2ft | 6000867.32742 | 2090696.01152 | 37.7207020346632 | -122.439059805593 | (37.7207020346632, -122.439059805593) | 9 | 7 | 6 | 28861 | 25 | |||
13068 | 1286 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3928 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 6x5 | 5992480.71384 | 2087450.61333 | 37.7113101914743 | -122.467813554168 | (37.7113101914743, -122.467813554168) | 9 | 8 | 4 | 64 | 24 | |||
15962 | 117054 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3570 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778339 | 5997182.58708 | 2116049.71281 | 37.7901065984817 | -122.453626513253 | (37.7901065984817, -122.453626513253) | 11 | 6 | 1 | 54 | 31 | |
18429 | 219466 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 157 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992652.07452 | 2095558.46871 | 37.7335822742946 | -122.46781060978 | (37.7335822742946, -122.46781060978) | 9 | 8 | 4 | 59 | 40 | |||
20327 | 109501 | Private 9 | Ulmus americana :: American Elm 74 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard | Tree | Private 2 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.8021053817179 | -122.404424889694 | (37.8021053817179, -122.404424889694) | 3 | 1 | 10 | 308 | 23 | ||||
20422 | 219563 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 468 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993412.01695 | 2099476.55803 | 37.7443842184582 | -122.465467821877 | (37.7443842184582, -122.465467821877) | 1 | 8 | 4 | 29491 | 40 | |||
20815 | 242367 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 233 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004197.65677 | 2108704.77066 | 37.7703388613782 | -122.428831087511 | (37.7703388613782, -122.428831087511) | 7 | 9 | 5 | 29492 | 10 | |||
21091 | 242363 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4530 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000946.15042 | 2104663.40742 | 37.7590577062546 | -122.439788225849 | (37.7590577062546, -122.439788225849) | 2 | 4 | 5 | 28862 | 3 | |||
22199 | 219513 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 35 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992615.42573 | 2096597.10847 | 37.7364320028189 | -122.468012837633 | (37.7364320028189, -122.468012837633) | 1 | 8 | 4 | 59 | 40 | |||
22369 | 242359 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 537 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007481.39138 | 2096395.00518 | 37.7367243607425 | -122.41660047944 | (37.7367243607425, -122.41660047944) | 2 | 7 | 7 | 28859 | 2 | |||
23200 | 219510 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 45 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992616.53817 | 2096522.0464 | 37.7362259654513 | -122.468003533256 | (37.7362259654513, -122.468003533256) | 1 | 8 | 4 | 59 | 40 | |||
24193 | 180501 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2019 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6000600.83666 | 2090287.11698 | 37.7195641359612 | -122.439951675834 | (37.7195641359612, -122.439951675834) | 9 | 7 | 6 | 28861 | 25 | |||
24542 | 248413 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 715 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997910.6761 | 2108085.9087 | 37.7682817800738 | -122.450533022459 | (37.7682817800738, -122.450533022459) | 15 | 5 | 11 | 29492 | 9 | |||
26625 | 219522 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 5 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992593.39724 | 2096877.28948 | 37.7372000373399 | -122.468109373561 | (37.7372000373399, -122.468109373561) | 1 | 8 | 4 | 59 | 40 | |||
27031 | 219479 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 40 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992572.27413 | 2096608.73557 | 37.7364614358501 | -122.468162875133 | (37.7364614358501, -122.468162875133) | 1 | 8 | 4 | 59 | 40 | |||
27443 | 219472 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992548.15428 | 2096853.45183 | 37.7371319721693 | -122.468264064141 | (37.7371319721693, -122.468264064141) | 1 | 8 | 4 | 59 | 40 | |||
27520 | 219490 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 72 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 5992585.45067 | 2096291.55338 | 37.735591294102 | -122.468094253274 | (37.735591294102, -122.468094253274) | 1 | 8 | 4 | 59 | 40 | |||
27534 | 180487 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2079 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000343.28213 | 2090036.11194 | 37.7188602680644 | -122.440823949885 | (37.7188602680644, -122.440823949885) | 9 | 7 | 6 | 28861 | 25 | |||
28936 | 219534 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3780 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990464.73851 | 2090861.23093 | 37.7205582924235 | -122.47503001192 | (37.7205582924235, -122.47503001192) | 9 | 8 | 4 | 64 | 40 | |||
29168 | 242362 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1060 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003143.14835 | 2102033.69016 | 37.7519619384111 | -122.432002187867 | (37.7519619384111, -122.432002187867) | 2 | 4 | 5 | 28862 | 22 | |||
29740 | 219527 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3802 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5990536.22283 | 2090561.43245 | 37.7197392627356 | -122.474761045407 | (37.7197392627356, -122.474761045407) | 9 | 8 | 4 | 64 | 40 | |||
31024 | 219567 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 440 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 5993560.04517 | 2099487.34762 | 37.7444223802853 | -122.464956758761 | (37.7444223802853, -122.464956758761) | 1 | 8 | 4 | 29491 | 40 | |||
32585 | 1312 | Permitted Site 7 | Ulmus americana :: American Elm 74 | 4043 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x5 | 5991834.02635 | 2087022.6898 | 37.7100978532157 | -122.470017510902 | (37.7100978532157, -122.470017510902) | 9 | 8 | 4 | 64 | 24 | |||
32705 | 25438 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2445 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2000 12:00:00 AM | 3 | 3X3 | 6010976.31597 | 2086829.29062 | 37.7106548222305 | -122.403844026987 | (37.7106548222305, -122.403844026987) | 10 | 3 | 8 | 309 | 1 | ||
33294 | 215457 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 170 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992608.79004 | 2095578.76173 | 37.7336354943765 | -122.467961730965 | (37.7336354943765, -122.467961730965) | 9 | 8 | 4 | 59 | 40 | |||
33968 | 219556 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 500 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993176.35113 | 2099457.21579 | 37.7443175148487 | -122.466281292872 | (37.7443175148487, -122.466281292872) | 1 | 8 | 4 | 29491 | 40 | |||
34330 | 219494 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 90 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992589.58933 | 2096152.44191 | 37.7352095678711 | -122.468069828571 | (37.7352095678711, -122.468069828571) | 1 | 8 | 4 | 59 | 40 | |||
34866 | 242356 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 205 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006761.93151 | 2098429.31569 | 37.7422696353456 | -122.419232232979 | (37.7422696353456, -122.419232232979) | 2 | 7 | 7 | 28859 | 2 | |||
36845 | 219549 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 598 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992707.78967 | 2099421.22358 | 37.7441916430378 | -122.467898847667 | (37.7441916430378, -122.467898847667) | 1 | 8 | 4 | 29491 | 40 | |||
37423 | 219564 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 460 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993432.10903 | 2099478.98685 | 37.7443920461633 | -122.465398524625 | (37.7443920461633, -122.465398524625) | 1 | 8 | 4 | 29491 | 40 | |||
37886 | 219475 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 20 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992563.48801 | 2096782.78152 | 37.7369388148738 | -122.468205909482 | (37.7369388148738, -122.468205909482) | 1 | 8 | 4 | 59 | 40 | |||
38855 | 139051 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2669 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5999827.1373 | 2113991.9623 | 37.7846078002996 | -122.444328673472 | (37.7846078002996, -122.444328673472) | 15 | 6 | 11 | 29490 | 31 | |||
38865 | 180510 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4035 Alemany Blvd | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5991869.02362 | 2087044.73214 | 37.7101603992515 | -122.469898158374 | (37.7101603992515, -122.469898158374) | 9 | 8 | 4 | 64 | 24 | |||
39345 | 180496 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2067 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000450.00528 | 2090141.8929 | 37.7191567961292 | -122.440462633746 | (37.7191567961292, -122.440462633746) | 9 | 7 | 6 | 28861 | 25 | |||
40046 | 215471 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 50 Sola Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 5994846.246 | 2100781.0539 | 37.7480486509235 | -122.460603103871 | (37.7480486509235, -122.460603103871) | 1 | 8 | 4 | 29491 | 40 | |||
40894 | 1173 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 5996863.34156 | 2087489.7045 | 37.7116696217356 | -122.452668983506 | (37.7116696217356, -122.452668983506) | 9 | 7 | 6 | 28861 | 25 | |||
40895 | 215456 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 170 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992607.47204 | 2095602.74615 | 37.7337012734937 | -122.467968031596 | (37.7337012734937, -122.467968031596) | 9 | 8 | 4 | 59 | 40 | |||
40986 | 180508 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2500 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010763.65816 | 2086463.16447 | 37.7096376305352 | -122.404553267433 | (37.7096376305352, -122.404553267433) | 10 | 3 | 8 | 309 | 1 |
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) );