trees
286 rows where qSpecies_id = 74 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||||||||
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 | |||
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 | |||
64238 | 215469 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 160 Magellan Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 4ft | 5995028.58035 | 2100711.10786 | 37.7478670849985 | -122.459967536785 | (37.7478670849985, -122.459967536785) | 1 | 8 | 4 | 29491 | 40 | |||
136346 | 25439 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2401 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/1997 12:00:00 AM | 3 | 3x3 | 6011150.97537 | 2087110.40453 | 37.7114364608051 | -122.403260124179 | (37.7114364608051, -122.403260124179) | 10 | 3 | 8 | 309 | 1 | ||
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 | |||
97199 | 180502 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2003 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6000738.6193 | 2090458.82485 | 37.7200434494224 | -122.4394877147 | (37.7200434494224, -122.4394877147) | 9 | 7 | 6 | 28861 | 25 | |||
120581 | 242369 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 233 Hermann St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004255.94534 | 2108711.38345 | 37.7703603174149 | -122.428629938834 | (37.7703603174149, -122.428629938834) | 7 | 9 | 5 | 29492 | 10 | |||
179125 | 219559 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4 Cortes Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 5993189.55754 | 2099585.29183 | 37.7446699411581 | -122.466244934168 | (37.7446699411581, -122.466244934168) | 1 | 8 | 4 | 29491 | 40 | |||
46610 | 180489 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 434 Huron Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998732.6593 | 2088560.74965 | 37.7147174016639 | -122.446285139651 | (37.7147174016639, -122.446285139651) | 9 | 7 | 6 | 28861 | 25 | |||
67853 | 242368 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 233 Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004227.74725 | 2108711.23983 | 37.7703583272026 | -122.428727465798 | (37.7703583272026, -122.428727465798) | 7 | 9 | 5 | 29492 | 10 | |||
177693 | 219547 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 500 Junipero Serra Blvd | 49 | : | Tree | Private 2 | 4 | Width 0ft | 5991319.77336 | 2093416.99308 | 37.7276252981672 | -122.4722606639 | (37.7276252981672, -122.4722606639) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
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 | |||
56783 | 219569 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400 Magellan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5993620.64115 | 2099492.84628 | 37.7444409719637 | -122.464747631304 | (37.7444409719637, -122.464747631304) | 1 | 8 | 4 | 29491 | 40 | |||
116407 | 219516 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 35 Santa Ana Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992613.16178 | 2096649.41488 | 37.73657549235 | -122.468024468563 | (37.73657549235, -122.468024468563) | 1 | 8 | 4 | 59 | 40 | |||
119766 | 219474 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2 Santa Ana Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992559.60263 | 2096805.97754 | 37.7370022809142 | -122.468221029778 | (37.7370022809142, -122.468221029778) | 1 | 8 | 4 | 59 | 40 | |||
157642 | 219584 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 241 Montalvo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5993880.71075 | 2099373.6943 | 37.7441288011066 | -122.463839724345 | (37.7441288011066, -122.463839724345) | 1 | 8 | 4 | 29491 | 40 | |||
158316 | 219545 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 34 | : | Tree | Private 2 | 17 | Width 0ft | 5991400.33592 | 2094418.5167 | 37.730379893706 | -122.472055129242 | (37.730379893706, -122.472055129242) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
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 | |||
60726 | 242366 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 233 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004171.85314 | 2108702.49137 | 37.7703311424999 | -122.428920179722 | (37.7703311424999, -122.428920179722) | 7 | 9 | 5 | 29492 | 10 | |||
64275 | 215453 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 130 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5992604.15491 | 2095739.66057 | 37.7340770147327 | -122.467989455265 | (37.7340770147327, -122.467989455265) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
74093 | 219506 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 65 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992621.37254 | 2096400.00635 | 37.7358911532574 | -122.467977944832 | (37.7358911532574, -122.467977944832) | 1 | 8 | 4 | 59 | 40 | |||
74265 | 219581 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 201 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993830.50755 | 2099471.62985 | 37.7443948142649 | -122.464020422411 | (37.7443948142649, -122.464020422411) | 1 | 8 | 4 | 29491 | 40 | |||
86131 | 219468 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 195 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992655.03542 | 2095482.88699 | 37.7333749167204 | -122.467794877953 | (37.7333749167204, -122.467794877953) | 9 | 8 | 4 | 59 | 40 | |||
89209 | 219577 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 250 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5993372.19825 | 2099725.86442 | 37.7450664540558 | -122.465623614159 | (37.7450664540558, -122.465623614159) | 1 | 8 | 4 | 29491 | 40 | |||
90384 | 219499 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 89 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992627.94959 | 2096200.87994 | 37.7353447818384 | -122.467940726393 | (37.7353447818384, -122.467940726393) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
112212 | 219519 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 25 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992609.905 | 2096718.49186 | 37.7367649723144 | -122.468040751674 | (37.7367649723144, -122.468040751674) | 1 | 8 | 4 | 59 | 40 | |||
126341 | 219503 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 75 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992624.10282 | 2096321.89499 | 37.7356768367092 | -122.467962825444 | (37.7356768367092, -122.467962825444) | 1 | 8 | 4 | 59 | 40 | |||
132143 | 180488 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 434 Huron Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5998779.43876 | 2088603.45048 | 37.7148373199676 | -122.44612652085 | (37.7148373199676, -122.44612652085) | 9 | 7 | 6 | 28861 | 25 | |||
133524 | 219515 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 35 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992614.77796 | 2096630.2864 | 37.7365230636791 | -122.468017489821 | (37.7365230636791, -122.468017489821) | 1 | 8 | 4 | 59 | 40 | |||
146078 | 219579 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 396 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993828.63857 | 2099567.99676 | 37.7446593057809 | -122.464033878966 | (37.7446593057809, -122.464033878966) | 1 | 8 | 4 | 29491 | 40 | |||
149140 | 215448 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 110 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5992599.75801 | 2095859.89979 | 37.7344069076591 | -122.468013399705 | (37.7344069076591, -122.468013399705) | 9 | 8 | 4 | 59 | 40 | |||
151808 | 219570 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5993657.20288 | 2099495.64217 | 37.7444507566102 | -122.464621412364 | (37.7444507566102, -122.464621412364) | 1 | 8 | 4 | 29491 | 40 | |||
161179 | 215460 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 180 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992612.98876 | 2095518.41795 | 37.7334700478853 | -122.467942827217 | (37.7334700478853, -122.467942827217) | 9 | 8 | 4 | 59 | 40 | |||
167566 | 219473 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992552.54486 | 2096838.28511 | 37.7370905817533 | -122.468247781032 | (37.7370905817533, -122.468247781032) | 1 | 8 | 4 | 59 | 40 | |||
170411 | 219457 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 125 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992642.51774 | 2095825.25253 | 37.734314244193 | -122.467863047447 | (37.734314244193, -122.467863047447) | 9 | 8 | 4 | 59 | 40 | |||
174515 | 219486 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 60 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992579.41042 | 2096404.23892 | 37.7359003515064 | -122.468123331026 | (37.7359003515064, -122.468123331026) | 1 | 8 | 4 | 59 | 40 | |||
175325 | 219585 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 241 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993899.35887 | 2099335.10378 | 37.7440239158702 | -122.463772443345 | (37.7440239158702, -122.463772443345) | 1 | 8 | 4 | 29491 | 40 | |||
178691 | 180494 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3163 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5995762.75975 | 2086924.30814 | 37.7100540508169 | -122.45643200954 | (37.7100540508169, -122.45643200954) | 9 | 7 | 6 | 28861 | 25 | |||
194259 | 180505 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1985 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 2ft | Permit Number 785142 | 6000851.90782 | 2090665.09489 | 37.7206162672045 | -122.43911089157 | (37.7206162672045, -122.43911089157) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
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 | |||
139950 | 219543 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 25 | : | Tree | Private 2 | 4 | Width 0ft | 5991389.00988 | 2094463.60901 | 37.7305030504606 | -122.472097570066 | (37.7305030504606, -122.472097570066) | 9 | 8 | 4 | 64 | 40 | |||
191100 | 219542 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 24 | : | Tree | Private 2 | 15 | Width 0ft | 5991404.22112 | 2094464.36175 | 37.7305059975454 | -122.472045037948 | (37.7305059975454, -122.472045037948) | 9 | 8 | 4 | 64 | 40 | |||
185799 | 11726 | Permitted Site 7 | Ulmus americana :: American Elm 74 | 899X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
41866 | 219493 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 90 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992589.41674 | 2096176.23062 | 37.7352748757434 | -122.468072155131 | (37.7352748757434, -122.468072155131) | 1 | 8 | 4 | 59 | 40 | |||
42769 | 215472 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1 Sola Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 5994924.36549 | 2100698.72724 | 37.7478270966613 | -122.46032700748 | (37.7478270966613, -122.46032700748) | 1 | 8 | 4 | 29491 | 40 | |||
47182 | 219521 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 15 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992605.36477 | 2096774.53089 | 37.7369185792154 | -122.468060524183 | (37.7369185792154, -122.468060524183) | 1 | 8 | 4 | 59 | 40 | |||
49106 | 219553 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 550 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5992916.58806 | 2099434.6981 | 37.7442406956683 | -122.46717785397 | (37.7442406956683, -122.46717785397) | 1 | 8 | 4 | 29491 | 40 | |||
51220 | 219561 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 490 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5993262.17778 | 2099464.73823 | 37.7443431212459 | -122.465985071457 | (37.7443431212459, -122.465985071457) | 1 | 8 | 4 | 29491 | 40 | |||
53999 | 215450 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 120 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992601.06459 | 2095800.70653 | 37.7342444532197 | -122.46800457827 | (37.7342444532197, -122.46800457827) | 9 | 8 | 4 | 59 | 40 | |||
56347 | 219469 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 195 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992654.63062 | 2095463.63791 | 37.7333220401737 | -122.467794877931 | (37.7333220401737, -122.467794877931) | 9 | 8 | 4 | 59 | 40 | |||
61413 | 219582 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 201 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 3ft | 5993843.78442 | 2099442.00982 | 37.7443142502938 | -122.46397236444 | (37.7443142502938, -122.46397236444) | 1 | 8 | 4 | 29491 | 40 | |||
70942 | 215465 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 155 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5995078.64363 | 2100761.22837 | 37.748007582495 | -122.459798051436 | (37.748007582495, -122.459798051436) | 1 | 8 | 4 | 29491 | 40 | |||
73073 | 82753 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1369-1369 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52440 | 6008965.8436 | 2109583.1338 | 37.7730193637194 | -122.412399968507 | (37.7730193637194, -122.412399968507) | 8 | 2 | 9 | 28853 | 34 | |
73520 | 219578 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 250 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993422.34759 | 2099726.29406 | 37.7450705261771 | -122.465450239238 | (37.7450705261771, -122.465450239238) | 1 | 8 | 4 | 29491 | 40 | |||
73877 | 219514 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 35 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992615.02777 | 2096610.18146 | 37.7364678749865 | -122.468015164161 | (37.7364678749865, -122.468015164161) | 1 | 8 | 4 | 59 | 40 | |||
78722 | 219462 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 141 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5992648.10165 | 2095694.10938 | 37.7339544803051 | -122.467834207082 | (37.7339544803051, -122.467834207082) | 9 | 8 | 4 | 59 | 40 | |||
79485 | 219575 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 215 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5993599.71947 | 2099709.46865 | 37.7450345560008 | -122.464835701903 | (37.7450345560008, -122.464835701903) | 1 | 8 | 4 | 29491 | 40 | |||
80413 | 215467 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 131 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5995042.95861 | 2100982.39636 | 37.7486128019409 | -122.459937467057 | (37.7486128019409, -122.459937467057) | 1 | 8 | 4 | 29491 | 40 | |||
83310 | 180509 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2500 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010776.88958 | 2086485.57277 | 37.7096998986965 | -122.4045091134 | (37.7096998986965, -122.4045091134) | 10 | 3 | 8 | 309 | 1 | |||
83747 | 1864 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2555 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 3 | 3X3 | 6010698.44639 | 2086315.70345 | 37.7092290874102 | -122.404768277337 | (37.7092290874102, -122.404768277337) | 10 | 3 | 8 | 309 | 1 | ||
84180 | 219571 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993693.09404 | 2099500.59064 | 37.7444664129069 | -122.464497668332 | (37.7444664129069, -122.464497668332) | 1 | 8 | 4 | 29491 | 40 | |||
85970 | 219458 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 125 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992642.59495 | 2095810.90237 | 37.7342748466983 | -122.467861737123 | (37.7342748466983, -122.467861737123) | 9 | 8 | 4 | 59 | 40 | |||
86613 | 219512 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 41 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992615.55608 | 2096571.31124 | 37.7363611776267 | -122.468010511076 | (37.7363611776267, -122.468010511076) | 1 | 8 | 4 | 59 | 40 | |||
87126 | 219480 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 40 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992573.35664 | 2096580.23843 | 37.7363832523767 | -122.468157060102 | (37.7363832523767, -122.468157060102) | 1 | 8 | 4 | 59 | 40 | |||
88466 | 219456 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 115 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5992639.24928 | 2095904.23823 | 37.734530930444 | -122.467880090494 | (37.734530930444, -122.467880090494) | 9 | 8 | 4 | 59 | 40 | |||
91221 | 219554 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 540 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5992988.81952 | 2099440.93268 | 37.7442619835139 | -122.466928548418 | (37.7442619835139, -122.466928548418) | 1 | 8 | 4 | 29491 | 40 | |||
91654 | 215462 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 196 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992612.69306 | 2095452.3609 | 37.7332886546337 | -122.467939046451 | (37.7332886546337, -122.467939046451) | 9 | 8 | 4 | 59 | 40 | |||
94712 | 242365 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 233 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004152.28939 | 2108699.9482 | 37.7703230522076 | -122.428987669363 | (37.7703230522076, -122.428987669363) | 7 | 9 | 5 | 29492 | 10 | |||
103253 | 215452 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 130 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992604.2406 | 2095761.0748 | 37.7341358178054 | -122.467990716115 | (37.7341358178054, -122.467990716115) | 9 | 8 | 4 | 59 | 40 | |||
107099 | 215447 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 110 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992597.98393 | 2095879.53795 | 37.7344607266837 | -122.468020961215 | (37.7344607266837, -122.468020961215) | 9 | 8 | 4 | 59 | 40 | |||
108561 | 219524 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 751 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991357.23794 | 2092104.99366 | 37.7240250422104 | -122.472035561797 | (37.7240250422104, -122.472035561797) | 9 | 8 | 4 | 59 | 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 | |||
117044 | 219526 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 121 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995598.71297 | 2087377.82947 | 37.7112898955879 | -122.457031766517 | (37.7112898955879, -122.457031766517) | 9 | 8 | 6 | 28861 | 24 | |||
119521 | 219478 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 30 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992570.88525 | 2096654.65896 | 37.7365874497346 | -122.468171016701 | (37.7365874497346, -122.468171016701) | 1 | 8 | 4 | 59 | 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 | |||
138511 | 180493 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3163 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995731.65538 | 2086919.46942 | 37.7100389790737 | -122.456539161954 | (37.7100389790737, -122.456539161954) | 9 | 7 | 6 | 28861 | 25 | |||
140972 | 219505 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 65 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992622.51145 | 2096374.1879 | 37.7358203280358 | -122.467972129825 | (37.7358203280358, -122.467972129825) | 1 | 8 | 4 | 59 | 40 | |||
141609 | 219460 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 131 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992644.33525 | 2095767.44219 | 37.7341556163962 | -122.46785256047 | (37.7341556163962, -122.46785256047) | 9 | 8 | 4 | 59 | 40 | |||
141948 | 219509 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 45 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992617.13851 | 2096502.60389 | 37.736172615865 | -122.46800004387 | (37.736172615865, -122.46800004387) | 1 | 8 | 4 | 59 | 40 | |||
144712 | 219491 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 80 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992586.43112 | 2096226.20805 | 37.7354119288232 | -122.468086111696 | (37.7354119288232, -122.468086111696) | 1 | 8 | 4 | 59 | 40 |
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) );