trees
1,977 rows where qSpecies_id = 41 sorted by qLegalStatus_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | |||
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 | |||||||||||||
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 | ||||
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 | |||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | ||||
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 | |||
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 | |||||
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 | |||||||||||||
14256 | 258777 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x10 | 5993535 | 2092458 | 37.725120092529 | -122.464533057261 | (37.725120092529, -122.464533057261) | 9 | 8 | 4 | 59 | 40 | ||||
14832 | 261961 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 15 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
14861 | 176144 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 5 | : | Tree | Private 2 | 39 | Width 0ft | 5987593.26623 | 2090234.31177 | 37.7186700965335 | -122.484909687836 | (37.7186700965335, -122.484909687836) | 1 | 8 | 4 | 64 | 14 | |||
14966 | 20413 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
15397 | 20618 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1492X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984803.7392562 | 2105036.6950477 | 37.7591505890295 | -122.495643037613 | (37.7591505890295, -122.495643037613) | 1 | 8 | 3 | 56 | 35 | |||
15485 | 263628 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 192 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6000206.52297 | 2095259.24719 | 37.7331940064051 | -122.441671308196 | (37.7331940064051, -122.441671308196) | 9 | 7 | 5 | 63 | 40 | |||||
15603 | 251321 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Monument Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | |||||||||||||||
15807 | 21024 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2101X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
15823 | 20424 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
15871 | 21025 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2101X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
15884 | 21428 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2692X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
15891 | 261952 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15921 | 20422 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
15966 | 185572 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2201 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 48 | Width 0ft | 5984879.9724 | 2099676.4789 | 37.7444373731189 | -122.494984152016 | (37.7444373731189, -122.494984152016) | 1 | 8 | 3 | 29491 | 35 | |||
15978 | 20430 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 30 | |||||||||||||
16093 | 19936 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
16135 | 21176 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 17 | 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 | |||
16153 | 19978 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY45 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 30ST | |||||||||||||
16181 | 263627 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 192 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6000206.52297 | 2095259.24719 | 37.7331940064051 | -122.441671308196 | (37.7331940064051, -122.441671308196) | 9 | 7 | 5 | 63 | 40 | |||||
16212 | 261956 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
16237 | 261035 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 78 | Median : Yard | Tree | Private 2 | 03/25/2020 12:00:00 AM | 3 | 3x3 | 5984861 | 2104296 | 37.7571201993916 | -122.495390378798 | (37.7571201993916, -122.495390378798) | 1 | 8 | 3 | 56 | 35 | ||
16302 | 21167 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985027.9083074 | 2099542.6271361 | 37.744078511576 | -122.494462762583 | (37.744078511576, -122.494462762583) | 1 | 8 | 3 | 29491 | 35 | |||
16465 | 19951 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
16556 | 20423 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
16638 | 19909 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
16654 | 261545 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Sloat Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5989483 | 2096058 | 37.7347703567949 | -122.478803415035 | (37.7347703567949, -122.478803415035) | 1 | 8 | 3 | 64 | 35 | ||||
16749 | 20291 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
16810 | 254987 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 850 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5991239 | 2091717 | 37.7229528649662 | -122.472416015965 | (37.7229528649662, -122.472416015965) | 9 | 8 | 4 | 64 | 40 | ||||
16814 | 261949 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
16882 | 21108 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2201X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5985004.6737667 | 2100227.1692458 | 37.7459567185928 | -122.494593556276 | (37.7459567185928, -122.494593556276) | 1 | 8 | 3 | 29491 | 35 | |||
17009 | 258662 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10X Mendosa Ave | 9 | Median : Cutout | Tree | Private 2 | 3x3 | 5993533 | 2101170 | 37.749040957039 | -122.465172468022 | (37.749040957039, -122.465172468022) | 1 | 8 | 4 | 29491 | 40 | ||||
17093 | 185328 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984973.8581 | 2097100.251 | 37.7373692412783 | -122.494469646251 | (37.7373692412783, -122.494469646251) | 1 | 8 | 3 | 29491 | 35 | |||
17153 | 206856 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 45 | : | Tree | Private 2 | 26 | Width 0ft | 5991248.85263 | 2092491.97057 | 37.7250813121323 | -122.472438427511 | (37.7250813121323, -122.472438427511) | 9 | 8 | 4 | 64 | 40 | |||
17534 | 261947 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
17725 | 258661 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10X Mendosa Ave | 8 | Median : Cutout | Tree | Private 2 | 3x3 | 5993533 | 2101170 | 37.749040957039 | -122.465172468022 | (37.749040957039, -122.465172468022) | 1 | 8 | 4 | 29491 | 40 | ||||
17791 | 186062 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984799.1046 | 2102135.8379 | 37.7511853667035 | -122.495445120336 | (37.7511853667035, -122.495445120336) | 1 | 8 | 3 | 29491 | 35 | |||
17805 | 20377 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
17984 | 20373 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
18123 | 19934 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
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 | ||||
18542 | 19869 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY33 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST | |||||||||||||
18620 | 261959 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 13 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
18954 | 126425 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1306x Montgomery St | 27 | Median : Yard | Tree | DPW 1 | 13 | Width 8ft | 6011438.82177 | 2120037.47116 | 37.8018629670555 | -122.404581652737 | (37.8018629670555, -122.404581652737) | 3 | 1 | 10 | 308 | 23 | |||
19208 | 19953 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
19225 | 20729 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984865.3499442 | 2104298.7792234 | 37.7571280850658 | -122.495375540207 | (37.7571280850658, -122.495375540207) | 1 | 8 | 3 | 56 | 35 | |||
19293 | 20452 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 495X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 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) );