Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28660 | 28660 | 142575 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2251 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008927.1192 | 2120859.172 | 37.803978459247205 | -122.41333149055401 | (37.8039784592472, -122.413331490554) | |||
29311 | 29311 | 199962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1265 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018011.0370000005 | 2092725.2017 | 37.7272343718441 | -122.379939611903 | (37.7272343718441, -122.379939611903) | |||
34489 | 34489 | 183440 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098754.1113 | 37.7421770482141 | -122.47877029228998 | (37.7421770482141, -122.47877029229) | |||
36009 | 36009 | 186909 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985192.0104 | 2096702.7177 | 37.7362904860675 | -122.49368611859501 | (37.7362904860675, -122.493686118595) | |||
38876 | 38876 | 142250 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 623 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004849.3706 | 2110876.8893 | 37.7763398361781 | -122.426731515889 | (37.7763398361781, -122.426731515889) | |||
43673 | 43673 | 247493 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 806 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002649.6994 | 2109575.8819 | 37.7726429829887 | -122.434247750607 | (37.7726429829887, -122.434247750607) | |||
51023 | 51023 | 185052 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983668.1125 | 2096649.8142 | 37.7360559577629 | -122.498950875232 | (37.7360559577629, -122.498950875232) | |||
51298 | 51298 | 200113 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | |||
52001 | 52001 | 200104 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.39045295200899 | (37.726258938018, -122.390452952009) | |||
53050 | 53050 | 245954 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 189 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998286.3355 | 2107663.1593 | 37.7671425117336 | -122.44920319850401 | (37.7671425117336, -122.449203198504) | |||
54686 | 54686 | 142249 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 619 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004863.0676 | 2110879.3064 | 37.7763472473304 | -122.42668430629101 | (37.7763472473304, -122.426684306291) | |||
54938 | 54938 | 182961 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5990015.6611 | 2098388.4154 | 37.7411999929644 | -122.47713208357 | (37.7411999929644, -122.47713208357) | |||
55147 | 55147 | 246315 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | |||
56909 | 56909 | 200009 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1435 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017676.8443 | 2092268.1534 | 37.72596096442079 | -122.381063162948 | (37.7259609644208, -122.381063162948) | |||
58140 | 58140 | 141665 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5 MASONIC AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998794.5569 | 2112395.1526 | 37.7801644097761 | -122.44778604353901 | (37.7801644097761, -122.447786043539) | |||
59332 | 59332 | 200004 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6017626.5562 | 2092285.3405 | 37.7260053809224 | -122.38123820192101 | (37.7260053809224, -122.381238201921) | |||
62276 | 62276 | 200097 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015067.4938 | 2092354.869 | 37.7260546913573 | -122.390089647295 | (37.7260546913573, -122.390089647295) | |||
62772 | 62772 | 185051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983667.0512 | 2096660.9577 | 37.736086492552 | -122.49895536756901 | (37.736086492552, -122.498955367569) | |||
64313 | 64313 | 200002 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017646.9261 | 2092314.6221 | 37.726086906985 | -122.381169818775 | (37.726086906985, -122.381169818775) | |||
64448 | 64448 | 200105 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014949.7328 | 2092444.2049 | 37.7262934578304 | -122.39050298275801 | (37.7262934578304, -122.390502982758) | |||
67225 | 67225 | 247478 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002704.2967 | 2109689.8401 | 37.772958982719494 | -122.43406704066099 | (37.7729589827195, -122.434067040661) | |||
71134 | 71134 | 187130 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985156.874 | 2097417.7557 | 37.73825173359629 | -122.49386027578899 | (37.7382517335963, -122.493860275789) | |||
73740 | 73740 | 200018 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1008 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6018250.1161 | 2092086.6599 | 37.7254942451327 | -122.37906877917801 | (37.7254942451327, -122.379068779178) | |||
74356 | 74356 | 186817 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1200 Sunset Blvd | 110 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984826.8059 | 2106810.865 | 37.7640233139964 | -122.49569412937599 | (37.7640233139964, -122.495694129376) | |||
76536 | 76536 | 247481 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002713.0909 | 2109626.0822 | 37.7727844183865 | -122.43403206203101 | (37.7727844183865, -122.434032062031) | |||
131229 | 131229 | 200112 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1560 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014792.7183 | 2092559.9355 | 37.726602519263004 | -122.391053863847 | (37.726602519263, -122.391053863847) | |||
132516 | 132516 | 246316 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | |||
134902 | 134902 | 181607 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1255 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5987053.8771 | 2106742.5422 | 37.7639658865787 | -122.487986427971 | (37.7639658865787, -122.487986427971) | |||
136463 | 136463 | 244199 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 677 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003772.3734 | 2110028.492 | 37.7739493963127 | -122.430396601984 | (37.7739493963127, -122.430396601984) | |||
146728 | 146728 | 246318 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006836.8702 | 2108926.9706 | 37.7710979938489 | -122.419717800254 | (37.7710979938489, -122.419717800254) | |||
148569 | 148569 | 200000 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017688.3023 | 2092371.2757 | 37.726244750724 | -122.381030719301 | (37.726244750724, -122.381030719301) | |||
150887 | 150887 | 183441 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098772.4148 | 37.742227304861395 | -122.47877163063801 | (37.7422273048614, -122.478771630638) | |||
150955 | 150955 | 142587 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2320 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008491.26 | 2120799.1265 | 37.8037891087643 | -122.414835562646 | (37.8037891087643, -122.414835562646) | |||
155567 | 155567 | 247480 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002710.1595 | 2109648.0677 | 37.772844618769895 | -122.434043773953 | (37.7728446187699, -122.434043773953) | |||
156648 | 156648 | 182931 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2639 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982106.6394 | 2097122.6843 | 37.7372626147396 | -122.50438444730699 | (37.7372626147396, -122.504384447307) | |||
157008 | 157008 | 187077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985155.4633 | 2096938.6014 | 37.736936021545 | -122.493829852855 | (37.736936021545, -122.493829852855) | |||
157041 | 157041 | 199935 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1310 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017874.9241 | 2092620.1152 | 37.726938315047896 | -122.380402857754 | (37.7269383150479, -122.380402857754) | |||
159060 | 159060 | 200098 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015053.9581 | 2092365.0208 | 37.726081815437205 | -122.39013714867201 | (37.7260818154372, -122.390137148672) | |||
159237 | 159237 | 139750 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 CLEARY CT | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004722.5099 | 2113632.2289 | 37.78389814561189 | -122.427366689538 | (37.7838981456119, -122.427366689538) | |||
159621 | 159621 | 186908 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985188.8014 | 2096694.9245 | 37.736268900285 | -122.493696639188 | (37.736268900285, -122.493696639188) | |||
162927 | 162927 | 246317 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.771133605468705 | -122.419700914309 | (37.7711336054687, -122.419700914309) | |||
163079 | 163079 | 247479 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 309 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002709.4266 | 2109671.5189 | 37.7729089683714 | -122.434047985824 | (37.7729089683714, -122.434047985824) | |||
163085 | 163085 | 183580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988349.2799 | 2097484.0905 | 37.7386201346216 | -122.482827506776 | (37.7386201346216, -122.482827506776) | |||
168441 | 168441 | 139749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 CLEARY CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004687.007999999 | 2113628.2842 | 37.783885306529605 | -122.427489231919 | (37.7838853065296, -122.427489231919) | |||
172420 | 172420 | 200111 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1552 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014807.6076 | 2092549.7837 | 37.726575470666106 | -122.39100168241998 | (37.7265754706661, -122.39100168242) | |||
172614 | 172614 | 244059 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998660.6331 | 2109020.8428 | 37.7708917674934 | -122.44800632768299 | (37.7708917674934, -122.448006327683) | |||
175752 | 175752 | 183581 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988348.717 | 2097504.9177 | 37.738677287922 | -122.48283097892299 | (37.738677287922, -122.482830978923) | |||
176268 | 176268 | 200103 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014982.2186 | 2092417.8102 | 37.72622278535071 | -122.390388836652 | (37.7262227853507, -122.390388836652) | |||
176799 | 176799 | 182968 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2501 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5990431.4773 | 2098333.0499 | 37.7410720891089 | -122.475690312642 | (37.7410720891089, -122.475690312642) | |||
180480 | 180480 | 143382 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1600 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005275.1713 | 2118900.2974 | 37.798394179030794 | -122.425829789965 | (37.7983941790308, -122.425829789965) | |||
182025 | 182025 | 200099 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015044.482999999 | 2092374.4958 | 37.7261073063636 | -122.390170565448 | (37.7261073063636, -122.390170565448) | |||
184446 | 184446 | 142580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 650 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6008660.8 | 2120758.6253 | 37.8036874273397 | -122.414245990591 | (37.8036874273397, -122.414245990591) | |||
187192 | 187192 | 246314 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) | |||
188902 | 188902 | 182960 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5990064.3236 | 2098390.6107 | 37.741208843809794 | -122.47696398819299 | (37.7412088438098, -122.476963988193) |
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");