Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
86719 | 86719 | 109347 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 59x BURNSIDE AVE | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | ||||
142951 | 142951 | 111265 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 20 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
18019 | 18019 | 111271 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 42 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
79179 | 79179 | 111279 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 17 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
89050 | 89050 | 111507 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 18 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
100466 | 100466 | 111508 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 18 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
82351 | 82351 | 111514 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
85854 | 85854 | 111516 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 14 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
126284 | 126284 | 111553 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 31 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
140665 | 140665 | 111554 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 32 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 26 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
111551 | 111551 | 111555 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 33 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
115460 | 115460 | 111557 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 35 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
100574 | 100574 | 111558 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 36 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 15 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
100839 | 100839 | 111575 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1x SUNSET BLVD OFF RAMP | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 3x3 | 5984955.0 | 2095624.0 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | |||
103200 | 103200 | 112912 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 480X BEACON ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 30 | 6002571.0 | 2098077.0 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
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) | |
84289 | 84289 | 115997 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 20X Park St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 08/30/2016 09:25:00 AM | 3 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | |||
96458 | 96458 | 116067 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 4150X CLEMENT ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | |
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) | |||
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) | ||||
86909 | 86909 | 120542 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2450 California St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | DPW for City Agency 2 | 6002644.1089699995 | 2115479.97736 | 37.7888538273233 | -122.43468935172599 | (37.7888538273233, -122.434689351726) | ||||
111709 | 111709 | 120624 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
79301 | 79301 | 120625 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004349.0 | 2113949.0 | 37.784746788576705 | -122.428681484586 | (37.7847467885767, -122.428681484586) | |||||
61501 | 61501 | 120626 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
117256 | 117256 | 120627 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
121508 | 121508 | 120628 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004397.0 | 2113949.0 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | |||||
90526 | 90526 | 120629 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
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) | |||
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) | ||||
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) | ||||
46130 | 46130 | 132162 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 165 Francisco St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.40771371440901 | (37.8053168133783, -122.407713714409) | ||||
65528 | 65528 | 132163 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011528.08163 | 2120803.5748799997 | 37.8039714887622 | -122.40432672370399 | (37.8039714887622, -122.404326723704) | |||
39232 | 39232 | 132164 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011515.19186 | 2120799.8495099996 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | |||
60960 | 60960 | 139214 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6004809.3749 | 2114055.503 | 37.78506526335679 | -122.427096327106 | (37.7850652633568, -122.427096327106) | |||
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) | |||
62236 | 62236 | 139330 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6005126.2471 | 2114101.4827 | 37.7852094256692 | -122.42600332266599 | (37.7852094256692, -122.426003322666) | |||
131295 | 131295 | 139356 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6005063.0942 | 2114090.4032 | 37.785175434752105 | -122.42622102328698 | (37.7851754347521, -122.426221023287) | |||
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) | |||
70800 | 70800 | 139359 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 6004685.2851 | 2114039.9918 | 37.7850156556233 | -122.42752453341801 | (37.7850156556233, -122.427524533418) | |||
9686 | 9686 | 173637 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | ||||
9930 | 9930 | 173744 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
9922 | 9922 | 173745 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
9932 | 9932 | 173746 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) |
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");