Street_Tree_List

Data source: data.sfgov.org

12 rows where DBH = 2 and qSpecies = 73

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
18980 18980 5478 Permitted Site 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 655 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/2013 12:00:00 AM 2 3X3   6005024.7062 2104455.06021 37.7587169450524 -122.42566780763501 (37.7587169450524, -122.425667807635)
25091 25091 230419 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1301 San Jose Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003538.9746900005 2095464.77113 37.733947636477396 -122.430164781185 (37.7339476364774, -122.430164781185)
37325 37325 193426 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 807 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6015414.46793 2103902.8500099997 37.7577823075377 -122.389696374594 (37.7577823075377, -122.389696374594)
49040 49040 230420 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 143 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6005428.8647300005 2102882.34915 37.7544214771723 -122.424158193041 (37.7544214771723, -122.424158193041)
53201 53201 230399 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 635 Potrero Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6010446.039030001 2105294.43136 37.761326519519 -122.406977425991 (37.761326519519, -122.406977425991)
61485 61485 230422 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 387 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007833.76172 2105654.7259299997 37.7621692805159 -122.41603773676901 (37.7621692805159, -122.416037736769)
74087 74087 230423 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 387 Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007832.95914 2105672.86461 37.7622190400112 -122.416041797198 (37.7622190400112, -122.416041797198)
76597 76597 46980 Permitted Site 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1310 Minnesota St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/2002 12:00:00 AM 2   Permit Number 44998 6015320.4365300005 2102435.8456200003 37.7537490109239 -122.38991910430799 (37.7537490109239, -122.389919104308)
132389 132389 46977 Permitted Site 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1310 Minnesota St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/2002 12:00:00 AM 2   Permit Number 44998 6015323.660209999 2102361.18474 37.7535441867291 -122.38990274114201 (37.7535441867291, -122.389902741142)
137569 137569 177457 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1651 San Jose Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001558.284440001 2094165.3004599998 37.730267205960295 -122.436919623235 (37.7302672059603, -122.436919623235)
160052 160052 230400 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 898 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6010432.2870000005 2104046.5208099997 37.7578992679501 -122.406937031143 (37.7578992679501, -122.406937031143)
189134 189134 230425 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 70 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6001023.25881 2106016.57579 37.762777563946294 -122.439618557053 (37.7627775639463, -122.439618557053)

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