Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24370 | 24370 | 207978 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 155 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001108.30575 | 2095400.37488 | 37.733632849462104 | -122.43856371615101 | (37.7336328494621, -122.438563716151) | |||
25706 | 25706 | 207376 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1200 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 7ft | 5991774.71222 | 2107128.83955 | 37.7653008152139 | -122.471686772321 | (37.7653008152139, -122.471686772321) | |||
29050 | 29050 | 207850 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 277 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5994296.2066 | 2089616.42482 | 37.7173616620944 | -122.461695729788 | (37.7173616620944, -122.461695729788) | |||
29728 | 29728 | 207935 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996775.70026 | 2094622.40699 | 37.73124932318171 | -122.453486560779 | (37.7312493231817, -122.453486560779) | |||
30774 | 30774 | 227328 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 61 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6000814.1059 | 2096414.9830099999 | 37.7364019870456 | -122.43965356137801 | (37.7364019870456, -122.439653561378) | |||
31307 | 31307 | 208013 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.84466 | 2093225.77807 | 37.7275391817664 | -122.44585248661001 | (37.7275391817664, -122.44585248661) | ||||
31560 | 31560 | 207988 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 843 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999421.70434 | 2095638.9238900002 | 37.7341917619256 | -122.44441190581101 | (37.7341917619256, -122.444411905811) | |||
42940 | 42940 | 227287 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 689 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6002120.490069999 | 2098829.19814 | 37.74310512978921 | -122.435309486038 | (37.7431051297892, -122.435309486038) | ||||
43925 | 43925 | 177069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6000083.89105 | 2087741.94761 | 37.7125462340909 | -122.44155601691901 | (37.7125462340909, -122.441556016919) | |||
47270 | 47270 | 207837 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 506 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 1ft | 5994801.27267 | 2091957.06598 | 37.7238175641248 | -122.46011944125799 | (37.7238175641248, -122.460119441258) | |||
49212 | 49212 | 207992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5999471.24101 | 2094937.00073 | 37.732267272102106 | -122.444190220201 | (37.7322672721021, -122.444190220201) | |||
49918 | 49918 | 227452 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4741 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5999752.01374 | 2105002.00645 | 37.759919371898704 | -122.4439424309 | (37.7599193718987, -122.4439424309) | |||
51204 | 51204 | 207991 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 378 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999591.13062 | 2094983.54982 | 37.7324019240113 | -122.44377907894699 | (37.7324019240113, -122.443779078947) | ||||
55298 | 55298 | 207980 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 341 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5999148.95483 | 2095220.4410700002 | 37.733027140778 | -122.445324804895 | (37.733027140778, -122.445324804895) | |||
57617 | 57617 | 177094 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993369.32747 | 2086575.0773 | 37.708957449004394 | -122.464678768412 | (37.7089574490044, -122.464678768412) | |||
57742 | 57742 | 207982 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 620 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999457.28605 | 2095077.61427 | 37.732652567752105 | -122.444248566437 | (37.7326525677521, -122.444248566437) | |||
61831 | 61831 | 207813 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 410 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5998661.39505 | 2094413.54813 | 37.7307837594656 | -122.44695237635901 | (37.7307837594656, -122.446952376359) | |||
63447 | 63447 | 207963 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 41 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5997821.411180001 | 2095826.65809 | 37.734615797675296 | -122.449958126471 | (37.7346157976753, -122.449958126471) | |||
64268 | 64268 | 177059 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999000.98419 | 2090535.17383 | 37.7201540399677 | -122.445499591747 | (37.7201540399677, -122.445499591747) | |||
69430 | 69430 | 208008 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 247 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998434.03995 | 2093773.3668900002 | 37.72901298084221 | -122.44769230795299 | (37.7290129808422, -122.447692307953) | ||||
70423 | 70423 | 227272 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4331 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6001752.41046 | 2100271.7496599997 | 37.7470451262446 | -122.4366854416 | (37.7470451262446, -122.4366854416) | |||
70460 | 70460 | 129566 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99 Toledo Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001391.4418 | 2119925.56535 | 37.800989055367 | -122.439342181017 | (37.800989055367, -122.439342181017) | |||
71850 | 71850 | 177124 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 469 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6007846.143630001 | 2091662.3583799999 | 37.723750042115 | -122.415004493075 | (37.723750042115, -122.415004493075) | |||
72489 | 72489 | 207852 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 442 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5992499.131030001 | 2090773.1201400002 | 37.7204340555615 | -122.467991417565 | (37.7204340555615, -122.467991417565) | |||
75624 | 75624 | 207863 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 40 Lagunitas Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5991134.49125 | 2095574.8768799999 | 37.733539579871504 | -122.47305847768 | (37.7335395798715, -122.47305847768) | |||
75870 | 75870 | 207984 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 394 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998812.93096 | 2095267.10672 | 37.7331360864487 | -122.446489879305 | (37.7331360864487, -122.446489879305) | |||
76568 | 76568 | 177120 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6004577.78198 | 2092457.96973 | 37.7257504113309 | -122.42635929453999 | (37.7257504113309, -122.42635929454) | |||
134404 | 134404 | 207967 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 735 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998008.97089 | 2095771.4899 | 37.73447504928421 | -122.44930569891301 | (37.7344750492842, -122.449305698913) | |||
137621 | 137621 | 207968 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998212.35549 | 2096276.0168 | 37.735871991408 | -122.448638859714 | (37.735871991408, -122.448638859714) | |||
148265 | 148265 | 207950 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992685.27644 | 2100498.70583 | 37.747148834247795 | -122.468055053599 | (37.7471488342478, -122.468055053599) | |||
150660 | 150660 | 207840 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 314 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5994777.11096 | 2090681.2081099998 | 37.7203129744533 | -122.460110575752 | (37.7203129744533, -122.460110575752) | |||
151723 | 151723 | 129628 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2700 Larkin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 6006529.89635 | 2120833.1576900003 | 37.8037721486334 | -122.421625403586 | (37.8037721486334, -122.421625403586) | |||
153838 | 153838 | 207975 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 538 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998933.253409999 | 2097323.81684 | 37.7387901961225 | -122.44622178873001 | (37.7387901961225, -122.44622178873) | |||
154056 | 154056 | 227453 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4767 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5999650.25934 | 2104935.92317 | 37.759732118673206 | -122.444289599795 | (37.7597321186732, -122.444289599795) | |||
155186 | 155186 | 177117 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 226 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004541.32921 | 2091944.5690000001 | 37.724338665476104 | -122.42644876989401 | (37.7243386654761, -122.426448769894) | ||||
159114 | 159114 | 191451 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6014385.345480001 | 2116032.04037 | 37.7910292291593 | -122.39410465341001 | (37.7910292291593, -122.39410465341) | |||
159993 | 159993 | 119447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 895 32nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5986012.28825 | 2109834.94123 | 37.7723959307274 | -122.49181659590599 | (37.7723959307274, -122.491816595906) | ||||
161126 | 161126 | 227248 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 140 Park St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6005788.1768 | 2096358.4915900002 | 37.736528729414104 | -122.42245207301599 | (37.7365287294141, -122.422452073016) | |||
165417 | 165417 | 207981 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 337 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5999172.91711 | 2095220.2141099998 | 37.733027885423496 | -122.44524194498301 | (37.7330278854235, -122.445241944983) | |||
165682 | 165682 | 207976 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 791 Myra Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5997064.21874 | 2098028.7436 | 37.7406188361825 | -122.45273486333001 | (37.7406188361825, -122.45273486333) | |||
166760 | 166760 | 207853 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 258 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5992483.116230001 | 2089580.8821400001 | 37.7171595349616 | -122.467960100499 | (37.7171595349616, -122.467960100499) | |||
167023 | 167023 | 207941 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2194 12th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5992629.8459 | 2100501.88116 | 37.7471543516012 | -122.46824695724199 | (37.7471543516012, -122.468246957242) | |||
167324 | 167324 | 122130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5991115.18782 | 2115016.9633400002 | 37.7869212654547 | -122.474543613569 | (37.7869212654547, -122.474543613569) | ||||
167862 | 167862 | 177122 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 342 Harvard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6006351.771930001 | 2092249.47025 | 37.725278036125495 | -122.420211942723 | (37.7252780361255, -122.420211942723) | |||
169340 | 169340 | 207955 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 10 Woodside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5996262.83861 | 2100050.55871 | 37.7461242897204 | -122.45565181617901 | (37.7461242897204, -122.455651816179) | |||
170072 | 170072 | 177090 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 36 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5993074.958319999 | 2086622.9468 | 37.7090719120225 | -122.46569961766001 | (37.7090719120225, -122.46569961766) | |||
172316 | 172316 | 207956 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995766.68193 | 2100244.56754 | 37.746628504495895 | -122.457381484986 | (37.7466285044959, -122.457381484986) | |||
175117 | 175117 | 227359 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 165 Montcalm St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6010158.31216 | 2099748.7883900004 | 37.746083312104 | -122.40758154645 | (37.746083312104, -122.40758154645) | |||
175876 | 175876 | 118089 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 7049 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5985075.84275 | 2112426.03783 | 37.7794555626476 | -122.49524691703199 | (37.7794555626476, -122.495246917032) | |||
176073 | 176073 | 207979 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 6 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 6000455.91103 | 2095286.7491099997 | 37.7332837263556 | -122.440811080593 | (37.7332837263556, -122.440811080593) | |||
176095 | 176095 | 207970 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 63 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998594.466519999 | 2095921.95645 | 37.734921667891506 | -122.44729228142201 | (37.7349216678915, -122.447292281422) | |||
181991 | 181991 | 191439 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2205 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 5ft | 6012190.61304 | 2101859.85462 | 37.751993394903295 | -122.40070234973801 | (37.7519933949033, -122.400702349738) | |||
182263 | 182263 | 120396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 23rd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5988633.9259 | 2114634.88666 | 37.7857281137897 | -122.48310009361099 | (37.7857281137897, -122.483100093611) | |||
184181 | 184181 | 120484 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2309 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5988270.499009999 | 2114625.30582 | 37.785680652510294 | -122.48435672889299 | (37.7856806525103, -122.484356728893) | |||
184817 | 184817 | 227298 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6002393.51458 | 2100323.84062 | 37.7472245688541 | -122.434472284662 | (37.7472245688541, -122.434472284662) | ||||
185957 | 185957 | 207972 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 204 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996281.29923 | 2096182.49278 | 37.7355045886606 | -122.45530848830299 | (37.7355045886606, -122.455308488303) |
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");