Street_Tree_List

Data source: data.sfgov.org

25 rows where PlotSize = "Width 0ft" and qSpecies = 61

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH, YCoord

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23628 23628 185802 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2612 Pacheco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5986872.5715 2101682.5627 37.7500619869815 -122.488241637782 (37.7500619869815, -122.488241637782)
27666 27666 183543 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2581 25th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5988605.1751 2097774.8752 37.7394334392266 -122.481964049119 (37.7394334392266, -122.481964049119)
28253 28253 247297 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 251 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6002733.6666 2109491.8212 37.7724169385487 -122.43395128968099 (37.7724169385487, -122.433951289681)
28456 28456 183540 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1412 Vicente St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5988533.1723 2097656.6869 37.739104737168105 -122.48220434364299 (37.7391047371681, -122.482204343643)
38063 38063 185803 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2614 Pacheco St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5986857.6825 2101684.1029 37.750065347280895 -122.488293237257 (37.7500653472809, -122.488293237257)
39607 39607 181953 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2213 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5986306.2848 2098879.0935 37.7423313601889 -122.48999368848601 (37.7423313601889, -122.489993688486)
40154 40154 247360 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 717 Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6003117.4357 2109597.3047 37.7727283414985 -122.432631332795 (37.7727283414985, -122.432631332795)
52243 52243 140387 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1701 O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6003030.1364 2113397.2369999997 37.783157057463605 -122.433204874911 (37.7831570574636, -122.433204874911)
64259 64259 185267 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2301 Vicente St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985773.8434 2097496.0598 37.7385028138514 -122.491732893269 (37.7385028138514, -122.491732893269)
67360 67360 141771 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1749 O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6002929.9391 2113383.5737 37.7831138570318 -122.433550539983 (37.7831138570318, -122.433550539983)
74896 74896 183537 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1406 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5988583.1202 2097657.595 37.739110135695796 -122.482031715061 (37.7391101356958, -122.482031715061)
132156 132156 244152 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 403 Rose St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6004627.8101 2109638.4044 37.77292673004921 -122.42740970756701 (37.7729267300492, -122.427409707567)
136087 136087 183538 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1408 Vicente St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5988570.9251 2097656.2977 37.7391058643676 -122.482073784664 (37.7391058643676, -122.482073784664)
145440 145440 244151 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 403 Rose St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6004595.5153 2109633.7909 37.772912235932004 -122.427521090443 (37.772912235932, -122.427521090443)
151597 151597 140386 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1739 O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6002991.9931 2113391.544 37.783139262071096 -122.433336428258 (37.7831392620711, -122.433336428258)
152015 152015 183584 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2609 25th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5988610.1868 2097562.569 37.7388507932479 -122.48193117307501 (37.7388507932479, -122.481931173075)
160749 160749 183583 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2605 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5988610.8123 2097582.8977 37.738906646935895 -122.48193049915001 (37.7389066469359, -122.48193049915)
162854 162854 137857 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1845 LAGUNA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6004358.4918 2115232.5475 37.7882716253172 -122.428740178583 (37.7882716253172, -122.428740178583)
169483 169483 185801 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2610 Pacheco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5986892.0814 2101684.6163 37.750068763852205 -122.488174323251 (37.7500687638522, -122.488174323251)
170226 170226 183539 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1410 Vicente St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5988555.4867 2097656.6869 37.7391060350729 -122.48212719150601 (37.7391060350729, -122.482127191506)
172622 172622 140385 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1745 O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6002953.8498 2113388.1282 37.7831277191493 -122.433468144329 (37.7831277191493, -122.433468144329)
179615 179615 185804 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2616 Pacheco St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5986840.2263 2101683.0761 37.7500615094832 -122.48835352551201 (37.7500615094832, -122.488353525512)
180956 180956 183541 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1414 Vicente St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5988516.3068 2097655.13 37.7390994813211 -122.48226254214501 (37.7390994813211, -122.482262542145)
182495 182495 181894 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1150 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5989578.6544 2099057.611 37.7430120666023 -122.47869200875799 (37.7430120666023, -122.478692008758)
183543 183543 247359 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 247 Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6002737.9071 2109456.3066 37.7723196648748 -122.433934082382 (37.7723196648748, -122.433934082382)

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