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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54321 | 54321 | 70512 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 5 | 6004917.4216 | 2092965.0192099998 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | ||
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) | ||
25548 | 25548 | 71937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | ||
62195 | 62195 | 84689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6002195.05393 | 2120739.39081 | 37.80326930438871 | -122.436619630107 | (37.8032693043887, -122.436619630107) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||||
8632 | 8632 | 99720 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2164 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007185.20399 | 2119756.67852 | 37.8008533386708 | -122.41928126041701 | (37.8008533386708, -122.419281260417) | |||
8375 | 8375 | 100825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003069.70231 | 2120954.84645 | 37.803910554290795 | -122.43360829069401 | (37.8039105542908, -122.433608290694) | |||
4190 | 4190 | 100829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003036.60353 | 2120959.36193 | 37.803921074561295 | -122.43372315391198 | (37.8039210745613, -122.433723153912) | |||
137589 | 137589 | 101799 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 616 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6x6 | 6012351.43379 | 2105077.38644 | 37.7608370005419 | -122.400372179851 | (37.7608370005419, -122.400372179851) | |||
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) | |||||
54473 | 54473 | 103306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6011832.19369 | 2105491.00064 | 37.7619437242424 | -122.402197092231 | (37.7619437242424, -122.402197092231) | ||||
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) | |||||
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) | |||
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) | |||
12269 | 12269 | 106828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 631 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6009794.12958 | 2091448.15219 | 37.7232711495323 | -122.40825550289 | (37.7232711495323, -122.40825550289) | |||
50164 | 50164 | 107054 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 98X ROTTECK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6003385.0 | 2094496.0 | 37.731278888142704 | -122.43062801306999 | (37.7312788881427, -122.43062801307) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | ||||
81185 | 81185 | 108348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 3x3 | 5988501.0 | 2100296.0 | 37.746349726050894 | -122.48250892192699 | (37.7463497260509, -122.482508921927) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
173674 | 173674 | 109355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 5x45 | 6007469.51339 | 2120600.5219 | 37.8031863275346 | -122.41835729337299 | (37.8031863275346, -122.418357293373) | |||
24884 | 24884 | 109356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 5x45 | 6007464.49344 | 2120601.01033 | 37.8031873860571 | -122.41837469975 | (37.8031873860571, -122.41837469975) | |||
71497 | 71497 | 109357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 5x45 | 6007459.04695 | 2120599.58062 | 37.8031831538387 | -122.41839344609801 | (37.8031831538387, -122.418393446098) | |||
171997 | 171997 | 109358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007454.77295 | 2120598.70497 | 37.8031805089291 | -122.41840817430901 | (37.8031805089291, -122.418408174309) | |||
48049 | 48049 | 109359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007452.06537 | 2120598.7604799997 | 37.8031805089269 | -122.41841754792802 | (37.8031805089269, -122.418417547928) | |||
147679 | 147679 | 109360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007448.76613 | 2120598.25036 | 37.803178922540205 | -122.418428928878 | (37.8031789225402, -122.418428928878) | |||
155176 | 155176 | 109361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007445.84949 | 2120597.53947 | 37.803176806427004 | -122.418438971581 | (37.803176806427, -122.418438971581) | |||
70565 | 70565 | 109362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007443.52896 | 2120597.58705 | 37.8031768064372 | -122.41844700523701 | (37.8031768064372, -122.418447005237) | |||
75911 | 75911 | 109363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007417.13772 | 2120593.69695 | 37.8031646394947 | -122.418538057081 | (37.8031646394947, -122.418538057081) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
78535 | 78535 | 110569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
124373 | 124373 | 110570 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
107354 | 107354 | 110571 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
55719 | 55719 | 110572 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
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) | |||
164696 | 164696 | 110916 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014753.14393 | 2113088.0309200003 | 37.7829660902443 | -122.392626043851 | (37.7829660902443, -122.392626043851) | |||
151494 | 151494 | 110917 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014761.22745 | 2113096.50864 | 37.7829898170664 | -122.39259867121001 | (37.7829898170664, -122.39259867121) | |||
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) | |||
181098 | 181098 | 110919 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014784.35432 | 2113116.8816 | 37.783047040932395 | -122.39252008665001 | (37.7830470409324, -122.39252008665) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||||
168446 | 168446 | 115307 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1309 Hyde St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | 6007522.861409999 | 2116889.0118 | 37.792998452176796 | -122.41790942558501 | (37.7929984521768, -122.417909425585) | |||
66804 | 66804 | 115308 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1309 Hyde St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | 6007523.230690001 | 2116877.91301 | 37.792967998429 | -122.417907360732 | (37.792967998429, -122.417907360732) | |||
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) | |||
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) | |||
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) | |||
135274 | 135274 | 117699 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5982983.94909 | 2113077.92837 | 37.781122765049 | -122.50253180663601 | (37.781122765049, -122.502531806636) | |||
76179 | 76179 | 117700 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5982971.473069999 | 2113077.09614 | 37.7811197468717 | -122.502574905114 | (37.7811197468717, -122.502574905114) | |||
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) | |||
44550 | 44550 | 117813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983481.12715 | 2111084.52953 | 37.775678674640396 | -122.500664399599 | (37.7756786746404, -122.500664399599) | |||
166581 | 166581 | 117814 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983453.00574 | 2111081.1088 | 37.7756676313487 | -122.500761423942 | (37.7756676313487, -122.500761423942) | |||
179349 | 179349 | 117815 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5983440.2073 | 2111080.71217 | 37.7756657909172 | -122.50080566686 | (37.7756657909172, -122.50080566686) | |||
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) | |||
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) | |||
75864 | 75864 | 117818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3936 Balboa St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 1ft | 5983313.54909 | 2111075.82361 | 37.775644931310396 | -122.501243440143 | (37.7756449313104, -122.501243440143) | |||
29129 | 29129 | 117930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 593 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5982838.9134599995 | 2111805.09577 | 37.7776194161311 | -122.502939294109 | (37.7776194161311, -122.502939294109) | |||
37574 | 37574 | 117932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 599 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5982840.28847 | 2111742.07201 | 37.77744645210971 | -122.502929870802 | (37.7774464521097, -122.502929870802) | |||
65282 | 65282 | 118037 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3421 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 5984874.28781 | 2113152.5227900003 | 37.7814384776062 | -122.49599778017401 | (37.7814384776062, -122.495997780174) | |||
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) | |||
77219 | 77219 | 118070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 35th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5985031.51413 | 2113017.90855 | 37.7810780733056 | -122.49544393016599 | (37.7810780733056, -122.495443930166) | |||
158745 | 158745 | 118071 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 35th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5985031.745180001 | 2113002.45389 | 37.7810356528066 | -122.49544199070401 | (37.7810356528066, -122.495441990704) | |||
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) | |||
39296 | 39296 | 118084 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5984977.6516 | 2112422.66835 | 37.7794405616591 | -122.49558634816002 | (37.7794405616591, -122.49558634816) | |||
147263 | 147263 | 118085 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5984968.995209999 | 2112422.4327599998 | 37.779439407894 | -122.495616276446 | (37.779439407894, -122.495616276446) | |||
181808 | 181808 | 118086 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5984961.82415 | 2112422.5857 | 37.779439407892795 | -122.495641095089 | (37.7794394078928, -122.495641095089) | |||
76845 | 76845 | 118087 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5984956.11601 | 2112422.0770099997 | 37.7794376769099 | -122.495660804133 | (37.7794376769099, -122.495660804133) | |||
171608 | 171608 | 118088 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5984949.57327 | 2112422.00658 | 37.7794371003845 | -122.495683432703 | (37.7794371003845, -122.495683432703) | |||
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) | |||
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) | |||
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) | ||||
75381 | 75381 | 118704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5982455.1363 | 2110968.5092599997 | 37.775299830770294 | -122.504204899972 | (37.7752998307703, -122.504204899972) | |||
157951 | 157951 | 118705 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5982441.7055 | 2110968.62548 | 37.7752993599927 | -122.504251368027 | (37.7752993599927, -122.504251368027) |
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");