trees

2,306 rows where qSpecies_id = 15 sorted by Neighborhoods (old)

✎ 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                      
161 194506 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 299x Cashmere St 26 Median : Yard Tree DPW 1     18     6016624.93937 2096021.78221 37.7362095654157 -122.384960961105 (37.7362095654157, -122.384960961105) 10 3 8 58 1
2907 194508 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 299x Cashmere St 28 Median : Yard Tree DPW 1     23     6016611.71691 2096022.49532 37.7362107920965 -122.385006726687 (37.7362107920965, -122.385006726687) 10 3 8 58 1
4778 201565 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 16 Sidewalk: Property side : Yard Tree Private 2     45     6019673.98228 2093813.82501 37.7303151200443 -122.374266134286 (37.7303151200443, -122.374266134286) 10 3 8 58 1
5905 261162 Significant Tree 6 Pinus radiata :: Monterey Pine 15 595 Newhall St 1 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   6016024 2097656 37.7406635379999 -122.387152626875 (37.7406635379999, -122.387152626875) 10 3 8 58 1
5980 113539 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 2 Median : Yard Tree DPW 1     20     6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
15996 258691 Property Tree 8 Pinus radiata :: Monterey Pine 15 100x Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
25286 201566 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 799 Jerrold Ave 1 Sidewalk: Property side : Yard Tree Private 2     11     6019697.16467 2093717.76615 37.7300526357971 -122.374179337111 (37.7300526357971, -122.374179337111) 10 3 8 58 1
25771 194495 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2 Tulare St 13 Front Yard : Yard Tree Private 2     6     6016190.05979 2100302.20421 37.7479386656413 -122.38676294076 (37.7479386656413, -122.38676294076)   3 8 58 1
31671 194519 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1108 Griffith St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 8ft   6018142.03115 2092982.0233 37.7279467796967 -122.379504594361 (37.7279467796967, -122.379504594361) 10 3 8 58 1
36819 201729 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1411 Phelps St 4 Side Yard : Yard Tree Private 2     3     6013763.5505 2095932.04649 37.735804483793 -122.394847748824 (37.735804483793, -122.394847748824) 10 3 8 58 1
37949 201567 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 799 Jerrold Ave 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 9ft   6019712.53243 2093705.44833 37.7300196585793 -122.374125355309 (37.7300196585793, -122.374125355309) 10 3 8 58 1
40173 201730 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1411 Phelps St 5 Side Yard : Yard Tree Private 2     20     6013762.45417 2095926.0507 37.7357879596321 -122.39485111951 (37.7357879596321, -122.39485111951) 10 3 8 58 1
42183 110954 Significant Tree 6 Pinus radiata :: Monterey Pine 15 126X Mendell St 1 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6017060.74507 2098543.22184 37.7431570265693 -122.383629676533 (37.7431570265693, -122.383629676533) 10 3 8 58 1
43756 194494 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 3305 03rd St 2 Sidewalk: Property side : Yard Tree Private 2     22 Width 10ft   6016095.96516 2099918.62991 37.7468802400244 -122.387061569634 (37.7468802400244, -122.387061569634)   3 8 58 1
45780 194507 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 299x Cashmere St 27 Median : Yard Tree DPW 1     21     6016618.68245 2096023.02512 37.7362126321093 -122.384982680622 (37.7362126321093, -122.384982680622) 10 3 8 58 1
51342 194514 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 301x Cashmere St 26 Median : Yard Tree DPW 1     22     6016024.76116 2095911.21448 37.7358727531167 -122.387028333393 (37.7358727531167, -122.387028333393) 10 3 8 58 1
53862 173726 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1101 Connecticut St 1 Front Yard : Yard Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
61677 194518 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 15x Reuel Ct 2 Median : Yard Tree DPW 1     16     6017388.67134 2096078.81136 37.7364083704432 -122.382324365581 (37.7364083704432, -122.382324365581) 10 3 8 58 1
62956 194517 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 15 Reuel Ct 1 : Tree Private 2     31     6017370.39077 2096095.66056 37.7364536252419 -122.382388741749 (37.7364536252419, -122.382388741749) 10 3 8 58 1
64408 201553 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 4 Sidewalk: Property side : Yard Tree Private 2     31     6019956.36355 2093604.98051 37.72975719952 -122.373275437534 (37.72975719952, -122.373275437534) 10 3 8 58 1
66472 194511 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 301x Cashmere St 21 Median : Yard Tree DPW 1     29     6016041.40389 2096043.15017 37.7362359434412 -122.386979991251 (37.7362359434412, -122.386979991251) 10 3 8 58 1
66798 113536 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 3 Median : Yard Tree DPW 1           6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1

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