trees
858 rows where qSpecies_id = 85 sorted by qLegalStatus_id 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 | ||
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 | |
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
38177 | 36048 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | 3x3 | Permit Number 49634 | 6008358.98035191 | 2106192.95330852 | 37.7636766447114 | -122.414259282291 | (37.7636766447114, -122.414259282291) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
39646 | 93672 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 80 Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53291 | 6013405 | 2106710 | 37.7653784929972 | -122.396842798823 | (37.7653784929972, -122.396842798823) | 14 | 3 | 8 | 28856 | 20 | |||
40405 | 48612 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 201 Ulloa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.455861320442 | (37.7434052350482, -122.455861320442) | 1 | 5 | 4 | 59 | 40 | ||
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 | |||
41579 | 87854 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 330 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50765 | 6006363.5 | 2097928.1 | 37.7408709626282 | -122.42057431814 | (37.7408709626282, -122.42057431814) | 2 | 7 | 7 | 28859 | 2 | ||
45555 | 47535 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1242 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51815 | 6004449.94033609 | 2101659.83008367 | 37.7510094045374 | -122.427456480608 | (37.7510094045374, -122.427456480608) | 2 | 4 | 5 | 28862 | 22 | ||
45740 | 36047 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | 3x3 | Permit Number 49634 | 6008358.98035191 | 2106192.95330852 | 37.7636766447114 | -122.414259282291 | (37.7636766447114, -122.414259282291) | 8 | 4 | 7 | 28859 | 19 | ||
46814 | 51711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47987 | 6012686.20544956 | 2110082.45661085 | 37.7745984647237 | -122.399565756547 | (37.7745984647237, -122.399565756547) | 14 | 2 | 9 | 28856 | 20 | |||
47458 | 113229 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1150 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | 13 | 9 | 10 | 28858 | 21 | ||||
49931 | 50761 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 2 | 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 | |||
55030 | 116917 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 252 HERMANN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6004064 | 2108728 | 37.7703950777069 | -122.429295062823 | (37.7703950777069, -122.429295062823) | 7 | 9 | 11 | 29492 | 10 | ||||
58557 | 95102 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2200 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5999690 | 2120891 | 37.8035429078816 | -122.445299328106 | (37.8035429078816, -122.445299328106) | 13 | 9 | 1 | 57 | 17 | ||||
61990 | 40622 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
62992 | 103798 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1157 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
63657 | 51599 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1288 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47893 | 6002992.45198434 | 2111708.96678382 | 37.7785193529519 | -122.433214576841 | (37.7785193529519, -122.433214576841) | 15 | 9 | 11 | 29490 | 41 | |||
67452 | 46436 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 160 Corwin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2002 12:00:00 AM | Permit Number 44654 | 6000678.81028631 | 2104119.18809943 | 37.7575481921194 | -122.44067377633 | (37.7575481921194, -122.44067377633) | 2 | 4 | 5 | 28862 | 38 | |||
68638 | 57152 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | Permit Number 53479 | 6007084.13005826 | 2107360.24310609 | 37.7668100557647 | -122.41875139025 | (37.7668100557647, -122.41875139025) | 8 | 4 | 7 | 28853 | 19 | |||
71401 | 48528 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 350(REVISED) Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45846 | 6002907.64330557 | 2106199.19589491 | 37.763386065819 | -122.433114190665 | (37.763386065819, -122.433114190665) | 15 | 4 | 5 | 28862 | 3 | |||
72524 | 99310 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007548.2 | 2113343.2 | 37.7832639475046 | -122.417570329335 | (37.7832639475046, -122.417570329335) | 7 | 9 | 9 | 28852 | 36 | ||||
76354 | 28703 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3004 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011599.0463446 | 2091533.093888 | 37.7236052850781 | -122.402022182135 | (37.7236052850781, -122.402022182135) | 10 | 3 | 7 | 309 | 28 | ||
76561 | 96527 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 206 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 56866 | 6005415 | 2102506 | 37.7533873269869 | -122.424179377033 | (37.7533873269869, -122.424179377033) | 2 | 4 | 5 | 28859 | 19 | |||
83699 | 83705 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 358 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50603 | 6006700.55316292 | 2104029.56637849 | 37.7576431915581 | -122.419841757163 | (37.7576431915581, -122.419841757163) | 2 | 4 | 7 | 28859 | 19 | ||
86288 | 24937 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2591 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | 16 | 3X3 | 6011042.03793 | 2093526.3228 | 37.7290471738075 | -122.404087882402 | (37.7290471738075, -122.404087882402) | 10 | 3 | 7 | 309 | 28 | ||
92078 | 103819 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006925.9 | 2114751.5 | 37.7870957589339 | -122.41982320605 | (37.7870957589339, -122.41982320605) | 13 | 9 | 10 | 28858 | 21 | ||
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 | ||
94918 | 61868 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1352 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 21908 | 6010316.20997421 | 2101337.00017342 | 37.7504530304494 | -122.407147486405 | (37.7504530304494, -122.407147486405) | 2 | 4 | 7 | 28859 | 19 | ||
101290 | 69866 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 42 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52372 | 6018792.25966014 | 2094248.90737336 | 37.7314612388187 | -122.377344581888 | (37.7314612388187, -122.377344581888) | 10 | 3 | 8 | 58 | 1 | ||
104338 | 34980 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 204 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | 6 | 4.5x6 | Permit Number 38560 | 6005404.47969691 | 2102506.81993306 | 37.7533889843192 | -122.424215816798 | (37.7533889843192, -122.424215816798) | 2 | 4 | 5 | 28859 | 19 | |
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 | ||
107465 | 58887 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 970 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50451 | 6003109.65492005 | 2102587.69576047 | 37.7534812078562 | -122.432157572723 | (37.7534812078562, -122.432157572723) | 2 | 4 | 5 | 28862 | 22 | ||
109417 | 87526 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2602 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6011024.729699 | 2093421.52877 | 37.7287584641902 | -122.40414034637 | (37.7287584641902, -122.40414034637) | 10 | 3 | 7 | 309 | 28 | |||
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 | |
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 | ||
114281 | 93116 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 397 San Jose Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 02/02/2010 12:00:00 AM | Permit 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | 2 | 4 | 5 | 28859 | 19 | |||
115412 | 45711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1202X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066 | 2116562 | 37.7921311104068 | -122.416006962529 | (37.7921311104068, -122.416006962529) | 5 | 1 | 10 | 28858 | 21 | |
118400 | 64083 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 180 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | 3x3 | Permit Number 25061 | 6004796 | 2098747 | 37.7430310106703 | -122.426052434635 | (37.7430310106703, -122.426052434635) | 2 | 7 | 5 | 63 | 22 | |
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 | |||
121058 | 59216 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 42 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1983 12:00:00 AM | 16 | 3x3 | Permit Number 20726 | 6004445.43179676 | 2107524.22878238 | 37.7671113993979 | -122.427889900178 | (37.7671113993979, -122.427889900178) | 8 | 4 | 5 | 28862 | 3 | |
121866 | 93030 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 45 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
123485 | 40625 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
123957 | 44025 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 924 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2000 12:00:00 AM | Permit Number 43565 | 6008561.50966714 | 2103154.02648323 | 37.7553438203715 | -122.413343872305 | (37.7553438203715, -122.413343872305) | 2 | 4 | 7 | 28859 | 19 | |||
125192 | 50170 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 256 16th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2003 12:00:00 AM | Permit Number 46881 | 5990896.23441717 | 2113690.84424492 | 37.7832674231585 | -122.475204285437 | (37.7832674231585, -122.475204285437) | 11 | 6 | 2 | 54 | 26 | |||
125303 | 45777 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2001 12:00:00 AM | Permit Number 44419 | 6006888.64433858 | 2114502.25167433 | 37.7864092853866 | -122.419934408834 | (37.7864092853866, -122.419934408834) | 13 | 9 | 10 | 28858 | 36 | |||
127738 | 51712 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47987 | 6012686.20544956 | 2110082.45661085 | 37.7745984647237 | -122.399565756547 | (37.7745984647237, -122.399565756547) | 14 | 2 | 9 | 28856 | 20 | |||
129611 | 63522 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 812 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24132 | 6009881.10701644 | 2104476.66274978 | 37.759049483001 | -122.4088735989 | (37.759049483001, -122.4088735989) | 2 | 4 | 7 | 28859 | 19 | ||
129768 | 56463 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 495 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005502.51915575 | 2107805.81880506 | 37.7679443229226 | -122.424253620258 | (37.7679443229226, -122.424253620258) | 8 | 4 | 5 | 28853 | 19 | |||||
133879 | 103807 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1145 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
135628 | 103812 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006831.1 | 2114737.7 | 37.787052526526 | -122.420150214034 | (37.787052526526, -122.420150214034) | 13 | 9 | 10 | 28858 | 21 | ||
136059 | 50171 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 256 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2003 12:00:00 AM | Permit Number 46881 | 5990896.23441717 | 2113690.84424492 | 37.7832674231585 | -122.475204285437 | (37.7832674231585, -122.475204285437) | 11 | 6 | 2 | 54 | 26 | |||
136272 | 103799 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1157 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
138759 | 40621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
141254 | 92895 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009778 | 2109505 | 37.7728503689602 | -122.409585091202 | (37.7728503689602, -122.409585091202) | 14 | 2 | 9 | 28853 | 34 | |||||
144566 | 51861 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 91 Wool St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2005 12:00:00 AM | Permit Number 48120 | 6007415.86132508 | 2097804.20610527 | 37.7405900296033 | -122.416926859077 | (37.7405900296033, -122.416926859077) | 2 | 7 | 7 | 28859 | 2 | |||
144883 | 47534 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1242 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51815 | 6004449.94033609 | 2101659.83008367 | 37.7510094045374 | -122.427456480608 | (37.7510094045374, -122.427456480608) | 2 | 4 | 5 | 28862 | 22 | ||
146295 | 112455 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 4299X 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000874 | 2105811 | 37.7622046070719 | -122.440120047168 | (37.7622046070719, -122.440120047168) | 15 | 5 | 5 | 28862 | 3 | ||||
149649 | 51862 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 91 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2005 12:00:00 AM | Permit Number 48120 | 6007415.86132508 | 2097804.20610527 | 37.7405900296033 | -122.416926859077 | (37.7405900296033, -122.416926859077) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | |||
156068 | 47766 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 6822ND ST Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2002 12:00:00 AM | Permit Number 45544 | 6005359.55978496 | 2103319.20105125 | 37.7556170573602 | -122.424428938199 | (37.7556170573602, -122.424428938199) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
158761 | 103808 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1145 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
161531 | 47765 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 6822ND ST Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2002 12:00:00 AM | Permit Number 45544 | 6005359.55978496 | 2103319.20105125 | 37.7556170573602 | -122.424428938199 | (37.7556170573602, -122.424428938199) | 2 | 4 | 5 | 28859 | 19 | |||
166728 | 99311 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007548.2 | 2113343.2 | 37.7832639475046 | -122.417570329335 | (37.7832639475046, -122.417570329335) | 7 | 9 | 9 | 28852 | 36 | ||||
168233 | 103813 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006831.1 | 2114737.7 | 37.787052526526 | -122.420150214034 | (37.787052526526, -122.420150214034) | 13 | 9 | 10 | 28858 | 21 | ||
170000 | 33564 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 330 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50765 | 6006381.57970099 | 2097942.21736521 | 37.7409107446577 | -122.420512807004 | (37.7409107446577, -122.420512807004) | 2 | 7 | 7 | 28859 | 2 | ||
174745 | 95627 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3271# A 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767394 | 6008383 | 2104448 | 37.7588867529802 | -122.414052751679 | (37.7588867529802, -122.414052751679) | 2 | 4 | 7 | 28859 | 19 | |
175585 | 113230 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1150 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | 13 | 9 | 10 | 28858 | 21 | ||||
178412 | 51591 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 244 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2016 12:00:00 AM | 3 | Permit Number 778163 | 6004105.53378334 | 2108740.61800809 | 37.7704320749507 | -122.429152297233 | (37.7704320749507, -122.429152297233) | 7 | 9 | 11 | 29492 | 10 | ||
179599 | 78996 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 4299X 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 56960 | 6000874 | 2105811 | 37.7622046070719 | -122.440120047168 | (37.7622046070719, -122.440120047168) | 15 | 5 | 5 | 28862 | 3 | |||
179646 | 40623 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
180228 | 104631 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2350 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2013 12:00:00 AM | 3x3 | Permit Number 770599 | 6010469.4 | 2095032.4 | 37.7331505320264 | -122.406173611635 | (37.7331505320264, -122.406173611635) | 10 | 3 | 7 | 309 | 28 | ||
182993 | 45710 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1202X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066 | 2116562 | 37.7921311104068 | -122.416006962529 | (37.7921311104068, -122.416006962529) | 5 | 1 | 10 | 28858 | 21 | |
185147 | 63948 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2007 12:00:00 AM | Permit No. 49233 | 6007549.75522386 | 2113332.29045601 | 37.7832340800522 | -122.417564175407 | (37.7832340800522, -122.417564175407) | 7 | 9 | 9 | 28852 | 36 | ||
187370 | 98583 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3X Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/29/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768693 | 5995785.9 | 2114444.5 | 37.7856189504109 | -122.458342670912 | (37.7856189504109, -122.458342670912) | 11 | 6 | 1 | 54 | 31 | |
191646 | 112456 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 4299X 17TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000874 | 2105811 | 37.7622046070719 | -122.440120047168 | (37.7622046070719, -122.440120047168) | 15 | 5 | 5 | 28862 | 3 | ||||
193960 | 40624 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | 14 | 3x3 | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |
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 | ||||
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 | ||
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 | ||||
27985 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 6007603.98274 | 2103104.14442 | 37.7551530486792 | -122.416651764192 | (37.7551530486792, -122.416651764192) | 2 | 4 | 7 | 28859 | 19 | ||||
61723 | 111634 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 3009 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6009514.91537658 | 2100993.40768569 | 37.7494647260255 | -122.40989418187 | (37.7494647260255, -122.40989418187) | 2 | 4 | 7 | 28859 | 19 | |||
64719 | 253770 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 234 Carl St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 770677 | 5997066 | 2107091 | 37.7655016335596 | -122.453382820195 | (37.7655016335596, -122.453382820195) | 15 | 5 | 11 | 29492 | 12 | |||
67165 | 258067 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 833 York St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x3 | Permit Number 782335 | 6009933.30187 | 2104364.32189 | 37.758743943813 | -122.408685158341 | (37.758743943813, -122.408685158341) | 2 | 4 | 7 | 28859 | 19 | |||
108934 | 104726 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1079 Church St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770313 | 6004474.7 | 2102638.1 | 37.7536969056436 | -122.427440543051 | (37.7536969056436, -122.427440543051) | 2 | 4 | 5 | 28862 | 22 | ||||
193898 | 258078 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 606 Capp St | 2 | 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 | ||||
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 | ||||
48698 | 108284 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
56765 | 111767 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 4966 17th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5997580.2349427 | 2105651.04183436 | 37.7615773358373 | -122.45150033551 | (37.7615773358373, -122.45150033551) | 15 | 5 | 11 | 29492 | 9 | |||||
76253 | 104335 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1X Beaver St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002844 | 2106791 | 37.7650074058753 | -122.433376604069 | (37.7650074058753, -122.433376604069) | 15 | 5 | 5 | 28862 | 3 | ||||
78904 | 98227 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 207 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Planted without permit; 2' away from sewer line. | 6007132 | 2097003 | 37.7383741239705 | -122.417851565085 | (37.7383741239705, -122.417851565085) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );