Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95182 | 95182 | 16377 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1400X Montgomery St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | |||
| 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) | ||||
| 96795 | 96795 | 219249 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 493 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5998807.9038 | 2094951.17494 | 37.732268325221206 | -122.446484538256 | (37.7322683252212, -122.446484538256) | |||
| 97259 | 97259 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 15x4 | 6004495.0 | 2117637.0 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | |||
| 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) | |||||
| 100221 | 100221 | 5821 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | |||
| 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) | ||||||
| 102075 | 102075 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 654 Precita Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | |||||
| 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) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||||
| 109984 | 109984 | 116585 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2100 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6011843.0 | 2103815.0 | 37.757342401329105 | -122.402041888427 | (37.7573424013291, -122.402041888427) | |||
| 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) | |||
| 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) | ||||
| 112118 | 112118 | 878 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
| 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) | |||
| 115088 | 115088 | 117438 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 230 AMBER DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 25 | 3X3 | 5999593.0 | 2099199.0 | 37.7439766577846 | -122.444075405191 | (37.7439766577846, -122.444075405191) | |||
| 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) | |||||
| 116928 | 116928 | 226976 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 233 Arbor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6001281.48778 | 2096833.4414099997 | 37.737577567341106 | -122.438067595237 | (37.7375775673411, -122.438067595237) | |||
| 116931 | 116931 | 176821 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 629 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6009772.50024 | 2091512.8387900002 | 37.723447554245894 | -122.40833483209299 | (37.7234475542459, -122.408334832093) | |||
| 117657 | 117657 | 206947 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 66 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5999628.508830001 | 2093810.3461799999 | 37.7291827126146 | -122.443565606895 | (37.7291827126146, -122.443565606895) | |||
| 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) | ||||
| 119314 | 119314 | 129168 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2601 Francisco St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5999089.48794 | 2119715.1025099996 | 37.8002799138508 | -122.447292735565 | (37.8002799138508, -122.447292735565) | |||
| 119837 | 119837 | 219290 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 502 Edna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5998794.71473 | 2094454.093 | 37.7309027019769 | -122.44649438672899 | (37.7309027019769, -122.446494386729) | ||||
| 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) | |||
| 120444 | 120444 | 120172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2300 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5988392.10695 | 2111261.25032 | 37.7764509846763 | -122.483689270751 | (37.7764509846763, -122.483689270751) | |||
| 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) | ||||
| 123310 | 123310 | 226843 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 Grand View Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6000048.9204 | 2101630.772 | 37.7506797174008 | -122.442673512691 | (37.7506797174008, -122.442673512691) | ||||
| 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) | ||||
| 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) | ||||
| 125057 | 125057 | 226994 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 155 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6003283.62292 | 2097316.63831 | 37.7390179746069 | -122.431179747064 | (37.7390179746069, -122.431179747064) | |||
| 125302 | 125302 | 176625 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 332 Ellington Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5998763.992880001 | 2087858.5335799998 | 37.712791065527796 | -122.446126358062 | (37.7127910655278, -122.446126358062) | |||
| 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) | ||||
| 129500 | 129500 | 129165 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5998683.20091 | 2113396.5400099996 | 37.7829075938537 | -122.448243401733 | (37.7829075938537, -122.448243401733) | |||
| 129532 | 129532 | 227007 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5511 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 5ft | 6001889.47135 | 2097556.17355 | 37.73959657953029 | -122.436017212027 | (37.7395965795303, -122.436017212027) | |||
| 129546 | 129546 | 176751 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Gambier St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6005772.20267 | 2093310.23557 | 37.728157991789104 | -122.422290792187 | (37.7281579917891, -122.422290792187) | |||
| 129585 | 129585 | 219384 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 329 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5999214.00791 | 2095218.5463299998 | 37.7330256515176 | -122.445099763939 | (37.7330256515176, -122.445099763939) | |||
| 129593 | 129593 | 176829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1581 Cayuga Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 1ft | 5998649.34679 | 2089153.88395 | 37.7163412544316 | -122.446615750237 | (37.7163412544316, -122.446615750237) | |||
| 129688 | 129688 | 129131 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3542 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000280.24975 | 2120491.13146 | 37.8024786510429 | -122.443228011273 | (37.8024786510429, -122.443228011273) | |||
| 129996 | 129996 | 176779 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Dartmouth St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008512.5516 | 2093571.34607 | 37.729029141679895 | -122.412835725785 | (37.7290291416799, -122.412835725785) | |||
| 130192 | 130192 | 249743 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 27 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000230.51867 | 2117262.97292 | 37.793612148632704 | -122.443168120916 | (37.7936121486327, -122.443168120916) | |||
| 130258 | 130258 | 176848 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005711.542330001 | 2093506.49571 | 37.728693457131 | -122.422514437416 | (37.728693457131, -122.422514437416) | |||
| 130260 | 130260 | 54791 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.711719793993204 | -122.39815894829901 | (37.7117197939932, -122.398158948299) | ||
| 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) | |||
| 130333 | 130333 | 190795 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2051 23rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6012296.97439 | 2102792.20367 | 37.7545593540486 | -122.40040001655301 | (37.7545593540486, -122.400400016553) | |||
| 130684 | 130684 | 190802 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 625 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6011842.77301 | 2105367.13187 | 37.7616041987086 | -122.402151793375 | (37.7616041987086, -122.402151793375) | |||
| 130697 | 130697 | 176632 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000949.95305 | 2087893.72595 | 37.713012287961604 | -122.43857351247499 | (37.7130122879616, -122.438573512475) | |||
| 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) | |||
| 130860 | 130860 | 190785 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 566 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6014353.501540001 | 2104489.0568 | 37.7593330157277 | -122.393406687779 | (37.7593330157277, -122.393406687779) | |||
| 130965 | 130965 | 249623 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 7ft | 5997659.54255 | 2111324.05825 | 37.7771585265736 | -122.451635273045 | (37.7771585265736, -122.451635273045) | |||
| 131124 | 131124 | 201347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012791.8631 | 2092596.6146799999 | 37.7265919996064 | -122.397973366875 | (37.7265919996064, -122.397973366875) | |||
| 131324 | 131324 | 219414 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 5999417.68406 | 2095671.79096 | 37.7342817777744 | -122.44442816642 | (37.7342817777744, -122.44442816642) | |||
| 131613 | 131613 | 176652 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 80 Badger St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002383.04289 | 2094283.2100900002 | 37.730637801296204 | -122.434076751136 | (37.7306378012962, -122.434076751136) | |||
| 131660 | 131660 | 247557 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 2ft | 6000027.54626 | 2108348.5362299997 | 37.769123823324 | -122.443229861189 | (37.769123823324, -122.443229861189) | |||
| 131673 | 131673 | 201354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6012921.134769999 | 2092559.31371 | 37.726496777601795 | -122.39752386145099 | (37.7264967776018, -122.397523861451) | |||
| 131686 | 131686 | 190788 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1701 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6012435.911169999 | 2105136.5588700003 | 37.7610041854195 | -122.400084163877 | (37.7610041854195, -122.400084163877) | |||
| 131766 | 131766 | 176734 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1245 Bacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007778.84426 | 2091938.91597 | 37.7245056282085 | -122.41525670432699 | (37.7245056282085, -122.415256704327) | |||
| 131893 | 131893 | 129312 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2164 Hyde St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6007181.25127 | 2119783.68737 | 37.8009272755444 | -122.419296855565 | (37.8009272755444, -122.419296855565) | |||
| 131920 | 131920 | 31117 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 450 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34839 | 5998792.33216 | 2094320.7757 | 37.7305365079364 | -122.446493035949 | (37.7305365079364, -122.446493035949) | |
| 131947 | 131947 | 129294 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2360 Larkin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6006752.1432 | 2119373.08608 | 37.7997756918535 | -122.420752588162 | (37.7997756918535, -122.420752588162) | |||
| 132062 | 132062 | 129292 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2320 Larkin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6006777.35788 | 2119212.5003400003 | 37.7993361850728 | -122.42065392985799 | (37.7993361850728, -122.420653929858) | |||
| 132065 | 132065 | 226896 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1243 Valencia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 6006432.373930001 | 2102561.6161 | 37.7535974274886 | -122.420665025691 | (37.7535974274886, -122.420665025691) | |||
| 132149 | 132149 | 226992 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 67 Everson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6003410.577190001 | 2097089.59792 | 37.7384017672326 | -122.43072460017099 | (37.7384017672326, -122.430724600171) | |||
| 132151 | 132151 | 176730 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1533 Burrows St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6006825.48206 | 2092127.1271099998 | 37.724968788961206 | -122.41856569774299 | (37.7249687889612, -122.418565697743) | |||
| 132206 | 132206 | 176602 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 279 Moscow St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6004631.85763 | 2091492.97725 | 37.7231038108784 | -122.426103691929 | (37.7231038108784, -122.426103691929) | |||
| 132381 | 132381 | 226897 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1035 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999804.0569 | 2099745.02655 | 37.745487953702 | -122.443384833249 | (37.745487953702, -122.443384833249) | |||
| 132494 | 132494 | 185500 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2400 Sunset Blvd | 54 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985111.7766 | 2098706.9627 | 37.7417889108579 | -122.49411119019399 | (37.7417889108579, -122.494111190194) |
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");