Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24557 | 24557 | 136431 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 13 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6008632.90068 | 2119166.6230200003 | 37.799314619318 | -122.414229834152 | (37.799314619318, -122.414229834152) | ||||
| 25384 | 25384 | 185213 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985153.279 | 2098105.011 | 37.740138541922 | -122.49392333934799 | (37.740138541922, -122.493923339348) | |||
| 26484 | 26484 | 184736 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984658.5537 | 2106283.3352 | 37.762565010947704 | -122.49623713063801 | (37.7625650109477, -122.496237130638) | |||
| 27330 | 27330 | 187124 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985135.2439 | 2097353.8058 | 37.738074878751895 | -122.493930349328 | (37.7380748787519, -122.493930349328) | |||
| 29043 | 29043 | 181547 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984881.425 | 2105994.983 | 37.761786329172104 | -122.495445043427 | (37.7617863291721, -122.495445043427) | |||
| 29532 | 29532 | 186369 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1801 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984816.0737 | 2102538.2484 | 37.7522912688492 | -122.495416115464 | (37.7522912688492, -122.495416115464) | |||
| 30220 | 30220 | 181484 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1400 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984898.4123 | 2105356.9862 | 37.7600355628364 | -122.49533923888201 | (37.7600355628364, -122.495339238882) | |||
| 34861 | 34861 | 240630 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6003226.48563 | 2097681.33135 | 37.7400160997695 | -122.43140332841999 | (37.7400160997695, -122.43140332842) | ||||
| 35086 | 35086 | 185875 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985024.3241 | 2101081.1994 | 37.74830280287971 | -122.494588557862 | (37.7483028028797, -122.494588557862) | |||
| 35152 | 35152 | 215041 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 497 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998794.49638 | 2094951.64479 | 37.732268849509104 | -122.44653092436701 | (37.7322688495091, -122.446530924367) | |||
| 35177 | 35177 | 184804 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984679.0585 | 2105723.8188 | 37.7610299368102 | -122.496124931271 | (37.7610299368102, -122.496124931271) | |||
| 36125 | 36125 | 186472 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1601 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984790.3524 | 2103740.0582 | 37.755589600564704 | -122.495593697553 | (37.7555896005647, -122.495593697553) | |||
| 36375 | 36375 | 136443 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013384.0493 | 2118922.9353099996 | 37.7989112401317 | -122.39777198798201 | (37.7989112401317, -122.397771987982) | ||||
| 36809 | 36809 | 215040 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 88 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5994178.77111 | 2090487.7098599998 | 37.71974724151371 | -122.46216479907 | (37.7197472415137, -122.46216479907) | ||||
| 37950 | 37950 | 247598 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 900 Tompkins Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6009167.823059999 | 2096407.9062599998 | 37.7368544863348 | -122.410770639572 | (37.7368544863348, -122.410770639572) | |||
| 38278 | 38278 | 215037 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 314 Staples Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5997982.72892 | 2093830.4607099998 | 37.7291439428352 | -122.449256629186 | (37.7291439428352, -122.449256629186) | ||||
| 38662 | 38662 | 215039 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 179 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5994134.23715 | 2091156.84385 | 37.721581958319504 | -122.462367242757 | (37.7215819583195, -122.462367242757) | ||||
| 40320 | 40320 | 187361 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985088.1562 | 2099814.8531 | 37.7448294961486 | -122.49427450340099 | (37.7448294961486, -122.494274503401) | |||
| 40656 | 40656 | 186033 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985025.9241 | 2102045.6103 | 37.7509509050251 | -122.49465411447399 | (37.7509509050251, -122.494654114474) | |||
| 40898 | 40898 | 185564 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984920.5667 | 2099758.7289 | 37.744665585625896 | -122.494849850524 | (37.7446655856259, -122.494849850524) | |||
| 41346 | 41346 | 181435 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984924.5894 | 2104933.1403 | 37.7588733327201 | -122.495217449651 | (37.7588733327201, -122.495217449651) | |||
| 41820 | 41820 | 136433 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2671 Leavenworth St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 6007318.566930001 | 2121838.23641 | 37.8065762788357 | -122.418967487863 | (37.8065762788357, -122.418967487863) | ||||
| 43173 | 43173 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 43258 | 43258 | 240627 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002066.06456 | 2097929.8821400004 | 37.7406327271153 | -122.43543335598 | (37.7406327271153, -122.43543335598) | ||||
| 43998 | 43998 | 136441 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6013371.772919999 | 2118938.4754 | 37.798953225861 | -122.397815559237 | (37.798953225861, -122.397815559237) | ||||
| 44071 | 44071 | 181543 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984893.6781 | 2105927.5909 | 37.761602006776 | -122.49539769507 | (37.761602006776, -122.49539769507) | |||
| 44202 | 44202 | 186673 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984739.5822 | 2105465.3048 | 37.7603236745559 | -122.495896538326 | (37.7603236745559, -122.495896538326) | |||
| 45421 | 45421 | 240621 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 219 Upper Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 3ft | 5999599.462169999 | 2106267.78648 | 37.7633861864367 | -122.444561006196 | (37.7633861864367, -122.444561006196) | |||
| 47297 | 47297 | 240626 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6002059.772469999 | 2097912.30108 | 37.740584096269295 | -122.435453854224 | (37.7405840962693, -122.435453854224) | ||||
| 47961 | 47961 | 136435 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013344.909530001 | 2118921.0971 | 37.7989040131614 | -122.39790729640801 | (37.7989040131614, -122.397907296408) | ||||
| 48209 | 48209 | 136445 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6013392.00591 | 2118921.55061 | 37.79890788115829 | -122.397744358119 | (37.7989078811583, -122.397744358119) | ||||
| 48439 | 48439 | 181387 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984939.8638 | 2104520.2223 | 37.757740468934294 | -122.495134175513 | (37.7577404689343, -122.495134175513) | |||
| 50233 | 50233 | 187392 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2100 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985024.2566 | 2100630.9061 | 37.7470664162932 | -122.494555600597 | (37.7470664162932, -122.494555600597) | |||
| 50578 | 50578 | 136439 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013363.76971 | 2118922.4292 | 37.7989087211284 | -122.397842127014 | (37.7989087211284, -122.397842127014) | ||||
| 51589 | 51589 | 184745 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984671.0844 | 2106181.5705 | 37.7622863276384 | -122.496186283596 | (37.7622863276384, -122.496186283596) | |||
| 52535 | 52535 | 187380 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985069.8747 | 2100065.0386 | 37.7455153678045 | -122.494356154683 | (37.7455153678045, -122.494356154683) | |||
| 53755 | 53755 | 136438 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6013355.98644 | 2118932.3733599996 | 37.798935591968004 | -122.39786975780301 | (37.798935591968, -122.397869757803) | ||||
| 55401 | 55401 | 181491 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1400 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984894.5136 | 2105385.9481 | 37.760114855862604 | -122.49535485835699 | (37.7601148558626, -122.495354858357) | |||
| 55573 | 55573 | 184741 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984704.12 | 2106224.4787 | 37.76240607654479 | -122.496075193313 | (37.7624060765448, -122.496075193313) | |||
| 57134 | 57134 | 186036 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985023.9883 | 2102086.2614 | 37.7510624084937 | -122.49466380518 | (37.7510624084937, -122.49466380518) | |||
| 59035 | 59035 | 186092 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1901 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984860.3007 | 2101794.0493 | 37.750250492095795 | -122.495208298659 | (37.7502504920958, -122.495208298659) | |||
| 59256 | 59256 | 187358 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985096.2813 | 2099797.9258 | 37.7447834938464 | -122.494245161303 | (37.7447834938464, -122.494245161303) | |||
| 60464 | 60464 | 186891 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985178.2577 | 2096509.7223 | 37.7357597676042 | -122.493719449451 | (37.7357597676042, -122.493719449451) | |||
| 63429 | 63429 | 181539 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984878.0833 | 2105873.5659 | 37.761452756110394 | -122.4954476457 | (37.7614527561104, -122.4954476457) | |||
| 63967 | 63967 | 185633 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2100 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985076.9465 | 2100353.2830000003 | 37.7463072224732 | -122.494352945117 | (37.7463072224732, -122.494352945117) | |||
| 64455 | 64455 | 181395 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984933.1803 | 2104579.26 | 37.7579021787746 | -122.495161642957 | (37.7579021787746, -122.495161642957) | |||
| 64589 | 64589 | 186730 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984855.0036 | 2106288.7736 | 37.7625914487693 | -122.495558092973 | (37.7625914487693, -122.495558092973) | |||
| 65616 | 65616 | 247596 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 900 Tompkins Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6009145.02453 | 2096408.71868 | 37.73685543873 | -122.410849521814 | (37.73685543873, -122.410849521814) | |||
| 65956 | 65956 | 185096 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2801 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985018.6615 | 2095986.0271 | 37.7343125019956 | -122.494232639372 | (37.7343125019956, -122.494232639372) | |||
| 66493 | 66493 | 185214 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985123.3973 | 2098105.6751 | 37.7401386169566 | -122.494026705548 | (37.7401386169566, -122.494026705548) | |||
| 69472 | 69472 | 181545 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984885.3237 | 2105962.1224 | 37.7616963314413 | -122.495429135957 | (37.7616963314413, -122.495429135957) | |||
| 69595 | 69595 | 240624 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002039.42489 | 2097863.5246099997 | 37.7404490118051 | -122.4355207197 | (37.7404490118051, -122.4355207197) | ||||
| 70736 | 70736 | 247974 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 346 Peralta Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6009790.92788 | 2099185.07173 | 37.7445148980554 | -122.408812155357 | (37.7445148980554, -122.408812155357) | ||||
| 70926 | 70926 | 186856 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985217.4528 | 2096293.5766 | 37.735168582064794 | -122.49356801735901 | (37.7351685820648, -122.493568017359) | |||
| 71275 | 71275 | 187306 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 89 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984963.8587 | 2098228.7818 | 37.7404672985278 | -122.494587390296 | (37.7404672985278, -122.494587390296) | |||
| 71910 | 71910 | 186966 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985198.0961 | 2096141.0368 | 37.734748616014 | -122.493623703195 | (37.734748616014, -122.493623703195) | |||
| 72190 | 72190 | 179498 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 892 Peru Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6005545.45161 | 2091807.84398 | 37.7240199601485 | -122.422967943043 | (37.7240199601485, -122.422967943043) | ||||
| 73058 | 73058 | 186967 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985210.5401 | 2096146.418 | 37.7347641193316 | -122.493581077021 | (37.7347641193316, -122.493581077021) | |||
| 73907 | 73907 | 186731 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984870.0408 | 2106303.059 | 37.7626315529982 | -122.495507139178 | (37.7626315529982, -122.495507139178) | |||
| 74058 | 74058 | 186679 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984735.2903 | 2105403.2290000003 | 37.760152980386 | -122.495906802394 | (37.760152980386, -122.495906802394) | |||
| 74083 | 74083 | 187107 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985143.7078 | 2097238.6019 | 37.73775905490071 | -122.49389259826401 | (37.7377590549007, -122.493892598264) | |||
| 74195 | 74195 | 240615 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 297 Cumberland St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6003715.872169999 | 2104475.4119700002 | 37.75869878143 | -122.430195805998 | (37.75869878143, -122.430195805998) | |||
| 74839 | 74839 | 187109 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985172.8615 | 2097253.1787 | 37.7378007845896 | -122.493792875188 | (37.7378007845896, -122.493792875188) | |||
| 75777 | 75777 | 240625 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6002051.53836 | 2097889.55934 | 37.7405211850978 | -122.43548069809799 | (37.7405211850978, -122.435480698098) | ||||
| 77228 | 77228 | 136442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6013378.377640001 | 2118933.3014 | 37.7989393870992 | -122.397792341438 | (37.7989393870992, -122.397792341438) | ||||
| 78522 | 78522 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 81040 | 81040 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 85824 | 85824 | 112921 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 89530 | 89530 | 112922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 100331 | 100331 | 112930 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 105322 | 105322 | 181478 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1400 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984917.9059 | 2105334.1509 | 37.759974004815795 | -122.495270136852 | (37.7599740048158, -122.495270136852) | |||
| 115520 | 115520 | 112925 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 117865 | 117865 | 112928 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 128076 | 128076 | 112923 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 131451 | 131451 | 136444 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013387.59339 | 2118931.12048 | 37.798933912018704 | -122.397760298614 | (37.7989339120187, -122.397760298614) | ||||
| 132343 | 132343 | 185730 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984911.7584 | 2100300.7286 | 37.7461532538825 | -122.494920263061 | (37.7461532538825, -122.494920263061) | |||
| 134037 | 134037 | 186968 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985205.8316 | 2096154.4897 | 37.73478600662639 | -122.49359795024999 | (37.7347860066264, -122.49359795025) | |||
| 134490 | 134490 | 215036 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 694 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5996922.84392 | 2094438.19015 | 37.7307519414457 | -122.45296456906901 | (37.7307519414457, -122.452964569069) | ||||
| 134633 | 134633 | 187307 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 90 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984946.0227 | 2098230.3328 | 37.740470513218796 | -122.49464917361601 | (37.7404705132188, -122.494649173616) | |||
| 135635 | 135635 | 240594 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 216 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6003152.3623 | 2096416.5644900003 | 37.736539139077394 | -122.43156934507401 | (37.7365391390774, -122.431569345074) | ||||
| 136288 | 136288 | 181391 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984921.4841 | 2104558.6525 | 37.757844911537 | -122.495200573085 | (37.757844911537, -122.495200573085) | |||
| 136491 | 136491 | 185568 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984938.6086 | 2099724.7676 | 37.74457339320529 | -122.49478496266701 | (37.7445733932053, -122.494784962667) | |||
| 140824 | 140824 | 112927 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 141641 | 141641 | 112926 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 142904 | 142904 | 112920 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 146439 | 146439 | 187127 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985167.6891 | 2097369.3231 | 37.7381193834059 | -122.49381931494301 | (37.7381193834059, -122.493819314943) | |||
| 147246 | 147246 | 215043 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 798 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5996915.73734 | 2095029.5626400001 | 37.732375301382 | -122.453031809567 | (37.732375301382, -122.453031809567) | ||||
| 148152 | 148152 | 186376 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1801 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984798.5659 | 2102512.3907 | 37.7522192455734 | -122.495474752392 | (37.7522192455734, -122.495474752392) | |||
| 149148 | 149148 | 185877 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985055.2583 | 2101098.876 | 37.7483531484939 | -122.494482892668 | (37.7483531484939, -122.494482892668) | |||
| 150118 | 150118 | 240628 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6003238.63031 | 2097694.69053 | 37.740053469295795 | -122.431362290536 | (37.7400534692958, -122.431362290536) | ||||
| 152027 | 152027 | 136436 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013350.43599 | 2118931.2626099996 | 37.7989322330038 | -122.397888886371 | (37.7989322330038, -122.397888886371) | ||||
| 152219 | 152219 | 184995 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2701 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985022.2207 | 2096528.9025 | 37.7358033013739 | -122.494260335606 | (37.7358033013739, -122.494260335606) | |||
| 153291 | 153291 | 136440 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013367.06255 | 2118933.3720400003 | 37.7989389509345 | -122.397831500623 | (37.7989389509345, -122.397831500623) | ||||
| 153412 | 153412 | 179499 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1151 Felton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007548.787880001 | 2092831.16716 | 37.7269426263769 | -122.416115141404 | (37.7269426263769, -122.416115141404) | |||
| 153678 | 153678 | 187305 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 88 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984977.8173 | 2098236.5366 | 37.740489408091605 | -122.49453969916 | (37.7404894080916, -122.49453969916) | |||
| 154758 | 154758 | 185095 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2801 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985029.9671 | 2095999.845 | 37.7343511038502 | -122.494194570965 | (37.7343511038502, -122.494194570965) | |||
| 154850 | 154850 | 187128 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985172.8615 | 2097384.8403 | 37.738162292099204 | -122.49380257480101 | (37.7381622920992, -122.493802574801) | |||
| 154917 | 154917 | 215038 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 314 Staples Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5997989.53732 | 2093829.39983 | 37.7291414193406 | -122.449233015693 | (37.7291414193406, -122.449233015693) | ||||
| 156845 | 156845 | 186677 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984721.4724 | 2105427.5149 | 37.760218853394605 | -122.49595638286101 | (37.7602188533946, -122.495956382861) | |||
| 159687 | 159687 | 185874 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985052.1017 | 2101064.154 | 37.7482576266138 | -122.494491248711 | (37.7482576266138, -122.494491248711) |
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");