Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1872 | 1872 | 177039 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 178 Seville St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001177.23506 | 2087434.66895 | 37.711764745717 | -122.437755094333 | (37.711764745717, -122.437755094333) | |||
27531 | 27531 | 129510 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2500 Chestnut St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5999790.44594 | 2119530.29467 | 37.799812509208 | -122.444853861425 | (37.799812509208, -122.444853861425) | |||
31372 | 31372 | 177035 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 15 Merrill St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 6009505.01631 | 2094936.0613 | 37.732832016669605 | -122.409500962316 | (37.7328320166696, -122.409500962316) | |||
33936 | 33936 | 207369 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 501x Ortega St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5992541.8863 | 2103083.6869900003 | 37.7542382439023 | -122.468738948444 | (37.7542382439023, -122.468738948444) | |||
35462 | 35462 | 129513 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 25 Heather Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5997331.52493 | 2114270.89109 | 37.785230964483105 | -122.45298274796998 | (37.7852309644831, -122.45298274797) | |||
36100 | 36100 | 226649 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 410 Valley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003222.12075 | 2099233.47316 | 37.744277674881104 | -122.43152920021099 | (37.7442776748811, -122.431529200211) | |||
37818 | 37818 | 226638 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 201 Coso Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6007716.3532 | 2099510.6976099997 | 37.74529257420679 | -122.41600868956301 | (37.7452925742068, -122.416008689563) | |||
42723 | 42723 | 129514 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2730 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999183.84789 | 2118189.54872 | 37.796096542872206 | -122.446856379121 | (37.7960965428722, -122.446856379121) | |||
45735 | 45735 | 226654 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 220 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999922.0088 | 2105601.51229 | 37.761575162283705 | -122.443397564951 | (37.7615751622837, -122.443397564951) | |||
45994 | 45994 | 226656 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 121 Moffitt St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6002727.925340001 | 2096681.4535 | 37.737242397212704 | -122.43305572295401 | (37.7372423972127, -122.433055722954) | |||
47655 | 47655 | 129519 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.25144 | 2118762.17983 | 37.79774087408789 | -122.442529358545 | (37.7977408740879, -122.442529358545) | |||
47963 | 47963 | 191430 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 12 Augusta St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6011384.738480001 | 2095507.87401 | 37.7345072405216 | -122.403042454946 | (37.7345072405216, -122.403042454946) | |||
48051 | 48051 | 177031 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 263 Maynard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 2ft | 6005122.72167 | 2093818.5342400002 | 37.729517010390204 | -122.42457221572901 | (37.7295170103902, -122.424572215729) | |||
52039 | 52039 | 226655 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 232 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999888.11878 | 2105582.8714799997 | 37.761522046538204 | -122.44351343721901 | (37.7615220465382, -122.443513437219) | |||
54730 | 54730 | 226647 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 31 Hidalgo Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6004982.44987 | 2107476.14572 | 37.767009740246 | -122.42602901133101 | (37.767009740246, -122.426029011331) | |||
59600 | 59600 | 129529 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006561.352969999 | 2120334.1919299997 | 37.802403889494 | -122.421481088503 | (37.802403889494, -122.421481088503) | |||
63854 | 63854 | 129545 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 10 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010092.54789 | 2116944.91924 | 37.7932962437837 | -122.409022077819 | (37.7932962437837, -122.409022077819) | |||
65210 | 65210 | 226642 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 14 Cumberland St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6005484.04077 | 2104618.2918599998 | 37.759191085608 | -122.42409082483101 | (37.759191085608, -122.424090824831) | |||
72309 | 72309 | 226644 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 48 Cumberland St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005321.7767900005 | 2104616.40188 | 37.7591767333496 | -122.42465187767701 | (37.7591767333496, -122.424651877677) | |||
73133 | 73133 | 177037 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 125 Goettingen St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 6009971.552 | 2093934.84647 | 37.7301090233129 | -122.407817447612 | (37.7301090233129, -122.407817447612) | |||
75267 | 75267 | 117692 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 435 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5982808.33309 | 2112832.48805 | 37.780438537012294 | -122.50312116344101 | (37.7804385370123, -122.503121163441) | |||
76500 | 76500 | 129528 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006558.18826 | 2120353.46017 | 37.802456616741 | -122.4214934092 | (37.802456616741, -122.4214934092) | |||
130118 | 130118 | 121971 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 106 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5991185.189040001 | 2114684.00966 | 37.7860111230721 | -122.474277122949 | (37.7860111230721, -122.474277122949) | |||
131107 | 131107 | 129515 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2730 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999181.629430001 | 2118207.9413900003 | 37.7961469175038 | -122.44686537955 | (37.7961469175038, -122.44686537955) | |||
132877 | 132877 | 117693 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 435 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5982808.8484 | 2112817.53757 | 37.7803975176735 | -122.503118273577 | (37.7803975176735, -122.503118273577) | |||
133340 | 133340 | 226641 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 953 Treat Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6008623.395269999 | 2103036.69536 | 37.7550251300303 | -122.413121556411 | (37.7550251300303, -122.413121556411) | |||
144257 | 144257 | 226646 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 31 Hidalgo Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6004999.4002 | 2107477.2952799997 | 37.767013854632 | -122.425970464583 | (37.767013854632, -122.425970464583) | |||
147024 | 147024 | 226652 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 225 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5999964.01354 | 2105579.20426 | 37.7615163052595 | -122.443250685888 | (37.7615163052595, -122.443250685888) | |||
157440 | 157440 | 129527 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006554.47344 | 2120382.0459 | 37.802534896425 | -122.421508295689 | (37.802534896425, -122.421508295689) | |||
160826 | 160826 | 129520 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6000447.31564 | 2118755.2398900003 | 37.7977218795107 | -122.442525177605 | (37.7977218795107, -122.442525177605) | |||
163344 | 163344 | 226643 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 48 Cumberland St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005334.035069999 | 2104616.89651 | 37.75917878378829 | -122.42460951781099 | (37.7591787837883, -122.424609517811) | |||
165862 | 165862 | 129518 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.00148 | 2118771.96061 | 37.797767715271796 | -122.44253092607 | (37.7977677152718, -122.44253092607) | |||
166596 | 166596 | 207366 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5990777.74909 | 2106795.52344 | 37.7643278872345 | -122.475110663153 | (37.7643278872345, -122.475110663153) | |||
178419 | 178419 | 191431 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 9 Sumner St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009550.82105 | 2110763.25421 | 37.7762925082147 | -122.410459796982 | (37.7762925082147, -122.410459796982) | |||
178665 | 178665 | 177036 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 15 Merrill St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 6009502.62349 | 2094943.7258099997 | 37.7328529276995 | -122.409509775682 | (37.7328529276995, -122.409509775682) | |||
186226 | 186226 | 129526 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006553.85688 | 2120395.35345 | 37.8025714008062 | -122.421511374958 | (37.8025714008062, -122.421511374958) | |||
187883 | 187883 | 129522 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1240 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6006403.02216 | 2120103.20622 | 37.8017607330441 | -122.422012573438 | (37.8017607330441, -122.422012573438) |
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");