Street_Tree_List

Data source: data.sfgov.org

18 rows where SiteOrder = 3 and qSpecies = 110

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1694 251475 Undocumented 2 Pittosporum eugenioides :: Tarata 110 151 32nd Ave 3 Front Yard : Yard 7 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
26376 233965 Undocumented 2 Pittosporum eugenioides :: Tarata 110 16 Parnassus Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998630.023569999 2106931.63106 37.765153571896896 -122.44796176374099 (37.7651535718969, -122.447961763741)
40834 247628 Undocumented 2 Pittosporum eugenioides :: Tarata 110 286 Bradford St 3 Front Yard : Yard 7 Tree 1 Private 1     9     6009493.85882 2096962.27736 37.738394944962394 -122.409682503062 (37.7383949449624, -122.409682503062)
45134 132383 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1713 Taylor St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6008731.67478 2118716.1773200002 37.7980833548266 -122.41385615953301 (37.7980833548266, -122.413856159533)
54276 194583 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1698 Galvez Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   6015441.64874 2098018.63828 37.7416270022859 -122.38919150780899 (37.7416270022859, -122.389191507809)
57817 132397 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2836 Larkin St 3 Side Yard : Yard 17 Tree 1 Private 1     16     6006502.73263 2120950.76111 37.804093525861795 -122.42172776352899 (37.8040935258618, -122.421727763529)
62614 178399 Undocumented 2 Pittosporum eugenioides :: Tarata 110 339 Athens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   6004188.88481 2091298.12563 37.7225437445683 -122.42762108566002 (37.7225437445683, -122.42762108566)
64368 249601 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2200 Golden Gate Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   5998898.09787 2111497.4092 37.777705355751294 -122.447363215433 (37.7777053557513, -122.447363215433)
69854 132400 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2745 Larkin St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6006513.749919999 2120658.41667 37.8032914438996 -122.421668860656 (37.8032914438996, -122.421668860656)
70254 122245 Undocumented 2 Pittosporum eugenioides :: Tarata 110 47 Lake St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   5990779.800559999 2114787.3723 37.7862714344884 -122.47568719317199 (37.7862714344884, -122.475687193172)
71019 132386 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   6005813.32494 2119673.13314 37.8005465862138 -122.42402259955799 (37.8005465862138, -122.424022599558)
75547 132405 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2671 Leavenworth St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6007317.65081 2121868.01026 37.8066579786473 -122.418972771382 (37.8066579786473, -122.418972771382)
89513 132372 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6008211.08199 2117028.50784 37.793420182046 -122.41553801857401 (37.793420182046, -122.415538018574)
97714 102073 Significant Tree 6 Pittosporum eugenioides :: Tarata 110 273 Magellan Ave 3 Front Yard : Yard 7 Tree 1 Private 1           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194)
115488 233973 Undocumented 2 Pittosporum eugenioides :: Tarata 110 242 Upper Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5999494.677630001 2106185.26835 37.7631536325665 -122.44491748844901 (37.7631536325665, -122.444917488449)
147932 233969 Undocumented 2 Pittosporum eugenioides :: Tarata 110 59 Parnassus Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   5998431.96444 2106860.6202700003 37.7649472710115 -122.448641684483 (37.7649472710115, -122.448641684483)
155855 132392 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2833 Larkin St 3 Side Yard : Yard 17 Tree 1 Private 1     16     6006479.362930001 2120932.81603 37.8040429353981 -122.421807360741 (37.8040429353981, -122.421807360741)
184440 247639 Undocumented 2 Pittosporum eugenioides :: Tarata 110 360 Bradford St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 8ft   6009456.29127 2096556.43991 37.7372784977969 -122.409783755028 (37.7372784977969, -122.409783755028)

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