Street_Tree_List

Data source: data.sfgov.org

22 rows where qAddress = "420 Dolores St"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3824 3824 229287 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 420 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 SFUSD 6   2 6x6   6004863.64618 2105856.17124 37.7625549619753 -122.42632458341299 (37.7625549619753, -122.426324583413)
25705 25705 234339 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 3ft   6004868.93824 2105500.74139 37.7615793351331 -122.426280973507 (37.7615793351331, -122.426280973507)
29021 29021 234332 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 3ft   6004849.34041 2105800.52772 37.7624013694379 -122.42637009990601 (37.7624013694379, -122.426370099906)
31311 31311 229289 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 420 Dolores St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004878.07286 2105581.6287 37.7618019488243 -122.426255139588 (37.7618019488243, -122.426255139588)
33391 33391 229290 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 420 Dolores St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6004880.38436 2105530.63009 37.7616620493947 -122.426243514035 (37.7616620493947, -122.426243514035)
36529 36529 229288 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 420 Dolores St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6004867.71345 2105767.79402 37.76231252903371 -122.42630422366699 (37.7623125290337, -122.426304223667)
39365 39365 234337 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 3ft   6004866.4127400005 2105541.3308900003 37.7616906415182 -122.42629259813299 (37.7616906415182, -122.426292598133)
40316 40316 220130 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   6004868.33246 2105707.1608700003 37.7621460797944 -122.42629776564199 (37.7621460797944, -122.426297765642)
44771 44771 234338 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     37 Width 3ft   6004867.72819 2105514.5268599996 37.761617118366104 -122.42628614009199 (37.7616171183661, -122.426286140092)
47019 47019 244022 Undocumented 2 :: 54 420 Dolores St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 1ft   6004861.89835 2105875.95275 37.762609178502004 -122.42633203700599 (37.762609178502, -122.426332037006)
52654 52654 220128 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   6004866.25236 2105787.5349 37.762366650211796 -122.4263106826 (37.7623666502118, -122.4263106826)
52883 52883 220131 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 6ft   6004876.29383 2105622.20284 37.761913255226396 -122.42626418136999 (37.7619132552264, -122.42626418137)
53723 53723 220129 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   6004868.0084 2105745.84567 37.762252280750204 -122.426301640812 (37.7622522807502, -122.426301640812)
72122 72122 234341 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35 Width 3ft   6004869.93402 2105476.5468200003 37.7615129588681 -122.42627580688401 (37.7615129588681, -122.426275806884)
75986 75986 220127 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 6ft   6004864.426659999 2105831.25856 37.762486601794 -122.426320110198 (37.762486601794, -122.426320110198)
131778 131778 234335 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 3ft   6004864.336759999 2105585.63058 37.7618121606106 -122.42630293224899 (37.7618121606106, -122.426302932249)
135856 135856 234333 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 3ft   6004857.87037 2105688.78101 37.762095021687706 -122.42633264136002 (37.7620950216877, -122.42633264136)
136108 136108 234331 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 3ft   6004849.00155 2105814.83535 37.762440635635 -122.426372290646 (37.762440635635, -122.426372290646)
160623 160623 234336 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 3ft   6004864.2449199995 2105581.16954 37.7617999064621 -122.42630293226101 (37.7617999064621, -122.426302932261)
163745 163745 234334 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 3ft   6004862.85296 2105604.25637 37.7618632187373 -122.426309390288 (37.7618632187373, -122.426309390288)
174417 174417 220557 Undocumented 2 Aesculus x carnea :: Red Horse Chestnut 194 420 Dolores St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004878.61123 2105553.35269 37.761724340040296 -122.42625126438101 (37.7617243400403, -122.426251264381)
181869 181869 234340 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     39 Width 3ft   6004869.08955 2105489.95301 37.7615497213531 -122.42627968206499 (37.7615497213531, -122.426279682065)

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