Street_Tree_List

Data source: data.sfgov.org

26 rows where qSiteInfo = 6

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
37 226924 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 1 Sidewalk: Property side : Pot 6 Tree 1 Private 1     11 Width 4ft   6002558.65829 2099967.6575700003 37.7462559468486 -122.433875776072 (37.7462559468486, -122.433875776072)
44 226925 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 2 Sidewalk: Property side : Pot 6 Tree 1 Private 1     19 Width 4ft   6002565.841680001 2099976.66752 37.746281093695 -122.433851580699 (37.746281093695, -122.433851580699)
61 226596 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1 Newburg St 4 Sidewalk: Property side : Pot 6 Tree 1 Private 1     4 Width 4ft   6002583.45295 2099992.19698 37.746324733318 -122.433791792881 (37.746324733318, -122.433791792881)
65 226926 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 3 Sidewalk: Property side : Pot 6 Tree 1 Private 1     15 Width 4ft   6002574.76935 2099983.89995 37.7463014588644 -122.433821226777 (37.7463014588644, -122.433821226777)
1580 239668 Undocumented 2 Butia capitata :: Pindo Palm 149 180 Dolores St 3 Sidewalk: Property side : Pot 6 Tree 1 Private 1     23 Width 4ft   6004776.3298 2107329.36682 37.766595069134105 -122.426731495165 (37.7665950691341, -122.426731495165)
79776 94218 Permitted Site 1 Ficus nitida :: Laurel Fig 43 246 01st St 3 Sidewalk: Property side : Pot 6 Tree 1 Private 1   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636)
80534 96292 Permitted Site 1 Tree(s) :: 17 1294 Union St   Sidewalk: Property side : Pot 6 Landscaping 2 Private 1   03/21/2011 12:00:00 AM       6006773.0 2119090.0 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797)
83162 91494 Permitted Site 1 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 1980 Union St 3 Sidewalk: Property side : Pot 6 Tree 1 Private 1   12/12/2006 12:00:00 AM     Permit Number 49113 6003507.0 2118649.0 37.797604101528 -122.431930246212 (37.797604101528, -122.431930246212)
86057 94469 Property Tree 7 Cupressus sempervirens :: Italian Cypress 136 4128 17th St   Sidewalk: Property side : Pot 6 Tree 1 Private 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
88424 107748 Permitted Site 1 Tree(s) :: 17 475 Florida St 3 Sidewalk: Property side : Pot 6 Tree 1 Private 1   10/22/2014 12:00:00 AM 3   Permit Number 774008 6009222.84948 2106151.80329 37.7636121434561 -122.41126850895901 (37.7636121434561, -122.411268508959)
90460 94216 Permitted Site 1 Ficus nitida :: Laurel Fig 43 1X Tehama St 1 Sidewalk: Property side : Pot 6 Tree 1 Private 1   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814)
93021 107747 Permitted Site 1 Tree(s) :: 17 475 Florida St 2 Sidewalk: Property side : Pot 6 Tree 1 Private 1   10/22/2014 12:00:00 AM 3   Permit Number 774008 6009222.84948 2106151.80329 37.7636121434561 -122.41126850895901 (37.7636121434561, -122.411268508959)
98453 93908 Permitted Site 1 Tree(s) :: 17 1238 Sutter St   Sidewalk: Property side : Pot 6 Tree 1 Private 1   04/26/2010 12:00:00 AM     Permit Number 53382 6006657.0 2114990.0 37.787735469045295 -122.420770480664 (37.7877354690453, -122.420770480664)
100186 107746 Permitted Site 1 Tree(s) :: 17 475 Florida St 1 Sidewalk: Property side : Pot 6 Tree 1 Private 1   10/22/2014 12:00:00 AM 3   Permit Number 774008 6009222.84948 2106151.80329 37.7636121434561 -122.41126850895901 (37.7636121434561, -122.411268508959)
100656 94229 Permitted Site 1 Tree(s) :: 17 45 Stonecrest Dr 1 Sidewalk: Property side : Pot 6 Tree 1 Private 1   06/28/2010 12:00:00 AM 60   Permit Number 53610 5991334.0 2093833.0 37.728768372571295 -122.47224179475 (37.7287683725713, -122.47224179475)
100936 96291 Permitted Site 1 Tree(s) :: 17 1294 Union St   Sidewalk: Property side : Pot 6 Landscaping 2 Private 1   03/21/2011 12:00:00 AM       6006773.0 2119090.0 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797)
101398 91493 Permitted Site 1 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 1980 Union St 2 Sidewalk: Property side : Pot 6 Tree 1 Private 1   12/12/2006 12:00:00 AM     Permit Number 49113 6003507.0 2118649.0 37.797604101528 -122.431930246212 (37.797604101528, -122.431930246212)
103566 94487 Property Tree 7 Cupressus sempervirens :: Italian Cypress 136 4128 17th St   Sidewalk: Property side : Pot 6 Tree 1 Private 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
105416 94220 Permitted Site 1 Ficus nitida :: Laurel Fig 43 1X Tehama St 5 Sidewalk: Property side : Pot 6 Tree 1 Private 1         Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814)
117229 94219 Permitted Site 1 Ficus nitida :: Laurel Fig 43 246 01st St 4 Sidewalk: Property side : Pot 6 Tree 1 Private 1   06/25/2010 12:00:00 AM     Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636)
121379 91495 Permitted Site 1 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 1980 Union St 4 Sidewalk: Property side : Pot 6 Tree 1 Private 1   12/12/2006 12:00:00 AM     Permit Number 49113 6003507.0 2118649.0 37.797604101528 -122.431930246212 (37.797604101528, -122.431930246212)
126549 94468 Property Tree 7 Cupressus sempervirens :: Italian Cypress 136 4128 17th St   Sidewalk: Property side : Pot 6 Tree 1 Private 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
139298 92611 Permitted Site 1 Shrub :: Shrub 98 3856 23rd St   Sidewalk: Property side : Pot 6 Landscaping 2 Private 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
139599 110312 Permitted Site 1 Tree(s) :: 17 899x Stanyan St 6 Sidewalk: Property side : Pot 6 Tree 1 Dept of Real Estate 5   04/03/2015 12:00:00 AM 3 3x3 Permit Number 774992 5997166.64381 2107575.86009 37.7668387037649 -122.45306972128999 (37.7668387037649, -122.45306972129)
140810 93909 Permitted Site 1 Tree(s) :: 17 1238 Sutter St 2 Sidewalk: Property side : Pot 6 Tree 1 Private 1   04/26/2010 12:00:00 AM     Permit Number 53382 6006657.0 2114990.0 37.787735469045295 -122.420770480664 (37.7877354690453, -122.420770480664)
143783 94217 Permitted Site 1 Ficus nitida :: Laurel Fig 43 246 01st St 2 Sidewalk: Property side : Pot 6 Tree 1 Private 1   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636)

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