trees

118 rows where Zip Codes = 28862 and qCaretaker_id = 4 sorted by qCareAssistant

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28862 · 18 ✖
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)
185959 102026 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
192623 99547 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Henry St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   24 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 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
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
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
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

CSV options: 

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)
);