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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93271 | 93271 | 8100 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 765 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004193.95704 | 2111472.64562 | 37.7779385589247 | -122.429041260431 | (37.7779385589247, -122.429041260431) | ||
| 101774 | 101774 | 8103 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 775 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004110.63243 | 2111457.69852 | 37.7778928009026 | -122.42932844351601 | (37.7778928009026, -122.429328443516) | ||
| 79717 | 79717 | 10670 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002868.606349099 | 2110598.6567928 | 37.775463691965896 | -122.43356363564301 | (37.7754636919659, -122.433563635643) | |||
| 105619 | 105619 | 11343 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1300X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | ||
| 19205 | 19205 | 17244 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 10X Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2005 12:00:00 AM | 6 | 3X3 | 5993945.3779 | 2088542.9193 | 37.7143938707274 | -122.462830535838 | (37.7143938707274, -122.462830535838) | ||
| 113357 | 113357 | 18570 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 698X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 5992368.005846401 | 2088553.4079402 | 37.7143316913291 | -122.46828327353701 | (37.7143316913291, -122.468283273537) | ||
| 17486 | 17486 | 18596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.46642881780501 | (37.7141961040887, -122.466428817805) | ||
| 21649 | 21649 | 18607 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 530 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3x3 | 5992558.0676 | 2088557.0731 | 37.7143527306111 | -122.467626617395 | (37.7143527306111, -122.467626617395) | ||
| 17788 | 17788 | 18608 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | ||
| 98414 | 98414 | 22550 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 23 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2008 12:00:00 AM | 4 | 2x3 | 6001475.729427099 | 2098645.6307198997 | 37.742564460006896 | -122.437525748228 | (37.7425644600069, -122.437525748228) | ||
| 105407 | 105407 | 25463 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 308 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 3 | 3X3 | 5993157.11936 | 2088546.32287 | 37.714357782974204 | -122.46555529463001 | (37.7143577829742, -122.46555529463) | ||
| 17804 | 17804 | 26068 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 282 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2003 12:00:00 AM | 3 | 2X3 | 5994051.2236 | 2088339.7969 | 37.7138422407476 | -122.46244996961 | (37.7138422407476, -122.46244996961) | ||
| 18943 | 18943 | 26157 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 260 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1997 12:00:00 AM | 3 | 3X3 | 5994051.6997 | 2088243.7899 | 37.713578655736 | -122.462441364614 | (37.713578655736, -122.462441364614) | ||
| 15769 | 15769 | 30659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 54 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34592 | 6007591.74325 | 2109572.72569 | 37.7729135790239 | -122.41715242667 | (37.7729135790239, -122.41715242667) |
| 130691 | 130691 | 30907 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2363 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37373 | 5987310.298054401 | 2099201.63941585 | 37.743275562979605 | -122.486545838163 | (37.7432755629796, -122.486545838163) | |
| 34675 | 34675 | 31971 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 9 | Permit Number 35372 | 5995225.90281 | 2114852.20624 | 37.786706205556 | -122.46030963631 | (37.786706205556, -122.46030963631) | |
| 29132 | 29132 | 31972 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995228.46958 | 2114784.79077 | 37.786521248530995 | -122.46029586964701 | (37.786521248531, -122.460295869647) | |
| 29438 | 29438 | 31973 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | |
| 53789 | 53789 | 32019 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 900 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.40005739994601 | (37.7704413522571, -122.400057399946) | |||
| 147065 | 147065 | 32517 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 837 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | 5 | Permit Number 39421 | 6007583.92915 | 2095468.81341 | 37.734187007231796 | -122.41618038453998 | (37.7341870072318, -122.41618038454) | |
| 40556 | 40556 | 32518 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | |
| 183550 | 183550 | 32520 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 848 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 6 | Permit Number 37022 | 6007545.9989 | 2095398.0670900003 | 37.7339906204551 | -122.416306512649 | (37.7339906204551, -122.416306512649) | |
| 60527 | 60527 | 32523 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 861 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 8 | Permit Number 37025 | 6007568.6691 | 2095324.89508 | 37.7337909808565 | -122.416222953925 | (37.7337909808565, -122.416222953925) | |
| 68843 | 68843 | 32524 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 862 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 4 | Permit Number 37026 | 6007537.57048 | 2095302.13495 | 37.733726737790796 | -122.416328859904 | (37.7337267377908, -122.416328859904) | |
| 54592 | 54592 | 32576 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1366 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37050 | 5986201.05883385 | 2105941.9596711 | 37.7617179230551 | -122.49087711798 | (37.7617179230551, -122.49087711798) | |
| 176744 | 176744 | 32595 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1383 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37063 | 5985531.94877095 | 2105814.83097448 | 37.7613297510328 | -122.49318190152901 | (37.7613297510328, -122.493181901529) | |
| 66939 | 66939 | 32596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1474 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37064 | 5985605.53989408 | 2105188.12612078 | 37.759613297357895 | -122.492881221287 | (37.7596132973579, -122.492881221287) | |
| 54735 | 54735 | 32597 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1478 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37065 | 5985606.43921528 | 2105161.9851204 | 37.759541574007 | -122.492876185531 | (37.759541574007, -122.492876185531) | |
| 29717 | 29717 | 32611 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2926 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 0 | Permit Number 37076 | 5985807.8579886 | 2105043.58172562 | 37.7592282476447 | -122.492170870983 | (37.7592282476447, -122.492170870983) | |
| 141851 | 141851 | 32857 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 142436 | 142436 | 32858 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 126641 | 126641 | 32859 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 118244 | 118244 | 32863 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 369 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37210 | 6002757.72867407 | 2101496.8738153 | 37.7504661097568 | -122.433296668218 | (37.7504661097568, -122.433296668218) | ||
| 124833 | 124833 | 33056 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | |||
| 77489 | 77489 | 33057 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | |||
| 128904 | 128904 | 33058 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | Permit Number 779143 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | ||
| 182568 | 182568 | 33177 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3245 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | 3.5x5 | Permit Number 37389 | 5985988.52360796 | 2098193.06286983 | 37.740429143118206 | -122.491041921171 | (37.7404291431182, -122.491041921171) |
| 92257 | 92257 | 33453 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37554 | 6006165.48085512 | 2098035.43238588 | 37.7411545114342 | -122.421266615711 | (37.7411545114342, -122.421266615711) | |||
| 128723 | 128723 | 33551 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 242 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37659 | 6007042.9412775 | 2097614.40669633 | 37.740047898701604 | -122.418202822848 | (37.7400478987016, -122.418202822848) | |||
| 25175 | 25175 | 34531 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 635 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38240 | 5988437.8449 | 2111647.649 | 37.7775145896121 | -122.483559386935 | (37.7775145896121, -122.483559386935) | ||
| 126722 | 126722 | 34910 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 234 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1997 12:00:00 AM | Permit Number 38511 | 5994034.02525385 | 2087990.46611796 | 37.712882070912 | -122.462484089909 | (37.712882070912, -122.462484089909) | |||
| 146231 | 146231 | 34936 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 11 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1997 12:00:00 AM | Permit Number 38531 | 6004292.24994663 | 2098281.86304207 | 37.741725367299104 | -122.427761131369 | (37.7417253672991, -122.427761131369) | |||
| 93817 | 93817 | 35102 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 778 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767512 | 6001912.66160072 | 2089308.81779253 | 37.716952534231794 | -122.435347237927 | (37.7169525342318, -122.435347237927) | |
| 50125 | 50125 | 35432 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1506 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | 7 | Permit Number 38878 | 6014141.4984800005 | 2102013.02263 | 37.7525225775725 | -122.39396657421499 | (37.7525225775725, -122.393966574215) | |
| 10944 | 10944 | 35742 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 14122 | 14122 | 35743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 136514 | 136514 | 35869 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.40561798198799 | (37.7381266097475, -122.405617981988) | |
| 137431 | 137431 | 35870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 3 | Permit Number 39080 | 6010672.98165 | 2096855.55492 | 37.738167912917106 | -122.405598135739 | (37.7381679129171, -122.405598135739) | |
| 120373 | 120373 | 35894 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 225 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | ||
| 124738 | 124738 | 37419 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39897 | 6002931.14322816 | 2099749.14332352 | 37.7456770883652 | -122.432572163971 | (37.7456770883652, -122.432572163971) | ||
| 157585 | 157585 | 37646 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992418.62314 | 2111328.39102 | 37.7768688906569 | -122.46976542425399 | (37.7768688906569, -122.469765424254) | ||
| 73555 | 73555 | 37647 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | ||
| 54318 | 54318 | 37648 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992433.05565 | 2111328.08721 | 37.776868890669206 | -122.46971547615499 | (37.7768688906692, -122.469715476155) | ||
| 47422 | 47422 | 37962 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.394309999 | 2106347.66255 | 37.7644148813545 | -122.39487221400299 | (37.7644148813545, -122.394872214003) | |
| 92893 | 92893 | 37976 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 125240 | 125240 | 37977 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 143906 | 143906 | 37978 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 101438 | 101438 | 37979 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 107439 | 107439 | 37980 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 141016 | 141016 | 37981 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 99110 | 99110 | 38000 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2454 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40212 | 5992064.31245936 | 2098735.51233127 | 37.742271675931896 | -122.47007391125601 | (37.7422716759319, -122.470073911256) | ||
| 80857 | 80857 | 38028 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | |||
| 128574 | 128574 | 38029 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | ||
| 102562 | 102562 | 38030 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 108435 | 108435 | 38031 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 99254 | 99254 | 38032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 114634 | 114634 | 38033 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | ||
| 99913 | 99913 | 38034 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 71 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40237 | 5993126.63617522 | 2098605.576855 | 37.7419762612493 | -122.466391311334 | (37.7419762612493, -122.466391311334) | ||
| 100543 | 100543 | 38059 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 107754 | 107754 | 38060 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 87400 | 87400 | 38061 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 96296 | 96296 | 38062 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 11876 | 11876 | 38200 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 514 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45184 | 6010449.69037 | 2092207.2371 | 37.7253921259422 | -122.406042793857 | (37.7253921259422, -122.406042793857) |
| 140049 | 140049 | 38215 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | ||
| 98066 | 98066 | 38216 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | ||
| 83910 | 83910 | 38217 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | ||
| 124237 | 124237 | 38635 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 33 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | |
| 119285 | 119285 | 38636 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | |
| 90176 | 90176 | 38637 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2010 12:00:00 AM | 3x3 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | |
| 141716 | 141716 | 38638 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | ||
| 140727 | 140727 | 38639 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | ||
| 112909 | 112909 | 38640 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | ||
| 82592 | 82592 | 38845 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1333 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40675 | 5989863.06342131 | 2106288.82741716 | 37.76288358166779 | -122.47823721882601 | (37.7628835816678, -122.478237218826) | ||
| 66650 | 66650 | 38870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1551 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 2 | Permit Number 43029 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.47860439661501 | (37.7615577752966, -122.478604396615) | |
| 159224 | 159224 | 38871 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1551 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1998 12:00:00 AM | 2 | Permit Number 40696 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.47860439661501 | (37.7615577752966, -122.478604396615) | ||
| 101850 | 101850 | 38881 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 54142 | 54142 | 38882 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 83881 | 83881 | 38883 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 77080 | 77080 | 38895 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 123 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40710 | 5996840.66245358 | 2113625.05698332 | 37.7834295330259 | -122.454634297306 | (37.7834295330259, -122.454634297306) | |
| 111478 | 111478 | 39381 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2001 12:00:00 AM | Permit Number 43822 | 6007199.57850018 | 2107537.80288531 | 37.7673040926749 | -122.418364663242 | (37.7673040926749, -122.418364663242) | ||
| 159694 | 159694 | 39695 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1583 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | 7 | Permit Number 41080 | 6014997.8516 | 2094075.2851 | 37.730774746396 | -122.390450554434 | (37.730774746396, -122.390450554434) | |
| 80145 | 80145 | 39731 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3472 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41103 | 6003734.27078033 | 2106581.04610194 | 37.7644813903829 | -122.430282399811 | (37.7644813903829, -122.430282399811) | ||
| 167372 | 167372 | 40008 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 950 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41261 | 6018990.20826 | 2094681.6711099998 | 37.7326604269313 | -122.376690235261 | (37.7326604269313, -122.376690235261) | |
| 96051 | 96051 | 40031 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1656 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41273 | 6014957.20136248 | 2095924.63791994 | 37.7358504391775 | -122.390720277971 | (37.7358504391775, -122.390720277971) | ||
| 86331 | 86331 | 40032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1660 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41274 | 6014934.45622927 | 2095941.56583888 | 37.7358956578297 | -122.390800100159 | (37.7358956578297, -122.390800100159) | ||
| 64837 | 64837 | 40044 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1322 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 1 | Permit Number 41281 | 6016731.9607 | 2093562.0843 | 37.729461643225704 | -122.384419676567 | (37.7294616432257, -122.384419676567) | |
| 102334 | 102334 | 40175 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1779 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1999 12:00:00 AM | Permit Number 41366 | 6008032.61088554 | 2108096.47604813 | 37.7688849366199 | -122.415522872015 | (37.7688849366199, -122.415522872015) | ||
| 75380 | 75380 | 40197 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.50048820674401 | (37.7773644306872, -122.500488206744) | |
| 156274 | 156274 | 40198 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 4 | Permit Number 41381 | 5983564.00887 | 2111698.1064299997 | 37.7773682442298 | -122.500423071675 | (37.7773682442298, -122.500423071675) | |
| 119499 | 119499 | 40199 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) |
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");