trees
336 rows where SiteOrder = 1 and qSpecies_id = 5 sorted by Latitude
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13041 | 19762 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
| 94151 | 87254 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 32 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50278 | 6007985.7 | 2086740.5 | 37.7102434920179 | -122.414174016703 | (37.7102434920179, -122.414174016703) | 9 | 7 | 8 | 309 | 39 | |||
| 133859 | 87253 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50277 | 6008031.4 | 2086860.8 | 37.7105763778259 | -122.414024572568 | (37.7105763778259, -122.414024572568) | 9 | 7 | 8 | 309 | 39 | |||
| 20304 | 49779 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 241@ BLANKEN Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | Permit Number 46565 | 6012711.25696991 | 2087289.78103258 | 37.7120160109599 | -122.397879925295 | (37.7120160109599, -122.397879925295) | 10 | 3 | 8 | 309 | 1 | ||
| 138537 | 47239 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1004X Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013984.3411 | 2089670.3406 | 37.7186233778889 | -122.393646260173 | (37.7186233778889, -122.393646260173) | 10 | 3 | 8 | 58 | 1 |
| 154326 | 175840 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 658 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002330.91523 | 2089965.9471 | 37.7187806097236 | -122.433948484453 | (37.7187806097236, -122.433948484453) | 9 | 7 | 6 | 28861 | 5 | |||
| 35427 | 35826 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 658 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47147 | 6002331.25520589 | 2089974.9119099 | 37.7188052443929 | -122.433947949751 | (37.7188052443929, -122.433947949751) | 9 | 7 | 6 | 28861 | 5 | ||
| 107061 | 47237 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1200X Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45189 | 6014656.8506 | 2090563.7281 | 37.721113790544 | -122.391384069594 | (37.721113790544, -122.391384069594) | 10 | 3 | 8 | 58 | 1 |
| 43480 | 65221 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 411 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 28008 | 6002203.13463286 | 2091195.37244375 | 37.7221490848593 | -122.434478026037 | (37.7221490848593, -122.434478026037) | 9 | 7 | 6 | 28861 | 5 | ||
| 192846 | 175841 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 407 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002201.57312 | 2091201.22242 | 37.7221650589433 | -122.434483841864 | (37.7221650589433, -122.434483841864) | 9 | 7 | 6 | 28861 | 5 | |||
| 187600 | 56853 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 245 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/1974 12:00:00 AM | 10 | Permit Number 14088 | 6004257.88058 | 2091960.10063 | 37.7243652845164 | -122.427429718013 | (37.7243652845164, -122.427429718013) | 9 | 7 | 6 | 28861 | 5 | ||
| 41676 | 175842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 234 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004274.97667 | 2092050.61974 | 37.724614796925 | -122.427377064513 | (37.724614796925, -122.427377064513) | 9 | 7 | 6 | 28861 | 5 | |||
| 166205 | 175843 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 154 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004555.98826 | 2092507.33419 | 37.7258847232758 | -122.426438147115 | (37.7258847232758, -122.426438147115) | 9 | 7 | 6 | 28861 | 5 | |||
| 159417 | 57469 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 71 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1987 12:00:00 AM | Permit Number 24965 | 5992451.26080169 | 2092911.00734917 | 37.7263014049972 | -122.468312338233 | (37.7263014049972, -122.468312338233) | 9 | 8 | 4 | 59 | 40 | ||
| 66893 | 199696 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | 10 | 3 | 8 | 58 | 1 | |||
| 118594 | 199693 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016099.111 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | 10 | 3 | 8 | 58 | 1 | |||
| 42288 | 199691 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1343 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016071.0177 | 2092930.0859 | 37.7276897308085 | -122.38666058841 | (37.7276897308085, -122.38666058841) | 10 | 3 | 8 | 58 | 1 | |||
| 169891 | 205990 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993405.09676 | 2093676.51676 | 37.7284583518695 | -122.46507057606 | (37.7284583518695, -122.46507057606) | 9 | 8 | 4 | 59 | 40 | |||
| 119313 | 65609 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 259 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 12 | Permit Number 28514 | 6005079.93888 | 2093817.02687 | 37.7295104552453 | -122.424720013038 | (37.7295104552453, -122.424720013038) | 9 | 7 | 6 | 28861 | 5 | |
| 114437 | 206015 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.456394837862 | (37.7296789783055, -122.456394837862) | 9 | 7 | 4 | 28861 | 40 | |||
| 46212 | 61684 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 49 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21681 | 6013901.59422939 | 2093898.15648128 | 37.7302275129585 | -122.394228121663 | (37.7302275129585, -122.394228121663) | 10 | 3 | 8 | 58 | 1 | ||
| 4137 | 61685 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 34 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 11 | Permit Number 21682 | 6013864.09066 | 2093969.56082 | 37.7304214900476 | -122.394362775032 | (37.7304214900476, -122.394362775032) | 10 | 3 | 8 | 58 | 1 | |
| 14153 | 61726 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1984 12:00:00 AM | 9 | Permit Number 21728 | 6013869.02725 | 2093995.24936 | 37.7304922999628 | -122.39434750634 | (37.7304922999628, -122.39434750634) | 10 | 3 | 8 | 58 | 1 | |
| 18873 | 61724 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1984 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.394301699376 | (37.7307052783181, -122.394301699376) | 10 | 3 | 8 | 58 | 1 | |
| 167565 | 94892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
| 67228 | 206013 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992845.13508 | 2095810.81929 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | 9 | 8 | 4 | 59 | 40 | |||
| 24361 | 206014 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | 9 | 8 | 4 | 59 | 40 | |||
| 114865 | 201371 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Hare St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6018297.03999 | 2095334.93444 | 37.7344159629251 | -122.379132069983 | (37.7344159629251, -122.379132069983) | 10 | 3 | 8 | 58 | 1 | ||||
| 117653 | 205999 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001682.52176 | 2095686.82759 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | 2 | 7 | 5 | 63 | 7 | |||
| 140204 | 201373 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2 Hare St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018334.73237 | 2095383.10991 | 37.7345503216464 | -122.379005098324 | (37.7345503216464, -122.379005098324) | 10 | 3 | 8 | 58 | 1 | ||||
| 165394 | 17387 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1657 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6014551.02447 | 2095461.01119 | 37.7345548713079 | -122.392092190109 | (37.7345548713079, -122.392092190109) | 10 | 3 | 8 | 58 | 1 | |||
| 63208 | 206021 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | 9 | 7 | 4 | 59 | 40 | |||
| 135947 | 225081 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004907.37106 | 2095955.144 | 37.7353714997996 | -122.425468699532 | (37.7353714997996, -122.425468699532) | 2 | 7 | 5 | 28861 | 2 | |||
| 172971 | 96123 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767774 | 6004920.8 | 2095965.5 | 37.7354006937902 | -122.425423007406 | (37.7354006937902, -122.425423007406) | 2 | 7 | 5 | 28861 | 2 | |
| 63557 | 17398 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1734X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014174.38954 | 2095813.0161 | 37.7355004859498 | -122.393418978825 | (37.7355004859498, -122.393418978825) | 10 | 3 | 8 | 58 | 1 | |||
| 20031 | 17400 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1740 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014126.91093 | 2095851.18558 | 37.7356026534403 | -122.393585802156 | (37.7356026534403, -122.393585802156) | 10 | 3 | 8 | 58 | 1 | |||
| 129074 | 189916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1771 Palou Ave | 1 | : | Tree | Private 2 | 15 | Width 4ft | 6013954.80906 | 2095907.81376 | 37.7357485783226 | -122.394184791988 | (37.7357485783226, -122.394184791988) | 10 | 3 | 8 | 58 | 1 | |||
| 118720 | 17403 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1775 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 6013944.43098 | 2095916.733 | 37.7357724918668 | -122.394221297579 | (37.7357724918668, -122.394221297579) | 10 | 3 | 8 | 58 | 1 | |||
| 181416 | 225043 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 463 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008911.67409 | 2096164.66425 | 37.7361722309519 | -122.411639081583 | (37.7361722309519, -122.411639081583) | 10 | 7 | 7 | 28859 | 2 | |||
| 37929 | 82121 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.446593550118 | (37.7365973852663, -122.446593550118) | 9 | 7 | 4 | 59 | 40 | ||
| 152645 | 205995 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998862.6525 | 2096533.61775 | 37.7366164654663 | -122.446409060855 | (37.7366164654663, -122.446409060855) | 9 | 7 | 4 | 59 | 40 | |||
| 150580 | 82143 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
| 131544 | 59362 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/1980 12:00:00 AM | Permit Number 18713 | 6001270.92113106 | 2096540.31776103 | 37.7367721171555 | -122.4380831379 | (37.7367721171555, -122.4380831379) | 2 | 7 | 5 | 63 | 7 | |||
| 80491 | 17417 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1836 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013526.86611 | 2096296.97727 | 37.7367933450374 | -122.395691626761 | (37.7367933450374, -122.395691626761) | 10 | 3 | 8 | 58 | 1 | |||
| 32220 | 17420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1844 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013467.77602 | 2096339.40457 | 37.7369065543995 | -122.395898900707 | (37.7369065543995, -122.395898900707) | 10 | 3 | 8 | 58 | 1 | |||
| 51291 | 225053 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.7369115105593 | -122.438267032523 | (37.7369115105593, -122.438267032523) | 2 | 7 | 5 | 63 | 7 | |||
| 93841 | 17432 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1899 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013304.38665 | 2096386.76437 | 37.7370275033033 | -122.396467132869 | (37.7370275033033, -122.396467132869) | 10 | 3 | 8 | 58 | 1 | |||
| 67810 | 41699 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2 Mizpah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42149 | 6001021.55719924 | 2096664.38095079 | 37.7370985809646 | -122.438954184383 | (37.7370985809646, -122.438954184383) | 2 | 7 | 5 | 63 | 7 | ||
| 170988 | 225052 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000953.83658 | 2096674.21341 | 37.7371217252913 | -122.439189029173 | (37.7371217252913, -122.439189029173) | 2 | 7 | 5 | 63 | 7 | |||
| 191495 | 225054 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 342 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001139.36381 | 2096693.29596 | 37.7371846769336 | -122.438548945674 | (37.7371846769336, -122.438548945674) | 2 | 7 | 5 | 63 | 7 | |||
| 127978 | 225055 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | 2 | 7 | 5 | 63 | 7 | |||
| 62355 | 225056 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901045 | -122.438748363154 | (37.737188901045, -122.438748363154) | 2 | 7 | 5 | 63 | 7 | |||
| 172941 | 225057 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | 2 | 7 | 5 | 63 | 7 | |||
| 110285 | 32421 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36948 | 6000917.26502 | 2096711.23126 | 37.7372212865363 | -122.439318125938 | (37.7372212865363, -122.439318125938) | 2 | 7 | 5 | 63 | 7 | ||
| 113575 | 17433 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1900 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6013265.7394 | 2096489.52235 | 37.7373075045406 | -122.396607955902 | (37.7373075045406, -122.396607955902) | 10 | 3 | 8 | 58 | 1 | |||
| 146541 | 17437 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1919 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6013108.75457 | 2096537.612 | 37.7374308105776 | -122.397154099803 | (37.7374308105776, -122.397154099803) | 10 | 3 | 8 | 58 | 1 | |||
| 107783 | 17444 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1950 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6013023.36347 | 2096670.73663 | 37.7377915889102 | -122.397458672302 | (37.7377915889102, -122.397458672302) | 10 | 3 | 8 | 58 | 1 | |||
| 3395 | 17446 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6012949.46477 | 2096727.20845 | 37.7379425338291 | -122.397718137505 | (37.7379425338291, -122.397718137505) | 10 | 3 | 8 | 58 | 1 | |||
| 102986 | 17458 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1999 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 6012778.88075 | 2096779.84322 | 37.7380775571329 | -122.398311626199 | (37.7380775571329, -122.398311626199) | 10 | 3 | 8 | 58 | 1 | |||
| 132763 | 17464 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2043 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6012526.80505 | 2096970.93797 | 37.7385882182703 | -122.399196593253 | (37.7385882182703, -122.399196593253) | 10 | 3 | 8 | 58 | 1 | |||
| 164831 | 206009 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990946.44352 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | 1 | 8 | 4 | 29491 | 40 | |||
| 50124 | 206005 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553 | (37.7394900683054, -122.47345704553) | 1 | 8 | 4 | 29491 | 40 | |||
| 182447 | 224898 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1X Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007216.8564 | 2097735.11711 | 37.7403891304638 | -122.417610047575 | (37.7403891304638, -122.417610047575) | 2 | 7 | 7 | 28859 | 2 | |||
| 174571 | 225065 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006960.17815 | 2097772.45281 | 37.7404771992577 | -122.418500188445 | (37.7404771992577, -122.418500188445) | 2 | 7 | 7 | 28859 | 2 | |||
| 99949 | 96852 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1x Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007194 | 2097789 | 37.7405357947447 | -122.417692894396 | (37.7405357947447, -122.417692894396) | 2 | 7 | 7 | 28859 | 2 | |||
| 35885 | 189864 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6015974.53489 | 2097767.48194 | 37.7409669053009 | -122.387331434622 | (37.7409669053009, -122.387331434622) | 10 | 3 | 8 | 58 | 1 | |||
| 26053 | 16540 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 0 | 6016126.25571 | 2098060.8881 | 37.7417809401523 | -122.386827291768 | (37.7417809401523, -122.386827291768) | 10 | 3 | 8 | 58 | 1 | |||
| 100997 | 173732 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015419 | 2098106 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | 10 | 3 | 8 | 58 | 1 | ||||
| 136362 | 189853 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.7420694633311 | -122.382594511142 | (37.7420694633311, -122.382594511142) | 10 | 3 | 8 | 58 | 1 | |||
| 186991 | 16521 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016284.3157 | 2098184.69928 | 37.7421296504552 | -122.386289397351 | (37.7421296504552, -122.386289397351) | 10 | 3 | 8 | 58 | 1 | |||
| 80577 | 189839 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.383560265197 | (37.7422631836031, -122.383560265197) | 10 | 3 | 8 | 58 | 1 | |||
| 62069 | 4912 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
| 177283 | 16490 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016659.29203 | 2098304.79019 | 37.7424801439961 | -122.385001199414 | (37.7424801439961, -122.385001199414) | 10 | 3 | 8 | 58 | 1 | |||
| 153118 | 189887 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6016910.34518 | 2098303.24769 | 37.7424897920671 | -122.384133016442 | (37.7424897920671, -122.384133016442) | 10 | 3 | 8 | 58 | 1 | |||
| 22352 | 16479 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
| 192927 | 16499 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016428.13466 | 2098327.93774 | 37.7425309135822 | -122.385802093385 | (37.7425309135822, -122.385802093385) | 10 | 3 | 8 | 58 | 1 | |||
| 24626 | 93109 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.35417 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | 10 | 3 | 8 | 58 | 1 | |
| 169044 | 16510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
| 158664 | 189901 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6016452.46192 | 2098385.21634 | 37.7426895350994 | -122.385721967406 | (37.7426895350994, -122.385721967406) | 10 | 3 | 8 | 58 | 1 | |||
| 167263 | 14924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
| 64038 | 248270 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | 2 | 7 | 7 | 28859 | 2 | |||
| 111174 | 248263 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.7431418122345 | -122.419409127839 | (37.7431418122345, -122.419409127839) | 2 | 7 | 7 | 28859 | 2 | |||
| 12569 | 111886 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
| 178019 | 248274 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006747.61558 | 2098750.15701 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | 2 | 7 | 7 | 28859 | 2 | |||
| 64807 | 248261 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | 2 | 7 | 7 | 28859 | 2 | |||
| 53125 | 248260 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | 2 | 7 | 7 | 28859 | 2 | |||
| 191608 | 248257 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.419204890889 | (37.7434438819296, -122.419204890889) | 2 | 7 | 7 | 28859 | 2 | |||
| 65527 | 248255 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | 2 | 7 | 7 | 28859 | 2 | |||
| 105802 | 248279 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | 2 | 7 | 7 | 28859 | 2 | |||
| 82514 | 63116 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 115 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23622 | 6006844.85682717 | 2098899.69149034 | 37.7435658517454 | -122.418978856767 | (37.7435658517454, -122.418978856767) | 2 | 7 | 7 | 28859 | 2 | ||
| 157121 | 248253 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006804.33159 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | 2 | 7 | 7 | 28859 | 2 | |||
| 174101 | 113692 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 112 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6006814 | 2098928 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | 2 | 7 | 7 | 28859 | 2 | |||
| 179658 | 2505 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
| 22673 | 248195 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006895.3062 | 2099022.51404 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | 2 | 7 | 7 | 28859 | 2 | |||
| 161276 | 188483 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016580.58877 | 2098830.37302 | 37.7439189335051 | -122.385309950204 | (37.7439189335051, -122.385309950204) | 10 | 3 | 8 | 58 | 1 | |||
| 180926 | 63125 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 80 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 23639 | 6007006.19001516 | 2099063.67894521 | 37.744025207978 | -122.418432630519 | (37.744025207978, -122.418432630519) | 2 | 7 | 7 | 28859 | 2 | ||
| 130222 | 248198 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006917.65895 | 2099068.87829 | 37.7440345000033 | -122.418739120308 | (37.7440345000033, -122.418739120308) | 2 | 7 | 7 | 28859 | 2 | |||
| 72277 | 58315 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1986 12:00:00 AM | Permit Number 23623 | 6006886.31504247 | 2099084.89744452 | 37.7440767201845 | -122.418848636603 | (37.7440767201845, -122.418848636603) | 2 | 7 | 7 | 28859 | 2 | ||
| 41267 | 63222 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 76 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1987 12:00:00 AM | Permit Number 23766 | 6007018.22684623 | 2099086.03719365 | 37.7440872763149 | -122.418392594768 | (37.7440872763149, -122.418392594768) | 2 | 7 | 7 | 28859 | 2 | ||
| 9983 | 248199 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698122 | (37.7440974516285, -122.41868698122) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );