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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100221 | 100221 | 5821 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 11566 | 11566 | 16410 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1186X Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001066.26402 | 2087197.59203 | 37.7111074743937 | -122.43812166787501 | (37.7111074743937, -122.438121667875) | |||
| 160789 | 160789 | 226993 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 61 Everson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 4ft | 6003460.61917 | 2097097.8957599998 | 37.738427386212 | -122.430552171371 | (37.738427386212, -122.430552171371) | |||
| 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) | |||
| 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) | |||
| 71892 | 71892 | 129105 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2636 Union St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 3ft | 6000388.79124 | 2118226.33242 | 37.796266303397104 | -122.442689690586 | (37.7962663033971, -122.442689690586) | |||
| 172345 | 172345 | 219378 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Martha Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 3ft | 6000398.21075 | 2095772.5501 | 37.734614336269395 | -122.44104540612801 | (37.7346143362694, -122.441045406128) | |||
| 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) | |||
| 161516 | 161516 | 219361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 606 Shields St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 4ft | 5992405.16075 | 2089868.2609299999 | 37.717944105311 | -122.468250447523 | (37.717944105311, -122.468250447523) | |||
| 131660 | 131660 | 247557 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 2ft | 6000027.54626 | 2108348.5362299997 | 37.769123823324 | -122.443229861189 | (37.769123823324, -122.443229861189) | |||
| 11045 | 11045 | 27100 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 675 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005860.0759 | 2093589.7540900002 | 37.728930444682206 | -122.422006859139 | (37.7289304446822, -122.422006859139) | |||
| 102075 | 102075 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 654 Precita Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | |||||
| 104233 | 104233 | 106802 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 BRYANT ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 30 | 3x2 | 6009455.7 | 2106195.7 | 37.763745730245795 | -122.41046624869301 | (37.7637457302458, -122.410466248693) | |||
| 109984 | 109984 | 116585 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2100 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6011843.0 | 2103815.0 | 37.757342401329105 | -122.402041888427 | (37.7573424013291, -122.402041888427) | |||
| 132065 | 132065 | 226896 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1243 Valencia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 6006432.373930001 | 2102561.6161 | 37.7535974274886 | -122.420665025691 | (37.7535974274886, -122.420665025691) | |||
| 172615 | 172615 | 247554 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 2ft | 6000050.05446 | 2108365.18828 | 37.769170829105 | -122.44315320297501 | (37.769170829105, -122.443153202975) | |||
| 175226 | 175226 | 226981 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 139 Farnum St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 4ft | 6002455.82036 | 2097307.40869 | 37.7389456870897 | -122.434041245917 | (37.7389456870897, -122.434041245917) | |||
| 162955 | 162955 | 206961 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 311 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 10ft | 5999953.1490400005 | 2094930.4476 | 37.7322767599675 | -122.442523689227 | (37.7322767599675, -122.442523689227) | |||
| 93107 | 93107 | 116295 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699X DETROIT ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 3x20 | 5999400.0 | 2095202.0 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | |||
| 133626 | 133626 | 176731 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 421 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 5ft | 6007786.78425 | 2091855.6543599998 | 37.724277455832706 | -122.415223365581 | (37.7242774558327, -122.415223365581) | |||
| 110428 | 110428 | 12623 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 825 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 5992882.168 | 2114794.01241 | 37.7864113245051 | -122.468414093066 | (37.7864113245051, -122.468414093066) | |||
| 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) | |||
| 173921 | 173921 | 219301 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 594 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 4ft | 5996849.44073 | 2094145.99272 | 37.729945430323895 | -122.453197247977 | (37.7299454303239, -122.453197247977) | |||
| 175383 | 175383 | 226978 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Thor Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 2ft | 6002261.072480001 | 2096075.82305 | 37.735552982986604 | -122.43462655258499 | (37.7355529829866, -122.434626552585) | |||
| 11331 | 11331 | 1100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2328 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999423.31284 | 2089282.1433599999 | 37.71673760544579 | -122.44394976577298 | (37.7167376054458, -122.443949765773) | |||
| 45160 | 45160 | 226880 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 Bryant St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 2ft | 6009467.77548 | 2106133.6543799997 | 37.7635760441104 | -122.41042010180901 | (37.7635760441104, -122.410420101809) | |||
| 52652 | 52652 | 226879 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 25 | Width 2ft | 6009465.88714 | 2106164.02417 | 37.7636593267514 | -122.41042877757201 | (37.7636593267514, -122.410428777572) | |||
| 75317 | 75317 | 34709 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 727 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 25 | Permit Number 38365 | 5981632.43118 | 2110780.81019 | 37.7747360459971 | -122.50703684968501 | (37.7747360459971, -122.507036849685) | |
| 104644 | 104644 | 106801 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 BRYANT ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 25 | 2x3 | 6009455.7 | 2106195.7 | 37.763745730245795 | -122.41046624869301 | (37.7637457302458, -122.410466248693) | |||
| 115088 | 115088 | 117438 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 230 AMBER DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 25 | 3X3 | 5999593.0 | 2099199.0 | 37.7439766577846 | -122.444075405191 | (37.7439766577846, -122.444075405191) | |||
| 141152 | 141152 | 116301 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699X DETROIT ST | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 3x20 | 5999400.0 | 2095202.0 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | |||
| 149616 | 149616 | 117816 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 6ft | 5983419.54459 | 2111079.81342 | 37.775662110061 | -122.50087707664801 | (37.775662110061, -122.500877076648) | |||
| 155003 | 155003 | 250175 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5997242.30788 | 2110631.32988 | 37.7752325717698 | -122.453028595406 | (37.7752325717698, -122.453028595406) | |||
| 186387 | 186387 | 219389 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 637 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 5ft | 5999415.32076 | 2095207.5821200002 | 37.7330070346513 | -122.444402987233 | (37.7330070346513, -122.444402987233) | |||
| 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) | |||
| 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) | |||
| 150775 | 150775 | 219371 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 174 Stillings Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 5999599.81898 | 2095796.21538 | 37.734633808405796 | -122.44380740578801 | (37.7346338084058, -122.443807405788) | |||
| 152185 | 152185 | 190800 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2098 20th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 7ft | 6011906.2795400005 | 2104697.87951 | 37.7597701249107 | -122.401885102143 | (37.7597701249107, -122.401885102143) | |||
| 166248 | 166248 | 250168 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 7ft | 5997236.19535 | 2110687.93342 | 37.775387640062796 | -122.45305382679399 | (37.7753876400628, -122.453053826794) | |||
| 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) | |||
| 132151 | 132151 | 176730 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1533 Burrows St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6006825.48206 | 2092127.1271099998 | 37.724968788961206 | -122.41856569774299 | (37.7249687889612, -122.418565697743) | |||
| 150469 | 150469 | 190799 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2098 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 7ft | 6011915.50815 | 2104697.98802 | 37.7597709378887 | -122.401853192367 | (37.7597709378887, -122.401853192367) | |||
| 184505 | 184505 | 249764 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 48 | : 4 | Tree 1 | Private 1 | 23 | Width 1ft | 6000246.04856 | 2117175.67215 | 37.7933733291772 | -122.44310811365101 | (37.7933733291772, -122.443108113651) | |||
| 23498 | 23498 | 176772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 6007351.78047 | 2093548.13266 | 37.72890017978 | -122.41684696742901 | (37.72890017978, -122.416846967429) | |||
| 66823 | 66823 | 87246 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 236323 Larkin St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 22 | 3x3 | Permit Number 50274 | 6006702.92902 | 2119345.02683 | 37.7996958743116 | -122.420920894495 | (37.7996958743116, -122.420920894495) | |
| 147420 | 147420 | 176672 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Colonial Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6000356.65136 | 2093592.6446 | 37.7286264549295 | -122.441032751759 | (37.7286264549295, -122.441032751759) | |||
| 155081 | 155081 | 176765 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Tulane St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 1ft | 6007434.2081 | 2093761.04246 | 37.729489420077705 | -122.416577084482 | (37.7294894200777, -122.416577084482) | |||
| 185042 | 185042 | 219409 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 5999419.94343 | 2095736.70644 | 37.7344601493043 | -122.44442501881201 | (37.7344601493043, -122.444425018812) | |||
| 185925 | 185925 | 226904 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1334 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 6001345.2019 | 2099797.64766 | 37.7457202045352 | -122.438059576001 | (37.7457202045352, -122.438059576001) | |||
| 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) | |||
| 4549 | 4549 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001140.61217 | 2096125.6115299999 | 37.735626018710896 | -122.438503967885 | (37.7356260187109, -122.438503967885) | |||
| 41410 | 41410 | 219410 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 5ft | 5999420.88677 | 2095723.69435 | 37.734424474994995 | -122.444420822556 | (37.734424474995, -122.444420822556) | |||
| 51537 | 51537 | 190761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 285 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 6013218.562419999 | 2105774.14575 | 37.762798465109995 | -122.397422010521 | (37.76279846511, -122.397422010521) | |||
| 51908 | 51908 | 219403 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 434 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 5998524.48424 | 2095282.7989 | 37.733162693800104 | -122.44748824191002 | (37.7331626938001, -122.44748824191) | |||
| 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) | ||||
| 59420 | 59420 | 249634 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 5997294.55506 | 2111271.9763700003 | 37.776994614336 | -122.452894113492 | (37.776994614336, -122.452894113492) | |||
| 65449 | 65449 | 226944 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001147.55227 | 2096122.75745 | 37.735618576845205 | -122.43847976892401 | (37.7356185768452, -122.438479768924) | |||
| 66666 | 66666 | 227014 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5557 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6001726.69776 | 2097242.18492 | 37.7387251913123 | -122.436557543618 | (37.7387251913123, -122.436557543618) | |||
| 130965 | 130965 | 249623 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 7ft | 5997659.54255 | 2111324.05825 | 37.7771585265736 | -122.451635273045 | (37.7771585265736, -122.451635273045) | |||
| 153438 | 153438 | 129309 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1148 Broadway | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 5ft | 6008108.57977 | 2118262.33824 | 37.796802213007105 | -122.41598010012699 | (37.7968022130071, -122.415980100127) | |||
| 174994 | 174994 | 249763 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 47 | : 4 | Tree 1 | Private 1 | 21 | Width 1ft | 6000244.96871 | 2117178.7308099996 | 37.7933816658824 | -122.443112069768 | (37.7933816658824, -122.443112069768) | |||
| 186803 | 186803 | 226887 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1266 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5997536.57649 | 2105194.59271 | 37.7603215415281 | -122.451618405363 | (37.7603215415281, -122.451618405363) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 40477 | 40477 | 219411 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 5999420.52154 | 2095713.4289400002 | 37.7343962677584 | -122.444421347772 | (37.7343962677584, -122.444421347772) | |||
| 55652 | 55652 | 250174 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997242.00203 | 2110645.63605 | 37.7752718352644 | -122.45303068632299 | (37.7752718352644, -122.453030686323) | |||
| 70038 | 70038 | 249762 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 46 | : 4 | Tree 1 | Private 1 | 20 | Width 1ft | 6000243.900669999 | 2117182.35848 | 37.7933915656126 | -122.443116025908 | (37.7933915656126, -122.443116025908) | |||
| 77087 | 77087 | 219288 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6000650.92821 | 2094383.0916900001 | 37.730813597150394 | -122.44007207888399 | (37.7308135971504, -122.440072078884) | |||
| 159174 | 159174 | 124497 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2700 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 5996600.75625 | 2111319.20262 | 37.7770845024867 | -122.45529757783001 | (37.7770845024867, -122.45529757783) | |||
| 159319 | 159319 | 250161 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997228.87455 | 2110733.66678 | 37.7755127924135 | -122.45308245310301 | (37.7755127924135, -122.453082453103) | |||
| 167004 | 167004 | 219256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1948 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 5991302.1918 | 2102132.80922 | 37.751555686753704 | -122.47295674457199 | (37.7515556867537, -122.472956744572) | |||
| 172366 | 172366 | 219268 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1330 Kirkham St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 5990642.8904800005 | 2105223.71561 | 37.760004306576704 | -122.47546232413299 | (37.7600043065767, -122.475462324133) | |||
| 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) | |||
| 188311 | 188311 | 248142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 280 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6009850.53205 | 2099420.75509 | 37.7451653713952 | -122.40862267810499 | (37.7451653713952, -122.408622678105) | |||
| 44 | 44 | 226925 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 2 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 19 | Width 4ft | 6002565.841680001 | 2099976.66752 | 37.746281093695 | -122.433851580699 | (37.746281093695, -122.433851580699) | |||
| 24188 | 24188 | 247556 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 2ft | 6000035.32206 | 2108353.94379 | 37.7691391145131 | -122.443203353661 | (37.7691391145131, -122.443203353661) | |||
| 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) | |||
| 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) | |||
| 40060 | 40060 | 226881 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 14 Liberty St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 1ft | 6006207.80682 | 2104080.83219 | 37.757756184028395 | -122.42154951882 | (37.7577561840284, -122.42154951882) | |||
| 43916 | 43916 | 249625 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 7ft | 5997639.79528 | 2111322.31201 | 37.777152600940106 | -122.451703458765 | (37.7771526009401, -122.451703458765) | |||
| 132689 | 132689 | 176620 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 114 Desmond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010562.66148 | 2086802.426 | 37.710557939180795 | -122.405271825739 | (37.7105579391808, -122.405271825739) | |||
| 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) | |||
| 157403 | 157403 | 226885 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1577 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997889.74449 | 2105168.82757 | 37.760271015821296 | -122.450395110664 | (37.7602710158213, -122.450395110664) | |||
| 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) | |||
| 174657 | 174657 | 219412 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 5999419.9485 | 2095700.4483599998 | 37.7343605934475 | -122.44442239638599 | (37.7343605934475, -122.444422396386) | |||
| 175305 | 175305 | 129291 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1351 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 7ft | 6005939.01276 | 2119972.76765 | 37.8013764014559 | -122.423608983393 | (37.8013764014559, -122.423608983393) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 40063 | 40063 | 190763 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1901 Quint St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6012404.6522 | 2095210.16355 | 37.7337466919524 | -122.39949535794202 | (37.7337466919524, -122.399495357942) | |||
| 45751 | 45751 | 248141 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 274 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6009875.37752 | 2099433.39728 | 37.745201475562794 | -122.408537657996 | (37.7452014755628, -122.408537657996) | |||
| 47377 | 47377 | 226969 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 220 Swiss Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6001229.98666 | 2096685.54964 | 37.7371685619871 | -122.438235067016 | (37.7371685619871, -122.438235067016) | |||
| 52721 | 52721 | 176767 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Tulane St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 1ft | 6007451.76214 | 2093763.21373 | 37.7294963691419 | -122.416516552018 | (37.7294963691419, -122.416516552018) | |||
| 56126 | 56126 | 123951 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 394 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5993436.16113 | 2112921.30545 | 37.7813013648658 | -122.46636127827101 | (37.7813013648658, -122.466361278271) |
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");