trees
1,977 rows where qSpecies_id = 41
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
8535 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
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 | |||
8751 | 262427 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||||||||||||||
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 | ||||
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 | |||||
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 | |||||||||||||||
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 | |||||||||||||||
9922 | 261964 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 18 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10025 | 264885 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1279 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 787806 | 5982392 | 2106415 | 37.7627934961857 | -122.504085938563 | (37.7627934961857, -122.504085938563) | 1 | 8 | 3 | 56 | 35 | |||
10088 | 253978 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
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 | ||||
10143 | 256870 | Planning Code 138.1 required 2 | Cupressus macrocarpa :: Monterey Cypress 41 | 30X Bernal Heights Blvd | 1 | Back Yard : Cutout | Tree | Private 2 | 12x6 | ||||||||||||||
10153 | 262205 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Lois Ln | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6012244 | 2087959 | 37.7138275196569 | -122.39954186434 | (37.7138275196569, -122.39954186434) | 10 | 3 | 8 | 309 | 1 | ||||
10387 | 261604 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300X Sloat Blvd | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5987403 | 2095938 | 37.7343198717706 | -122.485985793061 | (37.7343198717706, -122.485985793061) | 1 | 8 | 3 | 64 | 35 | ||||
10395 | 260478 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3333 California St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
10397 | 261602 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Sloat Blvd | 2 | Median : Cutout | Tree | Private 2 | 10x10 | 5989247 | 2095899 | 37.7343200773404 | -122.47960770916 | (37.7343200773404, -122.47960770916) | 1 | 8 | 4 | 64 | 35 | ||||
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 | |||
10672 | 223744 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 591 27th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6002700.25317 | 2100030.09519 | 37.7464354200694 | -122.433390619685 | (37.7464354200694, -122.433390619685) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
11014 | 262425 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
11142 | 20455 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 495X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
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 | ||||
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 | ||||
11442 | 260571 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 5 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
11463 | 260828 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 165 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | ||||
11583 | 261603 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300X Sloat Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5987403 | 2095938 | 37.7343198717706 | -122.485985793061 | (37.7343198717706, -122.485985793061) | 1 | 8 | 3 | 64 | 35 | ||||
11790 | 254293 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 110 Junipero Serra Blvd | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
11875 | 260569 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
11921 | 263623 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 980 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008397 | 2119007 | 37.7988630807128 | -122.415034830901 | (37.7988630807128, -122.415034830901) | 5 | 1 | 10 | 308 | 32 | ||||
11929 | 253845 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 150 Junipero Serra Blvd | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 5991384 | 2095197 | 37.7325164679088 | -122.472168327848 | (37.7325164679088, -122.472168327848) | 1 | 8 | 4 | 64 | 40 | ||||
12058 | 253308 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
12152 | 255704 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 201X Hernandez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995122 | 2099706 | 37.7451126829106 | -122.459571712369 | (37.7451126829106, -122.459571712369) | 1 | 8 | 4 | 59 | 40 | ||||
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 | |||||||||||||
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 | |||||
12293 | 20434 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
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 | |||
12390 | 20412 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
12393 | 261459 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 701X Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
12448 | 261958 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 12 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
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 | ||||
12505 | 205919 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 230 Edna St | 2 | Side Yard : Yard | Tree | Private 2 | 34 | 5998797.1475 | 2095343.94395 | 37.7333461617934 | -122.446549972916 | (37.7333461617934, -122.446549972916) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
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 | ||||
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 | |||||||||||||
12971 | 253842 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5991400 | 2095443 | 37.7331928478719 | -122.472130937334 | (37.7331928478719, -122.472130937334) | 1 | 8 | 4 | 64 | 40 | ||||
13027 | 261955 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
13064 | 19694 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY7 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 12ST | |||||||||||||
13098 | 254290 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 110 Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
13121 | 261953 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
13143 | 19776 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY18 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
13149 | 260567 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
13162 | 251365 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
13223 | 19700 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY11 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 40ST | |||||||||||||
13318 | 262248 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
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 | |||||||||||||
13568 | 217777 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 470 West Portal Ave | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | 5991442.94255 | 2096087.95113 | 37.7349662059076 | -122.472029467093 | (37.7349662059076, -122.472029467093) | 1 | 8 | 4 | 29491 | 40 | ||||
13572 | 261601 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Sloat Blvd | 2 | Median : Cutout | Tree | Private 2 | 10x10 | 5989483 | 2096058 | 37.7347703567949 | -122.478803415035 | (37.7347703567949, -122.478803415035) | 1 | 8 | 3 | 64 | 35 | ||||
13593 | 247903 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 582 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 31 | 6009830.823 | 2098729.70619 | 37.7432667982256 | -122.408642088157 | (37.7432667982256, -122.408642088157) | 10 | 7 | 7 | 28859 | 2 | ||||
13718 | 251364 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
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 | ||||
13885 | 223773 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 310 Liberty St | 62 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003724.02134 | 2103929.75159 | 37.7572009893486 | -122.430128695891 | (37.7572009893486, -122.430128695891) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
13893 | 264884 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1624 48th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5981321 | 2103997 | 37.7560913197894 | -122.50761065519 | (37.7560913197894, -122.50761065519) | 1 | 8 | 3 | 56 | 35 | ||||
13902 | 115326 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601X Sunset Blvd | 21 | Median : Cutout | Tree | DPW 1 | 40 | 5985098.343425 | 2097506.3093477 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | |||
13937 | 253313 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
13972 | 260573 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 129 Edgehill Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5994858 | 2098970 | 37.7430766268484 | -122.460431252252 | (37.7430766268484, -122.460431252252) | 1 | 8 | 4 | 59 | 40 | ||||
13998 | 206803 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 300 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5993087.14993 | 2102582.23712 | 37.7528928770087 | -122.466816856226 | (37.7528928770087, -122.466816856226) | 1 | 8 | 4 | 56 | 12 | ||||
14026 | 19949 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST | |||||||||||||
14139 | 186412 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 7 | Median : Yard | Tree | Private 2 | 0 | Width 0ft | 5984810.0324 | 2103749.2702 | 37.7556160465723 | -122.495526318381 | (37.7556160465723, -122.495526318381) | 1 | 8 | 3 | 56 | 35 | |||
14193 | 186443 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984758.9481 | 2103937.6958 | 37.7561304196042 | -122.495716879396 | (37.7561304196042, -122.495716879396) | 1 | 8 | 3 | 56 | 35 | |||
14194 | 261962 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 16 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
14203 | 20280 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 |
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) );