Street_Tree_List

Data source: data.sfgov.org

26 rows where DBH = 5, qLegalStatus = 1 and qSpecies = 48

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
10369 83563 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 422 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2012 12:00:00 AM 5 3x3 Permit Number 769753 6002333.8721199995 2090986.9240400002 37.721584152666104 -122.434011205875 (37.7215841526661, -122.434011205875)
11369 83554 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 117X Peru Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003920.58239 2093359.5974299998 37.728188908672294 -122.428695428367 (37.7281889086723, -122.428695428367)
11687 83518 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 117X Peru Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003951.4498 2093338.17621 37.7281318376981 -122.428587192249 (37.7281318376981, -122.428587192249)
12350 83555 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 117X Peru Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003936.8249699995 2093347.62291 37.7281569485605 -122.428638423918 (37.7281569485605, -122.428638423918)
13067 83533 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 242 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2012 12:00:00 AM 5 3x3 Permit Number 769751 6002979.54268 2092016.08462 37.724446620113 -122.43185274573099 (37.724446620113, -122.431852745731)
13749 68842 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 602 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/27/2004 12:00:00 AM 5 3x3 Permit Number 767166 6014359.28345 2104329.14494 37.7588942535933 -122.39337550020399 (37.7588942535933, -122.393375500204)
31529 52954 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 975 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2006 12:00:00 AM 5   Permit Number 48941 6000767.51384 2091342.1163299999 37.7224704120511 -122.43945112037399 (37.7224704120511, -122.439451120374)
33778 52557 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1671 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 5   Permit Number 48653 5984052.4061 2103791.5706 37.7556877987927 -122.498149511058 (37.7556877987927, -122.498149511058)
39062 88481 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1221 Newhall St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2008 12:00:00 AM 5 3x3 Permit Number 51432 6014818.59944 2096228.0421 37.7366758342199 -122.391220684988 (37.7366758342199, -122.391220684988)
56096 65853 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 3415 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2008 12:00:00 AM 5 3x3 Permit Number 51130 6000770.44597 2120073.90569 37.8013609996628 -122.44150173651501 (37.8013609996628, -122.441501736515)
56157 95935 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 706 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 5 3x3 Permit Number 767632 5987262.82019 2111075.2653 37.7758745231149 -122.48758207690001 (37.7758745231149, -122.4875820769)
56854 88482 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1221 Newhall St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2008 12:00:00 AM 5 3x3 Permit Number 51432 6014826.8932300005 2096240.8429 37.7367114428676 -122.391192904038 (37.7367114428676, -122.391192904038)
66540 83309 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1519 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/23/2008 12:00:00 AM 5 3x3 Permit Number 50153 5982468.6778 2104743.2959 37.758207981102295 -122.50369693305099 (37.7582079811023, -122.503696933051)
71687 50032 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 33 Tulane St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM 5   Permit Number 46764 6007353.74197 2093754.84576 37.729467879523895 -122.416854825683 (37.7294678795239, -122.416854825683)
73444 34680 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1904 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2009 12:00:00 AM 5 3x3 Permit Number 52535 6003705.30059 2119372.14104 37.7996008996227 -122.43129571912701 (37.7996008996227, -122.431295719127)
78971 51607 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 800 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/2005 12:00:00 AM 5 3x3 Permit Number 47904 5997656.30420255 2107807.08178851 37.7675016300781 -122.45139275313 (37.7675016300781, -122.45139275313)
118167 43321 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 283 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/20/2007 12:00:00 AM 5 3x3 Permit Number 49915 6004368.565719999 2091597.24704 37.7233752280736 -122.427021263027 (37.7233752280736, -122.427021263027)
118839 88270 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 288 States St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM 5 3x3 Permit Number 51256 6000346.0 2106829.0 37.764969709442504 -122.44201926680701 (37.7649697094425, -122.442019266807)
150165 88483 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1221 Newhall St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2008 12:00:00 AM 5 3x3 Permit Number 51432 6014835.95113 2096251.5284900002 37.7367412859786 -122.39116233337201 (37.7367412859786, -122.391162333372)
150847 52442 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2310 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2005 12:00:00 AM 5   Permit Number 48553 6003588.30454 2116614.49532 37.7920224826905 -122.43150359293301 (37.7920224826905, -122.431503592933)
153309 88186 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 43 Dore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM 5 3x3 Permit Number 51193 6008751.52799 2109978.60624 37.774093208961204 -122.41316928526001 (37.7740932089612, -122.41316928526)
167979 95712 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 642 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767468 6003074.18539 2089625.7401 37.7178886288451 -122.431355025819 (37.7178886288451, -122.431355025819)
176002 95742 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 86 Ina Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767488 6004830.443109999 2091416.58174 37.7229052675357 -122.42541178684799 (37.7229052675357, -122.425411786848)
176219 88398 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 405 27th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 5 3x3 Permit Number 51376 5987449.923219999 2113199.01189 37.7817166413541 -122.48709085924 (37.7817166413541, -122.48709085924)
178000 95108 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 445 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2010 12:00:00 AM 5 3x3 Permit Number 54037 6002085.32525 2093826.71651 37.7293674729177 -122.435073368138 (37.7293674729177, -122.435073368138)
181980 60927 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1506 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/13/1983 12:00:00 AM 5   Permit Number 20728 6010428.9415 2094674.9694599998 37.732166840331104 -122.406288313254 (37.7321668403311, -122.406288313254)

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