trees
286 rows where qSpecies_id = 74 sorted by XCoord
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) | ||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
156527 | 219538 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3776 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990469.41158 | 2090916.96408 | 37.7207115926475 | -122.475017925048 | (37.7207115926475, -122.475017925048) | 9 | 8 | 4 | 64 | 40 | |||
90190 | 219539 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3774 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990471.08973 | 2090949.21154 | 37.7208002334236 | -122.475014477034 | (37.7208002334236, -122.475014477034) | 9 | 8 | 4 | 64 | 40 | |||
167438 | 219537 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3778 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5990477.3207 | 2090889.9775 | 37.7206379525664 | -122.47498861704 | (37.7206379525664, -122.47498861704) | 9 | 8 | 4 | 64 | 40 | |||
160814 | 219535 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3780 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5990477.51267 | 2090868.47849 | 37.7205789327461 | -122.474986384926 | (37.7205789327461, -122.474986384926) | 9 | 8 | 4 | 64 | 40 | |||
182205 | 219532 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3794 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5990477.6688 | 2090693.78822 | 37.7200992856469 | -122.474973100146 | (37.7200992856469, -122.474973100146) | 9 | 8 | 4 | 64 | 40 | |||
183747 | 219536 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3778 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5990478.1501 | 2090882.01341 | 37.720616133219 | -122.474985169044 | (37.720616133219, -122.474985169044) | 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 | |||
175954 | 219531 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3796 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990484.55998 | 2090665.82939 | 37.7200229169975 | -122.474947240127 | (37.7200229169975, -122.474947240127) | 9 | 8 | 4 | 64 | 40 | |||
186061 | 219530 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3798 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5990495.45016 | 2090638.28304 | 37.7199479126589 | -122.474907587234 | (37.7199479126589, -122.474907587234) | 9 | 8 | 4 | 64 | 40 | |||
88060 | 219529 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3798 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990509.31034 | 2090609.6806 | 37.7198701806571 | -122.474857591227 | (37.7198701806571, -122.474857591227) | 9 | 8 | 4 | 64 | 40 | |||
163236 | 219528 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3800 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5990523.17081 | 2090581.07783 | 37.7197924477439 | -122.474807594299 | (37.7197924477439, -122.474807594299) | 9 | 8 | 4 | 64 | 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 | |||
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 | |||
43891 | 219540 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3020 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5990625.96048 | 2094991.11327 | 37.7319072572925 | -122.47477400284 | (37.7319072572925, -122.47477400284) | 1 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
48415 | 219523 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 851 Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5991345.30581 | 2091866.10116 | 37.7233684121017 | -122.472059404642 | (37.7233684121017, -122.472059404642) | 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 | |||
157716 | 219546 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400 Junipero Serra Blvd | 14 | : | Tree | Private 2 | 8 | Width 0ft | 5991370.04012 | 2094121.65421 | 37.7295630305013 | -122.472138234715 | (37.7295630305013, -122.472138234715) | 9 | 8 | 4 | 64 | 40 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
99216 | 1310 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4035 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X6 | 5991848.72186 | 2087031.07112 | 37.7101217158162 | -122.469967330646 | (37.7101217158162, -122.469967330646) | 9 | 8 | 4 | 64 | 24 | |||
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 | |||
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 | |||
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 | |||
106423 | 219471 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992545.99069 | 2096862.54215 | 37.7371568069404 | -122.468272205699 | (37.7371568069404, -122.468272205699) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
129511 | 219477 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 30 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992571.34305 | 2096676.4237 | 37.7366472366842 | -122.468171016694 | (37.7366472366842, -122.468171016694) | 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 | |||
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 | |||
177505 | 219481 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 50 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992575.51838 | 2096555.0686 | 37.7363142671892 | -122.468147755737 | (37.7363142671892, -122.468147755737) | 1 | 8 | 4 | 59 | 40 | |||
188687 | 219482 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 50 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992576.61335 | 2096511.16113 | 37.7361937715337 | -122.468140776996 | (37.7361937715337, -122.468140776996) | 1 | 8 | 4 | 59 | 40 | |||
191756 | 219483 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 54 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992577.4442 | 2096486.68909 | 37.7361266254364 | -122.468136124802 | (37.7361266254364, -122.468136124802) | 1 | 8 | 4 | 59 | 40 | |||
168464 | 219484 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 54 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992577.59564 | 2096461.89628 | 37.7360585593464 | -122.468133798263 | (37.7360585593464, -122.468133798263) | 1 | 8 | 4 | 59 | 40 | |||
190262 | 219485 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 60 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992578.71338 | 2096435.07341 | 37.7359849750264 | -122.468127983245 | (37.7359849750264, -122.468127983245) | 1 | 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 | |||
132505 | 219487 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 66 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992581.45271 | 2096373.37647 | 37.7358157289051 | -122.468114025768 | (37.7358157289051, -122.468114025768) | 1 | 8 | 4 | 59 | 40 | |||
155587 | 219488 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 66 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992583.52997 | 2096344.18796 | 37.735735704541 | -122.468104721355 | (37.735735704541, -122.468104721355) | 1 | 8 | 4 | 59 | 40 | |||
71750 | 219489 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 72 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992583.96831 | 2096317.04431 | 37.7356612001976 | -122.468101231991 | (37.7356612001976, -122.468101231991) | 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 | |||
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 | |||
47130 | 219492 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 90 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992588.10178 | 2096193.67809 | 37.7353227061853 | -122.468077970135 | (37.7353227061853, -122.468077970135) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
188418 | 219495 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 92 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992590.1122 | 2096129.31629 | 37.7351461009061 | -122.468066339199 | (37.7351461009061, -122.468066339199) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
128210 | 219587 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 100 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 5992597.45757 | 2095923.83271 | 37.7345823186193 | -122.468026001902 | (37.7345823186193, -122.468026001902) | 9 | 8 | 4 | 59 | 40 | |||
169884 | 215446 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 110 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992597.86385 | 2095891.15575 | 37.7344926193226 | -122.468022221156 | (37.7344926193226, -122.468022221156) | 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 | |||
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 | |||
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 | |||
99530 | 215449 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 120 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992601.94776 | 2095825.37047 | 37.7343122252356 | -122.468003318313 | (37.7343122252356, -122.468003318313) | 9 | 8 | 4 | 59 | 40 | |||
79410 | 215451 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 130 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5992603.36881 | 2095771.61937 | 37.7341647202147 | -122.467994496876 | (37.7341647202147, -122.467994496876) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
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 | |||
44877 | 215454 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 160 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5992606.05096 | 2095656.49757 | 37.7338487794048 | -122.467976853054 | (37.7338487794048, -122.467976853054) | 9 | 8 | 4 | 59 | 40 | |||
158534 | 215455 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 160 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 5992606.29113 | 2095633.26163 | 37.7337849931862 | -122.467974333173 | (37.7337849931862, -122.467974333173) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
116673 | 219520 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 15 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992608.23435 | 2096751.02117 | 37.7368541931494 | -122.468048893267 | (37.7368541931494, -122.468048893267) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
182954 | 215458 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 180 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992610.41916 | 2095552.22945 | 37.7335627374372 | -122.467954169463 | (37.7335627374372, -122.467954169463) | 9 | 8 | 4 | 59 | 40 | |||
67019 | 219517 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 25 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992610.84668 | 2096683.29768 | 37.7366683923157 | -122.468034936661 | (37.7366683923157, -122.468034936661) | 1 | 8 | 4 | 59 | 40 | |||
184746 | 219518 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 25 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992611.40848 | 2096694.00568 | 37.7366978262389 | -122.468033772953 | (37.7366978262389, -122.468033772953) | 1 | 8 | 4 | 59 | 40 | |||
166805 | 215459 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 180 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992611.44157 | 2095531.51805 | 37.7335059281442 | -122.467949128772 | (37.7335059281442, -122.467949128772) | 9 | 8 | 4 | 59 | 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 | |||
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 | |||
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 | |||
171726 | 215461 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 196 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992613.18906 | 2095475.94459 | 37.7333534382047 | -122.467939046448 | (37.7333534382047, -122.467939046448) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
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 |
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) );