Street_Tree_List

Data source: data.sfgov.org

16 rows where DBH = 2 and qSpecies = 98

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, qSiteInfo, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
31687 31687 187056 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 75 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984980.0493 2097557.2924 37.7386245167659 -122.49448192258001 (37.7386245167659, -122.49448192258)
34598 34598 187054 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 73 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984950.4566 2097599.3275 37.738738201883294 -122.494587336532 (37.7387382018833, -122.494587336532)
42436 42436 187055 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 74 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984955.8371 2097567.7171 37.738651723125294 -122.49456640389 (37.7386517231253, -122.49456640389)
47657 47657 184756 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984687.2225 2106057.4022 37.761946341588 -122.496121307582 (37.761946341588, -122.496121307582)
50614 50614 184751 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984675.641 2106097.6525 37.7620561792493 -122.4961643326 (37.7620561792493, -122.4961643326)
52950 52950 185897 Undocumented 2 Shrub :: Shrub 98 2000 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985016.2502 2101239.5934 37.7487372369942 -122.494628152274 (37.7487372369942, -122.494628152274)
57510 57510 182676 Undocumented 2 Shrub :: Shrub 98 1715 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5988712.3482 2103638.8826 37.7555406843938 -122.482022959471 (37.7555406843938, -122.482022959471)
64376 64376 187053 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984954.1557 2097623.876 37.7388058219757 -122.494576356208 (37.7388058219757, -122.494576356208)
79808 79808 37377 Permitted Site 1 Shrub :: Shrub 98 755 Morse St 11 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
84241 84241 37371 Permitted Site 1 Shrub :: Shrub 98 755 Morse St 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
139023 139023 37379 Permitted Site 1 Shrub :: Shrub 98 755 Morse St 13 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
167803 167803 187122 Undocumented 2 Shrub :: Shrub 98 2600 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985165.8082 2097341.5801 37.7380430985113 -122.49382377418101 (37.7380430985113, -122.493823774181)
176597 176597 186340 Undocumented 2 Shrub :: Shrub 98 1801 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984827.0787 2102831.0491 37.7530958632805 -122.495399651332 (37.7530958632805, -122.495399651332)
179154 179154 184750 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984665.0089 2106100.6902 37.7620638971415 -122.496201328503 (37.7620638971415, -122.496201328503)
181183 181183 184754 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984657.4145 2106082.8434 37.762014449980704 -122.496226277389 (37.7620144499807, -122.496226277389)
184478 184478 187025 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984975.6777 2097882.1396 37.7395162040617 -122.494520977899 (37.7395162040617, -122.494520977899)

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