38 rows where DBH = 4 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

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)
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
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
169868 96576 DPW Maintained 1 Quercus coccinea :: Scarlet Oak 134 401x Otsego Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     4     6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
51293 100971 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   4   Permit Number 37341 6009642.5454 2120895.3461 37.8041179253888 -122.410858257388 (37.8041179253888, -122.410858257388) 3 1 10 308 23
90475 234072 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   4 Width 3ft   6011140.67766 2101759.73109 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746) 10 4 8 28859 19
1341 76159 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
5695 77663 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6006674.08558 2093407.54115 37.7284760037541 -122.419179842976 (37.7284760037541, -122.419179842976) 9 3 7 309 5
7708 76081 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
8515 76311 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 299X Cambridge St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 0   6006754.26056 2093151.90933 37.7277786091743 -122.418884550584 (37.7277786091743, -122.418884550584) 9 3 7 309 5
18051 77661 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6006687.82384 2093371.12447 37.7283767851556 -122.419129766951 (37.7283767851556, -122.419129766951) 9 3 7 309 5
18509 76705 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6003030.53484 2092605.75448 37.7260686121528 -122.431718554264 (37.7260686121528, -122.431718554264) 9 7 6 28861 5
26495 42983 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2X Yale St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 4 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
57109 102194 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
70160 95470 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 539X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   5986557.7 2112257.8 37.7790802775989 -122.490108236864 (37.7790802775989, -122.490108236864) 11 6 2 55 26
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
76451 77217 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 21 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
84709 99338 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 450 30th Ave 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3X3   5986576.26956 2112967.74794 37.7810306764919 -122.490096232309 (37.7810306764919, -122.490096232309) 11 6 2 55 26
86443 76019 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
89171 77219 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 23 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
90903 77212 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 19 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
97154 70472 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 450X Banks St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 4 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
110143 99327 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   5986588.01582 2112673.64698 37.7802238451734 -122.490033958427 (37.7802238451734, -122.490033958427) 11 6 2 55 26
123461 99334 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 450 30th Ave 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   5986579.77919 2112870.79018 37.7807646631349 -122.490076957163 (37.7807646631349, -122.490076957163) 11 6 2 55 26
127608 76051 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
132081 42984 DPW Maintained 1 Tree(s) :: 17 2X Yale St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/05/2000 12:00:00 AM 4 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
134117 95467 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 533X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   5986556.1 2112298 37.7791905619119 -122.490116729573 (37.7791905619119, -122.490116729573) 11 6 2 55 26
136087 30737 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 490X Page St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/05/2000 12:00:00 AM 4 3x3 Permit Number 42884 6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
147370 116046 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 650x Kansas St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 5x15   6011495.20108 2105434.89797 37.7617708628477 -122.40335867726 (37.7617708628477, -122.40335867726) 10 3 8 28856 29
153204 81998 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 4 3x3 Permit Number 50638 6005939.39797 2120724.94139 37.8034416999448 -122.42366116025 (37.8034416999448, -122.42366116025) 5 9 1 28858 32
153739 77206 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
159694 76205 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
165795 95471 DPW Maintained 1 Olea europaea :: Olive Tree 9 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   5986558.17112 2112222.97674 37.778984690357 -122.49010404497 (37.778984690357, -122.49010404497) 11 6 2 55 26
167966 76185 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
169903 130257 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2213 Jones St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 Width 5ft   6008055.23608 2120086.84866 37.8018088638398 -122.416293973386 (37.8018088638398, -122.416293973386) 5 1 10 308 32
173163 97729 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3 Permit Number 50638 6005819.00921 2120706.70735 37.8033848375917 -122.424076473471 (37.8033848375917, -122.424076473471) 5 9 1 28858 32
188131 97727 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3 Permit Number 50638 6005898.3389 2120719.31411 37.8034239311172 -122.423802846647 (37.8034239311172, -122.423802846647) 5 9 1 28858 32
191362 97733 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3 Permit Number 50638 6005736.8865 2120695.23683 37.8033487055393 -122.424359846228 (37.8033487055393, -122.424359846228) 5 9 1 28858 32
192959 76112 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10

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