Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
29962 | 29962 | 129123 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2495 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6001080.52047 | 2118605.3023200002 | 37.7973462632737 | -122.44032336202801 | (37.7973462632737, -122.440323362028) | |||
30012 | 30012 | 129133 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5999835.3006 | 2119536.2494799998 | 37.799831419239204 | -122.44469907640301 | (37.7998314192392, -122.444699076403) | |||
30337 | 30337 | 176758 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 663 Silver Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005749.694519999 | 2093584.4330799999 | 37.728909608285704 | -122.42238807817101 | (37.7289096082857, -122.422388078171) | |||
30388 | 30388 | 226889 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 21 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009640.71829 | 2098586.38073 | 37.7428626087272 | -122.409289311345 | (37.7428626087272, -122.409289311345) | |||
30448 | 30448 | 122000 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3848 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991408.48983 | 2110002.47291 | 37.773169842884 | -122.473163026058 | (37.773169842884, -122.473163026058) | |||
30597 | 30597 | 200732 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1462 Oakdale Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6015803.6984 | 2094934.205 | 37.7331778386107 | -122.387724495212 | (37.7331778386107, -122.387724495212) | |||
30656 | 30656 | 176851 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 339 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6004177.9913099995 | 2091279.54891 | 37.7224921207944 | -122.427657419158 | (37.7224921207944, -122.427657419158) | |||
30727 | 30727 | 129276 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1762 Washington St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6006164.04315 | 2116981.80981 | 37.7931766860951 | -122.422617614837 | (37.7931766860951, -122.422617614837) | |||
30977 | 30977 | 226957 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4415 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001675.32551 | 2104070.79205 | 37.75747200635521 | -122.437223965526 | (37.7574720063552, -122.437223965526) | |||
31157 | 31157 | 206941 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 5998788.54531 | 2094148.8010200001 | 37.7300640895797 | -122.446493759872 | (37.7300640895797, -122.446493759872) | |||
31245 | 31245 | 219282 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 201 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5999962.0472099995 | 2094329.87548 | 37.7306282360949 | -122.44244982431299 | (37.7306282360949, -122.442449824313) | |||
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) | ||||
31654 | 31654 | 117698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4049 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5982870.28986 | 2113072.50922 | 37.7811012062077 | -122.502924603076 | (37.7811012062077, -122.502924603076) | |||
31904 | 31904 | 226984 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2323 Diamond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6001664.11704 | 2096982.04185 | 37.738007342550794 | -122.436755300925 | (37.7380073425508, -122.436755300925) | |||
32036 | 32036 | 176732 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 462 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007785.763719999 | 2091661.92409 | 37.7237454564679 | -122.415213186138 | (37.7237454564679, -122.415213186138) | |||
32089 | 32089 | 219321 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.2109 | 2091143.91965 | 37.7216008413857 | -122.45909980971201 | (37.7216008413857, -122.459099809712) | |||
32222 | 32222 | 219278 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 70 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994659.22206 | 2100668.89439 | 37.747729927596396 | -122.46124169176001 | (37.7477299275964, -122.46124169176) | |||
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) | ||||
32303 | 32303 | 219349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992970.2206 | 2090529.11347 | 37.719791266033 | -122.466345302087 | (37.719791266033, -122.466345302087) | |||
32407 | 32407 | 866 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
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) | ||||
32459 | 32459 | 249756 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 40 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6000240.43697 | 2117209.2145 | 37.7934651076862 | -122.443129940195 | (37.7934651076862, -122.443129940195) | |||
32651 | 32651 | 219322 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.87033 | 2091157.1990200002 | 37.7216373412734 | -122.459098491322 | (37.7216373412734, -122.459098491322) | |||
32661 | 32661 | 176624 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 190 Foote Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998633.901980001 | 2088379.60151 | 37.714214369464 | -122.446613458762 | (37.714214369464, -122.446613458762) | |||
32893 | 32893 | 176636 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 725 Olmstead St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6009567.85058 | 2090563.67809 | 37.7208298948579 | -122.40897533376301 | (37.7208298948579, -122.408975333763) | |||
32920 | 32920 | 129104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2636 Union St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6000393.5421400005 | 2118227.4889 | 37.7962697496128 | -122.442673334618 | (37.7962697496128, -122.442673334618) | |||
33141 | 33141 | 176785 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 194 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6009137.47484 | 2093394.32671 | 37.7285781415571 | -122.41066281353999 | (37.7285781415571, -122.41066281354) | |||
33330 | 33330 | 129143 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999331.215369999 | 2120442.50933 | 37.8022909867986 | -122.44650862838199 | (37.8022909867986, -122.446508628382) | |||
33355 | 33355 | 129290 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1455 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6006103.4711 | 2119303.6940200003 | 37.799548577059205 | -122.42299230206899 | (37.7995485770592, -122.422992302069) | |||
33441 | 33441 | 248140 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 268 Rutledge St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6009882.82604 | 2099441.40705 | 37.7452238857837 | -122.408512467075 | (37.7452238857837, -122.408512467075) | |||
33747 | 33747 | 226990 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 255 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6002949.15348 | 2097822.0657099998 | 37.740386802104204 | -122.432372276886 | (37.7403868021042, -122.432372276886) | |||
33935 | 33935 | 226974 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 233 Arbor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6001270.1389999995 | 2096845.7649599998 | 37.7376107595169 | -122.4381077158 | (37.7376107595169, -122.4381077158) | |||
33950 | 33950 | 176781 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008506.492819999 | 2093591.6358299998 | 37.7290845129336 | -122.41285810544399 | (37.7290845129336, -122.412858105444) | |||
34113 | 34113 | 129193 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2601 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5999321.34267 | 2119401.25907 | 37.799431429569395 | -122.446467838743 | (37.7994314295694, -122.446467838743) | |||
34168 | 34168 | 226851 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 50 Digby St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6002882.53015 | 2097620.47975 | 37.7398295156191 | -122.43258823826599 | (37.7398295156191, -122.432588238266) | |||
34356 | 34356 | 227013 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5549 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001761.53629 | 2097297.86137 | 37.738880045571 | -122.436441072418 | (37.738880045571, -122.436441072418) | |||
34410 | 34410 | 129343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 310 Green St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6011372.9134599995 | 2119406.36194 | 37.800126411255995 | -122.40476527089399 | (37.800126411256, -122.404765270894) | |||
34424 | 34424 | 206951 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5998696.40165 | 2093529.6745 | 37.7283588499644 | -122.44676777970501 | (37.7283588499644, -122.446767779705) | |||
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) | ||||
34520 | 34520 | 226931 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2002 Castro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6002625.7141 | 2099687.43852 | 37.7454903360096 | -122.43362388225799 | (37.7454903360096, -122.433623882258) | |||
34647 | 34647 | 129297 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1287 Filbert St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006764.06719 | 2119403.1905 | 37.799859023038 | -122.420713464975 | (37.799859023038, -122.420713464975) | |||
34712 | 34712 | 176663 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Lamartine St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6002669.49931 | 2094359.4125400002 | 37.7308632891975 | -122.433091871219 | (37.7308632891975, -122.433091871219) | |||
34911 | 34911 | 176616 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1373 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999306.08729 | 2089805.4122099997 | 37.7181676947695 | -122.44439253889601 | (37.7181676947695, -122.444392538896) | |||
34914 | 34914 | 176818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 695 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6009866.42198 | 2091203.0617799999 | 37.722602230178 | -122.407988325128 | (37.722602230178, -122.407988325128) | |||
34919 | 34919 | 176670 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Camellia Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6003267.33366 | 2094058.1298900002 | 37.730069928882706 | -122.43100356717501 | (37.7300699288827, -122.431003567175) | |||
34985 | 34985 | 129161 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 135 Mayfair Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997429.44136 | 2114454.7075099996 | 37.7857412865759 | -122.452657259939 | (37.7857412865759, -122.452657259939) | |||
34986 | 34986 | 129263 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1075 Pacific Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 6009008.56152 | 2117982.3464099998 | 37.796083982049 | -122.41284613813299 | (37.796083982049, -122.412846138133) | |||
35098 | 35098 | 142469 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 548 VARENNES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010746.4928 | 2119899.9648 | 37.8014466914345 | -122.40696774883999 | (37.8014466914345, -122.40696774884) | |||
35124 | 35124 | 226997 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 147 Beacon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6003368.6222 | 2097143.53298 | 37.7385474834888 | -122.430873508099 | (37.7385474834888, -122.430873508099) | |||
35227 | 35227 | 226980 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 139 Farnum St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 3ft | 6002461.28051 | 2097299.02865 | 37.73892298731379 | -122.434021768396 | (37.7389229873138, -122.434021768396) | |||
35316 | 35316 | 219317 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1200 Capitol Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 1ft | 5995097.23073 | 2091960.8022599998 | 37.7238448414569 | -122.45909664051001 | (37.7238448414569, -122.45909664051) | |||
35455 | 35455 | 129147 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Jefferson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000543.90951 | 2121371.39176 | 37.8049106408804 | -122.442378852499 | (37.8049106408804, -122.442378852499) | |||
35617 | 35617 | 129243 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2127 Broadway | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6003277.29318 | 2117510.20752 | 37.794464246380294 | -122.432643704862 | (37.7944642463803, -122.432643704862) | |||
35741 | 35741 | 129306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1081 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6006156.05151 | 2120698.06699 | 37.8033801368411 | -122.42290950959101 | (37.8033801368411, -122.422909509591) | |||
35757 | 35757 | 219380 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 62 Nordhoff St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000460.74015 | 2095508.47445 | 37.7338928075 | -122.440810284667 | (37.7338928075, -122.440810284667) | |||
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) | ||||
35782 | 35782 | 190765 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1050 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6015259.20985 | 2101616.65669 | 37.751496295539106 | -122.39007361861601 | (37.7514962955391, -122.390073618616) | |||
36198 | 36198 | 129241 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2792 Fillmore St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6002607.77018 | 2117744.6226 | 37.7950698975185 | -122.434977106511 | (37.7950698975185, -122.434977106511) | |||
36384 | 36384 | 206940 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5999451.4635 | 2094112.46165 | 37.7300021523805 | -122.444199366316 | (37.7300021523805, -122.444199366316) | |||
36391 | 36391 | 190790 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1701 19th St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6012585.92688 | 2105143.77126 | 37.7610323521809 | -122.39956582791099 | (37.7610323521809, -122.399565827911) | |||
36439 | 36439 | 226890 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 257 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6009790.06992 | 2099605.20569 | 37.7456684458592 | -122.408844757605 | (37.7456684458592, -122.408844757605) | |||
36482 | 36482 | 226955 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 160 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009521.12916 | 2097699.3584 | 37.7404203378164 | -122.409640225031 | (37.7404203378164, -122.409640225031) | |||
36594 | 36594 | 129227 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6000607.86653 | 2117501.04945 | 37.794287353335704 | -122.441879565091 | (37.7942873533357, -122.441879565091) | |||
36674 | 36674 | 226855 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1706 Dolores St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6005260.22167 | 2098389.31197 | 37.7420751065764 | -122.424421844598 | (37.7420751065764, -122.424421844598) | |||
36733 | 36733 | 117761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 39th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5983797.475319999 | 2112772.58996 | 37.7803321653034 | -122.499694882039 | (37.7803321653034, -122.499694882039) | |||
36832 | 36832 | 250172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997240.90305 | 2110650.9273599996 | 37.775286300843796 | -122.45303486996401 | (37.7752863008438, -122.453034869964) | |||
36896 | 36896 | 129318 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900 Chestnut St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007412.87531 | 2120593.39917 | 37.8031635819044 | -122.418552786177 | (37.8031635819044, -122.418552786177) | |||
36912 | 36912 | 129299 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1287 Filbert St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006780.09649 | 2119405.7984599997 | 37.7998670872493 | -122.42065818273399 | (37.7998670872493, -122.420658182734) | |||
36939 | 36939 | 250162 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5997228.928169999 | 2110728.99929 | 37.7754999797735 | -122.45308193061301 | (37.7754999797735, -122.453081930613) | |||
36980 | 36980 | 219357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5993732.37033 | 2089277.01188 | 37.7163972426289 | -122.463620014561 | (37.7163972426289, -122.463620014561) | |||
36995 | 36995 | 176766 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Tulane St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 1ft | 6007444.0064199995 | 2093762.37592 | 37.7294936325246 | -122.41654330505501 | (37.7294936325246, -122.416543305055) | |||
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) | ||||
37364 | 37364 | 129125 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3750 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000188.47224 | 2121175.57148 | 37.8043527059816 | -122.44359480245501 | (37.8043527059816, -122.443594802455) | |||
37574 | 37574 | 117932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 599 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5982840.28847 | 2111742.07201 | 37.77744645210971 | -122.502929870802 | (37.7774464521097, -122.502929870802) | |||
37590 | 37590 | 176608 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Chicago Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6002866.9269 | 2086792.03649 | 37.710096150800794 | -122.431869203328 | (37.7100961508008, -122.431869203328) | |||
37637 | 37637 | 129196 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | |||
37643 | 37643 | 219320 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5995079.65544 | 2091128.71847 | 37.7215591281313 | -122.459097172915 | (37.7215591281313, -122.459097172915) | |||
37694 | 37694 | 176737 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1201 Bacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007977.54478 | 2091998.9809400002 | 37.7246817190783 | -122.414574069464 | (37.7246817190783, -122.414574069464) | |||
37774 | 37774 | 226848 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Farnum St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6002464.70638 | 2097278.29069 | 37.7388662400962 | -122.43400844134399 | (37.7388662400962, -122.434008441344) | |||
37929 | 37929 | 176673 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 62 Paulding St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 6ft | 5999928.39495 | 2093418.54545 | 37.7281240171909 | -122.442500760096 | (37.7281240171909, -122.442500760096) | |||
37931 | 37931 | 176756 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 39 Amherst St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6007334.92335 | 2093326.38526 | 37.7282903611866 | -122.416889539518 | (37.7282903611866, -122.416889539518) | |||
37997 | 37997 | 249753 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 37 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6000238.5689199995 | 2117223.4057 | 37.793503966475 | -122.44313742344801 | (37.793503966475, -122.443137423448) | |||
38096 | 38096 | 206933 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 6000003.13616 | 2094038.3079799998 | 37.7298300014536 | -122.44228685095301 | (37.7298300014536, -122.442286850953) | |||
38280 | 38280 | 176654 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Badger St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6002446.68138 | 2094237.0700599998 | 37.7305147227757 | -122.433853446802 | (37.7305147227757, -122.433853446802) | |||
38472 | 38472 | 129194 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Cervantes Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001552.51444 | 2120931.86169 | 37.8037612434571 | -122.438856955397 | (37.8037612434571, -122.438856955397) | |||
38511 | 38511 | 245190 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1165 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000954.6073 | 2109297.4919 | 37.7717822376068 | -122.440091274084 | (37.7717822376068, -122.440091274084) | |||
38573 | 38573 | 176693 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 231 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6004560.89466 | 2091885.9682599998 | 37.7241788667532 | -122.426376964428 | (37.7241788667532, -122.426376964428) | |||
38642 | 38642 | 176865 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001491.17517 | 2087075.7451099998 | 37.7107970662038 | -122.436644357861 | (37.7107970662038, -122.436644357861) | |||
38742 | 38742 | 219285 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 111 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6001314.21471 | 2094602.6455299999 | 37.7314541797466 | -122.437794714872 | (37.7314541797466, -122.437794714872) | |||
38919 | 38919 | 201349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012827.9931 | 2092586.2696 | 37.7265656062986 | -122.39784774058998 | (37.7265656062986, -122.39784774059) | |||
38948 | 38948 | 249603 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2240 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998819.017030001 | 2111486.76835 | 37.77767161949011 | -122.44763601580799 | (37.7776716194901, -122.447636015808) | |||
39030 | 39030 | 249749 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 33 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000235.88036 | 2117238.71283 | 37.7935458425285 | -122.44314782591299 | (37.7935458425285, -122.443147825913) | |||
39031 | 39031 | 118935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 882 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981106.559230001 | 2109729.9345299997 | 37.7718196654774 | -122.50877787634701 | (37.7718196654774, -122.508777876347) | |||
39084 | 39084 | 250169 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 7ft | 5997237.65706 | 2110666.34039 | 37.7753284349893 | -122.453047211372 | (37.7753284349893, -122.453047211372) | |||
39223 | 39223 | 226882 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2810 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009447.14609 | 2105030.4857 | 37.7605458378345 | -122.41041355295201 | (37.7605458378345, -122.410413552952) | |||
39238 | 39238 | 176826 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 635 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6002712.89216 | 2087452.0684200001 | 37.711899721374 | -122.432448688654 | (37.711899721374, -122.432448688654) | |||
39296 | 39296 | 118084 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5984977.6516 | 2112422.66835 | 37.7794405616591 | -122.49558634816002 | (37.7794405616591, -122.49558634816) | |||
39518 | 39518 | 129245 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008845.28336 | 2117017.82608 | 37.79342648000571 | -122.41334287149401 | (37.7934264800057, -122.413342871494) | |||
39633 | 39633 | 219241 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Miramar Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995302.14694 | 2090052.41762 | 37.7186166498261 | -122.458250223781 | (37.7186166498261, -122.458250223781) |
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");