Street_Tree_List

Data source: data.sfgov.org

12 rows where qSiteInfo = 4 and qSpecies = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24466 24466 207106 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 100 Tara St 2 : 4 Tree 1 Private 1     20 Width 0ft   5998100.60654 2090923.0946 37.7211677377768 -122.448639805789 (37.7211677377768, -122.448639805789)
63860 63860 207135 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 99 : 4 Tree 1 Private 1     5 Width 0ft   5991243.409109999 2092046.59438 37.7238581046423 -122.472424791093 (37.7238581046423, -122.472424791093)
67484 67484 207132 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 87 : 4 Tree 1 Private 1     16 Width 0ft   5991236.29103 2092157.26983 37.7241615799784 -122.472457461649 (37.7241615799784, -122.472457461649)
130969 130969 250332 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 141 27th Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   5987387.77846 2115003.34197 37.786667192588894 -122.487438428541 (37.7866671925889, -122.487438428541)
132080 132080 207131 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 500 Junipero Serra Blvd 23 : 4 Tree 1 Private 1     14 Width 0ft   5991341.745569999 2093676.61882 37.7283394372056 -122.47220362351901 (37.7283394372056, -122.472203623519)
132288 132288 207130 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 300 Junipero Serra Blvd 22 : 4 Tree 1 Private 1     24 Width 0ft   5991387.56325 2094477.49413 37.7305410918021 -122.472103582925 (37.7305410918021, -122.472103582925)
148023 148023 207134 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 98 : 4 Tree 1 Private 1     12 Width 0ft   5991244.20773 2092057.90852 37.723889216687496 -122.47242285485201 (37.7238892166875, -122.472422854852)
148752 148752 207137 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 103 : 4 Tree 1 Private 1     12 Width 0ft   5991231.72322 2092011.81443 37.7237619311543 -122.47246265254 (37.7237619311543, -122.47246265254)
152163 152163 207138 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 123 : 4 Tree 1 Private 1     8 Width 0ft   5991217.227519999 2091775.34767 37.7231118130309 -122.472495529957 (37.7231118130309, -122.472495529957)
154113 154113 201278 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 28 Lydia Ave 1 : 4 Tree 1 Private 1     6 Width 2ft   6012862.05555 2092837.94578 37.7272585546286 -122.397747632568 (37.7272585546286, -122.397747632568)
167635 167635 207136 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 100 : 4 Tree 1 Private 1     6 Width 0ft   5991240.31686 2092039.5475299999 37.723838576763896 -122.47243496690399 (37.7238385767639, -122.472434966904)
185196 185196 207133 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 90 : 4 Tree 1 Private 1     10 Width 0ft   5991231.48328 2092142.9158700001 37.724121889294295 -122.472473035196 (37.7241218892943, -122.472473035196)

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