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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49 | 49 | 251186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3042 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002010.0 | 2118654.0 | 37.7975328515761 | -122.437110618013 | (37.7975328515761, -122.437110618013) | ||||
50099 | 50099 | 108350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
77664 | 77664 | 96104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
80181 | 80181 | 109321 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3699 MARKET ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000396.5 | 2103077.7 | 37.7546724390671 | -122.441575379015 | (37.7546724390671, -122.441575379015) | ||||
80360 | 80360 | 110171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
80890 | 80890 | 108255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
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) | ||||
89053 | 89053 | 102912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 84 Vienna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004823.0 | 2092922.0 | 37.7270383945734 | -122.42554460371599 | (37.7270383945734, -122.425544603716) | |||||
92163 | 92163 | 108259 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
94535 | 94535 | 108345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
94629 | 94629 | 110173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
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) | ||||
97359 | 97359 | 119672 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2090x 20th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6011896.0 | 2104722.0 | 37.7598357807336 | -122.40192234981501 | (37.7598357807336, -122.401922349815) | |||||
98097 | 98097 | 108256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
99148 | 99148 | 108346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
99222 | 99222 | 108353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
103370 | 103370 | 96098 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1999 Bryant St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009553.0 | 2105475.0 | 37.7617723065941 | -122.41007883348301 | (37.7617723065941, -122.410078833483) | |||
104404 | 104404 | 106685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Yukon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 772768 | 6000197.4 | 2104288.0 | 37.757984281634 | -122.44235080136299 | (37.757984281634, -122.442350801363) | |||||
105668 | 105668 | 108258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
107819 | 107819 | 114704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 524 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996948.70097149 | 2093858.06219815 | 37.729160530354 | -122.452833321223 | (37.729160530354, -122.452833321223) | |||||
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) | ||||
108530 | 108530 | 110402 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
112041 | 112041 | 121326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 25th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5987896.0 | 2115988.0 | 37.7894004070969 | -122.48575242171101 | (37.7894004070969, -122.485752421711) | ||||
112717 | 112717 | 108257 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
115013 | 115013 | 96105 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
115819 | 115819 | 110406 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
119866 | 119866 | 96106 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
120525 | 120525 | 110172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
121707 | 121707 | 108254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
122281 | 122281 | 96103 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
122726 | 122726 | 110174 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
124192 | 124192 | 108351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
124212 | 124212 | 108347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
127293 | 127293 | 110175 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
129230 | 129230 | 108349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
144668 | 144668 | 110414 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
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) | ||||
23567 | 23567 | 137685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 720 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000552.856000001 | 2111474.7278 | 37.7777374972355 | -122.441637228704 | (37.7777374972355, -122.441637228704) | |||
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) | ||||
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) | ||||
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) | ||||
43932 | 43932 | 206959 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998473.1983199995 | 2095010.9948599997 | 37.7324134532998 | -122.44764599109399 | (37.7324134532998, -122.447645991094) | ||||
74501 | 74501 | 129333 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007566.1830400005 | 2119864.34532 | 37.8011704135381 | -122.417970546228 | (37.8011704135381, -122.417970546228) | ||||
151034 | 151034 | 249495 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1801 California St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005713.466659999 | 2115852.8179900004 | 37.7900513270512 | -122.42409631339399 | (37.7900513270512, -122.424096313394) | |||
160401 | 160401 | 227015 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002114.09151 | 2096793.82616 | 37.7375161085743 | -122.43518606040399 | (37.7375161085743, -122.435186060404) | |||
170842 | 170842 | 129329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007555.7240699995 | 2119861.47467 | 37.8011619428155 | -122.41800653528601 | (37.8011619428155, -122.418006535286) | ||||
171563 | 171563 | 129328 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6007553.95221 | 2119861.40094 | 37.8011616406485 | -122.418012661478 | (37.8011616406485, -122.418012661478) | ||||
23881 | 23881 | 129298 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1287 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6006767.5192599995 | 2119403.73147 | 37.799860702966 | -122.420701557924 | (37.799860702966, -122.420701557924) | |||
36594 | 36594 | 129227 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6000607.86653 | 2117501.04945 | 37.794287353335704 | -122.441879565091 | (37.7942873533357, -122.441879565091) | |||
39701 | 39701 | 129113 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007329.70066 | 2119282.266 | 37.7995588581063 | -122.418747576633 | (37.7995588581063, -122.418747576633) | ||||
41224 | 41224 | 227003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5411 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6002088.6819 | 2098074.75757 | 37.741031805779 | -122.435365514706 | (37.741031805779, -122.435365514706) | |||
47827 | 47827 | 176859 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002706.29177 | 2087440.6711400002 | 37.7118680526473 | -122.432470687896 | (37.7118680526473, -122.432470687896) | |||
51153 | 51153 | 176836 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5999285.39372 | 2089701.94289 | 37.7178824109155 | -122.444456635388 | (37.7178824109155, -122.444456635388) | |||
56530 | 56530 | 129361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 555 California St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6011684.8742 | 2116686.03693 | 37.7926744848808 | -122.403494267154 | (37.7926744848808, -122.403494267154) | |||
60902 | 60902 | 129330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007557.40785 | 2119862.6523599997 | 37.8011652712212 | -122.41800079219601 | (37.8011652712212, -122.418000792196) | ||||
61753 | 61753 | 176856 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002702.07598 | 2087433.5886 | 37.7118483664744 | -122.43248475327499 | (37.7118483664744, -122.432484753275) | |||
136197 | 136197 | 249748 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 32 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6000234.88856 | 2117241.71857 | 37.7935540389482 | -122.443151473582 | (37.7935540389482, -122.443151473582) | |||
148697 | 148697 | 227017 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6002132.64017 | 2096807.6586799999 | 37.7375551427627 | -122.435122918088 | (37.7375551427627, -122.435122918088) | |||
152046 | 152046 | 176712 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601 Silliman St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006141.07074 | 2092882.19738 | 37.7270034925144 | -122.42098522120199 | (37.7270034925144, -122.420985221202) | |||
155571 | 155571 | 129116 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007272.57871 | 2119275.5487599997 | 37.7995371979413 | -122.418944762911 | (37.7995371979413, -122.418944762911) | ||||
160189 | 160189 | 185221 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2507 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985796.5284 | 2098145.3036 | 37.740286789775 | -122.491702240957 | (37.740286789775, -122.491702240957) | |||
165303 | 165303 | 190791 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1701 19th St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6012603.88401 | 2105144.39947 | 37.761035078034894 | -122.3995037657 | (37.7610350780349, -122.3995037657) | |||
166224 | 166224 | 190792 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1701 19th St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6012608.36477 | 2105144.14311 | 37.7610346238788 | -122.399488250597 | (37.7610346238788, -122.399488250597) | |||
167115 | 167115 | 226854 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1306 York St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6010039.207119999 | 2101569.82479 | 37.7510768094609 | -122.40812180518 | (37.7510768094609, -122.40812180518) | |||
167158 | 167158 | 176709 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601 Silliman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006103.2010699995 | 2092869.0729 | 37.72696532078629 | -122.421115204706 | (37.7269653207863, -122.421115204706) | |||
169303 | 169303 | 129327 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007552.17158 | 2119860.88653 | 37.801160127991295 | -122.41801878675899 | (37.8011601279913, -122.418018786759) | ||||
170907 | 170907 | 129360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 555 California St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6011669.484759999 | 2116684.16602 | 37.7926684882083 | -122.40354738383002 | (37.7926684882083, -122.40354738383) | |||
174751 | 174751 | 129308 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2363 Larkin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006690.60343 | 2119350.14307 | 37.7997092274501 | -122.420963909083 | (37.7997092274501, -122.420963909083) | |||
177707 | 177707 | 176711 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601 Silliman St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006130.21076 | 2092879.08379 | 37.7269943310972 | -122.421022543052 | (37.7269943310972, -122.421022543052) | |||
179802 | 179802 | 129331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1101 Greenwich St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6007561.62509 | 2119863.3782 | 37.8011675015458 | -122.41798625015899 | (37.8011675015458, -122.417986250159) | ||||
180106 | 180106 | 176853 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 44 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6002702.22859 | 2087060.99975 | 37.7108253274008 | -122.43245763061 | (37.7108253274008, -122.43245763061) | |||
184897 | 184897 | 129307 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2363 Larkin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006689.73885 | 2119362.09742 | 37.7997420023389 | -122.420967750079 | (37.7997420023389, -122.420967750079) | |||
185500 | 185500 | 176862 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002709.09569 | 2087445.08105 | 37.711880320298 | -122.43246131155199 | (37.711880320298, -122.432461311552) | |||
187209 | 187209 | 206920 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 411 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5997366.58572 | 2095512.9448099998 | 37.7337283808453 | -122.45150798300399 | (37.7337283808453, -122.451507983004) | ||||
9867 | 9867 | 118924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 855 La Playa | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.772014669966396 | -122.510057198601 | (37.7720146699664, -122.510057198601) | ||
14463 | 14463 | 110915 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014720.0191 | 2113052.86526 | 37.7828676936327 | -122.39273818212 | (37.7828676936327, -122.39273818212) | |||
24753 | 24753 | 129266 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 24 Priest St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6008334.4403800005 | 2117141.01825 | 37.7937360410291 | -122.41511915572399 | (37.7937360410291, -122.415119155724) | |||
25101 | 25101 | 206960 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 546 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998473.38947 | 2095013.2793400001 | 37.7324197368658 | -122.44764549463899 | (37.7324197368658, -122.447645494639) | ||||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
40241 | 40241 | 176843 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999252.47179 | 2089747.68303 | 37.718006124373105 | -122.444573717211 | (37.7180061243731, -122.444573717211) | |||
42195 | 42195 | 129225 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6000598.01874 | 2117499.1088 | 37.794281463669705 | -122.441913500121 | (37.7942814636697, -122.441913500121) | |||
45249 | 45249 | 219385 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 329 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5999222.72505 | 2095218.63632 | 37.7330263961533 | -122.445069633071 | (37.7330263961533, -122.445069633071) | |||
45698 | 45698 | 219252 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 493 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998807.210109999 | 2094945.46348 | 37.7322526032772 | -122.446486525737 | (37.7322526032772, -122.446486525737) | |||
54085 | 54085 | 226853 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5531 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6001823.93594 | 2097423.83037 | 37.7392294726628 | -122.43623433623999 | (37.7392294726628, -122.43623433624) | |||
54348 | 54348 | 183004 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988132.401000001 | 2098265.1638 | 37.7407521359399 | -122.483634610884 | (37.7407521359399, -122.483634610884) | |||
54353 | 54353 | 190762 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1540 Newhall St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6014201.85219 | 2095471.1202599998 | 37.7345632359036 | -122.39330011180901 | (37.7345632359036, -122.393300111809) | |||
55295 | 55295 | 176830 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1581 Cayuga Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 5998657.8361599995 | 2089162.37902 | 37.7163650648728 | -122.44658701780001 | (37.7163650648728, -122.4465870178) | |||
56652 | 56652 | 176842 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999251.78306 | 2089738.34145 | 37.717980435227396 | -122.44457542680901 | (37.7179804352274, -122.444575426809) | |||
57691 | 57691 | 129314 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2164 Hyde St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6007179.677 | 2119798.49269 | 37.8009678385549 | -122.419303354081 | (37.8009678385549, -122.419303354081) | |||
58394 | 58394 | 227002 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5411 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002089.29593 | 2098063.49977 | 37.7410009293557 | -122.43536258651699 | (37.7410009293557, -122.435362586517) | |||
58589 | 58589 | 176839 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999268.4674 | 2089720.26783 | 37.717931761216605 | -122.444516458293 | (37.7179317612166, -122.444516458293) | |||
59810 | 59810 | 219387 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 329 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5999234.70338 | 2095218.3873299998 | 37.733026396154706 | -122.445028203091 | (37.7330263961547, -122.445028203091) | |||
60332 | 60332 | 129310 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007284.92251 | 2119276.14262 | 37.7995395235904 | -122.418902090975 | (37.7995395235904, -122.418902090975) |
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");