trees
2,306 rows where qSpecies_id = 15 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
689 | 119914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400X Brotherhood Way | 1 | Front Yard : Yard | Tree | DPW 1 | 100x100 | ||||||||||||||
815 | 20416 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
844 | 254210 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
1144 | 20400 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
1176 | 119263 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Lakeshore Dr | 1 | Median : Yard | Tree | DPW 1 | 10x30 | ||||||||||||||
1531 | 20287 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
1886 | 20313 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
1978 | 87100 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 700 Connecticut St | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x3 | Permit Number 50056 | |||||||||||||
1982 | 20405 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
2568 | 20451 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
2812 | 19775 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
3000 | 20052 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY53 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
3106 | 20323 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3639 | 20284 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
4038 | 20457 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
4494 | 20293 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
4731 | 19749 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY15 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
4776 | 19969 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY43 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15 | |||||||||||||
5041 | 20311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
5216 | 20045 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY52 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
6109 | 20338 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
6239 | 261665 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 401X Greenwich St | 1 | Unaccepted Street : Cutout | Tree | DPW 1 | |||||||||||||||
6415 | 20399 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
6528 | 20289 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
6752 | 20418 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
6984 | 20069 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY55 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 40ST | |||||||||||||
7041 | 20329 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
7330 | 20367 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
7403 | 20408 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 53 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
7420 | 20458 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
8084 | 20421 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
8135 | 20290 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
8660 | 20402 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 47 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
8757 | 20337 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
8781 | 94862 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53932 | ||||||||||||||
9087 | 20433 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
9165 | 20427 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
9285 | 20285 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
9368 | 20394 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 39 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
10032 | 254212 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 81X Elsie St | 10 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
10108 | 94859 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53932 | ||||||||||||||
10142 | 20420 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
11212 | 20461 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
11436 | 20292 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
11490 | 20283 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
11544 | 20435 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
11775 | 173632 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3300X Market St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
11955 | 20344 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40 | |||||||||||||
11962 | 19853 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY29 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
11998 | 20308 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
12112 | 20431 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 30 | |||||||||||||
12400 | 20426 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
12659 | 122532 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1900X Castro St | 1 | Unaccepted Street : Yard | Tree | Private 2 | |||||||||||||||
12894 | 20288 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
13192 | 20368 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
13588 | 20425 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
14170 | 20388 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
14280 | 20070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY55 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
14435 | 20307 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
14843 | 19968 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY43 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
15008 | 20387 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
15020 | 20401 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 46 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
15093 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x Avalon Ave | 3 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15388 | 20295 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
16184 | 19977 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY45 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
16196 | 251543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard | Tree | Private 2 | ||||||||||||||||
16290 | 20286 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
16411 | 20053 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY53 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
17047 | 20343 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
17057 | 20306 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
18328 | 20339 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
18358 | 20374 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
18372 | 121500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 251X Pennsylvania Ave | 1 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
18633 | 20454 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
18945 | 20432 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 30 | |||||||||||||
19039 | 20396 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 41 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
19072 | 20380 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
60038 | 258526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 50 Hermann St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
72407 | 118344 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 621x Gough St | 1 | Front Yard : Yard | Tree | Private 2 | 6005346 | 2111820 | 37.7789574535961 | -122.425080654997 | (37.7789574535961, -122.425080654997) | 7 | 9 | 11 | 28852 | 41 | |||||
117614 | 40618 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 201 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 41624 | 6005148.26696606 | 2109558.58269734 | 37.7727369810284 | -122.425603701556 | (37.7727369810284, -122.425603701556) | 7 | 9 | 11 | 28852 | 10 | ||
125282 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
159 | 117627 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
176 | 194490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 22nd St | 19 | Front Yard : Yard | Tree | Private 2 | 29 | 6013346.63868 | 2103825.44695 | 37.7574548949481 | -122.396842409144 | (37.7574548949481, -122.396842409144) | 10 | 3 | 8 | 28856 | 29 | ||||
1428 | 194473 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 851 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 8ft | 6014996.92919 | 2104399.34696 | 37.7591224196901 | -122.391175112734 | (37.7591224196901, -122.391175112734) | 10 | 3 | 8 | 28856 | 29 | |||
2030 | 112443 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
3166 | 194483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 930 Kansas St | 2 | Front Yard : Yard | Tree | Private 2 | 31 | 6011593.09908 | 2103991.17748 | 37.7578121947052 | -122.402918540071 | (37.7578121947052, -122.402918540071) | 10 | 3 | 8 | 28856 | 29 | ||||
3197 | 261564 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
5888 | 261561 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
7194 | 117622 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
8513 | 112444 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
11046 | 262155 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1800 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013141 | 2101984 | 37.752387232625 | -122.397424456513 | (37.752387232625, -122.397424456513) | 10 | 3 | 8 | 28856 | 29 | ||||
12343 | 194488 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6012030.15727 | 2101805.35505 | 37.751834800344 | -122.401253403036 | (37.751834800344, -122.401253403036) | 10 | 3 | 8 | 28856 | 29 | ||||
16931 | 194485 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 998 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 10ft | 6011603.18064 | 2103745.73679 | 37.7571388318007 | -122.402866411773 | (37.7571388318007, -122.402866411773) | 10 | 3 | 8 | 28856 | 29 | |||
19174 | 261294 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 801 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6012760.41981 | 2103766.81895 | 37.7572612683759 | -122.398865686828 | (37.7572612683759, -122.398865686828) | 10 | 3 | 8 | 28856 | 29 | |||||
22742 | 112442 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 36 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 10 | 3 | 8 | 28856 | 29 | |||||
28407 | 194476 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x Carolina St | 43 | Median : Yard | Tree | DPW 1 | 22 | 6012491.75598 | 2103075.93483 | 37.755349278054 | -122.399746327228 | (37.755349278054, -122.399746327228) | 10 | 3 | 8 | 28856 | 29 | ||||
29301 | 121490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 24 | 6011163.12299 | 2106299.7163 | 37.7641269067524 | -122.404568089162 | (37.7641269067524, -122.404568089162) | 8 | 3 | 8 | 28856 | 29 | ||||
33806 | 194491 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 22nd St | 21 | Front Yard : Yard | Tree | Private 2 | 24 | 6013319.82421 | 2103789.39675 | 37.7573544163899 | -122.396932617442 | (37.7573544163899, -122.396932617442) | 10 | 3 | 8 | 28856 | 29 |
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) );