trees
49 rows where qCareAssistant = "FUF" and qCaretaker_id = 4 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67548 | 108784 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005634.22998 | 2088024.32377 | 37.7136362375916 | -122.422392346349 | (37.7136362375916, -122.422392346349) | 9 | 7 | 8 | 309 | 18 |
70634 | 108779 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 2055 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005562.18075 | 2088048.73923 | 37.7136992126121 | -122.422643108799 | (37.7136992126121, -122.422643108799) | 9 | 7 | 8 | 309 | 18 |
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 | ||||
130378 | 108783 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 2055 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005623.18894 | 2088028.75541 | 37.7136477830893 | -122.422430822919 | (37.7136477830893, -122.422430822919) | 9 | 7 | 8 | 309 | 18 |
163683 | 108781 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 2055 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005591.90568 | 2088038.18998 | 37.7136719236049 | -122.422539619323 | (37.7136719236049, -122.422539619323) | 9 | 7 | 8 | 309 | 18 |
185247 | 108782 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005606.4158 | 2088034.4515 | 37.713662477117 | -122.422489201534 | (37.713662477117, -122.422489201534) | 9 | 7 | 8 | 309 | 18 |
5747 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
7373 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
13082 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
41336 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
54868 | 96570 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
57870 | 96483 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
72268 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
78450 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
99609 | 96481 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
101013 | 94947 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
103743 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
124067 | 96482 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
130983 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
135218 | 94946 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
135340 | 96571 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
170438 | 96480 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
13279 | 108789 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
48321 | 108786 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
68022 | 108785 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
107282 | 108787 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
148959 | 108780 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6006878.58529 | 2087505.45215 | 37.7122816418905 | -122.418054633195 | (37.7122816418905, -122.418054633195) | 9 | 7 | 8 | 309 | 39 |
187308 | 108788 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
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 | |||
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 | |||||
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 | |||||
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 | |||
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 | |||||
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 | |||||
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 | |||||
81530 | 96594 | 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 | |||||
106561 | 97238 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 |
120469 | 96606 | 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 | |||||
136541 | 96599 | 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 | |||||
138264 | 96604 | 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 | |||||
142618 | 96600 | 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 | |||||
145479 | 96592 | 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 | |||||
156111 | 96589 | 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 | |||||
184992 | 96603 | 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 | |||||
186894 | 96605 | 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 |
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) );