Street_Tree_List

Data source: data.sfgov.org

20 rows where qSiteInfo = 2 and qSpecies = 88

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

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
27684 27684 208849 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 15 Santa Rita Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 3ft   5993729.602000001 2100694.18749 37.7477458321253 -122.464458079273 (37.7477458321253, -122.464458079273)
30218 30218 208836 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1677 18th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5990563.73281 2104000.71919 37.756641694668396 -122.47564678406499 (37.7566416946684, -122.475646784065)
36826 36826 218387 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 50 San Marcos Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5993857.52408 2100226.90247 37.746470159084396 -122.46398181990101 (37.7464701590844, -122.463981819901)
52959 52959 208835 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1673 18th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5990563.36006 2104017.9082 37.7566888695243 -122.475649328274 (37.7566888695243, -122.475649328274)
55977 55977 230279 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 529 Buchanan St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6004554.65684 2110370.74902 37.774933432055 -122.42771494250499 (37.774933432055, -122.427714942505)
73056 73056 123366 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 780 04th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994765.69029 2110380.32738 37.774401141157796 -122.461577514019 (37.7744011411578, -122.461577514019)
73090 73090 123057 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 514 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5991919.1397400005 2111920.98536 37.778467110254795 -122.47153646453998 (37.7784671102548, -122.47153646454)
75476 75476 208842 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 168 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993717.6087 2099811.01881 37.7453201833801 -122.46443543703998 (37.7453201833801, -122.46443543704)
77158 77158 208851 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 185 Vasquez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994827.47674 2099365.31036 37.7441602944536 -122.46056543215299 (37.7441602944536, -122.460565432153)
130198 130198 208841 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2134 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993696.59277 2101147.8080700003 37.74898945599679 -122.46460515623001 (37.7489894559968, -122.46460515623)
135397 135397 218385 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 50 San Marcos Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5993842.10795 2100214.10934 37.7464341439306 -122.46403419821999 (37.7464341439306, -122.46403419822)
135913 135913 208850 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 185 Vasquez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994846.41703 2099381.9265400004 37.7442070079607 -122.46050114503001 (37.7442070079607, -122.46050114503)
153849 153849 193344 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1133 19th St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   6014141.435 2105240.8231200003 37.761385417914205 -122.394192754591 (37.7613854179142, -122.394192754591)
157233 157233 208838 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1450 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5991176.37038 2105519.1814900003 37.7608464875004 -122.47363884617799 (37.7608464875004, -122.473638846178)
160936 160936 121810 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 106 19th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5989928.89895 2114601.72994 37.7857123459232 -122.478617478776 (37.7857123459232, -122.478617478776)
161578 161578 230318 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 107 Valley St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6005160.92225 2099293.15868 37.744551255839795 -122.424829478514 (37.7445512558398, -122.424829478514)
165491 165491 193346 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1133 19th St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   6014187.49963 2105244.21667 37.761397296172 -122.394033672633 (37.761397296172, -122.394033672633)
171396 171396 123367 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 780 04th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994765.802759999 2110367.1849 37.774365061862504 -122.461576171928 (37.7743650618625, -122.461576171928)
184438 184438 119038 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 675 44th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5982249.27103 2111200.72651 37.7759253222044 -122.50493423498501 (37.7759253222044, -122.504934234985)
187472 187472 193345 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1133 19th St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   6014171.26133 2105242.63423 37.7613920486234 -122.394089723782 (37.7613920486234, -122.394089723782)

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