Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7848 | 7848 | 51578 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47872 | |||||||||
| 10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 185883 | 185883 | 67262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 6 | Permit Number 30729 | 5981280.933019999 | 2112230.5095 | 37.7786957851972 | -122.508360365452 | (37.7786957851972, -122.508360365452) | |
| 171311 | 171311 | 67223 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30682 | 5981290.9854 | 2111950.9362 | 37.7779287520405 | -122.508304833393 | (37.7779287520405, -122.508304833393) | |
| 70184 | 70184 | 67244 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 5524 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 7 | Permit Number 30708 | 5981494.88729 | 2111682.33433 | 37.7772032645806 | -122.50757954173599 | (37.7772032645806, -122.507579541736) | |
| 50486 | 50486 | 46971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.6238 | 2103640.11 | 37.7551837030962 | -122.50333530778 | (37.7551837030962, -122.50333530778) | |
| 160628 | 160628 | 183298 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1286 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983077.482999999 | 2106384.7622 | 37.762750759369105 | -122.501712895715 | (37.7627507593691, -122.501712895715) | |||
| 56852 | 56852 | 183625 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1431 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983375.6866 | 2105398.8736 | 37.7600612994594 | -122.50060862808701 | (37.7600612994594, -122.500608628087) | |||
| 154101 | 154101 | 62594 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.8986299997 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | |
| 159008 | 159008 | 62593 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.2368799997 | 37.7750775975018 | -122.49734715750401 | (37.7750775975018, -122.497347157504) | |
| 121186 | 121186 | 62592 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | ||
| 64603 | 64603 | 62591 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.774573792054795 | -122.497317337939 | (37.7745737920548, -122.497317337939) | |
| 75651 | 75651 | 118275 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5984440.01732 | 2110639.37608 | 37.7745126579414 | -122.497314542381 | (37.7745126579414, -122.497314542381) | |||
| 41938 | 41938 | 62597 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.49730988283301 | (37.7744677278845, -122.497309882833) | |
| 26884 | 26884 | 54531 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 855 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 12 | Permit Number 10326 | 5984466.31691 | 2110015.99536 | 37.7728025745037 | -122.497177542996 | (37.7728025745037, -122.497177542996) | ||
| 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) | |||
| 172508 | 172508 | 182848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1795 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5985939.7457 | 2103040.5574 | 37.7537362025059 | -122.491567304651 | (37.7537362025059, -122.491567304651) | |||
| 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) | ||||
| 65846 | 65846 | 37203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1574 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39770 | 5986243.4033 | 2104539.0139 | 37.7578682946863 | -122.49062744276699 | (37.7578682946863, -122.490627442767) | |
| 130474 | 130474 | 119507 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 725 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5986293.694519999 | 2110943.52758 | 37.7754562387381 | -122.49092478893101 | (37.7754562387381, -122.490924788931) | |||
| 151314 | 151314 | 119942 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 346 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5986553.230140001 | 2113597.32948 | 37.7827579817147 | -122.490222261455 | (37.7827579817147, -122.490222261455) | |||
| 180317 | 180317 | 185606 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2123 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987259.0828 | 2100808.0996 | 37.7476834885004 | -122.48684086956699 | (37.7476834885004, -122.486840869567) | |||
| 122091 | 122091 | 114098 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 219x VIDAL DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 40 | 5987664.0 | 2090565.0 | 37.719582202213104 | -122.48468943736401 | (37.7195822022131, -122.484689437364) | ||||
| 88441 | 88441 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 239x VIDAL DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5987668.0 | 2090475.0 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | ||||
| 148718 | 148718 | 59149 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 218 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1980 12:00:00 AM | 7 | Permit Number 18458 | 5987761.12595 | 2114471.82373 | 37.7852295614332 | -122.48610772054501 | (37.7852295614332, -122.486107720545) | ||
| 175991 | 175991 | 101635 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1800X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987855.0174 | 2102962.611 | 37.753633925344296 | -122.484938226474 | (37.7536339253443, -122.484938226474) | |||
| 33362 | 33362 | 55257 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 810 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | 5 | Permit Number 11179 | 5988221.44369 | 2110421.88962 | 37.7741363990758 | -122.48421806494801 | (37.7741363990758, -122.484218064948) | ||
| 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) | |||
| 58329 | 58329 | 120302 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 361 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5988369.83373 | 2113569.61422 | 37.7827878063085 | -122.483935624743 | (37.7827878063085, -122.483935624743) | |||
| 177288 | 177288 | 101277 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2323 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988481.6146 | 2106443.4757 | 37.7632279152074 | -122.48302644728001 | (37.7632279152074, -122.48302644728) | |||
| 11487 | 11487 | 110355 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988563.2444 | 2106497.4984 | 37.763380996470005 | -122.482748079472 | (37.76338099647, -122.482748079472) | |||
| 124121 | 124121 | 12823 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3 | 5 | 5988577.51702 | 2114639.82314 | 37.785738385289896 | -122.483295611932 | (37.7857383852899, -122.483295611932) | ||
| 32562 | 32562 | 183926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988583.1369 | 2101004.688 | 37.7483003735732 | -122.482276819356 | (37.7483003735732, -122.482276819356) | |||
| 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) | |||
| 149295 | 149295 | 120400 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5988653.91402 | 2114240.5156099997 | 37.7846464457785 | -122.483002026322 | (37.7846464457785, -122.483002026322) | |||
| 60756 | 60756 | 56836 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 2 | 3X3 | Permit Number 14067 | 5988782.4304 | 2103136.262 | 37.7541646986668 | -122.48174378301701 | (37.7541646986668, -122.481743783017) | |
| 164311 | 164311 | 181320 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2130 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989076.012999999 | 2106520.0924 | 37.7634728536567 | -122.48097625438999 | (37.7634728536567, -122.48097625439) | |||
| 99192 | 99192 | 101266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989175.0 | 2106519.0 | 37.7634756077712 | -122.48063381405599 | (37.7634756077712, -122.480633814056) | ||||
| 26544 | 26544 | 101281 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2049 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5989322.9543 | 2106470.5284 | 37.763351115778796 | -122.48011854571301 | (37.7633511157788, -122.480118545713) | |||
| 151635 | 151635 | 101284 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989388.4992 | 2106533.1127 | 37.7635267635243 | -122.479896429915 | (37.7635267635243, -122.479896429915) | |||
| 107084 | 107084 | 101265 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989459.10715 | 2106523.8610900003 | 37.7635054630097 | -122.47965154526001 | (37.7635054630097, -122.47965154526) | ||||
| 57258 | 57258 | 61503 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.784654374553206 | -122.479617149177 | (37.7846543745532, -122.479617149177) | |
| 34167 | 34167 | 181337 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1943 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989659.6191 | 2106483.3237 | 37.7634058040829 | -122.478955080908 | (37.7634058040829, -122.478955080908) | |||
| 47167 | 47167 | 182701 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1706 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5989689.5329 | 2103706.6241 | 37.75578346921429 | -122.478648542868 | (37.7557834692143, -122.478648542868) | |||
| 10520 | 10520 | 95069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | ||||
| 145747 | 145747 | 101261 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989742.0 | 2106485.0 | 37.763415190264894 | -122.478670277794 | (37.7634151902649, -122.478670277794) | ||||
| 60829 | 60829 | 101260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1900 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989805.9135 | 2106546.133 | 37.7635867556905 | -122.47845369468399 | (37.7635867556905, -122.478453694684) | |||
| 63108 | 63108 | 56420 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 231 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 7 | Permit Number 12580 | 5990219.564180001 | 2113818.4640099998 | 37.783578588527796 | -122.47755460021799 | (37.7835785885278, -122.477554600218) | ||
| 178868 | 178868 | 56417 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 222 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 10 | Permit Number 12577 | 5990267.02613 | 2113888.22786 | 37.783772894624 | -122.47739550229299 | (37.783772894624, -122.477395502293) | ||
| 132975 | 132975 | 56418 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 226 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 9 | Permit Number 12578 | 5990267.28978 | 2113858.89022 | 37.783692356954205 | -122.477392445306 | (37.7836923569542, -122.477392445306) | ||
| 165885 | 165885 | 56421 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 232 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 12 | 5x5 | Permit Number 12581 | 5990270.934780001 | 2113836.22748 | 37.7836303428936 | -122.47737817827 | (37.7836303428936, -122.47737817827) | |
| 33941 | 33941 | 40560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.47707654197399 | (37.779256995112, -122.477076541974) | |
| 135631 | 135631 | 122270 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1600 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990596.49847 | 2111330.4876599996 | 37.7767691597055 | -122.47606879302 | (37.7767691597055, -122.47606879302) | |||
| 158754 | 158754 | 67388 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 779 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | 12 | Permit Number 30885 | 5990666.23465 | 2110099.72843 | 37.7733938754744 | -122.475737660544 | (37.7733938754744, -122.475737660544) | |
| 118589 | 118589 | 34242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38052 | 5990773.84225381 | 2106807.51859079 | 37.7643605962692 | -122.47512505139099 | (37.7643605962692, -122.475125051391) | |||
| 164052 | 164052 | 55004 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 585 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10882 | 5990928.49024 | 2111392.95682 | 37.7769599278948 | -122.474924907094 | (37.7769599278948, -122.474924907094) | ||
| 150383 | 150383 | 56174 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 701 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12282 | 5990956.32694 | 2110582.1012 | 37.774735153466295 | -122.474769414984 | (37.7747351534663, -122.474769414984) | ||
| 187706 | 187706 | 55001 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 546 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 12 | Permit Number 10879 | 5990967.23553 | 2111663.9992 | 37.777706381155205 | -122.474810664746 | (37.7777063811552, -122.474810664746) | ||
| 172427 | 172427 | 56173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 680 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12281 | 5990998.5556 | 2110774.78809 | 37.7752666659576 | -122.474637404879 | (37.7752666659576, -122.474637404879) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) |
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");