trees

2,306 rows where qSpecies_id = 15 sorted by Zip Codes

✎ View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);