trees

1,977 rows where qSpecies_id = 41 sorted by DBH

✎ 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)
16810 254987 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 850 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       10x10   5991239 2091717 37.7229528649662 -122.472416015965 (37.7229528649662, -122.472416015965) 9 8 4 64 40
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                              
17009 258662 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10X Mendosa Ave 9 Median : Cutout Tree Private 2       3x3   5993533 2101170 37.749040957039 -122.465172468022 (37.749040957039, -122.465172468022) 1 8 4 29491 40
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                              
17641 262215 Landmark tree 11 Cupressus macrocarpa :: Monterey Cypress 41 2626 Vallejo St 1 Back Yard : Yard Tree Private 2       3x3   6001000 2117623 37.7946445343139 -122.440531492639 (37.7946445343139, -122.440531492639) 13 9 1 57 27
17725 258661 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10X Mendosa Ave 8 Median : Cutout Tree Private 2       3x3   5993533 2101170 37.749040957039 -122.465172468022 (37.749040957039, -122.465172468022) 1 8 4 29491 40
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                              
18711 262449 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 155 Baker St 1 Side Yard : Yard Tree Private 2       10x10   6000750.251 2109577.8851 37.7725404908768 -122.440818271359 (37.7725404908768, -122.440818271359) 15 5 11 29492 9
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
21096 253953 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 11X Ravenwood Dr 2 Sidewalk: Curb side : Yard Tree Private 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 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
21554 256452 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 2901 Sunset Blvd 1 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
21615 254127 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100X Lake Merced Blvd 1 Median : Yard Tree DPW 1       10x10   5983894 2095251 37.7322284370415 -122.498066633405 (37.7322284370415, -122.498066633405) 1 8 4 64 35
21695 112187 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 301x CORBETT AVE 3 Sidewalk: Property side : Yard Tree DPW 1       3x3   5999677 2105220 37.760513648973 -122.444217531177 (37.760513648973, -122.444217531177) 15 5 5 28862 3
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
22321 256538 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 19 Miguel St 1 Back Yard : Yard Tree Private 2       3x3   6003470 2097467 37.7394413932778 -122.430546066859 (37.7394413932778, -122.430546066859) 2 7 5 63 7
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
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
24231 93107 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 15 Mesa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM   3x3 Permit Number 53163 5993680.1 2100698.2 37.7477539957997 -122.464629544553 (37.7477539957997, -122.464629544553) 1 8 4 29491 40
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
24607 258657 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10X Mendosa Ave 1 Median : Cutout Tree Private 2       3x3   5993533 2101170 37.749040957039 -122.465172468022 (37.749040957039, -122.465172468022) 1 8 4 29491 40
25399 252916 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 101 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001472 2098865 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716) 2 7 5 63 7
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
27394 251152 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
27900 251155 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
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
30295 251424 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 5016 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
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
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
33711 92561 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 222 Stanyan St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52905 5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
34251 253786 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1675X 15th Ave 2 Median : Cutout Tree DPW 1       3x3   5991390 2103897 37.7564047756354 -122.47278171886 (37.7564047756354, -122.47278171886) 1 8 4 56 12
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
37154 254306 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 170 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
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
40021 253329 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 24 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
40198 253709 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Monument Way 3 Unaccepted Street : Yard Tree Private 2       10x10   5999088 2105836 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118) 15 5 5 29492 3
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
40974 253789 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1651X 15th Ave 1 Median : Cutout Tree DPW 1       3x2   5991453 2104016 37.7567351651282 -122.472572520554 (37.7567351651282, -122.472572520554) 1 8 4 56 12
41003 116084 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 127 Edgehill Way 1 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 773426 5994851.1 2098962.7 37.7430561859317 -122.460454581583 (37.7430561859317, -122.460454581583) 1 8 4 59 40
41976 251677 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 772x Panorama Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5996636 2102785 37.7536537924326 -122.454558985212 (37.7536537924326, -122.454558985212) 1 5 4 63 38
42203 251150 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
42325 92565 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 222 Stanyan St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52905 5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
42360 92562 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 222 Stanyan St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52905 5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
42469 251630 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 2 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
42627 109678 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 200X VIDAL DR 7 Median : Yard Tree DPW 1           5987624 2090693 37.7199313280832 -122.484837086298 (37.7199313280832, -122.484837086298) 1 8 4 64 14
43971 251151 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
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
46030 251147 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 113x Gladeview Way 1 Back Yard : Yard Tree Private 2       3x3   5997915 2102038 37.7516759885035 -122.450082102397 (37.7516759885035, -122.450082102397) 1 5 4 63 38
46183 258665 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10X Mendosa Ave 12 Median : Cutout Tree Private 2       3x3   5993533 2101170 37.749040957039 -122.465172468022 (37.749040957039, -122.465172468022) 1 8 4 29491 40
46465 253979 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 441 Detroit St 3 Unaccepted Street : Yard Tree DPW 1       10x10   5999396 2094599 37.7313349085161 -122.444426062201 (37.7313349085161, -122.444426062201) 9 7 4 59 40
46471 253626 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1671 Funston Ave 1 Back Yard : Yard Tree Private 2       10x10   5992125 2104081 37.7569525124502 -122.470253253306 (37.7569525124502, -122.470253253306) 1 8 4 56 12
46823 103516 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 1 Back Yard : Yard Tree Private 2           6008298 2118971 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445) 5 1 10 308 32
47216 112606 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 100X Monument Way 1 Back Yard : Yard Tree Private 2       10x10   5999003 2105766 37.7619743535119 -122.446587863076 (37.7619743535119, -122.446587863076) 15 5 5 29492 9
47800 255367 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Brotherhood Way 2 Median : Cutout Tree DPW 1       14x10   5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
48834 85239 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 200 Yerba Buena Ave 2 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
49071 173652 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 65 ZIRCON PL 2 Sidewalk: Property side : Yard Tree Private 2           6002398.2 2098694.7 37.7427515964219 -122.434339626982 (37.7427515964219, -122.434339626982) 2 7 5 63 7
49170 99447 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601X 15th Ave 5 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
49363 87064 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 101 Arbor St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2007 12:00:00 AM     Permit Number 50006 6001805 2096722 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043) 2 7 5 63 7
49414 254986 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 866 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       10x10   5991230 2091572 37.7225542099511 -122.472436561116 (37.7225542099511, -122.472436561116) 9 8 4 64 40
49646 251627 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2R Amethyst Way 2 Back Yard : Yard Tree Private 2           5999263 2100016 37.7462011119367 -122.44527519505 (37.7462011119367, -122.44527519505) 2 7 5 63 22
49738 258660 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10X Mendosa Ave 7 Median : Cutout Tree Private 2       3x3   5993533 2101170 37.749040957039 -122.465172468022 (37.749040957039, -122.465172468022) 1 8 4 29491 40
49941 109676 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 200X VIDAL DR 5 Median : Yard Tree DPW 1           5987624 2090693 37.7199313280832 -122.484837086298 (37.7199313280832, -122.484837086298) 1 8 4 64 14
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
52672 251603 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 44R Amber Dr 2 Back Yard : Yard Tree Private 2           5999509 2100035 37.7462673204657 -122.444425925791 (37.7462673204657, -122.444425925791) 2 7 5 63 22
55368 109658 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 29 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
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
56525 122494 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 69x Bonview St 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
56935 114710 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 500X CONGO ST 4 Sidewalk: Property side : Yard Tree Private 2       3x10   6000185 2095264 37.733205830187 -122.441746059696 (37.733205830187, -122.441746059696) 9 7 5 63 40
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
57789 121199 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 72 Fountain St 1 Back Yard : Yard Tree Private 2           6000322 2101283 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556) 2 4 5 28862 22
59933 122637 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630X 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x8   5990614 2091411 37.7220764711857 -122.47455416919 (37.7220764711857, -122.47455416919) 9 8 4 64 40
60213 254988 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 870 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       10x10   5991228 2091536 37.7224552471007 -122.472440851401 (37.7224552471007, -122.472440851401) 9 8 4 64 40
60957 114709 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 500X CONGO ST 3 Sidewalk: Property side : Yard Tree Private 2       3x10   6000185 2095264 37.733205830187 -122.441746059696 (37.733205830187, -122.441746059696) 9 7 5 63 40
61064 253428 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3 Valletta Ct 1 Side Yard : Cutout Tree Private 2       6x10 Permit Number 780575 5999319 2096479 37.7364925519579 -122.444827352142 (37.7364925519579, -122.444827352142) 9 7 4 63 40
61118 115331 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2601X Sunset Blvd 26 Median : Cutout Tree DPW 1       40   5985098.343425 2097506.3093477 37.7384914535226 -122.494069167367 (37.7384914535226, -122.494069167367) 1 8 3 29491 35
61865 253368 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 236 Moncada Way 1 Median : Yard Tree DPW 1       10x10   5992398 2093455 37.7277919980392 -122.468536018982 (37.7277919980392, -122.468536018982) 9 8 4 59 40
62262 251148 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
62852 253330 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 25 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
63950 254128 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100X Lake Merced Blvd 2 Median : Yard Tree DPW 1       10x10   5983894 2095251 37.7322284370415 -122.498066633405 (37.7322284370415, -122.498066633405) 1 8 4 64 35
64227 251624 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 76R Amber Dr 2 Back Yard : Yard Tree Private 2           5999293 2100015 37.7462000785932 -122.44517138727 (37.7462000785932, -122.44517138727) 2 7 5 63 22
65119 258667 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10X Mendosa Ave 14 Median : Cutout Tree Private 2       3x3   5993533 2101170 37.749040957039 -122.465172468022 (37.749040957039, -122.465172468022) 1 8 4 29491 40
66378 251374 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 401 Portola Dr 2 Median : Yard Tree DPW 1           5998962 2100210 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078) 2 7 5 63 22
66603 254984 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 830 Junipero Serra Blvd 1 Median : Yard Tree Private 2       10x10   5991251 2091898 37.7234505406642 -122.472387723412 (37.7234505406642, -122.472387723412) 9 8 4 64 40
67763 258658 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10X Mendosa Ave 5 Median : Cutout Tree Private 2       3x3   5993533 2101170 37.749040957039 -122.465172468022 (37.749040957039, -122.465172468022) 1 8 4 29491 40
69281 122640 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630X 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2       3x8   5990614 2091411 37.7220764711857 -122.47455416919 (37.7220764711857, -122.47455416919) 9 8 4 64 40
70051 251378 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 401 Portola Dr 6 Median : Yard Tree DPW 1           5998962 2100210 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078) 2 7 5 63 22
70978 253291 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 650 Peru Ave 7 Front Yard : Yard Tree Private 2           6005101.95698 2092563.19401 37.7260689503102 -122.424554741032 (37.7260689503102, -122.424554741032) 9 7 6 28861 5
71227 253306 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
72041 253876 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 56x Ellsworth St 1 Side Yard : Yard Tree DPW 1       3x3   6008136 2098387 37.7422307347858 -122.414478117675 (37.7422307347858, -122.414478117675) 2 7 7 28859 2

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