trees

2,306 rows where qSpecies_id = 15 sorted by YCoord

✎ 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                      
115207 178266 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 12x Canyon Dr 13 Median : Cutout Tree DPW 1     11 Width 0ft   6002746.13562 2086151.65676 37.7083309587667 -122.432240977639 (37.7083309587667, -122.432240977639) 9 7 6 28861 5
24815 178246 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 334 Schwerin St 1 Sidewalk: Property side : Yard Tree Private 2     59 Width 8ft   6008498.73338 2086169.51029 37.7087044750874 -122.412360530312 (37.7087044750874, -122.412360530312) 9 7 8 309 39
181489 178265 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 12x Canyon Dr 11 Median : Cutout Tree DPW 1     25 Width 0ft   6002756.14079 2086182.07734 37.7084150543766 -122.432208569675 (37.7084150543766, -122.432208569675) 9 7 6 28861 5
77383 106062 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 140X CANYON DR 2 Median : Yard Tree DPW 1     30     6002713 2086188.2 37.7084294197398 -122.432358106226 (37.7084294197398, -122.432358106226) 9 7 6 28861 5
131335 106057 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 140X CANYON DR 1 Median : Yard Tree DPW 1     18     6002713 2086188.2 37.7084294197398 -122.432358106226 (37.7084294197398, -122.432358106226) 9 7 6 28861 5
125396 178264 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 12x Canyon Dr 10 Median : Cutout Tree DPW 1     34 Width 0ft   6002759.72323 2086192.08797 37.7084427445179 -122.432196902771 (37.7084427445179, -122.432196902771) 9 7 6 28861 5
73606 178271 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 35 Tomaso Ct 2 Side Yard : Yard Tree Private 2     17 Width 3ft   6009176.17094 2086260.29043 37.7089917311415 -122.410025611499 (37.7089917311415, -122.410025611499) 9 7 8 309 39
81271 178270 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 35 Tomaso Ct 1 Side Yard : Yard Tree Private 2     14 Width 3ft   6009167.93697 2086263.08528 37.7089989437285 -122.410054266587 (37.7089989437285, -122.410054266587) 9 7 8 309 39
33077 178244 Undocumented 4 Pinus radiata :: Monterey Pine 15 62 Tomaso Ct 4 Front Yard : Yard Tree Private 2     17 Width 8ft   6009170.0421 2086265.24197 37.7090049835504 -122.410047143074 (37.7090049835504, -122.410047143074) 9 7 8 309 39
20014 178243 Undocumented 4 Pinus radiata :: Monterey Pine 15 62 Tomaso Ct 3 Front Yard : Yard Tree Private 2     26 Width 8ft   6009152.06447 2086268.0035 37.7090115585089 -122.410109471469 (37.7090115585089, -122.410109471469) 9 7 8 309 39
190443 178242 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 62 Tomaso Ct 2 Front Yard : Yard Tree Private 2     17 Width 8ft   6009144.65272 2086270.07017 37.709016817728 -122.410135233474 (37.709016817728, -122.410135233474) 9 7 8 309 39
103484 106061 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 12X Canyon Dr 1 Median : Yard Tree DPW 1     40     6003256.93175 2086330.47946 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046) 9 7 6 28861 5
27633 113114 Undocumented 4 Pinus radiata :: Monterey Pine 15 1x TOMASO CT 2 Sidewalk: Property side : Yard Tree Private 2           6009323 2086334 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552) 9 7 8 309 39
46911 113122 Undocumented 4 Pinus radiata :: Monterey Pine 15 1x TOMASO CT 10 Sidewalk: Property side : Yard Tree Private 2           6009323 2086334 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552) 9 7 8 309 39
59885 113113 Undocumented 4 Pinus radiata :: Monterey Pine 15 1x TOMASO CT 1 Sidewalk: Property side : Yard Tree Private 2           6009323 2086334 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552) 9 7 8 309 39
34412 178245 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 62 Tomaso Ct 8 Front Yard : Yard Tree Private 2     39 Width 8ft   6009206.68729 2086340.63676 37.7092140561483 -122.409925810128 (37.7092140561483, -122.409925810128) 9 7 8 309 39
149895 255973 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 90X San Diego Ave 1 Median : Yard Tree Private 2       10x10   5992838 2086352 37.7083142855385 -122.466498894096 (37.7083142855385, -122.466498894096) 9 8 6 28861 25
48856 178273 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 98 San Diego Ave 2 Front Yard : Yard Tree Private 2     17     5992768.65673 2086361.85687 37.7083373484579 -122.466739266325 (37.7083373484579, -122.466739266325) 9 8 6 28861 25
62554 178272 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 35 Tomaso Ct 10 Side Yard : Yard Tree Private 2     22 Width 3ft   6009218.69223 2086367.8804 37.7092895344499 -122.409886240875 (37.7092895344499, -122.409886240875) 9 7 8 309 39
65188 106909 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 254 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2     51 6x6   6001705.95388 2086562.81591 37.7094008786158 -122.435865357921 (37.7094008786158, -122.435865357921) 9 7 6 28861 5
164999 104135 Undocumented 4 Pinus radiata :: Monterey Pine 15 254 WINDING WAY 2 Sidewalk: Curb side : Cutout Tree Private 2     60 6x9   6001720 2086577 37.7094406229145 -122.435817826478 (37.7094406229145, -122.435817826478) 9 7 6 28861 5
53102 102229 Undocumented 4 Pinus radiata :: Monterey Pine 15 254 WINDING WAY 2 Sidewalk: Curb side : Cutout Tree Private 2     45 6x9   6001720 2086577.5 37.7094419958048 -122.435817862229 (37.7094419958048, -122.435817862229) 9 7 6 28861 5

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