trees

1,977 rows where qSpecies_id = 41 sorted by PlotSize

✎ 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)
106 251438 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Santiago St 1 Median : Yard Tree DPW 1                              
251 187669 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 554 Valley St 1 Median : Yard Tree Private 2           6002324 2099197 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307) 2 7 5 63 22
394 119605 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 299x Avalon Ave 1 Front Yard : Yard Tree Private 2                              
537 261951 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 5 Sidewalk: Property side : Yard Tree DPW 1                              
595 261954 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 8 Sidewalk: Property side : Yard Tree DPW 1                              
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
945 217846 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Woodacre Dr 1 Sidewalk: Curb side : Yard Tree Private 2     54     5991427.31798 2095733.50913 37.7339920935414 -122.472057659936 (37.7339920935414, -122.472057659936) 1 8 4 64 40
1051 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
2644 113698 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 80 LINARES AVE 1 Sidewalk: Curb side : Yard Tree DPW 1           5994154.8 2102090.7 37.7516048020548 -122.463089089164 (37.7516048020548, -122.463089089164) 1 8 4 29491 40
2744 261957 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 11 Sidewalk: Property side : Yard Tree DPW 1                              
2858 261960 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 14 Sidewalk: Property side : Yard Tree DPW 1                              
3038 248184 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 216 Esmeralda Ave 3 Side Yard : Yard Tree Private 2     28     6007432.52043 2098714.89498 37.7430915158666 -122.416933765486 (37.7430915158666, -122.416933765486) 2 7 7 28859 2
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
4154 261966 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 20 Sidewalk: Property side : Yard Tree DPW 1                              
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
5439 247017 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 500 Valley St 9 Sidewalk: Property side : Yard Tree Private 2     40     6002542.70295 2099187.51886 37.7441129631509 -122.433875195085 (37.7441129631509, -122.433875195085) 2 7 5 63 22
6028 261967 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 299x Portola Dr 1 Median : Yard Tree DPW 1                              
6724 261948 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 2 Sidewalk: Property side : Yard Tree DPW 1                              
7781 102468 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 50 Saint Germain Ave 1 Sidewalk: Property side : Yard Tree Private 2           5998217.7 2104179.8 37.7575741573713 -122.449189617767 (37.7575741573713, -122.449189617767) 15 5 4 28862 38
7813 206807 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 11x Saint Francis Blvd 1 Median : Yard Tree DPW 1     12     5991689.22153 2095992.93147 37.7347195542573 -122.471171081279 (37.7347195542573, -122.471171081279) 9 8 4 59 40
8535 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
8755 5050 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 5399X Diamond Heights Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     19     6001979.62541 2098516.88417 37.7422395880754 -122.43577421703 (37.7422395880754, -122.43577421703) 2 7 5 63 22
9183 261965 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 19 Sidewalk: Property side : Yard Tree DPW 1                              
9448 251375 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 401 Portola Dr 3 Median : Yard Tree DPW 1           5998962 2100210 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078) 2 7 5 63 22
9662 113066 - 12 Cupressus macrocarpa :: Monterey Cypress 41 2X Cranleigh Dr 7 : Tree DPW 1   09/09/2015 01:08:00 PM 3     5991370.3 2095943.7 37.7345659248964 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
9705 261963 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 17 Sidewalk: Property side : Yard Tree DPW 1                              
9730 190968 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 8 Sidewalk: Curb side : Yard Tree Private 2     39     6011276.3148 2104337.18505 37.7587445605265 -122.404038467608 (37.7587445605265, -122.404038467608) 10 3 8 28856 29
9757 261950 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 4 Sidewalk: Property side : Yard Tree DPW 1                              
9922 261964 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 18 Sidewalk: Property side : Yard Tree DPW 1                              
10140 106278 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 200X VIDAL DR 2 Median : Cutout Tree DPW 1     60     5987624 2090693 37.7199313280832 -122.484837086298 (37.7199313280832, -122.484837086298) 1 8 4 64 14
12058 253308 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 6 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
12287 95982 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 100 Vasquez Ave 1 Back Yard : Yard Tree Private 2           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972) 1 8 4 59 40
12448 261958 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 12 Sidewalk: Property side : Yard Tree DPW 1                              
12495 126414 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2836 Larkin St 10 Side Yard : Yard Tree Private 2     12     6006501.05561 2120998.53971 37.8042246191233 -122.421736962694 (37.8042246191233, -122.421736962694) 5 9 1 28858 32
12505 205919 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 230 Edna St 2 Side Yard : Yard Tree Private 2     34     5998797.1475 2095343.94395 37.7333461617934 -122.446549972916 (37.7333461617934, -122.446549972916) 9 7 4 59 40
13027 261955 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 9 Sidewalk: Property side : Yard Tree DPW 1                              
13121 261953 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 7 Sidewalk: Property side : Yard Tree DPW 1                              
13162 251365 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 2 Sidewalk: Property side : Yard Tree Private 2                              
13568 217777 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 470 West Portal Ave 16 Sidewalk: Curb side : Yard Tree Private 2     29     5991442.94255 2096087.95113 37.7349662059076 -122.472029467093 (37.7349662059076, -122.472029467093) 1 8 4 29491 40
13593 247903 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 582 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     31     6009830.823 2098729.70619 37.7432667982256 -122.408642088157 (37.7432667982256, -122.408642088157) 10 7 7 28859 2
13718 251364 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 1 Sidewalk: Property side : Yard Tree Private 2                              
13759 190995 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10x Cashmere St 3 Median : Yard Tree DPW 1     28     6017237.22965 2095860.87095 37.7358015834667 -122.382832806316 (37.7358015834667, -122.382832806316) 10 3 8 58 1
13937 253313 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 11 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
13998 206803 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 300 Ortega St 1 Sidewalk: Curb side : Yard Tree Private 2     28     5993087.14993 2102582.23712 37.7528928770087 -122.466816856226 (37.7528928770087, -122.466816856226) 1 8 4 56 12
14194 261962 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 16 Sidewalk: Property side : Yard Tree DPW 1                              
14241 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
14832 261961 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 15 Sidewalk: Property side : Yard Tree DPW 1                              
15219 251366 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 3 Sidewalk: Property side : Yard Tree Private 2                              
15485 263628 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 192 Mangels Ave 5 Sidewalk: Property side : Yard Tree Private 2           6000206.52297 2095259.24719 37.7331940064051 -122.441671308196 (37.7331940064051, -122.441671308196) 9 7 5 63 40
15603 251321 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Monument Way 1 Unaccepted Street : Yard Tree Private 2                              
15795 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
15891 261952 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 6 Sidewalk: Property side : Yard Tree DPW 1                              
16181 263627 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 192 Mangels Ave 4 Sidewalk: Property side : Yard Tree Private 2           6000206.52297 2095259.24719 37.7331940064051 -122.441671308196 (37.7331940064051, -122.441671308196) 9 7 5 63 40
16212 261956 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 10 Sidewalk: Property side : Yard Tree DPW 1                              
16814 261949 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 3 Sidewalk: Property side : Yard Tree DPW 1                              
16989 106642 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 4540X 17TH ST 1 Sidewalk: Property side : Yard Tree Private 2     24     5999139 2105833 37.7621660862312 -122.446122313424 (37.7621660862312, -122.446122313424) 15 5 5 29492 3
17534 261947 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 1 Sidewalk: Property side : Yard Tree DPW 1                              
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
18620 261959 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 13 Sidewalk: Property side : Yard Tree DPW 1                              
20228 251632 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 14R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999202 2100044 37.7462745109784 -122.445488137723 (37.7462745109784, -122.445488137723) 2 7 5 63 22
21130 206819 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2187x 09th Ave 11 Median : Yard Tree DPW 1     9     5993645.71889 2101030.10757 37.7486633474324 -122.46477253084 (37.7486633474324, -122.46477253084) 1 8 4 29491 40
21438 99445 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601X 15th Ave 2 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
21455 253336 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 31 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
21566 176163 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 654 Peru Ave 1 Side Yard : Yard Tree Private 2     23     6005125.75661 2092550.72712 37.7260360630077 -122.424471580706 (37.7260360630077, -122.424471580706) 9 7 6 28861 5
21639 190969 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 9 Sidewalk: Curb side : Yard Tree Private 2     14     6011271.58164 2104330.23228 37.7587252053147 -122.404054347838 (37.7587252053147, -122.404054347838) 10 3 8 28856 29
21932 85238 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 200 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2007 12:00:00 AM     Permit Number 49542 5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 40
22040 251614 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 64R Amber Dr 1 Back Yard : Yard Tree Private 2           5999367 2100045 37.7462866749207 -122.444917661566 (37.7462866749207, -122.444917661566) 2 7 5 63 22
22642 253769 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 Raccoon Dr 2 Back Yard : Yard Tree Private 2           5998692 2104165 37.7575606372552 -122.447548237739 (37.7575606372552, -122.447548237739) 15 5 5 28862 3
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
23773 205912 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 198 Mangels Ave 3 Sidewalk: Property side : Yard Tree Private 2     53     6000155.51959 2095259.25814 37.7331911303498 -122.441847640961 (37.7331911303498, -122.441847640961) 9 7 5 63 40
24205 253319 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 17 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
24522 253316 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 14 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
24527 114055 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 700X LAKE MERCED BLVD 1 Median : Cutout Tree Private 2     50     5987837 2092819 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
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
26063 253321 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 19 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
26787 251634 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 14R Amethyst Way 3 Back Yard : Yard Tree Private 2           5999202 2100044 37.7462745109784 -122.445488137723 (37.7462745109784, -122.445488137723) 2 7 5 63 22
27160 111763 Landmark tree 11 Cupressus macrocarpa :: Monterey Cypress 41 2626 Vallejo St 1 Back Yard : Yard Tree Private 2           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268) 13 9 1 57 27
28931 111586 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 730X Lake Merced Blvd 2 Sidewalk: Property side : Yard Tree DPW 1     48     5987577.49507 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397) 1 8 4 64 14
29166 249716 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2975 Broadway 5 Back Yard : Yard Tree Private 2     7     5999444.23089 2116975.86958 37.7927789735145 -122.44586807365 (37.7927789735145, -122.44586807365) 13 9 1 29490 27
30007 114128 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 21 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
30200 98503 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 208 Glenview Dr   Back Yard : Yard Tree Private 2           5998871 2100779 37.7482737407191 -122.446685565827 (37.7482737407191, -122.446685565827) 2 5 5 63 38
30463 99864 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 681 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768887 5981306.2 2111092.9 37.7755737343962 -122.508188499048 (37.7755737343962, -122.508188499048) 11 6 2 55 26
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
30966 112739 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 444 Franconia St 3 Unaccepted Street : Yard Tree Private 2     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.408218103257 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
31495 251620 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 72R Amber Dr 3 Back Yard : Yard Tree Private 2           5999318 2100030 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875) 2 7 5 63 22
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
33268 5047 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 5399X Diamond Heights Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     30     6002007.86459 2098449.21717 37.7420553943514 -122.43567173476 (37.7420553943514, -122.43567173476) 2 7 5 63 22
33593 190974 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 22 Sidewalk: Curb side : Yard Tree Private 2     20     6011278.73233 2104250.41369 37.7585064407439 -122.404024000205 (37.7585064407439, -122.404024000205) 10 3 8 28856 29
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
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
35357 251625 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 76R Amber Dr 3 Back Yard : Yard Tree Private 2           5999293 2100015 37.7462000785932 -122.44517138727 (37.7462000785932, -122.44517138727) 2 7 5 63 22
35560 98376 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 199X Cragmont Ave 1 Unaccepted Street : Yard Tree Private 2           5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
36956 251618 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 72R Amber Dr 1 Back Yard : Yard Tree Private 2           5999318 2100030 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875) 2 7 5 63 22
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
37147 201718 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Hawkins Ln 3 Side Yard : Yard Tree Private 2     14     6017093.28201 2095356.32471 37.7344082458391 -122.383295385174 (37.7344082458391, -122.383295385174) 10 3 8 58 1
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
37713 87116 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 470 West Portal Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2008 12:00:00 AM     Permit Number 50062 5991694 2096460 37.7360022829337 -122.471188578306 (37.7360022829337, -122.471188578306) 1 8 4 29491 40
39021 126416 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2836 Larkin St 12 Side Yard : Yard Tree Private 2     46     6006501.51207 2121012.26216 37.8042623232049 -122.421736358356 (37.8042623232049, -122.421736358356) 5 9 1 28858 32

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