trees

1,977 rows where qSpecies_id = 41 sorted by qSiteInfo

✎ 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)
68382 249924 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 358 Greenwich St 8 Back Yard : Yard Tree Private 2     12 Width 0ft   6011171.36702 2120411.09017 37.8028738823709 -122.405533505089 (37.8028738823709, -122.405533505089) 3 1 10 308 23
74879 249919 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 358 Greenwich St 4 Back Yard : Yard Tree Private 2     14 Width 0ft   6011190.2403 2120395.87946 37.8028331727783 -122.405467121607 (37.8028331727783, -122.405467121607) 3 1 10 308 23
77182 251613 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 60R Amber Dr 2 Back Yard : Yard Tree Private 2           5999394 2100048 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752) 2 7 5 63 22
79802 249918 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 358 Greenwich St 3 Back Yard : Yard Tree Private 2     20 Width 0ft   6011195.29362 2120394.33345 37.8028292103611 -122.405449525493 (37.8028292103611, -122.405449525493) 3 1 10 308 23
79818 251517 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 145 Bonview St 1 Back Yard : Yard Tree Private 2       3x3   6007188 2098162 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125) 2 7 7 28859 2
93089 249927 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 358 Greenwich St 12 Back Yard : Yard Tree Private 2     31 Width 0ft   6011132.35015 2120388.99651 37.8028110368738 -122.405666967151 (37.8028110368738, -122.405666967151) 3 1 10 308 23
93871 218149 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 35 Ashton Ave 2 Back Yard : Yard Tree Private 2     12     5994121.02208 2090034.4141 37.7184992747921 -122.462331555861 (37.7184992747921, -122.462331555861) 9 8 6 28861 24
98838 251629 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
102716 251631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 3 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
104365 251617 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 64R Amber Dr 4 Back Yard : Yard Tree Private 2           5999367 2100045 37.7462866749207 -122.444917661566 (37.7462866749207, -122.444917661566) 2 7 5 63 22
104650 249923 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 358 Greenwich St 9 Back Yard : Yard Tree Private 2     33 Width 0ft   6011163.06331 2120405.05222 37.8028568393309 -122.405561814838 (37.8028568393309, -122.405561814838) 3 1 10 308 23
105722 187627 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 88 States St 1 Back Yard : Yard Tree Private 2           6001213 2106258 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
109149 249925 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 358 Greenwich St 10 Back Yard : Yard Tree Private 2     14 Width 0ft   6011155.36985 2120409.86411 37.8028696214088 -122.40558877741 (37.8028696214088, -122.40558877741) 3 1 10 308 23
109151 249917 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 358 Greenwich St 2 Back Yard : Yard Tree Private 2     10 Width 0ft   6011197.83082 2120409.77535 37.802871751897 -122.405441833595 (37.802871751897, -122.405441833595) 3 1 10 308 23
111349 251628 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2R Amethyst Way 3 Back Yard : Yard Tree Private 2           5999263 2100016 37.7462011119367 -122.44527519505 (37.7462011119367, -122.44527519505) 2 7 5 63 22
113435 251621 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 72R Amber Dr 4 Back Yard : Yard Tree Private 2           5999318 2100030 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875) 2 7 5 63 22
113507 253768 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 100 Raccoon Dr 1 Back Yard : Yard Tree Private 2           5998692 2104165 37.7575606372552 -122.447548237739 (37.7575606372552, -122.447548237739) 15 5 5 28862 3
116904 105236 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 235X STATES ST 1 Back Yard : Yard Tree Private 2     30     6001213 2106258 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
122354 251619 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 72R Amber Dr 2 Back Yard : Yard Tree Private 2           5999318 2100030 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875) 2 7 5 63 22
135134 113440 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 190 BEACON ST   Back Yard : Yard Tree Private 2     32 3x3   6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
139511 218151 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 35 Ashton Ave 4 Back Yard : Yard Tree Private 2     19     5994130.74614 2090030.24083 37.7184883759248 -122.462297641538 (37.7184883759248, -122.462297641538) 9 8 6 28861 24
145363 251626 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999263 2100016 37.7462011119367 -122.44527519505 (37.7462011119367, -122.44527519505) 2 7 5 63 22
146932 251622 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 72R Amber Dr 5 Back Yard : Yard Tree Private 2           5999318 2100030 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875) 2 7 5 63 22
148930 251635 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 18R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999176 2100050 37.7462895011988 -122.445578473632 (37.7462895011988, -122.445578473632) 2 7 5 63 22
153865 251633 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 14R Amethyst Way 2 Back Yard : Yard Tree Private 2           5999202 2100044 37.7462745109784 -122.445488137723 (37.7462745109784, -122.445488137723) 2 7 5 63 22
157400 97685 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 84 Coventry Ct   Back Yard : Yard Tree Private 2           5997084 2096485 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132) 9 7 4 59 40
158945 251611 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 56R Amber Dr 4 Back Yard : Yard Tree Private 2           5999423 2100048 37.7462981080439 -122.44472423658 (37.7462981080439, -122.44472423658) 2 7 5 63 22
160937 102060 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 115 Kensington Way 1 Back Yard : Yard Tree Private 2           5994908.3 2098325.8 37.7413107073974 -122.460210667073 (37.7413107073974, -122.460210667073) 1 8 4 59 40
163478 251615 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 64R Amber Dr 2 Back Yard : Yard Tree Private 2           5999367 2100045 37.7462866749207 -122.444917661566 (37.7462866749207, -122.444917661566) 2 7 5 63 22
167870 251608 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 56R Amber Dr 1 Back Yard : Yard Tree Private 2           5999423 2100048 37.7462981080439 -122.44472423658 (37.7462981080439, -122.44472423658) 2 7 5 63 22
169893 223816 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Ohlone Way 1 Back Yard : Yard Tree Private 2     45 Width 5ft   6002135.08017 2096585.18119 37.7369444095655 -122.435098574335 (37.7369444095655, -122.435098574335) 2 7 5 63 7
173335 117644 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1111X SANSOME ST 1 Back Yard : Yard Tree Private 2       3x30   6011937 2119613 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034) 3 1 10 308 23
175016 249916 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 358 Greenwich St 1 Back Yard : Yard Tree Private 2     20 Width 0ft   6011201.85513 2120410.11068 37.8028728976405 -122.405427930969 (37.8028728976405, -122.405427930969) 3 1 10 308 23
177432 102706 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1342 Funston Ave 1 Back Yard : Yard Tree Private 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
177581 251609 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 56R Amber Dr 2 Back Yard : Yard Tree Private 2           5999423 2100048 37.7462981080439 -122.44472423658 (37.7462981080439, -122.44472423658) 2 7 5 63 22
178693 251623 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 76R Amber Dr 1 Back Yard : Yard Tree Private 2           5999293 2100015 37.7462000785932 -122.44517138727 (37.7462000785932, -122.44517138727) 2 7 5 63 22
183210 120110 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 90X Knollview Way 1 Back Yard : Yard Tree Private 2     20 3x25   5997618 2101448 37.7500389946504 -122.451066619924 (37.7500389946504, -122.451066619924) 1 5 4 63 38
184584 218150 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 35 Ashton Ave 3 Back Yard : Yard Tree Private 2     8     5994126.47455 2090031.24651 37.7184908913149 -122.46231247945 (37.7184908913149, -122.46231247945) 9 8 6 28861 24
185289 251616 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 64R Amber Dr 3 Back Yard : Yard Tree Private 2           5999367 2100045 37.7462866749207 -122.444917661566 (37.7462866749207, -122.444917661566) 2 7 5 63 22
190882 251610 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 56R Amber Dr 3 Back Yard : Yard Tree Private 2           5999423 2100048 37.7462981080439 -122.44472423658 (37.7462981080439, -122.44472423658) 2 7 5 63 22
145768 98703 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 7070@ 32nd Ave California St 4 Front Yard : Tree Private 2   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
32630 85060 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 7070 California St 1 Front Yard : Cutout Tree Private 2   07/03/2007 12:00:00 AM     Permit Number 49405 5985878 2113896 37.7835385880022 -122.492580242312 (37.7835385880022, -122.492580242312) 11 6 2 55 26
33801 114265 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 6 Front Yard : Cutout Tree Private 2     26     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
123260 87819 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 390 Lansdale Ave 1 Front Yard : Cutout Tree Private 2         Permit Number 50681 5995630.7 2096410.1 37.7360921919213 -122.457574304331 (37.7360921919213, -122.457574304331) 9 7 4 59 40
147794 115388 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 169x BOCANA ST 1 Front Yard : Cutout Tree Private 2     25 40x50   6007278 2097999 37.7411171346524 -122.417417333034 (37.7411171346524, -122.417417333034) 2 7 7 28859 2
186507 254476 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1511 Lyon St 1 Front Yard : Cutout Tree Private 2           5999620 2114151 37.7850326563334 -122.445056733542 (37.7850326563334, -122.445056733542) 15 6 1 29490 31
394 119605 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 299x Avalon Ave 1 Front Yard : Yard Tree Private 2                              
612 223703 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1100 San Jose Ave 77 Front Yard : Yard Tree Private 2     18     6004573.37155 2096423.41392 37.7366383864359 -122.426656795699 (37.7366383864359, -122.426656795699) 2 7 5 63 7
703 262210 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2011 Bay Shore Blvd 1 Front Yard : Yard Tree Private 2       3x3   6012422 2088364 37.7149494891568 -122.398955034798 (37.7149494891568, -122.398955034798) 10 3 8 309 1
2657 260570 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 4 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
3666 113065 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2X Cranleigh Dr 6 Front Yard : Yard Tree DPW 1   08/18/2016 09:51:00 AM 3     5991370.3 2095943.7 37.7345659248964 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
4865 223711 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1201 San Jose Ave 43 Front Yard : Yard Tree Private 2     27     6004453.96026 2096061.62765 37.7356382512944 -122.427043891762 (37.7356382512944, -122.427043891762) 2 7 5 28861 2
5792 260568 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 2 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
6858 261031 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 150 Chestnut St 1 Front Yard : Yard Tree Private 2       3x3   6011107 2121175 37.8049677916951 -122.405810090856 (37.8049677916951, -122.405810090856) 3 1 10 308 23
7283 176114 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Zoo Rd 1 Front Yard : Yard Tree Private 2     24 Width 10ft   5982696.49512 2094384.4536 37.7297788507039 -122.502142508582 (37.7297788507039, -122.502142508582) 1 8 4 64 14
8040 260572 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 6 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
10025 264885 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1279 44th Ave 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 787806 5982392 2106415 37.7627934961857 -122.504085938563 (37.7627934961857, -122.504085938563) 1 8 3 56 35
11442 260571 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 5 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11875 260569 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 3 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
13149 260567 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 1 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
14608 259056 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99 Cedro Ave 1 Front Yard : Yard Tree Private 2   10/09/2019 12:00:00 AM 3 3x3 Permit Number 784357 5992279 2093128 37.7268872622364 -122.468923614031 (37.7268872622364, -122.468923614031) 9 8 4 59 40
18265 249711 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2901 Broadway 1 Front Yard : Yard Tree Private 2     30     5999592.84448 2116997.53125 37.7928469352999 -122.445355424115 (37.7928469352999, -122.445355424115) 13 9 1 29490 27
20540 247989 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 130 Mullen Ave 1 Front Yard : Yard Tree Private 2     15 Width 10ft   6009899.29934 2099821.33089 37.7462679959733 -122.408482299339 (37.7462679959733, -122.408482299339) 2 7 7 28859 2
22976 103600 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 50X Hermann St 1 Front Yard : Yard Tree Private 2           6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
24760 223699 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1100 San Jose Ave 2 Front Yard : Yard Tree Private 2     72     6004901.06349 2096745.81285 37.7375421421457 -122.425546760699 (37.7375421421457, -122.425546760699) 2 7 5 63 7
25939 190985 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 17 Front Yard : Yard Tree Private 2     13     6016130.05616 2100249.95648 37.747791881903 -122.386966789196 (37.747791881903, -122.386966789196)   3 8 58 1
29097 223789 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 190 Storrie St 1 Front Yard : Yard Tree Private 2     20 Width 3ft   6000719.29532 2105252.42792 37.7606620968006 -122.440615044554 (37.7606620968006, -122.440615044554) 15 4 5 28862 3
30658 190983 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 20 Front Yard : Yard Tree Private 2     15     6016115.94828 2100251.37259 37.7477949890666 -122.387015672733 (37.7477949890666, -122.387015672733)   3 8 58 1
32016 223722 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 201 College Ave 1 Front Yard : Yard Tree Private 2     13 Width 2ft   6005269.83523 2095874.10119 37.7351694473011 -122.424209762894 (37.7351694473011, -122.424209762894) 2 7 7 28859 2
33730 249826 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 391 Filbert St 2 Front Yard : Yard Tree Private 2     41 Width 0ft   6011015.83097 2120024.81975 37.8018045803872 -122.406044514263 (37.8018045803872, -122.406044514263) 3 1 10 308 23
33894 223780 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 4071 20th St 1 Front Yard : Yard Tree Private 2     28 Width 3ft   6003254.36282 2104156.16383 37.7577960518603 -122.431769121362 (37.7577960518603, -122.431769121362) 2 4 5 28862 3
35065 223737 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1760 Diamond St 3 Front Yard : Yard Tree Private 2     23     6002025.38373 2098740.99425 37.7428575410441 -122.435632028807 (37.7428575410441, -122.435632028807) 2 7 5 63 22
35838 247988 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 124 Mullen Ave 2 Front Yard : Yard Tree Private 2     29 Width 10ft   6009878.9446 2099816.70211 37.7462541464208 -122.408552357412 (37.7462541464208, -122.408552357412) 2 7 7 28859 2
37088 223716 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1101 San Jose Ave 12 Front Yard : Yard Tree Private 2     18     6004761.80581 2096370.25265 37.7365030690611 -122.426001513664 (37.7365030690611, -122.426001513664) 2 7 5 28859 2
37158 254238 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 47 Cole St 3 Front Yard : Yard Tree Private 2           5997708 2110435 37.7747201781994 -122.451403505262 (37.7747201781994, -122.451403505262) 15 5 2 29492 16
37603 93205 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 400 Masonic Ave 3 Front Yard : Yard Tree Private 2   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.7774714343299 -122.446572853901 (37.7774714343299, -122.446572853901) 15 5 11 29492 16
37874 223798 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 250 States St 1 Front Yard : Yard Tree Private 2     51 Width 3ft   6000691.89745 2106604.60917 37.7643732931049 -122.440806799815 (37.7643732931049, -122.440806799815) 15 5 5 28862 3
39688 249675 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2400 Baker St 7 Front Yard : Yard Tree Private 2     49     5999731.49147 2117154.85585 37.7932868206735 -122.444887014927 (37.7932868206735, -122.444887014927) 13 9 1 57 27
40248 223739 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1760 Diamond St 5 Front Yard : Yard Tree Private 2     25     6002032.66494 2098618.50085 37.7425216163939 -122.43559809108 (37.7425216163939, -122.43559809108) 2 7 5 63 22
40516 254236 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 47 Cole St 1 Front Yard : Yard Tree Private 2           5997708 2110435 37.7747201781994 -122.451403505262 (37.7747201781994, -122.451403505262) 15 5 2 29492 16
40743 223743 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 65 Zircon Pl 2 Front Yard : Yard Tree Private 2     45     6002363.70914 2098682.85125 37.7427171047157 -122.434458039421 (37.7427171047157, -122.434458039421) 2 7 5 63 7
41603 223706 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1100 San Jose Ave 80 Front Yard : Yard Tree Private 2     4     6004536.52923 2096375.86849 37.7365057544425 -122.4267807906 (37.7365057544425, -122.4267807906) 2 7 5 63 7
42296 206849 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Cranleigh Dr 14 Front Yard : Yard Tree Private 2     3 Width 0ft   5991370.13316 2095847.84746 37.7343027283865 -122.472263695526 (37.7343027283865, -122.472263695526) 1 8 4 64 40
43937 223735 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1760 Diamond St 1 Front Yard : Yard Tree Private 2     34     6002021.50784 2098799.04405 37.7430167120556 -122.43564958267 (37.7430167120556, -122.43564958267) 2 7 5 63 22
44661 102745 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 222 Moncada Way 1 Front Yard : Yard Tree Private 2           5992354 2093377.4 37.7275763858966 -122.468682482409 (37.7275763858966, -122.468682482409) 9 8 4 59 40
45795 217840 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Cranleigh Dr 30 Front Yard : Yard Tree Private 2     1     5991415.56175 2095863.71205 37.7343489175724 -122.472107791755 (37.7343489175724, -122.472107791755) 1 8 4 64 40
47129 223698 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1100 San Jose Ave 1 Front Yard : Yard Tree Private 2     151     6004903.42732 2096771.39372 37.7376125150086 -122.425540407858 (37.7376125150086, -122.425540407858) 2 7 5 63 7
49560 217841 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Cranleigh Dr 31 Front Yard : Yard Tree Private 2     1     5991404.95504 2095888.4488 37.7344162246301 -122.472146264739 (37.7344162246301, -122.472146264739) 1 8 4 64 40
50525 173933 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 190 Beacon St 1 Front Yard : Yard Tree Private 2           6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
50890 253778 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 90 Cuesta Ct 2 Front Yard : Yard Tree DPW 1           5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
55445 253289 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 650 Peru Ave 5 Front Yard : Yard Tree Private 2           6005101.95698 2092563.19401 37.7260689503102 -122.424554741032 (37.7260689503102, -122.424554741032) 9 7 6 28861 5
56981 223785 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 4053 20th St 4 Front Yard : Yard Tree Private 2     33 Width 3ft   6003318.98777 2104163.44905 37.7578197184314 -122.431546141668 (37.7578197184314, -122.431546141668) 2 4 5 28862 3
57675 253290 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 650 Peru Ave 6 Front Yard : Yard Tree Private 2           6005101.95698 2092563.19401 37.7260689503102 -122.424554741032 (37.7260689503102, -122.424554741032) 9 7 6 28861 5
58208 248051 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 25 Rutledge St 1 Front Yard : Yard Tree Private 2     24     6010607.15124 2099382.29757 37.7451021220724 -122.406003697633 (37.7451021220724, -122.406003697633) 2 7 7 28859 2
58681 190979 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 26 Front Yard : Yard Tree Private 2     10     6016095.64833 2100226.27382 37.7477249489626 -122.387084119257 (37.7477249489626, -122.387084119257)   3 8 58 1
60505 249710 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2901 Broadway 2 Front Yard : Yard Tree Private 2     24     5999603.39885 2116998.02748 37.7928489002955 -122.445318941321 (37.7928489002955, -122.445318941321) 13 9 1 29490 27
61381 223718 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1101 San Jose Ave 59 Front Yard : Yard Tree Private 2     4     6005036.87733 2096676.581 37.7373597200698 -122.42507226309 (37.7373597200698, -122.42507226309) 2 7 5 28859 2
64580 114269 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 10 Front Yard : Yard Tree Private 2     38     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
68846 223786 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 4053 20th St 7 Front Yard : Yard Tree Private 2     31 Width 3ft   6003330.94018 2104170.09947 37.7578386563428 -122.431505280044 (37.7578386563428, -122.431505280044) 2 4 5 28862 3
70213 250205 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 212 Union St 1 Front Yard : Yard Tree Private 2     13 Width 0ft   6011817.68969 2119792.01106 37.8012101599872 -122.4032533082 (37.8012101599872, -122.4032533082) 3 1 10 308 23

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