Street_Tree_List

Data source: data.sfgov.org

25 rows where qSiteInfo = 4 and qSpecies = 88

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29562 29562 193317 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 136 Hawthorne St 3 : 4 Tree 1 Private 1     9 Width 2ft   6013319.34244 2113654.62795 37.7844421016727 -122.397626191699 (37.7844421016727, -122.397626191699)
33199 33199 193347 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 444 Mississippi St 1 : 4 Tree 1 Private 1     10 Width 4ft   6014042.11061 2105043.11718 37.760837039231205 -122.394522434371 (37.7608370392312, -122.394522434371)
42961 42961 193318 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 136 Hawthorne St 4 : 4 Tree 1 Private 1     10 Width 2ft   6013332.96782 2113640.4980900004 37.7844040630434 -122.397578060899 (37.7844040630434, -122.397578060899)
44983 44983 250184 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 665 Parker Ave 1 : 4 Tree 1 Private 1     2 Width 4ft   5997216.13133 2110917.44789 37.7760166771611 -122.45313980466699 (37.7760166771611, -122.453139804667)
45125 45125 193342 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 401 Texas St 4 : 4 Tree 1 Private 1     1 Width 3ft   6013812.69862 2105193.07398 37.7612360315304 -122.39532637971901 (37.7612360315304, -122.395326379719)
49219 49219 247756 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 52 Alpine Ter 2 : 4 Tree 1 Private 1     3 Width 3ft   6001615.48849 2108494.65039 37.7696154359451 -122.437747736977 (37.7696154359451, -122.437747736977)
50385 50385 230282 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 175 Haight St 1 : 4 Tree 1 Private 1     3 Width 3ft   6005285.87309 2109545.94561 37.77271005706189 -122.425126806975 (37.7727100570619, -122.425126806975)
55956 55956 246808 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 162 Brewster St 1 : 4 Tree 1 Private 1     1 Width 2ft   6010230.46229 2099004.5054099998 37.744043711743004 -122.407279600877 (37.744043711743, -122.407279600877)
60128 60128 250187 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 665 Parker Ave 4 : 4 Tree 1 Private 1     1 Width 4ft   5997222.68042 2110871.6887 37.7758914096851 -122.453113845732 (37.7758914096851, -122.453113845732)
61328 61328 193352 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1707 McKinnon Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   6014777.576230001 2096343.32459 37.736990099615 -122.39137057769199 (37.736990099615, -122.391370577692)
68072 68072 250185 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 665 Parker Ave 2 : 4 Tree 1 Private 1     2 Width 4ft   5997218.614440001 2110901.95743 37.7759742867055 -122.453130096488 (37.7759742867055, -122.453130096488)
72263 72263 193315 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 136 Hawthorne St 1 : 4 Tree 1 Private 1     9 Width 2ft   6013291.138730001 2113684.88595 37.7845236126199 -122.39772589056001 (37.7845236126199, -122.39772589056)
72299 72299 247777 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 240 30th St 1 : 4 Tree 1 Private 1     2 Width 3ft   6005014.994390001 2098457.52943 37.742248565111204 -122.42527461684799 (37.7422485651112, -122.425274616848)
75334 75334 193343 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 698 Arkansas St 1 : 4 Tree 1 Private 1     4 Width 3ft   6012989.114019999 2103849.31958 37.757500537346395 -122.39808055528299 (37.7575005373464, -122.398080555283)
134744 134744 230281 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 185 Haight St 1 : 4 Tree 1 Private 1     3 Width 3ft   6005261.48002 2109543.28647 37.772701377697004 -122.425210996096 (37.772701377697, -122.425210996096)
135085 135085 246460 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 200 Duncan St 1 : 4 Tree 1 Private 1     2 Width 3ft   6005150.47679 2099924.83113 37.7462850938946 -122.42491052900299 (37.7462850938946, -122.424910529003)
153633 153633 247755 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 52 Alpine Ter 1 : 4 Tree 1 Private 1     2 Width 3ft   6001613.95356 2108514.35375 37.7696694492075 -122.43775445760299 (37.7696694492075, -122.437754457603)
160737 160737 193316 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 136 Hawthorne St 2 : 4 Tree 1 Private 1     9 Width 2ft   6013300.831040001 2113672.81478 37.784491007704396 -122.39769151127301 (37.7844910077044, -122.397691511273)
161301 161301 230280 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 201 Webster St 3 : 4 Tree 1 Private 1     2 Width 3ft   6004189.92363 2109488.51079 37.772490383253896 -122.428913720795 (37.7724903832539, -122.428913720795)
164978 164978 246941 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 269 Frederick St 1 : 4 Tree 1 Private 1     2 Width 3ft   5998752.122880001 2107600.5740099996 37.7669972990085 -122.447587610674 (37.7669972990085, -122.447587610674)
169196 169196 250186 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 665 Parker Ave 3 : 4 Tree 1 Private 1     2 Width 4ft   5997220.39466 2110886.1472400003 37.7759309780695 -122.4531227967 (37.7759309780695, -122.4531227967)
173077 173077 193354 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 75 Latona St 4 : 4 Tree 1 Private 1     3 Width 2ft   6014363.50892 2094164.90475 37.7309856140862 -122.392649861509 (37.7309856140862, -122.392649861509)
174129 174129 193351 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1752 Quesada Ave 2 : 4 Tree 1 Private 1     1 Width 4ft   6014452.02014 2095263.45344 37.734006920685204 -122.392420670182 (37.7340069206852, -122.392420670182)
181425 181425 193353 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 75 Latona St 2 : 4 Tree 1 Private 1     2 Width 2ft   6014356.71381 2094130.9148900001 37.730891907436295 -122.392670976684 (37.7308919074363, -122.392670976684)
185939 185939 193350 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1752 Quesada Ave 1 : 4 Tree 1 Private 1     1 Width 4ft   6014471.5284 2095248.21375 37.7339661589078 -122.39235215802799 (37.7339661589078, -122.392352158028)

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