trees

286 rows where qSpecies_id = 74 sorted by Fire Prevention Districts

✎ View and edit SQL

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)          
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
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
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
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
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
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
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
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
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
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
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
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
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
45041 219508 DPW Maintained 1 Ulmus americana :: American Elm 74 45 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   5992618.0664 2096466.7402 37.7360741967519 -122.467994227949 (37.7360741967519, -122.467994227949) 1 8 4 59 40
45245 219551 DPW Maintained 1 Ulmus americana :: American Elm 74 570 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5992805.02333 2099425.24605 37.7442083020749 -122.467562930206 (37.7442083020749, -122.467562930206) 1 8 4 29491 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
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
53718 219574 DPW Maintained 1 Ulmus americana :: American Elm 74 100 Montalvo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     22 Width 3ft   5993666.81553 2099677.65694 37.7449510773443 -122.464601388053 (37.7449510773443, -122.464601388053) 1 8 4 29491 40
53897 219572 DPW Maintained 1 Ulmus americana :: American Elm 74 400 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 3ft   5993729.40272 2099508.38123 37.7444898968847 -122.46437268687 (37.7444898968847, -122.46437268687) 1 8 4 29491 40
54037 219576 DPW Maintained 1 Ulmus americana :: American Elm 74 215 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5993565.89872 2099706.47118 37.7450243756816 -122.464952429427 (37.7450243756816, -122.464952429427) 1 8 4 29491 40
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
60049 219560 DPW Maintained 1 Ulmus americana :: American Elm 74 490 Cortes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5993227.69053 2099492.54719 37.7444174879844 -122.466106340543 (37.7444174879844, -122.466106340543) 1 8 4 29491 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
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
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
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
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
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
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
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
74416 215464 DPW Maintained 1 Ulmus americana :: American Elm 74 155 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5995075.02131 2100739.26228 37.7479470608168 -122.459808986296 (37.7479470608168, -122.459808986296) 1 8 4 29491 40
76459 219568 DPW Maintained 1 Ulmus americana :: American Elm 74 432 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5993595.89147 2099490.15845 37.7444321649285 -122.464833014754 (37.7444321649285, -122.464833014754) 1 8 4 29491 40
77444 219580 DPW Maintained 1 Ulmus americana :: American Elm 74 320 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5994238.61211 2099950.79183 37.7457339839424 -122.462644044196 (37.7457339839424, -122.462644044196) 1 8 4 29491 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
83350 215466 DPW Maintained 1 Ulmus americana :: American Elm 74 131 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   5995052.95095 2100968.80441 37.7485760565417 -122.459901929455 (37.7485760565417, -122.459901929455) 1 8 4 29491 40
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
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
87202 219583 DPW Maintained 1 Ulmus americana :: American Elm 74 201 Montalvo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 3ft   5993863.59028 2099405.60943 37.7442154454004 -122.463901238844 (37.7442154454004, -122.463901238844) 1 8 4 29491 40
88369 219504 DPW Maintained 1 Ulmus americana :: American Elm 74 65 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   5992624.10653 2096354.05467 37.7357651393451 -122.467965151081 (37.7357651393451, -122.467965151081) 1 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
90137 219501 DPW Maintained 1 Ulmus americana :: American Elm 74 75 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   5992625.26831 2096281.33572 37.7355655384208 -122.467955846711 (37.7355655384208, -122.467955846711) 1 8 4 59 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
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
91277 219497 DPW Maintained 1 Ulmus americana :: American Elm 74 89 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 8ft   5992628.80524 2096145.58724 37.7351930113401 -122.46793374764 (37.7351930113401, -122.46793374764) 1 8 4 59 40
92153 117518 Significant Tree 6 Ulmus americana :: American Elm 74 30 Santa Paula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2016 12:00:00 AM 3   Permit Number 777803 5993995.8 2097679.6 37.7394838741894 -122.463318866351 (37.7394838741894, -122.463318866351) 1 8 4 59 40
98921 219557 DPW Maintained 1 Ulmus americana :: American Elm 74 500 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5993193.55184 2099470.33756 37.7443545363406 -122.466222770361 (37.7443545363406, -122.466222770361) 1 8 4 29491 40
102654 219550 DPW Maintained 1 Ulmus americana :: American Elm 74 584 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5992742.68217 2099422.51229 37.7441971963417 -122.467778291755 (37.7441971963417, -122.467778291755) 1 8 4 29491 40
105688 219511 DPW Maintained 1 Ulmus americana :: American Elm 74 41 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 8ft   5992616.80765 2096550.85016 37.736305068912 -122.468004696059 (37.736305068912, -122.468004696059) 1 8 4 59 40
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
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
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
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
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
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
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
125573 219565 DPW Maintained 1 Ulmus americana :: American Elm 74 456 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5993467.92544 2099480.37304 37.7443979178455 -122.465274780618 (37.7443979178455, -122.465274780618) 1 8 4 29491 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
128531 215468 DPW Maintained 1 Ulmus americana :: American Elm 74 140 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5995041.47526 2100911.57821 37.7484182678045 -122.459937467056 (37.7484182678045, -122.459937467056) 1 8 4 29491 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
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
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
134532 219573 DPW Maintained 1 Ulmus americana :: American Elm 74 140 Montalvo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 3ft   5993734.74084 2099541.05519 37.7445799190316 -122.46435660067 (37.7445799190316, -122.46435660067) 1 8 4 29491 40
139058 219562 DPW Maintained 1 Ulmus americana :: American Elm 74 474 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5993376.84863 2099471.9511 37.7443695406169 -122.465589090967 (37.7443695406169, -122.465589090967) 1 8 4 29491 40
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
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
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
146569 219548 DPW Maintained 1 Ulmus americana :: American Elm 74 598 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   5992680.0025 2099419.78547 37.7441860897219 -122.467994824228 (37.7441860897219, -122.467994824228) 1 8 4 29491 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
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
153606 219496 DPW Maintained 1 Ulmus americana :: American Elm 74 91 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   5992630.2874 2096120.09632 37.7351231052451 -122.467926769816 (37.7351231052451, -122.467926769816) 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
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
160461 219558 DPW Maintained 1 Ulmus americana :: American Elm 74 500 Cortes Ave 2 Sidewalk: Curb side : Yard Tree Private 2     22 Width 3ft   5993196.24887 2099494.98963 37.7444223802847 -122.466215235845 (37.7444223802847, -122.466215235845) 1 8 4 29491 40
161859 219500 DPW Maintained 1 Ulmus americana :: American Elm 74 85 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 8ft   5992628.23833 2096214.60894 37.735382494908 -122.467940726397 (37.735382494908, -122.467940726397) 1 8 4 59 40
164288 219502 DPW Maintained 1 Ulmus americana :: American Elm 74 75 Santa Ana Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 8ft   5992626.60813 2096297.05268 37.7356087706264 -122.46795235732 (37.7356087706264, -122.46795235732) 1 8 4 59 40
164929 219507 DPW Maintained 1 Ulmus americana :: American Elm 74 55 Santa Ana Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 8ft   5992619.03813 2096448.96489 37.7360254463244 -122.467989575775 (37.7360254463244, -122.467989575775) 1 8 4 59 40
165482 215463 DPW Maintained 1 Ulmus americana :: American Elm 74 187 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5995065.4232 2100715.05952 37.747880054141 -122.459840423011 (37.747880054141, -122.459840423011) 1 8 4 29491 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
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
168531 219586 DPW Maintained 1 Ulmus americana :: American Elm 74 45 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     31 Width 4ft   5994631.61405 2099807.81481 37.7453640307186 -122.461274748142 (37.7453640307186, -122.461274748142) 1 8 4 59 40
171215 219555 DPW Maintained 1 Ulmus americana :: American Elm 74 540 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     22 Width 3ft   5993011.22836 2099444.16931 37.7442721638315 -122.466851299354 (37.7442721638315, -122.466851299354) 1 8 4 29491 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
175337 219552 DPW Maintained 1 Ulmus americana :: American Elm 74 560 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   5992845.00519 2099427.10194 37.744215706187 -122.467424817725 (37.744215706187, -122.467424817725) 1 8 4 29491 40
176932 219498 DPW Maintained 1 Ulmus americana :: American Elm 74 89 Santa Ana Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 8ft   5992626.79103 2096177.78936 37.7352813139843 -122.467943052944 (37.7352813139843, -122.467943052944) 1 8 4 59 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);