Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize, PermitNotes
PlantDate ✖
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) |
JSON shape: default, array, newline-delimited
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");