Street_Tree_List

Data source: data.sfgov.org

352 rows where qSpecies = 71 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
187908 187908 181540 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1300 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984863.0454 2105869.1102 37.7614396414651 -122.49549932614799 (37.7614396414651, -122.495499326148)
185848 185848 132161 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 165 Francisco St 10 Front Yard : Yard 7 Tree 1 Private 1     15     6010552.8238 2121311.7929599998 37.8053123842132 -122.407737540175 (37.8053123842132, -122.407737540175)
185501 185501 184347 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1251 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984658.9334 2106421.3632 37.7629440193232 -122.49624600189699 (37.7629440193232, -122.496246001897)
185213 185213 187193 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2301 Sunset Blvd 55 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984945.2043 2099085.395 37.7428182353231 -122.49471502746701 (37.7428182353231, -122.494715027467)
184099 184099 200557 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 33 Median : Cutout 11 Tree 1 DPW 2     17 Width 0ft   6016298.6383 2095516.7839 37.734804887646796 -122.386053935891 (37.7348048876468, -122.386053935891)
184043 184043 178171 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988123.04078 2089845.83927 37.71763429155529 -122.483050036443 (37.7176342915553, -122.483050036443)
183666 183666 187385 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2200 Sunset Blvd 71 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985037.3743 2100116.159 37.7456538284953 -122.49447230207399 (37.7456538284953, -122.494472302074)
183135 183135 186167 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1700 Sunset Blvd 52 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984926.5892 2103481.0156 37.7548863180592 -122.49510345420799 (37.7548863180592, -122.495103454208)
183116 183116 211029 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 162 : 4 Tree 1 Private 1     5 Width 0ft   5991185.525 2091363.77787 37.721979909226704 -122.472575126241 (37.7219799092267, -122.472575126241)
181713 181713 200526 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 2 Median : Cutout 11 Tree 1 DPW 2     20 Width 0ft   6016126.5305 2095710.5736 37.735327468440204 -122.386662486514 (37.7353274684402, -122.386662486514)
181664 181664 178138 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 9 : 4 Tree 1 Private 1     7 Width 0ft   5992224.93754 2087880.30275 37.71247524252121 -122.46872882029699 (37.7124752425212, -122.468728820297)
179816 179816 211003 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Portola Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996800.72253 2099394.55039 37.7443539050009 -122.453744529511 (37.7443539050009, -122.453744529511)
179757 179757 185955 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2001 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984875.9978 2101408.1817 37.7491919243755 -122.49512556709298 (37.7491919243755, -122.495125567093)
179683 179683 185932 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2000 Sunset Blvd 75 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984999.1426 2101513.5873 37.7494885480173 -122.494707506851 (37.7494885480173, -122.494707506851)
179595 179595 185906 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2000 Sunset Blvd 49 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985026.2976 2101345.2263 37.7490278641469 -122.49460119526 (37.7490278641469, -122.49460119526)
179412 179412 178168 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 23 : 4 Tree 1 Private 1     5 Width 0ft   5992821.74753 2087850.08942 37.712426743882 -122.46666388422899 (37.712426743882, -122.466663884229)
179339 179339 139329 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1350x GEARY BLVD 3 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   6005196.3246 2114113.3931 37.785246088934706 -122.425761723999 (37.7852460889347, -122.425761723999)
177987 177987 186620 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1501 Sunset Blvd 91 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984755.0749 2104355.2681 37.7572767304033 -122.495761074715 (37.7572767304033, -122.495761074715)
177953 177953 234476 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 784 Duncan St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   6001432.63511 2099723.41327 37.745521346435204 -122.43775192962799 (37.7455213464352, -122.437751929628)
177368 177368 181473 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1400 Sunset Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984918.4628 2105275.6702 37.759813465723795 -122.49526389807 (37.7598134657238, -122.49526389807)
177231 177231 200533 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 9 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6016162.6096 2095677.4311 37.7352384631645 -122.38653543635799 (37.7352384631645, -122.386535436358)
177190 177190 200529 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 5 Median : Cutout 11 Tree 1 DPW 2     16 Width 0ft   6016150.0239 2095691.2754 37.7352757800904 -122.386579915171 (37.7352757800904, -122.386579915171)
176986 176986 178144 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 15 : 4 Tree 1 Private 1     4 Width 0ft   5991934.88004 2087954.77106 37.712662953501294 -122.46973675705799 (37.7126629535013, -122.469736757058)
176294 176294 139358 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1350x GEARY BLVD 7 Median : Cutout 11 Tree 1 DPW 2     19 Width 0ft   6004934.0187 2114075.446 37.7851270694756 -122.426666519258 (37.7851270694756, -122.426666519258)
176067 176067 178146 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 17 : 4 Tree 1 Private 1     4 Width 0ft   5991839.8077 2087981.8975 37.712731940507105 -122.47006732805 (37.7127319405071, -122.47006732805)
175688 175688 185676 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2101 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984839.348999999 2100771.308 37.747441097621206 -122.495205338122 (37.7474410976212, -122.495205338122)
175007 175007 194425 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 132 Kissling St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   6007938.01013 2109107.31213 37.771655137004 -122.41592168104799 (37.771655137004, -122.415921681048)
174927 174927 181557 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1300 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984875.8554 2106073.5142 37.76200162774529 -122.495470098326 (37.7620016277453, -122.495470098326)
174832 174832 185700 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2101 Sunset Blvd 32 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984899.9898 2100515.832 37.7467431803198 -122.494976814737 (37.7467431803198, -122.494976814737)
174392 174392 181538 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1300 Sunset Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984897.5768 2105857.4141 37.761409549185 -122.495379035532 (37.761409549185, -122.495379035532)
173693 173693 178156 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 11 : 4 Tree 1 Private 1     5 Width 0ft   5993327.478519999 2087822.82752 37.712381061909 -122.464913959129 (37.712381061909, -122.464913959129)
173673 173673 211035 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 61 Burnside Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20     6001198.5187 2095714.51341 37.7345005324595 -122.438274321504 (37.7345005324595, -122.438274321504)
173075 173075 186890 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2700 Sunset Blvd 39 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985200.262 2096503.3044 37.7357434330648 -122.493642900348 (37.7357434330648, -122.493642900348)
172927 172927 211028 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 160 : 4 Tree 1 Private 1     4 Width 0ft   5991184.3391 2091378.75733 37.722020970475505 -122.472580317131 (37.7220209704755, -122.472580317131)
172637 172637 211002 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Portola Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5996779.38475 2099373.51377 37.744294920285 -122.45381679181801 (37.744294920285, -122.453816791818)
172467 172467 187388 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2200 Sunset Blvd 74 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985049.5619 2100144.9354 37.7457335539505 -122.49443228067 (37.7457335539505, -122.49443228067)
171859 171859 211005 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 800x Portola Dr 2 Median : Cutout 11 Tree 1 DPW 2     7 Width 4ft   5996562.64616 2099171.2604900002 37.7437271539842 -122.454551615288 (37.7437271539842, -122.454551615288)
171858 171858 185535 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2201 Sunset Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984921.0973 2100070.748 37.745522336384795 -122.49487101697099 (37.7455223363848, -122.494871016971)
171829 171829 178157 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 12 : 4 Tree 1 Private 1     7 Width 0ft   5993292.82373 2087832.959 37.712406882332 -122.46503447098499 (37.712406882332, -122.465034470985)
170936 170936 186435 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1601 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984740.5243 2104016.8346 37.7563466338471 -122.495786431621 (37.7563466338471, -122.495786431621)
170901 170901 178143 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 14 : 4 Tree 1 Private 1     5 Width 0ft   5991964.10718 2087949.4813 37.7126501183836 -122.46963535489999 (37.7126501183836, -122.4696353549)
170555 170555 181384 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1500 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984945.4334 2104486.2478 37.75764751046 -122.49511240858 (37.75764751046, -122.49511240858)
170076 170076 178164 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 19 : 4 Tree 1 Private 1     5 Width 0ft   5993000.50065 2087852.84302 37.71244461881 -122.46604626403 (37.71244461881, -122.46604626403)
170060 170060 185310 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2601 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984962.2385 2097256.121 37.737796538483295 -122.494521307154 (37.7377965384833, -122.494521307154)
169856 169856 200573 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 43 Median : Cutout 11 Tree 1 DPW 2     17 Width 0ft   6016335.7649 2095440.4518 37.734597349697104 -122.385920256211 (37.7345973496971, -122.385920256211)
169644 169644 185964 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2001 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984823.122 2101326.4259 37.7489643495953 -122.495302381208 (37.7489643495953, -122.495302381208)
169232 169232 178173 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988347.73388 2089792.82325 37.717501795356 -122.482269501364 (37.717501795356, -122.482269501364)
168152 168152 211014 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 53 : 4 Tree 1 Private 1     3 Width 0ft   5991322.30761 2093384.4785900002 37.7275361681597 -122.4722495339 (37.7275361681597, -122.4722495339)
166247 166247 120262 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 100 24th Ave 6 Side Yard : Yard 17 Tree 1 Private 1     26     5988353.58713 2115180.43805 37.7872097252822 -122.484109995805 (37.7872097252822, -122.484109995805)
166214 166214 181513 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1400 Sunset Blvd 73 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984909.8299 2105563.3396 37.7606028201969 -122.49531496977501 (37.7606028201969, -122.495314969775)
165671 165671 200567 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 39 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6016322.0539 2095480.6054 37.7347068446432 -122.38597045824699 (37.7347068446432, -122.385970458247)
164960 164960 200615 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 56 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   6016438.8423 2095106.2461 37.7336853915549 -122.38554059619301 (37.7336853915549, -122.385540596193)
164811 164811 178154 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 9 : 4 Tree 1 Private 1     7 Width 0ft   5993415.347159999 2087786.9851099998 37.7122877131728 -122.464607659932 (37.7122877131728, -122.464607659932)
164480 164480 185307 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2601 Sunset Blvd 32 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984973.1253 2097316.8359 37.7379638824881 -122.494488141215 (37.7379638824881, -122.494488141215)
164388 164388 234478 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 398 Surrey St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 5ft   6001098.400769999 2096167.19905 37.7357378071451 -122.43865288754 (37.7357378071451, -122.43865288754)
163628 163628 178129 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 345 Tocoloma Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6012554.38724 2086809.43241 37.7106883309719 -122.398388432799 (37.7106883309719, -122.398388432799)
163106 163106 185033 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2701 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985049.8565 2096299.4419 37.7351748809707 -122.494147882197 (37.7351748809707, -122.494147882197)
162875 162875 211022 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 80 : 4 Tree 1 Private 1     3 Width 0ft   5991230.5084 2092239.13983 37.7243860399747 -122.47248341699101 (37.7243860399747, -122.472483416991)
162182 162182 178153 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 8 : 4 Tree 1 Private 1     7 Width 0ft   5993495.89449 2087748.40295 37.712186418929896 -122.464326467118 (37.7121864189299, -122.464326467118)
161740 161740 178134 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 5 : 4 Tree 1 Private 1     5 Width 0ft   5992424.40969 2087850.98169 37.7124062555176 -122.46803725782699 (37.7124062555176, -122.468037257827)
161559 161559 211006 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 600x Portola Dr 1 Median : Cutout 11 Tree 1 DPW 2     6 Width 4ft   5997174.86391 2099677.95775 37.7451535147355 -122.45247128193701 (37.7451535147355, -122.452471281937)
161403 161403 118538 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 7900x Geary Blvd 1 Median : Cutout 11 Tree 1 DPW 2     11 Width 4ft   5982472.235830001 2112389.87128 37.7792034803758 -122.504251064408 (37.7792034803758, -122.504251064408)
161339 161339 178145 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 16 : 4 Tree 1 Private 1     4 Width 0ft   5991905.80045 2087967.0692099999 37.71269504040679 -122.469838159212 (37.7126950404068, -122.469838159212)
161248 161248 186247 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1701 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984819.3113 2103171.6078 37.754030488698895 -122.49545162726801 (37.7540304886989, -122.495451627268)
161140 161140 178136 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 7 : 4 Tree 1 Private 1     5 Width 0ft   5992351.132540001 2087854.27594 37.7124110686957 -122.468290763208 (37.7124110686957, -122.468290763208)
160645 160645 178163 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 18 : 4 Tree 1 Private 1     5 Width 0ft   5993033.97644 2087855.7565900001 37.712454549997204 -122.465930773993 (37.7124545499972, -122.465930773993)
160627 160627 186893 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2700 Sunset Blvd 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985181.9251 2096557.8565 37.7358921458374 -122.493710315825 (37.7358921458374, -122.493710315825)
160510 160510 234472 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 4810 17th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 2ft   5998175.60392 2105685.14055 37.7617050378737 -122.44944366388701 (37.7617050378737, -122.449443663887)
159854 159854 247525 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1101 Waller St 6 Side Yard : Yard 17 Tree 1 Private 1     2     6000029.935269999 2108491.2793400004 37.7695158962756 -122.443231851395 (37.7695158962756, -122.443231851395)
159660 159660 186880 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2700 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5985201.1788 2096460.2128 37.73562516865071 -122.49363655642 (37.7356251686507, -122.49363655642)
159459 159459 234473 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 99 Elsie St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     16     6007295.70063 2098744.01488 37.7431637754778 -122.417408915989 (37.7431637754778, -122.417408915989)
159159 159159 178170 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Serrano Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     5989035.58475 2090454.3423900001 37.719358148051796 -122.479940326497 (37.7193581480518, -122.479940326497)
158981 158981 211037 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 61 Burnside Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6001183.29295 2095747.84811 37.734591195811795 -122.438329349227 (37.7345911958118, -122.438329349227)
158905 158905 200558 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 34 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6016305.3951 2095506.8264 37.734777920300004 -122.38602988117901 (37.7347779203, -122.386029881179)
157655 157655 178162 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 17 : 4 Tree 1 Private 1     5 Width 0ft   5993072.48922 2087856.39417 37.7124585223038 -122.46579770942301 (37.7124585223038, -122.465797709423)
157592 157592 185023 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2701 Sunset Blvd 49 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985046.0879999995 2096329.59 37.735257439095705 -122.49416313243499 (37.7352574390957, -122.494163132435)
157213 157213 211033 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 417 Dewey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5995123.84893 2100332.4468799997 37.746832855650396 -122.459610683101 (37.7468328556504, -122.459610683101)
156955 156955 211039 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 52 Burnside Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23     6001157.31367 2095726.26325 37.7345304511011 -122.438417622186 (37.7345304511011, -122.438417622186)
156892 156892 211023 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 83 : 4 Tree 1 Private 1     5 Width 0ft   5991239.95465 2092188.59606 37.7242478060794 -122.472447079879 (37.7242478060794, -122.472447079879)
156453 156453 211011 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 34 : 4 Tree 1 Private 1     3 Width 0ft   5991335.35345 2093583.37833 37.728083052188104 -122.47221892726499 (37.7280830521881, -122.472218927265)
156435 156435 178169 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 24 : 4 Tree 1 Private 1     6 Width 0ft   5992786.910569999 2087851.5448200002 37.7124287295635 -122.466784396099 (37.7124287295635, -122.466784396099)
156327 156327 185563 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2201 Sunset Blvd 47 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984887.6667 2099768.5458 37.7446906142612 -122.49496433430599 (37.7446906142612, -122.494964334306)
156194 156194 178141 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 12 : 4 Tree 1 Private 1     5 Width 0ft   5992021.87667 2087934.24208 37.7126116138994 -122.46943457854401 (37.7126116138994, -122.469434578544)
155635 155635 194423 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 132 Kissling St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 5ft   6007917.867000001 2109077.33792 37.771571702413 -122.41598923453002 (37.771571702413, -122.41598923453)
155336 155336 178160 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 15 : 4 Tree 1 Private 1     6 Width 0ft   5993144.356269999 2087854.16093 37.712456535710395 -122.465549154771 (37.7124565357104, -122.465549154771)
153955 153955 185290 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2601 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984983.8028 2097379.2257 37.738135813056005 -122.494455822202 (37.738135813056, -122.494455822202)
153781 153781 200572 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 42 Median : Cutout 11 Tree 1 DPW 2     18 Width 0ft   6016330.8681 2095450.735 37.73462531430871 -122.385937902813 (37.7346253143087, -122.385937902813)
152650 152650 178139 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 10 : 4 Tree 1 Private 1     6 Width 0ft   5992188.74587 2087889.2446599999 37.7124977039766 -122.468854559004 (37.7124977039766, -122.468854559004)
152330 152330 211015 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 78 : 4 Tree 1 Private 1     3 Width 0ft   5991307.93934 2093199.2311 37.727026693213794 -122.47228570643101 (37.7270266932138, -122.472285706431)
151728 151728 200146 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 6101 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 0ft   6013586.8559 2091305.2042 37.7230902914135 -122.395134667477 (37.7230902914135, -122.395134667477)
151346 151346 132160 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1141 Chestnut St 5 Front Yard : Yard 7 Tree 1 Private 1     20     6006382.37262 2120397.93248 37.802568811663605 -122.422104980572 (37.8025688116636, -122.422104980572)
150293 150293 178166 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 21 : 4 Tree 1 Private 1     5 Width 0ft   5992891.51235 2087851.5166099998 37.7124346884767 -122.466422861421 (37.7124346884767, -122.466422861421)
150068 150068 178148 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 19 : 4 Tree 1 Private 1     5 Width 0ft   5991783.61367 2087988.3395200002 37.712746380014295 -122.47026201958299 (37.7127463800143, -122.470262019583)
148698 148698 211010 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 27 : 4 Tree 1 Private 1     3 Width 0ft   5991339.1010300005 2093646.61822 37.728256910008895 -122.47221057976601 (37.7282569100089, -122.472210579766)
147538 147538 186878 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2700 Sunset Blvd 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985170.4646 2096439.5838 37.7355667300556 -122.493741225987 (37.7355667300556, -122.493741225987)
146741 146741 211030 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 165 : 4 Tree 1 Private 1     4 Width 0ft   5991183.72988 2091349.85826 37.7219415855123 -122.47258031712099 (37.7219415855123, -122.472580317121)
146720 146720 178155 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 10 : 4 Tree 1 Private 1     6 Width 0ft   5993366.44396 2087810.43567 37.71234928345479 -122.46477838452499 (37.7123492834548, -122.464778384525)
145855 145855 122584 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2500X Lyon St 4 Median : Cutout 11 Tree 1 Private 1     11 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
144225 144225 101034 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1010X Portola Dr 8 Front Yard : Yard 7 Tree 1 DPW 2           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
144047 144047 108298 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 10X Greenwich St 1 Front Yard : Yard 7 Tree 1 Private 1   12/15/2014 12:00:00 AM 3   Permit Number 774449 6012830.0 2116175.0 37.791335193350896 -122.399496166675 (37.7913351933509, -122.399496166675)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 76.56ms · Data source: data.sfgov.org