Street_Tree_List

Data source: data.sfgov.org

21 rows where PlotSize = "4X4", qLegalStatus = 3 and qSpecies = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
16854 16854 11488 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/05/1993 12:00:00 AM 6 4X4   6018872.157000001 2097296.32677 37.7398332567899 -122.377279727371 (37.7398332567899, -122.377279727371)
18215 18215 4462 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1454 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6004517.68898 2100379.8296 37.7474986516535 -122.42713103697099 (37.7474986516535, -122.427131036971)
22088 22088 16025 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 131 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6001203.7257900005 2094613.91575 37.7314788418574 -122.438177502293 (37.7314788418574, -122.438177502293)
77690 77690 6329 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1895X Ellis St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
79295 79295 6333 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1895X Ellis St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
79767 79767 6335 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1895X Ellis St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
81124 81124 11506 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 20 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
82431 82431 6309 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1807 Ellis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6002200.5977300005 2112898.1085099997 37.7817394844201 -122.43603901136999 (37.7817394844201, -122.43603901137)
86602 86602 5245 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1780X Turk St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 4X4   6001669.86946 2112366.9914599997 37.78025100635529 -122.437837026039 (37.7802510063553, -122.437837026039)
92387 92387 6315 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1829 Ellis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002129.29202 2112924.84308 37.781808839600394 -122.43628760910102 (37.7818088396004, -122.436287609101)
94164 94164 11508 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
96484 96484 6324 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1895X Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
98320 98320 11502 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
104769 104769 11500 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
107854 107854 11501 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
109964 109964 1773 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 2000X Bay Shore Blvd 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 4X4   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
126552 126552 11503 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
129014 129014 11507 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 21 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
138869 138869 11509 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
141336 141336 5243 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1780X Turk St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 4X4   6001669.86946 2112366.9914599997 37.78025100635529 -122.437837026039 (37.7802510063553, -122.437837026039)
143972 143972 5244 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1780X Turk St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 4X4   6001669.86946 2112366.9914599997 37.78025100635529 -122.437837026039 (37.7802510063553, -122.437837026039)

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