1,977 rows where qSpecies_id = 41 sorted by Neighborhoods (old)

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                      
703 262210 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2011 Bay Shore Blvd 1 Front Yard : Yard Tree Private 2       3x3   6012422 2088364 37.7149494891568 -122.398955034798 (37.7149494891568, -122.398955034798) 10 3 8 309 1
10153 262205 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2 Lois Ln 1 Back Yard : Yard Tree Private 2       3x3   6012244 2087959 37.7138275196569 -122.39954186434 (37.7138275196569, -122.39954186434) 10 3 8 309 1
13759 190995 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10x Cashmere St 3 Median : Yard Tree DPW 1     28     6017237.22965 2095860.87095 37.7358015834667 -122.382832806316 (37.7358015834667, -122.382832806316) 10 3 8 58 1
25939 190985 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 17 Front Yard : Yard Tree Private 2     13     6016130.05616 2100249.95648 37.747791881903 -122.386966789196 (37.747791881903, -122.386966789196)   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)
);