Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |||
| 62524 | 62524 | 207864 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2545 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5991142.22279 | 2094819.8771799998 | 37.731466988790395 | -122.47297671042801 | (37.7314669887904, -122.472976710428) | |||
| 70555 | 70555 | 102084 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 201 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52515 | 5991161.35766 | 2114023.19945 | 37.7841953413 | -122.474311334384 | (37.7841953413, -122.474311334384) |
| 157271 | 157271 | 121996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991310.915630001 | 2111122.21398 | 37.776238696818204 | -122.473582239238 | (37.7762386968182, -122.473582239238) | |||
| 67680 | 67680 | 121997 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 634 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991314.5458 | 2111079.72567 | 37.776122245754706 | -122.47356658162501 | (37.7761222457547, -122.473566581625) | |||
| 161344 | 161344 | 207398 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 160 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991337.5246 | 2104227.06806 | 37.7573080176715 | -122.472987263976 | (37.7573080176715, -122.472987263976) | |||
| 137697 | 137697 | 207399 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 154 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991342.55523 | 2104236.58133 | 37.7573344298491 | -122.47297055996401 | (37.7573344298491, -122.472970559964) | |||
| 72400 | 72400 | 207400 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 148 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991365.09994 | 2104283.83195 | 37.757465472780105 | -122.472896037642 | (37.7574654727801, -122.472896037642) | |||
| 76570 | 76570 | 207401 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 142 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991370.5253800005 | 2104294.44691 | 37.757494932750504 | -122.472878048496 | (37.7574949327505, -122.472878048496) | |||
| 165959 | 165959 | 207402 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 136 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991386.74911 | 2104341.46071 | 37.7576249594532 | -122.472825368893 | (37.7576249594532, -122.472825368893) | |||
| 64682 | 64682 | 207404 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.58809 | 2097102.41328 | 37.737752914457396 | -122.472028548874 | (37.7377529144574, -122.472028548874) | |||
| 60067 | 60067 | 207405 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.745630001 | 2097109.88885 | 37.737773449589795 | -122.47202854890499 | (37.7377734495898, -122.472028548905) | |||
| 181511 | 181511 | 207403 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.82157 | 2097093.68289 | 37.7377289565351 | -122.472027105478 | (37.7377289565351, -122.472027105478) | |||
| 66231 | 66231 | 207904 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991482.67128 | 2097068.4954400002 | 37.737660831087496 | -122.47196355577299 | (37.7376608310875, -122.471963555773) | |||
| 56238 | 56238 | 207903 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991490.36095 | 2097069.60585 | 37.7376643249521 | -122.471937050068 | (37.7376643249521, -122.471937050068) | |||
| 172407 | 172407 | 207902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991496.246809999 | 2097069.9907900002 | 37.7376657224794 | -122.471916728076 | (37.7376657224794, -122.471916728076) | |||
| 182238 | 182238 | 207901 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991520.05038 | 2097071.77928 | 37.73767201055411 | -122.47183455883801 | (37.7376720105541, -122.471834558838) | |||
| 166541 | 166541 | 207900 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991529.51733 | 2097072.3432599998 | 37.737674106866 | -122.471801868461 | (37.737674106866, -122.471801868461) | |||
| 166208 | 166208 | 207899 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991539.23475 | 2097072.6474799998 | 37.737675504425795 | -122.47176829317101 | (37.7376755044258, -122.471768293171) | |||
| 33606 | 33606 | 207898 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991548.15864 | 2097071.69595 | 37.7376734080929 | -122.471737369979 | (37.7376734080929, -122.471737369979) | |||
| 157262 | 157262 | 207897 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991557.6312 | 2097072.51432 | 37.7376762031927 | -122.471704678736 | (37.7376762031927, -122.471704678736) | |||
| 73012 | 73012 | 207896 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991566.326830001 | 2097072.84008 | 37.7376776007508 | -122.471674637797 | (37.7376776007508, -122.471674637797) | |||
| 132402 | 132402 | 207893 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 509 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991609.8871 | 2099055.22647 | 37.7431232484418 | -122.47166845315701 | (37.7431232484418, -122.471668453157) | |||
| 153350 | 153350 | 207894 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2405 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991680.0958 | 2099028.04696 | 37.743052682242606 | -122.471423712548 | (37.7430526822426, -122.471423712548) | |||
| 171151 | 171151 | 207895 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2405 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991680.9977 | 2099010.21605 | 37.7430037753042 | -122.47141929508801 | (37.7430037753042, -122.471419295088) | |||
| 133387 | 133387 | 207891 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1585 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991719.11212 | 2104563.20896 | 37.7582530567451 | -122.471692092715 | (37.7582530567451, -122.471692092715) | |||
| 77315 | 77315 | 207890 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1585 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991722.660569999 | 2104556.3453900004 | 37.7582344164913 | -122.47167932056999 | (37.7582344164913, -122.47167932057) | |||
| 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) | |||
| 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) | |||
| 64994 | 64994 | 207926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1630 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991910.04045 | 2096405.2401 | 37.7358644199941 | -122.470437659868 | (37.7358644199941, -122.470437659868) | |||
| 188748 | 188748 | 207927 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1630 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5991926.85515 | 2096424.2337 | 37.7359175438479 | -122.470380908151 | (37.7359175438479, -122.470380908151) | |||
| 58173 | 58173 | 124075 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5991933.35964 | 2110333.59039 | 37.774109377871106 | -122.47137158054599 | (37.7741093778711, -122.471371580546) | |||
| 146067 | 146067 | 92919 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 362 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5991957.0 | 2096928.0 | 37.7373025018195 | -122.47031336115101 | (37.7373025018195, -122.470313361151) | ||||
| 89336 | 89336 | 68787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32724 | 5991980.95842416 | 2099649.38115823 | 37.74477610705139 | -122.470428661516 | (37.7447761070514, -122.470428661516) | ||
| 163646 | 163646 | 207905 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991984.0362 | 2099641.46865 | 37.744754559288104 | -122.470417443113 | (37.7447545592881, -122.470417443113) | |||
| 166270 | 166270 | 217633 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 362 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5992003.7966 | 2096898.1347 | 37.7372232047665 | -122.470149391099 | (37.7372232047665, -122.470149391099) | |||
| 24084 | 24084 | 217648 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5992011.4385 | 2096784.9217 | 37.7369127922508 | -122.470114728443 | (37.7369127922508, -122.470114728443) | |||
| 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) | ||||
| 53838 | 53838 | 207378 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1221 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 5992032.39492 | 2107035.89745 | 37.7650605262515 | -122.470788746219 | (37.7650605262515, -122.470788746219) | |||
| 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) | |||
| 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) | |||
| 98736 | 98736 | 92942 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5992043.0 | 2096735.0 | 37.73677754441 | -122.47000197350701 | (37.73677754441, -122.470001973507) | ||||
| 34069 | 34069 | 61665 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 129 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 9 | Permit Number 21661 | 5992088.12386 | 2114525.07918 | 37.78562701181829 | -122.47114165946199 | (37.7856270118183, -122.471141659462) | |
| 171418 | 171418 | 217644 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 345 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5992091.2536 | 2096871.5297 | 37.7371552098209 | -122.46984507850401 | (37.7371552098209, -122.469845078504) | |||
| 147183 | 147183 | 217630 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 342 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5992097.4803 | 2096991.2524 | 37.7374842980463 | -122.46983226413201 | (37.7374842980463, -122.469832264132) | |||
| 109511 | 109511 | 92932 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 329 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5992099.0 | 2097070.0 | 37.7377006069055 | -122.46983274150101 | (37.7377006069055, -122.469832741501) | ||||
| 75182 | 75182 | 207372 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1340 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992112.242459999 | 2106307.60409 | 37.7630654432505 | -122.4704595305 | (37.7630654432505, -122.4704595305) | |||
| 54141 | 54141 | 67725 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1340 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1993 12:00:00 AM | Permit Number 31343 | 5992114.71357014 | 2106313.78524878 | 37.763082557956295 | -122.470451434039 | (37.7630825579563, -122.470451434039) | ||
| 19690 | 19690 | 69083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 10 | 3x3 | Permit Number 33092 | 5992130.4466308 | 2105856.46587897 | 37.761827789630104 | -122.470363712817 | (37.7618277896301, -122.470363712817) |
| 181482 | 181482 | 207371 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992131.14604 | 2105828.32493 | 37.7617505624579 | -122.470359244405 | (37.7617505624579, -122.470359244405) | |||
| 44656 | 44656 | 61666 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 182 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 10 | Permit Number 21662 | 5992143.35704 | 2114256.7455 | 37.7848934361496 | -122.470931016199 | (37.7848934361496, -122.470931016199) | |
| 71760 | 71760 | 207407 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 235 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992143.68881 | 2095203.2702099998 | 37.7325776191621 | -122.469542382078 | (37.7325776191621, -122.469542382078) | |||
| 150045 | 150045 | 207406 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 225 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992144.25287 | 2095230.06817 | 37.7326512322553 | -122.469542382075 | (37.7326512322553, -122.469542382075) | |||
| 68191 | 68191 | 217640 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5992167.8139 | 2096949.2221 | 37.7373729586648 | -122.46958603122499 | (37.7373729586648, -122.469586031225) | |||
| 115395 | 115395 | 92910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 312 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5992168.0 | 2097141.0 | 37.7378995431122 | -122.469599344661 | (37.7378995431122, -122.469599344661) | ||||
| 75640 | 75640 | 59136 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 8 | Permit Number 18442 | 5992181.25908 | 2111926.88103 | 37.7784984588509 | -122.47063013268401 | (37.7784984588509, -122.470630132684) | ||
| 117727 | 117727 | 92938 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 345 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5992182.7 | 2096880.8 | 37.7371859491769 | -122.469529584198 | (37.7371859491769, -122.469529584198) | ||||
| 36586 | 36586 | 207860 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 88 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992206.435269999 | 2088409.02561 | 37.7139259191081 | -122.468831219804 | (37.7139259191081, -122.468831219804) | |||
| 147022 | 147022 | 207861 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5992207.07547 | 2088343.8619 | 37.7137470322778 | -122.46882426804702 | (37.7137470322778, -122.468824268047) | |||
| 63748 | 63748 | 207859 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 88 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992207.50569 | 2088392.37957 | 37.713880274943 | -122.468826309486 | (37.713880274943, -122.468826309486) | |||
| 165273 | 165273 | 59135 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 416 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1992 12:00:00 AM | 15 | Permit Number 30326 | 5992208.149780001 | 2112497.17184 | 37.7800658767774 | -122.470578655632 | (37.7800658767774, -122.470578655632) | ||
| 123503 | 123503 | 92934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5992211.0 | 2096907.0 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | ||||
| 72758 | 72758 | 217625 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 312 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5992220.3164 | 2097118.9001 | 37.7378418858944 | -122.46941685468201 | (37.7378418858944, -122.469416854682) | |||
| 28091 | 28091 | 217638 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 329 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5992227.5338 | 2097006.9607 | 37.737534945647795 | -122.46938375516001 | (37.7375349456478, -122.46938375516) | |||
| 63022 | 63022 | 59140 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 546 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 14 | Permit Number 18446 | 5992233.6974599995 | 2111729.4961200003 | 37.7779595257589 | -122.470434351154 | (37.7779595257589, -122.470434351154) | ||
| 36298 | 36298 | 207910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 272 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992257.40464 | 2097504.13559 | 37.7389017884968 | -122.46931665586 | (37.7389017884968, -122.46931665586) | |||
| 142205 | 142205 | 68799 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32738 | 5992323.72089278 | 2098718.16784221 | 37.742239045272996 | -122.469175702533 | (37.742239045273, -122.469175702533) | ||
| 50246 | 50246 | 207906 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992324.527969999 | 2098726.3849 | 37.742261653859295 | -122.46917350985001 | (37.7422616538593, -122.46917350985) | |||
| 139262 | 139262 | 111081 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2811 14TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992341.0 | 2097126.0 | 37.737868354045204 | -122.469000113007 | (37.7378683540452, -122.469000113007) | ||||
| 174916 | 174916 | 61663 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 121 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 9 | 6x9 | Permit Number 21657 | 5992393.21685 | 2114622.9849400003 | 37.7859134760601 | -122.470093267127 | (37.7859134760601, -122.470093267127) |
| 149437 | 149437 | 217677 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 254 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5992403.7215 | 2097300.6069 | 37.7383514042899 | -122.468795958226 | (37.7383514042899, -122.468795958226) | |||
| 33095 | 33095 | 207868 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992426.05558 | 2104800.10163 | 37.758944378192794 | -122.46926443762 | (37.7589443781928, -122.46926443762) | |||
| 29591 | 29591 | 207870 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992427.188159999 | 2104766.73387 | 37.7588528245185 | -122.469258092 | (37.7588528245185, -122.469258092) | |||
| 41097 | 41097 | 207871 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992427.77388 | 2104765.5037700003 | 37.7588494808325 | -122.46925597679399 | (37.7588494808325, -122.469255976794) | |||
| 155073 | 155073 | 207872 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992428.33216 | 2104748.4393 | 37.7588026585314 | -122.469252803993 | (37.7588026585314, -122.469252803993) | |||
| 178601 | 178601 | 207873 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992428.50791 | 2104727.72891 | 37.7587458033845 | -122.46925068878201 | (37.7587458033845, -122.469250688782) | |||
| 187170 | 187170 | 207869 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992429.29261 | 2104765.0149 | 37.7588482262841 | -122.46925068878599 | (37.7588482262841, -122.469250688786) | |||
| 73020 | 73020 | 207875 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992429.92349 | 2104693.2894 | 37.7586513233149 | -122.46924328645599 | (37.7586513233149, -122.469243286456) | |||
| 130185 | 130185 | 207876 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5992430.48818 | 2104676.5294 | 37.7586053373771 | -122.469240113663 | (37.7586053373771, -122.469240113663) | |||
| 26664 | 26664 | 207878 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992430.64291 | 2104640.28912 | 37.75850584000379 | -122.469236940844 | (37.7585058400038, -122.469236940844) | |||
| 29328 | 29328 | 207874 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992430.658340001 | 2104713.67602 | 37.758707342094496 | -122.46924222885 | (37.7587073420945, -122.46924222885) | |||
| 182181 | 182181 | 207877 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992430.68315 | 2104656.73178 | 37.7585509895658 | -122.469237998432 | (37.7585509895658, -122.469237998432) | |||
| 181564 | 181564 | 207881 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1631 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992440.55655 | 2104337.16872 | 37.7576741235779 | -122.469180593809 | (37.7576741235779, -122.469180593809) | |||
| 54429 | 54429 | 207880 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1635 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992442.291069999 | 2104322.4786900003 | 37.7576338888234 | -122.46917352603701 | (37.7576338888234, -122.469173526037) | |||
| 43448 | 43448 | 207911 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1201 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992447.46376 | 2098370.00525 | 37.7412902286696 | -122.46872251336 | (37.7412902286696, -122.46872251336) | |||
| 65214 | 65214 | 207879 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1677 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5992449.40881 | 2104058.56598 | 37.7569096647699 | -122.46912970299299 | (37.7569096647699, -122.469129702993) | |||
| 27199 | 27199 | 207909 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 222 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992450.69932 | 2097715.88503 | 37.7394943670795 | -122.46866374176099 | (37.7394943670795, -122.468663741761) | |||
| 45797 | 45797 | 207862 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 50 Vernon St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5992461.4298 | 2088225.8604700002 | 37.7134377203567 | -122.467936556254 | (37.7134377203567, -122.467936556254) | |||
| 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) | |||
| 70979 | 70979 | 59128 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 473 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 10 | Permit Number 18433 | 5992483.23161 | 2112207.48548 | 37.779286379459 | -122.469605937359 | (37.779286379459, -122.469605937359) | ||
| 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) | |||
| 127035 | 127035 | 117422 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992487.0 | 2088224.0 | 37.713434088528295 | -122.467848042178 | (37.7134340885283, -122.467848042178) | ||||
| 167639 | 167639 | 217671 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 230 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5992488.6312 | 2097389.1961 | 37.7385995529445 | -122.46850882833701 | (37.7385995529445, -122.468508828337) | |||
| 72489 | 72489 | 207852 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 442 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5992499.131030001 | 2090773.1201400002 | 37.7204340555615 | -122.467991417565 | (37.7204340555615, -122.467991417565) | |||
| 57084 | 57084 | 59130 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 10 | Permit Number 18435 | 5992502.82437 | 2111669.37553 | 37.7778100081451 | -122.469498976775 | (37.7778100081451, -122.469498976775) | |
| 58270 | 58270 | 59242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 563 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1980 12:00:00 AM | 8 | Permit Number 18573 | 5992504.0033599995 | 2111618.37405 | 37.777670040058496 | -122.469491184767 | (37.7776700400585, -122.469491184767) | ||
| 165258 | 165258 | 217669 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 220 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5992526.5576 | 2097428.2546 | 37.7387089884334 | -122.46838053894301 | (37.7387089884334, -122.468380538943) | |||
| 161457 | 161457 | 207908 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992548.53449 | 2097821.47012 | 37.739789928349 | -122.46833315276301 | (37.739789928349, -122.468333152763) | |||
| 123597 | 123597 | 104004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992553.4 | 2100640.7 | 37.7475310970527 | -122.46852139722701 | (37.7475310970527, -122.468521397227) |
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");