286 rows where qSpecies_id = 74 sorted by XCoord

View and edit SQL

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

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