Street_Tree_List

Data source: data.sfgov.org

20 rows where qSiteInfo = 2 and qSpecies = 86 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 20 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
78277 78277 98312 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 160 Stanford Heights Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5998064.7 2096544.4 37.7366004632858 -122.449168689734 (37.7366004632858, -122.449168689734)
51068 51068 201994 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013316.6056 2092506.69666 37.7263743142142 -122.396153039251 (37.7263743142142, -122.396153039251)
132662 132662 201996 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968)
137250 137250 201997 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013313.68951 2092516.98736 37.7264024081338 -122.39616384100201 (37.7264024081338, -122.396163841002)
157844 157844 201995 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013319.20907 2092521.7003099998 37.726415656052104 -122.396145090149 (37.7264156560521, -122.396145090149)
164241 164241 201993 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013314.351009999 2092488.44605 37.726324076294205 -122.396159554816 (37.7263240762942, -122.396159554816)
176864 176864 135666 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3001 Divisadero St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 9ft   6000472.49775 2118651.8946700003 37.797439556256705 -122.442430617479 (37.7974395562567, -122.442430617479)
49096 49096 212850 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 32 Malta Dr 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 3ft   5999489.821880001 2096117.1264 37.7355086796695 -122.444210754429 (37.7355086796695, -122.444210754429)
25205 25205 195981 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6018524.13374 2099557.3325900002 37.746022348857295 -122.37864001312799 (37.7460223488573, -122.378640013128)
26910 26910 195984 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093)
29206 29206 195983 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939)
46984 46984 195986 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6018468.61509 2099561.7634900003 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987)
61850 61850 195989 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6018358.23149 2099573.02507 37.7460562901585 -122.37921477706699 (37.7460562901585, -122.379214777067)
69871 69871 195990 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6018348.89198 2099575.3229 37.746062084515295 -122.379247231793 (37.7460620845153, -122.379247231793)
120047 120047 195988 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6018362.603680001 2099564.59582 37.7460333862374 -122.379199073078 (37.7460333862374, -122.379199073078)
130066 130066 195985 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6018474.359130001 2099556.32192 37.74601682971289 -122.378812058831 (37.7460168297129, -122.378812058831)
130871 130871 195987 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6018466.53487 2099573.76457 37.7460642923433 -122.378840325441 (37.7460642923433, -122.378840325441)
149276 149276 195992 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6018320.61791 2099573.80473 37.7460563567193 -122.379344895446 (37.7460563567193, -122.379344895446)
177923 177923 195991 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6018339.20952 2099575.6179 37.7460623605839 -122.379280733321 (37.7460623605839, -122.379280733321)
187127 187127 195982 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6018502.102580001 2099556.87815 37.746019886521296 -122.378716163238 (37.7460198865213, -122.378716163238)

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