trees

2,306 rows where qSpecies_id = 15 sorted by Police Districts

✎ 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                      
139808 250139 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2550x Lyon St 7 Median : Yard Tree DPW 1     11     5999209.46456 2117608.80739 37.794503445131 -122.446725934276 (37.794503445131, -122.446725934276) 13   1 57 30
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
14690 132193 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 24 Priest St 1 Sidewalk: Property side : Yard Tree Private 2     23 Width 10ft   6008345.5033 2117049.6207 37.7934857075452 -122.415074404558 (37.7934857075452, -122.415074404558) 5 1 10 28858 21
16781 260951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 190 Jackson St 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   6013038 2118237 37.7970085486816 -122.398921272101 (37.7970085486816, -122.398921272101) 3 1 10 28860 6
18614 132205 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 12 Greenwich St 10 Sidewalk: Curb side : Yard Tree Private 2     27     6012257.5514 2120548.1369 37.8033108539845 -122.401784364564 (37.8033108539845, -122.401784364564) 3 1 10 28860 6
18878 250202 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 203 Union St 3 Side Yard : Yard Tree Private 2     12 Width 0ft   6011755.5651 2119757.15751 37.8011109908426 -122.403465834184 (37.8011109908426, -122.403465834184) 3 1 10 308 23
19052 260948 Significant Tree 6 Pinus radiata :: Monterey Pine 15 370 Drumm St 1 Side Yard : Yard Tree Private 2           6013616 2118213 37.7969748404412 -122.396919555024 (37.7969748404412, -122.396919555024) 3 1 10 28860 6
22008 132208 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 199 Union St 8 Sidewalk: Property side : Yard Tree Private 2     22     6012099.30323 2119801.66278 37.8012523849575 -122.402279475534 (37.8012523849575, -122.402279475534) 3 1 10 28860 6
29505 132201 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 95 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     23     6008101.98916 2119090.79799 37.7990765867616 -122.416061605678 (37.7990765867616, -122.416061605678) 5 1 10 308 32
32649 132207 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 199 Union St 5 Sidewalk: Property side : Yard Tree Private 2     9     6012049.27862 2119798.13006 37.8012398924644 -122.40245233511 (37.8012398924644, -122.40245233511) 3 1 10 28860 6
44600 107186 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 2 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
47218 99951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1160 Battery St 1 Front Yard : Yard Tree Private 2   06/19/2012 12:00:00 AM     Permit Number 768993 6012314.3 2120017.7 37.8018575696458 -122.401550680127 (37.8018575696458, -122.401550680127) 3 1 10 28860 6
56602 250219 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 310 Montgomery St 2 Front Yard : Yard Tree Private 2     23 Width 0ft   6011287.59722 2120080.15149 37.8019717040854 -122.40510797016 (37.8019717040854, -122.40510797016) 3 1 10 308 23
58145 249825 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 391 Filbert St 1 Front Yard : Yard Tree Private 2     25 Width 0ft   6010996.75714 2119996.47458 37.8017256846648 -122.406108520815 (37.8017256846648, -122.406108520815) 3 1 10 308 23
60721 132203 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 941 Vallejo St 9 Front Yard : Yard Tree Private 2     25     6008948.41749 2118683.7067 37.7980063683465 -122.413103866774 (37.7980063683465, -122.413103866774) 3 1 10 308 21
69829 132202 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 956 Vallejo St 1 Front Yard : Yard Tree Private 2     54     6008925.46833 2118706.00298 37.7980663000818 -122.413184855205 (37.7980663000818, -122.413184855205) 3 1 10 308 21
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
84037 107611 Significant Tree 6 Pinus radiata :: Monterey Pine 15 470x Broadway 1 Back Yard : Yard Tree Private 2         Permit Number 774041 6011286.02608 2118707.45024 37.7982025127238 -122.40501669829 (37.7982025127238, -122.40501669829) 3 1 10 308 23
84386 99192 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1155@Sansome Battery St 3 Front Yard : Yard Tree Private 2       Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
84470 249790 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 173 Chestnut St 4 Front Yard : Yard Tree Private 2     16 Width 0ft   6010907.69463 2121032.6733 37.8045658498002 -122.406489777591 (37.8045658498002, -122.406489777591) 3 1 10 308 23
91710 249898 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1497 Montgomery St 4 Side Yard : Yard Tree Private 2     20 Width 0ft   6011364.51666 2120462.68134 37.8030263372523 -122.404868738822 (37.8030263372523, -122.404868738822) 3 1 10 28860 23
92469 249994 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 230 Filbert St 2 Front Yard : Yard Tree Private 2     18 Width 0ft   6011548.30327 2120099.56234 37.8020395723386 -122.404207166046 (37.8020395723386, -122.404207166046) 3 1 10 308 23

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