trees
858 rows where qSpecies_id = 85 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22133 | 86802 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359 | 2106197 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | 8 | 4 | 7 | 28859 | 19 | |||
152418 | 86801 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359 | 2106197 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | 8 | 4 | 7 | 28859 | 19 | |||
284 | 142846 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1249 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006785.3377 | 2115265.4346 | 37.7884989771715 | -122.420346012985 | (37.7884989771715, -122.420346012985) | 13 | 9 | 10 | 28858 | 21 | |||
562 | 18470 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2003 12:00:00 AM | 12 | 3X3 | 6010619.64201 | 2102143.08548 | 37.7526833394657 | -122.406154975289 | (37.7526833394657, -122.406154975289) | 10 | 4 | 8 | 28859 | 19 | ||
623 | 179591 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 46 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010887.64563 | 2089644.57166 | 37.7183800597759 | -122.404348520588 | (37.7183800597759, -122.404348520588) | 10 | 7 | 8 | 309 | 39 | |||
763 | 81425 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 940 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6008220.47523 | 2115740.61826 | 37.7898844812376 | -122.415414298837 | (37.7898844812376, -122.415414298837) | 5 | 1 | 10 | 28858 | 21 | ||
984 | 20145 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1006 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002942.8987 | 2111794.0047 | 37.7787500346576 | -122.433392078669 | (37.7787500346576, -122.433392078669) | 15 | 9 | 11 | 29490 | 41 | |||
988 | 246280 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 350 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002911.2454 | 2106157.7898 | 37.7632725790372 | -122.433098773623 | (37.7632725790372, -122.433098773623) | 15 | 4 | 5 | 28862 | 3 | |||
2442 | 35339 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 740 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 9 | Permit Number 38804 | 6013014.621 | 2103534.39703 | 37.7566372493387 | -122.397970249845 | (37.7566372493387, -122.397970249845) | 10 | 3 | 8 | 28856 | 29 | |
4082 | 215134 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 87 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785257 | 5992831.00569 | 2098575.54206 | 37.741876730518 | -122.467411314403 | (37.741876730518, -122.467411314403) | 1 | 8 | 4 | 59 | 40 | |
4603 | 59265 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1693 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1980 12:00:00 AM | 3 | 3x3 | Permit Number 18600 | 6006592.1641 | 2116638.2998 | 37.7922576371531 | -122.421111884547 | (37.7922576371531, -122.421111884547) | 13 | 9 | 10 | 28858 | 21 |
5526 | 71641 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011027.0266 | 2119468.0848 | 37.800276548465 | -122.405966529737 | (37.800276548465, -122.405966529737) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||
7978 | 81424 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 936 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008224.91775 | 2115730.6565 | 37.7898573783726 | -122.415398222545 | (37.7898573783726, -122.415398222545) | 5 | 1 | 10 | 28858 | 21 | |||
8109 | 136528 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3271 Baker St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 5999283.78896 | 2120122.72812 | 37.8014102447475 | -122.446649724806 | (37.8014102447475, -122.446649724806) | 13 | 9 | 1 | 57 | 17 | |||
8339 | 4224 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3978 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1995 12:00:00 AM | 3 | 3X3 | 6004063.19493 | 2100446.35832 | 37.7476556121143 | -122.428707390249 | (37.7476556121143, -122.428707390249) | 2 | 4 | 5 | 63 | 22 | ||
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 | |||
10632 | 245230 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 24 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005803.61111 | 2105914.49608 | 37.7627681957301 | -122.423077727748 | (37.7627681957301, -122.423077727748) | 8 | 4 | 5 | 28859 | 19 | |||
11327 | 12222 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1543 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6015840.7459 | 2095893.0455 | 37.7358126735457 | -122.387663285334 | (37.7358126735457, -122.387663285334) | 10 | 3 | 8 | 58 | 1 | ||
11346 | 261371 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 105 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095358 | 37.7338620991787 | -122.417441127318 | (37.7338620991787, -122.417441127318) | 2 | 7 | 7 | 28859 | 2 | ||||
11748 | 61613 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1546 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/1984 12:00:00 AM | 17 | Permit Number 21590 | 6006691.8914 | 2116275.8765 | 37.7912681342545 | -122.42074108486 | (37.7912681342545, -122.42074108486) | 13 | 9 | 10 | 28858 | 21 | |
12551 | 223913 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 199X Ogden Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6007786.13084 | 2096145.8013 | 37.7360572355453 | -122.415529221396 | (37.7360572355453, -122.415529221396) | 2 | 7 | 7 | 28859 | 2 | |||
12590 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 778992 | 6001431 | 2120732 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | 13 | 9 | 1 | 57 | 17 | ||
13586 | 32270 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1654 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36856 | 6002284.74056 | 2121254.77264 | 37.8046895029868 | -122.436346174145 | (37.8046895029868, -122.436346174145) | 13 | 9 | 1 | 57 | 17 | ||
13801 | 245307 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 715 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785521 | 6007791 | 2095580 | 37.7345039424746 | -122.415472341973 | (37.7345039424746, -122.415472341973) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
14418 | 256780 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 2301 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006284 | 2118744 | 37.7980219841193 | -122.422327817993 | (37.7980219841193, -122.422327817993) | 13 | 9 | 10 | 28858 | 32 | ||||
14932 | 51370 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 39 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 47705 | 6013932.28471 | 2095479.44374 | 37.7345711103726 | -122.394232686294 | (37.7345711103726, -122.394232686294) | 10 | 3 | 8 | 58 | 1 |
15065 | 261762 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 2943 Harrison St | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6009034.67775 | 2101326.83516 | 37.7503533174728 | -122.411578417814 | (37.7503533174728, -122.411578417814) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | |||
15752 | 62590 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3550 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 12 | Permit Number 22896 | 5984601.92533 | 2110430.06768 | 37.7739474449292 | -122.496739029498 | (37.7739474449292, -122.496739029498) | 11 | 6 | 2 | 55 | 26 | |
16712 | 240997 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 52 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004455.87708 | 2107460.86758 | 37.7669380156921 | -122.42784925625 | (37.7669380156921, -122.42784925625) | 8 | 4 | 5 | 28862 | 3 | |||
16751 | 78587 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1361 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012314.29117 | 2102093.10716 | 37.7526407529845 | -122.400291031321 | (37.7526407529845, -122.400291031321) | 10 | 3 | 8 | 28856 | 29 | |||
17510 | 70565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 210 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6014527.51657 | 2111489.70716 | 37.7785649223813 | -122.39329474466 | (37.7785649223813, -122.39329474466) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |
19243 | 197785 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2347 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6010748.45807 | 2105046.89477 | 37.7606637578537 | -122.405914042413 | (37.7606637578537, -122.405914042413) | 10 | 3 | 8 | 28856 | 29 | ||||
19565 | 218219 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 387 Wawona St | 1 | : | Tree | Private 2 | 2 | Width 2ft | 5991861.85445 | 2097038.30782 | 37.7375998777167 | -122.470650352243 | (37.7375998777167, -122.470650352243) | 1 | 8 | 4 | 59 | 40 | |||
19679 | 40601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 13 | Permit Number 47084 | 6011717.76597 | 2107914.27714 | 37.7685911090192 | -122.402763284706 | (37.7685911090192, -122.402763284706) | 8 | 2 | 8 | 28853 | 20 | |
19713 | 50720 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1350 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/01/2004 12:00:00 AM | Permit Number 47273 | 5999239.23876402 | 2108409.63945521 | 37.7692466150992 | -122.44596095669 | (37.7692466150992, -122.44596095669) | 15 | 5 | 11 | 29492 | 9 | ||
19745 | 240855 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 151 Albion St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6005930.39356 | 2106374.49675 | 37.7640384026622 | -122.422671922196 | (37.7640384026622, -122.422671922196) | 8 | 4 | 5 | 28859 | 19 | |||
19979 | 41630 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012549.77298 | 2109959.42064 | 37.7742530301757 | -122.400029064208 | (37.7742530301757, -122.400029064208) | 14 | 2 | 9 | 28856 | 20 | ||
20782 | 40002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019340.13593 | 2094332.72798 | 37.731721560802 | -122.375456255711 | (37.731721560802, -122.375456255711) | 10 | 3 | 8 | 58 | 1 | |
22187 | 26857 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 586 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/1998 12:00:00 AM | 2 | 3x3 | Permit Number 772904 | 6002335.9416 | 2104815.18897 | 37.7595534719369 | -122.434992530799 | (37.7595534719369, -122.434992530799) | 2 | 4 | 5 | 28862 | 3 | |
22240 | 26182 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 490 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X3 | Permit Number 772904 | 6002306.27174 | 2105387.04682 | 37.7611219705289 | -122.435136045518 | (37.7611219705289, -122.435136045518) | 15 | 4 | 5 | 28862 | 3 | ||
22257 | 197762 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 967 Natoma St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6008013.25237 | 2109878.84045 | 37.7737778014386 | -122.41571605105 | (37.7737778014386, -122.41571605105) | 8 | 2 | 9 | 28853 | 34 | |||
22358 | 246279 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 344 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002908.8621 | 2106176.8563 | 37.7633247958374 | -122.433108379022 | (37.7633247958374, -122.433108379022) | 15 | 4 | 5 | 28862 | 3 | |||
22473 | 37940 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 728 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2003 12:00:00 AM | 12 | Permit Number 46514 | 6015675.91863 | 2103966.98263 | 37.7579728963479 | -122.388796638862 | (37.7579728963479, -122.388796638862) | 10 | 3 | 8 | 28856 | 29 | |
22645 | 245357 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 31 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004081.16198 | 2105083.00593 | 37.7603877729869 | -122.428975785716 | (37.7603877729869, -122.428975785716) | 2 | 4 | 5 | 28862 | 3 | |||
23529 | 109139 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 741 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773383 | 5985366.92656 | 2110801.55292 | 37.7750122304906 | -122.494120186238 | (37.7750122304906, -122.494120186238) | 11 | 6 | 2 | 55 | 26 |
23803 | 245362 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 407 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002351.10882 | 2105711.87815 | 37.7620164245478 | -122.435004205785 | (37.7620164245478, -122.435004205785) | 15 | 4 | 5 | 28862 | 3 | |||
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 | |
24084 | 245269 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 207 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007122.3181 | 2096929.85321 | 37.7381727341921 | -122.417879856797 | (37.7381727341921, -122.417879856797) | 2 | 7 | 7 | 28859 | 2 | |||
24505 | 179621 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010365.10231 | 2091621.97451 | 37.7237803852281 | -122.406293990689 | (37.7237803852281, -122.406293990689) | 10 | 3 | 7 | 309 | 28 | |||
25066 | 142875 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1178 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 6006878.3822 | 2114950.2065 | 37.7876386810883 | -122.420001713925 | (37.7876386810883, -122.420001713925) | 13 | 9 | 10 | 28858 | 21 | |||
25359 | 245301 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 32 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003675.41677 | 2096604.34377 | 37.7370843710543 | -122.429774312644 | (37.7370843710543, -122.429774312644) | 2 | 7 | 5 | 63 | 7 | |||
25868 | 87525 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2600 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6011029.3764 | 2093400.1095 | 37.7286999109797 | -122.404122775515 | (37.7286999109797, -122.404122775515) | 10 | 3 | 7 | 309 | 28 | |||
26092 | 114847 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2200 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002442.62774 | 2118155.32308 | 37.7961881963905 | -122.435577919296 | (37.7961881963905, -122.435577919296) | 13 | 9 | 1 | 57 | 17 | |||
26447 | 42664 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 780 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2011 12:00:00 AM | 6 | Permit Number 768090 | 6007065.06318 | 2121240.35517 | 37.8049203715397 | -122.419802335728 | (37.8049203715397, -122.419802335728) | 5 | 1 | 1 | 28858 | 32 | ||
26945 | 142848 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1305 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006765.7864 | 2115397.4815 | 37.7888604436235 | -122.420423033997 | (37.7888604436235, -122.420423033997) | 13 | 9 | 10 | 28858 | 21 | ||
27267 | 73457 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009719.27808 | 2110896.03825 | 37.7766665443529 | -122.40988643061 | (37.7766665443529, -122.40988643061) | 8 | 2 | 9 | 28853 | 34 | ||
27271 | 50760 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47299 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
27864 | 142847 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006787.7441 | 2115244.9809 | 37.7884429519581 | -122.420336234883 | (37.7884429519581, -122.420336234883) | 13 | 9 | 10 | 28858 | 21 | |||
28052 | 103841 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1545 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006617.6 | 2116265.9 | 37.7912365537909 | -122.420997422968 | (37.7912365537909, -122.420997422968) | 13 | 9 | 10 | 28858 | 21 | ||
28707 | 50621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 820 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47218 | 6019242.65386152 | 2094476.11509562 | 37.7321099088197 | -122.375803212343 | (37.7321099088197, -122.375803212343) | 10 | 3 | 8 | 58 | 1 | |||
29214 | 142860 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1034 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6006934.3072 | 2114548.914 | 37.7865399811377 | -122.419779738746 | (37.7865399811377, -122.419779738746) | 13 | 9 | 9 | 28858 | 36 | |||
30690 | 245342 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 970 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003109.09048 | 2102570.15873 | 37.753433023323 | -122.432158272384 | (37.753433023323, -122.432158272384) | 2 | 4 | 5 | 28862 | 22 | |||
31156 | 26197 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 519 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | Permit Number 772904 | 6002381.63954 | 2105165.88105 | 37.7605189822794 | -122.434859564238 | (37.7605189822794, -122.434859564238) | 2 | 4 | 5 | 28862 | 3 | ||
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 |
33462 | 245260 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 178 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6004796.85539 | 2098734.84829 | 37.7429976931945 | -122.426048612058 | (37.7429976931945, -122.426048612058) | 2 | 7 | 5 | 63 | 22 | |||
33501 | 197788 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2056 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011954.13771 | 2104694.98029 | 37.7597648350875 | -122.401719379549 | (37.7597648350875, -122.401719379549) | 10 | 3 | 8 | 28856 | 29 | |||
33700 | 245246 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 68 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005362.43009 | 2103338.82468 | 37.755671101354 | -122.424420407495 | (37.755671101354, -122.424420407495) | 2 | 4 | 5 | 28859 | 19 | |||
34667 | 197775 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1555 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012572.98246 | 2106081.16458 | 37.7636055050056 | -122.399676416648 | (37.7636055050056, -122.399676416648) | 14 | 3 | 8 | 28856 | 29 | |||
35207 | 245324 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1139 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009488.18332 | 2102546.37168 | 37.7537273210842 | -122.410096245168 | (37.7537273210842, -122.410096245168) | 2 | 4 | 7 | 28859 | 19 | |||
35734 | 225141 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Albion St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005929.72911 | 2106381.16026 | 37.7640566615994 | -122.422674693899 | (37.7640566615994, -122.422674693899) | 8 | 4 | 5 | 28859 | 19 | |||
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 | |||
36408 | 83343 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50763 | 6011023.37395305 | 2119422.18641329 | 37.8001503184077 | -122.405975934235 | (37.8001503184077, -122.405975934235) | 3 | 1 | 10 | 308 | 23 | ||
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 | ||
37196 | 245249 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 204 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6005411.18534 | 2102480.95785 | 37.7533183516659 | -122.424190788097 | (37.7533183516659, -122.424190788097) | 2 | 4 | 5 | 28859 | 19 | |||
37524 | 246483 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 338 Duncan St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6004093.31065 | 2099866.86007 | 37.7460661485508 | -122.428561950981 | (37.7460661485508, -122.428561950981) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
38043 | 245343 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 998 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003112.4322 | 2102492.99553 | 37.7532213409162 | -122.432141205965 | (37.7532213409162, -122.432141205965) | 2 | 4 | 5 | 28862 | 22 | |||
38214 | 245363 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 511 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002381.78952 | 2105193.34277 | 37.7605943940349 | -122.434861009453 | (37.7605943940349, -122.434861009453) | 2 | 4 | 5 | 28862 | 3 | |||
38249 | 103855 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1489 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006726.68698 | 2115849.48669 | 37.7900993346467 | -122.420590411881 | (37.7900993346467, -122.420590411881) | 13 | 9 | 10 | 28858 | 21 | ||
38527 | 245248 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3434 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005494.2746 | 2103157.83673 | 37.7551815949762 | -122.423951577411 | (37.7551815949762, -122.423951577411) | 2 | 4 | 5 | 28859 | 19 | |||
38602 | 28716 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 588 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002337.13955 | 2104792.27663 | 37.7594906282039 | -122.434986749035 | (37.7594906282039, -122.434986749035) | 2 | 4 | 5 | 28862 | 3 | |
39234 | 51943 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3724 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | Permit Number 48168 | 6004898.66350081 | 2102543.97492913 | 37.7534624298516 | -122.425967681323 | (37.7534624298516, -122.425967681323) | 2 | 4 | 5 | 28862 | 22 | |||
39651 | 142885 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1100 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006912.0707 | 2114700.1497 | 37.7869539845455 | -122.419867407304 | (37.7869539845455, -122.419867407304) | 13 | 9 | 10 | 28858 | 21 | |||
40135 | 245257 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 941 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004404.53207 | 2103435.24181 | 37.7558817009973 | -122.427739992226 | (37.7558817009973, -122.427739992226) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
41666 | 240875 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3498 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6006590.99439 | 2100878.65509 | 37.7489853398132 | -122.419997058715 | (37.7489853398132, -122.419997058715) | 2 | 4 | 7 | 28859 | 19 | |||
41912 | 136569 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2617 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008276.62811 | 2122005.04702 | 37.8070881999362 | -122.415663746486 | (37.8070881999362, -122.415663746486) | 5 | 1 | 10 | 308 | 23 | |||
43359 | 240995 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 44 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004448.94888 | 2107518.77636 | 37.7670966273258 | -122.427877346558 | (37.7670966273258, -122.427877346558) | 8 | 4 | 5 | 28862 | 3 | |||
43365 | 245279 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3257 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006552.94667 | 2103757.73548 | 37.7568884902353 | -122.420332948315 | (37.7568884902353, -122.420332948315) | 2 | 4 | 7 | 28859 | 19 | |||
44241 | 245344 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1005 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 16 | Width 3ft | Permit Number 45840 | 6003175.28861 | 2102361.95423 | 37.7528650960514 | -122.431914479684 | (37.7528650960514, -122.431914479684) | 2 | 4 | 5 | 28862 | 22 | |
45626 | 147329 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 565 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5988421.62251 | 2112156.47459 | 37.7789107377833 | -122.483652819623 | (37.7789107377833, -122.483652819623) | 11 | 6 | 2 | 55 | 26 | |||
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 | |
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 | |
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 |
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) );