31 rows where qSpecies_id = 384 sorted by qSiteInfo

View and edit SQL

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)
22592 245815 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 92 Front Yard : Yard Tree Private 2     8     6004991.22077 2096914.75844 37.7380111224129 -122.425247062517 (37.7380111224129, -122.425247062517) 2 7 5 63 7
42493 245814 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 48 Front Yard : Yard Tree Private 2     10     6005138.21189 2097118.38559 37.7385785397582 -122.424753323004 (37.7385785397582, -122.424753323004) 2 7 5 28859 7
55500 245818 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 95 Front Yard : Yard Tree Private 2     15     6004977.00826 2096882.72633 37.7379223665264 -122.42529392347 (37.7379223665264, -122.42529392347) 2 7 5 63 7
56294 245819 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 96 Front Yard : Yard Tree Private 2     16     6004972.44653 2096874.30966 37.7378989985293 -122.425309096855 (37.7378989985293, -122.425309096855) 2 7 5 63 7
79871 245813 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 47 Front Yard : Yard Tree Private 2     13     6005140.34889 2097123.40459 37.7385924414978 -122.424746291228 (37.7385924414978, -122.424746291228) 2 7 5 28859 7
87415 245810 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 44 Front Yard : Yard Tree Private 2     10     6005122.10608 2097126.31099 37.7385993914497 -122.424809572906 (37.7385993914497, -122.424809572906) 2 7 5 28859 7
110930 245809 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 43 Front Yard : Yard Tree Private 2     13     6005116.45422 2097135.79328 37.7386251084509 -122.424829788766 (37.7386251084509, -122.424829788766) 2 7 5 28859 7
113681 245816 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 93 Front Yard : Yard Tree Private 2     7     6004985.63853 2096904.07268 37.7379814663592 -122.425265602924 (37.7379814663592, -122.425265602924) 2 7 5 63 7
122374 245817 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 94 Front Yard : Yard Tree Private 2     32     6004980.52596 2096892.52372 37.7379494666842 -122.425282458027 (37.7379494666842, -122.425282458027) 2 7 5 63 7
138042 245811 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 45 Front Yard : Yard Tree Private 2     13     6005130.64633 2097121.32587 37.7385861857983 -122.424779690228 (37.7385861857983, -122.424779690228) 2 7 5 28859 7
147672 245808 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 9 Front Yard : Yard Tree Private 2     13     6005180.88138 2097324.81377 37.7391477548528 -122.424620472474 (37.7391477548528, -122.424620472474) 2 7 5 28859 7
161087 245820 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 97 Front Yard : Yard Tree Private 2     5     6004968.56772 2096865.41877 37.7378743670117 -122.425321875304 (37.7378743670117, -122.425321875304) 2 7 5 63 7
177989 245807 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 10 Front Yard : Yard Tree Private 2     8     6005192.84827 2097397.66927 37.7393484754449 -122.42458427745 (37.7393484754449, -122.42458427745) 2 7 5 28859 7
191359 245812 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 46 Front Yard : Yard Tree Private 2     13     6005133.84129 2097128.34789 37.7386056471346 -122.424769142989 (37.7386056471346, -122.424769142989) 2 7 5 28859 7
31684 15331 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1700X Mission St 3 Median : Cutout Tree DPW 1     12 4X4   6006725.71304 2108437.22279 37.7697470004467 -122.42006753591 (37.7697470004467, -122.42006753591) 8 4 7 28853 19
100547 15329 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1700X Mission St 1 Median : Cutout Tree DPW 1     12 4X4   6006717.7369932 2108570.5208478 37.7701125558687 -122.420104586186 (37.7701125558687, -122.420104586186) 8 4 7 28853 19
140022 15332 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1700X Mission St 4 Median : Cutout Tree DPW 1     12 4X4   6006723.99669 2108411.90123 37.7696773767498 -122.420071675471 (37.7696773767498, -122.420071675471) 8 4 7 28853 19
144738 15330 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1700X Mission St 2 Median : Cutout Tree DPW 1     12 4X4   6006727.83912 2108452.72313 37.769789680489 -122.420061282012 (37.769789680489, -122.420061282012) 8 4 7 28853 19
162016 13409 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 364 Marietta Dr 2 Median : Cutout Tree DPW 1     100 5   5999660.108164 2097381.7238333 37.7389906787724 -122.443712833155 (37.7389906787724, -122.443712833155) 9 7 4 59 40
173295 15333 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1700X Mission St 5 Median : Cutout Tree DPW 1     12 4X4   6006720.95157 2108390.0555 37.7696172219899 -122.420080657908 (37.7696172219899, -122.420080657908) 8 4 7 28853 19
52322 121200 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 423 18th Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5990242 2112483 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216) 11 6 2 55 26
70939 113392 Permitted Site 7 Corymbia citriodora :: Lemon Scented Gum 384 2741 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991774.5 2096885.7 37.7371758034866 -122.470941261472 (37.7371758034866, -122.470941261472) 1 8 4 29491 40
134710 112622 Undocumented 4 Corymbia citriodora :: Lemon Scented Gum 384 226x HESTER AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012667 2087636 37.7129641948773 -122.398057164184 (37.7129641948773, -122.398057164184) 10 3 8 309 1
155589 9296 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 135X Mansell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6011497.3933158 2090592.5284866 37.7210170109869 -122.40230748066 (37.7210170109869, -122.40230748066) 10 7 8 309 28
160521 102185 Undocumented 4 Corymbia citriodora :: Lemon Scented Gum 384 1840X Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003534.8 2115143.2 37.7879796472282 -122.431583632877 (37.7879796472282, -122.431583632877) 13 9 11 29490 27
76346 245822 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 100 Alemany Blvd 33 Sidewalk: Curb side : Yard Tree Private 2     5     6009164.14819 2095772.28813 37.7351090101588 -122.410738469925 (37.7351090101588, -122.410738469925) 10 7 7 28859 2
126114 245821 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 100 Alemany Blvd 32 Sidewalk: Curb side : Yard Tree Private 2     12     6009177.83151 2095781.65672 37.7351355014861 -122.410691822979 (37.7351355014861, -122.410691822979) 10 7 7 28859 2
173372 245823 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 100 Alemany Blvd 34 Sidewalk: Curb side : Yard Tree Private 2     7     6009152.02942 2095785.20865 37.7351438076288 -122.41078128124 (37.7351438076288, -122.41078128124) 10 7 7 28859 2
53340 24613 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1735 Mission St 1 Sidewalk: Property side : Cutout Tree DPW 1     24 6x7   6006758.73918 2108085.91697 37.7687842586517 -122.419928366315 (37.7687842586517, -122.419928366315) 8 4 7 28853 19
19491 260088 Undocumented 4 Corymbia citriodora :: Lemon Scented Gum 384 1100 Oakdale Ave 1 Sidewalk: Property side : Yard Tree Private 2       15x5   6017813 2093492 37.7293289240284 -122.380677509991 (37.7293289240284, -122.380677509991) 10 3 8 58 1
109274 126133 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 2600 Richardson Ave 1 Sidewalk: Property side : Yard Tree Private 2     9     5999007.61362 2119788.17204 37.8004758644149 -122.447581314529 (37.8004758644149, -122.447581314529) 13 9 1 57 17

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