Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4747 | 4747 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 5x10 | |||||||||
| 7041 | 7041 | 20305 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 50X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 7433 | 7433 | 19666 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 10919 | 10919 | 19986 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY46 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 11206 | 11206 | 20301 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 50X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 11841 | 11841 | 19663 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 11943 | 11943 | 19664 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 12961 | 12961 | 87019 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 10 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 14276 | 14276 | 19667 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 16176 | 16176 | 19976 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY45 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 16885 | 16885 | 19980 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY45 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 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) | |||
| 40640 | 40640 | 178151 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5993597.52442 | 2087641.3827799999 | 37.7118984245322 | -122.46396744335199 | (37.7118984245322, -122.463967443352) | |||
| 75963 | 75963 | 178152 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993523.09133 | 2087729.02455 | 37.7121347780763 | -122.46423106162399 | (37.7121347780763, -122.464231061624) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 29859 | 29859 | 178135 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992385.6999699995 | 2087851.7958799999 | 37.7124062555186 | -122.46817110840401 | (37.7124062555186, -122.468171108404) | |||
| 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) | |||
| 52632 | 52632 | 178132 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5992585.12632 | 2087848.18621 | 37.7124078599039 | -122.467481573927 | (37.7124078599039, -122.467481573927) | |||
| 134128 | 134128 | 178133 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5992553.46677 | 2087849.4362400002 | 37.7124094643071 | -122.467591088862 | (37.7124094643071, -122.467591088862) | |||
| 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) | |||
| 44889 | 44889 | 178131 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992618.59421 | 2087849.2354599999 | 37.7124126730667 | -122.46736597596501 | (37.7124126730667, -122.467365975965) | |||
| 40730 | 40730 | 178130 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5992655.54446 | 2087848.4586 | 37.7124126730818 | -122.4672382093 | (37.7124126730818, -122.4672382093) | |||
| 25615 | 25615 | 178137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992316.61451 | 2087859.0919400002 | 37.712422298533895 | -122.46841041712901 | (37.7124222985339, -122.468410417129) | |||
| 130721 | 130721 | 178158 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993255.20411 | 2087840.2590599998 | 37.7124247572585 | -122.465165024673 | (37.7124247572585, -122.465165024673) | |||
| 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) | |||
| 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) | |||
| 50141 | 50141 | 178167 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992858.09731 | 2087851.4953400001 | 37.7124327018762 | -122.466538351485 | (37.7124327018762, -122.466538351485) | |||
| 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) | |||
| 38392 | 38392 | 178159 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 14 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993218.97583 | 2087844.63687 | 37.7124346884772 | -122.465290557432 | (37.7124346884772, -122.465290557432) | |||
| 130784 | 130784 | 178165 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 20 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | |||
| 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) | |||
| 33800 | 33800 | 178161 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 16 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5993106.56964 | 2087853.50799 | 37.7124525633948 | -122.46567970845899 | (37.7124525633948, -122.465679708459) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 134503 | 134503 | 178140 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 11 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5992153.764330001 | 2087899.9141099998 | 37.712524978625005 | -122.46897624088301 | (37.712524978625, -122.468976240883) | |||
| 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) | |||
| 50188 | 50188 | 178142 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991993.89623 | 2087943.0111099998 | 37.7126340744777 | -122.469531924782 | (37.7126340744777, -122.469531924782) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 62726 | 62726 | 178147 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 18 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991814.6494 | 2087985.34878 | 37.712739962461 | -122.47015453351999 | (37.712739962461, -122.47015453352) | |||
| 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) | |||
| 36495 | 36495 | 178150 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 21 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991622.99627 | 2087995.81221 | 37.71275761073721 | -122.47081770347401 | (37.7127576107372, -122.470817703474) | |||
| 63973 | 63973 | 178149 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 20 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991654.66793 | 2087995.1451599998 | 37.712757610756 | -122.470708188538 | (37.712757610756, -122.470708188538) | |||
| 118805 | 118805 | 2266 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X Brotherhood Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2014 12:00:00 AM | 22 | 14M | Permit Number 772491 | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |
| 107898 | 107898 | 2268 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 750X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 123578 | 123578 | 114260 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 92410 | 92410 | 98278 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 500 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
| 110779 | 110779 | 98279 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 501 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
| 80132 | 80132 | 105261 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988914.8 | 2089258.8 | 37.716068469533205 | -122.48027037241002 | (37.7160684695332, -122.48027037241) | |||||
| 127115 | 127115 | 178176 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5989163.89955 | 2089384.56057 | 37.7164282485354 | -122.479418571325 | (37.7164282485354, -122.479418571325) | ||||
| 40111 | 40111 | 178175 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989026.35056 | 2089515.5020599999 | 37.7167797908382 | -122.47990357931002 | (37.7167797908382, -122.47990357931) | ||||
| 9646 | 9646 | 114139 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9654 | 9654 | 114138 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/16/2016 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9658 | 9658 | 114124 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9665 | 9665 | 114123 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9672 | 9672 | 114137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 96125 | 96125 | 114371 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 821 GONZALEZ DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988453.0 | 2089765.0 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | ||||
| 119505 | 119505 | 114372 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 821 GONZALEZ DR | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988453.0 | 2089765.0 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | ||||
| 120617 | 120617 | 114370 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 821 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988453.0 | 2089765.0 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | ||||
| 132856 | 132856 | 178174 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988358.3694 | 2089791.63303 | 37.717499145949 | -122.48223265254101 | (37.717499145949, -122.482232652541) | ||||
| 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) | ||||
| 80939 | 80939 | 114377 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 842X GONZALEZ DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988421.0 | 2089827.0 | 37.7175998975755 | -122.48201875930201 | (37.7175998975755, -122.482018759302) | ||||
| 104763 | 104763 | 105268 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 842X GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988421.0 | 2089827.0 | 37.7175998975755 | -122.48201875930201 | (37.7175998975755, -122.482018759302) | ||||
| 125758 | 125758 | 114378 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 842X GONZALEZ DR | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988421.0 | 2089827.0 | 37.7175998975755 | -122.48201875930201 | (37.7175998975755, -122.482018759302) | ||||
| 56811 | 56811 | 178172 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988133.68649 | 2089845.1312099998 | 37.7176329668754 | -122.483013187625 | (37.7176329668754, -122.483013187625) | ||||
| 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) | ||||
| 114243 | 114243 | 115834 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 900X LAKE MERCED BLVD | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x100 | Permit Number 777492 | 5987646.0 | 2090104.0 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | |
| 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) | ||||
| 109790 | 109790 | 100068 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 303 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990392.0 | 2090762.0 | 37.720281613079 | -122.47527420247 | (37.720281613079, -122.47527420247) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 44904 | 44904 | 211027 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 157 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991179.7136 | 2091396.7999900002 | 37.7220702434165 | -122.47259762098 | (37.7220702434165, -122.47259762098) | |||
| 137218 | 137218 | 211026 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 138 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991196.61305 | 2091604.8062200001 | 37.7226423552448 | -122.472554361808 | (37.7226423552448, -122.472554361808) | |||
| 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) | |||
| 29067 | 29067 | 211025 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 95 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991234.71561 | 2092082.53367 | 37.723956281843705 | -122.472457461651 | (37.7239562818437, -122.472457461651) | |||
| 41068 | 41068 | 211024 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 94 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991236.61569 | 2092101.4351299999 | 37.7240082905392 | -122.472452270761 | (37.7240082905392, -122.472452270761) | |||
| 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) | |||
| 35161 | 35161 | 211021 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 78 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991241.40021 | 2092233.4270099998 | 37.7243709844069 | -122.472445349599 | (37.7243709844069, -122.472445349599) | |||
| 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) | |||
| 133473 | 133473 | 211020 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 74 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991248.48231 | 2092260.69315 | 37.7244462603628 | -122.472422854829 | (37.7244462603628, -122.472422854829) | |||
| 132551 | 132551 | 211019 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 71 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991242.8983 | 2092280.74938 | 37.724501006592895 | -122.472443619273 | (37.7245010065929, -122.472443619273) | |||
| 116918 | 116918 | 211018 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 55 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991237.26366 | 2092440.87353 | 37.7249403415953 | -122.472474765495 | (37.7249403415953, -122.472474765495) | |||
| 33005 | 33005 | 211017 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 49 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991258.9422 | 2092457.39845 | 37.724986969654495 | -122.47240103009399 | (37.7249869696545, -122.472401030094) | |||
| 54409 | 54409 | 211016 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 46 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991242.43895 | 2092472.66575 | 37.7250279346749 | -122.472459191965 | (37.7250279346749, -122.472459191965) | |||
| 26747 | 26747 | 178177 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 167 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6004561.94872 | 2092421.1241099997 | 37.7256483463685 | -122.426411406667 | (37.7256483463685, -122.426411406667) | ||||
| 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) | |||
| 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) | |||
| 1103 | 1103 | 211013 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 44 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5991332.59313 | 2093509.69784 | 37.727880584217 | -122.47222310103399 | (37.727880584217, -122.472223101034) | |||
| 50538 | 50538 | 211012 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 35 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991334.380059999 | 2093575.3838 | 37.7280610448729 | -122.47222170976102 | (37.7280610448729, -122.472221709761) | |||
| 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) |
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");