Street_Tree_List

Data source: data.sfgov.org

23 rows where qSpecies = 294

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, 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
15764 15764 80467 Private 5 Alnus cordata :: Italian Alder 294 1780 Bancroft Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/07/2002 12:00:00 AM 10     6013451.73876 2092852.71308 37.727331923129896 -122.395710120444 (37.7273319231299, -122.395710120444)
25802 25802 187983 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 5ft   6013541.30669 2092786.45742 37.7271549806017 -122.395395842461 (37.7271549806017, -122.395395842461)
27897 27897 187974 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   6013741.64285 2092638.14431 37.726758883215396 -122.394692895458 (37.7267588832154, -122.394692895458)
33022 33022 187984 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 5ft   6013523.184119999 2092800.1784400002 37.7271916477681 -122.395459453304 (37.7271916477681, -122.395459453304)
38208 38208 187977 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   6013646.8498 2092708.23202 37.726946059107 -122.395025501647 (37.726946059107, -122.395025501647)
47081 47081 187978 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 5ft   6013630.25148 2092720.2143700002 37.726978037202 -122.39508372105499 (37.726978037202, -122.395083721055)
48919 48919 200827 Undocumented 2 Alnus cordata :: Italian Alder 294 5300 03rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6014256.7382 2093362.9923 37.728777794532704 -122.392962903849 (37.7287777945327, -122.392962903849)
50931 50931 187980 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 5ft   6013594.15592 2092747.34309 37.7270505198448 -122.395210403156 (37.7270505198448, -122.395210403156)
60109 60109 200825 Undocumented 2 Alnus cordata :: Italian Alder 294 5300 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6014263.6097 2093382.4616 37.728831634987294 -122.392940510044 (37.7288316349873, -122.392940510044)
64147 64147 187976 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   6013686.9099 2092676.6751599999 37.726861637932004 -122.39488480448401 (37.726861637932, -122.394884804484)
73692 73692 187979 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 5ft   6013615.832 2092731.9970200001 37.7270095881002 -122.395134394263 (37.7270095881002, -122.395134394263)
90697 90697 22361 DPW Maintained 3 Alnus cordata :: Italian Alder 294 5330X 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574)
116457 116457 22360 DPW Maintained 3 Alnus cordata :: Italian Alder 294 5330X 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574)
116967 116967 22359 DPW Maintained 3 Alnus cordata :: Italian Alder 294 5330X 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/09/1995 12:00:00 AM 3 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574)
118029 118029 100229 Undocumented 2 Alnus cordata :: Italian Alder 294 701X 39th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2016 12:00:00 AM 3 3x3 Permit Number 778265 5983807.975430001 2110975.7277599997 37.7753991192247 -122.49952572567801 (37.7753991192247, -122.499525725678)
132782 132782 184872 Undocumented 2 Alnus cordata :: Italian Alder 294 1201 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984669.9453 2106823.2961 37.7640482591194 -122.496237573009 (37.7640482591194, -122.496237573009)
155555 155555 187982 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 5ft   6013557.45285 2092775.26074 37.7271251348046 -122.395339240918 (37.7271251348046, -122.395339240918)
157876 157876 200826 Undocumented 2 Alnus cordata :: Italian Alder 294 5300 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6014262.4645 2093372.7269 37.728804841856295 -122.392943788301 (37.7288048418563, -122.392943788301)
159142 159142 200824 Undocumented 2 Alnus cordata :: Italian Alder 294 5300 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6014267.0455 2093396.2046 37.728869561334704 -122.392929593283 (37.7288695613347, -122.392929593283)
159819 159819 222008 Undocumented 2 Alnus cordata :: Italian Alder 294 22 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 4ft   6004062.615180001 2108585.10305 37.7700026390277 -122.429289661699 (37.7700026390277, -122.429289661699)
161861 161861 187975 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 5ft   6013720.25954 2092652.55253 37.7267972563783 -122.394767826095 (37.7267972563783, -122.394767826095)
173798 173798 187981 Undocumented 2 Alnus cordata :: Italian Alder 294 1740 Bancroft Ave 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 5ft   6013574.181969999 2092762.0333900002 37.7270897455934 -122.395280481931 (37.7270897455934, -122.395280481931)
184796 184796 181967 Undocumented 2 Alnus cordata :: Italian Alder 294 2423 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5986399.1816 2098739.8329 37.7419544119514 -122.48966224523501 (37.7419544119514, -122.489662245235)

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