trees
177 rows where Police Districts = 3 and qCaretaker_id = 4 sorted by XCoord
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5500 | 77664 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006642.94243 | 2093520.00504 | 37.728783051183 | -122.419295481395 | (37.728783051183, -122.419295481395) | 9 | 3 | 7 | 309 | 5 | ||
26495 | 42983 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2X Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 4 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
32373 | 77649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
54545 | 42985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 12 | 9x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
67880 | 77637 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
89151 | 77638 | DPW Maintained 1 | Tree(s) :: 17 | 2X Yale St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
103561 | 42990 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
110301 | 42989 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
118983 | 77668 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 5 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
120765 | 42988 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
132081 | 42984 | DPW Maintained 1 | Tree(s) :: 17 | 2X Yale St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 4 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
133673 | 77636 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
135683 | 77635 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
141010 | 77633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 8 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
175839 | 42987 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2X Yale St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 8 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
180726 | 77634 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
191330 | 42986 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2X Yale St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 3 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
5695 | 77663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006674.08558 | 2093407.54115 | 37.7284760037541 | -122.419179842976 | (37.7284760037541, -122.419179842976) | 9 | 3 | 7 | 309 | 5 | ||
1403 | 77662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006681.78325 | 2093389.68756 | 37.7284274151839 | -122.419151965791 | (37.7284274151839, -122.419151965791) | 9 | 3 | 7 | 309 | 5 | ||
18051 | 77661 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006687.82384 | 2093371.12447 | 37.7283767851556 | -122.419129766951 | (37.7283767851556, -122.419129766951) | 9 | 3 | 7 | 309 | 5 | ||
3604 | 77660 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006693.80957 | 2093349.88561 | 37.7283188049508 | -122.419107568078 | (37.7283188049508, -122.419107568078) | 9 | 3 | 7 | 309 | 5 | ||
13778 | 77659 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6006700.09662 | 2093328.78928 | 37.7282612330662 | -122.419084337666 | (37.7282612330662, -122.419084337666) | 9 | 3 | 7 | 309 | 5 | ||
8555 | 77658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006705.39704 | 2093310.53877 | 37.7282114196192 | -122.419064719886 | (37.7282114196192, -122.419064719886) | 9 | 3 | 7 | 309 | 5 | ||
17259 | 77657 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006712.15653 | 2093290.62233 | 37.7281571140509 | -122.41903993995 | (37.7281571140509, -122.41903993995) | 9 | 3 | 7 | 309 | 5 | ||
9739 | 77653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006717.25868 | 2093269.99639 | 37.7281007670162 | -122.41902083924 | (37.7281007670162, -122.41902083924) | 9 | 3 | 7 | 309 | 5 | ||
6638 | 77652 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006723.02825 | 2093252.77715 | 37.7280538116191 | -122.41899967279 | (37.7280538116191, -122.41899967279) | 9 | 3 | 7 | 309 | 5 | ||
14433 | 76390 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006730.14725 | 2093235.82763 | 37.7280076727975 | -122.418973860459 | (37.7280076727975, -122.418973860459) | 9 | 3 | 7 | 309 | 5 | ||
5947 | 76372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006736.19364 | 2093210.27498 | 37.7279378512454 | -122.418951146283 | (37.7279378512454, -122.418951146283) | 9 | 3 | 7 | 309 | 5 | ||
4867 | 76353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006742.79477 | 2093189.9157 | 37.7278823207912 | -122.418926882581 | (37.7278823207912, -122.418926882581) | 9 | 3 | 7 | 309 | 5 | ||
2404 | 76334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006750.61437 | 2093170.72103 | 37.7278300567077 | -122.418898489194 | (37.7278300567077, -122.418898489194) | 9 | 3 | 7 | 309 | 5 | ||
8515 | 76311 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299X Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 0 | 6006754.26056 | 2093151.90933 | 37.7277786091743 | -122.418884550584 | (37.7277786091743, -122.418884550584) | 9 | 3 | 7 | 309 | 5 | ||
129312 | 77648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.14742 | 2093142.98247 | 37.7277576387802 | -122.418666516263 | (37.7277576387802, -122.418666516263) | 9 | 3 | 7 | 309 | 5 | |
1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
17218 | 77646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | 9 | 3 | 7 | 309 | 5 | ||
7775 | 77645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006883.85072 | 2093162.97754 | 37.7278162961767 | -122.418437338432 | (37.7278162961767, -122.418437338432) | 9 | 3 | 7 | 309 | 5 | ||
3789 | 77644 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | 9 | 3 | 7 | 309 | 5 | ||
1121 | 77643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006923.44086 | 2093174.37286 | 37.7278498138936 | -122.418301281799 | (37.7278498138936, -122.418301281799) | 9 | 3 | 7 | 309 | 5 | ||
9319 | 77642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006942.10409 | 2093179.93326 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | 9 | 3 | 7 | 309 | 5 | ||
10546 | 77641 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006964.98892 | 2093186.85252 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | 9 | 3 | 7 | 309 | 5 | ||
9059 | 77640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 13 | 0 | 6006980.92428 | 2093193.11147 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | 9 | 3 | 7 | 309 | 5 | ||
16134 | 106952 | Undocumented 4 | Tree(s) :: 17 | 399X SOMERSET ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6009953 | 2092875 | 37.7271978698015 | -122.407806879765 | (37.7271978698015, -122.407806879765) | 10 | 3 | 7 | 309 | 28 | ||||
163044 | 106953 | Undocumented 4 | Tree(s) :: 17 | 399X SOMERSET ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6009953 | 2092875 | 37.7271978698015 | -122.407806879765 | (37.7271978698015, -122.407806879765) | 10 | 3 | 7 | 309 | 28 | |||||
72835 | 253729 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
73519 | 253732 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
75070 | 253734 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
82489 | 253724 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
108286 | 253726 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
109856 | 253733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
127602 | 253727 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
138444 | 253731 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
160599 | 253725 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
181086 | 253730 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
183365 | 251680 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
190932 | 253728 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
106425 | 116064 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/30/2018 12:00:00 AM | 3 | 8x7 | 6011272.30638 | 2105412.17877 | 37.7616960293658 | -122.404127986133 | (37.7616960293658, -122.404127986133) | 10 | 3 | 8 | 28856 | 29 | |
89512 | 116065 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/30/2018 12:00:00 AM | 3 | 8x7 | 6011274.01561 | 2105377.63125 | 37.7616012651139 | -122.404119643106 | (37.7616012651139, -122.404119643106) | 10 | 3 | 8 | 28856 | 29 | |
184196 | 122755 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.404117444276 | (37.7615439863765, -122.404117444276) | 10 | 3 | 8 | 28856 | 29 | |||
35970 | 122754 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 6011277.36342 | 2105334.1858 | 37.7614821606899 | -122.404105006665 | (37.7614821606899, -122.404105006665) | 10 | 3 | 8 | 28856 | 29 | |||
117414 | 122753 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 15 | 6011277.81019 | 2105311.62173 | 37.7614202297665 | -122.404101873421 | (37.7614202297665, -122.404101873421) | 10 | 3 | 8 | 28856 | 29 | |||
36749 | 122752 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | 10 | 3 | 8 | 28856 | 29 | |||
134813 | 122751 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 693 Vermont St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011280.99043 | 2105260.13165 | 37.7612790272197 | -122.404087250433 | (37.7612790272197, -122.404087250433) | 10 | 3 | 8 | 28856 | 29 | |||
122926 | 122750 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 6011285.1392 | 2105241.40164 | 37.7612278306072 | -122.404071583333 | (37.7612278306072, -122.404071583333) | 10 | 3 | 8 | 28856 | 29 | |||
143067 | 122749 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 6011285.50671 | 2105214.92948 | 37.7611551645106 | -122.404068449214 | (37.7611551645106, -122.404068449214) | 10 | 3 | 8 | 28856 | 29 | |||
61919 | 43305 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/12/2000 12:00:00 AM | 6 | Permit Number 43072 | 6011285.67007 | 2105193.27319 | 37.7610957103087 | -122.4040663601 | (37.7610957103087, -122.4040663601) | 10 | 3 | 8 | 28856 | 29 | |
165196 | 43304 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 693 Vermont St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/12/2000 12:00:00 AM | 19 | Permit Number 43072 | 6011287.96925 | 2105166.37556 | 37.7610219838923 | -122.404056515205 | (37.7610219838923, -122.404056515205) | 10 | 3 | 8 | 28856 | 29 | |
114573 | 43306 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 693 Vermont St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/12/2000 12:00:00 AM | 22 | Permit Number 43072 | 6011289.47877 | 2105149.93268 | 37.7609769197604 | -122.404050137204 | (37.7609769197604, -122.404050137204) | 10 | 3 | 8 | 28856 | 29 | |
35366 | 116063 | DPW Maintained 1 | Brachychiton discolor :: 437 | 2100x 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 19 | 3x3 | 6011332.66531 | 2105125.78364 | 37.7609130247313 | -122.403899073603 | (37.7609130247313, -122.403899073603) | 10 | 3 | 8 | 28856 | 29 | ||
120995 | 116062 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2100x 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 22 | 3x3 | 6011361.02056 | 2105129.82914 | 37.7609257168785 | -122.403801289392 | (37.7609257168785, -122.403801289392) | 10 | 3 | 8 | 28856 | 29 | ||
8962 | 116061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | 10 | 3 | 8 | 28856 | 29 | ||
41878 | 116060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | 10 | 3 | 8 | 28856 | 29 | ||
112770 | 116059 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2100x 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6011431.5308 | 2105131.75607 | 37.7609349466036 | -122.403557559651 | (37.7609349466036, -122.403557559651) | 10 | 3 | 8 | 28856 | 29 | ||
164578 | 116058 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2100x 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6011458.59484 | 2105134.56728 | 37.760944177262 | -122.403464154268 | (37.760944177262, -122.403464154268) | 10 | 3 | 8 | 28856 | 29 | ||
79109 | 116057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2100x 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6011480.97635 | 2105135.37266 | 37.760947638753 | -122.40338680266 | (37.760947638753, -122.40338680266) | 10 | 3 | 8 | 28856 | 29 | ||
147370 | 116046 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 5x15 | 6011495.20108 | 2105434.89797 | 37.7617708628477 | -122.40335867726 | (37.7617708628477, -122.40335867726) | 10 | 3 | 8 | 28856 | 29 | ||
89640 | 116047 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 5x12 | 6011496.1211 | 2105415.82819 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | 10 | 3 | 8 | 28856 | 29 | ||
110109 | 116049 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.7615544688802 | -122.403342277248 | (37.7615544688802, -122.403342277248) | 10 | 3 | 8 | 28856 | 29 | ||
150345 | 116048 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 650x Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 4x4 | 6011498.51602 | 2105372.79225 | 37.7616005195649 | -122.403342842915 | (37.7616005195649, -122.403342842915) | 10 | 3 | 8 | 28856 | 29 | ||
180684 | 116050 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Kansas St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 4x4 | 6011499.79329 | 2105331.08163 | 37.7614860628578 | -122.403335490949 | (37.7614860628578, -122.403335490949) | 10 | 3 | 8 | 28856 | 29 | ||
14250 | 116051 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 4x4 | 6011500.28754 | 2105307.13541 | 37.7614203394907 | -122.403332096897 | (37.7614203394907, -122.403332096897) | 10 | 3 | 8 | 28856 | 29 | ||
58864 | 116052 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/23/2018 12:00:00 AM | 3 | 4x4 | 6011506.55629 | 2105277.69862 | 37.7613398627543 | -122.403308344903 | (37.7613398627543, -122.403308344903) | 10 | 3 | 8 | 28856 | 29 | |
184781 | 116053 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 650x Kansas St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 4x4 | 6011508.10962 | 2105241.51829 | 37.7612406063998 | -122.403300427289 | (37.7612406063998, -122.403300427289) | 10 | 3 | 8 | 28856 | 29 | ||
176047 | 116054 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 650x Kansas St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 23 | 4x4 | 6011511.93551 | 2105220.59815 | 37.7611833780414 | -122.403285723377 | (37.7611833780414, -122.403285723377) | 10 | 3 | 8 | 28856 | 29 | ||
8452 | 116055 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2020 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.403280067548 | (37.7611252557522, -122.403280067548) | 10 | 3 | 8 | 28856 | 29 | |
40315 | 116056 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/30/2018 12:00:00 AM | 23 | 4x4 | 6011515.19198 | 2105171.68257 | 37.7610492486475 | -122.403271019449 | (37.7610492486475, -122.403271019449) | 10 | 3 | 8 | 28856 | 29 | |
17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
60432 | 112026 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
62536 | 112022 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
73651 | 112027 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
127080 | 112029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
129965 | 112024 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
174726 | 112028 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2101x 22nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
187598 | 112025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
44433 | 94516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.94736 | 37.7534025731789 | -122.398672553793 | (37.7534025731789, -122.398672553793) | 10 | 3 | 8 | 28856 | 29 | ||
82714 | 94895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
84292 | 94894 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
132285 | 94893 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
167565 | 94892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
13195 | 78202 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014063.31576 | 2094176.73754 | 37.7310014277784 | -122.393688515509 | (37.7310014277784, -122.393688515509) | 10 | 3 | 8 | 58 | 1 | ||
7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 |
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) );