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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||||
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) | |||||
115283 | 115283 | 8342 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
115433 | 115433 | 186889 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985183.3004 | 2096502.846 | 37.7357411821318 | -122.49370150858101 | (37.7357411821318, -122.493701508581) | |||
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) | ||||
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) | |||
117137 | 117137 | 21429 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2692X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
117254 | 117254 | 24789 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.779435386439204 | -122.50204978501301 | (37.7794353864392, -122.502049785013) | |||
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) | |||||
117891 | 117891 | 8351 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
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) | |||
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) | ||||
120091 | 120091 | 234474 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 72 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006078.82979 | 2097595.56477 | 37.739941848150394 | -122.421534992063 | (37.7399418481504, -122.421534992063) | |||
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) | |||
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) | |||||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
135334 | 135334 | 184982 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2701 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984985.373 | 2096691.7859999998 | 37.7362483795762 | -122.494399733702 | (37.7362483795762, -122.494399733702) | |||
135899 | 135899 | 211034 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 417 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5995115.077769999 | 2100328.51022 | 37.746821542199996 | -122.45964072765 | (37.7468215422, -122.45964072765) | |||
136097 | 136097 | 185539 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2201 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984878.3804 | 2100042.8891 | 37.7454433428019 | -122.495016669314 | (37.7454433428019, -122.495016669314) | |||
136877 | 136877 | 181519 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1400 Sunset Blvd | 79 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984899.8047 | 2105606.7824 | 37.76072151501489 | -122.49535284581002 | (37.7607215150149, -122.49535284581) | |||
136924 | 136924 | 200613 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6016431.4971 | 2095119.9571 | 37.733722632810604 | -122.38556694616501 | (37.7337226328106, -122.385566946165) | |||
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) | |||
137509 | 137509 | 187121 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985174.7424 | 2097328.4139 | 37.7380074703554 | -122.493791914706 | (37.7380074703554, -122.493791914706) | |||
137881 | 137881 | 200571 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016326.461 | 2095462.4873 | 37.7346573398722 | -122.385953958726 | (37.7346573398722, -122.385953958726) | |||
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) | ||||
141886 | 141886 | 21459 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2701X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
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) | ||||
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) | |||||
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) | |||
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) | |||
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) |
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");