Street_Tree_List

Data source: data.sfgov.org

19 rows where qSiteInfo = 9 and qSpecies = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 19 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25829 25829 218789 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 380 Monterey Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30     5999445.613919999 2094740.51345 37.7317263020196 -122.44426470386101 (37.7317263020196, -122.444264703861)
28031 28031 199363 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2001 25th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 8ft   6012400.8175099995 2101833.78107 37.7519335243359 -122.39997359673 (37.7519335243359, -122.39997359673)
28059 28059 206279 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 201 Elk St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 2ft   6000804.900880001 2095895.32742 37.7349746100829 -122.439648143869 (37.7349746100829, -122.439648143869)
39572 39572 247122 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2301 Castro St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6002767.913930001 2098805.6060200003 37.743077097036796 -122.433069184902 (37.7430770970368, -122.433069184902)
40661 40661 199343 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1801 03rd St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 4ft   6015732.2545300005 2106672.58002 37.7654050079639 -122.388790681754 (37.7654050079639, -122.388790681754)
44352 44352 206286 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 199 Elk St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 3ft   6000787.19541 2095992.57825 37.735240630441396 -122.439716327743 (37.7352406304414, -122.439716327743)
49495 49495 224027 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1350 Noe St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     6003197.19524 2100390.33495 37.7474527349542 -122.431697967013 (37.7474527349542, -122.431697967013)
50774 50774 199342 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1801 03rd St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 4ft   6015732.89393 2106644.75831 37.7653286510121 -122.38878652777201 (37.7653286510121, -122.388786527772)
61215 61215 206288 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 199 Elk St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   6000799.22427 2096049.60807 37.735397905697205 -122.439678826929 (37.7353979056972, -122.439678826929)
64809 64809 206287 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 199 Elk St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 3ft   6000792.43269 2096023.23658 37.7353251091687 -122.439700417862 (37.7353251091687, -122.439700417862)
72139 72139 206285 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 201 Elk St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 3ft   6000787.804140001 2095958.5254 37.7351471639001 -122.43971178258002 (37.7351471639001, -122.43971178258)
132361 132361 206283 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 201 Elk St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 2ft   6000785.48714 2095941.8805200001 37.7351013290572 -122.439718600327 (37.7351013290572, -122.439718600327)
149237 149237 206281 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 201 Elk St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 2ft   6000794.7331 2095912.2311 37.735020444925205 -122.439684508859 (37.7350204449252, -122.439684508859)
153651 153651 199341 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 400 Mariposa St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 6ft   6015776.44164 2106315.00515 37.764425633653296 -122.388612884902 (37.7644256336533, -122.388612884902)
154600 154600 224031 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 822 Clayton St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 4ft   5998688.13035 2107403.24761 37.766451833222604 -122.447794742535 (37.7664518332226, -122.447794742535)
176451 176451 199344 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1801 03rd St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 4ft   6015727.94816 2106771.64308 37.7656767749832 -122.38881249299801 (37.7656767749832, -122.388812492998)
181459 181459 206298 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 74 Vista Verde Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 3ft   5999168.51536 2096155.83752 37.735596635183605 -122.445324411018 (37.7355966351836, -122.445324411018)
182494 182494 206282 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 201 Elk St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 2ft   6000786.60453 2095932.3655299998 37.7350752667125 -122.43971405517901 (37.7350752667125, -122.439714055179)
188255 188255 224438 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 177 Powhattan Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   6008219.66372 2098116.4731099997 37.7414926273921 -122.414169698278 (37.7414926273921, -122.414169698278)

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 1681.351ms · Data source: data.sfgov.org