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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||
| 10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | 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 | |||||||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 170072 | 170072 | 177090 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 36 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5993074.958319999 | 2086622.9468 | 37.7090719120225 | -122.46569961766001 | (37.7090719120225, -122.46569961766) | |||
| 52138 | 52138 | 177088 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 300x Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6001504.621119999 | 2086478.58914 | 37.7091581713864 | -122.436555171203 | (37.7091581713864, -122.436555171203) | |||
| 45077 | 45077 | 177085 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 466 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012392.66028 | 2086405.7608400001 | 37.7095709179289 | -122.39891908764099 | (37.7095709179289, -122.398919087641) | |||
| 37277 | 37277 | 177144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.709919907953704 | -122.43274552071001 | (37.7099199079537, -122.43274552071) | |||
| 158841 | 158841 | 177143 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002598.76646 | 2086748.83961 | 37.7099623361716 | -122.432792933869 | (37.7099623361716, -122.432792933869) | |||
| 125956 | 125956 | 40954 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | ||||
| 55233 | 55233 | 177086 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 114 Gillette Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6013074.44499 | 2086867.89295 | 37.7108778091238 | -122.39659507942301 | (37.7108778091238, -122.396595079423) | |||
| 86603 | 86603 | 114790 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013060.0 | 2086881.0 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | ||||
| 10409 | 10409 | 104687 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | |||
| 159795 | 159795 | 177087 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012854.2238300005 | 2086908.7049900002 | 37.710977612288794 | -122.397359080471 | (37.7109776122888, -122.397359080471) | |||
| 11719 | 11719 | 54938 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 14 | 4x3 | Permit Number 10816 | 6013051.4266099995 | 2086907.8440900003 | 37.7109862260136 | -122.39667743572599 | (37.7109862260136, -122.396677435726) | |
| 37951 | 37951 | 177075 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013151.428830001 | 2086913.1361599998 | 37.711006322265 | -122.396332172488 | (37.711006322265, -122.396332172488) | |||
| 65681 | 65681 | 54939 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 537 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 7 | Permit Number 10817 | 6013054.91789 | 2086947.83958 | 37.7110962400835 | -122.396668170907 | (37.7110962400835, -122.396668170907) | ||
| 156751 | 156751 | 54754 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 525 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/1972 12:00:00 AM | 16 | Permit Number 10602 | 6013004.6612 | 2086964.21665 | 37.7111384110727 | -122.396843018889 | (37.7111384110727, -122.396843018889) | ||
| 36952 | 36952 | 177076 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012816.17748 | 2087024.5576799999 | 37.711293602592896 | -122.397498698426 | (37.7112936025929, -122.397498698426) | |||
| 151424 | 151424 | 177077 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012777.255059999 | 2087037.0196900002 | 37.7113256535156 | -122.39763409854099 | (37.7113256535156, -122.397634098541) | |||
| 173389 | 173389 | 177078 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012757.34984 | 2087044.1812200001 | 37.71134420923121 | -122.397703398489 | (37.7113442092312, -122.397703398489) | |||
| 156887 | 156887 | 177079 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 411 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012724.51952 | 2087052.8334599999 | 37.7113661383121 | -122.397817475721 | (37.7113661383121, -122.397817475721) | |||
| 55331 | 55331 | 177080 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 411 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012673.3507900005 | 2087069.8441 | 37.7114099964555 | -122.397995521673 | (37.7114099964555, -122.397995521673) | |||
| 30331 | 30331 | 177074 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 250 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012293.95082 | 2087148.96015 | 37.711606095404704 | -122.399312384552 | (37.7116060954047, -122.399312384552) | |||
| 37287 | 37287 | 177073 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 250 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012250.9341 | 2087164.6168900002 | 37.7116466881279 | -122.399462161252 | (37.7116466881279, -122.399462161252) | |||
| 36975 | 36975 | 177081 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 299 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012270.95689 | 2087199.0340099998 | 37.711742306725995 | -122.39939537131 | (37.711742306726, -122.39939537131) | |||
| 144898 | 144898 | 31669 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | |||
| 59510 | 59510 | 177072 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 140 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012065.17517 | 2087224.72612 | 37.7118013805076 | -122.400108416784 | (37.7118013805076, -122.400108416784) | |||
| 136655 | 136655 | 177082 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 199 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012090.15374 | 2087257.68783 | 37.7118932795125 | -122.40002439671999 | (37.7118932795125, -122.40002439672) | |||
| 135468 | 135468 | 177083 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 199 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012071.18023 | 2087265.13818 | 37.7119126788116 | -122.400090497793 | (37.7119126788116, -122.400090497793) | |||
| 35900 | 35900 | 177084 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 199 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012033.75638 | 2087275.42031 | 37.71193882479629 | -122.400220567635 | (37.7119388247963, -122.400220567635) | |||
| 82585 | 82585 | 44826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 129 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2001 12:00:00 AM | Permit Number 43918 | 6010308.29040288 | 2087358.77915196 | 37.7120713475932 | -122.40619016379601 | (37.7120713475932, -122.406190163796) | |||
| 29104 | 29104 | 207851 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 266 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994330.673359999 | 2087784.2357400001 | 37.712332889716 | -122.46144384316099 | (37.712332889716, -122.461443843161) | |||
| 43925 | 43925 | 177069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6000083.89105 | 2087741.94761 | 37.7125462340909 | -122.44155601691901 | (37.7125462340909, -122.441556016919) | |||
| 26709 | 26709 | 177070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.712548932973206 | -122.44155935339501 | (37.7125489329732, -122.441559353395) | |||
| 148786 | 148786 | 177071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.85227 | 2087744.80295 | 37.7125540150319 | -122.441559812029 | (37.7125540150319, -122.441559812029) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 11054 | 11054 | 1139 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5998352.02606 | 2088442.52333 | 37.7143710331717 | -122.447592253902 | (37.7143710331717, -122.447592253902) | |||
| 186701 | 186701 | 177068 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 26 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000490.27056 | 2088504.66061 | 37.7146636177052 | -122.440206107549 | (37.7146636177052, -122.440206107549) | |||
| 11402 | 11402 | 1130 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2554 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5998598.100380001 | 2088668.31183 | 37.7150050570134 | -122.446757963627 | (37.7150050570134, -122.446757963627) | |||
| 159944 | 159944 | 101866 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 851 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2013 12:00:00 AM | 2 | 3x3 | Permit Number 769709 | 6001077.037690001 | 2088890.9773 | 37.71575774639479 | -122.438205662778 | (37.7157577463948, -122.438205662778) | |
| 21740 | 21740 | 26336 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2564 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997739.3987300005 | 2089429.54745 | 37.7170461430363 | -122.449780813452 | (37.7170461430363, -122.449780813452) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 29050 | 29050 | 207850 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 277 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5994296.2066 | 2089616.42482 | 37.7173616620944 | -122.461695729788 | (37.7173616620944, -122.461695729788) | |||
| 24017 | 24017 | 65613 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 743 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 18 | Permit Number 28520 | 6001843.34769 | 2089618.0611400001 | 37.71779771097221 | -122.43560893330299 | (37.7177977109722, -122.435608933303) | |
| 53693 | 53693 | 207848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 833 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5995895.43899 | 2089793.88094 | 37.717940843481706 | -122.45618078484199 | (37.7179408434817, -122.456180784842) | |||
| 20442 | 20442 | 19325 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 212 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X4 | 5993418.3820400005 | 2089852.67557 | 37.717959779598 | -122.464747082736 | (37.717959779598, -122.464747082736) | |||
| 146527 | 146527 | 177089 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 545 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009804.5393 | 2089523.18108 | 37.717986161204706 | -122.408083826812 | (37.7179861612047, -122.408083826812) | |||
| 102900 | 102900 | 52416 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 734 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2005 12:00:00 AM | Permit Number 48535 | 6001832.35713287 | 2089688.63788093 | 37.717990874718 | -122.43565196916799 | (37.717990874718, -122.435651969168) | ||
| 48436 | 48436 | 177044 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 87 Seneca Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000253.62595 | 2089858.9653200002 | 37.7183687570946 | -122.44112115243999 | (37.7183687570946, -122.44112115244) | |||
| 160832 | 160832 | 177043 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 87 Seneca Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6000241.05575 | 2089872.3479 | 37.7184047866172 | -122.441165561868 | (37.7184047866172, -122.441165561868) | |||
| 72591 | 72591 | 177042 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 123 Seneca Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000059.76293 | 2090063.89794 | 37.7189204111404 | -122.441805953806 | (37.7189204111404, -122.441805953806) | |||
| 135805 | 135805 | 207849 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 48 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995641.83079 | 2090207.60009 | 37.7190622575991 | -122.45708730146099 | (37.7190622575991, -122.457087301461) | |||
| 139428 | 139428 | 67005 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 48 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30360 | 5995649.51069731 | 2090220.09677054 | 37.7190970115741 | -122.457061658607 | (37.7190970115741, -122.457061658607) | ||
| 34744 | 34744 | 177051 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.44564302283199 | (37.7191438872553, -122.445643022832) | |||
| 149265 | 149265 | 62617 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 608 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1986 12:00:00 AM | 7 | Permit Number 22927 | 6001463.88334 | 2090119.9381900001 | 37.719154192602 | -122.43695648018101 | (37.719154192602, -122.436956480181) | ||
| 154412 | 154412 | 177052 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998953.787769999 | 2090172.9381799998 | 37.719156729587 | -122.445636697899 | (37.719156729587, -122.445636697899) | |||
| 149576 | 149576 | 177053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998955.229780001 | 2090176.99773 | 37.719167958508 | -122.445632005212 | (37.719167958508, -122.445632005212) | |||
| 68735 | 68735 | 177054 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998957.42918 | 2090181.0336799999 | 37.719179165869996 | -122.44562469283001 | (37.71917916587, -122.44562469283) | |||
| 64895 | 64895 | 177055 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998959.63131 | 2090185.20091 | 37.7191907338521 | -122.44561738044399 | (37.7191907338521, -122.445617380444) | |||
| 183308 | 183308 | 177056 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998961.55007 | 2090188.4526900002 | 37.71919977204001 | -122.44561098175801 | (37.71919977204, -122.445610981758) | |||
| 177642 | 177642 | 177057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998963.193390001 | 2090191.18353 | 37.7192073641203 | -122.44560549771799 | (37.7192073641203, -122.445605497718) | |||
| 97569 | 97569 | 177058 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998964.8504 | 2090194.5720900001 | 37.7192167629302 | -122.44560001362801 | (37.7192167629302, -122.445600013628) | |||
| 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) | ||||
| 156675 | 156675 | 177064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 102 France Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | |||
| 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) | |||
| 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) | |||
| 40485 | 40485 | 177065 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002192.98275 | 2090253.20784 | 37.7195615351173 | -122.43444578884599 | (37.7195615351173, -122.434445788846) | |||
| 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) | ||||
| 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) | |||
| 67169 | 67169 | 207858 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 143 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993571.00568 | 2090460.55199 | 37.7196376600192 | -122.46426364137699 | (37.7196376600192, -122.464263641377) | |||
| 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) | |||
| 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) | |||
| 143643 | 143643 | 65177 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 573 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27158 | 6002678.99460756 | 2090431.51316854 | 37.7200786982312 | -122.43277855471001 | (37.7200786982312, -122.43277855471) | ||
| 177409 | 177409 | 207847 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995588.095430001 | 2090580.79577 | 37.7200838784522 | -122.457300026187 | (37.7200838784522, -122.457300026187) | |||
| 104680 | 104680 | 67018 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30374 | 5995620.26197767 | 2090586.55623665 | 37.7201015427641 | -122.457189254526 | (37.7201015427641, -122.457189254526) | ||
| 143521 | 143521 | 67985 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 212 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31709 | 5996176.45016211 | 2090576.83582112 | 37.7201067800111 | -122.455266009291 | (37.7201067800111, -122.455266009291) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 55289 | 55289 | 177095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | ||||
| 24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
| 66634 | 66634 | 207845 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 125 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5995607.338719999 | 2090657.41082 | 37.7202953504384 | -122.457239048555 | (37.7202953504384, -122.457239048555) | |||
| 182678 | 182678 | 67465 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 937 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 9 | Permit Number 30978 | 6008961.1272 | 2090382.77007 | 37.7202991536555 | -122.41105982826001 | (37.7202991536555, -122.41105982826) | ||
| 35972 | 35972 | 207841 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 314 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5994779.70633 | 2090681.1537400002 | 37.72031297444521 | -122.460101600536 | (37.7203129744452, -122.460101600536) | |||
| 150660 | 150660 | 207840 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 314 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5994777.11096 | 2090681.2081099998 | 37.7203129744533 | -122.460110575752 | (37.7203129744533, -122.460110575752) |
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");