53 rows where qLegalStatus_id = 6 and qSiteInfo = "Sidewalk: Curb side : Yard" sorted by qCareAssistant

View and edit SQL

qSiteInfo

  • Sidewalk: Curb side : Yard · 53
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)
891 207770 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 40 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft   5993240.61068 2097284.1687 37.7383545825079 -122.465901234858 (37.7383545825079, -122.465901234858) 1 8 4 59 40
5712 258876 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1326 Hayes St 1 Sidewalk: Curb side : Yard Tree Private 2       Width 0ft   6001504 2110473 37.7750411502564 -122.438275119801 (37.7750411502564, -122.438275119801) 15 5 11 29492 10
9862 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
13120 258703 Significant Tree 6 Tree(s) :: 17 131X Juan Bautista Cir 2 Sidewalk: Curb side : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
15674 258702 Significant Tree 6 Tree(s) :: 17 131X Juan Bautista Cir 1 Sidewalk: Curb side : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
16781 260951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 190 Jackson St 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   6013038 2118237 37.7970085486816 -122.398921272101 (37.7970085486816, -122.398921272101) 3 1 10 28860 6
17188 260389 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2       10x6   5993303.46118 2096918.61416 37.7373544866644 -122.465657379584 (37.7373544866644, -122.465657379584) 1 8 4 59 40
19388 114226 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 2 Sidewalk: Curb side : Yard Tree Private 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
21096 253953 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 11X Ravenwood Dr 2 Sidewalk: Curb side : Yard Tree Private 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 40
21577 114229 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 5 Sidewalk: Curb side : Yard Tree Private 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
23985 114387 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 417x ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     7     5988152 2090574 37.7196353223366 -122.483003277928 (37.7196353223366, -122.483003277928) 1 8 4 64 14
27121 114234 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 10 Sidewalk: Curb side : Yard Tree Private 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
30455 114232 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 8 Sidewalk: Curb side : Yard Tree Private 2     15     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
38129 114239 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard Tree Private 2     28     5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
41877 114072 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 454 ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     4     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
44052 114240 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 16 Sidewalk: Curb side : Yard Tree Private 2           5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
44804 114228 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 4 Sidewalk: Curb side : Yard Tree Private 2     7     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
46153 209002 Significant Tree 6 Tree(s) :: 17 115 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/17/2018 12:00:00 AM 3 Width 4ft Permit Number 781950 5994125 2096751 37.7369416119865 -122.462804803775 (37.7369416119865, -122.462804803775) 9 8 4 59 40
51737 116458 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 777 Brotherhood Way 1 Sidewalk: Curb side : Yard Tree Private 2     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327) 1 8 4 64 14
59395 114525 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
62078 114235 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 11 Sidewalk: Curb side : Yard Tree Private 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
62177 99097 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Santa Monica Way 1 Sidewalk: Curb side : Yard Tree Private 2           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094) 9 8 4 59 40
62334 87240 Significant Tree 6 Tree(s) :: 17 233 Arbor St 2 Sidewalk: Curb side : Yard Tree Private 2   02/14/2008 12:00:00 AM     Permit Number 50269 6001330 2096776 37.7374226054152 -122.437895752709 (37.7374226054152, -122.437895752709) 2 7 5 63 7
63542 116459 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 777 Brotherhood Way 2 Sidewalk: Curb side : Yard Tree Private 2     20 10x20 Permit Number 777772 5989848.42836 2088633.83291 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287) 1 8 4 64 14
90315 112398 Significant Tree 6 Myoporum laetum :: Myoporum 62 246 CRESCENT AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6006552 2095759 37.7349257177289 -122.419768681192 (37.7349257177289, -122.419768681192) 2 7 7 28859 2
91742 114074 Significant Tree 6 Betula pendula :: European White Birch 253 18x HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     5     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
92381 116164 Significant Tree 6 Juniperus chinensis :: Juniper 113 2411 OCTAVIA ST 1 Sidewalk: Curb side : Yard Tree Private 2     13 15x4   6004495 2117637 37.7948813682629 -122.428439330772 (37.7948813682629, -122.428439330772) 13 9 1 28858 27
97189 114476 Significant Tree 6 Pittosporum spp :: Pittosporum spp 170 299x UNION ST 1 Sidewalk: Curb side : Yard Tree Private 2   12/29/2015 12:00:00 AM       6011527 2119680 37.8008863659875 -122.40425133897 (37.8008863659875, -122.40425133897) 3 1 10 308 23
104567 254405 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 321 Lexington St 2 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   6006540.69106 2104208.04068 37.7581242333638 -122.420407294379 (37.7581242333638, -122.420407294379) 2 4 7 28859 19
104794 115276 Significant Tree 6 Pinus radiata :: Monterey Pine 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 4 59 40
106956 251495 Significant Tree 6 Tree(s) :: 17 2448 Clay St 1 Sidewalk: Curb side : Yard Tree Private 2   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026 2116224 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488) 13 9 1 29490 27
109646 114230 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 6 Sidewalk: Curb side : Yard Tree Private 2     30     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
110540 253952 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 11X Ravenwood Dr 1 Sidewalk: Curb side : Yard Tree Private 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 40
119122 251575 Significant Tree 6 Pinus radiata :: Monterey Pine 15 300 Sussex St 1 Sidewalk: Curb side : Yard Tree Private 2   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194 2096647 37.7370606668352 -122.438356728037 (37.7370606668352, -122.438356728037) 2 7 5 63 7
123466 254110 Significant Tree 6 Tree(s) :: 17 100 Cerritos Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/04/2018 12:00:00 AM 3 10x10 Permit Number 781003 5992103 2092952 37.7263938396388 -122.469519230239 (37.7263938396388, -122.469519230239) 9 8 4 59 40
125282 110236 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100 BUCHANAN ST 1 Sidewalk: Curb side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.7712187378523 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
126287 114225 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 1 Sidewalk: Curb side : Yard Tree Private 2     48     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
127746 120952 Significant Tree 6 Tree(s) :: 17 100X 32nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2   08/30/2016 12:00:00 AM 3 10x10 Permit Number 778529 5985781 2114962 37.7864598433405 -122.492994369609 (37.7864598433405, -122.492994369609) 11 6 1 55 33
128045 114227 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 3 Sidewalk: Curb side : Yard Tree Private 2     16     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
134725 187654 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 375 Woodside Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
137836 208971 Significant Tree 6 Tree(s) :: 17 150 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   12/18/2018 12:00:00 AM 3 Width 6ft Permit Number 782070 5994318.90627 2096521.25566 37.7363219572757 -122.462117732164 (37.7363219572757, -122.462117732164) 9 8 4 59 40
141272 114231 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 7 Sidewalk: Curb side : Yard Tree Private 2     10     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
141906 114383 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 418X SERRANO DR 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
145907 187657 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2072 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5991666 2101424 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446) 1 8 4 29491 12
154745 114237 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 13 Sidewalk: Curb side : Yard Tree Private 2     14     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
161250 114073 Significant Tree 6 Betula pendula :: European White Birch 253 18x HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
162406 255994 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 179 Retiro Way 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   6001908 2121813 37.8062008335618 -122.437689923584 (37.8062008335618, -122.437689923584) 13 9 1 57 17
173544 114236 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 12 Sidewalk: Curb side : Yard Tree Private 2     22     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
179418 114233 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 9 Sidewalk: Curb side : Yard Tree Private 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
182689 108589 Significant Tree 6 Tree(s) :: 17 1139x HUDSON AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6017760 2094672 37.7325660477977 -122.380942739781 (37.7325660477977, -122.380942739781) 10 3 8 58 1
185977 114238 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 14 Sidewalk: Curb side : Yard Tree Private 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
193743 211099 Significant Tree 6 Tree(s) :: 17 501 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2   05/18/2018 12:00:00 AM 3 10x10 Permit Number 781418 5993137.63738 2096084.35497 37.7350542531473 -122.466170096172 (37.7350542531473, -122.466170096172) 1 8 4 59 40
1875 261661 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 741 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2 FUF         5986614 2110873 37.7752812973329 -122.489811603249 (37.7752812973329, -122.489811603249) 11 6 2 55 26

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