41 rows where Zip Codes = 56 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

Zip Codes

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)
42731 115967 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     4 3x3   5986812.8086 2104676.4366 37.7582788637421 -122.488668327875 (37.7582788637421, -122.488668327875) 1 8 3 56 35
49723 115970 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30TH AVE 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     0 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
52455 117257 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1570 31ST AVE 5 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
57689 117255 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
81017 117256 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
91388 105784 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
92249 115964 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30TH AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
148752 115965 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 3x3   5986811.649 2104744.2782 37.7584650705211 -122.488677324697 (37.7584650705211, -122.488677324697) 1 8 3 56 35
152290 115971 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4     4 3x3   5986813.9683 2104572.6448 37.757993947556 -122.488656688385 (37.757993947556, -122.488656688385) 1 8 3 56 35
156729 115973 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30TH AVE 10 Sidewalk: Curb side : Cutout Tree SFUSD 4     0 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
167675 115968 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5986813.3885 2104648.6042 37.7582024774349 -122.488664276638 (37.7582024774349, -122.488664276638) 1 8 3 56 35
170193 115966 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5986811.649 2104717.0256 37.7583902423484 -122.488675321582 (37.7583902423484, -122.488675321582) 1 8 3 56 35
178733 115972 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 3x3   5986817.4474 2104547.1317 37.7579240985888 -122.488642781125 (37.7579240985888, -122.488642781125) 1 8 3 56 35
178792 115969 DPW Maintained 1 Olea europaea :: Olive Tree 9 1599x 30th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5986813.3885 2104627.15 37.7581435700771 -122.488662699732 (37.7581435700771, -122.488662699732) 1 8 3 56 35
2028 76748 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 1501X 42nd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   7 3x12   5983093.5463 2104693.1195 37.7581069307926 -122.501532189631 (37.7581069307926, -122.501532189631) 1 8 3 56 35
3628 76755 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501X 42nd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x12   5983093.5463 2104662.8676 37.758023867602 -122.501529951702 (37.758023867602, -122.501529951702) 1 8 3 56 35
5610 46958 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
5633 76756 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501X 42nd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406) 1 8 3 56 35
11170 76785 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1501X 42nd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   24 3x12   5983097.8243 2104541.5546 37.75769102754 -122.501506182606 (37.75769102754, -122.501506182606) 1 8 3 56 35
14697 76382 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1501X 42nd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   25 3x12   5983091.4072 2104771.8049 37.7583228530818 -122.501545408351 (37.7583228530818, -122.501545408351) 1 8 3 56 35
18929 76784 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1501X 42nd Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   1 3x12   5983097.2131 2104562.028 37.7577472058325 -122.501509810878 (37.7577472058325, -122.501509810878) 1 8 3 56 35
58717 46964 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
59100 46948 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 3 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
63621 46967 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
65075 76344 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 12 3x30   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
70695 46953 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
72358 46950 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
75380 46955 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 4 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
78188 46960 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
79799 46957 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
81039 46962 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
87699 76252 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
87796 76222 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
97962 46965 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
104330 46952 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
155449 46966 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
157174 46961 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
162635 46949 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
167652 46951 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
171291 76271 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
189611 76325 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35

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