Street_Tree_List

Data source: data.sfgov.org

16 rows where SiteOrder = 2 and qCareAssistant = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSpecies, qSiteInfo, qCaretaker, DBH, PlotSize

qCareAssistant ✖

  • Private · 16 ✖

SiteOrder ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
445 445 251285 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1299x Hudson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
679 679 187631 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 4255x Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/28/2017 11:56:00 AM 3 3x3   5981269.0 2105492.0 37.760193098921796 -122.50790142928699 (37.7601930989218, -122.507901429287)
781 781 251370 DPW Maintained 3 Ginkgo biloba :: Maidenhair Tree 44 390 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
4545 4545 253200 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 800 Oak St 2 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2 Private 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
6709 6709 85477 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1711 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/10/2011 12:00:00 AM 18 4x4 Permit Number 56911 6007344.49108 2118216.09025 37.7966322393414 -122.418620748847 (37.7966322393414, -122.418620748847)
7078 7078 95163 DPW Maintained 3 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 998 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/21/2016 12:00:00 AM 3 3x3   6001491.8688 2111772.0851 37.7786074207661 -122.438410176931 (37.7786074207661, -122.438410176931)
25916 25916 115393 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 800x Rutland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14 Private 3   4 3x3   6009906.5006099995 2087474.9292900001 37.712367789705 -122.407587055718 (37.712367789705, -122.407587055718)
85683 85683 87557 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 408X Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/03/2007 12:00:00 AM 3 3x3   5994236.225190001 2114896.53302 37.786770936164395 -122.463736876784 (37.7867709361644, -122.463736876784)
86815 86815 112748 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 135X TRENTON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 Private 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
107477 107477 106680 Permitted Site 1 Tree(s) :: 17 2200 LYON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9 Private 3 06/24/2014 12:00:00 AM 20 3x3 Permit Number 773028 5999398.2 2116386.7 37.7911586409716 -122.445984946853 (37.7911586409716, -122.445984946853)
114566 114566 114692 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 391 Girard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9 Private 3 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975.0 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761)
114637 114637 106120 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 849X Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9 Private 3     6x9   5992954.7 2110649.6 37.775036084258794 -122.46786160539301 (37.7750360842588, -122.467861605393)
120602 120602 115341 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1514 SUNNYDALE AVE 2 Sidewalk: Property side : Yard 9 Tree 1 Housing Authority 20 Private 3     3x3   6006572.0 2087815.0 37.7131143345755 -122.41913622882099 (37.7131143345755, -122.419136228821)
140895 140895 85310   Olea europaea :: Olive Tree 41 1250 Haight St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/27/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
144968 144968 17872 Section 143 8 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2148 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.788333445178104 -122.43117780902399 (37.7883334451781, -122.431177809024)
145363 145363 85250   Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1335 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)

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