Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71415 | 71415 | 226675 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 127 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 9ft | 6005684.59904 | 2100199.28079 | 37.7470688251863 | -122.423083100303 | (37.7470688251863, -122.423083100303) | |||
| 24191 | 24191 | 227330 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 221 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 8ft | 5998955.44589 | 2106862.7801900003 | 37.764983120694296 | -122.44683125657801 | (37.7649831206943, -122.446831256578) | |||
| 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) | |||
| 42853 | 42853 | 226684 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 178 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 8ft | 6005368.88002 | 2100227.87789 | 37.74712952490479 | -122.424176864772 | (37.7471295249048, -122.424176864772) | |||
| 48603 | 48603 | 177091 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.709026289400796 | -122.46453122115801 | (37.7090262894008, -122.464531221158) | |||
| 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) | |||
| 76045 | 76045 | 227331 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 225 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 8ft | 5998958.50232 | 2106842.59497 | 37.7649278717579 | -122.44681923263799 | (37.7649278717579, -122.446819232638) | |||
| 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) | |||
| 163355 | 163355 | 226683 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 160 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 8ft | 6005478.66525 | 2100234.88341 | 37.7471549586505 | -122.423797733972 | (37.7471549586505, -122.423797733972) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 4112 | 4112 | 226674 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 145 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2015 12:00:00 AM | 18 | Width 7ft | Permit Number 21993 | 6005571.69833 | 2100193.82022 | 37.747047459974 | -122.423473113803 | (37.747047459974, -122.423473113803) | |
| 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) | |||
| 35118 | 35118 | 249626 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5997629.20154 | 2111320.8976 | 37.7771481106256 | -122.45174000362199 | (37.7771481106256, -122.451740003622) | |||
| 37843 | 37843 | 249627 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 7ft | 5997621.56946 | 2111320.25827 | 37.777145918089 | -122.45176635913602 | (37.777145918089, -122.451766359136) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 25497 | 25497 | 227302 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1287 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6003266.52543 | 2100725.05977 | 37.7483757406618 | -122.43148211980301 | (37.7483757406618, -122.431482119803) | |||
| 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) | |||
| 34600 | 34600 | 177041 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 36 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 5999256.2594099995 | 2089431.5407 | 37.7171382857881 | -122.444537916099 | (37.7171382857881, -122.444537916099) | |||
| 36185 | 36185 | 226672 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1327 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6010353.59256 | 2101481.11421 | 37.7508508278045 | -122.407028370771 | (37.7508508278045, -122.407028370771) | |||
| 44511 | 44511 | 226682 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 154 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 6ft | 6005514.67234 | 2100235.81354 | 37.7471595451765 | -122.42367329031099 | (37.7471595451765, -122.423673290311) | |||
| 47662 | 47662 | 207856 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993273.296130001 | 2090436.09778 | 37.7195533503791 | -122.465290932448 | (37.7195533503791, -122.465290932448) | |||
| 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) | |||
| 58525 | 58525 | 207855 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993274.09777 | 2090428.4072099999 | 37.719532280163 | -122.46528760316099 | (37.719532280163, -122.465287603161) | |||
| 72357 | 72357 | 177142 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 417 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6002087.33741 | 2087757.61933 | 37.71270320445571 | -122.434632613123 | (37.7127032044557, -122.434632613123) | |||
| 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) | |||
| 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) | |||
| 160079 | 160079 | 226677 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 23 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6006022.72622 | 2100220.75054 | 37.7471468512526 | -122.42191540796301 | (37.7471468512526, -122.421915407963) | |||
| 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) | |||
| 177377 | 177377 | 226688 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1298 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6011388.93256 | 2102376.14008 | 37.7533662558597 | -122.40351101253599 | (37.7533662558597, -122.403511012536) | |||
| 177936 | 177936 | 177040 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 50 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5999261.0565599995 | 2089438.38497 | 37.7171573523208 | -122.444521826318 | (37.7171573523208, -122.444521826318) | |||
| 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) | |||
| 181058 | 181058 | 226689 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1298 Vermont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6011390.6750300005 | 2102355.0144 | 37.7533083467103 | -122.403503500497 | (37.7533083467103, -122.403503500497) | |||
| 181721 | 181721 | 226720 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6010300.3347 | 2102457.6667400002 | 37.75352924447979 | -122.407281376151 | (37.7535292444798, -122.407281376151) | |||
| 185859 | 185859 | 226736 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3652 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6005358.92953 | 2102566.09607 | 37.7535491707736 | -122.424377554773 | (37.7535491707736, -122.424377554773) | |||
| 3801 | 3801 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.72285164275971 | -122.445718558684 | (37.7228516427597, -122.445718558684) | |||
| 3805 | 3805 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998924.5969 | 2091518.7811599998 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | |||
| 3806 | 3806 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998978.57855 | 2091518.5364400002 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | |||
| 3808 | 3808 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369563999 | (37.7228504376851, -122.44574369564) | |||
| 3826 | 3826 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998921.0818300005 | 2091519.29315 | 37.722851642780796 | -122.44584652679501 | (37.7228516427808, -122.445846526795) | |||
| 3827 | 3827 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 7 | Width 5ft | 5998933.177730001 | 2091518.16383 | 37.7228492325857 | -122.44580463279199 | (37.7228492325857, -122.445804632792) | |||
| 45890 | 45890 | 226716 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1266 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6010288.92678 | 2101895.83233 | 37.751985933225 | -122.407281224142 | (37.751985933225, -122.407281224142) | |||
| 46792 | 46792 | 226717 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1266 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6010290.67208 | 2101875.6000099997 | 37.7519304774296 | -122.407273762489 | (37.7519304774296, -122.407273762489) | |||
| 49510 | 49510 | 129642 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1161 Greenwich St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 6007337.31848 | 2119837.29751 | 37.8010832638317 | -122.418760599735 | (37.8010832638317, -122.418760599735) | |||
| 50708 | 50708 | 227274 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1533 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6002044.25876 | 2099560.43078 | 37.7451085935954 | -122.43562537560899 | (37.7451085935954, -122.435625375609) | |||
| 50828 | 50828 | 129616 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007378.23169 | 2111027.62658 | 37.776896376005396 | -122.417994148015 | (37.7768963760054, -122.417994148015) | |||
| 53642 | 53642 | 177061 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5999007.9061199995 | 2090532.0864 | 37.720145957757104 | -122.44547544316002 | (37.7201459577571, -122.44547544316) | |||
| 55062 | 55062 | 207989 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 843 Detroit St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999418.49849 | 2095586.86925 | 37.7340486492241 | -122.444419249659 | (37.7340486492241, -122.444419249659) | |||
| 55814 | 55814 | 177063 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5999015.35979 | 2090528.72065 | 37.7201371416945 | -122.44544943653601 | (37.7201371416945, -122.445449436536) | |||
| 56491 | 56491 | 227237 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2707 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6008953.6424 | 2102708.0408799998 | 37.754141252929 | -122.41195623919701 | (37.754141252929, -122.411956239197) | |||
| 61317 | 61317 | 227283 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4412 23rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6000531.63027 | 2102304.55034 | 37.7525572554152 | -122.441052598925 | (37.7525572554152, -122.441052598925) | |||
| 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) | |||
| 66212 | 66212 | 177107 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5998942.4469800005 | 2091518.8488599998 | 37.722851642768894 | -122.44577264030701 | (37.7228516427689, -122.445772640307) | |||
| 67597 | 67597 | 207379 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1251 Funston Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5992036.47883 | 2106848.63378 | 37.7645465861817 | -122.470760979659 | (37.7645465861817, -122.470760979659) | |||
| 76053 | 76053 | 129617 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007383.9261 | 2110990.71861 | 37.776795356048005 | -122.417971832253 | (37.776795356048, -122.417971832253) | |||
| 77111 | 77111 | 177066 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 573 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6002664.89947 | 2090416.35383 | 37.720036274630104 | -122.432826194382 | (37.7200362746301, -122.432826194382) | |||
| 130528 | 130528 | 227383 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2930 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6008681.22938 | 2103336.88405 | 37.755852626809705 | -122.412942772087 | (37.7558526268097, -122.412942772087) | |||
| 134338 | 134338 | 129590 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005845.5146 | 2116275.22301 | 37.7912186002945 | -122.423669483476 | (37.7912186002945, -122.423669483476) | |||
| 136993 | 136993 | 129589 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005852.90495 | 2116274.14842 | 37.7912160669044 | -122.423643836609 | (37.7912160669044, -122.423643836609) | |||
| 137111 | 137111 | 226700 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 68 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6005192.67136 | 2107448.02367 | 37.7669444026985 | -122.425299885982 | (37.7669444026985, -122.425299885982) | |||
| 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) | |||
| 148258 | 148258 | 177067 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 573 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6002673.20995 | 2090427.0269900002 | 37.720066052099206 | -122.432798229977 | (37.7200660520992, -122.432798229977) | |||
| 148549 | 148549 | 227508 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 41 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6006644.81895 | 2109605.92162 | 37.7729514108221 | -122.420430313409 | (37.7729514108221, -122.420430313409) | |||
| 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) | |||
| 158347 | 158347 | 177126 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006914.161069999 | 2093507.1567900002 | 37.7287630439686 | -122.41835694803301 | (37.7287630439686, -122.418356948033) | |||
| 164422 | 164422 | 227318 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4346 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6000939.47796 | 2102320.11678 | 37.7526232188869 | -122.439643310892 | (37.7526232188869, -122.439643310892) | |||
| 166039 | 166039 | 226721 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6010296.192530001 | 2102509.90887 | 37.753672457944 | -122.407299383281 | (37.753672457944, -122.407299383281) | |||
| 168609 | 168609 | 226735 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 160 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6005280.3874699995 | 2104021.86948 | 37.7575419493218 | -122.424752726758 | (37.7575419493218, -122.424752726758) | |||
| 168694 | 168694 | 227347 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 236 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6006705.44249 | 2097738.30194 | 37.7403690845706 | -122.419378544583 | (37.7403690845706, -122.419378544583) | |||
| 169925 | 169925 | 226756 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 209 Day St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6004170.543190001 | 2098656.13064 | 37.7427461348209 | -122.42820861993799 | (37.7427461348209, -122.428208619938) | |||
| 174034 | 174034 | 227454 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 31 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6003284.13027 | 2107394.52295 | 37.7666894934374 | -122.431897401555 | (37.7666894934374, -122.431897401555) | |||
| 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) | |||
| 176315 | 176315 | 226679 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 136 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6005601.15773 | 2100240.7900099996 | 37.747178090991994 | -122.42337458408001 | (37.747178090992, -122.42337458408) | |||
| 177365 | 177365 | 191447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1300 Phelps St | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6014017.68905 | 2096332.11237 | 37.7369171097253 | -122.393997082801 | (37.7369171097253, -122.393997082801) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 186369 | 186369 | 226757 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 209 Day St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6004291.47259 | 2098662.3001599996 | 37.7427699165123 | -122.427790919941 | (37.7427699165123, -122.427790919941) | |||
| 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) | |||
| 291 | 291 | 129605 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 4ft | 6005928.19437 | 2117729.67294 | 37.79521682154579 | -122.42348685993299 | (37.7952168215458, -122.423486859933) | |||
| 2069 | 2069 | 129587 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1911 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 15 | Width 4ft | Permit Number 52344 | 6003864.05358 | 2118305.88007 | 37.79668221737371 | -122.43067024784901 | (37.7966822173737, -122.430670247849) | |
| 2246 | 2246 | 191498 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 4ft | 6016692.24365 | 2094766.72457 | 37.732767150375295 | -122.38464086270099 | (37.7327671503753, -122.384640862701) | |||
| 2259 | 2259 | 191494 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 4ft | 6016613.84098 | 2094824.1997599998 | 37.7329206295756 | -122.384915925743 | (37.7329206295756, -122.384915925743) | |||
| 3625 | 3625 | 129585 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Webster St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003281.99401 | 2116331.1346 | 37.7912270809146 | -122.432543180443 | (37.7912270809146, -122.432543180443) | ||
| 3706 | 3706 | 226704 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 18 | Width 4ft | Permit Number 38040 | 6007388.533559999 | 2107001.8580400003 | 37.7658431486538 | -122.41767310175399 | (37.7658431486538, -122.417673101754) | |
| 23407 | 23407 | 129668 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009333.59805 | 2121722.21012 | 37.806370959118205 | -122.411985864676 | (37.8063709591182, -122.411985864676) | |||
| 23737 | 23737 | 129604 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1675 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004955.93946 | 2118458.8169 | 37.7971639410302 | -122.426902971605 | (37.7971639410302, -122.426902971605) | |||
| 24247 | 24247 | 227356 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007559.31004 | 2096165.80664 | 37.7360994137559 | -122.41631485115101 | (37.7360994137559, -122.416314851151) | |||
| 24497 | 24497 | 227291 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 65 Zircon Pl | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.43449077742399 | (37.7428156470274, -122.434490777424) | |||
| 24839 | 24839 | 129593 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1730 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005825.1894 | 2117248.62262 | 37.7938901641474 | -122.42380905195101 | (37.7938901641474, -122.423809051951) | |||
| 25228 | 25228 | 123214 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 598 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5993175.3131800005 | 2111469.83533 | 37.7773009664124 | -122.467158112666 | (37.7773009664124, -122.467158112666) | |||
| 26027 | 26027 | 227311 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 405 Beacon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002323.66405 | 2098293.59277 | 37.7416460184529 | -122.434568676724 | (37.7416460184529, -122.434568676724) | |||
| 26130 | 26130 | 207916 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994697.354069999 | 2099701.1071099997 | 37.7450748213407 | -122.46103969864201 | (37.7450748213407, -122.461039698642) | |||
| 26336 | 26336 | 129613 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 711 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009198.53973 | 2115384.83404 | 37.7889625079688 | -122.412005118241 | (37.7889625079688, -122.412005118241) |
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");