trees
858 rows where qSpecies_id = 85 sorted by Fire Prevention Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6649 | 94079 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 634 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53466 | 5995982 | 2096031 | 37.735071449053 | -122.45633232205 | (37.735071449053, -122.45633232205) | 9 | 7 | 4 | 59 | 40 | ||
| 8664 | 179570 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5998636.21814 | 2088373.46946 | 37.7141976645548 | -122.446605012326 | (37.7141976645548, -122.446605012326) | 9 | 7 | 6 | 28861 | 25 | |||
| 10272 | 80644 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 369 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6008610.79188 | 2094726.87163 | 37.7322074806863 | -122.412577751678 | (37.7322074806863, -122.412577751678) | 9 | 3 | 7 | 309 | 28 | |||
| 14045 | 179629 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 49 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x6 | 6002062.61368 | 2087462.58557 | 37.7118917030158 | -122.434696982076 | (37.7118917030158, -122.434696982076) | 9 | 7 | 6 | 28861 | 5 | |||
| 14849 | 179597 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 25 Otsego Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6000936.4483 | 2092902.26266 | 37.7267638312622 | -122.438978907964 | (37.7267638312622, -122.438978907964) | 9 | 7 | 6 | 28861 | 25 | ||||
| 15102 | 49150 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 4199 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2003 12:00:00 AM | Permit Number 46273 | 6003544.55958588 | 2093981.972593 | 37.7298765227481 | -122.430039732071 | (37.7298765227481, -122.430039732071) | 9 | 7 | 6 | 28861 | 5 | |||
| 18132 | 38160 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 48 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773760 | 6009245.10254035 | 2094077.23333811 | 37.7304592916016 | -122.41033893557 | (37.7304592916016, -122.41033893557) | 9 | 3 | 7 | 309 | 28 | |
| 18241 | 215179 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 747 Detroit St | 12 | Side Yard : Yard | Tree | Private 2 | 5 | 5999425.63373 | 2095397.4728 | 37.7335290182456 | -122.444380974518 | (37.7335290182456, -122.444380974518) | 9 | 7 | 4 | 59 | 40 | ||||
| 21167 | 179605 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 247 Mount Vernon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5998680.84891 | 2089595.4146 | 37.7175553958555 | -122.446538611763 | (37.7175553958555, -122.446538611763) | 9 | 7 | 6 | 28861 | 25 | ||||
| 21838 | 108849 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 285 Allison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772784 | 6000190.55201 | 2087326.30532 | 37.7114110495602 | -122.441157562371 | (37.7114110495602, -122.441157562371) | 9 | 7 | 6 | 28861 | 5 |
| 24014 | 62260 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 126 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1985 12:00:00 AM | 12 | Permit Number 22386 | 6000410.66201 | 2092263.48087 | 37.7249799531412 | -122.440750730657 | (37.7249799531412, -122.440750730657) | 9 | 7 | 6 | 28861 | 25 | |
| 24765 | 179614 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 822 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008536.27873 | 2093186.38698 | 37.7279734580912 | -122.412726495035 | (37.7279734580912, -122.412726495035) | 9 | 3 | 7 | 309 | 28 | |||
| 30893 | 179612 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 Excelsior Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004345.82316 | 2091535.07257 | 37.7232032246197 | -122.4270954535 | (37.7232032246197, -122.4270954535) | 9 | 7 | 6 | 28861 | 5 | |||
| 32900 | 108848 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 285 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772784 | 6000194.12477 | 2087314.03499 | 37.7113775614841 | -122.441144334244 | (37.7113775614841, -122.441144334244) | 9 | 7 | 6 | 28861 | 5 |
| 35836 | 179593 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 78 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010613.233 | 2088708.1848 | 37.7157935942767 | -122.40523115211 | (37.7157935942767, -122.40523115211) | 9 | 7 | 8 | 309 | 39 | |||
| 36539 | 215138 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 810 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993949.3025 | 2094130.56753 | 37.7297364296862 | -122.46322217696 | (37.7297364296862, -122.46322217696) | 9 | 8 | 4 | 59 | 40 | |||
| 36658 | 66354 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 334 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1990 12:00:00 AM | 13 | Permit Number 29475 | 6003787.88189 | 2089236.55246 | 37.7168604267574 | -122.428860361341 | (37.7168604267574, -122.428860361341) | 9 | 7 | 6 | 28861 | 5 | ||
| 37943 | 15688 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4199 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1995 12:00:00 AM | 3 | 3X3 | 6003628.48127 | 2094078.57512 | 37.7301465241442 | -122.429756492581 | (37.7301465241442, -122.429756492581) | 9 | 7 | 6 | 28861 | 5 | ||
| 38658 | 179604 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998666.20237 | 2089602.87221 | 37.7175750361301 | -122.446589774218 | (37.7175750361301, -122.446589774218) | 9 | 7 | 6 | 28861 | 25 | |||
| 39933 | 179569 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5998642.93627 | 2088367.48919 | 37.7141816278426 | -122.446581361956 | (37.7141816278426, -122.446581361956) | 9 | 7 | 6 | 28861 | 25 | |||
| 41439 | 50825 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 260 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47345 | 5992354.32900617 | 2095121.08916568 | 37.7323641420519 | -122.468808176404 | (37.7323641420519, -122.468808176404) | 9 | 8 | 4 | 59 | 40 | |||
| 42604 | 215186 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 217 Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5998652.24527 | 2093777.94068 | 37.7290380080928 | -122.446938287569 | (37.7290380080928, -122.446938287569) | 9 | 7 | 4 | 28861 | 40 | |||
| 44587 | 179600 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5998640.25719 | 2089558.97664 | 37.71745302692 | -122.446676297989 | (37.71745302692, -122.446676297989) | 9 | 7 | 6 | 28861 | 25 | |||
| 46176 | 179568 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5998649.6038 | 2088359.07643 | 37.7141589091721 | -122.446557711588 | (37.7141589091721, -122.446557711588) | 9 | 7 | 6 | 28861 | 25 | |||
| 46661 | 83577 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 124 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52313 | 6003965.91077 | 2093279.80757 | 37.7279723888056 | -122.42853304139 | (37.7279723888056, -122.42853304139) | 9 | 7 | 6 | 28861 | 5 | |
| 46969 | 43209 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 15 | Permit Number 43000 | 6007755.9781 | 2093953.95749 | 37.7300372142398 | -122.415478343147 | (37.7300372142398, -122.415478343147) | 9 | 3 | 7 | 309 | 28 | |
| 47199 | 42979 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 308 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 10 | Permit Number 42863 | 6006597.58462 | 2092494.33475 | 37.7259642287513 | -122.419379553644 | (37.7259642287513, -122.419379553644) | 9 | 7 | 7 | 309 | 5 | |
| 47315 | 179611 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 Excelsior Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004351.48931 | 2091531.74381 | 37.7231944049897 | -122.427075629732 | (37.7231944049897, -122.427075629732) | 9 | 7 | 6 | 28861 | 5 | |||
| 47536 | 179594 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2115 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006118.53039 | 2086176.01149 | 37.7085884697411 | -122.420587301759 | (37.7085884697411, -122.420587301759) | 9 | 7 | 8 | 309 | 39 | |||
| 47899 | 215180 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 48 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999778.0534 | 2095525.26911 | 37.7339000182695 | -122.443171738004 | (37.7339000182695, -122.443171738004) | 9 | 7 | 4 | 63 | 40 | ||||
| 48039 | 215185 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 217 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5998634.76225 | 2093779.70268 | 37.7290418472936 | -122.446998854224 | (37.7290418472936, -122.446998854224) | 9 | 7 | 4 | 28861 | 40 | |||
| 49958 | 179598 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 25 Otsego Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000939.98945 | 2092924.83634 | 37.7268260149038 | -122.438968283387 | (37.7268260149038, -122.438968283387) | 9 | 7 | 6 | 28861 | 25 | |||
| 53406 | 256184 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 412 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 10x3 | Permit Number 770911 | 5998674.66662 | 2094402.01563 | 37.7307528521501 | -122.446905665072 | (37.7307528521501, -122.446905665072) | 9 | 7 | 4 | 59 | 40 | |
| 53922 | 215171 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 101 Stanford Heights Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997803.80598 | 2096370.84816 | 37.7361090059307 | -122.450058203043 | (37.7361090059307, -122.450058203043) | 9 | 7 | 4 | 59 | 40 | |||
| 55489 | 215151 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 748 Lakeview Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994563.14295 | 2089947.14984 | 37.7182851165506 | -122.460797016589 | (37.7182851165506, -122.460797016589) | 9 | 8 | 6 | 28861 | 24 | |||
| 55640 | 31053 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002711.16213 | 2087562.81668 | 37.7122037138071 | -122.432462573298 | (37.7122037138071, -122.432462573298) | 9 | 7 | 6 | 28861 | 5 | |
| 56716 | 179573 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 205 Seneca Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5999821.83375 | 2090347.39989 | 37.7196852827387 | -122.442648723777 | (37.7196852827387, -122.442648723777) | 9 | 7 | 6 | 28861 | 25 | |||
| 57296 | 179565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5998669.51427 | 2088341.14104 | 37.7141107999422 | -122.446487604047 | (37.7141107999422, -122.446487604047) | 9 | 7 | 6 | 28861 | 25 | |||
| 59253 | 215159 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 18 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993985.26424 | 2089201.78141 | 37.7162052463581 | -122.462740441625 | (37.7162052463581, -122.462740441625) | 9 | 8 | 6 | 64 | 24 | |||
| 61876 | 179578 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 334 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003779.11215 | 2089222.99439 | 37.7168227028799 | -122.428889707996 | (37.7168227028799, -122.428889707996) | 9 | 7 | 6 | 28861 | 5 | |||
| 62516 | 179588 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 71 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002920.32073 | 2087190.64044 | 37.7111936573252 | -122.431713104392 | (37.7111936573252, -122.431713104392) | 9 | 7 | 6 | 28861 | 5 | |||
| 64041 | 179615 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 30 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009248.62763 | 2094075.24291 | 37.7304540239162 | -122.410326608297 | (37.7304540239162, -122.410326608297) | 9 | 3 | 7 | 309 | 28 | |||
| 66206 | 215177 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 115 Bella Vista Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5998455.14668 | 2097038.32931 | 37.7379789995273 | -122.44785430284 | (37.7379789995273, -122.44785430284) | 9 | 7 | 4 | 59 | 40 | |||
| 69360 | 254892 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4199 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003642.63298 | 2094097.24722 | 37.7301985948914 | -122.429708899543 | (37.7301985948914, -122.429708899543) | 9 | 7 | 6 | 28861 | 5 | ||||
| 69487 | 215176 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 115 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998441.46818 | 2097042.42128 | 37.7379894532555 | -122.447901890481 | (37.7379894532555, -122.447901890481) | 9 | 7 | 4 | 59 | 40 | |||
| 71102 | 179603 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998658.1578 | 2089592.85208 | 37.7175470636356 | -122.446616859994 | (37.7175470636356, -122.446616859994) | 9 | 7 | 6 | 28861 | 25 | |||
| 72361 | 215174 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 120 Bella Vista Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998431.33624 | 2097088.3182 | 37.7381148960726 | -122.447940224956 | (37.7381148960726, -122.447940224956) | 9 | 7 | 4 | 59 | 40 | |||
| 78070 | 215167 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 616 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996095.52716 | 2095987.52181 | 37.734958585052 | -122.455936678249 | (37.734958585052, -122.455936678249) | 9 | 7 | 4 | 59 | 40 | |||
| 78817 | 179571 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5998627.15829 | 2088384.36554 | 37.7142270651918 | -122.446637110039 | (37.7142270651918, -122.446637110039) | 9 | 7 | 6 | 28861 | 25 | |||
| 78863 | 179572 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 205 Seneca Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5999817.08218 | 2090385.88306 | 37.7197906778859 | -122.442667909917 | (37.7197906778859, -122.442667909917) | 9 | 7 | 6 | 28861 | 25 | |||
| 79604 | 179610 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 Excelsior Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6004355.20316 | 2091529.34744 | 37.723188035096 | -122.427062621069 | (37.723188035096, -122.427062621069) | 9 | 7 | 6 | 28861 | 5 | |||
| 83276 | 215181 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 531 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 7ft | 5998095.27247 | 2095150.54109 | 37.7327750077488 | -122.448962612061 | (37.7327750077488, -122.448962612061) | 9 | 7 | 4 | 59 | 40 | |||
| 92610 | 215170 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 634 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995982.01885 | 2096037.45526 | 37.7350891747094 | -122.45633272349 | (37.7350891747094, -122.45633272349) | 9 | 7 | 4 | 59 | 40 | |||
| 93211 | 94080 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 670 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53467 | 5995742 | 2095977 | 37.7349093977174 | -122.457158177766 | (37.7349093977174, -122.457158177766) | 9 | 7 | 4 | 59 | 40 | ||
| 95719 | 215152 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 739 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994637.17315 | 2089906.08202 | 37.7181766133493 | -122.460538153038 | (37.7181766133493, -122.460538153038) | 9 | 8 | 6 | 28861 | 24 | |||
| 96728 | 31051 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 South Hill Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002706.14254 | 2087539.54135 | 37.7121395201911 | -122.432478261058 | (37.7121395201911, -122.432478261058) | 9 | 7 | 6 | 28861 | 5 | |
| 96783 | 215163 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 240 Manor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993891.80152 | 2094104.36583 | 37.7296611735131 | -122.463419061951 | (37.7296611735131, -122.463419061951) | 9 | 8 | 4 | 59 | 40 | |||
| 96838 | 15689 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4199 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1995 12:00:00 AM | 3 | 3X3 | 6003642.63298 | 2094097.24722 | 37.7301985948914 | -122.429708899543 | (37.7301985948914, -122.429708899543) | 9 | 7 | 6 | 28861 | 5 | ||
| 100099 | 179596 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2101 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006079.30218 | 2086189.02233 | 37.7086219838753 | -122.420723802683 | (37.7086219838753, -122.420723802683) | 9 | 7 | 8 | 309 | 39 | |||
| 101934 | 215168 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 622 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996065.35511 | 2096007.84568 | 37.7350126576924 | -122.456042461904 | (37.7350126576924, -122.456042461904) | 9 | 7 | 4 | 59 | 40 | |||
| 105383 | 94072 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 622 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53463 | 5996083.1 | 2096029.6 | 37.7350734082762 | -122.455982684089 | (37.7350734082762, -122.455982684089) | 9 | 7 | 4 | 59 | 40 | ||
| 106399 | 179602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998651.59561 | 2089580.85001 | 37.7175137338593 | -122.446638679342 | (37.7175137338593, -122.446638679342) | 9 | 7 | 6 | 28861 | 25 | |||
| 107382 | 215178 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Martha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000653.29214 | 2095587.48865 | 37.7341207262744 | -122.440150239859 | (37.7341207262744, -122.440150239859) | 9 | 7 | 5 | 63 | 40 | |||
| 108605 | 179608 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 239 Naples St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6004077.01735 | 2092129.72211 | 37.7248207965363 | -122.428067019004 | (37.7248207965363, -122.428067019004) | 9 | 7 | 6 | 28861 | 5 | ||||
| 109277 | 215149 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 484 Faxon Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994795.24722 | 2091767.07997 | 37.7232955616276 | -122.460126512638 | (37.7232955616276, -122.460126512638) | 9 | 8 | 4 | 28861 | 24 | |||
| 109543 | 215137 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 810 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993934.51855 | 2094140.11477 | 37.7297617923721 | -122.463273978817 | (37.7297617923721, -122.463273978817) | 9 | 8 | 4 | 59 | 40 | |||
| 109720 | 179566 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5998660.62804 | 2088348.62653 | 37.7141308458255 | -122.446518856356 | (37.7141308458255, -122.446518856356) | 9 | 7 | 6 | 28861 | 25 | |||
| 109894 | 38159 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 48 Holyoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773760 | 6009245.10254035 | 2094077.23333811 | 37.7304592916016 | -122.41033893557 | (37.7304592916016, -122.41033893557) | 9 | 3 | 7 | 309 | 28 | |
| 111011 | 179577 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 700 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001127.46159 | 2089574.9646 | 37.7176386901633 | -122.438080342229 | (37.7176386901633, -122.438080342229) | 9 | 7 | 6 | 28861 | 5 | |||
| 113386 | 94073 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 622 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53463 | 5996083.1 | 2096029.6 | 37.7350734082762 | -122.455982684089 | (37.7350734082762, -122.455982684089) | 9 | 7 | 4 | 59 | 40 | ||
| 114750 | 215183 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 463 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5999025.03283 | 2094940.16971 | 37.7322505069565 | -122.445733085438 | (37.7322505069565, -122.445733085438) | 9 | 7 | 4 | 59 | 40 | |||
| 115198 | 215155 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 201 Thrift St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994990.6689 | 2089608.53553 | 37.7173799515955 | -122.459294742256 | (37.7173799515955, -122.459294742256) | 9 | 8 | 6 | 28861 | 24 | |||
| 115347 | 179574 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 150 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001107.65338 | 2089620.96663 | 37.7177638748828 | -122.438152103634 | (37.7177638748828, -122.438152103634) | 9 | 7 | 6 | 28861 | 5 | |||
| 116172 | 31052 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 12 | Permit Number 34806 | 6002702.91806 | 2087603.19894 | 37.7123141271746 | -122.432493949742 | (37.7123141271746, -122.432493949742) | 9 | 7 | 6 | 28861 | 5 | |
| 119554 | 50826 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 260 San Leandro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47345 | 5992354.32900617 | 2095121.08916568 | 37.7323641420519 | -122.468808176404 | (37.7323641420519, -122.468808176404) | 9 | 8 | 4 | 59 | 40 | |||
| 119740 | 215173 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 120 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998452.61028 | 2097081.78391 | 37.7380981704837 | -122.447866199984 | (37.7380981704837, -122.447866199984) | 9 | 7 | 4 | 59 | 40 | |||
| 119832 | 179616 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Holyoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009268.03343 | 2094013.46046 | 37.7302854702824 | -122.410255158964 | (37.7302854702824, -122.410255158964) | 9 | 3 | 7 | 309 | 28 | |||
| 120773 | 179607 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 247 Mount Vernon Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5998695.31967 | 2089579.5071 | 37.7175125440582 | -122.44648744935 | (37.7175125440582, -122.44648744935) | 9 | 7 | 6 | 28861 | 25 | ||||
| 124189 | 215169 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 634 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996017.99501 | 2096027.04258 | 37.7350626492231 | -122.456207589133 | (37.7350626492231, -122.456207589133) | 9 | 7 | 4 | 59 | 40 | |||
| 126601 | 179599 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998631.90027 | 2089544.41132 | 37.7174125565133 | -122.446704136484 | (37.7174125565133, -122.446704136484) | 9 | 7 | 6 | 28861 | 25 | |||
| 128130 | 215165 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 240 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993883.88024 | 2094060.55173 | 37.7295404143478 | -122.463443268118 | (37.7295404143478, -122.463443268118) | 9 | 8 | 4 | 59 | 40 | |||
| 128373 | 215154 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 201 Thrift St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994969.58923 | 2089610.21368 | 37.7173833474283 | -122.459367725845 | (37.7173833474283, -122.459367725845) | 9 | 8 | 6 | 28861 | 24 | |||
| 131354 | 179564 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5998675.98821 | 2088335.16586 | 37.7140947632347 | -122.446464798107 | (37.7140947632347, -122.446464798107) | 9 | 7 | 6 | 28861 | 25 | |||
| 134738 | 115357 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 270 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2016 12:00:00 AM | 3 | 3x6 | 5999894.51999 | 2091641.88128 | 37.7232437759734 | -122.442490363056 | (37.7232437759734, -122.442490363056) | 9 | 7 | 6 | 28861 | 25 | ||
| 135214 | 179563 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5998684.14155 | 2088327.69562 | 37.71407471735 | -122.446436080061 | (37.71407471735, -122.446436080061) | 9 | 7 | 6 | 28861 | 25 | |||
| 136249 | 215148 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 484 Faxon Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994798.31225 | 2091770.42438 | 37.723304920868 | -122.46011615966 | (37.723304920868, -122.46011615966) | 9 | 8 | 4 | 28861 | 24 | |||
| 137514 | 215140 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 810 Darien Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993993.45625 | 2094092.45584 | 37.7296343278608 | -122.463066769619 | (37.7296343278608, -122.463066769619) | 9 | 8 | 4 | 59 | 40 | |||
| 137706 | 179575 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 150 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001094.37871 | 2089628.06075 | 37.7177825987614 | -122.438198496058 | (37.7177825987614, -122.438198496058) | 9 | 7 | 6 | 28861 | 5 | |||
| 141451 | 62128 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 669 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2011 12:00:00 AM | 14 | Permit Number 767154 | 6001650.69478 | 2093159.72475 | 37.7275113765377 | -122.436528202327 | (37.7275113765377, -122.436528202327) | 9 | 7 | 6 | 28861 | 25 | |
| 144508 | 215153 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 201 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994954.26021 | 2089609.71028 | 37.7173810838456 | -122.459420674348 | (37.7173810838456, -122.459420674348) | 9 | 8 | 6 | 28861 | 24 | |||
| 147217 | 179595 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2109 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006095.08243 | 2086183.72557 | 37.7086083294779 | -122.420668888264 | (37.7086083294779, -122.420668888264) | 9 | 7 | 8 | 309 | 39 | |||
| 147481 | 215182 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 463 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999010.27233 | 2094940.09474 | 37.732249458336 | -122.445784110252 | (37.732249458336, -122.445784110252) | 9 | 7 | 4 | 59 | 40 | |||
| 149667 | 64644 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 365 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52474 | 6008639.47010763 | 2094730.52839265 | 37.7322191308306 | -122.412478862636 | (37.7322191308306, -122.412478862636) | 9 | 3 | 7 | 309 | 28 | |
| 150017 | 215184 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6000197.81329 | 2094034.15603 | 37.7298296947652 | -122.441613533956 | (37.7298296947652, -122.441613533956) | 9 | 7 | 4 | 63 | 40 | ||||
| 151020 | 72146 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 49 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 10 | Permit Number 53889 | 6001152.42683 | 2093652.94221 | 37.7288373117797 | -122.43828603339 | (37.7288373117797, -122.43828603339) | 9 | 7 | 6 | 28861 | 25 | ||
| 153108 | 215158 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 494 Victoria St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5993274.39312 | 2090442.46947 | 37.7195709087624 | -122.465287603165 | (37.7195709087624, -122.465287603165) | 9 | 8 | 6 | 64 | 24 | |||
| 154629 | 215172 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 24 Arroyo Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998696.48615 | 2097465.41857 | 37.7391654760043 | -122.447050603021 | (37.7391654760043, -122.447050603021) | 9 | 7 | 4 | 59 | 40 | |||
| 156121 | 179576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 150 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001080.83583 | 2089635.43294 | 37.7178020708848 | -122.438245835497 | (37.7178020708848, -122.438245835497) | 9 | 7 | 6 | 28861 | 5 | |||
| 157794 | 49151 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 4199 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2003 12:00:00 AM | Permit Number 46273 | 6003544.55958588 | 2093981.972593 | 37.7298765227481 | -122.430039732071 | (37.7298765227481, -122.430039732071) | 9 | 7 | 6 | 28861 | 5 | |||
| 158223 | 179567 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5998654.86652 | 2088353.61348 | 37.7141442097611 | -122.446539128875 | (37.7141442097611, -122.446539128875) | 9 | 7 | 6 | 28861 | 25 |
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) );