Street_Tree_List

Data source: data.sfgov.org

30 rows where qSpecies = 301

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
17557 15331 DPW Maintained 3 Corymbia citriodora :: Lemon Scented Gum 301 1700X Mission St 3 Median : Cutout 11 Tree 1 DPW 2     12 4X4   6006725.71304 2108437.22279 37.7697470004467 -122.42006753591002 (37.7697470004467, -122.42006753591)
21011 15332 DPW Maintained 3 Corymbia citriodora :: Lemon Scented Gum 301 1700X Mission St 4 Median : Cutout 11 Tree 1 DPW 2     12 4X4   6006723.99669 2108411.90123 37.7696773767498 -122.42007167547101 (37.7696773767498, -122.420071675471)
21095 15330 DPW Maintained 3 Corymbia citriodora :: Lemon Scented Gum 301 1700X Mission St 2 Median : Cutout 11 Tree 1 DPW 2     12 4X4   6006727.83912 2108452.72313 37.769789680489 -122.420061282012 (37.769789680489, -122.420061282012)
21983 15333 DPW Maintained 3 Corymbia citriodora :: Lemon Scented Gum 301 1700X Mission St 5 Median : Cutout 11 Tree 1 DPW 2     12 4X4   6006720.95157 2108390.0555 37.7696172219899 -122.420080657908 (37.7696172219899, -122.420080657908)
25070 245815 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 92 Front Yard : Yard 7 Tree 1 Private 1     8     6004991.22077 2096914.7584400002 37.7380111224129 -122.42524706251699 (37.7380111224129, -122.425247062517)
36346 245812 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 46 Front Yard : Yard 7 Tree 1 Private 1     13     6005133.84129 2097128.34789 37.7386056471346 -122.424769142989 (37.7386056471346, -122.424769142989)
42717 245818 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 95 Front Yard : Yard 7 Tree 1 Private 1     15     6004977.00826 2096882.72633 37.7379223665264 -122.42529392347001 (37.7379223665264, -122.42529392347)
67350 245811 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 45 Front Yard : Yard 7 Tree 1 Private 1     13     6005130.64633 2097121.32587 37.7385861857983 -122.42477969022801 (37.7385861857983, -122.424779690228)
69233 245809 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 43 Front Yard : Yard 7 Tree 1 Private 1     13     6005116.45422 2097135.7932799999 37.7386251084509 -122.424829788766 (37.7386251084509, -122.424829788766)
80242 24613 DPW Maintained 3 Corymbia citriodora :: Lemon Scented Gum 301 1735 Mission St 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     24 6x7   6006758.7391800005 2108085.91697 37.768784258651706 -122.419928366315 (37.7687842586517, -122.419928366315)
86377 113392 Permitted Site 1 Corymbia citriodora :: Lemon Scented Gum 301 2741 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991774.5 2096885.7 37.7371758034866 -122.47094126147199 (37.7371758034866, -122.470941261472)
103149 15329 DPW Maintained 3 Corymbia citriodora :: Lemon Scented Gum 301 1700X Mission St 1 Median : Cutout 11 Tree 1 DPW 2     12 4X4   6006717.7369932 2108570.5208478 37.7701125558687 -122.42010458618601 (37.7701125558687, -122.420104586186)
111743 112622 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 226x HESTER AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6012667.0 2087636.0 37.712964194877294 -122.398057164184 (37.7129641948773, -122.398057164184)
118001 13409 DPW Maintained 3 Corymbia citriodora :: Lemon Scented Gum 301 364 Marietta Dr 2 Median : Cutout 11 Tree 1 DPW 2     100 5   5999660.108164 2097381.7238333 37.738990678772396 -122.443712833155 (37.7389906787724, -122.443712833155)
118910 102185 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1840X Webster St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6003534.8 2115143.2 37.787979647228205 -122.43158363287701 (37.7879796472282, -122.431583632877)
121316 9296 DPW Maintained 3 Corymbia citriodora :: Lemon Scented Gum 301 135X Mansell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6011497.3933157995 2090592.5284866001 37.7210170109869 -122.40230748066001 (37.7210170109869, -122.40230748066)
124657 121200 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 423 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5990242.0 2112483.0 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216)
130875 245816 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 93 Front Yard : Yard 7 Tree 1 Private 1     7     6004985.63853 2096904.07268 37.73798146635921 -122.425265602924 (37.7379814663592, -122.425265602924)
137152 245822 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 100 Alemany Blvd 33 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6009164.14819 2095772.28813 37.735109010158794 -122.41073846992501 (37.7351090101588, -122.410738469925)
149603 245819 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 96 Front Yard : Yard 7 Tree 1 Private 1     16     6004972.44653 2096874.3096599998 37.737898998529296 -122.42530909685499 (37.7378989985293, -122.425309096855)
153695 245823 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 100 Alemany Blvd 34 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6009152.02942 2095785.20865 37.7351438076288 -122.41078128123999 (37.7351438076288, -122.41078128124)
155151 245807 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 10 Front Yard : Yard 7 Tree 1 Private 1     8     6005192.84827 2097397.66927 37.7393484754449 -122.42458427745001 (37.7393484754449, -122.42458427745)
158903 245820 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 97 Front Yard : Yard 7 Tree 1 Private 1     5     6004968.56772 2096865.41877 37.737874367011706 -122.425321875304 (37.7378743670117, -122.425321875304)
163240 126133 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 2600 Richardson Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     5999007.61362 2119788.17204 37.8004758644149 -122.447581314529 (37.8004758644149, -122.447581314529)
167344 245814 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 48 Front Yard : Yard 7 Tree 1 Private 1     10     6005138.21189 2097118.38559 37.73857853975821 -122.424753323004 (37.7385785397582, -122.424753323004)
171669 245813 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 47 Front Yard : Yard 7 Tree 1 Private 1     13     6005140.34889 2097123.4045900002 37.7385924414978 -122.424746291228 (37.7385924414978, -122.424746291228)
176435 245808 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 9 Front Yard : Yard 7 Tree 1 Private 1     13     6005180.88138 2097324.81377 37.739147754852794 -122.424620472474 (37.7391477548528, -122.424620472474)
182535 245821 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 100 Alemany Blvd 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6009177.83151 2095781.65672 37.7351355014861 -122.41069182297899 (37.7351355014861, -122.410691822979)
186419 245810 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 44 Front Yard : Yard 7 Tree 1 Private 1     10     6005122.10608 2097126.3109900001 37.7385993914497 -122.424809572906 (37.7385993914497, -122.424809572906)
188089 245817 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 1000 San Jose Ave 94 Front Yard : Yard 7 Tree 1 Private 1     32     6004980.52596 2096892.5237200002 37.737949466684206 -122.425282458027 (37.7379494666842, -122.425282458027)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 42.126ms · Data source: data.sfgov.org