Street_Tree_List

Data source: data.sfgov.org

19 rows where PlotSize = "Width 0ft" and qSpecies = 14 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, YCoord

PlotSize ✖

  • Width 0ft · 19 ✖
Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3786 3786 182314 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2722 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2001 12:00:00 AM 8 Width 0ft Permit Number 43905 5986467.3075 2105072.335 37.7593457241234 -122.489892322597 (37.7593457241234, -122.489892322597)
3782 3782 182315 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2724 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2001 12:00:00 AM 9 Width 0ft Permit Number 43905 5986428.3511 2105069.3949 37.759335376640294 -122.490026834722 (37.7593353766403, -122.490026834722)
176299 176299 182645 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2326 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5986741.8525 2102358.1899 37.751909449151796 -122.48874332116002 (37.7519094491518, -122.48874332116)
130272 130272 182923 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2615 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5981792.4148 2097276.497 37.7376664555995 -122.50548224533199 (37.7376664555995, -122.505482245332)
58979 58979 183140 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3349 Santiago St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5982406.7135 2099430.6148 37.74361720224611 -122.503517824716 (37.7436172022461, -122.503517824716)
50422 50422 183141 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3345 Santiago St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5982420.2443 2099431.2913 37.7436198552063 -122.50347108938601 (37.7436198552063, -122.503471089386)
176539 176539 183213 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2219 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5982939.2739 2099996.1393 37.745201271967204 -122.501718222466 (37.7452012719672, -122.501718222466)
57574 57574 184362 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2235 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5981703.3038 2099872.4987 37.7447891133624 -122.505982756659 (37.7447891133624, -122.505982756659)
37071 37071 184415 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3516 Quintara St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982523.9135 2100851.2465 37.747524752909 -122.50321774395901 (37.747524752909, -122.503217743959)
187951 187951 184507 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 1883 47th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5981621.681 2102272.7873 37.7513748283574 -122.506442956648 (37.7513748283574, -122.506442956648)
30266 30266 184650 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3338 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5983871.6255 2103619.2141 37.7552039545022 -122.498761965635 (37.7552039545022, -122.498761965635)
180055 180055 184651 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3340 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5983852.0817 2103619.2141 37.7552028082153 -122.49882955279399 (37.7552028082153, -122.498829552794)
133931 133931 184652 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3342 Moraga St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5983832.8748 2103618.5402 37.755199831309 -122.498895925085 (37.755199831309, -122.498895925085)
154621 154621 184653 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3344 Moraga St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5983815.0158 2103618.5402 37.7551987837707 -122.498957685795 (37.7551987837707, -122.498957685795)
179342 179342 184680 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3349 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5983788.2273 2104242.0898 37.7569093054043 -122.49909639697701 (37.7569093054043, -122.499096396977)
131097 131097 184681 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3347 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5983801.7058 2104241.4158 37.756908245442 -122.499049734219 (37.756908245442, -122.499049734219)
172293 172293 184682 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3345 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5983812.8255 2104241.7528 37.756909823021005 -122.499011303641 (37.756909823021, -122.499011303641)
24310 24310 184685 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3339 Lawton St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5983851.9132 2104244.1115 37.756918592100206 -122.498876300129 (37.7569185921002, -122.498876300129)
74480 74480 185248 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2546 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5982756.6298 2097779.5782 37.7391044746726 -122.50218576556699 (37.7391044746726, -122.502185765567)

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