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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2179 | 2179 | 252925 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700 Sanchez St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
| 3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
| 8796 | 8796 | 8530 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 15 | 6001630.1932 | 2113615.3325 | 37.783676377346794 | -122.438063730933 | (37.7836763773468, -122.438063730933) | |||
| 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) | ||||
| 9904 | 9904 | 61559 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1096 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/25/1984 12:00:00 AM | 16 | Permit Number 21519 | 6012461.11053783 | 2102868.78681941 | 37.75477878641421 | -122.399837764002 | (37.7547787864142, -122.399837764002) | ||
| 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 | ||||||||
| 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) | ||||
| 18734 | 18734 | 94234 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 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) | ||||
| 39138 | 39138 | 234477 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Grand View Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999979.4834199995 | 2101750.0189 | 37.751003181959895 | -122.442922193204 | (37.7510031819599, -122.442922193204) | ||||
| 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) | ||||
| 41214 | 41214 | 211038 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6001171.81546 | 2095754.02956 | 37.7346075158123 | -122.43836947339199 | (37.7346075158123, -122.438369473392) | ||||
| 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) | ||||
| 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) | ||||
| 58985 | 58985 | 211040 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6001161.45161 | 2095717.9227900002 | 37.7345077855016 | -122.43840271862899 | (37.7345077855016, -122.438402718629) | ||||
| 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) | |||||
| 63541 | 63541 | 234471 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1350 Noe St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6003196.852580001 | 2100348.13678 | 37.7473368492221 | -122.431696139568 | (37.7473368492221, -122.431696139568) | ||||
| 66679 | 66679 | 211036 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001192.69302 | 2095737.41742 | 37.7345630902121 | -122.438296103083 | (37.7345630902121, -122.438296103083) | ||||
| 77629 | 77629 | 87016 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
| 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) | ||||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 83316 | 83316 | 87018 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1200 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | |||
| 84102 | 84102 | 94231 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 88999 | 88999 | 94233 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 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) | ||||
| 89948 | 89948 | 98838 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1101X Portola Dr | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5994967.957909999 | 2097979.30417 | 37.740362747150996 | -122.459979297607 | (37.740362747151, -122.459979297607) | |||
| 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) | |||||
| 92148 | 92148 | 87013 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1184 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49946 | 6017813.5 | 2093492.6 | 37.7293305991048 | -122.380675823117 | (37.7293305991048, -122.380675823117) | |||
| 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) | |||
| 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) | ||||
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 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) | ||||
| 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) | ||||
| 101397 | 101397 | 87015 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
| 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) | ||||
| 103326 | 103326 | 96843 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 417 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | |||||
| 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) | ||||
| 107428 | 107428 | 101036 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1010X Portola Dr | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||
| 107755 | 107755 | 94230 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Everglade Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 108306 | 108306 | 96844 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 417 Dewey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | |||||
| 109599 | 109599 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 600 Front St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.39944985704099 | (37.7974274520849, -122.399449857041) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||||
| 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) | ||||
| 116587 | 116587 | 94232 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 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) | |||||
| 118896 | 118896 | 101040 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1010X Portola Dr | 14 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||
| 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) | ||||
| 120538 | 120538 | 87017 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1200 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | |||
| 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) | ||||
| 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) | |||||
| 122533 | 122533 | 87014 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
| 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) | ||||
| 123850 | 123850 | 107158 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 101x Elsie St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 20 | 6007300.0 | 2098759.0 | 37.7432051631731 | -122.417395111614 | (37.7432051631731, -122.417395111614) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 141881 | 141881 | 94235 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 27 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 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) | ||||
| 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) | ||
| 144225 | 144225 | 101034 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1010X Portola Dr | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
| 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) | ||||
| 156955 | 156955 | 211039 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6001157.31367 | 2095726.26325 | 37.7345304511011 | -122.438417622186 | (37.7345304511011, -122.438417622186) | ||||
| 158981 | 158981 | 211037 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6001183.29295 | 2095747.84811 | 37.734591195811795 | -122.438329349227 | (37.7345911958118, -122.438329349227) | ||||
| 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) | ||||
| 159459 | 159459 | 234473 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | 6007295.70063 | 2098744.01488 | 37.7431637754778 | -122.417408915989 | (37.7431637754778, -122.417408915989) | ||||
| 159854 | 159854 | 247525 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1101 Waller St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000029.935269999 | 2108491.2793400004 | 37.7695158962756 | -122.443231851395 | (37.7695158962756, -122.443231851395) | ||||
| 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) | ||||
| 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) | ||||
| 173673 | 173673 | 211035 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6001198.5187 | 2095714.51341 | 37.7345005324595 | -122.438274321504 | (37.7345005324595, -122.438274321504) | ||||
| 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) | ||||
| 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) | ||||
| 93367 | 93367 | 2045 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X Bosworth St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 120471 | 120471 | 2028 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 600X Bosworth St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |
| 118870 | 118870 | 3773 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1098 Carolina St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
| 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 | ||||||||
| 123604 | 123604 | 23614 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 910X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 30X30PL | 6011300.2113585 | 2104101.3880723 | 37.7580984495586 | -122.403939228694 | (37.7580984495586, -122.403939228694) | |||
| 126787 | 126787 | 23612 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | |||
| 20409 | 20409 | 4367 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 973 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001101.12966 | 2096102.69208 | 37.7355608412513 | -122.438638832041 | (37.7355608412513, -122.438638832041) |
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");