Street_Tree_List

Data source: data.sfgov.org

25 rows where qSiteInfo = 2 and qSpecies = 17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, PlantDate, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27 27 244214 Private 5 Tree(s) :: 17 342 Scott St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779666 6002262.2202 2109717.5413 37.7730099442883 -122.43559821674499 (37.7730099442883, -122.435598216745)
50 50 138938 Private 5 Tree(s) :: 17 632 HAYES ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779650 6004797.9634 2110922.1515 37.7764612085261 -122.426912572117 (37.7764612085261, -122.426912572117)
2180 2180 251495 Significant Tree 6 Tree(s) :: 17 2448 Clay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026.0 2116224.0 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488)
29729 29729 181810 Undocumented 2 Tree(s) :: 17 2311 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5987920.8952 2099549.8455 37.744267219356395 -122.484460112778 (37.7442672193564, -122.484460112778)
32175 32175 183211 Undocumented 2 Tree(s) :: 17 2201 44th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5982626.7574 2100094.3318 37.7454525198404 -122.50280610050699 (37.7454525198404, -122.502806100507)
38125 38125 181361 Undocumented 2 Tree(s) :: 17 2125 Rivera St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5986542.2796 2100252.4532 37.746116016151795 -122.489278654419 (37.7461160161518, -122.489278654419)
54374 54374 183137 Undocumented 2 Tree(s) :: 17 3515 Santiago St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5981958.3374 2099418.2679 37.7435569304689 -122.505067258282 (37.7435569304689, -122.505067258282)
59267 59267 245110 Undocumented 2 Tree(s) :: 17 135 Baker St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   6000770.1938 2109453.5749 37.772200302029205 -122.44074036886002 (37.7722003020292, -122.44074036886)
77389 77389 105910 Undocumented 2 Tree(s) :: 17 80 LINARES AVE 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5994154.8 2102090.7 37.75160480205479 -122.46308908916401 (37.7516048020548, -122.463089089164)
81399 81399 93926 Permitted Site 1 Tree(s) :: 17 3711 19th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
87608 87608 87240 Significant Tree 6 Tree(s) :: 17 233 Arbor St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   02/14/2008 12:00:00 AM     Permit Number 50269 6001330.0 2096776.0 37.737422605415205 -122.43789575270901 (37.7374226054152, -122.437895752709)
99559 99559 104910 Undocumented 2 Tree(s) :: 17 604 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1         Permit Number 777994 5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
105728 105728 104942 Undocumented 2 Tree(s) :: 17 840X Gonzalez Dr   Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/11/2014 12:00:00 AM 3   Permit Number 770723 5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
107212 107212 104811 Permitted Site 1 Tree(s) :: 17 1900 08th Ave   Sidewalk: Curb side : Yard 2 Tree 1 Private 1   11/18/2013 12:00:00 AM     Permit Number 770426 5993817.2 2102486.9 37.7526732127641 -122.46428530535499 (37.7526732127641, -122.464285305355)
107759 107759 120952 Significant Tree 6 Tree(s) :: 17 100X 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 10x10 Permit Number 778529 5985781.0 2114962.0 37.7864598433405 -122.492994369609 (37.7864598433405, -122.492994369609)
111059 111059 108382 Undocumented 2 Tree(s) :: 17 30 CASTILLO ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       6x12   6006869.1 2086298.1 37.7089659714277 -122.418001881162 (37.7089659714277, -122.418001881162)
118708 118708 106159 Undocumented 2 Tree(s) :: 17 280 DORANTES AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5993249.6 2099727.1 37.745062774532 -122.46604762346 (37.745062774532, -122.46604762346)
123973 123973 183445 Undocumented 2 Tree(s) :: 17 2501 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5987037.8943 2098204.2673 37.740521160993296 -122.487414479884 (37.7405211609933, -122.487414479884)
138326 138326 95420 Permitted Site 1 Tree(s) :: 17 263 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   02/28/2011 12:00:00 AM     Permit Number 767289 5986781.4 2114160.4 37.7843173345373 -122.48947431767999 (37.7843173345373, -122.48947431768)
138563 138563 108589 Significant Tree 6 Tree(s) :: 17 1139x HUDSON AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6017760.0 2094672.0 37.732566047797704 -122.38094273978099 (37.7325660477977, -122.380942739781)
138617 138617 104911 Undocumented 2 Tree(s) :: 17 605 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/11/2014 12:00:00 AM 3   Permit Number 770292 5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
139831 139831 56597 Permitted Site 1 Tree(s) :: 17 537 Laidley St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6003206.07850285 2096083.64373576 37.735628059215294 -122.431359867263 (37.7356280592153, -122.431359867263)
148036 148036 182278 Undocumented 2 Tree(s) :: 17 1496 Kirkham St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5984983.6571 2105041.0964 37.7591732082041 -122.495021129405 (37.7591732082041, -122.495021129405)
168268 168268 246139 Undocumented 2 Tree(s) :: 17 636 Shrader St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5997577.8669 2108330.4431 37.7689341546251 -122.45170181346 (37.7689341546251, -122.45170181346)
185948 185948 218383 Undocumented 2 Tree(s) :: 17 398 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5993334.06783 2100029.01263 37.745896622722704 -122.465777482764 (37.7458966227227, -122.465777482764)

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