trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

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