17 rows where Zip Codes = 28857 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

Zip Codes

  • 28857 · 17
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)
11856 107887 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
58584 57790 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950 Clay St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 02/08/1977 12:00:00 AM 15 4x4 Permit Number 768771 6010215.62504 2117204.00661 37.7940145286904 -122.408614505968 (37.7940145286904, -122.408614505968) 3 1 10 28857 4
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
121110 98804 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010297.35863 2117215.00262 37.7940492982967 -122.408332474088 (37.7940492982967, -122.408332474088) 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
130969 116857 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6010080.35093 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981) 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
169090 98805 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010143.10639 2117195.10642 37.793986029186 -122.408864800763 (37.793986029186, -122.408864800763) 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
171481 107886 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 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
188988 98791 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950 Clay St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   1 3x6 Permit Number 768771 6010164.1906 2117196.54488 37.7939911598214 -122.408791948484 (37.7939911598214, -122.408791948484) 3 1 10 28857 4

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