Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4344 | 4344 | 253624 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 735 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2095994.0 | 37.735140362702396 | -122.446033688862 | (37.7351403627024, -122.446033688862) | ||||
27623 | 27623 | 192472 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 654 Minnesota St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015145.36132 | 2105441.65157 | 37.7619925996904 | -122.39073459873 | (37.7619925996904, -122.39073459873) | |||
29108 | 29108 | 190519 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 299 Bryant St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6015412.9478400005 | 2114035.0221599997 | 37.785602934875 | -122.39040956394501 | (37.785602934875, -122.390409563945) | |||
29354 | 29354 | 228255 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 470 Liberty St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6003278.43337 | 2103915.98823 | 37.7571379513705 | -122.43166872824301 | (37.7571379513705, -122.431668728243) | |||
29807 | 29807 | 226269 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 601 Grand View Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6000052.32454 | 2101592.71128 | 37.7505754059276 | -122.442659008402 | (37.7505754059276, -122.442659008402) | |||
31920 | 31920 | 228243 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 396 Cumberland St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6003155.66776 | 2104492.3906900003 | 37.758713655324 | -122.43213446015301 | (37.758713655324, -122.432134460153) | |||
32867 | 32867 | 219077 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 494 Victoria St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993267.6387 | 2090426.62452 | 37.7195270128342 | -122.465309800205 | (37.7195270128342, -122.465309800205) | |||
38697 | 38697 | 228343 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 50 Everson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6003603.71357 | 2097148.2169 | 37.7385736618306 | -122.43006100933201 | (37.7385736618306, -122.430061009332) | |||
39620 | 39620 | 124187 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 40 Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5995896.10311 | 2112493.6287599998 | 37.7802687106807 | -122.45782018278999 | (37.7802687106807, -122.45782018279) | ||||
43260 | 43260 | 192448 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2310 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6010888.50248 | 2105103.3176 | 37.7608265135647 | -122.40543366323 | (37.7608265135647, -122.40543366323) | |||
47942 | 47942 | 219125 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 149 Hamerton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6001356.75125 | 2095315.06653 | 37.733412742195505 | -122.43769866186899 | (37.7334127421955, -122.437698661869) | |||
48307 | 48307 | 192459 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 651 Indiana St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6014938.7100599995 | 2105394.68115 | 37.761852161564605 | -122.391446047021 | (37.7618521615646, -122.391446047021) | |||
49658 | 49658 | 190382 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2350 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6011068.2259 | 2104645.22046 | 37.7595787284893 | -122.404779824648 | (37.7595787284893, -122.404779824648) | |||
55598 | 55598 | 219114 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 409 Bella Vista Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997404.49541 | 2096329.01275 | 37.73597127834321 | -122.451435758472 | (37.7359712783432, -122.451435758472) | |||
57546 | 57546 | 219112 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Brentwood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5995677.34458 | 2095602.5386599998 | 37.7338775046316 | -122.457354631219 | (37.7338775046316, -122.457354631219) | |||
58695 | 58695 | 190381 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2350 20th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6011079.30934 | 2104645.54641 | 37.7595802429642 | -122.404741515334 | (37.7595802429642, -122.404741515334) | |||
63296 | 63296 | 129013 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 150 Francisco St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6010602.08919 | 2121361.05101 | 37.8054503923804 | -122.40757052527799 | (37.8054503923804, -122.407570525278) | ||||
71739 | 71739 | 219142 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 255 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998385.58971 | 2093771.8377200002 | 37.7290060129005 | -122.44785969336901 | (37.7290060129005, -122.447859693369) | ||||
71798 | 71798 | 192460 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 651 Indiana St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6014934.120519999 | 2105449.3054400003 | 37.7620018933059 | -122.391465739479 | (37.7620018933059, -122.391465739479) | |||
74303 | 74303 | 192449 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2310 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010874.27982 | 2105104.21282 | 37.760828176397 | -122.405482916403 | (37.760828176397, -122.405482916403) | |||
75653 | 75653 | 219115 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 409 Bella Vista Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5997400.88581 | 2096335.81192 | 37.7359897405315 | -122.451448728489 | (37.7359897405315, -122.451448728489) | |||
129993 | 129993 | 128906 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 586 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5997146.092730001 | 2113991.53957 | 37.7844533108166 | -122.453604104844 | (37.7844533108166, -122.453604104844) | |||
136093 | 136093 | 219113 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 409 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997408.05803 | 2096319.9732700002 | 37.7359466621108 | -122.451422789356 | (37.7359466621108, -122.451422789356) | |||
138013 | 138013 | 192450 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2310 19th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010867.63579 | 2105104.33666 | 37.7608281449347 | -122.40550590399599 | (37.7608281449347, -122.405505903996) | |||
147869 | 147869 | 176549 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 65 Ocean Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6001075.93443 | 2091730.69509 | 37.7235549090091 | -122.438412809004 | (37.7235549090091, -122.438412809004) | ||||
148595 | 148595 | 192474 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 654 Minnesota St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6015149.97171 | 2105400.79096 | 37.761880661075395 | -122.390715797509 | (37.7618806610754, -122.390715797509) | |||
155568 | 155568 | 192451 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2310 19th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6010858.43231 | 2105104.6131700003 | 37.760828389551705 | -122.405537754389 | (37.7608283895517, -122.405537754389) | |||
158625 | 158625 | 129012 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 150 Francisco St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6010624.52904 | 2121364.4676099997 | 37.8054610295673 | -122.40749310981501 | (37.8054610295673, -122.407493109815) | ||||
159270 | 159270 | 190365 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1401 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6014443.688019999 | 2101979.23692 | 37.75244659923371 | -122.392919179687 | (37.7524465992337, -122.392919179687) | ||||
160784 | 160784 | 192473 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 654 Minnesota St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6015149.47337 | 2105409.76647 | 37.7619052782381 | -122.390718148338 | (37.7619052782381, -122.390718148338) | |||
168120 | 168120 | 129006 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.41321064328301 | (37.7977154080083, -122.413210643283) | ||||
168686 | 168686 | 190518 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 299 Bryant St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6015402.02385 | 2114023.64667 | 37.785571094386 | -122.390446562985 | (37.785571094386, -122.390446562985) | |||
172043 | 172043 | 228254 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 470 Liberty St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003313.06662 | 2103916.0849200003 | 37.7571401799037 | -122.431548960114 | (37.7571401799037, -122.431548960114) |
JSON shape: default, array, newline-delimited
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");