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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25101 | 25101 | 206960 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998473.38947 | 2095013.2793400001 | 37.7324197368658 | -122.44764549463899 | (37.7324197368658, -122.447645494639) | ||||
25548 | 25548 | 71937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | ||
26975 | 26975 | 129323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Florence St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008475.1891 | 2118345.56468 | 37.7970513368976 | -122.414717435764 | (37.7970513368976, -122.414717435764) | ||||
27272 | 27272 | 206957 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998473.21835 | 2095005.05828 | 37.7323971540007 | -122.447645494648 | (37.7323971540007, -122.447645494648) | ||||
27332 | 27332 | 176698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 283 Moscow St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004617.240230001 | 2091470.03605 | 37.72303999319411 | -122.42615258897 | (37.7230399931941, -122.42615258897) | ||||
29711 | 29711 | 218145 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Ashton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5994144.20993 | 2090116.67038 | 37.7187264660332 | -122.462257368104 | (37.7187264660332, -122.462257368104) | ||||
29956 | 29956 | 176692 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6004473.28311 | 2091848.82103 | 37.72407191576529 | -122.426677180615 | (37.7240719157653, -122.426677180615) | ||||
31573 | 31573 | 129332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007563.684280001 | 2119863.77685 | 37.8011687120311 | -122.417979152724 | (37.8011687120311, -122.417979152724) | ||||
32280 | 32280 | 129119 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1114 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007553.05086 | 2119913.7987599997 | 37.8013054611424 | -122.418019497203 | (37.8013054611424, -122.418019497203) | ||||
32430 | 32430 | 176689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6004476.46951 | 2091852.67463 | 37.72408267705 | -122.426666440004 | (37.72408267705, -122.426666440004) | ||||
34438 | 34438 | 176721 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6005098.35657 | 2092750.06265 | 37.7265818471717 | -122.42458047420799 | (37.7265818471717, -122.424580474208) | ||||
35777 | 35777 | 226865 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 San Jose Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004824.42349 | 2096711.0552700001 | 37.7374423749661 | -122.425809268297 | (37.7374423749661, -122.425809268297) | ||||
37322 | 37322 | 219374 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 167 Hamerton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001346.700759999 | 2095283.33425 | 37.7333250412114 | -122.437731137293 | (37.7333250412114, -122.437731137293) | ||||
39701 | 39701 | 129113 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007329.70066 | 2119282.266 | 37.7995588581063 | -122.418747576633 | (37.7995588581063, -122.418747576633) | ||||
41994 | 41994 | 129117 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6007264.16981 | 2119273.41538 | 37.7995308667162 | -122.418973709394 | (37.7995308667162, -122.418973709394) | ||||
43932 | 43932 | 206959 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998473.1983199995 | 2095010.9948599997 | 37.7324134532998 | -122.44764599109399 | (37.7324134532998, -122.447645991094) | ||||
47621 | 47621 | 226917 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1334 Diamond St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001952.27802 | 2100070.91902 | 37.7465050491722 | -122.43597994953699 | (37.7465050491722, -122.435979949537) | ||||
50439 | 50439 | 176687 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004483.134190001 | 2091864.5004 | 37.7241155248047 | -122.426644242931 | (37.7241155248047, -122.426644242931) | ||||
52800 | 52800 | 129325 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007543.5223900005 | 2119858.96336 | 37.801154360655 | -122.41804858037399 | (37.801154360655, -122.418048580374) | ||||
54077 | 54077 | 176691 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004467.85023 | 2091856.56465 | 37.7240928708828 | -122.426696512434 | (37.7240928708828, -122.426696512434) | ||||
54090 | 54090 | 226841 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 Grand View Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6000050.597159999 | 2101613.91714 | 37.7506335336184 | -122.44266650425301 | (37.7506335336184, -122.442666504253) | ||||
54321 | 54321 | 70512 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 5 | 6004917.4216 | 2092965.0192099998 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | ||
54473 | 54473 | 103306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6011832.19369 | 2105491.00064 | 37.7619437242424 | -122.402197092231 | (37.7619437242424, -122.402197092231) | ||||
55511 | 55511 | 247671 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 170 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001937.95373 | 2108623.93042 | 37.7699887373234 | -122.43664159784099 | (37.7699887373234, -122.436641597841) | ||||
55719 | 55719 | 110572 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
57173 | 57173 | 247138 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6003171.95048 | 2100074.35789 | 37.7465837047841 | -122.43176270469499 | (37.7465837047841, -122.431762704695) | ||||
59244 | 59244 | 71583 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5993925.4185 | 2086705.1573599998 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | ||
60193 | 60193 | 219308 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 166 Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5998423.39601 | 2093237.9492099998 | 37.7275422412798 | -122.447690576758 | (37.7275422412798, -122.447690576758) | ||||
60332 | 60332 | 129310 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007284.92251 | 2119276.14262 | 37.7995395235904 | -122.418902090975 | (37.7995395235904, -122.418902090975) | ||||
60867 | 60867 | 246724 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501 Shotwell St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6008058.52794 | 2099329.47434 | 37.744814207710796 | -122.41481267936001 | (37.7448142077108, -122.41481267936) | ||||
60902 | 60902 | 129330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007557.40785 | 2119862.6523599997 | 37.8011652712212 | -122.41800079219601 | (37.8011652712212, -122.418000792196) | ||||
61449 | 61449 | 219253 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 449 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5997174.7237 | 2095517.45722 | 37.7337297819926 | -122.452171628738 | (37.7337297819926, -122.452171628738) | ||||
62195 | 62195 | 84689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6002195.05393 | 2120739.39081 | 37.80326930438871 | -122.436619630107 | (37.8032693043887, -122.436619630107) | |||
63287 | 63287 | 219402 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 434 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998549.21745 | 2095283.33159 | 37.733165569840295 | -122.44740277122601 | (37.7331655698403, -122.447402771226) | ||||
64677 | 64677 | 247136 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003181.95614 | 2100090.46758 | 37.7466285054035 | -122.43172925621501 | (37.7466285054035, -122.431729256215) | ||||
64780 | 64780 | 129114 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007312.730219999 | 2119281.87279 | 37.79955682294621 | -122.41880627269899 | (37.7995568229462, -122.418806272699) | ||||
65360 | 65360 | 129326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007546.3898 | 2119859.39883 | 37.801155717731 | -122.41803868875401 | (37.801155717731, -122.418038688754) | ||||
66998 | 66998 | 226943 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 301 Fairmount St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 63 | 6004022.8098 | 2097135.0105400002 | 37.7385611270814 | -122.42861103418001 | (37.7385611270814, -122.42861103418) | ||||
67246 | 67246 | 219401 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 434 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998548.8783 | 2095279.67226 | 37.7331555028062 | -122.447403680457 | (37.7331555028062, -122.447403680457) | ||||
74501 | 74501 | 129333 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007566.1830400005 | 2119864.34532 | 37.8011704135381 | -122.417970546228 | (37.8011704135381, -122.417970546228) | ||||
75142 | 75142 | 226916 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1334 Diamond St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001951.53708 | 2100078.27366 | 37.746525201185705 | -122.435983037796 | (37.7465252011857, -122.435983037796) | ||||
75513 | 75513 | 190810 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1400 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6012250.57302 | 2101824.03335 | 37.75189838151329 | -122.400492482157 | (37.7518983815133, -122.400492482157) | ||||
78535 | 78535 | 110569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
89053 | 89053 | 102912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 84 Vienna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004823.0 | 2092922.0 | 37.7270383945734 | -122.42554460371599 | (37.7270383945734, -122.425544603716) | |||||
94696 | 94696 | 107828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2601 Van Ness Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | Permit Number 774138 | 6005744.5 | 2119283.2 | 37.799472043237294 | -122.424233014169 | (37.7994720432373, -122.424233014169) | |||
97359 | 97359 | 119672 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2090x 20th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6011896.0 | 2104722.0 | 37.7598357807336 | -122.40192234981501 | (37.7598357807336, -122.401922349815) | |||||
101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
104404 | 104404 | 106685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Yukon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 772768 | 6000197.4 | 2104288.0 | 37.757984281634 | -122.44235080136299 | (37.757984281634, -122.442350801363) | |||||
107354 | 107354 | 110571 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
107819 | 107819 | 114704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 524 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996948.70097149 | 2093858.06219815 | 37.729160530354 | -122.452833321223 | (37.729160530354, -122.452833321223) | |||||
119837 | 119837 | 219290 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 502 Edna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5998794.71473 | 2094454.093 | 37.7309027019769 | -122.44649438672899 | (37.7309027019769, -122.446494386729) | ||||
123310 | 123310 | 226843 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 Grand View Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6000048.9204 | 2101630.772 | 37.7506797174008 | -122.442673512691 | (37.7506797174008, -122.442673512691) | ||||
124373 | 124373 | 110570 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
135078 | 135078 | 176697 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 283 Moscow St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004613.59426 | 2091464.71146 | 37.7230251669629 | -122.426164813475 | (37.7230251669629, -122.426164813475) | ||||
136064 | 136064 | 206915 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 382 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999548.48293 | 2094983.7433799999 | 37.7324000228394 | -122.44392653538999 | (37.7324000228394, -122.44392653539) | ||||
136870 | 136870 | 206916 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 382 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5999547.8885699995 | 2094988.6031799999 | 37.7324133328074 | -122.44392893927 | (37.7324133328074, -122.44392893927) | ||||
138216 | 138216 | 129178 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998998.34734 | 2120131.24528 | 37.801417321497794 | -122.447638089651 | (37.8014173214978, -122.447638089651) | ||||
149094 | 149094 | 129115 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007304.145280001 | 2119280.40626 | 37.7995523128455 | -122.418835875684 | (37.7995523128455, -122.418835875684) | ||||
149203 | 149203 | 176720 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6005093.440280001 | 2092751.8073 | 37.7265863599479 | -122.424597593708 | (37.7265863599479, -122.424597593708) | ||||
149571 | 149571 | 226942 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 301 Fairmount St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 61 | 6004034.48943 | 2097139.1413599998 | 37.7385731303523 | -122.428570945989 | (37.7385731303523, -122.428570945989) | ||||
150004 | 150004 | 247945 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 15 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010344.08085 | 2098894.91993 | 37.743749172086794 | -122.406879009554 | (37.7437491720868, -122.406879009554) | ||||
151655 | 151655 | 129180 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5998992.55112 | 2120173.79871 | 37.8015338304744 | -122.447661212108 | (37.8015338304744, -122.447661212108) | ||||
151959 | 151959 | 176688 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6004477.9919300005 | 2091866.25637 | 37.7241200555896 | -122.426662143938 | (37.7241200555896, -122.426662143938) | ||||
153922 | 153922 | 176719 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6005086.02152 | 2092756.70841 | 37.7265993983363 | -122.424623588602 | (37.7265993983363, -122.424623588602) | ||||
155571 | 155571 | 129116 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007272.57871 | 2119275.5487599997 | 37.7995371979413 | -122.418944762911 | (37.7995371979413, -122.418944762911) | ||||
161824 | 161824 | 226864 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 294 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6002870.33579 | 2096200.69977 | 37.735930434733895 | -122.43252901612499 | (37.7359304347339, -122.432529016125) | ||||
166472 | 166472 | 219289 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 212 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6000021.7588599995 | 2094391.55227 | 37.7308009895552 | -122.442247818595 | (37.7308009895552, -122.442247818595) | ||||
167449 | 167449 | 176718 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 139 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6004890.82087 | 2092414.1622099997 | 37.7256478157716 | -122.42527402599801 | (37.7256478157716, -122.425274025998) | ||||
167821 | 167821 | 219239 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 579 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5997578.77584 | 2094371.8563299999 | 37.7306073727237 | -122.450692139651 | (37.7306073727237, -122.450692139651) | ||||
169027 | 169027 | 206958 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998473.20462 | 2095007.84782 | 37.7324048126327 | -122.447645742852 | (37.7324048126327, -122.447645742852) | ||||
169303 | 169303 | 129327 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007552.17158 | 2119860.88653 | 37.801160127991295 | -122.41801878675899 | (37.8011601279913, -122.418018786759) | ||||
170842 | 170842 | 129329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007555.7240699995 | 2119861.47467 | 37.8011619428155 | -122.41800653528601 | (37.8011619428155, -122.418006535286) | ||||
171348 | 171348 | 190811 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1400 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012250.38187 | 2101814.62177 | 37.7518725286982 | -122.400492482145 | (37.7518725286982, -122.400492482145) | ||||
171563 | 171563 | 129328 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007553.95221 | 2119861.40094 | 37.8011616406485 | -122.418012661478 | (37.8011616406485, -122.418012661478) | ||||
171687 | 171687 | 219254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 449 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997174.97013 | 2095514.3444599998 | 37.7337212492173 | -122.452170552242 | (37.7337212492173, -122.452170552242) | ||||
173605 | 173605 | 226941 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Fairmount St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6004051.37428 | 2097144.63452 | 37.738589168851206 | -122.42851295770399 | (37.7385891688512, -122.428512957704) | ||||
173712 | 173712 | 201343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012739.9825 | 2092614.2530099999 | 37.72663754126479 | -122.39815395433399 | (37.7266375412648, -122.398153954334) | ||||
174096 | 174096 | 219307 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 166 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998440.900769999 | 2093236.39067 | 37.727538962329604 | -122.447629950774 | (37.7275389623296, -122.447629950774) | ||||
174640 | 174640 | 176690 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6004472.37947 | 2091855.23398 | 37.724089473225206 | -122.426680760821 | (37.7240894732252, -122.426680760821) | ||||
175259 | 175259 | 218146 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Ashton Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5994143.80732 | 2090112.0989599999 | 37.7187138908262 | -122.46225842838601 | (37.7187138908262, -122.462258428386) | ||||
175549 | 175549 | 247137 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003179.078430001 | 2100075.39017 | 37.7465869432333 | -122.431738130709 | (37.7465869432333, -122.431738130709) | ||||
179080 | 179080 | 118669 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | 5981412.61192 | 2111005.49415 | 37.7753400136649 | -122.507813913091 | (37.7753400136649, -122.507813913091) | ||||
179518 | 179518 | 176686 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 242 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004486.61146 | 2091862.36635 | 37.7241098617621 | -122.426632070637 | (37.7241098617621, -122.426632070637) | ||||
179802 | 179802 | 129331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007561.62509 | 2119863.3782 | 37.8011675015458 | -122.41798625015899 | (37.8011675015458, -122.417986250159) | ||||
183882 | 183882 | 129112 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007339.93679 | 2119283.26863 | 37.799562187397704 | -122.41871222699801 | (37.7995621873977, -122.418712226998) | ||||
184997 | 184997 | 219400 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 434 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5998549.53071 | 2095273.1110200002 | 37.7331375244767 | -122.447400952815 | (37.7331375244767, -122.447400952815) | ||||
187209 | 187209 | 206920 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 411 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5997366.58572 | 2095512.9448099998 | 37.7337283808453 | -122.45150798300399 | (37.7337283808453, -122.451507983004) | ||||
187387 | 187387 | 226842 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 Grand View Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6000049.35116 | 2101618.9889599998 | 37.75064738858 | -122.44267117713699 | (37.75064738858, -122.442671177137) | ||||
188832 | 188832 | 129179 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5998993.68481 | 2120160.70419 | 37.801497941247895 | -122.44765634587601 | (37.8014979412479, -122.447656345876) | ||||
14463 | 14463 | 110915 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014720.0191 | 2113052.86526 | 37.7828676936327 | -122.39273818212 | (37.7828676936327, -122.39273818212) | |||
28768 | 28768 | 110918 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014775.51071 | 2113108.67341 | 37.7830240119856 | -122.392550107818 | (37.7830240119856, -122.392550107818) | |||
151494 | 151494 | 110917 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014761.22745 | 2113096.50864 | 37.7829898170664 | -122.39259867121001 | (37.7829898170664, -122.39259867121) | |||
164696 | 164696 | 110916 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014753.14393 | 2113088.0309200003 | 37.7829660902443 | -122.392626043851 | (37.7829660902443, -122.392626043851) | |||
181098 | 181098 | 110919 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014784.35432 | 2113116.8816 | 37.783047040932395 | -122.39252008665001 | (37.7830470409324, -122.39252008665) | |||
50164 | 50164 | 107054 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 98X ROTTECK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6003385.0 | 2094496.0 | 37.731278888142704 | -122.43062801306999 | (37.7312788881427, -122.43062801307) | |||
66804 | 66804 | 115308 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1309 Hyde St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | 6007523.230690001 | 2116877.91301 | 37.792967998429 | -122.417907360732 | (37.792967998429, -122.417907360732) | |||
80890 | 80890 | 108255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
92163 | 92163 | 108259 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
98097 | 98097 | 108256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
105668 | 105668 | 108258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) |
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");