Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24194 | 24194 | 122139 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | ||||
| 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) | ||||
| 34798 | 34798 | 122131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.120209999 | 2115013.7594 | 37.786912464412104 | -122.47454361357 | (37.7869124644121, -122.47454361357) | ||||
| 36259 | 36259 | 208014 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.765869999 | 2093228.45695 | 37.7275465328469 | -122.44585295156901 | (37.7275465328469, -122.445852951569) | ||||
| 41868 | 41868 | 227288 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 689 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002143.45873 | 2098830.19502 | 37.7431091713442 | -122.43523013797501 | (37.7431091713442, -122.435230137975) | ||||
| 42545 | 42545 | 227299 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002389.0649 | 2100323.63751 | 37.7472237585745 | -122.43448765677499 | (37.7472237585745, -122.434487656775) | ||||
| 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) | ||||
| 44820 | 44820 | 122132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.47454043173401 | (37.7869049199545, -122.474540431734) | ||||
| 46096 | 46096 | 122133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5991114.065719999 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | ||||
| 47166 | 47166 | 227292 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1831 Castro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002653.15618 | 2100170.70248 | 37.746818822623894 | -122.433563522461 | (37.7468188226239, -122.433563522461) | ||||
| 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) | ||||
| 54549 | 54549 | 227289 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 687 29th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002191.96194 | 2098829.02358 | 37.743108709092496 | -122.435062343346 | (37.7431087090925, -122.435062343346) | ||||
| 58191 | 58191 | 207377 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1201 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5992030.8504800005 | 2107135.40247 | 37.7653336512411 | -122.47080133672199 | (37.7653336512411, -122.470801336722) | ||||
| 61200 | 61200 | 207832 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 147 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999123.91286 | 2093462.3743099999 | 37.7281984720769 | -122.44528502248001 | (37.7281984720769, -122.44528502248) | ||||
| 62185 | 62185 | 227290 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 685 29th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002218.42059 | 2098832.30166 | 37.7431192122842 | -122.434971090944 | (37.7431192122842, -122.434971090944) | ||||
| 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) | ||||
| 70419 | 70419 | 227286 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 691 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002107.89107 | 2098826.5345400004 | 37.743097100666 | -122.435352859445 | (37.743097100666, -122.435352859445) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 24921 | 24921 | 185624 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985032.5384 | 2100289.574 | 37.74612969593421 | -122.49450180509399 | (37.7461296959342, -122.494501805094) | |||
| 38825 | 38825 | 186910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2700 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985181.9251 | 2096700.884 | 37.7362848611965 | -122.49372085206998 | (37.7362848611965, -122.49372085207) | |||
| 23905 | 23905 | 207996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999475.26279 | 2094946.5125 | 37.732293618635396 | -122.44417699929 | (37.7322936186354, -122.44417699929) | |||
| 28430 | 28430 | 207999 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5999487.38528 | 2094945.2711599998 | 37.732290901786605 | -122.444135000045 | (37.7322909017866, -122.444135000045) | |||
| 34135 | 34135 | 208002 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999487.2394900005 | 2094938.2542299998 | 37.7322716266247 | -122.44413500004299 | (37.7322716266247, -122.444135000043) | |||
| 34744 | 34744 | 177051 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.44564302283199 | (37.7191438872553, -122.445643022832) | |||
| 35972 | 35972 | 207841 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 314 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5994779.70633 | 2090681.1537400002 | 37.72031297444521 | -122.460101600536 | (37.7203129744452, -122.460101600536) | |||
| 38750 | 38750 | 208004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998446.15319 | 2094958.3543599998 | 37.7322673692323 | -122.447735703852 | (37.7322673692323, -122.447735703852) | |||
| 40353 | 40353 | 207983 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 620 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999460.54725 | 2095077.27531 | 37.7326518231051 | -122.44423726735799 | (37.7326518231051, -122.444237267358) | |||
| 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) | |||
| 49286 | 49286 | 207854 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 258 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992483.5365 | 2089596.1759 | 37.717201552190105 | -122.467959759631 | (37.7172015521901, -122.467959759631) | |||
| 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) | |||
| 64895 | 64895 | 177055 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998959.63131 | 2090185.20091 | 37.7191907338521 | -122.44561738044399 | (37.7191907338521, -122.445617380444) | |||
| 68735 | 68735 | 177054 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998957.42918 | 2090181.0336799999 | 37.719179165869996 | -122.44562469283001 | (37.71917916587, -122.44562469283) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 54144 | 54144 | 120481 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988593.25091 | 2114641.37666 | 37.7857435664695 | -122.48324129171101 | (37.7857435664695, -122.483241291711) | |||
| 64567 | 64567 | 120483 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2309 Lake St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988277.53401 | 2114625.15663 | 37.7856806525102 | -122.48433237916201 | (37.7856806525102, -122.484332379162) | |||
| 68485 | 68485 | 120482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988588.087169999 | 2114640.4078900004 | 37.7857406059941 | -122.483259085533 | (37.7857406059941, -122.483259085533) | |||
| 69652 | 69652 | 120478 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988614.91495 | 2114641.72629 | 37.78574578718071 | -122.483166366817 | (37.7857457871807, -122.483166366817) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 26709 | 26709 | 177070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.712548932973206 | -122.44155935339501 | (37.7125489329732, -122.441559353395) | |||
| 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) | |||
| 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) | |||
| 45149 | 45149 | 177118 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6003359.98068 | 2092814.5992700001 | 37.726660722214 | -122.430594576183 | (37.726660722214, -122.430594576183) | |||
| 53837 | 53837 | 227249 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 140 Park St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6005791.54038 | 2096357.8109900001 | 37.7365270503857 | -122.422440395327 | (37.7365270503857, -122.422440395327) | |||
| 56467 | 56467 | 226671 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1340 Bryant St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 2ft | 6009364.61324 | 2107966.78389 | 37.7686036122904 | -122.41090638773899 | (37.7686036122904, -122.410906387739) | |||
| 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) | |||
| 72614 | 72614 | 227310 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002320.65439 | 2098300.9350099997 | 37.741666007681296 | -122.434579607974 | (37.7416660076813, -122.434579607974) | |||
| 74148 | 74148 | 227250 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 140 Park St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6005794.59689 | 2096357.13637 | 37.7365253704536 | -122.422429779736 | (37.7365253704536, -122.422429779736) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 23612 | 23612 | 177049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998733.2334 | 2090880.1248400002 | 37.721085906663106 | -122.44644991615299 | (37.7210859066631, -122.446449916153) | |||
| 24079 | 24079 | 207947 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992701.4282599995 | 2100499.03593 | 37.74715067337829 | -122.467999226394 | (37.7471506733783, -122.467999226394) | |||
| 26392 | 26392 | 207957 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995759.15859 | 2100245.2253900003 | 37.7466298786655 | -122.45740754733102 | (37.7466298786655, -122.457407547331) |
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");