Street_Tree_List

Data source: data.sfgov.org

21 rows where DBH = 6, PlotSize = "3X3" and qSpecies = 48

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4963 3516 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 201X Cargo Way 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/07/1996 12:00:00 AM 6 3X3   6018109.71439 2098036.73671 37.7418242442879 -122.379967395395 (37.7418242442879, -122.379967395395)
10352 27283 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 630 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/11/2008 12:00:00 AM 6 3X3   6005560.769069999 2093525.90712 37.7287382496569 -122.423037049614 (37.7287382496569, -122.423037049614)
10468 27000 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1236 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6008836.56983 2094066.26048 37.7304062528391 -122.411750521985 (37.7304062528391, -122.411750521985)
10740 27042 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 730 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6006159.1890199995 2093550.7367900002 37.7288401770086 -122.420970032554 (37.7288401770086, -122.420970032554)
10843 27202 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 302 Silver Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1999 12:00:00 AM 6 3X3   6003502.33889 2093475.71167 37.7284840526724 -122.43014959163601 (37.7284840526724, -122.430149591636)
11210 27282 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 710 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6006026.1077 2093547.18457 37.7288229208214 -122.421429852322 (37.7288229208214, -122.421429852322)
11736 26988 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1339 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 6 3X3   6009367.01038 2094339.1416200001 37.731185268979395 -122.409935962601 (37.7311852689794, -122.409935962601)
11827 27212 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 302 Silver Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1999 12:00:00 AM 6 3X3   6003753.294 2093466.8220900001 37.7284738543786 -122.429281393342 (37.7284738543786, -122.429281393342)
12126 27207 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 302 Silver Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1999 12:00:00 AM 6 3X3   6003623.95003 2093470.2864400002 37.7284760433174 -122.429728788952 (37.7284760433174, -122.429728788952)
12199 27193 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 284 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/27/2009 12:00:00 AM 6 3X3   6003096.09594 2093601.65823 37.7288068562446 -122.431562981455 (37.7288068562446, -122.431562981455)
12241 27220 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 387 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/03/2009 12:00:00 AM 6 3X3   6003946.676519999 2093508.2167200001 37.728598460843294 -122.42861580957899 (37.7285984608433, -122.428615809579)
12306 27287 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1036 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2008 12:00:00 AM 6 3X3   6007731.14975 2093596.42391 37.729054108643 -122.415538874723 (37.729054108643, -122.415538874723)
12933 27010 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1462 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/1999 12:00:00 AM 6 3X3   6010153.37045 2094576.2882400001 37.7318804638018 -122.407234074496 (37.7318804638018, -122.407234074496)
13061 27046 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 790 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 6 3X3   6006496.082169999 2093583.10222 37.728948030017904 -122.419807663316 (37.7289480300179, -122.419807663316)
13072 27052 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1016 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1999 12:00:00 AM 6 3X3   6007658.95865 2093571.8872599998 37.7289826781912 -122.415786708996 (37.7289826781912, -122.415786708996)
13204 27035 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1300X Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1999 12:00:00 AM 6 3X3   6009326.50967 2094276.52484 37.731011066700894 -122.410071562372 (37.7310110667009, -122.410071562372)
13218 27205 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 302 Silver Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1999 12:00:00 AM 6 3X3   6003575.96193 2093472.3389700002 37.7284789616109 -122.429894832577 (37.7284789616109, -122.429894832577)
93450 27125 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2095X Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/22/2011 12:00:00 AM 6 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
102581 27315 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1330X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1999 12:00:00 AM 6 3X3   6009430.10492 2094285.00827 37.7310401662886 -122.409714013149 (37.7310401662886, -122.409714013149)
104761 28817 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1075 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6008023.971390001 2093752.9516900002 37.7295003553203 -122.414537636128 (37.7295003553203, -122.414537636128)
120336 27014 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1518 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/2009 12:00:00 AM 6 3X3   6010461.99919 2094665.45469 37.732142563919794 -122.40617335478001 (37.7321425639198, -122.40617335478)

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