Street_Tree_List

Data source: data.sfgov.org

15 rows where DBH = 2 and qSpecies = 13

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28737 28737 92295 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1372 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2009 12:00:00 AM 2 3x3 Permit Number 52740 5989296.944 2106014.5102 37.762097501928295 -122.480175128724 (37.7620975019283, -122.480175128724)
31901 31901 200087 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2260 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014672.5559 2092688.6734 37.7269493390436 -122.391478260518 (37.7269493390436, -122.391478260518)
35328 35328 200091 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2230 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014724.5498 2092764.8713 37.7271614489349 -122.39130384140199 (37.7271614489349, -122.391303841402)
36043 36043 200090 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2250 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014714.6889 2092749.6317 37.7271190567752 -122.391336865844 (37.7271190567752, -122.391336865844)
39960 39960 186401 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1801 Sunset Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984842.4701 2102334.3496 37.7517329643959 -122.495309798203 (37.7517329643959, -122.495309798203)
40453 40453 92325 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 1451 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2009 12:00:00 AM 2 3x3 Permit Number 52757 5987103.8402 2105396.114 37.760271879713294 -122.487714698332 (37.7602718797133, -122.487714698332)
42113 42113 200095 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2220 Keith St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014767.5792 2092826.7261 37.727333677806 -122.391159409685 (37.727333677806, -122.391159409685)
52707 52707 200089 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2260 Keith St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014698.5528 2092729.0135 37.7270615477685 -122.39139120786301 (37.7270615477685, -122.391391207863)
59017 59017 200092 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2220 Keith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014736.2036 2092780.1109 37.727203940586904 -122.391264618831 (37.7272039405869, -122.391264618831)
59641 59641 182398 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1539 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5988985.656 2104841.7909999997 37.7588594394433 -122.481165865952 (37.7588594394433, -122.481165865952)
69983 69983 200088 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2260 Keith St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014685.1061 2092710.1881 37.72700911067479 -122.39143637779101 (37.7270091106748, -122.391436377791)
78718 78718 113143 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 1375 NORIEGA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   5989767.0 2103093.0 37.7541031181361 -122.478335773286 (37.7541031181361, -122.478335773286)
137026 137026 200094 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2220 Keith St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014757.7183 2092808.7972 37.727283901408896 -122.391192246384 (37.7272839014089, -122.391192246384)
143476 143476 122686 Planning Code 138.1 required 4 Podocarpus gracilor :: Fern Pine 13 3474 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6005720.0 2106109.0 37.7632975389877 -122.423380737252 (37.7632975389877, -122.423380737252)
185717 185717 200093 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 2220 Keith St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6014746.9609 2092794.4540000001 37.7272439208635 -122.39122843279699 (37.7272439208635, -122.391228432797)

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