trees

2,306 rows where qSpecies_id = 15 sorted by qAddress

✎ 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)
8781 94862 Permitted Site 7 Pinus radiata :: Monterey Pine 15   2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
10108 94859 Permitted Site 7 Pinus radiata :: Monterey Pine 15   1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
62478 178331 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Crespi Dr 3 Sidewalk: Property side : Yard Tree Private 2     14     5990248.62782 2090529.49404 37.7196348982192 -122.47575281776 (37.7196348982192, -122.47575281776) 1 8 4 64 14
119351 178330 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Crespi Dr 2 Sidewalk: Property side : Yard Tree Private 2     13     5990231.62588 2090527.90324 37.7196295445501 -122.47581147062 (37.7196295445501, -122.47581147062) 1 8 4 64 14
120992 178329 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Crespi Dr 1 Sidewalk: Property side : Yard Tree Private 2     10     5990213.26487 2090523.74185 37.719617053851 -122.47587463361 (37.719617053851, -122.47587463361) 1 8 4 64 14
59167 178308 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Font Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     31     5990210.12045 2089417.27348 37.7165787833656 -122.475804743705 (37.7165787833656, -122.475804743705) 1 8 4 64 14
28994 178321 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree Private 2     20     5989145.21541 2089457.74529 37.716628110272 -122.479488503489 (37.716628110272, -122.479488503489) 1 8 4 64 14
30187 178322 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree Private 2     31     5989407.26888 2089196.13882 37.7159250221006 -122.478563605643 (37.7159250221006, -122.478563605643) 1 8 4 64 14
69769 178320 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     28     5988848.05481 2089780.78106 37.7174978203386 -122.480539260585 (37.7174978203386, -122.480539260585) 1 8 4 64 14
86816 178324 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     30     5990257.38166 2089553.17282 37.7169546693979 -122.475651304982 (37.7169546693979, -122.475651304982) 1 8 4 64 14
104889 178326 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     25     5990372.21154 2089922.4902 37.7179753801352 -122.475281345478 (37.7179753801352, -122.475281345478) 1 8 4 64 14
136388 178325 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     28     5990390.33795 2089760.93363 37.7175328363477 -122.475206903186 (37.7175328363477, -122.475206903186) 1 8 4 64 14
143935 178328 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     29     5990317.34225 2090043.87869 37.7183055023747 -122.475479860906 (37.7183055023747, -122.475479860906) 1 8 4 64 14
172367 178323 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     26     5990245.32384 2089538.47983 37.7169136270349 -122.475691910275 (37.7169136270349, -122.475691910275) 1 8 4 64 14
189125 178327 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     28     5990329.94614 2089929.88135 37.7179932244997 -122.475427976322 (37.7179932244997, -122.475427976322) 1 8 4 64 14
18809 218136 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Noriega St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5992370.84065 2103479.76822 37.7553158970187 -122.469359289996 (37.7553158970187, -122.469359289996) 1 8 4 56 12
141282 218138 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Noriega St 4 Sidewalk: Curb side : Yard Tree Private 2     18 Width 0ft   5992012.78076 2103568.58372 37.7555390629029 -122.470604025479 (37.7555390629029, -122.470604025479) 1 8 4 56 12
148573 218137 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Noriega St 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5992341.41081 2103487.78695 37.7553362136098 -122.469461649962 (37.7553362136098, -122.469461649962) 1 8 4 56 12
24957 234529 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 San Jose Av Off Ramp 8 Front Yard : Yard Tree Private 2     12     6002999.62487 2095331.39066 37.7335508412 -122.432019955754 (37.7335508412, -122.432019955754) 2 7 5 63 7
51495 234527 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 San Jose Av Off Ramp 2 Front Yard : Yard Tree Private 2     39     6002909.37025 2095287.39297 37.7334249163266 -122.432328850416 (37.7334249163266, -122.432328850416) 2 7 5 63 7
64689 234530 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 San Jose Av Off Ramp 9 Front Yard : Yard Tree Private 2     27     6003016.33613 2095337.77177 37.7335693096769 -122.431962635665 (37.7335693096769, -122.431962635665) 2 7 5 63 7
143195 234528 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 San Jose Av Off Ramp 3 Front Yard : Yard Tree Private 2     46     6002924.2654 2095295.03485 37.7334467437666 -122.432277899312 (37.7334467437666, -122.432277899312) 2 7 5 63 7
147625 234526 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 San Jose Av Off Ramp 1 Front Yard : Yard Tree Private 2     36     6002889.3394 2095280.36515 37.7334044837183 -122.432397600873 (37.7334044837183, -122.432397600873) 2 7 5 63 7
13538 178318 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 3 Sidewalk: Curb side : Yard Tree Private 2     32     5988183.85887 2090397.25913 37.7191518903345 -122.482880208457 (37.7191518903345, -122.482880208457) 1 8 4 64 14
26929 178314 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 1 Sidewalk: Curb side : Yard Tree Private 2     36     5989006.41886 2090486.32798 37.7194442778983 -122.480043480515 (37.7194442778983, -122.480043480515) 1 8 4 64 14
34113 178309 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 2 Sidewalk: Curb side : Yard Tree Private 2     30     5989840.96696 2090677.12627 37.720016616367 -122.477172722251 (37.720016616367, -122.477172722251) 1 8 4 64 14
68508 178312 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 1 Sidewalk: Curb side : Yard Tree Private 2     24     5989196.07168 2090595.40584 37.7197547958347 -122.479395903892 (37.7197547958347, -122.479395903892) 1 8 4 64 14
103172 178317 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 1 Sidewalk: Curb side : Yard Tree Private 2     28     5988563.85117 2090373.52509 37.7191088253898 -122.481564998528 (37.7191088253898, -122.481564998528) 1 8 4 64 14
119790 178310 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 5 Sidewalk: Curb side : Yard Tree Private 2     34     5989465.34816 2090743.32296 37.7201765760646 -122.478475931633 (37.7201765760646, -122.478475931633) 1 8 4 64 14
120131 178316 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 4 Sidewalk: Curb side : Yard Tree Private 2     28     5988657.395 2090367.41703 37.719097493043 -122.481241210216 (37.719097493043, -122.481241210216) 1 8 4 64 14
180411 178315 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 2 Sidewalk: Curb side : Yard Tree Private 2     38     5988883.66138 2090326.3057 37.7189977636133 -122.480456095784 (37.7189977636133, -122.480456095784) 1 8 4 64 14
186165 178319 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 1 Sidewalk: Curb side : Yard Tree Private 2     25     5988184.71166 2090359.26888 37.7190476283173 -122.482874477988 (37.7190476283173, -122.482874477988) 1 8 4 64 14
193382 178313 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0 Serrano Dr 1 Sidewalk: Curb side : Yard Tree Private 2     43     5989165.0392 2090617.52486 37.7198137266005 -122.479504788413 (37.7198137266005, -122.479504788413) 1 8 4 64 14
16196 251543 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 0X Bay Shore Blvd Off Ramp   Side Yard : Yard Tree Private 2                              
30517 246697 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1 Bonview St 3 Sidewalk: Curb side : Yard Tree Private 2     16     6007653.37008 2099025.40867 37.7439565377568 -122.416192111692 (37.7439565377568, -122.416192111692) 2 7 7 28859 2
34903 246701 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1 Bonview St 7 Sidewalk: Curb side : Yard Tree Private 2     18     6007685.33931 2099084.9994 37.744121958161 -122.416085788444 (37.744121958161, -122.416085788444) 2 7 7 28859 2
154657 100850 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 Estero Ave 1 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
92908 211179 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1 Geneva Ave 4 : Tree Private 2     18 Width 0ft   5997208.95655 2091525.75307 37.7227714708997 -122.451765419354 (37.7227714708997, -122.451765419354) 9 8 4 28861 24
149707 108978 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 MIGUEL ST 1 Front Yard : Yard Tree Private 2     44     6003334.2 2097391.9 37.7392274919289 -122.431010244874 (37.7392274919289, -122.431010244874) 2 7 5 63 7
81078 114978 Undocumented 4 Pinus radiata :: Monterey Pine 15 1 PETER YORKE WAY 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6005775 2114336 37.7858899958642 -122.423775516058 (37.7858899958642, -122.423775516058) 13 9 1 28858 41
166062 115436 Undocumented 4 Pinus radiata :: Monterey Pine 15 1 PETER YORKE WAY 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6005775 2114336 37.7858899958642 -122.423775516058 (37.7858899958642, -122.423775516058) 13 9 1 28858 41
182174 115437 Undocumented 4 Pinus radiata :: Monterey Pine 15 1 PETER YORKE WAY 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6005775 2114336 37.7858899958642 -122.423775516058 (37.7858899958642, -122.423775516058) 13 9 1 28858 41
120537 250021 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1 Peter Yorke Way 10 Sidewalk: Property side : Yard Tree Private 2     20     6005906.53716 2114478.71267 37.7862892740647 -122.423330582061 (37.7862892740647, -122.423330582061) 13 9 1 28858 41
9862 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
59395 114525 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
38051 108038 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 Twin Peaks Blvd   Front Yard : Yard Tree Private 2           5998985.48572 2105240.3128 37.7605299471227 -122.446610614338 (37.7605299471227, -122.446610614338) 15 5 5 28862 12
107306 217848 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1 Woodacre Dr 3 Sidewalk: Curb side : Yard Tree Private 2     40     5991432.09089 2095719.97643 37.7339552123593 -122.472040172642 (37.7339552123593, -122.472040172642) 1 8 4 64 40
138186 1 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 10 10th Ave 1 Median : Cutout Tree DPW 1     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.468982710496 (37.7866097734767, -122.468982710496) 11 6 1 54 11
137033 114410 Property Tree 8 Pinus radiata :: Monterey Pine 15 10 GARDENSIDE DR   Sidewalk: Curb side : Cutout Tree Private 2           5999306 2102458 37.7529087049134 -122.445302055175 (37.7529087049134, -122.445302055175) 2 5 5 63 38
90360 178276 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 10 Lake Merced Blvd 3 : Tree Private 2     21 Width 0ft   5987587.71013 2089755.99269 37.7173564298339 -122.4848938211 (37.7173564298339, -122.4848938211) 1 8 4 64 14
125282 110236 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100 BUCHANAN ST 1 Sidewalk: Curb side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.7712187378523 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
61216 116672 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Esmeralda Ave 9 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
35987 8295 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Garcia Ave 5 Median : Cutout Tree DPW 1     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.459939898511 (37.743936899881, -122.459939898511) 1 8 4 59 40
65518 8293 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Garcia Ave 3 Median : Cutout Tree DPW 1     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.459939898511 (37.743936899881, -122.459939898511) 1 8 4 59 40
73811 8291 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Garcia Ave 1 Median : Cutout Tree DPW 1     6 8   5995006.6013281 2099280.197711 37.743936899881 -122.459939898511 (37.743936899881, -122.459939898511) 1 8 4 59 40
78424 8292 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Garcia Ave 2 Median : Cutout Tree DPW 1     18 8   5995006.6013281 2099280.197711 37.743936899881 -122.459939898511 (37.743936899881, -122.459939898511) 1 8 4 59 40
166232 8294 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Garcia Ave 4 Median : Cutout Tree DPW 1     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.459939898511 (37.743936899881, -122.459939898511) 1 8 4 59 40
43876 114817 Property Tree 8 Pinus radiata :: Monterey Pine 15 100 RACCOON DR 1 Back Yard : Cutout Tree Private 2           5998725 2104028 37.757186355085 -122.447424250084 (37.757186355085, -122.447424250084) 15 5 5 63 3
4731 19749 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY15 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
2812 19775 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY18 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 50ST                      
11962 19853 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY29 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
4776 19969 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY43 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 15                      
14843 19968 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY43 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
16184 19977 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY45 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
5216 20045 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY52 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
3000 20052 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY53 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
16411 20053 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY53 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
6984 20069 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY55 2 Sidewalk: Curb side : Cutout Tree DPW 1     36 40ST                      
14280 20070 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY55 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
23678 211144 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 3 Sidewalk: Curb side : Yard Tree Private 2     33     5993373.46569 2096862.7426 37.7372051149341 -122.465411285997 (37.7372051149341, -122.465411285997) 1 8 4 59 40
53818 211150 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 9 Sidewalk: Curb side : Yard Tree Private 2     46     5993560.03035 2096750.42119 37.7369074662969 -122.464758097607 (37.7369074662969, -122.464758097607) 1 8 4 59 40
65529 211148 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 7 Sidewalk: Curb side : Yard Tree Private 2     31     5993527.53053 2096770.01108 37.7369593814624 -122.46487188524 (37.7369593814624, -122.46487188524) 1 8 4 59 40
86697 211149 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 8 Sidewalk: Curb side : Yard Tree Private 2     41     5993545.6652 2096759.54622 37.7369316931402 -122.464808426368 (37.7369316931402, -122.464808426368) 1 8 4 59 40
107586 211143 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 2 Sidewalk: Curb side : Yard Tree Private 2     30     5993358.77763 2096871.55975 37.737228477512 -122.465462709251 (37.737228477512, -122.465462709251) 1 8 4 59 40
108680 211152 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 25 Sidewalk: Curb side : Yard Tree Private 2     34     5993733.1055 2096523.04642 37.7362931286276 -122.464143203246 (37.7362931286276, -122.464143203246) 1 8 4 59 40
187288 211151 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 10 Sidewalk: Curb side : Yard Tree Private 2     39     5993575.92443 2096738.74273 37.7368763164955 -122.464702297369 (37.7368763164955, -122.464702297369) 1 8 4 59 40
191938 211147 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 6 Sidewalk: Curb side : Yard Tree Private 2     28     5993511.61003 2096780.42946 37.7369870697942 -122.464927685472 (37.7369870697942, -122.464927685472) 1 8 4 59 40
193178 211142 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Terrace Dr 1 Sidewalk: Curb side : Yard Tree Private 2     31     5993344.39912 2096880.05499 37.7372509740365 -122.465513038912 (37.7372509740365, -122.465513038912) 1 8 4 59 40
50385 16381 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Moraga St 3 Median : Cutout Tree DPW 1     24 12   5991038.11952 2103837.44782 37.7562208847883 -122.473994287918 (37.7562208847883, -122.473994287918) 1 8 4 56 12
2194 261477 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 6 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
2808 261474 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 4 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
5304 261473 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 3 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
7152 261481 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 10 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
9819 261478 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 7 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
12253 261479 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 8 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
14470 261472 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 1 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
94145 233283 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 San Jose Ave 76 Front Yard : Yard Tree Private 2     2     6005053.15059 2097036.60001 37.7383491703834 -122.425041606983 (37.7383491703834, -122.425041606983) 2 7 5 63 7
123696 194478 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Texas St 2 Front Yard : Yard Tree Private 2     36     6013925.61111 2102123.62006 37.7528142537945 -122.394720899468 (37.7528142537945, -122.394720899468) 10 3 8 28856 29
177655 194477 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Texas St 1 Front Yard : Yard Tree Private 2     37     6013908.27444 2102233.75002 37.7531156831575 -122.394788565357 (37.7531156831575, -122.394788565357) 10 3 8 28856 29
104452 110629 Undocumented 4 Pinus radiata :: Monterey Pine 15 1000X MANDALAY LN 1 Unaccepted Street : Cutout Tree Private 2           5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
144061 114590 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000X MORAGA ST 2 Median : Cutout Tree DPW 1     30 12   5991075 2103884 37.7563508410106 -122.47387013998 (37.7563508410106, -122.47387013998) 1 8 4 56 12
9066 260960 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
168614 108208 Undocumented 4 Pinus radiata :: Monterey Pine 15 100X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2           6000799.34617 2109469.60329 37.7722459721119 -122.440640678445 (37.7722459721119, -122.440640678445) 15 5 11 29492 9
5980 113539 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 2 Median : Yard Tree DPW 1     20     6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
66798 113536 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 3 Median : Yard Tree DPW 1           6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
77642 113535 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 1 Median : Yard Tree DPW 1   12/05/2015 12:49:00 PM 3     6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
104162 113537 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 4 Median : Yard Tree DPW 1           6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
128651 113538 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 5 Median : Yard Tree DPW 1           6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
138693 102270 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X Casitas Ave 4 Median : Cutout Tree DPW 1     12 6x100   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
188717 254288 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X Junipero Serra Blvd 4 Median : Yard Tree Private 2       3x3   5991400 2095443 37.7331928478719 -122.472130937334 (37.7331928478719, -122.472130937334) 1 8 4 64 40

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