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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||
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) | ||
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) | |||
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) | ||
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) | ||
98762 | 98762 | 207846 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 160 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995656.91883 | 2090949.83096 | 37.721101114209205 | -122.45708880872401 | (37.7211011142092, -122.457088808724) | |||
142846 | 142846 | 67008 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30363 | 5995610.42846311 | 2090973.17671265 | 37.721162546103 | -122.457251199338 | (37.721162546103, -122.457251199338) | ||
177872 | 177872 | 207844 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995613.369530001 | 2090975.38331 | 37.721168773811 | -122.457241192529 | (37.721168773811, -122.457241192529) | |||
147795 | 147795 | 207843 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995613.80856 | 2091011.1988 | 37.721267139854795 | -122.457242264538 | (37.7212671398548, -122.457242264538) | |||
44078 | 44078 | 66992 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30345 | 5995611.62082258 | 2091036.47990525 | 37.721336430114796 | -122.457251654811 | (37.7213364301148, -122.457251654811) | ||
181443 | 181443 | 207842 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 193 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995618.109069999 | 2091172.31825 | 37.7217097825699 | -122.457239048551 | (37.7217097825699, -122.457239048551) | |||
2689 | 2689 | 207839 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626X Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994826.85492 | 2091253.8672900002 | 37.721888220645 | -122.459980091334 | (37.721888220645, -122.459980091334) | |||
91855 | 91855 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
91870 | 91870 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
99827 | 99827 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
109913 | 109913 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
110638 | 110638 | 122414 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
112319 | 112319 | 122417 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
112873 | 112873 | 122416 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
116737 | 116737 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
122326 | 122326 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
188009 | 188009 | 177141 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 355 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003671.36983 | 2091507.3370599998 | 37.7230889064227 | -122.429424930532 | (37.7230889064227, -122.429424930532) | |||
60851 | 60851 | 177046 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 317 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6000299.83904 | 2091602.15468 | 37.7231577908794 | -122.441086408025 | (37.7231577908794, -122.441086408025) | |||
11106 | 11106 | 25304 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 5999755.51283 | 2091622.1717 | 37.7231817335313 | -122.44296946786501 | (37.7231817335313, -122.442969467865) | |||
13198 | 13198 | 25303 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 286 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x9 | 5999775.2112 | 2091625.73202 | 37.7231926324273 | -122.4429016302 | (37.7231926324273, -122.4429016302) | |||
97971 | 97971 | 62791 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23147 | 5999722.02733953 | 2091630.11110927 | 37.7232016241068 | -122.44308579022301 | (37.7232016241068, -122.443085790223) | ||
55936 | 55936 | 177099 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999714.66231 | 2091641.03543 | 37.7232311998395 | -122.44311203381099 | (37.7232311998395, -122.443112033811) | |||
104134 | 104134 | 62790 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23146 | 6000313.64252899 | 2091641.02456839 | 37.7232653049393 | -122.441041479459 | (37.7232653049393, -122.441041479459) | ||
41100 | 41100 | 177100 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999723.90595 | 2091657.9425099997 | 37.7232781498534 | -122.443081294068 | (37.7232781498534, -122.443081294068) | |||
169770 | 169770 | 177045 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 21 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6000634.5733900005 | 2091639.69962 | 37.7232799412972 | -122.43993199059099 | (37.7232799412972, -122.439931990591) | |||
12673 | 12673 | 25310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 197 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000354.040159999 | 2091646.91959 | 37.7232837922084 | -122.440902255631 | (37.7232837922084, -122.440902255631) | |||
42836 | 42836 | 67278 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 58 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1992 12:00:00 AM | 3 | Permit Number 30752 | 6004928.68664 | 2091573.7324299999 | 37.7233423191649 | -122.42508335531001 | (37.7233423191649, -122.42508335531) | |
106537 | 106537 | 62784 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 137 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23140 | 6000712.17881294 | 2091681.24596218 | 37.723398435511896 | -122.439666701145 | (37.7233984355119, -122.439666701145) | ||
106547 | 106547 | 62782 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23138 | 6000753.3579224 | 2091686.36985433 | 37.7234148482869 | -122.439524720053 | (37.7234148482869, -122.439524720053) | ||
119329 | 119329 | 62781 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23137 | 6000780.81066937 | 2091689.78578334 | 37.7234257900447 | -122.43943006593099 | (37.7234257900447, -122.439430065931) | ||
82598 | 82598 | 62789 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.44101991790899 | (37.7234373055999, -122.441019917909) | ||
13006 | 13006 | 25299 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000418.66631 | 2091706.69164 | 37.7234515931109 | -122.44068314123001 | (37.7234515931109, -122.44068314123) | |||
108690 | 108690 | 62788 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23144 | 6000370.84981794 | 2091713.58104778 | 37.723467786704504 | -122.440848927652 | (37.7234677867045, -122.440848927652) | ||
178387 | 178387 | 62826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 170 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | 8 | Permit Number 23191 | 6000498.4193400005 | 2091715.9404799999 | 37.723481529728495 | -122.44040811326299 | (37.7234815297285, -122.440408113263) | |
11709 | 11709 | 25297 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000520.37509 | 2091718.7559 | 37.723490510352995 | -122.440332418218 | (37.723490510353, -122.440332418218) | |||
172527 | 172527 | 177103 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 154 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000580.38347 | 2091726.23406 | 37.723514460202395 | -122.440125516598 | (37.7235144602024, -122.440125516598) | |||
142722 | 142722 | 62787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23143 | 6000550.01003757 | 2091735.82644797 | 37.723539069470206 | -122.44023119939699 | (37.7235390694702, -122.440231199397) | ||
11537 | 11537 | 25293 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6000659.82425 | 2091738.03378 | 37.7235513818789 | -122.43985175036998 | (37.7235513818789, -122.43985175037) | |||
94190 | 94190 | 62786 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23142 | 6000618.91780925 | 2091744.38237049 | 37.723566485054 | -122.439993611308 | (37.723566485054, -122.439993611308) | ||
10599 | 10599 | 25290 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000711.5604 | 2091742.5944599998 | 37.7235668493142 | -122.439673234935 | (37.7235668493142, -122.439673234935) | |||
111795 | 111795 | 25294 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000635.349880001 | 2091747.8935900002 | 37.7235770614816 | -122.439937060329 | (37.7235770614816, -122.439937060329) | |||
10803 | 10803 | 25289 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000745.99488 | 2091748.7856599998 | 37.72358580881671 | -122.439554644937 | (37.7235858088167, -122.439554644937) | |||
73882 | 73882 | 177102 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 130 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000764.64112 | 2091750.39808 | 37.72359129737671 | -122.439490303855 | (37.7235912973767, -122.439490303855) | |||
140867 | 140867 | 62785 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23141 | 6000686.30847209 | 2091752.62403135 | 37.7235929509131 | -122.43976124488998 | (37.7235929509131, -122.43976124489) |
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");