Street_Tree_List

Data source: data.sfgov.org

21 rows where qSiteInfo = 2 and qSpecies = 72

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 21 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25734 25734 237874 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 160 Coso Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6007471.906690001 2099585.1841700003 37.74548335098721 -122.41685922338301 (37.7454833509872, -122.416859223383)
29426 29426 117740 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 475 39th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5983746.49746 2112674.00016 37.7800584750229 -122.499863945897 (37.7800584750229, -122.499863945897)
33471 33471 182339 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 3081 Kirkham St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5985312.4034 2104975.8588 37.759013323653 -122.493879375972 (37.759013323653, -122.493879375972)
36470 36470 237886 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 286 Upper Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5999373.81016 2106048.64713 37.7627716059584 -122.445325703321 (37.7627716059584, -122.445325703321)
46324 46324 135861 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 5 Dicha Aly 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 2ft   5998316.32407 2113776.61007 37.783930185978704 -122.44954003254999 (37.7839301859787, -122.44954003255)
46702 46702 214354 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 8 Edgehill Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994911.61844 2099129.8957599998 37.7435187450863 -122.460257437746 (37.7435187450863, -122.460257437746)
55084 55084 214318 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 16 Belmont Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5996661.1210199995 2106238.0269400002 37.763136371875895 -122.454721566453 (37.7631363718759, -122.454721566453)
57881 57881 214317 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 20 Belmont Ave 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21     5996726.67758 2106195.56131 37.763023532129004 -122.454491761784 (37.763023532129, -122.454491761784)
62511 62511 202088 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1 Gould St 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6012849.75876 2091137.38485 37.722588475066 -122.397670917693 (37.722588475066, -122.397670917693)
65313 65313 183563 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2593 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5987056.9644 2097643.917 37.738983699378096 -122.487307395263 (37.7389836993781, -122.487307395263)
71198 71198 214353 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 50 Garcia Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995149.72336 2099349.67966 37.74413591023829 -122.45945004977399 (37.7441359102383, -122.459450049774)
75667 75667 123051 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 544 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991925.368290001 2111718.74321 37.777912168825004 -122.47150017707199 (37.777912168825, -122.471500177072)
128545 128545 183562 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2591 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5987056.0774 2097655.4477 37.7390153079093 -122.487311308785 (37.7390153079093, -122.487311308785)
130582 130582 214327 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100 Vista Verde Ct 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 10ft   5999204.10164 2096073.9362400002 37.7353737849692 -122.44519548960501 (37.7353737849692, -122.445195489605)
131846 131846 214348 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   5993734.17627 2099649.69883 37.7448781944898 -122.464366439256 (37.7448781944898, -122.464366439256)
147966 147966 183564 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2595 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5987057.6296 2097628.3948 37.738941118307295 -122.487303955513 (37.7389411183073, -122.487303955513)
154466 154466 214328 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100 Vista Verde Ct 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 10ft   5999189.95231 2096066.10598 37.735351477276296 -122.44524384613001 (37.7353514772763, -122.44524384613)
164027 164027 237931 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 18 Temple St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999994.62286 2105880.85812 37.7623463174434 -122.443166486857 (37.7623463174434, -122.443166486857)
171405 171405 183467 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2534 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5988330.845 2098043.4689 37.740154968776395 -122.482932230746 (37.7401549687764, -122.482932230746)
175815 175815 237928 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 310 Liberty St 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6004144.43295 2103938.76991 37.75724955362679 -122.428675392374 (37.7572495536268, -122.428675392374)
186227 186227 214352 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 50 Garcia Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5995162.00455 2099364.3275 37.744176835692 -122.459408645009 (37.744176835692, -122.459408645009)

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