trees
2,306 rows where qSpecies_id = 15 sorted by Supervisor Districts
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 | |||||||||||||
9602 | 98360 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | 5 | 1 | 1 | 28858 | 32 | ||||
25270 | 124269 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 9 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5994882.44582 | 2114964.8982 | 37.7869958645771 | -122.461506079992 | (37.7869958645771, -122.461506079992) | 11 | 6 | 1 | 54 | 11 | ||||
35278 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999865 | 2112093 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | 15 | 5 | 1 | 29490 | 16 | ||||
41301 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 5985761 | 2114995 | 37.7865492821054 | -122.493065995445 | (37.7865492821054, -122.493065995445) | 11 | 6 | 1 | 55 | 33 | |||||
47675 | 92871 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 3600 Jackson St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53088 | 5997031 | 2116025 | 37.7900300525901 | -122.454149203806 | (37.7900300525901, -122.454149203806) | 11 | 6 | 1 | 54 | 31 | ||||
48342 | 250649 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 142 El Camino Del Mar | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 5988079.23944 | 2115372.9404 | 37.7877223050946 | -122.485073297006 | (37.7877223050946, -122.485073297006) | 11 | 6 | 1 | 55 | 33 | |||
49139 | 12819 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2160 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 14x5.5 | 5988722.6241 | 2114706.80979 | 37.7859307553787 | -122.482798499524 | (37.7859307553787, -122.482798499524) | 11 | 6 | 1 | 55 | 33 | |||
63786 | 124704 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2x Cherry St | 1 | Median : Yard | Tree | DPW 1 | 28 | 5996074.41717 | 2115943.0366 | 37.789750104458 | -122.457452946984 | (37.789750104458, -122.457452946984) | 11 | 6 | 1 | 54 | 31 | ||||
67654 | 250650 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 142 El Camino Del Mar | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 5988068.63131 | 2115372.88737 | 37.787721541568 | -122.485109994754 | (37.787721541568, -122.485109994754) | 11 | 6 | 1 | 55 | 33 | |||
68924 | 113937 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 800 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 35 | 5985966 | 2115003 | 37.7865832348262 | -122.492357345241 | (37.7865832348262, -122.492357345241) | 11 | 6 | 1 | 55 | 33 | ||||
74656 | 115555 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3897 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5996212.11985 | 2115219.4068 | 37.7877711202849 | -122.456924150932 | (37.7877711202849, -122.456924150932) | 11 | 6 | 1 | 54 | 31 | |||
79249 | 132191 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3837 Washington St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5996517.22256 | 2115577.54353 | 37.7887719829951 | -122.455894459569 | (37.7887719829951, -122.455894459569) | 11 | 6 | 1 | 54 | 31 | |||
81078 | 114978 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1 PETER YORKE WAY | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6005775 | 2114336 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | 13 | 9 | 1 | 28858 | 41 | ||||
82842 | 85282 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1283 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49571 | 6006751 | 2119761 | 37.8008407409326 | -122.42078409851 | (37.8008407409326, -122.42078409851) | 5 | 1 | 1 | 28858 | 32 | ||||
91205 | 249721 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2500 Broderick St | 5 | Front Yard : Yard | Tree | Private 2 | 18 | 6000189.90204 | 2117386.30397 | 37.7939484671928 | -122.443317519907 | (37.7939484671928, -122.443317519907) | 13 | 9 | 1 | 57 | 27 | ||||
94458 | 85283 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1283 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49571 | 6006751 | 2119761 | 37.8008407409326 | -122.42078409851 | (37.8008407409326, -122.42078409851) | 5 | 1 | 1 | 28858 | 32 | ||||
103238 | 121134 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 2 | Front Yard : Yard | Tree | Private 2 | 3x10 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
103446 | 50960 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 65 Montclair Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47453 | 6007264.23528351 | 2120370.2610527 | 37.8025425319574 | -122.41905132385 | (37.8025425319574, -122.41905132385) | 5 | 1 | 1 | 28858 | 32 | ||||
110091 | 132192 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2x Cherry St | 2 | Median : Yard | Tree | DPW 1 | 28 | 5996086.73681 | 2115931.64437 | 37.7897195320874 | -122.457409497957 | (37.7897195320874, -122.457409497957) | 11 | 6 | 1 | 54 | 31 | ||||
113165 | 113482 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2839 Pierce St | Back Yard : Yard | Tree | Private 2 | 6001345 | 2118077 | 37.7959107386074 | -122.439370308548 | (37.7959107386074, -122.439370308548) | 13 | 9 | 1 | 57 | 17 | ||||||
116312 | 121792 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2556 Broderick St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 6000243 | 2117343 | 37.7938325936105 | -122.443130684772 | (37.7938325936105, -122.443130684772) | 13 | 9 | 1 | 57 | 27 | ||||
116546 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2620 Larkin St | Front Yard : Yard | Tree | Private 2 | 37 | Permit Number 56959 | 6006630 | 2120172 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | 5 | 9 | 1 | 28858 | 32 |
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) );