1,977 rows where qSpecies_id = 41

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)
14241 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
14256 258777 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 101 Urbano Dr 1 Sidewalk: Property side : Yard Tree Private 2       6x10   5993535 2092458 37.725120092529 -122.464533057261 (37.725120092529, -122.464533057261) 9 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
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                              
14861 176144 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 5 : Tree Private 2     39 Width 0ft   5987593.26623 2090234.31177 37.7186700965335 -122.484909687836 (37.7186700965335, -122.484909687836) 1 8 4 64 14
14966 20413 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
15055 259264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
15210 260508 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 299 Laguna Honda Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994794 2101316 37.7495144720577 -122.460822530701 (37.7495144720577, -122.460822530701) 1 8 4 29491 40
15219 251366 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 3 Sidewalk: Property side : Yard Tree Private 2                              
15397 20618 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1492X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5984803.7392562 2105036.6950477 37.7591505890295 -122.495643037613 (37.7591505890295, -122.495643037613) 1 8 3 56 35
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                    
15807 21024 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2101X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5984980.9284488 2100900.997098 37.7478054765444 -122.494725332997 (37.7478054765444, -122.494725332997) 1 8 3 29491 35
15823 20424 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
15871 21025 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2101X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5984980.9284488 2100900.997098 37.7478054765444 -122.494725332997 (37.7478054765444, -122.494725332997) 1 8 3 29491 35
15884 21428 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2692X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
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                              
15921 20422 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
15966 185572 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2201 Sunset Blvd 56 Sidewalk: Property side : Yard Tree Private 2     48 Width 0ft   5984879.9724 2099676.4789 37.7444373731189 -122.494984152016 (37.7444373731189, -122.494984152016) 1 8 3 29491 35
15978 20430 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 485X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     42 30                      
15980 262426 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
16093 19936 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
16135 21176 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2301 Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5985027.9083074 2099542.6271361 37.744078511576 -122.494462762583 (37.744078511576, -122.494462762583) 1 8 3 29491 35
16153 19978 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY45 5 Sidewalk: Curb side : Cutout Tree DPW 1     36 30ST                      
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                              
16237 261035 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601 Sunset Blvd 78 Median : Yard Tree Private 2   03/25/2020 12:00:00 AM 3 3x3   5984861 2104296 37.7571201993916 -122.495390378798 (37.7571201993916, -122.495390378798) 1 8 3 56 35
16302 21167 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2301 Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 60   5985027.9083074 2099542.6271361 37.744078511576 -122.494462762583 (37.744078511576, -122.494462762583) 1 8 3 29491 35
16465 19951 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
16556 20423 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
16638 19909 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 120ST                      
16654 261545 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Sloat Blvd 1 Median : Cutout Tree Private 2       10x10   5989483 2096058 37.7347703567949 -122.478803415035 (37.7347703567949, -122.478803415035) 1 8 3 64 35
16749 20291 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
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                              
16882 21108 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2201X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5985004.6737667 2100227.1692458 37.7459567185928 -122.494593556276 (37.7459567185928, -122.494593556276) 1 8 3 29491 35
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
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
17093 185328 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2601 Sunset Blvd 53 Sidewalk: Property side : Yard Tree Private 2     13 Width 0ft   5984973.8581 2097100.251 37.7373692412783 -122.494469646251 (37.7373692412783, -122.494469646251) 1 8 3 29491 35
17153 206856 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700 Junipero Serra Blvd 45 : Tree Private 2     26 Width 0ft   5991248.85263 2092491.97057 37.7250813121323 -122.472438427511 (37.7250813121323, -122.472438427511) 9 8 4 64 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
17791 186062 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1901 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984799.1046 2102135.8379 37.7511853667035 -122.495445120336 (37.7511853667035, -122.495445120336) 1 8 3 29491 35
17805 20377 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
17984 20373 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
18123 19934 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
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
18542 19869 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY33 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 25ST                      
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
18954 126425 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1306x Montgomery St 27 Median : Yard Tree DPW 1     13 Width 8ft   6011438.82177 2120037.47116 37.8018629670555 -122.404581652737 (37.8018629670555, -122.404581652737) 3 1 10 308 23
19208 19953 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
19225 20729 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5984865.3499442 2104298.7792234 37.7571280850658 -122.495375540207 (37.7571280850658, -122.495375540207) 1 8 3 56 35
19293 20452 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 495X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
19500 20013 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY47 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
19524 187186 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2301 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     55 Width 0ft   5984928.1673 2099176.8766 37.7430684218097 -122.494780679026 (37.7430684218097, -122.494780679026) 1 8 3 29491 35
19615 19566 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 -9 Sidewalk: Curb side : Cutout Tree DPW 1     36 100ST                      
19748 20827 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1801X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5984911.465596 2102939.293478 37.7533980132231 -122.495115810531 (37.7533980132231, -122.495115810531) 1 8 3 56 35
20192 185329 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2601 Sunset Blvd 54 Sidewalk: Property side : Yard Tree Private 2     53 Width 0ft   5984988.7228 2097068.6374 37.7372833087501 -122.494415923127 (37.7372833087501, -122.494415923127) 1 8 3 29491 35
20214 223760 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 5735 Diamond Heights Blvd 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 8ft   6000715.37701 2097028.89046 37.7380820132743 -122.440038914579 (37.7380820132743, -122.440038914579) 2 7 5 63 7
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
20255 185965 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2001 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     90 Width 0ft   5984859.6467 2101291.1753 37.7488696995369 -122.4951734814 (37.7488696995369, -122.4951734814) 1 8 3 29491 35
20535 185631 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2100 Sunset Blvd 11 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985070.6677 2100332.2816 37.7462491908887 -122.49437310833 (37.7462491908887, -122.49437310833) 1 8 3 29491 35
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
20848 186436 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     18 Width 0ft   5984750.9924 2104017.2534 37.7563483968029 -122.495750260724 (37.7563483968029, -122.495750260724) 1 8 3 56 35
20858 181423 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1500 Sunset Blvd 56 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984896.1844 2104792.2296 37.7584847680729 -122.49530529413 (37.7584847680729, -122.49530529413) 1 8 3 56 35
21002 223796 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 208 States St 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   6000981.15252 2106412.23532 37.7638615509979 -122.439792556095 (37.7638615509979, -122.439792556095) 15 5 5 28862 3
21023 223701 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1100 San Jose Ave 33 Sidewalk: Property side : Yard Tree Private 2     1 Width 9ft   6004786.9856 2096684.12369 37.7373663112035 -122.425936792158 (37.7373663112035, -122.425936792158) 2 7 5 63 7
21037 181441 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1400 Sunset Blvd 1 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5984891.7288 2105036.7347 37.759155850149 -122.495338735135 (37.759155850149, -122.495338735135) 1 8 3 56 35
21083 223779 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 731 Noe St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6003094.68244 2103994.83983 37.7573440418231 -122.432309840552 (37.7573440418231, -122.432309840552) 2 4 5 28862 3
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
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
21226 206882 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 10 Sidewalk: Property side : Yard Tree Private 2     24 Width 5ft   5996132.62288 2106470.43448 37.7637441750665 -122.456566260324 (37.7637441750665, -122.456566260324) 15 5 4 29492 12
21228 16354 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1500X Monterey Blvd 4 Median : Cutout Tree DPW 1     18 4-HOA   5993443.33225 2095241.56421 37.7327577911269 -122.465052016742 (37.7327577911269, -122.465052016742) 9 8 4 59 40
21245 184771 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1301 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     46 Width 0ft   5984696.1459 2106000.2545 37.7617899526918 -122.496086229193 (37.7617899526918, -122.496086229193) 1 8 3 56 35
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
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
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
21626 185296 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2601 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     31 Width 0ft   5984977.9407 2097354.1023 37.7380664878554 -122.494474238626 (37.7380664878554, -122.494474238626) 1 8 3 29491 35
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
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
21700 206891 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1675x 15th Ave 1 Sidewalk: Property side : Cutout Tree DPW 1     24 Width 3ft   5991393.55964 2103864.47578 37.7563156787487 -122.472767037095 (37.7563156787487, -122.472767037095) 1 8 4 56 12
21805 119401 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3150 Cabrillo St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5985750.26334 2110481.7384 37.7741565341725 -122.492770599571 (37.7741565341725, -122.492770599571) 11 6 2 55 26
21901 12497 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 42 Sidewalk: Curb side : Cutout Tree PUC 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
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
22073 185991 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2001 Sunset Blvd 50 Sidewalk: Property side : Yard Tree Private 2     49 Width 0ft   5984838.2048 2101005.2084 37.7480832572577 -122.495226540797 (37.7480832572577, -122.495226540797) 1 8 3 29491 35
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
22522 176121 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3500 Great Hwy 8 Median : Tree Private 2     6 Width 0ft   5982310.61133 2092790.70938 37.7253801793381 -122.503358567347 (37.7253801793381, -122.503358567347) 1 8 4   14
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
22778 120919 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 198X Miraloma Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x10   5994595 2096392 37.7359829456919 -122.461153801837 (37.7359829456919, -122.461153801837) 9 8 4 59 40
22973 8585 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2200 Geary Blvd 12 Median : Cutout Tree DPW 1   06/01/1994 12:00:00 AM 6 6   6000465.007 2113386.3901 37.7829814273003 -122.442078382069 (37.7829814273003, -122.442078382069) 15 5 1 29490 41
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
23160 21117 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2201X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985004.6737667 2100227.1692458 37.7459567185928 -122.494593556276 (37.7459567185928, -122.494593556276) 1 8 3 29491 35
23219 110906 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2891 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2015 12:00:00 AM 3 3x10 Permit Number 775210 5999784.05969 2117390.40958 37.7939365889551 -122.444722064898 (37.7939365889551, -122.444722064898) 13 9 1 57 27
23335 186596 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1501 Sunset Blvd 67 Sidewalk: Property side : Yard Tree Private 2     67 Width 0ft   5984749.6315 2104462.0427 37.7575695849924 -122.495787775902 (37.7575695849924, -122.495787775902) 1 8 3 56 35

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