Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92988 | 92988 | 87254 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 32 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50278 | 6007985.7 | 2086740.5 | 37.710243492017895 | -122.414174016703 | (37.7102434920179, -122.414174016703) | |||
| 93830 | 93830 | 63116 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 115 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23622 | 6006844.85682717 | 2098899.69149034 | 37.7435658517454 | -122.41897885676701 | (37.7435658517454, -122.418978856767) | ||
| 96191 | 96191 | 22896 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 201 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 2X2 | 6006117.697509999 | 2108447.0783700002 | 37.7697397858216 | -122.422171347799 | (37.7697397858216, -122.422171347799) | |||
| 97514 | 97514 | 56845 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 4x4 | Permit Number 14078 | 5998833.42862215 | 2106621.08669964 | 37.7643125198309 | -122.447235885769 | (37.7643125198309, -122.447235885769) | ||
| 98251 | 98251 | 16517 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
| 98613 | 98613 | 106036 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||
| 99294 | 99294 | 52077 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2959 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2005 12:00:00 AM | Permit Number 48273 | 6009147.75263717 | 2102727.30105861 | 37.7542050255745 | -122.41128631630698 | (37.7542050255745, -122.411286316307) | ||
| 99462 | 99462 | 60684 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2969 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20325 | 6009095.19054271 | 2102724.34950865 | 37.7541939732112 | -122.411467881257 | (37.7541939732112, -122.411467881257) | ||
| 99856 | 99856 | 16553 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
| 99990 | 99990 | 47241 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1000X Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6014093.2543097995 | 2089771.82198012 | 37.718908077116 | -122.393276886105 | (37.718908077116, -122.393276886105) |
| 100270 | 100270 | 54886 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 3x4 | Permit Number 10751 | 5997750.13061777 | 2107162.33224107 | 37.7657366841835 | -122.45102172287201 | (37.7657366841835, -122.451021722872) | ||
| 100880 | 100880 | 50384 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 101303 | 101303 | 59009 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1980 12:00:00 AM | 15 | 4x4 | Permit Number 18300 | 6005405.85335043 | 2104274.1193378996 | 37.758241653827 | -122.42433675552401 | (37.758241653827, -122.424336755524) | |
| 101649 | 101649 | 62273 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22409 | 6004226.44756002 | 2109195.3304156 | 37.7716874486567 | -122.42876647673701 | (37.7716874486567, -122.428766476737) | ||
| 101713 | 101713 | 58721 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1981 12:00:00 AM | Permit Number 19065 | 6002629.53182761 | 2108749.25499909 | 37.770372124834296 | -122.434258404788 | (37.7703721248343, -122.434258404788) | |||
| 102431 | 102431 | 62270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 102 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22404 | 6004290.78316217 | 2109110.18870614 | 37.7714573112605 | -122.42853786594999 | (37.7714573112605, -122.42853786595) | ||
| 102536 | 102536 | 4922 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
| 103487 | 103487 | 50383 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 104167 | 104167 | 50385 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 104509 | 104509 | 60288 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2932 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1982 12:00:00 AM | Permit Number 19852 | 6009284.44431761 | 2102786.94037008 | 37.754376447104995 | -122.410817812439 | (37.754376447105, -122.410817812439) | ||
| 105012 | 105012 | 62272 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 113 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22406 | 6004233.40404883 | 2109145.28748516 | 37.7715504366717 | -122.428738845772 | (37.7715504366717, -122.428738845772) | ||
| 105799 | 105799 | 51546 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2005 12:00:00 AM | Permit Number 47845 | 6007074.31830792 | 2121880.33708987 | 37.806678119982706 | -122.419815746942 | (37.8066781199827, -122.419815746942) | |||
| 105923 | 105923 | 59722 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2905 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/14/1984 12:00:00 AM | Permit Number 19154 | 6008831.83417105 | 2103879.56302809 | 37.757351153159 | -122.41246028798 | (37.757351153159, -122.41246028798) | ||
| 105938 | 105938 | 51301 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 101 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 47670 | 6008105.70875607 | 2112751.56982087 | 37.7816708281319 | -122.41559966360799 | (37.7816708281319, -122.415599663608) | ||
| 106049 | 106049 | 59362 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/1980 12:00:00 AM | Permit Number 18713 | 6001270.92113106 | 2096540.31776103 | 37.736772117155496 | -122.43808313790001 | (37.7367721171555, -122.4380831379) | |||
| 106363 | 106363 | 82092 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
| 106473 | 106473 | 60259 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28050 | 6009367.15001104 | 2103917.51160129 | 37.757485378294895 | -122.41061162692301 | (37.7574853782949, -122.410611626923) | ||
| 107534 | 107534 | 63118 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23625 | 6006935.01451866 | 2099174.11524824 | 37.7443244342333 | -122.418686569992 | (37.7443244342333, -122.418686569992) | ||
| 109880 | 109880 | 50388 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 110128 | 110128 | 17403 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1775 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 6013944.430980001 | 2095916.733 | 37.7357724918668 | -122.39422129757901 | (37.7357724918668, -122.394221297579) | |||
| 110320 | 110320 | 60260 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2844 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19815 | 6009158.9675903 | 2103949.64001782 | 37.757561921733 | -122.41133387759399 | (37.757561921733, -122.411333877594) | ||
| 110377 | 110377 | 16641 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 161 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002897.949322799 | 2107328.6416625 | 37.7664866995789 | -122.433228426337 | (37.7664866995789, -122.433228426337) | |||
| 110724 | 110724 | 101044 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
| 111336 | 111336 | 106033 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||||
| 111792 | 111792 | 82143 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
| 112036 | 112036 | 101042 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
| 112042 | 112042 | 6647 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1990 12:00:00 AM | 3 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
| 112235 | 112235 | 60690 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2773 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20333 | 6009572.74299755 | 2103336.33183864 | 37.7559011138434 | -122.409859576548 | (37.7559011138434, -122.409859576548) | ||
| 112758 | 112758 | 21782 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2550 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x5 | 6008458.6 | 2121488.8 | 37.8056809434427 | -122.414997429015 | (37.8056809434427, -122.414997429015) | |||
| 113571 | 113571 | 22889 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 95X Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006042.93395 | 2109155.55847 | 37.771680885423606 | -122.422480302267 | (37.7716808854236, -122.422480302267) | |||
| 113730 | 113730 | 4923 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
| 113829 | 113829 | 82141 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
| 114124 | 114124 | 87253 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50277 | 6008031.4 | 2086860.8 | 37.7105763778259 | -122.414024572568 | (37.7105763778259, -122.414024572568) | |||
| 115300 | 115300 | 85051 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 355x Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | |||
| 115904 | 115904 | 21786 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6008350.54359 | 2121501.89618 | 37.805710829631295 | -122.41537230277201 | (37.8057108296313, -122.415372302772) | |||
| 116284 | 116284 | 2744 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5995591.7347 | 2110770.58853 | 37.775520208006604 | -122.458748349075 | (37.7755202080066, -122.458748349075) | |||
| 117344 | 117344 | 57469 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 71 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1987 12:00:00 AM | Permit Number 24965 | 5992451.26080169 | 2092911.00734917 | 37.7263014049972 | -122.46831233823299 | (37.7263014049972, -122.468312338233) | ||
| 117465 | 117465 | 51304 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767250 | 6001037.11613846 | 2102279.06351254 | 37.752516053262795 | -122.439302719451 | (37.7525160532628, -122.439302719451) | |
| 117686 | 117686 | 47317 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2524 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | |||
| 118697 | 118697 | 60271 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2761 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1982 12:00:00 AM | 12 | 3x3 | Permit Number 19827 | 6009603.81924648 | 2103922.02713572 | 37.7575110429284 | -122.409793445145 | (37.7575110429284, -122.409793445145) |
| 120131 | 120131 | 60694 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2770 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20337 | 6009580.52702931 | 2103388.84293588 | 37.7560457337564 | -122.409836363248 | (37.7560457337564, -122.409836363248) | ||
| 120218 | 120218 | 51670 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47948 | 5998713.82301338 | 2107188.47532501 | 37.765863591183 | -122.44769041413299 | (37.765863591183, -122.447690414133) | ||||
| 120646 | 120646 | 63121 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23632 | 6007120.53987433 | 2099276.08223849 | 37.7446148564174 | -122.418052288309 | (37.7446148564174, -122.418052288309) | ||
| 120916 | 120916 | 101045 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
| 121368 | 121368 | 101043 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
| 121655 | 121655 | 16548 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016043.45751 | 2097947.5572599997 | 37.7414651721818 | -122.387105680372 | (37.7414651721818, -122.387105680372) | |||
| 121827 | 121827 | 60691 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2767 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20334 | 6009604.72609902 | 2103338.10407704 | 37.7559077723841 | -122.409749093146 | (37.7559077723841, -122.409749093146) | ||
| 122387 | 122387 | 65950 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28971 | 6008148.07854497 | 2112823.994523 | 37.7818720705068 | -122.415458212735 | (37.7818720705068, -122.415458212735) | ||
| 122964 | 122964 | 47238 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1200X Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45189 | 6014641.0147 | 2090577.1277 | 37.7211497042731 | -122.39143974641 | (37.7211497042731, -122.39143974641) |
| 123421 | 123421 | 93111 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.742655406712295 | -122.38526477996099 | (37.7426554067123, -122.385264779961) | |
| 123961 | 123961 | 57556 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23627 | 6007019.50965831 | 2099220.3784742 | 37.7444562195491 | -122.418397682663 | (37.7444562195491, -122.418397682663) | ||
| 124297 | 124297 | 59670 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 98X PARNASSUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32228 | 5998297.0 | 2106864.0 | 37.76494883262271 | -122.449108733904 | (37.7649488326227, -122.449108733904) |
| 124374 | 124374 | 37053 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 231 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2015 12:00:00 AM | 3 | 6x9 | Permit Number 775674 | 6005030.06979159 | 2099868.96006137 | 37.7461248828886 | -122.425322907066 | (37.7461248828886, -122.425322907066) |
| 124706 | 124706 | 63223 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 74 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1986 12:00:00 AM | Permit Number 23767 | 6007024.24525419 | 2099097.21630379 | 37.7441183104389 | -122.418372576893 | (37.7441183104389, -122.418372576893) | ||
| 125283 | 125283 | 35826 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 658 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47147 | 6002331.25520589 | 2089974.9119099 | 37.718805244392904 | -122.433947949751 | (37.7188052443929, -122.433947949751) | ||
| 126122 | 126122 | 20125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 924X Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002999.41967 | 2110319.2516799998 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | |||
| 126974 | 126974 | 49779 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 241@ BLANKEN Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46565 | 6012711.25696991 | 2087289.78103258 | 37.7120160109599 | -122.39787992529499 | (37.7120160109599, -122.397879925295) | ||
| 127474 | 127474 | 63232 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | Permit Number 23779 | 6007031.32644483 | 2099242.02691528 | 37.7445163265111 | -122.418358357204 | (37.7445163265111, -122.418358357204) | ||
| 127575 | 127575 | 47316 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2524 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | ||
| 127787 | 127787 | 58566 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 119 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1979 12:00:00 AM | 3x3 | Permit Number 17756 | 5997901.33257876 | 2107130.89979942 | 37.7656590338964 | -122.450496484092 | (37.7656590338964, -122.450496484092) | ||
| 127903 | 127903 | 102874 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2761 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009574.6 | 2103896.5 | 37.757439313651396 | -122.409892695521 | (37.7574393136514, -122.409892695521) | ||||
| 127952 | 127952 | 82121 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.44659355011801 | (37.7365973852663, -122.446593550118) | ||
| 128506 | 128506 | 60264 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19820 | 6009362.55423892 | 2103960.83669592 | 37.7576040815568 | -122.410630580485 | (37.7576040815568, -122.410630580485) | ||
| 128870 | 128870 | 6849 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | |||
| 129421 | 129421 | 47061 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 114 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 3x3 | Permit Number 45048 | 6004275.94265243 | 2109216.94695979 | 37.7717496035942 | -122.428596811267 | (37.7717496035942, -122.428596811267) | |
| 131650 | 131650 | 32421 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36948 | 6000917.26502 | 2096711.2312599998 | 37.7372212865363 | -122.439318125938 | (37.7372212865363, -122.439318125938) | ||
| 137523 | 137523 | 65609 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 259 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 12 | Permit Number 28514 | 6005079.93888 | 2093817.0268700002 | 37.7295104552453 | -122.42472001303801 | (37.7295104552453, -122.424720013038) | |
| 138411 | 138411 | 63122 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1993 12:00:00 AM | Permit Number 32290 | 6007020.23858667 | 2099330.24637666 | 37.7447579331798 | -122.41840295087499 | (37.7447579331798, -122.418402950875) | ||
| 138752 | 138752 | 48532 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
| 140440 | 140440 | 34010 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 123 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1997 12:00:00 AM | Permit Number 37945 | 6002886.66979468 | 2107551.69377695 | 37.7670985064042 | -122.43328338001899 | (37.7670985064042, -122.433283380019) | |||
| 140595 | 140595 | 61796 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 60 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/1985 12:00:00 AM | Permit Number 21819 | 6002883.06164476 | 2108748.24537279 | 37.7703837393735 | -122.43338137366399 | (37.7703837393735, -122.433381373664) | ||
| 140677 | 140677 | 56842 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 910 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | 3 | Permit Number 30536 | 5998759.08975741 | 2106864.1829233 | 37.76497575295679 | -122.447510501506 | (37.7649757529568, -122.447510501506) | |
| 141444 | 141444 | 4914 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
| 141489 | 141489 | 96123 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767774 | 6004920.8 | 2095965.5 | 37.735400693790204 | -122.42542300740601 | (37.7354006937902, -122.425423007406) | |
| 142139 | 142139 | 33711 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37779 | 6003691.57039211 | 2108804.29883955 | 37.7705834843276 | -122.430588742236 | (37.7705834843276, -122.430588742236) | |||
| 142476 | 142476 | 68375 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 175 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32198 | 5997884.42699251 | 2106160.35589629 | 37.76299319850379 | -122.45048498278999 | (37.7629931985038, -122.45048498279) | ||
| 143717 | 143717 | 63120 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 46 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23631 | 6007008.06371762 | 2099307.94192573 | 37.7446960047915 | -122.418443468102 | (37.7446960047915, -122.418443468102) | ||
| 144535 | 144535 | 63125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 80 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23639 | 6007006.19001516 | 2099063.67894521 | 37.744025207978 | -122.418432630519 | (37.744025207978, -122.418432630519) | ||
| 145409 | 145409 | 60263 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19819 | 6009497.44754454 | 2103916.17692673 | 37.757489017835496 | -122.410160909746 | (37.7574890178355, -122.410160909746) | ||
| 145698 | 145698 | 106032 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||||
| 145872 | 145872 | 63270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23827 | 6007494.42657363 | 2099465.13084364 | 37.7451549781049 | -122.41677284932 | (37.7451549781049, -122.41677284932) | ||
| 146013 | 146013 | 16552 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
| 150575 | 150575 | 56925 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 12 | Permit Number 14168 | 6014784.53223 | 2116103.90747 | 37.7912487383869 | -122.392728500917 | (37.7912487383869, -122.392728500917) | ||
| 151813 | 151813 | 51298 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 7 | Permit Number 47670 | 6008009.38054 | 2112753.19289 | 37.7816698695126 | -122.415933029587 | (37.7816698695126, -122.415933029587) | |
| 153716 | 153716 | 93113 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016543.92232 | 2098378.4931799998 | 37.7426761351889 | -122.385405252254 | (37.7426761351889, -122.385405252254) | |
| 154115 | 154115 | 32473 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 144 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 9 | Permit Number 36981 | 6000263.910540001 | 2106227.11632 | 37.763312407875205 | -122.442259981907 | (37.7633124078752, -122.442259981907) | |
| 154265 | 154265 | 119738 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6013480.63892 | 2116044.41356 | 37.7910128776808 | -122.397235794198 | (37.7910128776808, -122.397235794198) | ||||
| 154271 | 154271 | 93112 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53024 | 6016561.73954 | 2098375.23066 | 37.7426681627043 | -122.38534341756599 | (37.7426681627043, -122.385343417566) | |
| 155166 | 155166 | 40183 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 298X Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1999 12:00:00 AM | 11 | Permit Number 41371 | 6013446.24914 | 2105734.66956 | 37.7627027466551 | -122.39663174926001 | (37.7627027466551, -122.39663174926) | ||
| 157632 | 157632 | 119739 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6013469.82728 | 2116055.87494 | 37.7910437460335 | -122.397274006392 | (37.7910437460335, -122.397274006392) |
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");