Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131686 | 131686 | 190788 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1701 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6012435.911169999 | 2105136.5588700003 | 37.7610041854195 | -122.400084163877 | (37.7610041854195, -122.400084163877) | |||
| 170127 | 170127 | 201932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 190 Boutwell St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 9ft | 6010626.2158 | 2095614.29555 | 37.734757064092605 | -122.405672426066 | (37.7347570640926, -122.405672426066) | |||
| 24631 | 24631 | 176638 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 65 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993323.454919999 | 2086371.47099 | 37.7083957495352 | -122.46482253315399 | (37.7083957495352, -122.464822533154) | |||
| 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) | |||
| 26942 | 26942 | 129350 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | |||
| 27490 | 27490 | 129348 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 40832 | 40832 | 227010 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5527 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001848.80076 | 2097475.72956 | 37.739373388466895 | -122.436152077973 | (37.7393733884669, -122.436152077973) | |||
| 43812 | 43812 | 176599 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 255 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5998280.541680001 | 2089346.8494799999 | 37.716850019794606 | -122.44790439957899 | (37.7168500197946, -122.447904399579) | |||
| 44537 | 44537 | 219348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5992970.49595 | 2090542.2168 | 37.7198272604875 | -122.466345302117 | (37.7198272604875, -122.466345302117) | |||
| 44637 | 44637 | 201345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6012754.450780001 | 2092609.0590599999 | 37.726624085606396 | -122.398103573427 | (37.7266240856064, -122.398103573427) | |||
| 44737 | 44737 | 206937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 33 Congo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6000058.45225 | 2094003.2368599998 | 37.7297368568549 | -122.442093101029 | (37.7297368568549, -122.442093101029) | |||
| 45644 | 45644 | 218230 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993788.79546 | 2098675.54917 | 37.7422065730654 | -122.46410687336001 | (37.7422065730654, -122.46410687336) | |||
| 46288 | 46288 | 129166 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5998684.61281 | 2113379.65213 | 37.782861304856894 | -122.448237300713 | (37.7828613048569, -122.448237300713) | |||
| 47046 | 47046 | 206921 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 638 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5997199.5508 | 2095299.8270400001 | 37.7331336438848 | -122.452070097972 | (37.7331336438848, -122.452070097972) | |||
| 48532 | 48532 | 226932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2002 Castro St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6002626.07145 | 2099676.8031 | 37.7454611539119 | -122.43362188664699 | (37.7454611539119, -122.433621886647) | |||
| 48581 | 48581 | 206949 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5998662.588880001 | 2093529.9908599998 | 37.728357786969 | -122.44688469428499 | (37.728357786969, -122.446884694285) | |||
| 52041 | 52041 | 206950 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5998705.14438 | 2093529.4926099998 | 37.7283588499702 | -122.44673754272499 | (37.7283588499702, -122.446737542725) | |||
| 53136 | 53136 | 226919 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 90 Fountain St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | Width 8ft | 6000343.27555 | 2101131.8365 | 37.7493265362977 | -122.44161980940001 | (37.7493265362977, -122.4416198094) | |||
| 53919 | 53919 | 218142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 55 Ridge Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5997830.51947 | 2089772.1428 | 37.717992043688895 | -122.449490525783 | (37.7179920436889, -122.449490525783) | |||
| 54826 | 54826 | 226930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2002 Castro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6002624.827880001 | 2099700.38315 | 37.745525828649 | -122.433627871623 | (37.745525828649, -122.433627871623) | |||
| 57464 | 57464 | 227009 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5527 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001851.51038 | 2097474.41545 | 37.739369934171904 | -122.436142615306 | (37.7393699341719, -122.436142615306) | |||
| 58448 | 58448 | 187589 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6010129.52422 | 2091292.7817400002 | 37.7228633096683 | -122.40708515576901 | (37.7228633096683, -122.407085155769) | |||
| 61343 | 61343 | 129164 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5998679.83386 | 2113409.66692 | 37.7829434444333 | -122.448255995832 | (37.7829434444333, -122.448255995832) | |||
| 62478 | 62478 | 247003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 401 Valley St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 8ft | 6003236.004319999 | 2099186.05464 | 37.744148261529006 | -122.431477809352 | (37.744148261529, -122.431477809352) | |||
| 62797 | 62797 | 218228 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 8ft | 5993822.95601 | 2098779.1266900003 | 37.742492939687 | -122.463996274721 | (37.742492939687, -122.463996274721) | |||
| 64892 | 64892 | 176702 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 943 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005153.2895 | 2092105.0699599998 | 37.724813941005394 | -122.42434471783001 | (37.7248139410054, -122.42434471783) | |||
| 67231 | 67231 | 219354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5993538.524669999 | 2090540.93075 | 37.7198564884635 | -122.46438174842699 | (37.7198564884635, -122.464381748427) | |||
| 69473 | 69473 | 206953 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5998675.411230001 | 2093529.7240799998 | 37.728357786978705 | -122.44684034782301 | (37.7283577869787, -122.446840347823) | |||
| 69556 | 69556 | 219390 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 637 Detroit St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5999417.04235 | 2095185.5785400001 | 37.7329467162174 | -122.444395454511 | (37.7329467162174, -122.444395454511) | |||
| 73223 | 73223 | 118055 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 499 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 5984683.022969999 | 2112541.9282299997 | 37.7797507575988 | -122.496614381059 | (37.7797507575988, -122.496614381059) | |||
| 73569 | 73569 | 187587 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6010130.636940001 | 2091289.3744 | 37.7228540160906 | -122.40708106925501 | (37.7228540160906, -122.407081069255) | |||
| 73755 | 73755 | 187586 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6010130.12486 | 2091286.0001700001 | 37.7228447224995 | -122.407082601693 | (37.7228447224995, -122.407082601693) | |||
| 75066 | 75066 | 206939 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 33 Congo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6000057.2539 | 2093985.20597 | 37.7296872799222 | -122.44209595007901 | (37.7296872799222, -122.442095950079) | |||
| 75147 | 75147 | 129353 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6011391.406830001 | 2120329.06369 | 37.8026609588854 | -122.404766271855 | (37.8026609588854, -122.404766271855) | |||
| 129500 | 129500 | 129165 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5998683.20091 | 2113396.5400099996 | 37.7829075938537 | -122.448243401733 | (37.7829075938537, -122.448243401733) | |||
| 131124 | 131124 | 201347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012791.8631 | 2092596.6146799999 | 37.7265919996064 | -122.397973366875 | (37.7265919996064, -122.397973366875) | |||
| 132978 | 132978 | 190823 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 184 Hooper St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 8ft | 6012465.245630001 | 2107532.99928 | 37.7675859124819 | -122.400151016782 | (37.7675859124819, -122.400151016782) | |||
| 135032 | 135032 | 201351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6012866.15074 | 2092573.2448900002 | 37.7265319680523 | -122.397714917004 | (37.7265319680523, -122.397714917004) | |||
| 138094 | 138094 | 227011 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5527 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6001841.22055 | 2097455.3401 | 37.7393169730884 | -122.43617682821699 | (37.7393169730884, -122.436176828217) | |||
| 147711 | 147711 | 206936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6000038.50963 | 2094035.1117 | 37.7298232412405 | -122.44216433183998 | (37.7298232412405, -122.44216433184) | |||
| 148493 | 148493 | 226991 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 205 Beacon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 8ft | 6003107.38975 | 2097593.4063 | 37.7397679273523 | -122.43180883631399 | (37.7397679273523, -122.431808836314) | |||
| 148744 | 148744 | 226918 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 90 Fountain St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 8ft | 6000342.712069999 | 2101137.2305099997 | 37.749341314846504 | -122.44162214496299 | (37.7493413148465, -122.441622144963) | |||
| 148958 | 148958 | 226929 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2002 Castro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6002624.18248 | 2099711.02453 | 37.745555010767 | -122.43363086369601 | (37.745555010767, -122.433630863696) | |||
| 149516 | 149516 | 201350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012847.3383 | 2092578.90387 | 37.726546458834896 | -122.397780348078 | (37.7265464588349, -122.397780348078) | |||
| 150715 | 150715 | 206952 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5998679.10262 | 2093529.64727 | 37.7283577869579 | -122.44682758104601 | (37.7283577869579, -122.446827581046) | |||
| 152742 | 152742 | 206922 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 370 Monterey Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5999677.20212 | 2094726.1329599998 | 37.7317000265246 | -122.44346302659201 | (37.7317000265246, -122.443463026592) | |||
| 153447 | 153447 | 226934 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2103 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6002703.96911 | 2099400.25887 | 37.74470624770721 | -122.43333277171101 | (37.7447062477072, -122.433332771711) | |||
| 154484 | 154484 | 201353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012904.00238 | 2092563.8073 | 37.7265081621175 | -122.39758340285101 | (37.7265081621175, -122.397583402851) | |||
| 154652 | 154652 | 129351 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.67929 | 2120161.57643 | 37.8022029953207 | -122.404635873741 | (37.8022029953207, -122.404635873741) | |||
| 155307 | 155307 | 226911 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 733 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6001786.77721 | 2099686.1484 | 37.745439156509 | -122.436524696781 | (37.745439156509, -122.436524696781) | |||
| 157613 | 157613 | 187588 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Holyoke St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6010130.07309 | 2091290.7104099998 | 37.7228576529424 | -122.407083112501 | (37.7228576529424, -122.407083112501) | |||
| 157956 | 157956 | 226933 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2002 Castro St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6002625.85191 | 2099666.17927 | 37.745431970904605 | -122.433621886658 | (37.7454319709046, -122.433621886658) | |||
| 158379 | 158379 | 129167 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5998686.927759999 | 2113366.6087 | 37.7828256233423 | -122.44822835246 | (37.7828256233423, -122.44822835246) | |||
| 158790 | 158790 | 219417 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 209 Stillings Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5999391.40495 | 2095743.8261900002 | 37.734478070093104 | -122.444524196931 | (37.7344780700931, -122.444524196931) | |||
| 161682 | 161682 | 176703 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6004753.02081 | 2092064.15662 | 37.724678991421705 | -122.425725489235 | (37.7246789914217, -122.425725489235) | |||
| 163136 | 163136 | 129352 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6011406.69978 | 2120255.02893 | 37.8024585322873 | -122.404708135188 | (37.8024585322873, -122.404708135188) | |||
| 163499 | 163499 | 206938 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 33 Congo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6000056.57771 | 2093992.33298 | 37.7297068105026 | -122.442098799116 | (37.7297068105026, -122.442098799116) | |||
| 164900 | 164900 | 206954 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 200 Judson Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5998672.69937 | 2093530.16764 | 37.7283588499667 | -122.446849754714 | (37.7283588499667, -122.446849754714) | |||
| 166819 | 166819 | 176630 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 271 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6004066.09018 | 2089571.2619999999 | 37.7177952090644 | -122.427922568075 | (37.7177952090644, -122.427922568075) | |||
| 166848 | 166848 | 201346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012773.9855 | 2092601.68911 | 37.7266049372574 | -122.39803552533199 | (37.7266049372574, -122.398035525332) | |||
| 168356 | 168356 | 201352 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012884.58431 | 2092567.5936099999 | 37.7265174772786 | -122.397650796243 | (37.7265174772786, -122.397650796243) | |||
| 169609 | 169609 | 190818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Helena St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6011192.32656 | 2096261.9333400002 | 37.7365669811865 | -122.403760731784 | (37.7365669811865, -122.403760731784) | |||
| 169741 | 169741 | 218229 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5993803.00449 | 2098718.65979 | 37.7423257629199 | -122.464060872135 | (37.7423257629199, -122.464060872135) | |||
| 170335 | 170335 | 206934 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 105 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 8ft | 6000030.26557 | 2094035.00933 | 37.7298224903164 | -122.442192825064 | (37.7298224903164, -122.442192825064) | |||
| 173086 | 173086 | 226928 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2002 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6002624.98668 | 2099722.15148 | 37.7455856083972 | -122.43362887797701 | (37.7455856083972, -122.433628877977) | |||
| 173615 | 173615 | 219391 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 637 Detroit St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5999416.30256 | 2095163.08339 | 37.7328849076096 | -122.44439639607799 | (37.7328849076096, -122.444396396078) | |||
| 175687 | 175687 | 176609 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1659 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5998355.24802 | 2088872.09815 | 37.7155507314505 | -122.447612021886 | (37.7155507314505, -122.447612021886) | |||
| 175803 | 175803 | 129354 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 52 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6011388.89614 | 2120338.61388 | 37.8026870410416 | -122.40477563290199 | (37.8026870410416, -122.404775632902) | |||
| 177114 | 177114 | 206923 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 370 Monterey Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5999650.953509999 | 2094728.03216 | 37.731703744317 | -122.443553909399 | (37.731703744317, -122.443553909399) | |||
| 177390 | 177390 | 201348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012808.60563 | 2092591.5632900002 | 37.7265790619707 | -122.397915133977 | (37.7265790619707, -122.397915133977) | |||
| 178055 | 178055 | 118281 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3245 Cabrillo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5985519.75315 | 2110399.45496 | 37.7739171254243 | -122.493561899449 | (37.7739171254243, -122.493561899449) | |||
| 178346 | 178346 | 176831 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1567 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 8ft | 5998676.7168 | 2089183.1568 | 37.7164231943611 | -122.446523251341 | (37.7164231943611, -122.446523251341) | |||
| 178370 | 178370 | 118280 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3245 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5985532.1252 | 2110400.01193 | 37.7739193784435 | -122.493519144142 | (37.7739193784435, -122.493519144142) | |||
| 182841 | 182841 | 206942 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 Edna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5998789.86378 | 2094159.83561 | 37.7300944632801 | -122.446489995331 | (37.7300944632801, -122.446489995331) | |||
| 184130 | 184130 | 219353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993539.38524 | 2090524.66713 | 37.7198118820929 | -122.46437759357201 | (37.7198118820929, -122.464377593572) | |||
| 186117 | 186117 | 218231 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993773.53157 | 2098636.1244900003 | 37.7420974430581 | -122.464156789307 | (37.7420974430581, -122.464156789307) | |||
| 187898 | 187898 | 219347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992971.18683 | 2090558.0944400001 | 37.7198708965006 | -122.46634406733999 | (37.7198708965006, -122.46634406734) | |||
| 188348 | 188348 | 218225 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 5993843.55646 | 2098914.16079 | 37.7428648966005 | -122.463934844718 | (37.7428648966005, -122.463934844718) | |||
| 188677 | 188677 | 218227 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993831.45355 | 2098825.44748 | 37.742620614658 | -122.463970254628 | (37.742620614658, -122.463970254628) | |||
| 188774 | 188774 | 218226 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5993838.37632 | 2098869.25868 | 37.7427413081634 | -122.46394949738199 | (37.7427413081634, -122.463949497382) | |||
| 188976 | 188976 | 219246 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 628 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5999461.66823 | 2095170.54845 | 37.732907993207604 | -122.44424009212 | (37.7329079932076, -122.44424009212) | |||
| 188999 | 188999 | 129349 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011426.64663 | 2120143.89656 | 37.8021545047788 | -122.40463128093398 | (37.8021545047788, -122.404631280934) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 42535 | 42535 | 250173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5997239.18442 | 2110648.2538799997 | 37.7752788616692 | -122.453040622039 | (37.7752788616692, -122.453040622039) | |||
| 43211 | 43211 | 118078 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7150 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5984743.66491 | 2112532.51161 | 37.7797284549829 | -122.496403902204 | (37.7797284549829, -122.496403902204) |
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");