trees
858 rows where qSpecies_id = 85 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
849 | 51822 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008911.92726 | 2109811.9687 | 37.7736446648878 | -122.412602652111 | (37.7736446648878, -122.412602652111) | 8 | 2 | 9 | 28853 | 34 | ||
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 | |||
1496 | 103826 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006957.18445 | 2114384.03926 | 37.7860885642674 | -122.419688886254 | (37.7860885642674, -122.419688886254) | 13 | 9 | 9 | 28858 | 36 | ||
2231 | 245261 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1350 Noe St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6003201.63898 | 2100380.79003 | 37.7474267787221 | -122.431681919499 | (37.7474267787221, -122.431681919499) | 2 | 4 | 5 | 63 | 22 | ||||
2254 | 245235 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 53 Dearborn St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005837.96271 | 2105774.17524 | 37.7623848461922 | -122.422948943959 | (37.7623848461922, -122.422948943959) | 8 | 4 | 5 | 28859 | 19 | |||
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 | |
3323 | 258079 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 606 Capp St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 6007262.82565 | 2103708.68672 | 37.7567937898158 | -122.417874439265 | (37.7567937898158, -122.417874439265) | 2 | 4 | 7 | 28859 | 19 | ||||
3332 | 259568 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 200 Public Park | 7 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
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 | |
4561 | 245236 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 53 Dearborn St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005838.90196 | 2105786.95682 | 37.7624199943988 | -122.422946603908 | (37.7624199943988, -122.422946603908) | 8 | 4 | 5 | 28859 | 19 | |||
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 | |||
6527 | 40000 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 14 | Permit Number 41257 | 6019376.91864 | 2094304.02926 | 37.7316447838739 | -122.375327100491 | (37.7316447838739, -122.375327100491) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
8080 | 75081 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 172 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 8x9 | 6010488.28034 | 2111342.37314 | 37.7779351433246 | -122.407257684389 | (37.7779351433246, -122.407257684389) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||
8387 | 240964 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 95 Eagle St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999841.6611 | 2104454.60365 | 37.7584214521056 | -122.443593061365 | (37.7584214521056, -122.443593061365) | 2 | 4 | 5 | 28862 | 3 | |||
8388 | 179624 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010352.88812 | 2091667.17419 | 37.7239038109035 | -122.406339396551 | (37.7239038109035, -122.406339396551) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
9268 | 245287 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 717 Duncan St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6001940.90402 | 2099694.09971 | 37.7454697460299 | -122.435992320586 | (37.7454697460299, -122.435992320586) | 2 | 7 | 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 | |||
11004 | 51713 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012693.61148 | 2110101.74925 | 37.7746518507372 | -122.399541492249 | (37.7746518507372, -122.399541492249) | 14 | 2 | 9 | 28856 | 20 | ||
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 | |
12232 | 240848 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009181.67793 | 2106295.69441 | 37.7640049263208 | -122.411421075131 | (37.7640049263208, -122.411421075131) | 8 | 4 | 7 | 28859 | 19 | ||||
12364 | 142864 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 POLK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6006888.1179 | 2114511.0898 | 37.7864335230518 | -122.419936857586 | (37.7864335230518, -122.419936857586) | 13 | 9 | 10 | 28858 | 36 | |||
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 | ||
12811 | 245270 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599X Ogden Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008504 | 2096098 | 37.7359663084052 | -122.413043870385 | (37.7359663084052, -122.413043870385) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||||
14590 | 142982 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2331 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008422.9305 | 2120909.8092 | 37.8040891760793 | -122.415079860656 | (37.8040891760793, -122.415079860656) | 5 | 1 | 10 | 308 | 23 | |||
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 | ||||
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 | |||
15296 | 49997 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.2211 | 2105187.35151 | 37.7612480878485 | -122.393598329713 | (37.7612480878485, -122.393598329713) | 10 | 3 | 8 | 28856 | 29 |
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 | |
16391 | 197750 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6012005.03317 | 2110833.59776 | 37.7766229335303 | -122.401974894942 | (37.7766229335303, -122.401974894942) | 14 | 2 | 9 | 28856 | 34 | |||
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 | |||
16960 | 179590 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Bishop St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010898.94901 | 2089680.08922 | 37.7184782153849 | -122.404311947847 | (37.7184782153849, -122.404311947847) | 10 | 7 | 8 | 309 | 39 | |||
17041 | 197764 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015565.1078 | 2103547.12613 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | 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 | |||
17588 | 245271 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599X Ogden Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008504 | 2096098 | 37.7359663084052 | -122.413043870385 | (37.7359663084052, -122.413043870385) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||||
18467 | 51710 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012671.60652 | 2110080.29176 | 37.7745917067712 | -122.399616105424 | (37.7745917067712, -122.399616105424) | 14 | 2 | 9 | 28856 | 20 | ||
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 | ||
20091 | 240883 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 499 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005534.08174 | 2107810.45937 | 37.7679588469372 | -122.424144778774 | (37.7679588469372, -122.424144778774) | 8 | 4 | 5 | 28853 | 19 | |||
20212 | 197797 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 315 Topeka Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6013586.21958 | 2094425.53729 | 37.731658057859 | -122.395355352274 | (37.731658057859, -122.395355352274) | 10 | 3 | 8 | 58 | 1 | |||
20363 | 103780 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1245 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006784.96564 | 2115238.8671 | 37.7884260084052 | -122.420345413822 | (37.7884260084052, -122.420345413822) | 13 | 9 | 10 | 28858 | 21 | ||
20367 | 52364 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1030@ CEDAR Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 8 | Permit Number 48499 | 6006935.64598 | 2114546.93824 | 37.7865346316038 | -122.419774966644 | (37.7865346316038, -122.419774966644) | 13 | 9 | 9 | 28858 | 36 | |
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 | |
20894 | 136529 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3601 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999666.6912 | 2120931.30198 | 37.8036522357126 | -122.445382888535 | (37.8036522357126, -122.445382888535) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||||
21194 | 245285 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 237 Murray St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6005655.37786 | 2095359.85954 | 37.7337792159359 | -122.422840265393 | (37.7337792159359, -122.422840265393) | 2 | 7 | 7 | 28861 | 2 | |||
21581 | 245234 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 53 Dearborn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005838.11402 | 2105765.07661 | 37.7623598720354 | -122.422947773934 | (37.7623598720354, -122.422947773934) | 8 | 4 | 5 | 28859 | 19 | |||
21710 | 240867 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1706 Dolores St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6005262.92873 | 2098348.03342 | 37.7419619179126 | -122.424409549065 | (37.7419619179126, -122.424409549065) | 2 | 7 | 5 | 63 | 7 | |||
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 |
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 | |||
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 | |||
22653 | 247213 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 800 Duboce Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001852.54114 | 2108296.01305 | 37.7690835031293 | -122.436913559108 | (37.7690835031293, -122.436913559108) | 15 | 5 | 5 | 29492 | 9 | |||
23221 | 131948 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2101 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | |||
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 |
23586 | 51714 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 14 | Permit Number 47987 | 6012645.95948 | 2110058.2702 | 37.7745298109235 | -122.399703277606 | (37.7745298109235, -122.399703277606) | 14 | 2 | 9 | 28856 | 20 | ||
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 | |||
24695 | 136564 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 780 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007032.14373 | 2121235.03543 | 37.8049039103473 | -122.419915879607 | (37.8049039103473, -122.419915879607) | 5 | 1 | 1 | 28858 | 32 | |||
24721 | 215166 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 491 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994735.18104 | 2099969.77075 | 37.7458146809981 | -122.460928368863 | (37.7458146809981, -122.460928368863) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
24859 | 103822 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1030 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.7 | 2114566.7 | 37.7865897969129 | -122.419720826278 | (37.7865897969129, -122.419720826278) | 13 | 9 | 9 | 28858 | 36 | ||
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 | |||
25201 | 199699 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2098 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015522.8982 | 2092787.4061 | 37.7272675999797 | -122.388545507017 | (37.7272675999797, -122.388545507017) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
25892 | 136559 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1200 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009435.38581 | 2117472.07438 | 37.794706848389 | -122.411333170001 | (37.794706848389, -122.411333170001) | 3 | 1 | 10 | 28857 | 4 |
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) );