trees
1,977 rows where qSpecies_id = 41 sorted by Police Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 12495 | 126414 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2836 Larkin St | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 6006501.05561 | 2120998.53971 | 37.8042246191233 | -122.421736962694 | (37.8042246191233, -122.421736962694) | 5 | 9 | 1 | 28858 | 32 | ||||
| 17641 | 262215 | Landmark tree 11 | Cupressus macrocarpa :: Monterey Cypress 41 | 2626 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6001000 | 2117623 | 37.7946445343139 | -122.440531492639 | (37.7946445343139, -122.440531492639) | 13 | 9 | 1 | 57 | 27 | ||||
| 18265 | 249711 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2901 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 5999592.84448 | 2116997.53125 | 37.7928469352999 | -122.445355424115 | (37.7928469352999, -122.445355424115) | 13 | 9 | 1 | 29490 | 27 | ||||
| 22976 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Hermann St | 1 | Front Yard : Yard | Tree | Private 2 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | |||||
| 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 | |
| 27160 | 111763 | Landmark tree 11 | Cupressus macrocarpa :: Monterey Cypress 41 | 2626 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 6001000.6 | 2117623.4 | 37.7946456667745 | -122.440529445268 | (37.7946456667745, -122.440529445268) | 13 | 9 | 1 | 57 | 27 | |||||
| 29166 | 249716 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2975 Broadway | 5 | Back Yard : Yard | Tree | Private 2 | 7 | 5999444.23089 | 2116975.86958 | 37.7927789735145 | -122.44586807365 | (37.7927789735145, -122.44586807365) | 13 | 9 | 1 | 29490 | 27 | ||||
| 29880 | 126427 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3130 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 5999056.00761 | 2119563.15995 | 37.7998608073009 | -122.447397647786 | (37.7998608073009, -122.447397647786) | 13 | 9 | 1 | 57 | 17 | |||
| 33476 | 139327 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1350x GEARY BLVD | 1 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6005396.3086 | 2114138.3218 | 37.7853258358528 | -122.425071614426 | (37.7853258358528, -122.425071614426) | 13 | 9 | 11 | 28858 | 41 | |||
| 39021 | 126416 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2836 Larkin St | 12 | Side Yard : Yard | Tree | Private 2 | 46 | 6006501.51207 | 2121012.26216 | 37.8042623232049 | -122.421736358356 | (37.8042623232049, -122.421736358356) | 5 | 9 | 1 | 28858 | 32 | ||||
| 39688 | 249675 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Baker St | 7 | Front Yard : Yard | Tree | Private 2 | 49 | 5999731.49147 | 2117154.85585 | 37.7932868206735 | -122.444887014927 | (37.7932868206735, -122.444887014927) | 13 | 9 | 1 | 57 | 27 | ||||
| 55029 | 8400 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003921.0381 | 2113941.5724 | 37.7847021645415 | -122.430161561145 | (37.7847021645415, -122.430161561145) | 13 | 9 | 11 | 29490 | 41 | |||
| 60064 | 139328 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1350x GEARY BLVD | 2 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6005318.1985 | 2114131.1202 | 37.7853016493854 | -122.42534133927 | (37.7853016493854, -122.42534133927) | 13 | 9 | 11 | 28858 | 41 | |||
| 60505 | 249710 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2901 Broadway | 2 | Front Yard : Yard | Tree | Private 2 | 24 | 5999603.39885 | 2116998.02748 | 37.7928489002955 | -122.445318941321 | (37.7928489002955, -122.445318941321) | 13 | 9 | 1 | 29490 | 27 | ||||
| 79519 | 139357 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1350x GEARY BLVD | 6 | Median : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6005019.8844 | 2114088.1873 | 37.785166908017 | -122.426370358064 | (37.785166908017, -122.426370358064) | 13 | 9 | 11 | 28858 | 41 | |||
| 79527 | 8399 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003960.687 | 2113944.6223 | 37.7847127843654 | -122.430024606782 | (37.7847127843654, -122.430024606782) | 13 | 9 | 11 | 29490 | 41 | |||
| 100264 | 8396 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004125.3824 | 2113965.9717 | 37.7847807304874 | -122.429456338379 | (37.7847807304874, -122.429456338379) | 13 | 9 | 11 | 29490 | 41 | ||
| 102237 | 8398 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003997.2859 | 2113948.4347 | 37.7847253249416 | -122.429898258777 | (37.7847253249416, -122.429898258777) | 13 | 9 | 11 | 29490 | 41 | |||
| 108023 | 126412 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Jefferson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6000088.69563 | 2121303.72403 | 37.8046988874181 | -122.443949299933 | (37.8046988874181, -122.443949299933) | 13 | 9 | 1 | 57 | 17 | |||
| 125484 | 8401 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003886.7265 | 2113933.9476 | 37.7846792853457 | -122.430279723684 | (37.7846792853457, -122.430279723684) | 13 | 9 | 11 | 29490 | 41 | |||
| 139045 | 126415 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2836 Larkin St | 11 | Side Yard : Yard | Tree | Private 2 | 48 | 6006502.51226 | 2121001.4648 | 37.8042327328147 | -122.421732129727 | (37.8042327328147, -122.421732129727) | 5 | 9 | 1 | 28858 | 32 | ||||
| 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 | |
| 144512 | 126413 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601 Vallejo St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001029.975 | 2117557.63316 | 37.7944667608931 | -122.440423085162 | (37.7944667608931, -122.440423085162) | 13 | 9 | 1 | 57 | 27 | |||
| 174954 | 126417 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2745 Larkin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6006522.5634 | 2120685.74713 | 37.8033669833519 | -122.421640303563 | (37.8033669833519, -122.421640303563) | 5 | 9 | 1 | 28858 | 32 | ||||
| 175426 | 13284 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2576 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6000068.81033 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | 13 | 9 | 1 | 57 | 17 | ||
| 190717 | 126428 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1701 North Point St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002587.87385 | 2120898.67704 | 37.8037289775726 | -122.43527166598 | (37.8037289775726, -122.43527166598) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 9662 | 113066 | - 12 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 7 | : | Tree | DPW 1 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 10140 | 106278 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 2 | Median : Cutout | Tree | DPW 1 | 60 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||||
| 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 | ||||
| 10694 | 187382 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5985066.1507 | 2100087.3826 | 37.7455765004249 | -122.494370678244 | (37.7455765004249, -122.494370678244) | 1 | 8 | 3 | 29491 | 35 | |||
| 10739 | 186360 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984814.758 | 2102602.0458 | 37.7524663619043 | -122.495425370042 | (37.7524663619043, -122.495425370042) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 12210 | 20839 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||||
| 12370 | 187404 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 50 | Width 0ft | 5985026.9229 | 2100775.7749 | 37.7474643426041 | -122.494557058858 | (37.7474643426041, -122.494557058858) | 1 | 8 | 3 | 29491 | 35 | |||
| 12825 | 181360 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 49 | unknown : Yard | Tree | Private 2 | 47 | Width 0ft | 5985113.1047 | 2098629.2701 | 37.7415756656355 | -122.494100873291 | (37.7415756656355, -122.494100873291) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );