Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187892 | 187892 | 177123 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 342 Harvard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6006356.99395 | 2092231.60745 | 37.7252292829921 | -122.4201926235 | (37.7252292829921, -122.4201926235) | |||
| 187210 | 187210 | 177060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999004.711019999 | 2090533.4907900002 | 37.7201496314864 | -122.445486588437 | (37.7201496314864, -122.445486588437) | |||
| 186663 | 186663 | 122136 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5991117.00305 | 2114994.0290099997 | 37.786858399358294 | -122.47453565898 | (37.7868583993583, -122.47453565898) | ||||
| 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) | |||
| 185708 | 185708 | 120477 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5988623.03819 | 2114641.82381 | 37.785746527658 | -122.483138270198 | (37.785746527658, -122.483138270198) | |||
| 185619 | 185619 | 191460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6014521.60501 | 2115886.5907099997 | 37.7906374305211 | -122.393623012505 | (37.7906374305211, -122.393623012505) | |||
| 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) | ||||
| 184261 | 184261 | 227300 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6002388.83562 | 2100326.88873 | 37.7472326726441 | -122.434488682032 | (37.7472326726441, -122.434488682032) | ||||
| 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) | |||
| 184012 | 184012 | 207997 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 5999481.71143 | 2094946.11387 | 37.73229289198321 | -122.444154676308 | (37.7322928919832, -122.444154676308) | |||
| 183703 | 183703 | 227267 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001720.54184 | 2099972.41794 | 37.7462214209976 | -122.436774216378 | (37.7462214209976, -122.436774216378) | |||
| 183308 | 183308 | 177056 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998961.55007 | 2090188.4526900002 | 37.71919977204001 | -122.44561098175801 | (37.71919977204, -122.445610981758) | |||
| 183260 | 183260 | 207993 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5999470.9807400005 | 2094940.5496900002 | 37.732277001865604 | -122.444191374942 | (37.7322770018656, -122.444191374942) | |||
| 183136 | 183136 | 207985 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 394 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998813.609180001 | 2095274.4257 | 37.733156221377 | -122.446488060895 | (37.733156221377, -122.446488060895) | |||
| 182931 | 182931 | 207380 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1251 Funston Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 5992036.83974 | 2106822.46143 | 37.764474744735395 | -122.470757824839 | (37.7644747447354, -122.470757824839) | |||
| 182511 | 182511 | 207835 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1209 Capitol Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995030.31814 | 2091918.85126 | 37.723725807194704 | -122.459324908222 | (37.7237258071947, -122.459324908222) | |||
| 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) | |||
| 182203 | 182203 | 122137 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083001 | (37.786826966306, -122.47453884083) | ||||
| 182185 | 182185 | 177119 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Avalon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6003367.9404 | 2092809.07535 | 37.7266460056919 | -122.430566665719 | (37.7266460056919, -122.430566665719) | |||
| 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) | |||
| 181849 | 181849 | 227282 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4412 23rd St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 6000544.37543 | 2102304.8503 | 37.7525588049644 | -122.441008545612 | (37.7525588049644, -122.441008545612) | |||
| 180646 | 180646 | 177121 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6004588.387180001 | 2092450.0669200001 | 37.7257293114356 | -122.426322070732 | (37.7257293114356, -122.426322070732) | |||
| 180220 | 180220 | 248212 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 67 Fair Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 6ft | 6007009.12213 | 2099449.33024 | 37.745084284924104 | -122.41844983181801 | (37.7450842849241, -122.418449831818) | |||
| 179227 | 179227 | 191458 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6014482.2077 | 2115927.0882900003 | 37.790746438249 | -122.393762161888 | (37.790746438249, -122.393762161888) | |||
| 178340 | 178340 | 207946 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992698.06615 | 2100499.1066400004 | 37.7471506733717 | -122.468010857342 | (37.7471506733717, -122.468010857342) | |||
| 177793 | 177793 | 177112 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5998995.97899 | 2091518.17463 | 37.722852847852295 | -122.445587543638 | (37.7228528478523, -122.445587543638) | |||
| 177642 | 177642 | 177057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998963.193390001 | 2090191.18353 | 37.7192073641203 | -122.44560549771799 | (37.7192073641203, -122.445605497718) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 175179 | 175179 | 249628 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 7ft | 5997613.51975 | 2111318.82879 | 37.7771415320813 | -122.45179410233999 | (37.7771415320813, -122.45179410234) | |||
| 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) | |||
| 174618 | 174618 | 208003 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5999487.18878 | 2094935.8135400002 | 37.7322649221692 | -122.444135000042 | (37.7322649221692, -122.444135000042) | |||
| 174409 | 174409 | 177111 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5998987.397890001 | 2091518.79195 | 37.7228540529596 | -122.445617250956 | (37.7228540529596, -122.445617250956) | |||
| 173479 | 173479 | 177048 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998741.12463 | 2090893.49817 | 37.7211230774582 | -122.446423600184 | (37.7211230774582, -122.446423600184) | |||
| 173097 | 173097 | 208015 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5998954.572369999 | 2093232.0746099998 | 37.7275564550483 | -122.445853880569 | (37.7275564550483, -122.445853880569) | ||||
| 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) | |||
| 171783 | 171783 | 177092 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | |||
| 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) | |||
| 169881 | 169881 | 208001 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999487.44652 | 2094940.8443 | 37.732278750160496 | -122.444134470341 | (37.7322787501605, -122.444134470341) | |||
| 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) | |||
| 168055 | 168055 | 120397 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 23rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 1ft | 5988633.138590001 | 2114628.42785 | 37.785710333915404 | -122.48310234386899 | (37.7857103339154, -122.483102343869) | |||
| 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) | |||
| 167423 | 167423 | 227307 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002310.77433 | 2098320.0282799997 | 37.741717872474396 | -122.434615134802 | (37.7417178724744, -122.434615134802) | |||
| 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) | ||||
| 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) | |||
| 167000 | 167000 | 122135 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.47454122766099 | (37.78686657212, -122.474541227661) | ||||
| 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) | |||
| 166567 | 166567 | 227271 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001729.3164800005 | 2099973.25035 | 37.7462242052805 | -122.436743934384 | (37.7462242052805, -122.436743934384) | |||
| 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) | |||
| 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) | |||
| 162552 | 162552 | 191452 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6014395.4165199995 | 2116019.0408900003 | 37.790994095352296 | -122.39406889728501 | (37.7909940953523, -122.394068897285) | |||
| 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) | |||
| 160883 | 160883 | 227269 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001725.03317 | 2099972.93353 | 37.746223091938894 | -122.43675872284099 | (37.7462230919389, -122.436758722841) | |||
| 160540 | 160540 | 207838 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 506 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 1ft | 5994800.95024 | 2091971.89024 | 37.7238582494329 | -122.46012162930401 | (37.7238582494329, -122.460121629304) | |||
| 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) | ||||
| 159816 | 159816 | 208005 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998445.88865 | 2094954.90573 | 37.7322578849907 | -122.447736370247 | (37.7322578849907, -122.447736370247) | |||
| 159185 | 159185 | 227270 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001726.6658 | 2099973.10248 | 37.746223648621395 | -122.43675308951 | (37.7462236486214, -122.43675308951) | |||
| 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) | |||
| 159062 | 159062 | 122138 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.47453486398899 | (37.7868169072323, -122.474534863989) | ||||
| 157541 | 157541 | 120479 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988612.47401 | 2114641.5086 | 37.785745047419 | -122.48317479571301 | (37.785745047419, -122.483174795713) | |||
| 156782 | 156782 | 191453 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6014408.51358 | 2116009.54729 | 37.790968756046794 | -122.39402291674 | (37.7909687560468, -122.39402291674) | |||
| 156713 | 156713 | 177062 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999011.63296 | 2090530.40369 | 37.720141550179896 | -122.44546243984199 | (37.7201415501799, -122.445462439842) | |||
| 156675 | 156675 | 177064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 102 France Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | |||
| 155404 | 155404 | 122134 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991116.74625 | 2115003.65081 | 37.78688480325761 | -122.4745372499 | (37.7868848032576, -122.4745372499) | ||||
| 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) | ||||
| 155175 | 155175 | 227259 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 1ft | 6001350.9072 | 2100668.98044 | 37.748113001917 | -122.438102253317 | (37.748113001917, -122.438102253317) | |||
| 155134 | 155134 | 207943 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992681.5782 | 2100498.78362 | 37.747148834263896 | -122.46806784736201 | (37.7471488342639, -122.468067847362) | |||
| 154412 | 154412 | 177052 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998953.787769999 | 2090172.9381799998 | 37.719156729587 | -122.445636697899 | (37.719156729587, -122.445636697899) | |||
| 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) | |||
| 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) | |||
| 153349 | 153349 | 208006 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998446.5912 | 2094951.6285700002 | 37.7322489268386 | -122.44773370554701 | (37.7322489268386, -122.447733705547) | |||
| 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) | |||
| 151233 | 151233 | 208000 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999487.481380001 | 2094942.52217 | 37.732283359186894 | -122.444134470345 | (37.7322833591869, -122.444134470345) | |||
| 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) | |||
| 149576 | 149576 | 177053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998955.229780001 | 2090176.99773 | 37.719167958508 | -122.445632005212 | (37.719167958508, -122.445632005212) | |||
| 149329 | 149329 | 207836 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995005.14377 | 2091917.0493299998 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | |||
| 149263 | 149263 | 191456 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6014463.08258 | 2115949.76346 | 37.7908076361998 | -122.393829922227 | (37.7908076361998, -122.393829922227) | |||
| 149225 | 149225 | 129559 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2661 Greenwich St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 1ft | 6000174.650330001 | 2118828.48318 | 37.7979074402255 | -122.443473935388 | (37.7979074402255, -122.443473935388) | |||
| 148786 | 148786 | 177071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.85227 | 2087744.80295 | 37.7125540150319 | -122.441559812029 | (37.7125540150319, -122.441559812029) | |||
| 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) | |||
| 147895 | 147895 | 207998 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5999486.80728 | 2094946.9617700002 | 37.7322955108311 | -122.444137119754 | (37.7322955108311, -122.444137119754) | |||
| 147509 | 147509 | 207966 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 735 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998008.19389 | 2095778.9308900002 | 37.7344954360226 | -122.449308921174 | (37.7344954360226, -122.449308921174) | |||
| 147312 | 147312 | 207994 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999470.93523 | 2094944.41877 | 37.7322876228558 | -122.444191810206 | (37.7322876228558, -122.444191810206) | |||
| 138220 | 138220 | 207375 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1240 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5991777.760009999 | 2107019.09717 | 37.7649996682339 | -122.471668232808 | (37.7649996682339, -122.471668232808) | |||
| 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) | |||
| 136670 | 136670 | 227260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001350.1729 | 2100676.3582200003 | 37.748133217784 | -122.438105320914 | (37.748133217784, -122.438105320914) | |||
| 136024 | 136024 | 227308 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002314.2643 | 2098316.80791 | 37.7417092282111 | -122.43460283744699 | (37.7417092282111, -122.434602837447) | |||
| 135820 | 135820 | 227297 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4220 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6002396.17742 | 2100337.95193 | 37.7472634663454 | -122.434464085561 | (37.7472634663454, -122.434464085561) | ||||
| 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) | |||
| 134273 | 134273 | 191457 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6014474.3471099995 | 2115936.1277 | 37.7907708215543 | -122.393789992334 | (37.7907708215543, -122.393789992334) | |||
| 132779 | 132779 | 227268 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001722.7938 | 2099972.97988 | 37.7462230919366 | -122.436766469611 | (37.7462230919366, -122.436766469611) | |||
| 131503 | 131503 | 177093 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5993374.13741 | 2086578.2467 | 37.7089664287264 | -122.464662374692 | (37.7089664287264, -122.464662374692) | |||
| 131196 | 131196 | 207959 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.658340001 | 2100247.6965 | 37.7466360605992 | -122.45744403462 | (37.7466360605992, -122.45744403462) | |||
| 130658 | 130658 | 207857 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5993273.27728 | 2090450.4863099998 | 37.7195928567171 | -122.465292042207 | (37.7195928567171, -122.465292042207) | |||
| 97569 | 97569 | 177058 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998964.8504 | 2090194.5720900001 | 37.7192167629302 | -122.44560001362801 | (37.7192167629302, -122.445600013628) | |||
| 76685 | 76685 | 227309 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002319.695169999 | 2098302.33211 | 37.741669789339205 | -122.434583024505 | (37.7416697893392, -122.434583024505) | |||
| 76604 | 76604 | 207995 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999470.3608 | 2094946.2688099998 | 37.7322926698604 | -122.44419392902799 | (37.7322926698604, -122.444193929028) | |||
| 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) | |||
| 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) |
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");