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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26630 | 26630 | 206935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6000034.8522 | 2094044.21533 | 37.7298480292542 | -122.442177629193 | (37.7298480292542, -122.442177629193) | |||
26634 | 26634 | 190806 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1924 22nd St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012287.449569999 | 2103786.76177 | 37.7572896615996 | -122.400502813555 | (37.7572896615996, -122.400502813555) | |||
26732 | 26732 | 219280 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Paradise Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 1ft | 6001093.95551 | 2095893.7470200001 | 37.734986718566105 | -122.438648668815 | (37.7349867185661, -122.438648668815) | |||
26877 | 26877 | 176791 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 241 Bowdoin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 2ft | 6008533.10117 | 2094294.56275 | 37.731016093010204 | -122.41281579411199 | (37.7310160930102, -122.412815794112) | |||
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) | ||||
26978 | 26978 | 176852 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 339 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6004182.999 | 2091286.4234200001 | 37.7225112799465 | -122.427640598252 | (37.7225112799465, -122.427640598252) | |||
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) | ||||
27285 | 27285 | 118936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 882 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981106.21349 | 2109713.8297599996 | 37.7717754261179 | -122.508777876355 | (37.7717754261179, -122.508777876355) | |||
27303 | 27303 | 129201 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6002306.14505 | 2121870.94259 | 37.8063825585658 | -122.43631622670799 | (37.8063825585658, -122.436316226708) | |||
27318 | 27318 | 176739 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 318 Princeton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6007769.14827 | 2092407.95318 | 37.725792959174 | -122.41532341065 | (37.725792959174, -122.41532341065) | |||
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) | ||||
27504 | 27504 | 117817 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5983396.39556 | 2111078.07387 | 37.7756559745836 | -122.50095702488899 | (37.7756559745836, -122.500957024889) | |||
27530 | 27530 | 249494 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1801 California St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005708.87609 | 2115852.08373 | 37.790049051771 | -122.42411214416401 | (37.790049051771, -122.424112144164) | |||
27573 | 27573 | 249744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 28 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000231.5353 | 2117259.0230400003 | 37.793601361269396 | -122.44316431948799 | (37.7936013612694, -122.443164319488) | |||
27727 | 27727 | 129285 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1725 Jones St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6008285.46318 | 2118399.2200599997 | 37.79718799969079 | -122.41537773598999 | (37.7971879996908, -122.41537773599) | |||
27860 | 27860 | 176667 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 285 Santa Rosa Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6000731.05105 | 2093595.2382 | 37.7286548942011 | -122.43973861924499 | (37.7286548942011, -122.439738619245) | |||
27868 | 27868 | 226847 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 565 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6002862.54514 | 2099747.2239599996 | 37.7456679278515 | -122.43280922866501 | (37.7456679278515, -122.432809228665) | |||
27887 | 27887 | 176613 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 263 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5998491.328480001 | 2088788.6230099997 | 37.7153293039925 | -122.447135664507 | (37.7153293039925, -122.447135664507) | |||
27937 | 27937 | 176651 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 314 Cayuga Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002207.18384 | 2094067.78615 | 37.730036314028 | -122.434669323428 | (37.730036314028, -122.434669323428) | |||
28070 | 28070 | 190826 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6016386.63874 | 2108737.40916 | 37.771110828636296 | -122.38667129537 | (37.7711108286363, -122.38667129537) | |||
28072 | 28072 | 176805 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 472 Gaven St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008072.53583 | 2094580.3018900002 | 37.7317748087483 | -122.41442826236099 | (37.7317748087483, -122.414428262361) | |||
28078 | 28078 | 129229 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6000617.83995 | 2117501.7173200003 | 37.794289755430796 | -122.44184510397 | (37.7942897554308, -122.44184510397) | |||
28264 | 28264 | 176811 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008163.14276 | 2093697.53873 | 37.729356020957105 | -122.414052586778 | (37.7293560209571, -122.414052586778) | |||
28290 | 28290 | 124056 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5991955.56775 | 2111031.62491 | 37.776027276009 | -122.471345630007 | (37.776027276009, -122.471345630007) | |||
28378 | 28378 | 226920 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4112 23rd St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6002387.67518 | 2102409.13417 | 37.75294995968729 | -122.43464156316001 | (37.7529499596873, -122.43464156316) | |||
28406 | 28406 | 219344 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991912.69269 | 2089165.54418 | 37.71598616072 | -122.469901542523 | (37.71598616072, -122.469901542523) | |||
28529 | 28529 | 129173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2901 Steiner St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001992.763069999 | 2118215.18241 | 37.7963269932617 | -122.437138827596 | (37.7963269932617, -122.437138827596) | |||
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) | |||
28788 | 28788 | 129185 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3751 Broderick St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999586.95971 | 2121459.2161 | 37.8050971935371 | -122.445696789672 | (37.8050971935371, -122.445696789672) | |||
28808 | 28808 | 129341 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6007472.08384 | 2121212.09706 | 37.80486570266171 | -122.418391787764 | (37.8048657026617, -122.418391787764) | |||
28909 | 28909 | 176778 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6008224.08958 | 2093491.7864599999 | 37.728794492350396 | -122.41382733896499 | (37.7287944923504, -122.413827338965) | |||
29100 | 29100 | 129254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6008749.8874699995 | 2117004.3190200003 | 37.7933840364978 | -122.413671993685 | (37.7933840364978, -122.413671993685) | |||
29129 | 29129 | 117930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 593 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5982838.9134599995 | 2111805.09577 | 37.7776194161311 | -122.502939294109 | (37.7776194161311, -122.502939294109) | |||
29238 | 29238 | 176752 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Gambier St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6005769.79082 | 2093316.51308 | 37.7281750924071 | -122.422299575881 | (37.7281750924071, -122.422299575881) | |||
29588 | 29588 | 176728 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1831 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6005368.22996 | 2092645.7174900002 | 37.726310575669295 | -122.423640115208 | (37.7263105756693, -122.423640115208) | |||
29615 | 29615 | 219408 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 826 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5999474.92133 | 2095660.53825 | 37.7342541461187 | -122.44422947111799 | (37.7342541461187, -122.444229471118) | |||
29666 | 29666 | 226988 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 18 Arlington St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 6005176.38711 | 2097549.1244 | 37.73976340735629 | -122.42465196401301 | (37.7397634073563, -122.424651964013) | |||
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) | ||||
29869 | 29869 | 190789 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1701 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6012459.01369 | 2105136.91709 | 37.761006457089 | -122.400004286971 | (37.761006457089, -122.400004286971) | |||
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) | |||
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) |
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");