Street_Tree_List

Data source: data.sfgov.org

49 rows where qSpecies = 189

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, 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
2712 253178 Significant Tree 6 Washingtonia filifera :: California Fan Palm 189 4450 24th St 2 Front Yard : Cutout 8 Tree 1 Private 1       Width 0ft   6000289.52403 2101701.02913 37.7508863393389 -122.441846529398 (37.7508863393389, -122.441846529398)
7291 19965 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 100 STAIRWAY41 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 25ST            
9436 102427 Permitted Site 1 Washingtonia filifera :: California Fan Palm 189 184 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010519.0 2112009.0 37.7797672638755 -122.40719841712601 (37.7797672638755, -122.407198417126)
17974 15058 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 10X Minerva St 1 Median : Cutout 11 Tree 1 DPW 2     3 11   5996572.9500165 2089038.2134875 37.7159048245128 -122.45378440062001 (37.7159048245128, -122.45378440062)
37751 15078 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 60 Minerva St 1 Median : Cutout 11 Tree 1 DPW 2     3 11   5996206.9344238 2089043.0380608002 37.7158970804766 -122.455049862348 (37.7158970804766, -122.455049862348)
73844 121136 Planning Code 138.1 required 4 Washingtonia filifera :: California Fan Palm 189 1875 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3   6006784.10346 2107469.87255 37.7670941752111 -122.41979691458599 (37.7670941752111, -122.419796914586)
74391 108538 Undocumented 2 Washingtonia filifera :: California Fan Palm 189 400-422X Tocoloma Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6012449.25025 2086560.52634 37.7099990266406 -122.39873435567301 (37.7099990266406, -122.398734355673)
77368 25053 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 990X Dolores St 8 Median : Cutout 11 Tree 1 DPW 2   10/20/1999 12:00:00 AM 20 20   6005038.29077 2102581.9809991 37.7535746757806 -122.425487524624 (37.7535746757806, -122.425487524624)
78915 114478 Undocumented 2 Washingtonia filifera :: California Fan Palm 189 45 HOFF ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3       3x3   6006591.0 2106401.0 37.7641484227608 -122.420388955837 (37.7641484227608, -122.420388955837)
79631 25068 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1096X Dolores St 11 Median : Cutout 11 Tree 1 DPW 2     40 20   6005084.164762099 2101955.0797665003 37.751855942534796 -122.42528427535 (37.7518559425348, -122.42528427535)
81790 102422 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 99 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 4x4   6010101.0 2112468.0 37.7810041676544 -122.408676858386 (37.7810041676544, -122.408676858386)
82114 98455 Significant Tree 6 Washingtonia filifera :: California Fan Palm 189 2200 22nd St 1 Front Yard : Yard 7 Tree 1 Private 1           6011565.2 2103754.7 37.7571613219705 -122.402998394603 (37.7571613219705, -122.402998394603)
86424 1839 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 2193X Bay Shore Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6011389.361054099 2087350.7454491002 37.7121096997176 -122.40245308578699 (37.7121096997176, -122.402453085787)
86587 25008 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 500X Dolores St 2 Median : Cutout 11 Tree 1 DPW 2     35 20   6004896.4850004995 2105439.5076575 37.7614127588524 -122.426181340905 (37.7614127588524, -122.426181340905)
87437 102436 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1001 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4   6010518.0 2112007.0 37.77976171638 -122.40720173555799 (37.77976171638, -122.407201735558)
88526 102440 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1010 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4   6010010.0 2112396.0 37.7808013755178 -122.408986592248 (37.7808013755178, -122.408986592248)
88979 109707 Undocumented 2 Washingtonia filifera :: California Fan Palm 189 850 PORTOLA DR 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5996501.5 2099217.0 37.7438492362387 -122.454766346821 (37.7438492362387, -122.454766346821)
89091 24970 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 198 Dolores St 11 Median : Cutout 11 Tree 1 DPW 2     50 20   6004804.6555297 2107199.7616194002 37.766240805753604 -122.426624291348 (37.7662408057536, -122.426624291348)
89709 28585 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1150 Ocean Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/18/2011 12:00:00 AM 3 3x3 Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
92140 102434 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1000 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4   6010518.0 2112007.0 37.77976171638 -122.40720173555799 (37.77976171638, -122.407201735558)
97179 24969 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 198 Dolores St 10 Median : Cutout 11 Tree 1 DPW 2     50 20   6004804.6555297 2107199.7616194002 37.766240805753604 -122.426624291348 (37.7662408057536, -122.426624291348)
98670 24971 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 198 Dolores St 12 Median : Cutout 11 Tree 1 DPW 2     50 20   6004804.6555297 2107199.7616194002 37.766240805753604 -122.426624291348 (37.7662408057536, -122.426624291348)
101534 96499 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 2500X Harrison St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
102209 96492 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 2500X Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
102232 114479 Undocumented 2 Washingtonia filifera :: California Fan Palm 189 45 HOFF ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3       3x3   6006591.0 2106401.0 37.7641484227608 -122.420388955837 (37.7641484227608, -122.420388955837)
102282 28586 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1150 Ocean Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/18/2011 12:00:00 AM 3 3x3 Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
102291 15070 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 30X Minerva St 2 Median : Cutout 11 Tree 1 DPW 2     3 11   5996426.1222644 2089040.1488729 37.7159017196126 -122.45429204268801 (37.7159017196126, -122.454292042688)
104572 178 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 2900X 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     70 3x3   6007426.6373058 2106784.9094001 37.7652496025139 -122.41752593136002 (37.7652496025139, -122.41752593136)
104874 102425 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 88 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 4x4   6010035.0 2112492.0 37.7810663692444 -122.40890687992399 (37.7810663692444, -122.408906879924)
105956 181 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 2900X 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3x3   6007426.6373058 2106784.9094001 37.7652496025139 -122.41752593136002 (37.7652496025139, -122.41752593136)
106425 102423 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 99 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 4x4   6010101.0 2112468.0 37.7810041676544 -122.408676858386 (37.7810041676544, -122.408676858386)
108743 102416 Permitted Site 1 Washingtonia filifera :: California Fan Palm 189 299X 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6010975.6 2111650.5 37.7788084493495 -122.405593572608 (37.7788084493495, -122.405593572608)
110065 25125 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1636X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     35 20   6005246.3113281 2098818.4021849 37.7432525052647 -122.42450045675601 (37.7432525052647, -122.424500456756)
110708 102439 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1010 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4   6010010.0 2112396.0 37.7808013755178 -122.408986592248 (37.7808013755178, -122.408986592248)
110930 179 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 2900X 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   6007426.6373058 2106784.9094001 37.7652496025139 -122.41752593136002 (37.7652496025139, -122.41752593136)
111511 25010 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 500X Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     50 20   6004896.4850004995 2105439.5076575 37.7614127588524 -122.426181340905 (37.7614127588524, -122.426181340905)
116100 102437 Permitted Site 1 Washingtonia filifera :: California Fan Palm 189 999X Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6010518.0 2112007.0 37.77976171638 -122.40720173555799 (37.77976171638, -122.407201735558)
117676 102417 Permitted Site 1 Washingtonia filifera :: California Fan Palm 189 299X 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6010975.6 2111650.5 37.7788084493495 -122.405593572608 (37.7788084493495, -122.405593572608)
118154 102433 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1000 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4   6010518.0 2112007.0 37.77976171638 -122.40720173555799 (37.77976171638, -122.407201735558)
120167 102435 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1001 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4   6010518.0 2112007.0 37.77976171638 -122.40720173555799 (37.77976171638, -122.407201735558)
121267 44364 Permitted Site 1 Washingtonia filifera :: California Fan Palm 189 633 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/16/2014 12:00:00 AM   4x4 Permit Number 772539 6010135.35236378 2105346.34168851 37.761451663169204 -122.408055626463 (37.7614516631692, -122.408055626463)
121327 40177 Permitted Site 1 Washingtonia filifera :: California Fan Palm 189 2406 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1999 12:00:00 AM 20   Permit Number 41368 6008809.43227886 2104437.82814434 37.7588827650821 -122.41257722578301 (37.7588827650821, -122.412577225783)
122693 96497 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 2500X Harrison St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
127485 102438 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 999X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4   6010518.0 2112007.0 37.77976171638 -122.40720173555799 (37.77976171638, -122.407201735558)
128092 25062 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 1096X Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     40 20   6005084.164762099 2101955.0797665003 37.751855942534796 -122.42528427535 (37.7518559425348, -122.42528427535)
139605 102424 Permitted Site 1 Washingtonia filifera :: California Fan Palm 189 88 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010035.0 2112492.0 37.7810663692444 -122.40890687992399 (37.7810663692444, -122.408906879924)
141913 15060 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 10X Minerva St 3 Median : Cutout 11 Tree 1 DPW 2     3 11   5996572.9500165 2089038.2134875 37.7159048245128 -122.45378440062001 (37.7159048245128, -122.45378440062)
145524 96494 DPW Maintained 3 Washingtonia filifera :: California Fan Palm 189 2500X Harrison St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
145973 114481 Undocumented 2 Washingtonia filifera :: California Fan Palm 189 45 HOFF ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3       3x3   6006591.0 2106401.0 37.7641484227608 -122.420388955837 (37.7641484227608, -122.420388955837)

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