Street_Tree_List

Data source: data.sfgov.org

25 rows where qSiteInfo = 7 and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize

qSiteInfo ✖

  • Front Yard : Yard · 25 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25572 25572 191703 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 2 Front Yard : Yard 7 Tree 1 Private 1     7 Width 4ft   6013259.66608 2096346.4213299998 37.7369142408999 -122.396618925818 (37.7369142408999, -122.396618925818)
34441 34441 191696 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1700 22nd St 3 Front Yard : Yard 7 Tree 1 Private 1     7     6012930.9536 2103804.38992 37.7573739307682 -122.398278546439 (37.7573739307682, -122.398278546439)
35128 35128 249903 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 300 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     17 Width 0ft   6011307.54061 2120412.72536 37.8028859854681 -122.40506238711399 (37.8028859854681, -122.405062387114)
36917 36917 191685 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1301 Minnesota St 13 Front Yard : Yard 7 Tree 1 Private 1     4     6015385.022890001 2102351.0583099998 37.7535197845136 -122.38968982661801 (37.7535197845136, -122.389689826618)
41768 41768 191697 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1700 22nd St 7 Front Yard : Yard 7 Tree 1 Private 1     13     6012906.9277800005 2103803.94978 37.7573713838993 -122.398361606903 (37.7573713838993, -122.398361606903)
42410 42410 126571 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1013 Vallejo St 2 Front Yard : Yard 7 Tree 1 Private 1     13     6008640.83285 2118637.5271099997 37.7978622987641 -122.414164932777 (37.7978622987641, -122.414164932777)
47316 47316 126572 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1001 Vallejo St 5 Front Yard : Yard 7 Tree 1 Private 1     6     6008680.36365 2118649.32289 37.7978969073709 -122.414028979559 (37.7978969073709, -122.414028979559)
55102 55102 191686 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1301 Minnesota St 14 Front Yard : Yard 7 Tree 1 Private 1     6     6015385.377169999 2102357.3727700002 37.7535371423304 -122.38968904242701 (37.7535371423304, -122.389689042427)
59361 59361 176270 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 195 Rome St 1 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   5998756.35201 2088943.21744 37.7157689240671 -122.44623074418001 (37.7157689240671, -122.44623074418)
61536 61536 246754 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1838 Alabama St 1 Front Yard : Yard 7 Tree 1 Private 1     16     6009313.62627 2099009.8875700003 37.7440071345341 -122.410450206611 (37.7440071345341, -122.410450206611)
66405 66405 249910 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 308 Greenwich St 2 Front Yard : Yard 7 Tree 1 Private 1     10 Width 0ft   6011272.31007 2120413.3018099996 37.8028855987512 -122.40518434418699 (37.8028855987512, -122.405184344187)
72590 72590 249863 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 233 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     6 Width 0ft   6011630.0308300005 2120434.01589 37.8029624665125 -122.40394789778799 (37.8029624665125, -122.403947897788)
133017 133017 224114 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 70 Front Yard : Yard 7 Tree 1 Private 1     6     6004687.50549 2096549.1812200001 37.736990167061 -122.42627113673001 (37.736990167061, -122.42627113673)
133784 133784 224113 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 69 Front Yard : Yard 7 Tree 1 Private 1     4     6004690.02185 2096554.43933 37.7370047468799 -122.426262810788 (37.7370047468799, -122.426262810788)
135288 135288 246764 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 70 Waltham St 8 Front Yard : Yard 7 Tree 1 Private 1     8     6009279.96949 2098891.64841 37.7436805888792 -122.410558236772 (37.7436805888792, -122.410558236772)
143567 143567 111509 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 800x BOSWORTH ST 4 Front Yard : Yard 7 Tree 1 DPW 2     4     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
158587 158587 249981 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 224 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     9 Width 0ft   6011659.45074 2120118.51197 37.8020978133144 -122.403823874987 (37.8020978133144, -122.403823874987)
159049 159049 224115 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 71 Front Yard : Yard 7 Tree 1 Private 1     8     6004680.7613 2096547.43611 37.7369849941684 -122.426294330213 (37.7369849941684, -122.426294330213)
160633 160633 176276 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 62 Tomaso Ct 7 Front Yard : Yard 7 Tree 1 Private 1     12 Width 8ft   6009192.32266 2086308.3659400002 37.7091246419674 -122.40997318013201 (37.7091246419674, -122.409973180132)
162057 162057 247967 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 16 Joy St 3 Front Yard : Yard 7 Tree 1 Private 1     4     6010333.495709999 2098927.4961099997 37.743838026898295 -122.40691790615 (37.7438380268983, -122.40691790615)
180486 180486 176271 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 195 Rome St 2 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   5998766.3474 2088951.7637599998 37.715792961145205 -122.446196810045 (37.7157929611452, -122.446196810045)
182683 182683 191698 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 602 Arthur Ave 35 Front Yard : Yard 7 Tree 1 Private 1     2     6015659.044530001 2099869.60737 37.7467214305684 -122.38856899259 (37.7467214305684, -122.38856899259)
184746 184746 191699 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 50 Quint St 4 Front Yard : Yard 7 Tree 1 Private 1     4 Width 6ft   6015737.97927 2099766.7157099997 37.7464432855229 -122.388288861864 (37.7464432855229, -122.388288861864)
186894 186894 246755 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1838 Alabama St 2 Front Yard : Yard 7 Tree 1 Private 1     16     6009311.20113 2098998.06122 37.7439745260177 -122.410457757318 (37.7439745260177, -122.410457757318)
187509 187509 191704 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 3 Front Yard : Yard 7 Tree 1 Private 1     6 Width 4ft   6013263.69136 2096352.02038 37.736929838751294 -122.396605400918 (37.7369298387513, -122.396605400918)

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