1,977 rows where qSpecies_id = 41 sorted by qLegalStatus_id

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)
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
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                      
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                      
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
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
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
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
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
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
6583 20407 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 52 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
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
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                      
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
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
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
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
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
8411 19699 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY11 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 40ST                      
8421 126411 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3398 Pierce St 1 Sidewalk: Property side : Yard Tree Private 2     20 Width 3ft   6001324.1548 2120088.88928 37.8014336702784 -122.439586737243 (37.8014336702784, -122.439586737243) 13 9 1 57 17
8582 19955 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 2ST                      
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
8678 185706 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2101 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     39 Width 0ft   5984860.1074 2100483.4684 37.7466519838878 -122.495112335974 (37.7466519838878, -122.495112335974) 1 8 3 29491 35
8755 5050 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 5399X Diamond Heights Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     19     6001979.62541 2098516.88417 37.7422395880754 -122.43577421703 (37.7422395880754, -122.43577421703) 2 7 5 63 22
8830 21239 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2401X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5985051.1945321 2098862.1753589 37.7422115377949 -122.494332098234 (37.7422115377949, -122.494332098234) 1 8 3 29491 35
8866 20398 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
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
8937 19804 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY22 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 20                      
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                              
9387 19932 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
9414 206806 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 175 Garcia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     44 Width 4ft   5994639.44486 2099406.32417 37.7442620887181 -122.461218572898 (37.7442620887181, -122.461218572898) 1 8 4 59 40
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                              
9730 190968 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 8 Sidewalk: Curb side : Yard Tree Private 2     39     6011276.3148 2104337.18505 37.7587445605265 -122.404038467608 (37.7587445605265, -122.404038467608) 10 3 8 28856 29
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                              

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