Street_Tree_List

Data source: data.sfgov.org

41 rows where qLegalStatus = 2 and qSpecies = 65

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

qLegalStatus ✖

  • Undocumented · 41 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
241 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 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)
23483 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 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 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 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 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 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 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 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 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)
53522 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 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 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 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 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 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 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 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 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 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 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)
129806 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 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 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 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 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 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 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 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 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 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 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 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 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)
175393 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 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 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)
187720 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)
188777 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 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 2875.239ms · Data source: data.sfgov.org