trees
1,977 rows where qSpecies_id = 41 sorted by qCaretaker_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||||||||||||||
| 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 | |||||||||||||
| 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 | |||
| 2282 | 19424 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | 1 | 8 | 3 | 64 | 35 | |||
| 2302 | 19935 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 2418 | 20917 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984934.4009631 | 2102260.4913733 | 37.7515355521167 | -122.494986448304 | (37.7515355521167, -122.494986448304) | 1 | 8 | 3 | 29491 | 35 | |||
| 2644 | 113698 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80 LINARES AVE | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 5994154.8 | 2102090.7 | 37.7516048020548 | -122.463089089164 | (37.7516048020548, -122.463089089164) | 1 | 8 | 4 | 29491 | 40 | |||||
| 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 | |||||||||||||||
| 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 | |||||||||||||
| 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 | |||||||||||||
| 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 | |||
| 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 | |||||||||||||||
| 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 | |||||||||||||
| 4930 | 20365 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
| 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 | |||||||||||||
| 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 | |||||||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 7644 | 19569 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
| 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 | ||||
| 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 | |||
| 8411 | 19699 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY11 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40ST | |||||||||||||
| 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 | |||
| 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 | |||||||||||||
| 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 | |||||
| 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 | |||
| 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 | |||||||||||||||
| 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 | ||||
| 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 | ||||
| 10413 | 20317 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 101X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
| 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 | |||
| 11142 | 20455 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 495X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
| 11294 | 20417 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
| 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 | ||||
| 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 | |||
| 12224 | 19907 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
| 12236 | 20366 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
| 12293 | 20434 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 12390 | 20412 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
| 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 | |||||||||||||||
| 12674 | 19753 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY15 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 12679 | 19813 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY24 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 12689 | 22877 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 951X Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 6 | 3X100 | 6009106.075934 | 2090003.4402519 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | 9 | 3 | 7 | 309 | 28 | |||
| 12914 | 20429 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 30 | |||||||||||||
| 12968 | 19943 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 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 | |||||||||||||||
| 13064 | 19694 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY7 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 12ST | |||||||||||||
| 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 | |||||||||||||||
| 13143 | 19776 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY18 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
| 13223 | 19700 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY11 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 40ST | |||||||||||||
| 13332 | 8534 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001381.7916 | 2113512.283 | 37.7833793 | -122.438915716928 | (37.7833793, -122.438915716928) | 15 | 5 | 11 | 29490 | 41 | ||
| 13417 | 19945 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
| 13755 | 11746 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 03/03/2006 12:00:00 AM | 3 | 6X6 | 5991277.67104 | 2092671.80389 | 37.7255767576586 | -122.472351910013 | (37.7255767576586, -122.472351910013) | 9 | 8 | 4 | 64 | 40 | ||
| 13759 | 190995 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10x Cashmere St | 3 | Median : Yard | Tree | DPW 1 | 28 | 6017237.22965 | 2095860.87095 | 37.7358015834667 | -122.382832806316 | (37.7358015834667, -122.382832806316) | 10 | 3 | 8 | 58 | 1 | ||||
| 13890 | 21325 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Sunset Blvd | 25 | 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 | |||
| 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 | ||||
| 13915 | 20977 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2002X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
| 14026 | 19949 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST |
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) );