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)
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                              
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
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                              
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
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
1051 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
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
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
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
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
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                              
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                              
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
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
5408 261480 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1000 Portola Dr 9 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
5792 260568 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 2 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
6028 261967 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 299x Portola Dr 1 Median : Yard Tree DPW 1                              
6226 261544 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Sloat Blvd 1 Median : Cutout Tree Private 2       10x10   5989247 2095899 37.7343200773404 -122.47960770916 (37.7343200773404, -122.47960770916) 1 8 4 64 35
6580 261206 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2301 Leavenworth St 1 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
6686 113093 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 598x ARBOR ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6000747 2096921 37.7377875715629 -122.439921844785 (37.7377875715629, -122.439921844785) 2 7 5 63 7
6706 255369 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Brotherhood Way 4 Median : Cutout Tree DPW 1       14x10   5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
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                              
6786 262148 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 420X Portola Dr 9 Median : Yard Tree DPW 1 Private     3x3   5998701 2100185 37.7466330487878 -122.44723067426 (37.7466330487878, -122.44723067426) 2 7 5 63 22
6858 261031 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 150 Chestnut St 1 Front Yard : Yard Tree Private 2       3x3   6011107 2121175 37.8049677916951 -122.405810090856 (37.8049677916951, -122.405810090856) 3 1 10 308 23
7257 260076 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 43 Rockwood Ct 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995749 2098768 37.7425732008551 -122.457335823598 (37.7425732008551, -122.457335823598) 1 8 4 59 40
7275 261458 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 701X Delano Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5999135 2090407 37.7198097539444 -122.445027136249 (37.7198097539444, -122.445027136249) 9 7 6 28861 25
7536 262249 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 4210 Ocean Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
7598 114708 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 500X CONGO ST 2 Sidewalk: Property side : Yard Tree Private 2       3x10   6000185 2095264 37.733205830187 -122.441746059696 (37.733205830187, -122.441746059696) 9 7 5 63 40
7637 263625 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
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
8040 260572 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 6 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
8535 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
8619 262142 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 420X Portola Dr 3 Median : Yard Tree DPW 1 Private     3x3   5998701 2100185 37.7466330487878 -122.44723067426 (37.7466330487878, -122.44723067426) 2 7 5 63 22
8751 262427 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
8932 254133 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100X Lake Merced Blvd 7 Median : Yard Tree DPW 1       10x10   5983894 2095251 37.7322284370415 -122.498066633405 (37.7322284370415, -122.498066633405) 1 8 4 64 35
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                              
9303 259269 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
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
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                              
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                              
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
10088 253978 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 441 Detroit St 1 Unaccepted Street : Yard Tree Private 2       3x10   5999396 2094599 37.7313349085161 -122.444426062201 (37.7313349085161, -122.444426062201) 9 7 4 59 40
10143 256870 Planning Code 138.1 required 2 Cupressus macrocarpa :: Monterey Cypress 41 30X Bernal Heights Blvd 1 Back Yard : Cutout Tree Private 2       12x6                      
10153 262205 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2 Lois Ln 1 Back Yard : Yard Tree Private 2       3x3   6012244 2087959 37.7138275196569 -122.39954186434 (37.7138275196569, -122.39954186434) 10 3 8 309 1
10387 261604 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300X Sloat Blvd 5 Median : Yard Tree Private 2       3x3   5987403 2095938 37.7343198717706 -122.485985793061 (37.7343198717706, -122.485985793061) 1 8 3 64 35
10395 260478 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3333 California St 8 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
10397 261602 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Sloat Blvd 2 Median : Cutout Tree Private 2       10x10   5989247 2095899 37.7343200773404 -122.47960770916 (37.7343200773404, -122.47960770916) 1 8 4 64 35
10605 260507 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 50X Carver St 1 Median : Cutout Tree DPW 1 Private     3x3   6009420 2098346 37.742190207281 -122.410035530349 (37.742190207281, -122.410035530349) 10 7 7 28859 2
11014 262425 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
11254 259267 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
11407 260477 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3333 California St 7 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
11442 260571 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 5 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11463 260828 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 165 Cerritos Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5991854 2092943 37.7263547341381 -122.470379348754 (37.7263547341381, -122.470379348754) 9 8 4 59 40
11583 261603 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300X Sloat Blvd 4 Median : Yard Tree Private 2       3x3   5987403 2095938 37.7343198717706 -122.485985793061 (37.7343198717706, -122.485985793061) 1 8 3 64 35
11790 254293 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 110 Junipero Serra Blvd 5 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
11875 260569 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 3 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11921 263623 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
11929 253845 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 150 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       3x3   5991384 2095197 37.7325164679088 -122.472168327848 (37.7325164679088, -122.472168327848) 1 8 4 64 40
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
12152 255704 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 201X Hernandez Ave 1 Side Yard : Yard Tree Private 2       10x10   5995122 2099706 37.7451126829106 -122.459571712369 (37.7451126829106, -122.459571712369) 1 8 4 59 40
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
12393 261459 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 701X Delano Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5999135 2090407 37.7198097539444 -122.445027136249 (37.7198097539444, -122.445027136249) 9 7 6 28861 25
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                              
12885 254297 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 130X Junipero Serra Blvd 3 Median : Yard Tree Private 2       10x30   5991393 2095322 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186) 1 8 4 64 40
12971 253842 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100X Junipero Serra Blvd 1 Median : Yard Tree Private 2       3x3   5991400 2095443 37.7331928478719 -122.472130937334 (37.7331928478719, -122.472130937334) 1 8 4 64 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                              
13098 254290 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 110 Junipero Serra Blvd 2 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
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                              
13149 260567 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 1 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
13162 251365 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 2 Sidewalk: Property side : Yard Tree Private 2                              
13318 262248 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 4210 Ocean Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
13572 261601 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Sloat Blvd 2 Median : Cutout Tree Private 2       10x10   5989483 2096058 37.7347703567949 -122.478803415035 (37.7347703567949, -122.478803415035) 1 8 3 64 35
13718 251364 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 1 Sidewalk: Property side : Yard Tree Private 2                              
13893 264884 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1624 48th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
13902 115326 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2601X Sunset Blvd 21 Median : Cutout Tree DPW 1       40   5985098.343425 2097506.3093477 37.7384914535226 -122.494069167367 (37.7384914535226, -122.494069167367) 1 8 3 29491 35
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
13972 260573 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 129 Edgehill Way 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5994858 2098970 37.7430766268484 -122.460431252252 (37.7430766268484, -122.460431252252) 1 8 4 59 40
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                    
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
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                              
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                              
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                              
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
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                              
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

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