1,977 rows where qSpecies_id = 41

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)
8274 2988 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2266X California St 4 Sidewalk: Property side : Cutout Tree DPW 1     35 3X3   6003528.90719 2115622.95537 37.7892965998021 -122.431638286196 (37.7892965998021, -122.431638286196) 13 9 1 29490 27
8394 206864 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700 Junipero Serra Blvd 108 : Tree Private 2     16 Width 0ft   5991230.74264 2091941.55129 37.7235689492395 -122.472460922234 (37.7235689492395, -122.472460922234) 9 8 4 64 40
8411 19699 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY11 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 40ST                      
8421 126411 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3398 Pierce St 1 Sidewalk: Property side : Yard Tree Private 2     20 Width 3ft   6001324.1548 2120088.88928 37.8014336702784 -122.439586737243 (37.8014336702784, -122.439586737243) 13 9 1 57 17
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                      
8619 262142 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 420X Portola Dr 3 Median : Yard Tree DPW 1 Private     3x3   5998701 2100185 37.7466330487878 -122.44723067426 (37.7466330487878, -122.44723067426) 2 7 5 63 22
8678 185706 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2101 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     39 Width 0ft   5984860.1074 2100483.4684 37.7466519838878 -122.495112335974 (37.7466519838878, -122.495112335974) 1 8 3 29491 35
8751 262427 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
8755 5050 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 5399X Diamond Heights Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     19     6001979.62541 2098516.88417 37.7422395880754 -122.43577421703 (37.7422395880754, -122.43577421703) 2 7 5 63 22
8830 21239 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2401X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5985051.1945321 2098862.1753589 37.7422115377949 -122.494332098234 (37.7422115377949, -122.494332098234) 1 8 3 29491 35
8866 20398 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
8932 254133 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100X Lake Merced Blvd 7 Median : Yard Tree DPW 1       10x10   5983894 2095251 37.7322284370415 -122.498066633405 (37.7322284370415, -122.498066633405) 1 8 4 64 35
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                              
9303 259269 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
9387 19932 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
9414 206806 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 175 Garcia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     44 Width 4ft   5994639.44486 2099406.32417 37.7442620887181 -122.461218572898 (37.7442620887181, -122.461218572898) 1 8 4 59 40
9448 251375 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 401 Portola Dr 3 Median : Yard Tree DPW 1           5998962 2100210 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078) 2 7 5 63 22
9662 113066 - 12 Cupressus macrocarpa :: Monterey Cypress 41 2X Cranleigh Dr 7 : Tree DPW 1   09/09/2015 01:08:00 PM 3     5991370.3 2095943.7 37.7345659248964 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
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                              
9730 190968 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 8 Sidewalk: Curb side : Yard Tree Private 2     39     6011276.3148 2104337.18505 37.7587445605265 -122.404038467608 (37.7587445605265, -122.404038467608) 10 3 8 28856 29
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                              
10025 264885 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1279 44th Ave 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 787806 5982392 2106415 37.7627934961857 -122.504085938563 (37.7627934961857, -122.504085938563) 1 8 3 56 35
10088 253978 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 441 Detroit St 1 Unaccepted Street : Yard Tree Private 2       3x10   5999396 2094599 37.7313349085161 -122.444426062201 (37.7313349085161, -122.444426062201) 9 7 4 59 40
10140 106278 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 200X VIDAL DR 2 Median : Cutout Tree DPW 1     60     5987624 2090693 37.7199313280832 -122.484837086298 (37.7199313280832, -122.484837086298) 1 8 4 64 14
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                      
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
10387 261604 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300X Sloat Blvd 5 Median : Yard Tree Private 2       3x3   5987403 2095938 37.7343198717706 -122.485985793061 (37.7343198717706, -122.485985793061) 1 8 3 64 35
10395 260478 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3333 California St 8 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
10397 261602 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Sloat Blvd 2 Median : Cutout Tree Private 2       10x10   5989247 2095899 37.7343200773404 -122.47960770916 (37.7343200773404, -122.47960770916) 1 8 4 64 35
10413 20317 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 101X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
10605 260507 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 50X Carver St 1 Median : Cutout Tree DPW 1 Private     3x3   6009420 2098346 37.742190207281 -122.410035530349 (37.742190207281, -122.410035530349) 10 7 7 28859 2
10672 223744 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 591 27th St 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 4ft   6002700.25317 2100030.09519 37.7464354200694 -122.433390619685 (37.7464354200694, -122.433390619685) 2 7 5 63 22
10694 187382 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2200 Sunset Blvd 68 Sidewalk: Property side : Yard Tree Private 2     21 Width 0ft   5985066.1507 2100087.3826 37.7455765004249 -122.494370678244 (37.7455765004249, -122.494370678244) 1 8 3 29491 35
10739 186360 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1801 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984814.758 2102602.0458 37.7524663619043 -122.495425370042 (37.7524663619043, -122.495425370042) 1 8 3 56 35
11014 262425 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
11142 20455 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 495X Sunset Blvd 20 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
11254 259267 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
11294 20417 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
11407 260477 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3333 California St 7 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
11442 260571 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 5 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11463 260828 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 165 Cerritos Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5991854 2092943 37.7263547341381 -122.470379348754 (37.7263547341381, -122.470379348754) 9 8 4 59 40
11583 261603 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300X Sloat Blvd 4 Median : Yard Tree Private 2       3x3   5987403 2095938 37.7343198717706 -122.485985793061 (37.7343198717706, -122.485985793061) 1 8 3 64 35
11790 254293 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 110 Junipero Serra Blvd 5 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
11875 260569 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 3 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11921 263623 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
11929 253845 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 150 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       3x3   5991384 2095197 37.7325164679088 -122.472168327848 (37.7325164679088, -122.472168327848) 1 8 4 64 40
12058 253308 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 6 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
12152 255704 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 201X Hernandez Ave 1 Side Yard : Yard Tree Private 2       10x10   5995122 2099706 37.7451126829106 -122.459571712369 (37.7451126829106, -122.459571712369) 1 8 4 59 40
12210 20839 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1801X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     36 60   5984911.465596 2102939.293478 37.7533980132231 -122.495115810531 (37.7533980132231, -122.495115810531) 1 8 3 56 35
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                      
12287 95982 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 100 Vasquez Ave 1 Back Yard : Yard Tree Private 2           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972) 1 8 4 59 40
12293 20434 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 485X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
12370 187404 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2100 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     50 Width 0ft   5985026.9229 2100775.7749 37.7474643426041 -122.494557058858 (37.7474643426041, -122.494557058858) 1 8 3 29491 35
12390 20412 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
12393 261459 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 701X Delano Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5999135 2090407 37.7198097539444 -122.445027136249 (37.7198097539444, -122.445027136249) 9 7 6 28861 25
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                              
12495 126414 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2836 Larkin St 10 Side Yard : Yard Tree Private 2     12     6006501.05561 2120998.53971 37.8042246191233 -122.421736962694 (37.8042246191233, -122.421736962694) 5 9 1 28858 32
12505 205919 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 230 Edna St 2 Side Yard : Yard Tree Private 2     34     5998797.1475 2095343.94395 37.7333461617934 -122.446549972916 (37.7333461617934, -122.446549972916) 9 7 4 59 40
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                      
12689 22877 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 951X Mansell St 4 Median : Cutout Tree DPW 1     6 3X100   6009106.075934 2090003.4402519 37.7192657205166 -122.410532013931 (37.7192657205166, -122.410532013931) 9 3 7 309 28
12825 181360 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2400 Sunset Blvd 49 unknown : Yard Tree Private 2     47 Width 0ft   5985113.1047 2098629.2701 37.7415756656355 -122.494100873291 (37.7415756656355, -122.494100873291) 1 8 3 29491 35
12885 254297 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 130X Junipero Serra Blvd 3 Median : Yard Tree Private 2       10x30   5991393 2095322 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186) 1 8 4 64 40
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                      
12971 253842 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100X Junipero Serra Blvd 1 Median : Yard Tree Private 2       3x3   5991400 2095443 37.7331928478719 -122.472130937334 (37.7331928478719, -122.472130937334) 1 8 4 64 40
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                      
13098 254290 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 110 Junipero Serra Blvd 2 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
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                      
13149 260567 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 1 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
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                      
13318 262248 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 4210 Ocean Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
13332 8534 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2100 Geary Blvd 5 Median : Cutout Tree DPW 1   06/10/1994 12:00:00 AM 6 6   6001381.7916 2113512.283 37.7833793 -122.438915716928 (37.7833793, -122.438915716928) 15 5 11 29490 41
13417 19945 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
13568 217777 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 470 West Portal Ave 16 Sidewalk: Curb side : Yard Tree Private 2     29     5991442.94255 2096087.95113 37.7349662059076 -122.472029467093 (37.7349662059076, -122.472029467093) 1 8 4 29491 40
13572 261601 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Sloat Blvd 2 Median : Cutout Tree Private 2       10x10   5989483 2096058 37.7347703567949 -122.478803415035 (37.7347703567949, -122.478803415035) 1 8 3 64 35
13593 247903 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 582 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     31     6009830.823 2098729.70619 37.7432667982256 -122.408642088157 (37.7432667982256, -122.408642088157) 10 7 7 28859 2
13718 251364 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 1 Sidewalk: Property side : Yard Tree Private 2                              
13755 11746 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700X Junipero Serra Blvd 29 Median : Cutout Tree DPW 1   03/03/2006 12:00:00 AM 3 6X6   5991277.67104 2092671.80389 37.7255767576586 -122.472351910013 (37.7255767576586, -122.472351910013) 9 8 4 64 40
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
13885 223773 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 310 Liberty St 62 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   6003724.02134 2103929.75159 37.7572009893486 -122.430128695891 (37.7572009893486, -122.430128695891) 2 4 5 28862 3
13890 21325 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985074.8907349 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189) 1 8 3 29491 35
13893 264884 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1624 48th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
13902 115326 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2601X Sunset Blvd 21 Median : Cutout Tree DPW 1       40   5985098.343425 2097506.3093477 37.7384914535226 -122.494069167367 (37.7384914535226, -122.494069167367) 1 8 3 29491 35
13915 20977 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2002X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     36 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
13937 253313 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Euclid Ave 11 Sidewalk: Curb side : Cutout Tree Private 2           5999085 2114289 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697) 15 6 1 54 31
13972 260573 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 129 Edgehill Way 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5994858 2098970 37.7430766268484 -122.460431252252 (37.7430766268484, -122.460431252252) 1 8 4 59 40
13998 206803 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 300 Ortega St 1 Sidewalk: Curb side : Yard Tree Private 2     28     5993087.14993 2102582.23712 37.7528928770087 -122.466816856226 (37.7528928770087, -122.466816856226) 1 8 4 56 12
14026 19949 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 25ST                      
14139 186412 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601 Sunset Blvd 7 Median : Yard Tree Private 2     0 Width 0ft   5984810.0324 2103749.2702 37.7556160465723 -122.495526318381 (37.7556160465723, -122.495526318381) 1 8 3 56 35
14193 186443 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984758.9481 2103937.6958 37.7561304196042 -122.495716879396 (37.7561304196042, -122.495716879396) 1 8 3 56 35
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                      

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