trees
57 rows where PlotSize = "3x3" and qCaretaker_id = 3 sorted by Police Districts
This data as json, CSV (advanced)
PlantType ✖
- Tree 56
- Landscaping 1
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▼ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2069 | 116350 | Undocumented 4 | Privet :: 212 | 4051X 24TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
23271 | 91828 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1941 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.413129591178 | (37.7664314036014, -122.413129591178) | 8 | 4 | 7 | 28853 | 19 | ||
32163 | 116349 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
43658 | 116348 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
82544 | 91762 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008660.813755 | 2107281.610975 | 37.7666827970273 | -122.413292321769 | (37.7666827970273, -122.413292321769) | 8 | 4 | 7 | 28853 | 19 | |||
87948 | 116353 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
100401 | 116352 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
122810 | 251512 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4116x 18th St | 1 | Back Yard : Yard | Tree | MTA 3 | 3x3 | 6002190 | 2105341 | 37.7609889340227 | -122.43553488468 | (37.7609889340227, -122.43553488468) | 15 | 4 | 5 | 28862 | 3 | ||||
146536 | 91829 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1941 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.413129591178 | (37.7664314036014, -122.413129591178) | 8 | 4 | 7 | 28853 | 19 | ||
151876 | 116351 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
152930 | 91827 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1941 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.413129591178 | (37.7664314036014, -122.413129591178) | 8 | 4 | 7 | 28853 | 19 | ||
162242 | 116354 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 10 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | |||
183279 | 116347 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 10 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | |||
196 | 116631 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 12 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
416 | 116621 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 2 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
6720 | 116625 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 6 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
22616 | 116522 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 324 08TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW for City Agency | 8 | 3x3 | 5993416 | 2113304 | 37.7823509768718 | -122.466458848407 | (37.7823509768718, -122.466458848407) | 11 | 6 | 2 | 54 | 11 | ||
34791 | 116627 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 8 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
36632 | 116630 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 11 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
52322 | 121200 | DPW Maintained 1 | Corymbia citriodora :: Lemon Scented Gum 384 | 423 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5990242 | 2112483 | 37.7799130778564 | -122.477379347216 | (37.7799130778564, -122.477379347216) | 11 | 6 | 2 | 55 | 26 | ||||
61507 | 116527 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5732 GEARY BLVD | 1 | Sidewalk: Curb side : Yard | Tree | MTA 3 | DPW for City Agency | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
85516 | 116628 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 9 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
102606 | 116620 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 1 | Front Yard : Cutout | Tree | MTA 3 | DPW | 12 | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | ||
107761 | 116629 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 10 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
134678 | 116624 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 5 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
141599 | 251417 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5990003 | 2112517 | 37.7799925618685 | -122.478208632121 | (37.7799925618685, -122.478208632121) | 11 | 6 | 2 | 55 | 26 | ||||
148169 | 116626 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 5732X GEARY BLVD | 7 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
156649 | 251254 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 09th Ave | 1 | unknown : Cutout | Tree | MTA 3 | 3x3 | 5993109 | 2113253 | 37.7821932251036 | -122.467517213871 | (37.7821932251036, -122.467517213871) | 11 | 6 | 2 | 54 | 11 | ||||
167673 | 116622 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 3 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
174243 | 116623 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 4 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
178661 | 121201 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 423 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5990242 | 2112483 | 37.7799130778564 | -122.477379347216 | (37.7799130778564, -122.477379347216) | 11 | 6 | 2 | 55 | 26 | ||||
17997 | 122419 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2200 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
39321 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
44800 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
80257 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
92548 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
95104 | 120593 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499x Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 34 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | |||
102801 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
104414 | 120596 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 36 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | |||
116578 | 120595 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
136955 | 122414 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 11 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
141801 | 122417 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 14 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
148884 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
149548 | 122416 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 13 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
156105 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
162950 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
166166 | 120598 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
173056 | 122420 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2200 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
6915 | 116579 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | |||
20043 | 116577 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 30 | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | ||
123567 | 116606 | Undocumented 4 | Ficus Spp. :: 101 | 1325x 08TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | MTA 3 | 3x3 | 5993613 | 2106469 | 37.7635952548206 | -122.465280685608 | (37.7635952548206, -122.465280685608) | 1 | 8 | 11 | 56 | 12 | ||||
135904 | 116578 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 2699x OCEAN AVE | 1 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 11 | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | ||
136506 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | |||
145371 | 116609 | Undocumented 4 | Ficus Spp. :: 101 | 1325x 08TH AVE | 4 | Sidewalk: Property side : Cutout | Tree | MTA 3 | 3x3 | 5993613 | 2106469 | 37.7635952548206 | -122.465280685608 | (37.7635952548206, -122.465280685608) | 1 | 8 | 11 | 56 | 12 | ||||
145690 | 116607 | Undocumented 4 | Ficus Spp. :: 101 | 1325x 08TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5993613 | 2106469 | 37.7635952548206 | -122.465280685608 | (37.7635952548206, -122.465280685608) | 1 | 8 | 11 | 56 | 12 | ||||
153596 | 116608 | Undocumented 4 | Ficus Spp. :: 101 | 1325x 08TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5993613 | 2106469 | 37.7635952548206 | -122.465280685608 | (37.7635952548206, -122.465280685608) | 1 | 8 | 11 | 56 | 12 | ||||
161563 | 116580 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 3 | Sidewalk: Property side : Cutout | Landscaping | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );