Street_Tree_List

Data source: data.sfgov.org

15 rows where PlotSize = "Width 4ft", SiteOrder = 2 and qSpecies = 97

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1440 1440 222893 DPW Maintained 3 Ceratonia siliqua :: Carob 97 301 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 Width 4ft   6004914.2278 2106488.73534 37.7642946914815 -122.426194676362 (37.7642946914815, -122.426194676362)
23379 23379 222925 Undocumented 2 Ceratonia siliqua :: Carob 97 1025 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5998825.08997 2106348.09575 37.763562478748604 -122.44724507779499 (37.7635624787486, -122.447245077795)
33581 33581 222905 Undocumented 2 Ceratonia siliqua :: Carob 97 363 Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6004739.789609999 2109820.49268 37.7734330328342 -122.427035328438 (37.7734330328342, -122.427035328438)
35726 35726 222928 Undocumented 2 Ceratonia siliqua :: Carob 97 912 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998758.16977 2106859.07637 37.764961679071796 -122.447513315894 (37.7649616790718, -122.447513315894)
59090 59090 189955 Undocumented 2 Ceratonia siliqua :: Carob 97 145 Main St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6014561.092019999 2115949.59191 37.790812611275 -122.39349079958299 (37.790812611275, -122.393490799583)
67137 67137 125997 Undocumented 2 Ceratonia siliqua :: Carob 97 2510 Jones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6007910.60432 2121475.9089200003 37.8056147389887 -122.416892938958 (37.8056147389887, -122.416892938958)
71127 71127 222923 Undocumented 2 Ceratonia siliqua :: Carob 97 88 Parnassus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5998162.74598 2106870.63901 37.764959382183704 -122.449573561064 (37.7649593821837, -122.449573561064)
74205 74205 225045 Undocumented 2 Ceratonia siliqua :: Carob 97 881 Alabama St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6009145.122330001 2103987.25914 37.7576644387915 -122.411384417877 (37.7576644387915, -122.411384417877)
138105 138105 222902 Undocumented 2 Ceratonia siliqua :: Carob 97 2500 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6010304.7702 2105067.63235 37.760695874438 -122.407450027813 (37.760695874438, -122.407450027813)
157752 157752 189865 Undocumented 2 Ceratonia siliqua :: Carob 97 501 Newhall St 2 : 4 Tree 1 Private 1     13 Width 4ft   6015985.7864 2097784.98338 37.7410155838051 -122.38729375121599 (37.7410155838051, -122.387293751216)
161602 161602 225042 Undocumented 2 Ceratonia siliqua :: Carob 97 979 Ashbury St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5999193.16537 2106656.55415 37.764430453131105 -122.44599421345801 (37.7644304531311, -122.445994213458)
161942 161942 188480 Undocumented 2 Ceratonia siliqua :: Carob 97 209 Arkansas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6012920.54855 2106035.89651 37.7635005775036 -122.398471110175 (37.7635005775036, -122.398471110175)
174929 174929 125978 Undocumented 2 Ceratonia siliqua :: Carob 97 2360 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6008392.85025 2121496.40648 37.8056981340166 -122.415225505068 (37.8056981340166, -122.415225505068)
177491 177491 222921 Undocumented 2 Ceratonia siliqua :: Carob 97 957 Cole St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   5998078.46928 2106885.24351 37.7649946607859 -122.44986610424601 (37.7649946607859, -122.449866104246)
188742 188742 246420 Undocumented 2 Ceratonia siliqua :: Carob 97 400 Duncan St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6003851.19686 2099854.61267 37.7460188154337 -122.42939827552401 (37.7460188154337, -122.429398275524)

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