Street_Tree_List

Data source: data.sfgov.org

23 rows where qSiteInfo = 2 and qSpecies = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 23 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25340 25340 199360 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1451 Rhode Island St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     6012046.6036 2101626.2388 37.7513439035983 -122.401183943899 (37.7513439035983, -122.401183943899)
31630 31630 199351 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 875 Vermont St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     6011310.4458099995 2104289.7069599996 37.7586161031593 -122.403917085224 (37.7586161031593, -122.403917085224)
33431 33431 199352 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2201 20th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6011438.777290001 2104618.08684 37.7595249301544 -122.403496357191 (37.7595249301544, -122.403496357191)
33604 33604 206271 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1510 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5993525.3861 2095199.14432 37.7326460476786 -122.46476525891899 (37.7326460476786, -122.464765258919)
39777 39777 199354 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2201 20th St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   6011487.25188 2104620.43012 37.759534071763 -122.403328871935 (37.759534071763, -122.403328871935)
41921 41921 206270 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 301 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 10ft   5993141.97199 2095936.7158400002 37.7346491229581 -122.46614438456801 (37.7346491229581, -122.466144384568)
42087 42087 206272 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 70 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 10ft   5993269.28362 2097133.14802 37.7379415715549 -122.46579112907 (37.7379415715549, -122.46579112907)
44606 44606 206273 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 335 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 10ft   5992818.8463 2096062.89914 37.734976942936 -122.46727070178301 (37.734976942936, -122.467270701783)
52044 52044 199349 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1501 25th St 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6014246.130480001 2101970.67081 37.752412103042104 -122.39360177230199 (37.7524121030421, -122.393601772302)
56783 56783 199353 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2201 20th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   6011453.77249 2104619.23603 37.7595289231366 -122.40344457691499 (37.7595289231366, -122.403444576915)
59093 59093 199361 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1433 Rhode Island St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     6012042.82381 2101683.55055 37.7515010583383 -122.40120104178999 (37.7515010583383, -122.40120104179)
60423 60423 224005 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 900 San Bruno Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15     6011012.17375 2104008.2643 37.7578266557966 -122.40492883511999 (37.7578266557966, -122.40492883512)
74140 74140 199355 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2201 20th St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6011503.64432 2104620.9577599997 37.7595364360688 -122.403272215543 (37.7595364360688, -122.403272215543)
75412 75412 176393 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   6003772.59409 2087534.0234400001 37.712184786677206 -122.42879190044901 (37.7121847866772, -122.428791900449)
129571 129571 206277 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 6ft   5994075.53376 2096720.2997299999 37.73685446745821 -122.46297360255801 (37.7368544674582, -122.462973602558)
133709 133709 176392 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   6003793.19406 2087522.42519 37.712154106300396 -122.428719874622 (37.7121541063004, -122.428719874622)
137222 137222 206278 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 121 Ortega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 2ft   5993596.441240001 2102535.31336 37.7527934164816 -122.46505223798701 (37.7527934164816, -122.465052237987)
153494 153494 199348 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1501 25th St 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6014219.92848 2101970.08813 37.7524090471553 -122.393692343051 (37.7524090471553, -122.393692343051)
158289 158289 206296 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1495 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5993533.84781 2095106.3143799999 37.7323916474557 -122.464729266269 (37.7323916474557, -122.464729266269)
160018 160018 206274 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 130 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 10ft   5992348.03804 2095988.5894400002 37.7347457173231 -122.468893032011 (37.7347457173231, -122.468893032011)
162695 162695 206275 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 531 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   5993329.29471 2096110.62255 37.735137433227294 -122.465509381364 (37.7351374332273, -122.465509381364)
169310 169310 176391 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   6003898.25323 2087460.6657900002 37.711990473755606 -122.42835236038401 (37.7119904737556, -122.428352360384)
171481 171481 224441 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 310 Liberty St 41 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6003891.83885 2103931.1825 37.757214421627395 -122.42954842002399 (37.7572144216274, -122.429548420024)

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