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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 3534 | 3534 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2179 41st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x5 | 5983532.0 | 2100331.0 | 37.74615550514321 | -122.49969345420799 | (37.7461555051432, -122.499693454208) | ||||
| 3549 | 3549 | 253470 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3 Valletta Ct | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999319.0 | 2096479.0 | 37.736492551957895 | -122.44482735214198 | (37.7364925519579, -122.444827352142) | ||||
| 46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
| 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) | |||
| 78153 | 78153 | 104715 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 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) | ||||
| 80457 | 80457 | 104540 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 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) | ||||
| 84515 | 84515 | 104544 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 85803 | 85803 | 106833 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 174 STILLINGS AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999619.6 | 2095804.2 | 37.7346568605649 | -122.443739589791 | (37.7346568605649, -122.443739589791) | |||||
| 86324 | 86324 | 121732 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1301 Vermont St | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 87429 | 87429 | 108624 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 101 GENEBERN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005050.2 | 2095237.8 | 37.733409902631 | -122.42492386614401 | (37.733409902631, -122.424923866144) | |||||
| 88432 | 88432 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2398 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 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) | |||||
| 89880 | 89880 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 86 Nordhoff St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000395.0 | 2095652.0 | 37.734283150969794 | -122.44104786104499 | (37.7342831509698, -122.441047861045) | |||||
| 90158 | 90158 | 108211 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
| 90274 | 90274 | 97299 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1051 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 91752 | 91752 | 96831 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2908 Baker St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999535.9 | 2118868.1 | 37.797979769659996 | -122.44568703479601 | (37.79797976966, -122.445687034796) | |||||
| 91812 | 91812 | 107986 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2401x SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001257.0 | 2116757.0 | 37.7922813550603 | -122.439580129378 | (37.7922813550603, -122.439580129378) | ||||
| 91961 | 91961 | 103591 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
| 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) | ||||
| 94698 | 94698 | 104538 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 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) | ||||
| 97319 | 97319 | 88347 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100x Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004738.0 | 2092796.0 | 37.7266876232591 | -122.425829482771 | (37.7266876232591, -122.425829482771) | |||
| 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) | |||||
| 97796 | 97796 | 104543 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 97963 | 97963 | 104717 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 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) | |||
| 98516 | 98516 | 104542 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 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) | ||||
| 99448 | 99448 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000586.0 | 2086414.0 | 37.70892857908329 | -122.439725431133 | (37.7089285790833, -122.439725431133) | ||||
| 99837 | 99837 | 99918 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 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) | |||
| 104252 | 104252 | 121734 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1301 Vermont St | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 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) | |||
| 107709 | 107709 | 99917 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 107724 | 107724 | 99916 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 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) | |||
| 109308 | 109308 | 103590 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
| 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) | |||||
| 111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
| 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) | ||||
| 112529 | 112529 | 104716 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 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) | |||
| 114105 | 114105 | 99919 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 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) | |||
| 116755 | 116755 | 103589 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 55X Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | |||||
| 117763 | 117763 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x8 | 5997298.0 | 2095759.0 | 37.7344000615683 | -122.45176284684601 | (37.7344000615683, -122.451762846846) | ||||
| 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) | ||||
| 125685 | 125685 | 96832 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2908 Baker St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999535.9 | 2118868.1 | 37.797979769659996 | -122.44568703479601 | (37.79797976966, -122.445687034796) | |||||
| 125858 | 125858 | 104539 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 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) | ||||
| 129210 | 129210 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 577 Sanchez St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6003673.0 | 2104901.0 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | |||||
| 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) | ||||
| 138525 | 138525 | 104568 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 140502 | 140502 | 104541 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 140837 | 140837 | 105857 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 1500X Valencia St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6006259.2 | 2100711.5 | 37.7485076710609 | -122.42113253995599 | (37.7485076710609, -122.421132539956) | ||||
| 143885 | 143885 | 108210 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
| 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) | |||
| 26942 | 26942 | 129350 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | |||
| 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) | ||||
| 61110 | 61110 | 92458 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3319 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52848 | 5983933.4582 | 2104246.8072 | 37.756930776386795 | -122.498594490514 | (37.7569307763868, -122.498594490514) |
| 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) | |||
| 154652 | 154652 | 129351 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.67929 | 2120161.57643 | 37.8022029953207 | -122.404635873741 | (37.8022029953207, -122.404635873741) | |||
| 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) | |||
| 27490 | 27490 | 129348 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | |||
| 35096 | 35096 | 103483 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 116 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770307 | 6009546.84586 | 2094694.0586599999 | 37.73216987282029 | -122.409339274108 | (37.7321698728203, -122.409339274108) | |
| 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) | |||
| 46668 | 46668 | 32026 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 910 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | 2 | Permit Number 48084 | 6011942.61594 | 2111635.52885 | 37.7788213676447 | -122.40224721144399 | (37.7788213676447, -122.402247211444) | ||
| 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) |
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");