Street_Tree_List

Data source: data.sfgov.org

46 rows where PlotSize = "Width 0ft" and qSpecies = 45

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 0ft · 35 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
40074 40074 181349 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2254 29th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5987333.026000001 2099936.24 37.745293905616705 -122.48652117681601 (37.7452939056167, -122.486521176816)
50005 50005 181948 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1813 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5987556.2457 2098923.5959 37.742526463070796 -122.48567502435301 (37.7425264630708, -122.485675024353)
50906 50906 200055 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1800 Lane St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6014871.4407 2094140.9637 37.7309480732984 -122.390892168964 (37.7309480732984, -122.390892168964)
53292 53292 217579 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 636 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5992273.5996 2088560.7555 37.714346412845295 -122.46861011007299 (37.7143464128453, -122.468610110073)
54123 54123 140855 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 621 Euclid Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5996425.9427 2113796.2189 37.7838757026194 -122.45608143549101 (37.7838757026194, -122.456081435491)
61590 61590 137691 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2175 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5999187.5809 2111472.1809 37.7776526229954 -122.44635998308 (37.7776526229954, -122.44635998308)
66165 66165 186237 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1701 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984808.8655 2103347.0431 37.7545115739121 -122.495500689099 (37.7545115739121, -122.495500689099)
66397 66397 140854 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 623 Euclid Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5996411.3906 2113796.8958 37.783876725924294 -122.456131829019 (37.7838767259243, -122.456131829019)
68882 68882 184399 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2085 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5982287.3567 2100926.0377 37.7477162005877 -122.50404126767499 (37.7477162005877, -122.504041267675)
74280 74280 217578 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 308 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5993138.4427 2088550.8537 37.7143691463099 -122.46562017697799 (37.7143691463099, -122.465620176978)
130949 130949 181350 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2270 25th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5988575.9018 2099879.6972 37.745211025577895 -122.48221942866999 (37.7452110255779, -122.48221942867)
145225 145225 186232 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1701 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984802.7052 2103358.5602 37.754542835963505 -122.49552284211201 (37.7545428359635, -122.495522842112)
146433 146433 142182 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1400 Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6001064.3503 2110400.0934 37.7748159516075 -122.439790732155 (37.7748159516075, -122.439790732155)
147113 147113 184465 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2182 45th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5982354.8718 2100269.3302 37.745917034436296 -122.503759179813 (37.7459170344363, -122.503759179813)
149259 149259 181332 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1458 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5988697.9248 2105396.3508 37.760365379214605 -122.482201591019 (37.7603653792146, -122.482201591019)
152254 152254 183295 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1262 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5981829.8203 2106490.9182 37.762968869451896 -122.50603591567899 (37.7629688694519, -122.506035915679)
153152 153152 141053 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 196 PARKER AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5996969.9558 2113061.6744 37.781890048327206 -122.45414629097999 (37.7818900483272, -122.45414629098)
153549 153549 184960 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1990 41st Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983549.8392 2101614.3877 37.7496803803898 -122.499726609203 (37.7496803803898, -122.499726609203)
155475 155475 199669 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1909 Keith St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6015195.1623 2093397.888 37.7289256934462 -122.38972111920602 (37.7289256934462, -122.389721119206)
155906 155906 183281 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1267 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981168.1745 2106457.5745 37.762838347579006 -122.50832180491899 (37.762838347579, -122.508321804919)
159848 159848 184401 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2089 45th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5982289.7256 2100897.9487 37.74763921532389 -122.504030996054 (37.7476392153239, -122.504030996054)
162943 162943 185411 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2300 Sunset Blvd 26 unknown : Yard 19 Tree 1 Private 1     10 Width 0ft   5985100.1361 2099184.3909 37.7430991186582 -122.49418661978599 (37.7430991186582, -122.494186619786)
168193 168193 184402 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2091 45th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982290.4025 2100883.0582 37.7475983699641 -122.50402755264601 (37.7475983699641, -122.504027552646)
168439 168439 141052 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 196 PARKER AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5996973.34 2113043.0612 37.7818391354491 -122.454133238512 (37.7818391354491, -122.454133238512)
168473 168473 183216 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3150 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983362.6255 2100199.941 37.7457857131054 -122.500269432817 (37.7457857131054, -122.500269432817)
169846 169846 181318 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1283 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5989233.022000001 2106632.6794 37.7637911125829 -122.480441458463 (37.7637911125829, -122.480441458463)
170778 170778 200056 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1800 Lane St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6014859.3493 2094125.5746 37.730905147018106 -122.390932896146 (37.7309051470181, -122.390932896146)
173420 173420 184400 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2087 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5982288.7103 2100911.824 37.747677253327 -122.504035534429 (37.747677253327, -122.504035534429)
175663 175663 186234 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1701 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984803.2409 2103355.3462 37.7545340425765 -122.495520752512 (37.7545340425765, -122.495520752512)
182997 182997 184434 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3816 Quintara St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5981590.8846 2100821.8038 37.7473890220179 -122.506441860059 (37.7473890220179, -122.506441860059)
185576 185576 183218 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3150 Rivera St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983331.3887 2100197.9386 37.7457783815563 -122.50037729543199 (37.7457783815563, -122.500377295432)
185994 185994 181319 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1283 22nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5989233.7879 2106609.7025 37.7637280687606 -122.48043712751101 (37.7637280687606, -122.480437127511)
187103 187103 184430 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3808 Quintara St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981643.6784 2100823.1575 37.747395847077996 -122.50625940628099 (37.747395847078, -122.506259406281)
187983 187983 140856 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 619 Euclid Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5996442.8638 2113795.8805 37.783875744697596 -122.456022870631 (37.7838757446976, -122.456022870631)
188758 188758 217581 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 500 Randolph St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5992611.7697 2088555.8456 37.714352460703104 -122.467440914144 (37.7143524607031, -122.467440914144)

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