1,977 rows where qSpecies_id = 41 sorted by Zip Codes

View and edit SQL

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)
80 260998 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree SFUSD 4       10x10                      
106 251438 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Santiago St 1 Median : Yard Tree DPW 1                              
394 119605 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 299x Avalon Ave 1 Front Yard : Yard Tree Private 2                              
509 19905 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 120ST                      
537 261951 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 5 Sidewalk: Property side : Yard Tree DPW 1                              
595 261954 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 8 Sidewalk: Property side : Yard Tree DPW 1                              
657 20296 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
720 19950 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
795 19570 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 4 Sidewalk: Curb side : Cutout Tree DPW 1     48 100ST                      
1051 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
2302 19935 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
2744 261957 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 11 Sidewalk: Property side : Yard Tree DPW 1                              
2858 261960 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 14 Sidewalk: Property side : Yard Tree DPW 1                              
3011 19948 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 25ST                      
3028 19906 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
3052 19908 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
3078 19568 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 2 Sidewalk: Curb side : Cutout Tree DPW 1     48 100ST                      
3098 20419 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
3191 19565 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 -11 Sidewalk: Curb side : Cutout Tree DPW 1     36 100ST                      
3442 20392 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 38 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
4154 261966 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 20 Sidewalk: Property side : Yard Tree DPW 1                              
4336 20312 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 101X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
4465 20303 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 50X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
4930 20365 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
5295 19947 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 25ST                      
5357 19933 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
5438 20428 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 485X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     42 40                      
5813 20297 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
6028 261967 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 299x Portola Dr 1 Median : Yard Tree DPW 1                              
6583 20407 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 52 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
6724 261948 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 2 Sidewalk: Property side : Yard Tree DPW 1                              
7317 20294 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
7644 19569 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 3 Sidewalk: Curb side : Cutout Tree DPW 1     48 100ST                      
7787 19910 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 120ST                      
8411 19699 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY11 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 40ST                      
8535 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
8582 19955 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 2ST                      
8866 20398 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
8937 19804 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY22 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 20                      
9183 261965 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 19 Sidewalk: Property side : Yard Tree DPW 1                              
9387 19932 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
9705 261963 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 17 Sidewalk: Property side : Yard Tree DPW 1                              
9757 261950 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 4 Sidewalk: Property side : Yard Tree DPW 1                              
9922 261964 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 18 Sidewalk: Property side : Yard Tree DPW 1                              
10143 256870 Planning Code 138.1 required 2 Cupressus macrocarpa :: Monterey Cypress 41 30X Bernal Heights Blvd 1 Back Yard : Cutout Tree Private 2       12x6                      
10413 20317 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 101X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
11142 20455 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 495X Sunset Blvd 20 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
11294 20417 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
12224 19907 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 120ST                      
12236 20366 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
12293 20434 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 485X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
12390 20412 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
12448 261958 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 12 Sidewalk: Property side : Yard Tree DPW 1                              
12674 19753 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY15 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
12679 19813 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY24 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
12914 20429 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 485X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     42 30                      
12968 19943 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
13027 261955 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 9 Sidewalk: Property side : Yard Tree DPW 1                              
13064 19694 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY7 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 12ST                      
13121 261953 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 7 Sidewalk: Property side : Yard Tree DPW 1                              
13143 19776 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY18 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
13162 251365 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 2 Sidewalk: Property side : Yard Tree Private 2                              
13223 19700 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY11 2 Sidewalk: Curb side : Cutout Tree DPW 1     36 40ST                      
13417 19945 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
13718 251364 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 1 Sidewalk: Property side : Yard Tree Private 2                              
14026 19949 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 25ST                      
14194 261962 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 16 Sidewalk: Property side : Yard Tree DPW 1                              
14203 20280 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
14241 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
14832 261961 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 15 Sidewalk: Property side : Yard Tree DPW 1                              
14966 20413 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
15219 251366 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 3 Sidewalk: Property side : Yard Tree Private 2                              
15603 251321 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Monument Way 1 Unaccepted Street : Yard Tree Private 2                              
15795 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
15823 20424 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
15891 261952 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 6 Sidewalk: Property side : Yard Tree DPW 1                              
15921 20422 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
15978 20430 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 485X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     42 30                      
16093 19936 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
16153 19978 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY45 5 Sidewalk: Curb side : Cutout Tree DPW 1     36 30ST                      
16212 261956 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 10 Sidewalk: Property side : Yard Tree DPW 1                              
16465 19951 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
16556 20423 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
16638 19909 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 120ST                      
16749 20291 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
16814 261949 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 3 Sidewalk: Property side : Yard Tree DPW 1                              
17534 261947 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 1 Sidewalk: Property side : Yard Tree DPW 1                              
17805 20377 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
17984 20373 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
18123 19934 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
18542 19869 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY33 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 25ST                      
18620 261959 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 13 Sidewalk: Property side : Yard Tree DPW 1                              
19208 19953 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
19293 20452 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 495X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
19500 20013 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY47 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
19615 19566 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 -9 Sidewalk: Curb side : Cutout Tree DPW 1     36 100ST                      
22522 176121 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3500 Great Hwy 8 Median : Tree Private 2     6 Width 0ft   5982310.61133 2092790.70938 37.7253801793381 -122.503358567347 (37.7253801793381, -122.503358567347) 1 8 4   14
43328 176117 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3500 Great Hwy 1 : Tree Private 2     27 Width 0ft   5982122.73417 2092919.02565 37.7257214549599 -122.504017530281 (37.7257214549599, -122.504017530281) 1 8 4   14
71432 176119 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3500 Great Hwy 3 : Tree Private 2     6 Width 0ft   5982177.8802 2092874.78727 37.7256032309891 -122.503823622987 (37.7256032309891, -122.503823622987) 1 8 4   14
81691 176125 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3500 Great Hwy 12 Median : Tree Private 2     2 Width 0ft   5982332.21205 2092769.07574 37.7253220489632 -122.503282295835 (37.7253220489632, -122.503282295835) 1 8 4   14

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