Street_Tree_List

Data source: data.sfgov.org

9 rows where qCaretaker = 10 and qSiteInfo = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: PlotSize

qSiteInfo ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2514 2514 246848 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 10 : 4 Tree 1 DPW for City Agency 10     14 Width 3ft   6001221.8841699995 2109765.97896 37.773083798207296 -122.439200331843 (37.7730837982073, -122.439200331843)
2519 2519 246843 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 5 : 4 Tree 1 DPW for City Agency 10     9 Width 3ft   6001198.912769999 2109877.26909 37.7733880658265 -122.439287771129 (37.7733880658265, -122.439287771129)
2532 2532 246847 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 9 : 4 Tree 1 DPW for City Agency 10     9 Width 3ft   6001212.96216 2109784.10249 37.773133053181404 -122.43923249339198 (37.7731330531814, -122.439232493392)
2533 2533 246849 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 11 : 4 Tree 1 DPW for City Agency 10     9 Width 3ft   6001216.8657599995 2109748.1446700003 37.7730345441487 -122.439216412614 (37.7730345441487, -122.439216412614)
2535 2535 246841 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 3 : 4 Tree 1 DPW for City Agency 10     14 Width 3ft   6001195.01805 2109899.62825 37.7734492368388 -122.439302846449 (37.7734492368388, -122.439302846449)
2546 2546 246846 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 8 : 4 Tree 1 DPW for City Agency 10     14 Width 3ft   6001207.38463 2109809.38993 37.773202168766105 -122.43925359959101 (37.7732021687661, -122.439253599591)
2552 2552 246840 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 2 : 4 Tree 1 DPW for City Agency 10     19 Width 3ft   6001188.51269 2109936.2184200003 37.7735493340682 -122.43932797261999 (37.7735493340682, -122.43932797262)
2553 2553 246842 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 4 : 4 Tree 1 DPW for City Agency 10     15 Width 4ft   6001208.43411 2109888.06605 37.7734182533891 -122.439255609578 (37.7734182533891, -122.439255609578)
2554 2554 246844 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 6 : 4 Tree 1 DPW for City Agency 10     17 Width 3ft   6001203.63374 2109838.69012 37.773282406297895 -122.439268674924 (37.7732824062979, -122.439268674924)

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