trees

858 rows where qSpecies_id = 85 sorted by DBH

✎ View and edit SQL

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)
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
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
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
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
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
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
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
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
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
40951 256130 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 3166 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008577.74529 2101575.59595 37.7510107173881 -122.413176115581 (37.7510107173881, -122.413176115581) 2 4 7 28859 19
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
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
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
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
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
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
69360 254892 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 4199 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6003642.63298 2094097.24722 37.7301985948914 -122.429708899543 (37.7301985948914, -122.429708899543) 9 7 6 28861 5
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
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
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
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
80046 104334 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 1X Beaver St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002844 2106791 37.7650074058753 -122.433376604069 (37.7650074058753, -122.433376604069) 15 5 5 28862 3
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
86596 253386 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 726 El Camino Del Mar 1 Front Yard : Cutout Tree Private 2           5986306 2114851 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158) 11 6 1 55 33
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
94083 120539 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 32 Landers St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004448.25188 2107581.7846 37.767269593348 -122.427884247566 (37.767269593348, -122.427884247566) 8 4 5 28862 3
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
102852 253387 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 726 El Camino Del Mar 2 Front Yard : Cutout Tree Private 2           5986306 2114851 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158) 11 6 1 55 33
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
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
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
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
123000 256782 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 2301 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006284 2118744 37.7980219841193 -122.422327817993 (37.7980219841193, -122.422327817993) 13 9 10 28858 32
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
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
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
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
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
164834 104333 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 1X Beaver St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002844 2106791 37.7650074058753 -122.433376604069 (37.7650074058753, -122.433376604069) 15 5 5 28862 3
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
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
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
180504 256781 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 2301 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006284 2118744 37.7980219841193 -122.422327817993 (37.7980219841193, -122.422327817993) 13 9 10 28858 32
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
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
191724 104336 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 1X Beaver St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002844 2106791 37.7650074058753 -122.433376604069 (37.7650074058753, -122.433376604069) 15 5 5 28862 3
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
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
70636 33147 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 2301 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 1   Permit Number 37372 5987301.0757 2099570.9968 37.7442891825609 -122.486604840877 (37.7442891825609, -122.486604840877) 1 8 3 29491 35
104684 245284 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 100 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006163.63049 2102542.62363 37.7535301285288 -122.421593052282 (37.7535301285288, -122.421593052282) 2 4 5 28859 19
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
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
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
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
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
28855 240986 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 2423 Market St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 8ft   6002082.38212 2105743.71018 37.7620885654527 -122.435935903446 (37.7620885654527, -122.435935903446) 15 4 5 28862 3
32439 136549 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 1160 Polk St 5 Sidewalk: Curb side : Pot Tree Private 2     10 Width 4ft   6006876.35083 2114950.02533 37.7876380691922 -122.420008729221 (37.7876380691922, -122.420008729221) 13 9 10 28858 21
35774 136578 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 145 Jefferson St 9 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6008572.42572 2122428.93464 37.808268711206 -122.414670090059 (37.808268711206, -122.414670090059) 3 1 10 308 23
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);