trees

1,977 rows where qSpecies_id = 41 sorted by PermitNotes descending

✎ 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)
191057 100769 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3701 21st St   Front Yard : Yard Tree Private 2     55   Street tree w/in RoW 6003717 2103606 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292) 2 4 5 28862 22
49827 53726 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 Topeka Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/1972 12:00:00 AM 8   Permit Number 9405 6012451.87174 2095251.14558 37.7338618519323 -122.399334980939 (37.7338618519323, -122.399334980939) 10 3 8 58 1
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
2599 122257 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300 Clement St 1 Sidewalk: Property side : Yard Tree Private 2   09/16/2019 12:00:00 AM 3 Width 3ft Permit Number 784386 5991472.52373 2113448.553 37.7826355430647 -122.473192897736 (37.7826355430647, -122.473192897736) 11 6 2 54 26
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
146280 255793 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 441 Detroit St 1 Unaccepted Street : Yard Tree Private 2       30x30 Permit Number 782172 5999396 2094599 37.7313349085161 -122.444426062201 (37.7313349085161, -122.444426062201) 9 7 4 59 40
169555 253449 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 330 Twin Peaks Blvd 1 Unaccepted Street : Yard Tree Private 2       10x10 Permit Number 780692 5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
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
94784 253250 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Lopez Ave 1 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
144280 253255 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 270 Castenada Ave 2 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 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                    
8535 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
14241 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
15795 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
116862 2287 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Brotherhood Way 2 Median : Cutout Tree DPW 1   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989126.18342 2088688.61813 37.7145151729252 -122.47949804711 (37.7145151729252, -122.47949804711) 1 8 4 64 14
139557 2290 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Brotherhood Way 5 Median : Cutout Tree DPW 1   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5991856 2088020 37.7128374968227 -122.470014135427 (37.7128374968227, -122.470014135427) 9 8 6 64 24
151272 2289 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Brotherhood Way 4 Median : Cutout Tree DPW 1   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5991856 2088020 37.7128374968227 -122.470014135427 (37.7128374968227, -122.470014135427) 9 8 6 64 24
2175 121189 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1000x Duncan St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
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
82162 109453 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 951 GILMAN AVE 1 Front Yard : Yard Tree Rec/Park 5   03/24/2015 12:00:00 AM 3   Permit Number 774986 6015934 2089205 37.7174537876507 -122.386874585955 (37.7174537876507, -122.386874585955) 10 3 8 58 1
72776 111589 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 730X Lake Merced Blvd 5 Front Yard : Yard Tree DPW for City Agency 14 DPW       Permit Number 774260 5987577.49507 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397) 1 8 4 64 14
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
164851 103422 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1365 Portola Dr 1 Front Yard : Yard Tree Private 2         Permit Number 769779 5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
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
101121 98820 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 302X Pacheco St 28 Median : Cutout Tree Private 2   05/09/2010 12:00:00 AM     Permit Number 768820 5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
162399 99047 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 240@Casitas Lansdale Ave 1 Sidewalk: Property side : Cutout Tree Private 2     42   Permit Number 768724 5994955.6 2096712.9 37.7368848033667 -122.459930310697 (37.7368848033667, -122.459930310697) 9 7 4 59 40
161675 98378 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 199X Cragmont Ave 3 Unaccepted Street : Yard Tree Private 2         Permit Number 768647 5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
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
186871 95072 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 19 Miguel St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 54021 6003434 2097382 37.7392059633181 -122.430664475135 (37.7392059633181, -122.430664475135) 2 7 5 63 7
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
98332 93204 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 400 Masonic Ave 1 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
158156 93206 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 400 Masonic Ave 4 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
180298 93203 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 400 Masonic Ave 2 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
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
123457 41202 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 79 Midcrest Way 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 53043 5998096.00481154 2100748.3020607 37.7481451508808 -122.449363253994 (37.7481451508808, -122.449363253994) 1 5 4 63 38
5238 92559 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 222 Stanyan St 1 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
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
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
130426 92563 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 222 Stanyan St 5 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
162467 92564 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 222 Stanyan St 6 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
193880 92560 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 222 Stanyan St 2 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
87390 91152 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 166 Kensington Way 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52026 5994670.3 2098755.2 37.7424760401064 -122.461064697802 (37.7424760401064, -122.461064697802) 1 8 4 59 40
118832 91138 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 166 Kensington Way 1 Sidewalk: Curb side : Yard Tree Private 2       3x3 Permit Number 52026 5994670.3 2098755.2 37.7424760401064 -122.461064697802 (37.7424760401064, -122.461064697802) 1 8 4 59 40
144947 91139 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 166 Kensington Way 2 Sidewalk: Curb side : Yard Tree Private 2       3x3 Permit Number 52026 5994670.3 2098755.2 37.7424760401064 -122.461064697802 (37.7424760401064, -122.461064697802) 1 8 4 59 40
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
142043 97731 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1150 Francisco St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3 Permit Number 50638 6005778.11415 2120709.05822 37.8033889834786 -122.424218159845 (37.8033889834786, -122.424218159845) 5 9 1 28858 32
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
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
87265 86903 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 233 Drake St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2007 12:00:00 AM   3x3 Permit Number 49863 6001780 2086418 37.7090074518569 -122.435599089406 (37.7090074518569, -122.435599089406) 9 7 6 28861 5
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
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
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
191822 40713 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 2 Crown Ter 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41692 5998528.84920016 2104703.4154957 37.7590296670037 -122.448151244492 (37.7590296670037, -122.448151244492) 15 5 5 28862 12
80 260998 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree SFUSD 4       10x10                      
106 251438 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Santiago St 1 Median : Yard Tree DPW 1                              
172 176155 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900X Brotherhood Way 9 Median : Cutout Tree DPW 1     25 10x10   5988860 2088745 37.7146545182747 -122.480422197946 (37.7146545182747, -122.480422197946) 1 8 4 64 14
190 21328 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     70 60   5985074.8907349 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189) 1 8 3 29491 35
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                              
464 173918 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2160X 09th Ave 6 Median : Cutout Tree DPW 1       6x10   5993671 2100995 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698) 1 8 4 29491 40
509 19905 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 120ST                      
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
657 20296 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
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
720 19950 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
795 19570 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 4 Sidewalk: Curb side : Cutout Tree DPW 1     48 100ST                      
838 264883 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1624 48th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
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
1127 263624 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
1336 185523 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2201 Sunset Blvd 7 Sidewalk: Property side : Yard Tree Private 2     60 Width 0ft   5984870.0228 2100148.4874 37.7457327977456 -122.495053353322 (37.7457327977456, -122.495053353322) 1 8 3 29491 35
1728 262141 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 420X Portola Dr 2 Median : Yard Tree DPW 1 Private     3x3   5998701 2100185 37.7466330487878 -122.44723067426 (37.7466330487878, -122.44723067426) 2 7 5 63 22
1873 20545 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1303X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree DPW 1     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
2239 253844 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 150 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       3x3   5991384 2095197 37.7325164679088 -122.472168327848 (37.7325164679088, -122.472168327848) 1 8 4 64 40
2282 19424 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1000X Sloat Blvd 1 Median : Cutout Tree DPW 1     24 20   5988569.2838063 2095968.4634055 37.7344714144349 -122.481955851921 (37.7344714144349, -122.481955851921) 1 8 3 64 35
2302 19935 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
2418 20917 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1901X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5984934.4009631 2102260.4913733 37.7515355521167 -122.494986448304 (37.7515355521167, -122.494986448304) 1 8 3 29491 35
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
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
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                              
2750 206896 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Pizarro Way 4 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5995094.72754 2093951.90742 37.7293117922974 -122.459249411033 (37.7293117922974, -122.459249411033) 9 7 4 28861 40
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                              
3011 19948 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 25ST                      
3028 19906 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
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
3052 19908 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
3078 19568 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 2 Sidewalk: Curb side : Cutout Tree DPW 1     48 100ST                      
3098 20419 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
3191 19565 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 -11 Sidewalk: Curb side : Cutout Tree DPW 1     36 100ST                      
3441 184824 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1201 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5984678.6788 2106921.0739 37.7643172410191 -122.496214581481 (37.7643172410191, -122.496214581481) 1 8 3 56 35
3442 20392 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 38 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
3453 21247 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2401X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985051.1945321 2098862.1753589 37.7422115377949 -122.494332098234 (37.7422115377949, -122.494332098234) 1 8 3 29491 35
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
3683 20906 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1901X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5984934.4009631 2102260.4913733 37.7515355521167 -122.494986448304 (37.7515355521167, -122.494986448304) 1 8 3 29491 35
4012 186763 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1200 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     28 Width 0ft   5984864.2659 2106722.4222 37.7637826685387 -122.495558044528 (37.7637826685387, -122.495558044528) 1 8 3 56 35
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                              
4254 254282 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 80X Junipero Serra Blvd 6 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
4324 8533 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2100 Geary Blvd 4 Median : Cutout Tree DPW 1     18 6   6001504.6387 2113566.4305 37.783534963845 -122.438494596028 (37.783534963845, -122.438494596028) 15 5 11 29490 41

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