Street_Tree_List

Data source: data.sfgov.org

28 rows where SiteOrder = 2 and qSpecies = 96

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus ✖

SiteOrder ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
114263 114263 18659 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 7 Richards Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6016312.43294 2095882.6817 37.7358103329414 -122.386031740711 (37.7358103329414, -122.386031740711)
124276 124276 110389 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 601X JOOST AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
131717 131717 239141 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 479 Andover St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007510.966109999 2096684.13991 37.73751992438871 -122.416518701402 (37.7375199243887, -122.416518701402)
134167 134167 213864 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 141 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992921.67848 2098165.7497799997 37.740756778702504 -122.467068013472 (37.7407567787025, -122.467068013472)
139919 139919 103333 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 243 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001783.9 2108958.2 37.7708978028329 -122.43719840332399 (37.7708978028329, -122.437198403324)
141020 141020 103331 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1600X McAllister St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001400.4 2111522.1 37.7779158216762 -122.438708684362 (37.7779158216762, -122.438708684362)
141148 141148 16008 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 100X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   04/06/1998 12:00:00 AM 12 8   6001411.931226401 2094682.0759854 37.7316778334432 -122.437462576871 (37.7316778334432, -122.437462576871)
155587 155587 213869 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 119 Madrone Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992750.5547 2098352.69692 37.74126020928 -122.467673282394 (37.74126020928, -122.467673282394)
160763 160763 239131 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 62 Woodland Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997117.0518 2106149.37077 37.762919085762796 -122.45313826323799 (37.7629190857628, -122.453138263238)
166454 166454 241396 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 952 Hampshire St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6010191.29772 2103654.4580900003 37.7568092635594 -122.407742832678 (37.7568092635594, -122.407742832678)
167714 167714 213886 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1032 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5990730.33666 2102492.76003 37.7525108935626 -122.4749605429 (37.7525108935626, -122.4749605429)
177111 177111 213905 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1434 Plymouth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5995905.10598 2093569.6319099998 37.72830871277029 -122.456420245524 (37.7283087127703, -122.456420245524)
180454 180454 241397 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 132 Grattan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5997957.14127 2106523.41576 37.7639942306689 -122.45025966195 (37.7639942306689, -122.45025966195)
180476 180476 213897 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 2365 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5992305.54148 2099333.17505 37.7439266478918 -122.46928331439399 (37.7439266478918, -122.469283314394)
187001 187001 213867 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 149 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992890.5132 2098130.93383 37.7406593839363 -122.467173239557 (37.7406593839363, -122.467173239557)

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