Street_Tree_List

Data source: data.sfgov.org

18 rows where DBH = 2 and qSpecies = 58

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
26902 26902 175812 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 15 Athens St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6005342.42292 2093158.1624099999 37.727716180055204 -122.42376574960899 (37.7277161800552, -122.423765749609)
36204 36204 222700 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 551 Eureka St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6001566.9280900005 2102610.03358 37.7534549532875 -122.437494242369 (37.7534549532875, -122.437494242369)
44360 44360 222680 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 76 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 6ft   6006248.111740001 2099605.96855 37.7454715078156 -122.421092396098 (37.7454715078156, -122.421092396098)
68446 68446 188417 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 274 Topeka Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6013295.80448 2094667.84679 37.7323072334974 -122.396376359792 (37.7323072334974, -122.396376359792)
75225 75225 204717 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1485x Northwood Dr 5 Median : Yard 3 Tree 1 DPW 2     2     5995876.20042 2094034.0159599998 37.7295821401899 -122.456553740875 (37.7295821401899, -122.456553740875)
81516 81516 50910 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2450 17th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2004 12:00:00 AM 2 3x9 Permit Number 772737 5991103.05311172 2098729.45888754 37.742199437798 -122.47339717645399 (37.742199437798, -122.473397176454)
84993 84993 117424 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 600x POWHATTAN AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6008524.0 2098073.0 37.7413903494898 -122.41311433102699 (37.7413903494898, -122.413114331027)
91704 91704 188404 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1300x De Haro St 10 Median : Yard 3 Tree 1 DPW 2     2     6012258.41015 2102196.39231 37.7529212353325 -122.40049153337401 (37.7529212353325, -122.400491533374)
128258 128258 204719 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 110 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993903.71897 2099982.29966 37.7458012037543 -122.46380433331001 (37.7458012037543, -122.46380433331)
129739 129739 204728 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 13 : 4 Tree 1 Private 1     2 Width 0ft   5991366.51565 2094145.3724 37.729627950748295 -122.47215214722401 (37.7296279507483, -122.472152147224)
133308 133308 222682 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2 Trainor St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6008292.2753800005 2108046.95875 37.768763565716704 -122.41462120290501 (37.7687635657167, -122.414621202905)
135290 135290 222704 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 69 Mirabel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007772.24851 2100018.26139 37.746689373329296 -122.415851346858 (37.7466893733293, -122.415851346858)
146575 146575 222710 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 201 Randall St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6004263.21249 2097476.0489 37.7395111430209 -122.427804130079 (37.7395111430209, -122.427804130079)
156342 156342 222693 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 440 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6003701.6023699995 2098966.92625 37.74357296341329 -122.42985224701 (37.7435729634133, -122.42985224701)
167905 167905 94813 Permitted Site 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2948 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/09/2010 12:00:00 AM 2 3x3 Permit Number 53896 6002515.07841 2118365.04564 37.7967681547718 -122.43534223486799 (37.7967681547718, -122.435342234868)
175877 175877 222699 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2102 Castro St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 5ft   6002635.97774 2099387.5471900003 37.744667486907204 -122.43356696417 (37.7446674869072, -122.43356696417)
175957 175957 204740 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 317 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   5999296.31857 2095221.44608 37.7330383112512 -122.44481540373 (37.7330383112512, -122.44481540373)
176434 176434 124049 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 651 11th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   5992517.64773 2111006.08275 37.775989642541795 -122.469399404795 (37.7759896425418, -122.469399404795)

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