Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11938 | 11938 | 19762 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 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) | |||
| 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) | |||
| 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) | ||
| 16011 | 16011 | 47239 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1004X Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013984.3411 | 2089670.3406 | 37.718623377888896 | -122.393646260173 | (37.7186233778889, -122.393646260173) |
| 72741 | 72741 | 175840 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 658 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002330.91523 | 2089965.9471 | 37.7187806097236 | -122.433948484453 | (37.7187806097236, -122.433948484453) | |||
| 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) | ||
| 25981 | 25981 | 47237 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1200X Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45189 | 6014656.8506 | 2090563.7281 | 37.721113790544 | -122.391384069594 | (37.721113790544, -122.391384069594) |
| 82379 | 82379 | 65221 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 411 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 28008 | 6002203.13463286 | 2091195.37244375 | 37.722149084859296 | -122.43447802603701 | (37.7221490848593, -122.434478026037) | ||
| 32238 | 32238 | 175841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 407 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002201.57312 | 2091201.22242 | 37.7221650589433 | -122.434483841864 | (37.7221650589433, -122.434483841864) | |||
| 53040 | 53040 | 56853 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 245 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1974 12:00:00 AM | 10 | Permit Number 14088 | 6004257.880580001 | 2091960.10063 | 37.724365284516395 | -122.427429718013 | (37.7243652845164, -122.427429718013) | ||
| 26761 | 26761 | 175842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 234 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004274.97667 | 2092050.6197400002 | 37.724614796925 | -122.427377064513 | (37.724614796925, -122.427377064513) | |||
| 176670 | 176670 | 175843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 154 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004555.98826 | 2092507.33419 | 37.7258847232758 | -122.42643814711501 | (37.7258847232758, -122.426438147115) | |||
| 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) | ||
| 174686 | 174686 | 199696 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | |||
| 68963 | 68963 | 199693 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016099.1110000005 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | |||
| 62337 | 62337 | 199691 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1343 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016071.0177 | 2092930.0859 | 37.7276897308085 | -122.38666058841001 | (37.7276897308085, -122.38666058841) | |||
| 73260 | 73260 | 205990 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993405.09676 | 2093676.5167599998 | 37.7284583518695 | -122.46507057606001 | (37.7284583518695, -122.46507057606) | |||
| 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) | |
| 67325 | 67325 | 206015 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.45639483786199 | (37.7296789783055, -122.456394837862) | |||
| 81866 | 81866 | 61684 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 49 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | Permit Number 21681 | 6013901.59422939 | 2093898.15648128 | 37.7302275129585 | -122.394228121663 | (37.7302275129585, -122.394228121663) | ||
| 166502 | 166502 | 61685 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 34 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 11 | Permit Number 21682 | 6013864.09066 | 2093969.56082 | 37.730421490047604 | -122.39436277503201 | (37.7304214900476, -122.394362775032) | |
| 31183 | 31183 | 61726 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 28 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 9 | Permit Number 21728 | 6013869.02725 | 2093995.2493599998 | 37.7304922999628 | -122.39434750633998 | (37.7304922999628, -122.39434750634) | |
| 158717 | 158717 | 61724 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.39430169937599 | (37.7307052783181, -122.394301699376) | |
| 119228 | 119228 | 94892 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 54347 | 54347 | 206013 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992845.13508 | 2095810.8192900002 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | |||
| 132092 | 132092 | 206014 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | |||
| 164903 | 164903 | 201371 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Hare St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6018297.03999 | 2095334.9344400002 | 37.7344159629251 | -122.379132069983 | (37.7344159629251, -122.379132069983) | ||||
| 42068 | 42068 | 205999 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001682.52176 | 2095686.8275900001 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | |||
| 143125 | 143125 | 201373 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018334.732369999 | 2095383.1099099999 | 37.7345503216464 | -122.379005098324 | (37.7345503216464, -122.379005098324) | ||||
| 16103 | 16103 | 17387 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1657 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6014551.02447 | 2095461.0111900002 | 37.7345548713079 | -122.39209219010901 | (37.7345548713079, -122.392092190109) | |||
| 59009 | 59009 | 206021 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | |||
| 154109 | 154109 | 225081 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004907.37106 | 2095955.144 | 37.7353714997996 | -122.42546869953199 | (37.7353714997996, -122.425468699532) | |||
| 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) | |
| 13474 | 13474 | 17398 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1734X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014174.38954 | 2095813.0161 | 37.7355004859498 | -122.393418978825 | (37.7355004859498, -122.393418978825) | |||
| 15376 | 15376 | 17400 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1740 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014126.91093 | 2095851.1855799998 | 37.735602653440296 | -122.393585802156 | (37.7356026534403, -122.393585802156) | |||
| 32351 | 32351 | 189916 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1771 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6013954.80906 | 2095907.8137599998 | 37.7357485783226 | -122.394184791988 | (37.7357485783226, -122.394184791988) | |||
| 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) | |||
| 67512 | 67512 | 225043 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 463 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008911.67409 | 2096164.66425 | 37.7361722309519 | -122.411639081583 | (37.7361722309519, -122.411639081583) | |||
| 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) | ||
| 157892 | 157892 | 205995 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998862.6525 | 2096533.61775 | 37.7366164654663 | -122.446409060855 | (37.7366164654663, -122.446409060855) | |||
| 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) | ||
| 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) | |||
| 16340 | 16340 | 17417 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1836 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013526.86611 | 2096296.9772700001 | 37.7367933450374 | -122.39569162676099 | (37.7367933450374, -122.395691626761) | |||
| 14666 | 14666 | 17420 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1844 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013467.77602 | 2096339.40457 | 37.736906554399496 | -122.395898900707 | (37.7369065543995, -122.395898900707) | |||
| 32281 | 32281 | 225053 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.736911510559295 | -122.438267032523 | (37.7369115105593, -122.438267032523) | |||
| 14926 | 14926 | 17432 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1899 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013304.38665 | 2096386.76437 | 37.7370275033033 | -122.39646713286899 | (37.7370275033033, -122.396467132869) | |||
| 85449 | 85449 | 41699 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2 Mizpah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42149 | 6001021.55719924 | 2096664.38095079 | 37.737098580964606 | -122.438954184383 | (37.7370985809646, -122.438954184383) | ||
| 154480 | 154480 | 225052 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 375 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000953.83658 | 2096674.2134099999 | 37.737121725291296 | -122.439189029173 | (37.7371217252913, -122.439189029173) | |||
| 184149 | 184149 | 225054 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 342 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6001139.36381 | 2096693.2959599998 | 37.7371846769336 | -122.438548945674 | (37.7371846769336, -122.438548945674) | |||
| 178420 | 178420 | 225055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | |||
| 65489 | 65489 | 225056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901044995 | -122.43874836315399 | (37.737188901045, -122.438748363154) | |||
| 37675 | 37675 | 225057 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | |||
| 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) | ||
| 15046 | 15046 | 17433 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1900 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6013265.7394 | 2096489.52235 | 37.7373075045406 | -122.396607955902 | (37.7373075045406, -122.396607955902) | |||
| 15961 | 15961 | 17437 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1919 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6013108.75457 | 2096537.612 | 37.7374308105776 | -122.397154099803 | (37.7374308105776, -122.397154099803) | |||
| 13524 | 13524 | 17444 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1950 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6013023.363469999 | 2096670.73663 | 37.737791588910206 | -122.397458672302 | (37.7377915889102, -122.397458672302) | |||
| 13413 | 13413 | 17446 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6012949.4647699995 | 2096727.20845 | 37.737942533829106 | -122.397718137505 | (37.7379425338291, -122.397718137505) | |||
| 15967 | 15967 | 17458 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1999 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 6012778.88075 | 2096779.8432200002 | 37.7380775571329 | -122.398311626199 | (37.7380775571329, -122.398311626199) | |||
| 14401 | 14401 | 17464 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2043 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6012526.80505 | 2096970.93797 | 37.738588218270294 | -122.39919659325301 | (37.7385882182703, -122.399196593253) | |||
| 164290 | 164290 | 206009 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990946.443519999 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | |||
| 157059 | 157059 | 206005 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553001 | (37.7394900683054, -122.47345704553) | |||
| 75887 | 75887 | 225065 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006960.17815 | 2097772.4528099997 | 37.740477199257704 | -122.418500188445 | (37.7404771992577, -122.418500188445) | |||
| 102430 | 102430 | 96852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1x Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007194.0 | 2097789.0 | 37.7405357947447 | -122.417692894396 | (37.7405357947447, -122.417692894396) | |||
| 46617 | 46617 | 189864 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015974.53489 | 2097767.4819400003 | 37.7409669053009 | -122.387331434622 | (37.7409669053009, -122.387331434622) | |||
| 23044 | 23044 | 16540 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 0 | 6016126.25571 | 2098060.8881 | 37.741780940152296 | -122.386827291768 | (37.7417809401523, -122.386827291768) | |||
| 9911 | 9911 | 173732 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015419.0 | 2098106.0 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | ||||
| 179431 | 179431 | 189853 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.742069463331106 | -122.382594511142 | (37.7420694633311, -122.382594511142) | |||
| 16483 | 16483 | 16521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016284.3157 | 2098184.69928 | 37.742129650455205 | -122.38628939735099 | (37.7421296504552, -122.386289397351) | |||
| 132013 | 132013 | 189839 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.38356026519699 | (37.7422631836031, -122.383560265197) | |||
| 85510 | 85510 | 4912 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 138765 | 138765 | 16490 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016659.29203 | 2098304.79019 | 37.7424801439961 | -122.385001199414 | (37.7424801439961, -122.385001199414) | |||
| 132365 | 132365 | 189887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016910.34518 | 2098303.24769 | 37.742489792067104 | -122.384133016442 | (37.7424897920671, -122.384133016442) | |||
| 125499 | 125499 | 16479 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 16852 | 16852 | 16499 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016428.13466 | 2098327.93774 | 37.7425309135822 | -122.385802093385 | (37.7425309135822, -122.385802093385) | |||
| 33365 | 33365 | 93109 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.354169999 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | |
| 122698 | 122698 | 16510 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
| 165480 | 165480 | 189901 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6016452.46192 | 2098385.2163400003 | 37.742689535099395 | -122.385721967406 | (37.7426895350994, -122.385721967406) | |||
| 118268 | 118268 | 14924 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
| 60186 | 60186 | 248270 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | |||
| 68659 | 68659 | 248263 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.743141812234505 | -122.41940912783899 | (37.7431418122345, -122.419409127839) | |||
| 61155 | 61155 | 111886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | |||
| 135232 | 135232 | 248274 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006747.61558 | 2098750.1570099997 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | |||
| 104259 | 104259 | 248261 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | |||
| 165360 | 165360 | 248260 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | |||
| 179238 | 179238 | 248257 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.41920489088899 | (37.7434438819296, -122.419204890889) | |||
| 156357 | 156357 | 248255 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | |||
| 33356 | 33356 | 248279 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | |||
| 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) | ||
| 176531 | 176531 | 248253 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006804.331590001 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | |||
| 144112 | 144112 | 113692 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6006814.0 | 2098928.0 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | |||
| 140142 | 140142 | 2505 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
| 65181 | 65181 | 248195 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006895.3062 | 2099022.5140400003 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | |||
| 53695 | 53695 | 188483 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016580.588769999 | 2098830.3730200003 | 37.7439189335051 | -122.38530995020399 | (37.7439189335051, -122.385309950204) | |||
| 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) | ||
| 152658 | 152658 | 248198 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006917.65895 | 2099068.8782900004 | 37.744034500003295 | -122.418739120308 | (37.7440345000033, -122.418739120308) | |||
| 86972 | 86972 | 58315 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23623 | 6006886.31504247 | 2099084.89744452 | 37.744076720184495 | -122.41884863660299 | (37.7440767201845, -122.418848636603) | ||
| 82535 | 82535 | 63222 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 76 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1987 12:00:00 AM | Permit Number 23766 | 6007018.22684623 | 2099086.03719365 | 37.7440872763149 | -122.41839259476801 | (37.7440872763149, -122.418392594768) | ||
| 181222 | 181222 | 248199 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698121999 | (37.7440974516285, -122.41868698122) | |||
| 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) |
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");