trees
156 rows where PlotSize = "Width 0ft" and qSpecies_id = 35 sorted by rowid descending
This data as json, CSV (advanced)
qSiteInfo ✖
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193293 | 181513 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984909.8299 | 2105563.3396 | 37.7606028201969 | -122.495314969775 | (37.7606028201969, -122.495314969775) | 1 | 8 | 3 | 56 | 35 | |||
| 191519 | 211018 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 55 | : | Tree | Private 2 | 3 | Width 0ft | 5991237.26366 | 2092440.87353 | 37.7249403415953 | -122.472474765495 | (37.7249403415953, -122.472474765495) | 9 | 8 | 4 | 64 | 40 | |||
| 191503 | 186889 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985183.3004 | 2096502.846 | 37.7357411821318 | -122.493701508581 | (37.7357411821318, -122.493701508581) | 1 | 8 | 3 | 29491 | 35 | |||
| 191418 | 211011 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 34 | : | Tree | Private 2 | 3 | Width 0ft | 5991335.35345 | 2093583.37833 | 37.7280830521881 | -122.472218927265 | (37.7280830521881, -122.472218927265) | 9 | 8 | 4 | 64 | 40 | |||
| 190105 | 181519 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400 Sunset Blvd | 79 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984899.8047 | 2105606.7824 | 37.7607215150149 | -122.49535284581 | (37.7607215150149, -122.49535284581) | 1 | 8 | 3 | 56 | 35 | |||
| 187582 | 139358 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 7 | Median : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6004934.0187 | 2114075.446 | 37.7851270694756 | -122.426666519258 | (37.7851270694756, -122.426666519258) | 13 | 9 | 11 | 28858 | 41 | |||
| 186740 | 186440 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984767.7413 | 2103960.7256 | 37.7561941679911 | -122.495688168642 | (37.7561941679911, -122.495688168642) | 1 | 8 | 3 | 56 | 35 | |||
| 186273 | 200533 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 9 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016162.6096 | 2095677.4311 | 37.7352384631645 | -122.386535436358 | (37.7352384631645, -122.386535436358) | 10 | 3 | 8 | 58 | 1 | |||
| 184903 | 178145 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 16 | : | Tree | Private 2 | 4 | Width 0ft | 5991905.80045 | 2087967.06921 | 37.7126950404068 | -122.469838159212 | (37.7126950404068, -122.469838159212) | 9 | 8 | 4 | 64 | 24 | |||
| 184676 | 178150 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 21 | : | Tree | Private 2 | 4 | Width 0ft | 5991622.99627 | 2087995.81221 | 37.7127576107372 | -122.470817703474 | (37.7127576107372, -122.470817703474) | 9 | 8 | 4 | 64 | 24 | |||
| 182755 | 178163 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 18 | : | Tree | Private 2 | 5 | Width 0ft | 5993033.97644 | 2087855.75659 | 37.7124545499972 | -122.465930773993 | (37.7124545499972, -122.465930773993) | 9 | 8 | 4 | 64 | 24 | |||
| 182192 | 178134 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 5 | Side Yard : Yard | Tree | DPW 1 | 5 | Width 0ft | 5992424.40969 | 2087850.98169 | 37.7124062555176 | -122.468037257827 | (37.7124062555176, -122.468037257827) | 9 | 8 | 4 | 64 | 24 | |||
| 182077 | 211028 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 160 | : | Tree | Private 2 | 4 | Width 0ft | 5991184.3391 | 2091378.75733 | 37.7220209704755 | -122.472580317131 | (37.7220209704755, -122.472580317131) | 9 | 8 | 4 | 64 | 40 | |||
| 180575 | 211022 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 80 | : | Tree | Private 2 | 3 | Width 0ft | 5991230.5084 | 2092239.13983 | 37.7243860399747 | -122.472483416991 | (37.7243860399747, -122.472483416991) | 9 | 8 | 4 | 64 | 40 | |||
| 179540 | 200526 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 2 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6016126.5305 | 2095710.5736 | 37.7353274684402 | -122.386662486514 | (37.7353274684402, -122.386662486514) | 10 | 3 | 8 | 58 | 1 | |||
| 178827 | 200557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 33 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016298.6383 | 2095516.7839 | 37.7348048876468 | -122.386053935891 | (37.7348048876468, -122.386053935891) | 10 | 3 | 8 | 58 | 1 | |||
| 178432 | 178154 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 9 | : | Tree | Private 2 | 7 | Width 0ft | 5993415.34716 | 2087786.98511 | 37.7122877131728 | -122.464607659932 | (37.7122877131728, -122.464607659932) | 9 | 8 | 4 | 64 | 24 | |||
| 177341 | 139329 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 3 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005196.3246 | 2114113.3931 | 37.7852460889347 | -122.425761723999 | (37.7852460889347, -122.425761723999) | 13 | 9 | 11 | 28858 | 41 | |||
| 174956 | 178160 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 15 | : | Tree | Private 2 | 6 | Width 0ft | 5993144.35627 | 2087854.16093 | 37.7124565357104 | -122.465549154771 | (37.7124565357104, -122.465549154771) | 9 | 8 | 4 | 64 | 24 | |||
| 174672 | 200529 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 5 | Median : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6016150.0239 | 2095691.2754 | 37.7352757800904 | -122.386579915171 | (37.7352757800904, -122.386579915171) | 10 | 3 | 8 | 58 | 1 | |||
| 173124 | 186878 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985170.4646 | 2096439.5838 | 37.7355667300556 | -122.493741225987 | (37.7355667300556, -122.493741225987) | 1 | 8 | 3 | 29491 | 35 | |||
| 172979 | 186699 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1401 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984730.9983 | 2105175.3386 | 37.7595270055976 | -122.495904834542 | (37.7595270055976, -122.495904834542) | 1 | 8 | 3 | 56 | 35 | |||
| 172096 | 185932 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2000 Sunset Blvd | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984999.1426 | 2101513.5873 | 37.7494885480173 | -122.494707506851 | (37.7494885480173, -122.494707506851) | 1 | 8 | 3 | 29491 | 35 | |||
| 170410 | 178146 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 17 | : | Tree | Private 2 | 4 | Width 0ft | 5991839.8077 | 2087981.8975 | 37.7127319405071 | -122.47006732805 | (37.7127319405071, -122.47006732805) | 9 | 8 | 4 | 64 | 24 | |||
| 169756 | 186691 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1401 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984728.0673 | 2105259.502 | 37.7597579231437 | -122.495921180027 | (37.7597579231437, -122.495921180027) | 1 | 8 | 3 | 56 | 35 | |||
| 169125 | 200573 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 43 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016335.7649 | 2095440.4518 | 37.7345973496971 | -122.385920256211 | (37.7345973496971, -122.385920256211) | 10 | 3 | 8 | 58 | 1 | |||
| 167758 | 211029 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 162 | : | Tree | Private 2 | 5 | Width 0ft | 5991185.525 | 2091363.77787 | 37.7219799092267 | -122.472575126241 | (37.7219799092267, -122.472575126241) | 9 | 8 | 4 | 64 | 40 | |||
| 167203 | 178168 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 23 | : | Tree | Private 2 | 5 | Width 0ft | 5992821.74753 | 2087850.08942 | 37.712426743882 | -122.466663884229 | (37.712426743882, -122.466663884229) | 9 | 8 | 4 | 64 | 24 | |||
| 165017 | 185033 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985049.8565 | 2096299.4419 | 37.7351748809707 | -122.494147882197 | (37.7351748809707, -122.494147882197) | 1 | 8 | 3 | 29491 | 35 | |||
| 163252 | 186251 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1701 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984830.2927 | 2103110.5403 | 37.7538634572036 | -122.495409148018 | (37.7538634572036, -122.495409148018) | 1 | 8 | 3 | 56 | 35 | |||
| 160793 | 178142 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 13 | : | Tree | Private 2 | 5 | Width 0ft | 5991993.89623 | 2087943.01111 | 37.7126340744777 | -122.469531924782 | (37.7126340744777, -122.469531924782) | 9 | 8 | 4 | 64 | 24 | |||
| 160689 | 211014 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 53 | : | Tree | Private 2 | 3 | Width 0ft | 5991322.30761 | 2093384.47859 | 37.7275361681597 | -122.4722495339 | (37.7275361681597, -122.4722495339) | 9 | 8 | 4 | 64 | 40 | |||
| 159200 | 178136 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 7 | : | Tree | Private 2 | 5 | Width 0ft | 5992351.13254 | 2087854.27594 | 37.7124110686957 | -122.468290763208 | (37.7124110686957, -122.468290763208) | 9 | 8 | 4 | 64 | 24 | |||
| 158562 | 200567 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 39 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016322.0539 | 2095480.6054 | 37.7347068446432 | -122.385970458247 | (37.7347068446432, -122.385970458247) | 10 | 3 | 8 | 58 | 1 | |||
| 158532 | 185308 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985001.1798 | 2097292.5499 | 37.7378988415191 | -122.494389354717 | (37.7378988415191, -122.494389354717) | 1 | 8 | 3 | 29491 | 35 | |||
| 157706 | 178159 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 14 | : | Tree | Private 2 | 5 | Width 0ft | 5993218.97583 | 2087844.63687 | 37.7124346884772 | -122.465290557432 | (37.7124346884772, -122.465290557432) | 9 | 8 | 4 | 64 | 24 | |||
| 156752 | 186238 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1701 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984762.5292 | 2103340.0793 | 37.7544897398871 | -122.495660416165 | (37.7544897398871, -122.495660416165) | 1 | 8 | 3 | 56 | 35 | |||
| 153819 | 186620 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1501 Sunset Blvd | 91 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984755.0749 | 2104355.2681 | 37.7572767304033 | -122.495761074715 | (37.7572767304033, -122.495761074715) | 1 | 8 | 3 | 56 | 35 | |||
| 153599 | 185439 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2300 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985094.1378 | 2099479.3093 | 37.74390853381 | -122.494229093058 | (37.74390853381, -122.494229093058) | 1 | 8 | 3 | 29491 | 35 | |||
| 153030 | 200615 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 56 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016438.8423 | 2095106.2461 | 37.7336853915549 | -122.385540596193 | (37.7336853915549, -122.385540596193) | 10 | 3 | 8 | 58 | 1 | |||
| 153020 | 186456 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984777.372 | 2103875.7247 | 37.7559613430639 | -122.495648593467 | (37.7559613430639, -122.495648593467) | 1 | 8 | 3 | 56 | 35 | |||
| 146921 | 186247 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1701 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984819.3113 | 2103171.6078 | 37.7540304886989 | -122.495451627268 | (37.7540304886989, -122.495451627268) | 1 | 8 | 3 | 56 | 35 | |||
| 145727 | 178137 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 8 | : | Tree | Private 2 | 5 | Width 0ft | 5992316.61451 | 2087859.09194 | 37.7124222985339 | -122.468410417129 | (37.7124222985339, -122.468410417129) | 9 | 8 | 4 | 64 | 24 | |||
| 143757 | 185290 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984983.8028 | 2097379.2257 | 37.738135813056 | -122.494455822202 | (37.738135813056, -122.494455822202) | 1 | 8 | 3 | 29491 | 35 | |||
| 142106 | 178147 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 18 | : | Tree | Private 2 | 4 | Width 0ft | 5991814.6494 | 2087985.34878 | 37.712739962461 | -122.47015453352 | (37.712739962461, -122.47015453352) | 9 | 8 | 4 | 64 | 24 | |||
| 137297 | 211019 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 71 | : | Tree | Private 2 | 3 | Width 0ft | 5991242.8983 | 2092280.74938 | 37.7245010065929 | -122.472443619273 | (37.7245010065929, -122.472443619273) | 9 | 8 | 4 | 64 | 40 | |||
| 136381 | 200558 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 34 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016305.3951 | 2095506.8264 | 37.7347779203 | -122.386029881179 | (37.7347779203, -122.386029881179) | 10 | 3 | 8 | 58 | 1 | |||
| 134727 | 186880 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5985201.1788 | 2096460.2128 | 37.7356251686507 | -122.49363655642 | (37.7356251686507, -122.49363655642) | 1 | 8 | 3 | 29491 | 35 | |||
| 134318 | 178164 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 19 | : | Tree | Private 2 | 5 | Width 0ft | 5993000.50065 | 2087852.84302 | 37.71244461881 | -122.46604626403 | (37.71244461881, -122.46604626403) | 9 | 8 | 4 | 64 | 24 | |||
| 133693 | 211016 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 46 | : | Tree | Private 2 | 3 | Width 0ft | 5991242.43895 | 2092472.66575 | 37.7250279346749 | -122.472459191965 | (37.7250279346749, -122.472459191965) | 9 | 8 | 4 | 64 | 40 | |||
| 133423 | 186893 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985181.9251 | 2096557.8565 | 37.7358921458374 | -122.493710315825 | (37.7358921458374, -122.493710315825) | 1 | 8 | 3 | 29491 | 35 | |||
| 133124 | 178162 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 17 | : | Tree | Private 2 | 5 | Width 0ft | 5993072.48922 | 2087856.39417 | 37.7124585223038 | -122.465797709423 | (37.7124585223038, -122.465797709423) | 9 | 8 | 4 | 64 | 24 | |||
| 131403 | 200571 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 41 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016326.461 | 2095462.4873 | 37.7346573398722 | -122.385953958726 | (37.7346573398722, -122.385953958726) | 10 | 3 | 8 | 58 | 1 | |||
| 130934 | 185700 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2101 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984899.9898 | 2100515.832 | 37.7467431803198 | -122.494976814737 | (37.7467431803198, -122.494976814737) | 1 | 8 | 3 | 29491 | 35 | |||
| 130337 | 186855 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985186.2801 | 2096278.9071 | 37.7351264799029 | -122.49367471051 | (37.7351264799029, -122.49367471051) | 1 | 8 | 3 | 29491 | 35 | |||
| 128912 | 184982 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984985.373 | 2096691.786 | 37.7362483795762 | -122.494399733702 | (37.7362483795762, -122.494399733702) | 1 | 8 | 3 | 29491 | 35 | |||
| 127400 | 187193 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2301 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984945.2043 | 2099085.395 | 37.7428182353231 | -122.494715027467 | (37.7428182353231, -122.494715027467) | 1 | 8 | 3 | 29491 | 35 | |||
| 126959 | 211020 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 74 | : | Tree | Private 2 | 4 | Width 0ft | 5991248.48231 | 2092260.69315 | 37.7244462603628 | -122.472422854829 | (37.7244462603628, -122.472422854829) | 9 | 8 | 4 | 64 | 40 | |||
| 123901 | 211026 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 138 | : | Tree | Private 2 | 4 | Width 0ft | 5991196.61305 | 2091604.80622 | 37.7226423552448 | -122.472554361808 | (37.7226423552448, -122.472554361808) | 9 | 8 | 4 | 64 | 40 | |||
| 123530 | 186167 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1700 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984926.5892 | 2103481.0156 | 37.7548863180592 | -122.495103454208 | (37.7548863180592, -122.495103454208) | 1 | 8 | 3 | 56 | 35 | |||
| 123187 | 211017 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 49 | : | Tree | Private 2 | 5 | Width 0ft | 5991258.9422 | 2092457.39845 | 37.7249869696545 | -122.472401030094 | (37.7249869696545, -122.472401030094) | 9 | 8 | 4 | 64 | 40 | |||
| 122774 | 200572 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 42 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6016330.8681 | 2095450.735 | 37.7346253143087 | -122.385937902813 | (37.7346253143087, -122.385937902813) | 10 | 3 | 8 | 58 | 1 | |||
| 122237 | 178153 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 8 | : | Tree | Private 2 | 7 | Width 0ft | 5993495.89449 | 2087748.40295 | 37.7121864189299 | -122.464326467118 | (37.7121864189299, -122.464326467118) | 9 | 8 | 4 | 64 | 24 | |||
| 121908 | 178144 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 15 | : | Tree | Private 2 | 4 | Width 0ft | 5991934.88004 | 2087954.77106 | 37.7126629535013 | -122.469736757058 | (37.7126629535013, -122.469736757058) | 9 | 8 | 4 | 64 | 24 | |||
| 121416 | 185539 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984878.3804 | 2100042.8891 | 37.7454433428019 | -122.495016669314 | (37.7454433428019, -122.495016669314) | 1 | 8 | 3 | 29491 | 35 | |||
| 119669 | 185964 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2001 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984823.122 | 2101326.4259 | 37.7489643495953 | -122.495302381208 | (37.7489643495953, -122.495302381208) | 1 | 8 | 3 | 29491 | 35 | |||
| 119256 | 181538 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984897.5768 | 2105857.4141 | 37.761409549185 | -122.495379035532 | (37.761409549185, -122.495379035532) | 1 | 8 | 3 | 56 | 35 | |||
| 118418 | 200613 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 54 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016431.4971 | 2095119.9571 | 37.7337226328106 | -122.385566946165 | (37.7337226328106, -122.385566946165) | 10 | 3 | 8 | 58 | 1 | |||
| 117654 | 178148 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 19 | : | Tree | Private 2 | 5 | Width 0ft | 5991783.61367 | 2087988.33952 | 37.7127463800143 | -122.470262019583 | (37.7127463800143, -122.470262019583) | 9 | 8 | 4 | 64 | 24 | |||
| 116100 | 185960 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2001 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984855.8243 | 2101346.8117 | 37.7490222380818 | -122.495190801303 | (37.7490222380818, -122.495190801303) | 1 | 8 | 3 | 29491 | 35 | |||
| 114736 | 185930 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2000 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985039.332 | 2101497.8374 | 37.7494476553955 | -122.494567371863 | (37.7494476553955, -122.494567371863) | 1 | 8 | 3 | 29491 | 35 | |||
| 112823 | 211025 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 95 | : | Tree | Private 2 | 6 | Width 0ft | 5991234.71561 | 2092082.53367 | 37.7239562818437 | -122.472457461651 | (37.7239562818437, -122.472457461651) | 9 | 8 | 4 | 64 | 40 | |||
| 111520 | 178143 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 14 | : | Tree | Private 2 | 5 | Width 0ft | 5991964.10718 | 2087949.4813 | 37.7126501183836 | -122.4696353549 | (37.7126501183836, -122.4696353549) | 9 | 8 | 4 | 64 | 24 | |||
| 110654 | 139356 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 5 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6005063.0942 | 2114090.4032 | 37.7851754347521 | -122.426221023287 | (37.7851754347521, -122.426221023287) | 13 | 9 | 11 | 28858 | 41 | |||
| 106955 | 211009 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 25 | : | Tree | Private 2 | 4 | Width 0ft | 5991341.55983 | 2093667.80622 | 37.728315229259 | -122.472203623507 | (37.728315229259, -122.472203623507) | 9 | 8 | 4 | 64 | 40 | |||
| 104913 | 185906 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2000 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985026.2976 | 2101345.2263 | 37.7490278641469 | -122.49460119526 | (37.7490278641469, -122.49460119526) | 1 | 8 | 3 | 29491 | 35 | |||
| 104823 | 181540 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984863.0454 | 2105869.1102 | 37.7614396414651 | -122.495499326148 | (37.7614396414651, -122.495499326148) | 1 | 8 | 3 | 56 | 35 | |||
| 102914 | 187129 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2600 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 0ft | 5985149.8207 | 2097410.2322 | 37.7382306634066 | -122.493884107972 | (37.7382306634066, -122.493884107972) | 1 | 8 | 3 | 29491 | 35 | |||
| 101060 | 185902 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2000 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985031.1855 | 2101301.2352 | 37.7489073626901 | -122.494581050501 | (37.7489073626901, -122.494581050501) | 1 | 8 | 3 | 29491 | 35 | |||
| 99999 | 181379 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984933.4588 | 2104463.134 | 37.7575833453331 | -122.495152116603 | (37.7575833453331, -122.495152116603) | 1 | 8 | 3 | 56 | 35 | |||
| 97343 | 187133 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2600 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985163.4571 | 2097445.4987 | 37.7383282936023 | -122.493839558913 | (37.7383282936023, -122.493839558913) | 1 | 8 | 3 | 29491 | 35 | |||
| 97315 | 186080 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1901 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984851.2986 | 2101988.3321 | 37.7507834123081 | -122.495253753816 | (37.7507834123081, -122.495253753816) | 1 | 8 | 3 | 29491 | 35 | |||
| 95893 | 184801 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1301 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984720.8276 | 2105758.3732 | 37.7611272600096 | -122.49598302149 | (37.7611272600096, -122.49598302149) | 1 | 8 | 3 | 56 | 35 | |||
| 94670 | 139359 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 9 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6004685.2851 | 2114039.9918 | 37.7850156556233 | -122.427524533418 | (37.7850156556233, -122.427524533418) | 13 | 9 | 11 | 28858 | 41 | |||
| 93290 | 181384 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984945.4334 | 2104486.2478 | 37.75764751046 | -122.49511240858 | (37.75764751046, -122.49511240858) | 1 | 8 | 3 | 56 | 35 | |||
| 92103 | 186040 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985014.7934 | 2102133.6877 | 37.7511920899125 | -122.49469909774 | (37.7511920899125, -122.49469909774) | 1 | 8 | 3 | 29491 | 35 | |||
| 90962 | 178141 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 12 | Median : Yard | Tree | Private 2 | DPW | 5 | Width 0ft | 5992021.87667 | 2087934.24208 | 37.7126116138994 | -122.469434578544 | (37.7126116138994, -122.469434578544) | 9 | 8 | 4 | 64 | 24 | ||
| 90257 | 178131 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 2 | : | Tree | Private 2 | 5 | Width 0ft | 5992618.59421 | 2087849.23546 | 37.7124126730667 | -122.467365975965 | (37.7124126730667, -122.467365975965) | 9 | 8 | 4 | 64 | 24 | |||
| 89742 | 186435 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984740.5243 | 2104016.8346 | 37.7563466338471 | -122.495786431621 | (37.7563466338471, -122.495786431621) | 1 | 8 | 3 | 56 | 35 | |||
| 88779 | 186421 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984727.9626 | 2104153.7573 | 37.756721849906 | -122.495839973726 | (37.756721849906, -122.495839973726) | 1 | 8 | 3 | 56 | 35 | |||
| 88636 | 186468 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984781.1405 | 2103769.7876 | 37.7556706898247 | -122.495627747424 | (37.7556706898247, -122.495627747424) | 1 | 8 | 3 | 56 | 35 | |||
| 88362 | 178135 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 6 | : | Tree | Private 2 | 5 | Width 0ft | 5992385.69997 | 2087851.79588 | 37.7124062555186 | -122.468171108404 | (37.7124062555186, -122.468171108404) | 9 | 8 | 4 | 64 | 24 | |||
| 88271 | 178133 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 4 | : | Tree | Private 2 | 6 | Width 0ft | 5992553.46677 | 2087849.43624 | 37.7124094643071 | -122.467591088862 | (37.7124094643071, -122.467591088862) | 9 | 8 | 4 | 64 | 24 | |||
| 87610 | 185118 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2850 35th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5985615.0479 | 2096000.8357 | 37.7343880441022 | -122.492171858431 | (37.7343880441022, -122.492171858431) | 1 | 8 | 3 | 29491 | 35 | |||
| 87580 | 178149 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 20 | : | Tree | Private 2 | 4 | Width 0ft | 5991654.66793 | 2087995.14516 | 37.712757610756 | -122.470708188538 | (37.712757610756, -122.470708188538) | 9 | 8 | 4 | 64 | 24 | |||
| 86690 | 200559 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 35 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016309.6626 | 2095501.1365 | 37.7347625331555 | -122.38601473032 | (37.7347625331555, -122.38601473032) | 10 | 3 | 8 | 58 | 1 | |||
| 84561 | 178158 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 13 | : | Tree | Private 2 | 5 | Width 0ft | 5993255.20411 | 2087840.25906 | 37.7124247572585 | -122.465165024673 | (37.7124247572585, -122.465165024673) | 9 | 8 | 4 | 64 | 24 | |||
| 82846 | 178140 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 11 | : | Tree | Private 2 | 6 | Width 0ft | 5992153.76433 | 2087899.91411 | 37.712524978625 | -122.468976240883 | (37.712524978625, -122.468976240883) | 9 | 8 | 4 | 64 | 24 | |||
| 80290 | 200146 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 6101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6013586.8559 | 2091305.2042 | 37.7230902914135 | -122.395134667477 | (37.7230902914135, -122.395134667477) | 10 | 3 | 8 | 58 | 1 | |||
| 76251 | 181473 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984918.4628 | 2105275.6702 | 37.7598134657238 | -122.49526389807 | (37.7598134657238, -122.49526389807) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );