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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84330 | 84330 | 111073 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1450 IRVING ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Fire Dept 11 | 3x3 | 5991201.0 | 2106639.0 | 37.7639226370674 | -122.473635352969 | (37.7639226370674, -122.473635352969) | ||||
173591 | 173591 | 219330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991259.76279 | 2090425.50198 | 37.7194079318084 | -122.472250145444 | (37.7194079318084, -122.472250145444) | |||
188529 | 188529 | 219331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991262.34027 | 2090458.54246 | 37.7194988020073 | -122.472243643342 | (37.7194988020073, -122.472243643342) | |||
24248 | 24248 | 219332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.719555381949206 | -122.47224364333 | (37.7195553819492, -122.47224364333) | |||
145895 | 145895 | 111072 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1450 IRVING ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Fire Dept 11 | 3x3 | 5991277.0 | 2106586.0 | 37.7637815143869 | -122.473368628437 | (37.7637815143869, -122.473368628437) | ||||
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) | |||
52693 | 52693 | 219257 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1948 16th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 1ft | 5991302.37835 | 2102159.67648 | 37.7516294680371 | -122.47295805847 | (37.7516294680371, -122.47295805847) | |||
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) | |||
157567 | 157567 | 122301 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5991504.38073 | 2111297.95565 | 37.77673243758429 | -122.47292581513099 | (37.7767324375843, -122.472925815131) | |||
151023 | 151023 | 122300 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5991520.86035 | 2111297.3922599996 | 37.7767318447096 | -122.47286876669901 | (37.7767318447096, -122.472868766699) | |||
53699 | 53699 | 122299 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5991529.77112 | 2111298.06861 | 37.7767342176341 | -122.472837991331 | (37.7767342176341, -122.472837991331) | |||
179668 | 179668 | 122298 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5991539.76663 | 2111298.7220900003 | 37.7767365905508 | -122.472803461891 | (37.7767365905508, -122.472803461891) | |||
178759 | 178759 | 122297 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991554.96298 | 2111299.05 | 37.7767383705979 | -122.472750917629 | (37.7767383705979, -122.472750917629) | |||
82512 | 82512 | 176641 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 89 Belle Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5991622.07464 | 2086489.1085299999 | 37.708620512601705 | -122.47071121118 | (37.7086205126017, -122.47071121118) | |||
96170 | 96170 | 113366 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 799X ORTEGA WAY | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5991631.0 | 2102457.0 | 37.7524648607614 | -122.47184332039 | (37.7524648607614, -122.47184332039) | ||||
67530 | 67530 | 219258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1383 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5991755.50234 | 2106034.38103 | 37.7622946118155 | -122.471673449788 | (37.7622946118155, -122.471673449788) | |||
52597 | 52597 | 219259 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1383 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5991755.795469999 | 2106024.31497 | 37.762266990044296 | -122.47167170238501 | (37.7622669900443, -122.471671702385) | |||
149343 | 149343 | 176640 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Payson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5991761.59345 | 2087760.80597 | 37.7121203547524 | -122.47032156819401 | (37.7121203547524, -122.470321568194) | |||
52562 | 52562 | 219270 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1220 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5991777.52525 | 2107074.159 | 37.7651508397576 | -122.47167305767701 | (37.7651508397576, -122.471673057677) | |||
133076 | 133076 | 219260 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1474 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991838.53608 | 2105394.78009 | 37.76054324059329 | -122.47133966548999 | (37.7605432405933, -122.47133966549) | |||
155438 | 155438 | 219261 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1474 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5991838.80839 | 2105407.70573 | 37.7605787467375 | -122.47133966550699 | (37.7605787467375, -122.471339665507) | |||
175110 | 175110 | 219346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5991911.85592 | 2089125.7971700002 | 37.7158769767191 | -122.46990154251999 | (37.7158769767191, -122.46990154252) | |||
75947 | 75947 | 219345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5991911.8899300005 | 2089150.8332900002 | 37.7159457217874 | -122.469903246754 | (37.7159457217874, -122.469903246754) | |||
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) | |||
65469 | 65469 | 219343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 295 Byxbee St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5991924.98252 | 2090428.4017299998 | 37.7194543701096 | -122.469950959395 | (37.7194543701096, -122.469950959395) | |||
166707 | 166707 | 219342 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 295 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5991925.44739 | 2090450.4823200002 | 37.719515024881794 | -122.469950959366 | (37.7195150248818, -122.469950959366) | |||
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) | |||
72833 | 72833 | 124057 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991955.61428 | 2111026.67231 | 37.776013680206496 | -122.47134510811001 | (37.7760136802065, -122.47134510811) | |||
38700 | 38700 | 64762 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1988 12:00:00 AM | 8 | Permit Number 25739 | 5991956.18292 | 2111010.7557900003 | 37.7759700106605 | -122.471341981082 | (37.7759700106605, -122.471341981082) | ||
72136 | 72136 | 219271 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1251 Funston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5992034.18905 | 2106913.1849700003 | 37.7647236941726 | -122.47077360162399 | (37.7647236941726, -122.470773601624) | |||
65137 | 65137 | 219272 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1251 Funston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5992034.771819999 | 2106897.54669 | 37.764680789314795 | -122.47077044680401 | (37.7646807893148, -122.470770446804) | |||
64730 | 64730 | 219273 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1251 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5992034.823059999 | 2106882.6464 | 37.76463988004279 | -122.470769184151 | (37.7646398800428, -122.470769184151) | |||
45474 | 45474 | 219274 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1251 Funston Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992036.15334 | 2106859.17905 | 37.7645755218673 | -122.470762873609 | (37.7645755218673, -122.470762873609) | |||
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) | |||
181201 | 181201 | 219362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992423.9143900005 | 2088481.1554 | 37.7141365322476 | -122.468084780709 | (37.7141365322476, -122.468084780709) | |||
157967 | 157967 | 123104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 446 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5992530.91894 | 2112401.0043200003 | 37.779820485509504 | -122.469455059019 | (37.7798204855095, -122.469455059019) | |||
110958 | 110958 | 108680 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 240 SANTA ANA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992606.9 | 2095181.7 | 37.73254515275271 | -122.46793939448999 | (37.7325451527527, -122.46793939449) | |||||
85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
92708 | 92708 | 85104 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
139234 | 139234 | 93020 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | Tree 3 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
108014 | 108014 | 113985 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 109 MADRONE AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5992778.0 | 2098364.0 | 37.74129282931111 | -122.46757920887899 | (37.7412928293111, -122.467579208879) | ||||
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) | |||
47837 | 47837 | 219366 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5992883.56621 | 2099683.9790000003 | 37.7449232514072 | -122.46731015773999 | (37.7449232514072, -122.46731015774) | |||
175801 | 175801 | 219367 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992906.92509 | 2099685.21793 | 37.74492800164 | -122.46722947778 | (37.74492800164, -122.46722947778) | |||
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) | |||
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) | |||
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) | |||
130769 | 130769 | 176644 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992981.09091 | 2087231.27267 | 37.7107368152211 | -122.466068210177 | (37.7107368152211, -122.466068210177) | |||
153643 | 153643 | 176643 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992994.85836 | 2087232.28697 | 37.7107403945151 | -122.46602070080401 | (37.7107403945151, -122.466020700804) | |||
60393 | 60393 | 176642 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993005.954030001 | 2087230.75027 | 37.7107368152174 | -122.465982240383 | (37.7107368152174, -122.465982240383) | |||
44302 | 44302 | 219351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993263.35325 | 2089534.6361099998 | 37.7170775806463 | -122.46525985636002 | (37.7170775806463, -122.46525985636) | |||
151929 | 151929 | 219350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5993263.513069999 | 2089526.9590200002 | 37.717056510421 | -122.465258746617 | (37.717056510421, -122.465258746617) | |||
49144 | 49144 | 219352 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5993266.488919999 | 2089531.0532200001 | 37.71706792372179 | -122.465248757836 | (37.7170679237218, -122.465248757836) | |||
3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) | ||
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) | |||
175407 | 175407 | 219276 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1607 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993358.66826 | 2104530.96639 | 37.75825925039079 | -122.466019495715 | (37.7582592503908, -122.466019495715) | |||
40696 | 40696 | 219275 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1651 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5993370.433230001 | 2104236.7588299997 | 37.7574521115395 | -122.465957429918 | (37.7574521115395, -122.465957429918) | |||
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) | |||
57377 | 57377 | 219355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5993537.41459 | 2090564.39449 | 37.719920850243 | -122.464387288237 | (37.719920850243, -122.464387288237) | |||
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) | |||
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) | |||
169105 | 169105 | 219262 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1827 08th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5993714.08956 | 2103051.3522200002 | 37.754217109838 | -122.464682861249 | (37.754217109838, -122.464682861249) | |||
179977 | 179977 | 219263 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1851 08th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993725.67794 | 2102905.85054 | 37.7538182676993 | -122.464632221316 | (37.7538182676993, -122.464632221316) | |||
92378 | 92378 | 219264 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1851 08th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5993726.42709 | 2102887.88763 | 37.7537689893516 | -122.464628326342 | (37.7537689893516, -122.464628326342) | |||
68468 | 68468 | 219360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5993732.0948 | 2089263.8820200001 | 37.7163611752992 | -122.46362001454901 | (37.7163611752992, -122.463620014549) | |||
180880 | 180880 | 219359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5993732.18416 | 2089268.1403400002 | 37.7163728727759 | -122.46362001455601 | (37.7163728727759, -122.463620014556) | |||
48887 | 48887 | 219358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5993732.273519999 | 2089272.39867 | 37.71638457028 | -122.463620014563 | (37.71638457028, -122.463620014563) | |||
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) | |||
181470 | 181470 | 219356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5993733.55118 | 2089282.3121 | 37.7164118638057 | -122.46361631744699 | (37.7164118638057, -122.463616317447) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
18666 | 18666 | 19313 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 21 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5993901.63447 | 2089816.98545 | 37.7178896324771 | -122.463074115289 | (37.7178896324771, -122.463074115289) | |||
59244 | 59244 | 71583 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5993925.4185 | 2086705.1573599998 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | ||
46662 | 46662 | 219339 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5993976.06053 | 2087910.0728799999 | 37.712657991947 | -122.46267860514999 | (37.712657991947, -122.46267860515) | |||
25117 | 25117 | 219340 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5993976.2548 | 2087899.9330400003 | 37.7126301615391 | -122.462677198595 | (37.7126301615391, -122.462677198595) | |||
130317 | 130317 | 219338 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5993976.25604 | 2087919.3939099999 | 37.7126835965453 | -122.462678605151 | (37.7126835965453, -122.462678605151) | |||
52462 | 52462 | 219337 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 5993976.47705 | 2087929.93053 | 37.712712540334 | -122.462678605144 | (37.712712540334, -122.462678605144) | |||
167871 | 167871 | 219336 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5993977.06233 | 2087938.43241 | 37.7127359181885 | -122.462677198601 | (37.7127359181885, -122.462677198601) | |||
155443 | 155443 | 219333 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 159 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5994132.08627 | 2090976.61214 | 37.721086961572496 | -122.46236161210699 | (37.7210869615725, -122.462361612107) | |||
175259 | 175259 | 218146 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Ashton Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5994143.80732 | 2090112.0989599999 | 37.7187138908262 | -122.46225842838601 | (37.7187138908262, -122.462258428386) | ||||
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) | ||||
40707 | 40707 | 219318 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5994210.25958 | 2091948.5213400002 | 37.7237600911452 | -122.46216184119 | (37.7237600911452, -122.46216184119) | |||
40364 | 40364 | 219319 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Ashton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994210.91317 | 2091964.42992 | 37.7238038098934 | -122.462160735039 | (37.7238038098934, -122.462160735039) | |||
136321 | 136321 | 124036 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 401 Lake St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5994232.612480001 | 2114839.72684 | 37.7866147536829 | -122.46374525122101 | (37.7866147536829, -122.463745251221) | |||
73904 | 73904 | 219369 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 55 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994238.9129800005 | 2101823.0990400002 | 37.750874882880396 | -122.46277880671002 | (37.7508748828804, -122.46277880671) | |||
72856 | 72856 | 219335 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 261 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5994423.037830001 | 2089616.126 | 37.7173681417119 | -122.461257314797 | (37.7173681417119, -122.461257314797) | |||
182427 | 182427 | 219370 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994548.062390001 | 2100959.98911 | 37.748522802305004 | -122.461647175376 | (37.748522802305, -122.461647175376) | |||
156857 | 156857 | 176639 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994551.36715 | 2086753.98013 | 37.7095167499667 | -122.460606453835 | (37.7095167499667, -122.460606453835) | |||
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) | |||
42674 | 42674 | 219277 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 70 Marcela Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994666.162690001 | 2100675.76794 | 37.74774920006679 | -122.46121818977501 | (37.7477492000668, -122.461218189775) | |||
26608 | 26608 | 219368 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Elmwood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994978.25407 | 2092702.73333 | 37.72587516529521 | -122.45956163048099 | (37.7258751652952, -122.459561630481) | |||
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) | |||
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) | |||
147745 | 147745 | 219323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1090 Capitol Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5995079.72755 | 2091168.59616 | 37.7216686268896 | -122.459099809715 | (37.7216686268896, -122.459099809715) | |||
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) |
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");