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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188762 | 188762 | 65630 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2510 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 8 | Permit Number 28538 | 6001388.347 | 2114610.3564 | 37.7863947012265 | -122.43897175770701 | (37.7863947012265, -122.438971757707) | |
187844 | 187844 | 64559 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1562 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 12 | Permit Number 25450 | 6000352.3546 | 2110302.164 | 37.774506509156204 | -122.442246634385 | (37.7745065091562, -122.442246634385) | |
187811 | 187811 | 101108 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | Permit Number 14067 | 5988777.5028 | 2103198.1315 | 37.754334289199704 | -122.481765355128 | (37.7543342891997, -122.481765355128) | ||
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) | ||
186959 | 186959 | 66501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1625 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29664 | 5999574.2556 | 2114579.9293 | 37.7862077735321 | -122.44524584382 | (37.7862077735321, -122.44524584382) | |
186625 | 186625 | 61561 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2018 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 13 | Permit Number 21521 | 6012372.92464 | 2102851.20002 | 37.754725580248 | -122.40014150193399 | (37.754725580248, -122.400141501934) | |
186375 | 186375 | 114467 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009280.92289 | 2121766.4788599997 | 37.8064895545061 | -122.412171287793 | (37.8064895545061, -122.412171287793) | |||
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) | |
184650 | 184650 | 54966 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 734 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1972 12:00:00 AM | 16 | Permit Number 10844 | 5993209.18585 | 2111421.27834 | 37.777169597209 | -122.467037406046 | (37.777169597209, -122.467037406046) | ||
184064 | 184064 | 62716 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/1986 12:00:00 AM | 17 | Permit Number 23059 | 6007595.431480001 | 2119179.891 | 37.799292719927294 | -122.417820789314 | (37.7992927199273, -122.417820789314) | |
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) | ||
179911 | 179911 | 38634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 16 | Permit Number 767658 | 6014976.9663 | 2094092.323 | 37.7308203704303 | -122.390523948894 | (37.7308203704303, -122.390523948894) | |
179791 | 179791 | 36154 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.8051 | 2114133.6254 | 37.7848092398389 | -122.45567731688699 | (37.7848092398389, -122.455677316887) | |
179640 | 179640 | 57058 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2030 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 9 | Permit Number 18365 | 6001452.76061 | 2115511.13593 | 37.78887167462379 | -122.438813476778 | (37.7888716746238, -122.438813476778) | ||
179367 | 179367 | 65899 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 166 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 8 | Permit Number 28906 | 5995945.57364 | 2113203.14409 | 37.782219693115394 | -122.45770039603998 | (37.7822196931154, -122.45770039604) | |
179289 | 179289 | 62212 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 11 | Permit Number 22335 | 6001303.33369 | 2093769.8822599999 | 37.729166984360795 | -122.437772711138 | (37.7291669843608, -122.437772711138) | |
179036 | 179036 | 62083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | 11 | Permit Number 22167 | 6013240.89819 | 2104321.43892 | 37.758810894525794 | -122.397242884449 | (37.7588108945258, -122.397242884449) | |
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) | ||
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) | |
177945 | 177945 | 45683 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 107 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2001 12:00:00 AM | 4 | Permit Number 44370 | 6008292.83323 | 2118060.93092 | 37.79625955578 | -122.41532827329901 | (37.79625955578, -122.415328273299) | ||
177215 | 177215 | 114470 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6009302.49876 | 2121620.58079 | 37.8060901655936 | -122.412086302768 | (37.8060901655936, -122.412086302768) | |||
176592 | 176592 | 34689 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.79943447017929 | -122.434367321195 | (37.7994344701793, -122.434367321195) |
176161 | 176161 | 31106 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | |
174916 | 174916 | 61663 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 121 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 9 | 6x9 | Permit Number 21657 | 5992393.21685 | 2114622.9849400003 | 37.7859134760601 | -122.470093267127 | (37.7859134760601, -122.470093267127) |
174666 | 174666 | 68980 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2258 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53507 | 6000514.3803 | 2119968.0276200003 | 37.8010556951124 | -122.44238022937901 | (37.8010556951124, -122.442380229379) | |
174274 | 174274 | 47892 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 725 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2002 12:00:00 AM | 1 | Permit Number 45636 | 6000495.8068 | 2111504.9503 | 37.7778172299888 | -122.441836750591 | (37.7778172299888, -122.441836750591) | |
172930 | 172930 | 88217 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2833 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51182 | 6002528.21368 | 2117927.18 | 37.7955666353375 | -122.435265448048 | (37.7955666353375, -122.435265448048) | |
172576 | 172576 | 30910 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 11 | Permit Number 34732 | 5994801.3845 | 2091947.2904299998 | 37.723790729247 | -122.46011834680901 | (37.723790729247, -122.460118346809) | ||
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) | ||
171655 | 171655 | 67616 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1493 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 4 | Permit Number 31197 | 6002054.0075 | 2111526.4952 | 37.777965051221706 | -122.43644794433399 | (37.7779650512217, -122.436447944334) | |
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) | |
171205 | 171205 | 60035 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 135 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 15 | Permit Number 19524 | 6014295.81848 | 2112435.53684 | 37.7811490811156 | -122.39416251758101 | (37.7811490811156, -122.394162517581) | |
170773 | 170773 | 96011 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009766.6453599995 | 2116419.41202 | 37.7918350666884 | -122.410112610112 | (37.7918350666884, -122.410112610112) |
169859 | 169859 | 60021 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 76 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 14 | Permit Number 19508 | 6014385.60562 | 2112720.25781 | 37.781935850286004 | -122.393871832437 | (37.781935850286, -122.393871832437) | |
168157 | 168157 | 101109 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | Permit Number 14067 | 5988776.9552 | 2103216.747 | 37.754385370533704 | -122.48176861229099 | (37.7543853705337, -122.481768612291) | ||
167683 | 167683 | 65928 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 41 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 4 | Permit Number 28947 | 5995850.771380001 | 2114206.39787 | 37.7849689134171 | -122.45810099794 | (37.7849689134171, -122.45810099794) | |
167171 | 167171 | 41176 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.193109999 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | |
166994 | 166994 | 34691 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.43435014504699 | (37.7993346796145, -122.434350145047) |
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) | |
165700 | 165700 | 73647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769028 | 6011581.87532 | 2119117.15178 | 37.799343987593495 | -122.404021813977 | (37.7993439875935, -122.404021813977) | |
165273 | 165273 | 59135 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 416 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1992 12:00:00 AM | 15 | Permit Number 30326 | 5992208.149780001 | 2112497.17184 | 37.7800658767774 | -122.470578655632 | (37.7800658767774, -122.470578655632) | ||
165245 | 165245 | 62020 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1615 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 9 | Permit Number 29670 | 5999582.1849 | 2114512.53 | 37.786023165226496 | -122.44521356308901 | (37.7860231652265, -122.445213563089) | |
165028 | 165028 | 37499 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010316.35975 | 2115796.38999 | 37.790155194247 | -122.408166630084 | (37.790155194247, -122.408166630084) | |
164660 | 164660 | 67592 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 355 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 8 | Permit Number 31159 | 6013796.23882 | 2105471.52113 | 37.7619996710595 | -122.39540281491199 | (37.7619996710595, -122.395402814912) | |
164215 | 164215 | 62019 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1617 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29660 | 5999580.2026 | 2114540.2826 | 37.7860992534846 | -122.445222417327 | (37.7860992534846, -122.445222417327) | |
164144 | 164144 | 56147 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2311 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1973 12:00:00 AM | 16 | Permit Number 12254 | 6001277.581809999 | 2116437.2088900004 | 37.7914044631939 | -122.43948598169901 | (37.7914044631939, -122.439485981699) | ||
164136 | 164136 | 64560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1556 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 9 | Permit Number 25451 | 6000388.6712 | 2110305.5423 | 37.7745178548342 | -122.442121251164 | (37.7745178548342, -122.442121251164) | |
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) | ||
163153 | 163153 | 50368 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2784 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 4 | Permit Number 47035 | 6000204.6547 | 2114445.9464 | 37.7858758547183 | -122.443055209056 | (37.7858758547183, -122.443055209056) | ||
163116 | 163116 | 59083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 771 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 5 | Permit Number 18384 | 5993309.0611 | 2110688.13822 | 37.7751623558712 | -122.46663860527399 | (37.7751623558712, -122.466638605274) | ||
161870 | 161870 | 98647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | ||
161810 | 161810 | 38641 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | 16 | Permit Number 40566 | 6014964.8748 | 2094103.3153 | 37.7308498822776 | -122.39056651931001 | (37.7308498822776, -122.39056651931) | |
161571 | 161571 | 107462 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6008769.702769999 | 2118455.29192 | 37.797369163620296 | -122.41370610855101 | (37.7973691636203, -122.413706108551) | ||||
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) | |
159755 | 159755 | 33285 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1537 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 6 | Permit Number 37447 | 6008380.6183400005 | 2117789.48589 | 37.795519168221205 | -122.415005295285 | (37.7955191682212, -122.415005295285) | |
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) | |
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) | |
156948 | 156948 | 65824 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2261 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | 7 | Permit Number 28814 | 6000527.32419 | 2119926.01796 | 37.800941085523 | -122.442332420517 | (37.800941085523, -122.442332420517) | |
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) | ||
156275 | 156275 | 65934 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 150 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 7 | Permit Number 28953 | 5995941.68563 | 2113369.58328 | 37.782676467432 | -122.45772589379801 | (37.782676467432, -122.457725893798) | |
156018 | 156018 | 62213 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 37 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 13 | Permit Number 22336 | 6001177.27304 | 2093672.32892 | 37.7288919563899 | -122.43820152677401 | (37.7288919563899, -122.438201526774) | |
155754 | 155754 | 33325 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3129 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 6 | Permit Number 37467 | 6004621.77515 | 2120339.1795900003 | 37.8023080334521 | -122.42819334046301 | (37.8023080334521, -122.428193340463) | |
155464 | 155464 | 41179 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.9248200003 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | |
154798 | 154798 | 68437 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 22 | Permit Number 32291 | 6008616.38965 | 2110404.13314 | 37.7752540178903 | -122.41366685765101 | (37.7752540178903, -122.413666857651) | ||
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) | |
153048 | 153048 | 98645 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.799200885676605 | -122.434457791187 | (37.7992008856766, -122.434457791187) | ||
152845 | 152845 | 59094 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 627 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 11 | Permit Number 18395 | 5994067.68279 | 2111215.68706 | 37.7766546137994 | -122.464052687917 | (37.7766546137994, -122.464052687917) | ||
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) | ||
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) | ||
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) | ||
146966 | 146966 | 30911 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34732 | 5994801.07425 | 2091932.47974 | 37.7237500448081 | -122.460118346802 | (37.7237500448081, -122.460118346802) | |
146797 | 146797 | 66827 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1994 12:00:00 AM | 7 | 3x3 | Permit Number 33308 | 6009276.00847 | 2121806.9136099997 | 37.8066003024322 | -122.412191154694 | (37.8066003024322, -122.412191154694) | |
146257 | 146257 | 66835 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 701 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | Permit Number 30135 | 6009204.71418502 | 2115334.29605872 | 37.788824089315796 | -122.41198018251 | (37.7888240893158, -122.41198018251) | ||
146117 | 146117 | 12192 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1465 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016272.6778818 | 2095480.4561363999 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | |||
146015 | 146015 | 68829 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32780 | 6000341.33765445 | 2094036.785475 | 37.729845090832 | -122.441117543772 | (37.729845090832, -122.441117543772) | ||
145692 | 145692 | 58421 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 68 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/1979 12:00:00 AM | 6x3.5 | Permit Number 17560 | 5999339.95243749 | 2107930.01507988 | 37.7679354379891 | -122.44557810019501 | (37.7679354379891, -122.445578100195) | ||
145670 | 145670 | 61864 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1266 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | 11 | 3x3 | Permit Number 21904 | 6010288.23074759 | 2101843.68563372 | 37.7518427109773 | -122.40727995543502 | (37.7518427109773, -122.407279955435) |
145645 | 145645 | 62706 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | Permit Number 23046 | 6007274.51894323 | 2119093.66115296 | 37.7990378895325 | -122.418925141627 | (37.7990378895325, -122.418925141627) | ||
145562 | 145562 | 60025 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 155 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19512 | 6014214.21813778 | 2112495.49732401 | 37.7813091831039 | -122.39444901599899 | (37.7813091831039, -122.394449015999) | ||
145291 | 145291 | 64518 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 512 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | Permit Number 25400 | 6000652.29265662 | 2110712.76052634 | 37.77565099320879 | -122.441238559661 | (37.7756509932088, -122.441238559661) | ||
145026 | 145026 | 59097 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 606 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | 6x4 | Permit Number 18399 | 5993800.13765 | 2111331.73354 | 37.7769578233506 | -122.464986627707 | (37.7769578233506, -122.464986627707) | |
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) | |||
144635 | 144635 | 20278 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
144349 | 144349 | 20274 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | |||
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) | ||
143556 | 143556 | 35620 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 271 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38974 | 6005958.6690018 | 2115368.0219754 | 37.78873403898871 | -122.42321345725901 | (37.7887340389887, -122.423213457259) | |||
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) | ||
143379 | 143379 | 20268 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
143263 | 143263 | 14807 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1160X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003602.65321 | 2111793.09154 | 37.7787849351465 | -122.43110966583299 | (37.7787849351465, -122.431109665833) | |||
143161 | 143161 | 62092 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 427 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | Permit Number 22181 | 6013254.84660542 | 2105078.89675682 | 37.7608914844372 | -122.397247759573 | (37.7608914844372, -122.397247759573) | ||
143097 | 143097 | 89036 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
143030 | 143030 | 59021 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 116 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1988 12:00:00 AM | Permit Number 25608 | 6005536.1099439 | 2104041.86258252 | 37.75761128554 | -122.423869755917 | (37.75761128554, -122.423869755917) | ||
142958 | 142958 | 20262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | |||
142944 | 142944 | 61841 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1051 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1991 12:00:00 AM | Permit Number 29816 | 6010269.32300261 | 2103102.32039095 | 37.7552975843096 | -122.40743406658301 | (37.7552975843096, -122.407434066583) | ||
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) | ||
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) | ||
142205 | 142205 | 68799 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32738 | 5992323.72089278 | 2098718.16784221 | 37.742239045272996 | -122.469175702533 | (37.742239045273, -122.469175702533) | ||
141672 | 141672 | 37544 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 825 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39986 | 6008203.02144852 | 2114810.28677718 | 37.7873290368122 | -122.415408797554 | (37.7873290368122, -122.415408797554) | ||
141136 | 141136 | 60022 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 64 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19509 | 6014593.22345076 | 2112850.04710835 | 37.782303758061 | -122.393162649296 | (37.782303758061, -122.393162649296) | ||
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");