trees

1,977 rows where qSpecies_id = 41 sorted by qCareAssistant

✎ 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                              
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
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
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
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
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
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
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
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
4336 20312 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 101X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
4372 21160 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2301 Sunset Blvd 1 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
4462 21326 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985074.8907349 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189) 1 8 3 29491 35
4465 20303 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 50X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
4543 206871 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700 Junipero Serra Blvd 167 : Tree Private 2     28 Width 0ft   5991178.39011 2091334.01969 37.7218977876304 -122.472597620991 (37.7218977876304, -122.472597620991) 9 8 4 64 40
4808 186197 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1701 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     66 Width 0ft   5984786.367 2103519.1304 37.7549827606067 -122.495591185684 (37.7549827606067, -122.495591185684) 1 8 3 56 35
4865 223711 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1201 San Jose Ave 43 Front Yard : Yard Tree Private 2     27     6004453.96026 2096061.62765 37.7356382512944 -122.427043891762 (37.7356382512944, -122.427043891762) 2 7 5 28861 2
4930 20365 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
5084 186429 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     52 Width 0ft   5984743.4554 2104053.6823 37.7564479790635 -122.495779012977 (37.7564479790635, -122.495779012977) 1 8 3 56 35
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
5295 19947 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 25ST                      
5357 19933 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
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
5438 20428 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 485X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     42 40                      
5439 247017 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 500 Valley St 9 Sidewalk: Property side : Yard Tree Private 2     40     6002542.70295 2099187.51886 37.7441129631509 -122.433875195085 (37.7441129631509, -122.433875195085) 2 7 5 63 22
5522 185128 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1200x Sloat Blvd 5 Median : Cutout Tree DPW 1     12 Width 0ft   5987683.0779 2095922.3154 37.7342931239465 -122.48501633511 (37.7342931239465, -122.48501633511) 1 8 4 64 35
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
5813 20297 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
5925 206820 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 335x Pacheco St 2 Median : Yard Tree DPW 1     28 Width 8ft   5994214.91647 2101031.13143 37.7486989587999 -122.462804340247 (37.7486989587999, -122.462804340247) 1 8 4 29491 40
6028 261967 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 299x Portola Dr 1 Median : Yard Tree DPW 1                              
6090 126426 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3130 Lyon St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 7ft   5999057.94156 2119543.59601 37.7998072004939 -122.447389546701 (37.7998072004939, -122.447389546701) 13 9 1 57 17
6209 186439 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     43 Width 0ft   5984744.2928 2103976.6372 37.7562364836353 -122.495770433997 (37.7562364836353, -122.495770433997) 1 8 3 56 35
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
6439 185119 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1200x Sloat Blvd 6 Median : Cutout Tree DPW 1     25 Width 0ft   5987585.1902 2095924.1623 37.7342924927912 -122.485354895586 (37.7342924927912, -122.485354895586) 1 8 4 64 35
6506 187198 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2301 Sunset Blvd 60 Sidewalk: Property side : Yard Tree Private 2     46 Width 0ft   5984955.9451 2099026.506 37.7426571707346 -122.494673548768 (37.7426571707346, -122.494673548768) 1 8 3 29491 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
6583 20407 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 52 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
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                              
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
7283 176114 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Zoo Rd 1 Front Yard : Yard Tree Private 2     24 Width 10ft   5982696.49512 2094384.4536 37.7297788507039 -122.502142508582 (37.7297788507039, -122.502142508582) 1 8 4 64 14
7317 20294 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
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
7540 21114 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2201X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5985004.6737667 2100227.1692458 37.7459567185928 -122.494593556276 (37.7459567185928, -122.494593556276) 1 8 3 29491 35
7557 206861 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700 Junipero Serra Blvd 89 : Tree Private 2     15 Width 0ft   5991235.10134 2092148.32282 37.7241369448505 -122.47246092223 (37.7241369448505, -122.47246092223) 9 8 4 64 40
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
7599 185900 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2000 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5985021.1381 2101287.9293 37.7488702402587 -122.494614813113 (37.7488702402587, -122.494614813113) 1 8 3 29491 35
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
7644 19569 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 3 Sidewalk: Curb side : Cutout Tree DPW 1     48 100ST                      
7690 186919 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2700 Sunset Blvd 68 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985188.343 2096744.434 37.7364048133414 -122.493701871188 (37.7364048133414, -122.493701871188) 1 8 3 29491 35
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
7787 19910 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 120ST                      
7813 206807 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 11x Saint Francis Blvd 1 Median : Yard Tree DPW 1     12     5991689.22153 2095992.93147 37.7347195542573 -122.471171081279 (37.7347195542573, -122.471171081279) 9 8 4 59 40
7904 184885 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1201 Sunset Blvd 74 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5984635.3908 2106778.1095 37.7639221652711 -122.496353750703 (37.7639221652711, -122.496353750703) 1 8 3 56 35
7998 181380 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1500 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5984920.3702 2104474.5517 37.7576139288826 -122.495198223579 (37.7576139288826, -122.495198223579) 1 8 3 56 35
8004 176122 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3500 Great Hwy 9 Median : Tree Private 2     3 Width 0ft   5982330.17471 2092783.08412 37.7253603924579 -122.503290375351 (37.7253603924579, -122.503290375351) 1 8 4 64 14
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
8274 2988 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2266X California St 4 Sidewalk: Property side : Cutout Tree DPW 1     35 3X3   6003528.90719 2115622.95537 37.7892965998021 -122.431638286196 (37.7892965998021, -122.431638286196) 13 9 1 29490 27
8394 206864 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700 Junipero Serra Blvd 108 : Tree Private 2     16 Width 0ft   5991230.74264 2091941.55129 37.7235689492395 -122.472460922234 (37.7235689492395, -122.472460922234) 9 8 4 64 40

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