trees
236 rows where DBH = "" and qCaretaker_id = 4 sorted by Zip Codes
This data as json, CSV (advanced)
These facets timed out: DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80 | 260998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | 10x10 | ||||||||||||||
2079 | 263595 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
4032 | 263594 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
4900 | 263589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 | |||
4935 | 263596 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
7643 | 263592 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
10051 | 263590 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
16157 | 263597 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 03/07/2007 12:00:00 AM | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | ||
18291 | 263593 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
38459 | 107872 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
47600 | 107870 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
51523 | 107874 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||||
68404 | 107869 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||||
76617 | 107873 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
88433 | 107871 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||||
171218 | 107868 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | |||||
84271 | 98794 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 950@Washington Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | ||
99627 | 107884 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |||
104181 | 98790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950x CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
114301 | 98806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
122492 | 107885 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |||
153795 | 98792 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 950 Clay St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 5x4 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |
157895 | 98793 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 950x CLAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x6 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
163523 | 107883 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
170083 | 98803 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |
179485 | 98802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | |
77923 | 256355 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
91578 | 97725 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | |||
101801 | 256358 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6005778.11415 | 2120709.05822 | 37.8033889834786 | -122.424218159845 | (37.8033889834786, -122.424218159845) | 5 | 9 | 1 | 28858 | 32 | |||
182487 | 256357 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
192030 | 256356 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
4815 | 98680 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
5845 | 96500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
17099 | 96505 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
21524 | 96504 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
44113 | 96509 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
51837 | 113436 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
55022 | 96512 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
58400 | 113437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
67353 | 98678 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
71171 | 98681 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
71723 | 79386 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2355 Folsom St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10/30/2009 12:00:00 AM | Permit Number 53016 | 6008491.21757684 | 2104497.38565881 | 37.7590284322587 | -122.4136819767 | (37.7590284322587, -122.4136819767) | 2 | 4 | 7 | 28859 | 19 | |||
75897 | 96511 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
78075 | 98679 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
81818 | 96502 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
85919 | 98676 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
87067 | 98675 | Permitted Site 7 | Tree(s) :: 17 | 199X Park St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
87145 | 113435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
88213 | 96513 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
91360 | 110190 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
92761 | 110187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
98851 | 98677 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
100591 | 96499 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
113513 | 96492 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
115599 | 96503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | |||
124180 | 96506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
141407 | 92806 | Permitted Site 7 | Tree(s) :: 17 | 2355 Folsom St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10/30/2009 12:00:00 AM | Permit Number 53016 | 6008199.4 | 2104720.1 | 37.7596235634815 | -122.414706984191 | (37.7596235634815, -122.414706984191) | 2 | 4 | 7 | 28859 | 19 | |||
146063 | 96501 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
152716 | 96497 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
165008 | 98682 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
176122 | 253851 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6008234 | 2102998 | 37.7548970135718 | -122.414465463083 | (37.7548970135718, -122.414465463083) | 2 | 4 | 7 | 28859 | 19 | ||||
189404 | 96510 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
190278 | 96494 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
6926 | 96580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
7701 | 97237 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
21821 | 97236 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
23905 | 96578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
31248 | 96579 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
51808 | 111862 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
60043 | 111861 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
108068 | 107643 | DPW Maintained 1 | Tree(s) :: 17 | 455 ATHENS ST | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 4x4 | 6003769 | 2090659.8 | 37.7207672837341 | -122.429027043999 | (37.7207672837341, -122.429027043999) | 9 | 7 | 6 | 28861 | 5 | ||||
122635 | 96583 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 401x Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | ||||
128118 | 96585 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401x Otsego Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
132862 | 111863 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
166189 | 96581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
172028 | 96582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
180230 | 96584 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
2158 | 95238 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | |||
4591 | 113471 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
8082 | 96598 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
15342 | 113473 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 30 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
18687 | 104158 | DPW Maintained 1 | :: 45 | 525X Church St | 6 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
19875 | 96597 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
31577 | 104151 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
33788 | 96601 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
35006 | 96602 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
43317 | 113469 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
56850 | 98746 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
57036 | 98749 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
61217 | 98752 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
65054 | 113474 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 31 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
67453 | 173941 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3750 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6004590 | 2105440 | 37.7613967828987 | -122.427241380377 | (37.7613967828987, -122.427241380377) | 8 | 4 | 5 | 28862 | 3 | ||||
79291 | 104154 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 |
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) );