trees
244 rows where qCaretaker_id = 2 and qSpecies_id = 35 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116936 | 100068 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 303 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990392 | 2090762 | 37.720281613079 | -122.47527420247 | (37.720281613079, -122.47527420247) | 1 | 8 | 4 | 64 | 40 | |||
| 19643 | 105261 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988914.8 | 2089258.8 | 37.7160684695332 | -122.48027037241 | (37.7160684695332, -122.48027037241) | 1 | 8 | 4 | 64 | 14 | |||||
| 128412 | 105268 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
| 181784 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.46484 | 37.7328958169551 | -122.491498163849 | (37.7328958169551, -122.491498163849) | 1 | 8 | 4 | 64 | 35 | |||
| 81883 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.46484 | 37.7328958169551 | -122.491498163849 | (37.7328958169551, -122.491498163849) | 1 | 8 | 4 | 64 | 35 | |||
| 1190 | 107158 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 101x Elsie St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6007300 | 2098759 | 37.7432051631731 | -122.417395111614 | (37.7432051631731, -122.417395111614) | 2 | 7 | 7 | 28859 | 2 | ||||
| 172237 | 108298 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 10X Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 12/15/2014 12:00:00 AM | 3 | Permit Number 774449 | 6012830 | 2116175 | 37.7913351933509 | -122.399496166675 | (37.7913351933509, -122.399496166675) | 4 | 1 | 10 | 28854 | 6 | ||
| 108114 | 114123 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 61085 | 114124 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 142428 | 114137 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 75828 | 114138 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/16/2016 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
| 41763 | 114139 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 6387 | 114260 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 161266 | 114370 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 821 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988453 | 2089765 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | 1 | 8 | 4 | 64 | 14 | ||||
| 82197 | 114371 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 821 GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988453 | 2089765 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | 1 | 8 | 4 | 64 | 14 | ||||
| 163611 | 114372 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 821 GONZALEZ DR | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988453 | 2089765 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | 1 | 8 | 4 | 64 | 14 | ||||
| 53879 | 114377 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
| 23338 | 114378 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
| 113218 | 114925 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 4400x OCEAN AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | |
| 99863 | 114934 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 4400x OCEAN AVE | 10 | Front Yard : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | |
| 138142 | 115834 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 900X LAKE MERCED BLVD | 2 | Median : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 10x100 | Permit Number 777492 | 5987646 | 2090104 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | 1 | 8 | 4 | 64 | 14 | |
| 22684 | 120262 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 24th Ave | 6 | Side Yard : Yard | Tree | Private 2 | 26 | 5988353.58713 | 2115180.43805 | 37.7872097252822 | -122.484109995805 | (37.7872097252822, -122.484109995805) | 11 | 6 | 1 | 55 | 33 | ||||
| 194127 | 122584 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2500X Lyon St | 4 | Median : Cutout | Tree | Private 2 | 11 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 94007 | 132160 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1141 Chestnut St | 5 | Front Yard : Yard | Tree | Private 2 | 20 | 6006382.37262 | 2120397.93248 | 37.8025688116636 | -122.422104980572 | (37.8025688116636, -122.422104980572) | 5 | 9 | 1 | 28858 | 32 | ||||
| 182602 | 132161 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 10 | Front Yard : Yard | Tree | Private 2 | 15 | 6010552.8238 | 2121311.79296 | 37.8053123842132 | -122.407737540175 | (37.8053123842132, -122.407737540175) | 3 | 1 | 10 | 308 | 23 | ||||
| 58106 | 132162 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 11 | Front Yard : Yard | Tree | Private 2 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.407713714409 | (37.8053168133783, -122.407713714409) | 3 | 1 | 10 | 308 | 23 | ||||
| 129810 | 132163 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 150 Lombard St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6011528.08163 | 2120803.57488 | 37.8039714887622 | -122.404326723704 | (37.8039714887622, -122.404326723704) | 3 | 1 | 10 | 28860 | 6 | |||
| 57367 | 132164 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6011515.19186 | 2120799.84951 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | 3 | 1 | 10 | 28860 | 6 | |||
| 192931 | 173637 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008672 | 2111900 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | 8 | 2 | 9 | 28853 | 34 | ||||
| 186953 | 173744 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
| 33716 | 178129 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 345 Tocoloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012554.38724 | 2086809.43241 | 37.7106883309719 | -122.398388432799 | (37.7106883309719, -122.398388432799) | 10 | 3 | 8 | 309 | 1 | |||
| 66301 | 178130 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 1 | : | Tree | Private 2 | 7 | Width 0ft | 5992655.54446 | 2087848.4586 | 37.7124126730818 | -122.4672382093 | (37.7124126730818, -122.4672382093) | 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 | |||
| 68619 | 178132 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 3 | : | Tree | Private 2 | 6 | Width 0ft | 5992585.12632 | 2087848.18621 | 37.7124078599039 | -122.467481573927 | (37.7124078599039, -122.467481573927) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 27670 | 178138 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 9 | : | Tree | Private 2 | 7 | Width 0ft | 5992224.93754 | 2087880.30275 | 37.7124752425212 | -122.468728820297 | (37.7124752425212, -122.468728820297) | 9 | 8 | 4 | 64 | 24 | |||
| 51083 | 178139 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 10 | : | Tree | Private 2 | 6 | Width 0ft | 5992188.74587 | 2087889.24466 | 37.7124977039766 | -122.468854559004 | (37.7124977039766, -122.468854559004) | 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 37951 | 178151 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 4 | : | Tree | Private 2 | 3 | Width 0ft | 5993597.52442 | 2087641.38278 | 37.7118984245322 | -122.463967443352 | (37.7118984245322, -122.463967443352) | 9 | 8 | 4 | 64 | 24 | |||
| 71095 | 178152 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 7 | : | Tree | Private 2 | 5 | Width 0ft | 5993523.09133 | 2087729.02455 | 37.7121347780763 | -122.464231061624 | (37.7121347780763, -122.464231061624) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 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 | |||
| 9866 | 178155 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 10 | : | Tree | Private 2 | 6 | Width 0ft | 5993366.44396 | 2087810.43567 | 37.7123492834548 | -122.464778384525 | (37.7123492834548, -122.464778384525) | 9 | 8 | 4 | 64 | 24 | |||
| 43976 | 178156 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 11 | : | Tree | Private 2 | 5 | Width 0ft | 5993327.47852 | 2087822.82752 | 37.712381061909 | -122.464913959129 | (37.712381061909, -122.464913959129) | 9 | 8 | 4 | 64 | 24 | |||
| 75099 | 178157 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 12 | : | Tree | Private 2 | 7 | Width 0ft | 5993292.82373 | 2087832.959 | 37.712406882332 | -122.465034470985 | (37.712406882332, -122.465034470985) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 52379 | 178161 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 16 | : | Tree | Private 2 | 6 | Width 0ft | 5993106.56964 | 2087853.50799 | 37.7124525633948 | -122.465679708459 | (37.7124525633948, -122.465679708459) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 450 | 178165 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 20 | Median : Cutout | Tree | Private 2 | 5 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | |||
| 25077 | 178166 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 21 | : | Tree | Private 2 | 5 | Width 0ft | 5992891.51235 | 2087851.51661 | 37.7124346884767 | -122.466422861421 | (37.7124346884767, -122.466422861421) | 9 | 8 | 4 | 64 | 24 | |||
| 49587 | 178167 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 22 | : | Tree | Private 2 | 5 | Width 0ft | 5992858.09731 | 2087851.49534 | 37.7124327018762 | -122.466538351485 | (37.7124327018762, -122.466538351485) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 30677 | 178169 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 24 | : | Tree | Private 2 | 6 | Width 0ft | 5992786.91057 | 2087851.54482 | 37.7124287295635 | -122.466784396099 | (37.7124287295635, -122.466784396099) | 9 | 8 | 4 | 64 | 24 | |||
| 144446 | 178170 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5989035.58475 | 2090454.34239 | 37.7193581480518 | -122.479940326497 | (37.7193581480518, -122.479940326497) | 1 | 8 | 4 | 64 | 14 | ||||
| 93553 | 178171 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988123.04078 | 2089845.83927 | 37.7176342915553 | -122.483050036443 | (37.7176342915553, -122.483050036443) | 1 | 8 | 4 | 64 | 14 | ||||
| 137776 | 178172 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988133.68649 | 2089845.13121 | 37.7176329668754 | -122.483013187625 | (37.7176329668754, -122.483013187625) | 1 | 8 | 4 | 64 | 14 | ||||
| 95623 | 178173 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988347.73388 | 2089792.82325 | 37.717501795356 | -122.482269501364 | (37.717501795356, -122.482269501364) | 1 | 8 | 4 | 64 | 14 | ||||
| 267 | 178174 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988358.3694 | 2089791.63303 | 37.717499145949 | -122.482232652541 | (37.717499145949, -122.482232652541) | 1 | 8 | 4 | 64 | 14 | ||||
| 170489 | 178175 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5989026.35056 | 2089515.50206 | 37.7167797908382 | -122.47990357931 | (37.7167797908382, -122.47990357931) | 1 | 8 | 4 | 64 | 14 | ||||
| 63516 | 178176 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989163.89955 | 2089384.56057 | 37.7164282485354 | -122.479418571325 | (37.7164282485354, -122.479418571325) | 1 | 8 | 4 | 64 | 14 | ||||
| 155300 | 178177 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 167 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004561.94872 | 2092421.12411 | 37.7256483463685 | -122.426411406667 | (37.7256483463685, -122.426411406667) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | |||
| 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 | |||
| 17565 | 181385 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984917.5854 | 2104501.8427 | 37.7576886993488 | -122.495209866912 | (37.7576886993488, -122.495209866912) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 38569 | 181557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984875.8554 | 2106073.5142 | 37.7620016277453 | -122.495470098326 | (37.7620016277453, -122.495470098326) | 1 | 8 | 3 | 56 | 35 | |||
| 75630 | 184347 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1251 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984658.9334 | 2106421.3632 | 37.7629440193232 | -122.496246001897 | (37.7629440193232, -122.496246001897) | 1 | 8 | 3 | 56 | 35 | |||
| 72264 | 184348 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1251 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984683.9949 | 2106431.9954 | 37.7629746803622 | -122.496160108596 | (37.7629746803622, -122.496160108596) | 1 | 8 | 3 | 56 | 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 | |||
| 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 | |||
| 53240 | 185023 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985046.088 | 2096329.59 | 37.7352574390957 | -122.494163132435 | (37.7352574390957, -122.494163132435) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 12887 | 185307 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984973.1253 | 2097316.8359 | 37.7379638824881 | -122.494488141215 | (37.7379638824881, -122.494488141215) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 60102 | 185310 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984962.2385 | 2097256.121 | 37.7377965384833 | -122.494521307154 | (37.7377965384833, -122.494521307154) | 1 | 8 | 3 | 29491 | 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 | |||
| 68405 | 185535 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984921.0973 | 2100070.748 | 37.7455223363848 | -122.494871016971 | (37.7455223363848, -122.494871016971) | 1 | 8 | 3 | 29491 | 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) );