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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54265 | 54265 | 185439 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2300 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985094.1378 | 2099479.3093 | 37.74390853380999 | -122.494229093058 | (37.74390853381, -122.494229093058) | |||
| 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) | |||
| 55771 | 55771 | 186733 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1250 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984855.8629 | 2106397.0571 | 37.7628888152225 | -122.49556310804701 | (37.7628888152225, -122.495563108047) | |||
| 56596 | 56596 | 211001 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Portola Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996755.5114400005 | 2099350.67627 | 37.7442308453761 | -122.45389769125 | (37.7442308453761, -122.45389769125) | |||
| 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) | ||||
| 58287 | 58287 | 200617 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 58 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6016444.7184 | 2095097.4319 | 37.7336615146436 | -122.385519666546 | (37.7336615146436, -122.385519666546) | |||
| 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) | ||||
| 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) | |||
| 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) | |||||
| 61627 | 61627 | 211032 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 297 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993259.54182 | 2099680.27875 | 37.7449347888095 | -122.46600984507799 | (37.7449347888095, -122.466009845078) | |||
| 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) | |||
| 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) | |||
| 63191 | 63191 | 234475 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 378 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007368.44216 | 2096501.6263599999 | 37.7370107660349 | -122.41699854724101 | (37.7370107660349, -122.416998547241) | |||
| 63231 | 63231 | 185118 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2850 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 0ft | 5985615.0479 | 2096000.8357 | 37.734388044102204 | -122.49217185843099 | (37.7343880441022, -122.492171858431) | |||
| 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) | ||||
| 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) | |||
| 64531 | 64531 | 184348 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1251 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984683.9949 | 2106431.9954 | 37.762974680362206 | -122.496160108596 | (37.7629746803622, -122.496160108596) | |||
| 64562 | 64562 | 181379 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984933.4588 | 2104463.134 | 37.7575833453331 | -122.495152116603 | (37.7575833453331, -122.495152116603) | |||
| 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) | |||
| 65779 | 65779 | 194426 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 132 Kissling St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 5ft | 6007946.83693 | 2109121.1094299997 | 37.77169351738029 | -122.415892125715 | (37.7716935173803, -122.415892125715) | |||
| 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) | ||||
| 66847 | 66847 | 200559 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016309.6626 | 2095501.1365 | 37.7347625331555 | -122.38601473032 | (37.7347625331555, -122.38601473032) | |||
| 67079 | 67079 | 186038 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1900 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984981.8854 | 2102120.1374 | 37.7511529582795 | -122.494811896529 | (37.7511529582795, -122.494811896529) | |||
| 68825 | 68825 | 185954 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2001 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984829.7049 | 2101412.004 | 37.749199709057706 | -122.495285928093 | (37.7491997090577, -122.495285928093) | |||
| 69007 | 69007 | 186699 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984730.9983 | 2105175.3386 | 37.759527005597604 | -122.495904834542 | (37.7595270055976, -122.495904834542) | |||
| 69760 | 69760 | 185902 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2000 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985031.1855 | 2101301.2352 | 37.7489073626901 | -122.494581050501 | (37.7489073626901, -122.494581050501) | |||
| 69894 | 69894 | 186685 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984734.6622 | 2105357.4834 | 37.7600273389586 | -122.495905599978 | (37.7600273389586, -122.495905599978) | |||
| 70507 | 70507 | 184801 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1301 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984720.8276 | 2105758.3732 | 37.7611272600096 | -122.49598302148998 | (37.7611272600096, -122.49598302149) | |||
| 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) | |||
| 70815 | 70815 | 186456 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984777.372 | 2103875.7247 | 37.755961343063895 | -122.49564859346701 | (37.7559613430639, -122.495648593467) | |||
| 71190 | 71190 | 91505 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 72624 | 72624 | 185709 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2101 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984908.4893 | 2100423.9717 | 37.7464914545154 | -122.49494065264601 | (37.7464914545154, -122.494940652646) | |||
| 72881 | 72881 | 186381 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1801 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984844.8943 | 2102435.3563 | 37.75201044294921 | -122.495308863381 | (37.7520104429492, -122.495308863381) | |||
| 74141 | 74141 | 186421 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984727.9626 | 2104153.7573 | 37.756721849906 | -122.495839973726 | (37.756721849906, -122.495839973726) | |||
| 74910 | 74910 | 186080 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1901 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984851.2986 | 2101988.3321 | 37.7507834123081 | -122.49525375381599 | (37.7507834123081, -122.495253753816) | |||
| 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) | |||
| 75987 | 75987 | 211004 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996822.63607 | 2099410.87592 | 37.7443999871842 | -122.453669936126 | (37.7443999871842, -122.453669936126) | |||
| 77480 | 77480 | 8344 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 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) | |||||
| 79809 | 79809 | 21491 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2792X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 80059 | 80059 | 91504 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 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) | |||||
| 80466 | 80466 | 8349 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 80484 | 80484 | 8339 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 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) | ||||
| 81272 | 81272 | 87834 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 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) | ||
| 84253 | 84253 | 21431 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2692X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 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) | ||||
| 86211 | 86211 | 91503 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 86601 | 86601 | 27299 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982630.17797 | 2112395.09735 | 37.779227117259296 | -122.503705073784 | (37.7792271172593, -122.503705073784) | ||
| 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) | ||||
| 88368 | 88368 | 8563 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | |||
| 88546 | 88546 | 8341 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 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) | ||||
| 89362 | 89362 | 8562 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | |||
| 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) | |||||
| 91520 | 91520 | 186238 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1701 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984762.5292 | 2103340.0793 | 37.7544897398871 | -122.49566041616501 | (37.7544897398871, -122.495660416165) | |||
| 92056 | 92056 | 27295 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.779242313567295 | -122.50336180684499 | (37.7792423135673, -122.503361806845) | ||
| 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) | |||
| 92710 | 92710 | 8340 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 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) | |||
| 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) | ||||
| 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) | |
| 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) | |||
| 99151 | 99151 | 8561 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | ||
| 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) | ||||
| 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) | |||
| 100876 | 100876 | 8560 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | ||
| 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) | |||
| 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) | |
| 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) | ||||
| 106088 | 106088 | 91502 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 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) | ||
| 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) | |||
| 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) | |||||
| 108857 | 108857 | 8348 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 6 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 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) | |||
| 111288 | 111288 | 27297 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.863919999 | 2112396.64212 | 37.7792343387449 | -122.50352984750401 | (37.7792343387449, -122.503529847504) | ||
| 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) | |||||
| 114112 | 114112 | 27296 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982703.46074 | 2112397.7930900003 | 37.7792388274313 | -122.50345176232 | (37.7792388274313, -122.50345176232) | ||
| 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) | |
| 114533 | 114533 | 87835 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) |
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");