Street_Tree_List

Data source: data.sfgov.org

58 rows where qSpecies = 65

View and edit SQL

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
241 251257 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1748x Eucalyptus Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
251 251258 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1748x Eucalyptus Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
9191 110478 Permitted Site 1 Phoenix dactylifera :: Date Palm 65 151 VALENCIA ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 9x8   6006061.0 2108804.0 37.7707166091945 -122.42239282710301 (37.7707166091945, -122.422392827103)
18244 22894 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 178 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/02/1994 12:00:00 AM 6 3X3   6006031.57399 2108654.01225 37.77030311873 -122.42248395306801 (37.77030311873, -122.422483953068)
18956 25081 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 1200X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2   10/03/2012 12:00:00 AM 20 20   6005156.57495 2101303.54282 37.7500710634364 -122.424987519083 (37.7500710634364, -122.424987519083)
19091 25124 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 1550 Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     40 20   6005279.44295 2099098.5457599997 37.744023586718505 -122.42440581777299 (37.7440235867185, -122.424405817773)
21087 18534 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 268 Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   6006513.583380001 2098175.5573400003 37.741558882232 -122.420072941732 (37.741558882232, -122.420072941732)
23483 234406 Undocumented 2 Phoenix dactylifera :: Date Palm 65 147 Valencia St 1 : 4 Tree 1 Private 1     20 Width 8ft   6006058.10348 2108951.831 37.7711223543454 -122.422413351811 (37.7711223543454, -122.422413351811)
25359 178092 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1021 Excelsior Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6004868.00529 2091200.35953 37.7223136907999 -122.425266563405 (37.7223136907999, -122.425266563405)
29131 194397 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1797 Bancroft Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 1ft   6013420.92243 2092796.80792 37.7271767046165 -122.39581273756501 (37.7271767046165, -122.395812737565)
34120 194400 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1121 Jamestown Ave 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6013373.9192 2090059.88362 37.7196590468175 -122.395783535707 (37.7196590468175, -122.395783535707)
35591 201709 Undocumented 2 Phoenix dactylifera :: Date Palm 65 2 Coronado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 8ft   6014934.03017 2089213.58115 37.717421931959 -122.39033164850201 (37.717421931959, -122.390331648502)
36530 178093 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1021 Excelsior Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6004866.88335 2091211.98696 37.722345553797204 -122.42527126868099 (37.7223455537972, -122.425271268681)
39900 178090 Undocumented 2 Phoenix dactylifera :: Date Palm 65 45 Paulding St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 8ft   6000057.910180001 2093284.3412900001 37.7277629052183 -122.442043393704 (37.7277629052183, -122.442043393704)
49162 234414 Undocumented 2 Phoenix dactylifera :: Date Palm 65 280 2 : Yard 23 Tree 1 Private 1     23 Width 3ft   6005979.042880001 2094923.96665 37.7326006076366 -122.421690307661 (37.7326006076366, -122.421690307661)
52508 178097 Undocumented 2 Phoenix dactylifera :: Date Palm 65 201 Trumbull St 71 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6004719.38437 2094363.75444 37.7309912771155 -122.426005390643 (37.7309912771155, -122.426005390643)
52593 69360 Permitted Site 1 Phoenix dactylifera :: Date Palm 65 1695 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/1994 12:00:00 AM 4   Permit Number 33454 6002664.21541 2120911.8448 37.803769467759 -122.435008424509 (37.803769467759, -122.435008424509)
53522 178094 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1015 Excelsior Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6004860.24486 2091216.32738 37.7223570965959 -122.425294525118 (37.7223570965959, -122.425294525118)
56452 178096 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1015 Excelsior Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 2ft   6004838.97157 2091229.6389400002 37.7223924453503 -122.425369008793 (37.7223924453503, -122.425369008793)
57380 201708 Undocumented 2 Phoenix dactylifera :: Date Palm 65 5 Coronado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 8ft   6014858.65018 2089061.02704 37.716998866568204 -122.390581550311 (37.7169988665682, -122.390581550311)
59059 185246 Undocumented 2 Phoenix dactylifera :: Date Palm 65 2563 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 0ft   5986117.5685 2097805.0277 37.739371240559294 -122.49056719930901 (37.7393712405593, -122.490567199309)
60919 194401 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1121 Jamestown Ave 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15     6013389.43326 2090047.39318 37.719625613600996 -122.39572903407101 (37.719625613601, -122.395729034071)
64052 194399 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1121 Jamestown Ave 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6013370.43296 2090062.5178 37.719666085808896 -122.395795770954 (37.7196660858089, -122.395795770954)
64217 234405 Undocumented 2 Phoenix dactylifera :: Date Palm 65 177 Valencia St 3 : 4 Tree 1 Private 1     22 Width 8ft   6006077.65974 2108680.63405 37.770378815562296 -122.422326434118 (37.7703788155623, -122.422326434118)
66091 194396 Undocumented 2 Phoenix dactylifera :: Date Palm 65 404 Texas St 2 : 4 Tree 1 Private 1     5 Width 3ft   6013753.00749 2105172.57058 37.7611764136899 -122.395531390984 (37.7611764136899, -122.395531390984)
67699 249892 Undocumented 2 Phoenix dactylifera :: Date Palm 65 230 Greenwich St 28 Back Yard : Yard 13 Tree 1 Private 1     36 Width 0ft   6011427.28959 2120425.37078 37.80292740013321 -122.404648882458 (37.8029274001332, -122.404648882458)
72537 185064 Undocumented 2 Phoenix dactylifera :: Date Palm 65 20 Crestlake Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     34 Width 0ft   5989046.5946 2096130.9763 37.7349453809922 -122.480317540903 (37.7349453809922, -122.480317540903)
72909 194398 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1121 Jamestown Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6013340.66521 2090086.19155 37.7197294331555 -122.395900326164 (37.7197294331555, -122.395900326164)
76163 113320 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 175X VALENCIA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6006045.0 2108809.0 37.7707294354185 -122.42244852678101 (37.7707294354185, -122.422448526781)
87764 107481 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 1300x Montgomery St 1 Median : Cutout 11 Tree 1 DPW 2           6011490.9987699995 2119741.7952799997 37.801054029046504 -122.404380271142 (37.8010540290465, -122.404380271142)
88934 107130 Property Tree 7 Phoenix dactylifera :: Date Palm 65 751 DOLORES ST 1 Front Yard : Cutout 8 Tree 1 Private 1           6005081.8 2103948.4 37.7573290011944 -122.42543429450701 (37.7573290011944, -122.425434294507)
98727 25142 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 1798X Dolores St 8 Median : Cutout 11 Tree 1 DPW 2     36 20   6005303.475850901 2097774.014097 37.740388080432204 -122.42422853472999 (37.7403880804322, -122.42422853473)
105982 30675 Permitted Site 1 Phoenix dactylifera :: Date Palm 65 1040 Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM   3x3 Permit Number 34599 6007565.37727332 2109755.15641274 37.77341300719829 -122.417256559972 (37.7734130071983, -122.417256559972)
116920 234415 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 10x Benton Ave 5 Median : Yard 3 Tree 1 DPW 2     33     6004760.79404 2095007.84902 37.732762157335 -122.425908061504 (37.732762157335, -122.425908061504)
125406 113318 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 174 VALENCIA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6005996.0 2108657.0 37.7703093154737 -122.42260721592699 (37.7703093154737, -122.422607215927)
127275 234411 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 10x Benton Ave 4 Median : Yard 3 Tree 1 DPW 2     32     6004755.33467 2095032.93123 37.7328307189427 -122.42592872073601 (37.7328307189427, -122.425928720736)
129806 234413 Undocumented 2 Phoenix dactylifera :: Date Palm 65 280 Justin Dr 1 : Yard 23 Tree 1 Private 1     26 Width 3ft   6005966.47626 2094899.24737 37.7325320253145 -122.42173199844 (37.7325320253145, -122.42173199844)
132669 210932 Undocumented 2 Phoenix dactylifera :: Date Palm 65 116 Tara St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 6ft   5998072.9046 2090918.0343900002 37.7211522595526 -122.44873519869199 (37.7211522595526, -122.448735198692)
133494 178098 Undocumented 2 Phoenix dactylifera :: Date Palm 65 638 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009383.33887 2092966.76941 37.727417941465895 -122.409782676733 (37.7274179414659, -122.409782676733)
150552 132134 Undocumented 2 Phoenix dactylifera :: Date Palm 65 844 Bay St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     18 Width 3ft   6006665.94728 2121190.24519 37.8047602904276 -122.42117996220101 (37.8047602904276, -122.421179962201)
151061 210933 Undocumented 2 Phoenix dactylifera :: Date Palm 65 154 Margaret Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     27 Width 10ft   5996718.73035 2089319.81928 37.716686405220706 -122.45330083726299 (37.7166864052207, -122.453300837263)
152953 119952 Undocumented 2 Phoenix dactylifera :: Date Palm 65 300 28th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 3ft   5987169.40244 2113876.4433 37.783560313977205 -122.488111110065 (37.7835603139772, -122.488111110065)
154426 210929 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1 Marne Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 4ft   5995223.39717 2097839.86385 37.7399945663944 -122.459086001528 (37.7399945663944, -122.459086001528)
156328 132135 Undocumented 2 Phoenix dactylifera :: Date Palm 65 844 Bay St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     16 Width 3ft   6006652.21719 2121188.57892 37.8047549412394 -122.42122735827299 (37.8047549412394, -122.421227358273)
157364 234416 Undocumented 2 Phoenix dactylifera :: Date Palm 65 567 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6003675.33514 2104944.37224 37.7599841383641 -122.430369460604 (37.7599841383641, -122.430369460604)
158934 210931 Undocumented 2 Phoenix dactylifera :: Date Palm 65 2 Edna St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32     5998770.31007 2092974.74869 37.7268393752316 -122.446472369507 (37.7268393752316, -122.446472369507)
159594 178095 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1015 Excelsior Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 2ft   6004841.82949 2091227.47838 37.7223866743918 -122.42535897594401 (37.7223866743918, -122.425358975944)
164439 234404 Undocumented 2 Phoenix dactylifera :: Date Palm 65 100 Valencia St 3 : 4 Tree 1 Private 1     20 Width 8ft   6006014.35416 2108978.5943299998 37.771193371997796 -122.422566584574 (37.7711933719978, -122.422566584574)
167167 210930 Undocumented 2 Phoenix dactylifera :: Date Palm 65 2 Edna St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     44     5998770.14435 2092952.3628099998 37.726777899364706 -122.446471332592 (37.7267778993647, -122.446471332592)
169078 234409 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 1750x Dolores St 2 Median : Yard 3 Tree 1 DPW 2     18     6005335.117769999 2098093.36784 37.7412667401708 -122.42414183529499 (37.7412667401708, -122.424141835295)
175393 234410 Undocumented 2 Phoenix dactylifera :: Date Palm 65 2230 Bryant St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009609.68289 2104362.91127 37.75872193988779 -122.40980428656401 (37.7587219398878, -122.409804286564)
176401 234412 Undocumented 2 Phoenix dactylifera :: Date Palm 65 270 Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     31 Width 4ft   6006505.66108 2098159.0005200002 37.7415129745481 -122.420099159673 (37.7415129745481, -122.420099159673)
178500 178089 Undocumented 2 Phoenix dactylifera :: Date Palm 65 627 Paris St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     37     6001428.27595 2089993.7852 37.7188057808522 -122.43707053397499 (37.7188057808522, -122.437070533975)
186368 234408 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 1700x Dolores St 6 Median : Yard 3 Tree 1 DPW 2     18     6005328.71951 2098210.15562 37.7415870517023 -122.424172262039 (37.7415870517023, -122.424172262039)
187720 249956 Undocumented 2 Phoenix dactylifera :: Date Palm 65 285 Filbert St 2 Side Yard : Yard 17 Tree 1 Private 1     23 Width 0ft   6011495.629790001 2120073.57822 37.8019652829314 -122.404387612316 (37.8019652829314, -122.404387612316)
188023 234407 DPW Maintained 3 Phoenix dactylifera :: Date Palm 65 100x Dolores St 8 Median : Yard 3 Tree 1 DPW 2     18     6004812.29017 2107562.9589 37.7672384899902 -122.426623750084 (37.7672384899902, -122.426623750084)
188777 201710 Undocumented 2 Phoenix dactylifera :: Date Palm 65 2 Coronado St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 8ft   6014843.669840001 2089083.1115 37.717058675093604 -122.390634872922 (37.7170586750936, -122.390634872922)
188922 178091 Undocumented 2 Phoenix dactylifera :: Date Palm 65 327 Maynard St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 8ft   6005482.9740699995 2093860.26389 37.7296519293885 -122.42332975108101 (37.7296519293885, -122.423329751081)

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