Street_Tree_List

Data source: data.sfgov.org

24 rows where PlotSize = "Width 3ft", qSiteInfo = 2 and qSpecies = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2094 2094 252881 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3536 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
32289 32289 207308 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996630.86084 2093949.68597 37.7293938887121 -122.453938729108 (37.7293938887121, -122.453938729108)
33808 33808 207309 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5996632.84291 2093955.22047 37.72940919877011 -122.45393227647699 (37.7294091987701, -122.453932276477)
37568 37568 207302 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 65 Hazelwood Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5996572.7806400005 2094082.116 37.72975417960021 -122.45414907781799 (37.7297541796002, -122.454149077818)
42179 42179 207304 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 53 Hazelwood Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996585.7495 2094006.0145 37.72954596675461 -122.454098749052 (37.7295459667546, -122.454098749052)
42565 42565 226630 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 17 Temple St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6000001.75416 2105889.17936 37.7623695721306 -122.443142420082 (37.7623695721306, -122.443142420082)
42681 42681 207330 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 345 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5995685.60702 2098472.19978 37.7417573653183 -122.45753361969601 (37.7417573653183, -122.457533619696)
54556 54556 207281 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 595 Darien Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993428.290469999 2094922.6798 37.731881346040794 -122.46508086700001 (37.7318813460408, -122.465080867)
56032 56032 207275 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 315 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993069.797230001 2099663.50314 37.7448777789813 -122.46666472241999 (37.7448777789813, -122.46666472242)
56956 56956 207310 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5996630.650640001 2093957.49673 37.7294153231391 -122.453940019643 (37.7294153231391, -122.453940019643)
58029 58029 207272 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 855 Ortega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5991341.884190001 2102447.3188400003 37.7524215459225 -122.472842415544 (37.7524215459225, -122.472842415544)
59067 59067 207271 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 855 Ortega St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991354.98649 2102448.1922400002 37.752424702544296 -122.47279716974899 (37.7524247025443, -122.472797169749)
61510 61510 207295 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 217 Colon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5996039.75572 2094297.6973299999 37.7303155346371 -122.45600737215 (37.7303155346371, -122.45600737215)
63518 63518 207294 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1414 Plymouth Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5995890.4022699995 2093395.3891200002 37.727829439763106 -122.456458481978 (37.7278294397631, -122.456458481978)
70124 70124 207280 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 595 Darien Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993435.14458 2094919.26873 37.731872375313294 -122.46505692344299 (37.7318723753133, -122.465056923443)
74649 74649 207296 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 217 Colon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996041.08515 2094289.8634799998 37.7302941010767 -122.456002210028 (37.7302941010767, -122.456002210028)
129805 129805 226626 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 310 Liberty St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6004198.11867 2103939.92108 37.757255752658295 -122.42848980825899 (37.7572557526583, -122.428489808259)
136074 136074 207276 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 350 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5992917.36629 2099685.98724 37.7449307166945 -122.467193430259 (37.7449307166945, -122.467193430259)
147662 147662 207305 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 45 Hazelwood Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996586.90838 2093990.0061299999 37.7295020780524 -122.454093586973 (37.7295020780524, -122.454093586973)
149640 149640 207307 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996632.29133 2093946.6824400001 37.7293857237559 -122.453933566973 (37.7293857237559, -122.453933566973)
163785 163785 207274 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 315 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993100.15501 2099667.06703 37.7448893164068 -122.466560010732 (37.7448893164068, -122.466560010732)
180537 180537 226627 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 310 Liberty St 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6004024.53424 2103933.71517 37.7572288881251 -122.42908968844401 (37.7572288881251, -122.429089688444)
183022 183022 207329 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 307 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5995854.78749 2098571.2519 37.7420390545738 -122.45695581607401 (37.7420390545738, -122.456955816074)
184253 184253 207297 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 217 Colon Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5996046.36344 2094274.51279 37.730252254734104 -122.455982853036 (37.7302522547341, -122.455982853036)

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