Street_Tree_List

Data source: data.sfgov.org

13 rows where DBH = 12, SiteOrder = 8 and qSpecies = 97

View and edit SQL

Suggested facets: qLegalStatus, qCaretaker, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
9098 2530 Permitted Site 1 Ceratonia siliqua :: Carob 97 1570 Burke Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6016273.7509883 2099134.0637751 37.7447358261247 -122.38639210410601 (37.7447358261247, -122.386392104106)
9478 16486 Permitted Site 1 Ceratonia siliqua :: Carob 97 220 Newhall St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.38421892893899 (37.7425024549748, -122.384218928939)
14309 14975 Permitted Site 1 Ceratonia siliqua :: Carob 97 400X Mendell St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Fire Dept 11     12 3x3   6016578.93942 2097580.627 37.7404872941606 -122.38522858943001 (37.7404872941606, -122.38522858943)
14807 2520 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1555 Burke Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016533.26 2098864.45764 37.744009904432 -122.385475978555 (37.744009904432, -122.385475978555)
14957 2540 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1575 Burke Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016367.14673 2098986.82897 37.7443367189812 -122.386058894813 (37.7443367189812, -122.386058894813)
15763 2504 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1500 Burke Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016654.18712 2098861.64491 37.7440088711085 -122.385057640012 (37.7440088711085, -122.385057640012)
15837 16547 Permitted Site 1 Ceratonia siliqua :: Carob 97 400X Newhall St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6016044.76119 2097949.4335 37.741470396145104 -122.387101303489 (37.7414703961451, -122.387101303489)
51434 16506 DPW Maintained 3 Ceratonia siliqua :: Carob 97 325 Newhall St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
92651 6652 DPW Maintained 3 Ceratonia siliqua :: Carob 97 495X Newhall St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472)
100205 2512 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1501 Burke Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016682.7889975 2098765.8378067003 37.743747386445996 -122.384952066789 (37.743747386446, -122.384952066789)
103848 14914 DPW Maintained 3 Ceratonia siliqua :: Carob 97 110X Newhall St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6017206.58246 2098230.05631 37.742305197314295 -122.383103612647 (37.7423051973143, -122.383103612647)
140926 4919 DPW Maintained 3 Ceratonia siliqua :: Carob 97 195X Newhall St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/11/2016 12:00:00 AM 12 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
170676 189907 Undocumented 2 Ceratonia siliqua :: Carob 97 350 Newhall St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6016312.908530001 2098309.60993 37.7424742122044 -122.38619923760099 (37.7424742122044, -122.386199237601)

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