897 rows where qSpecies_id = 160 sorted by PlantDate

View and edit SQL

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)
1012 24992 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 340 Dolores St 3 Median : Cutout Tree DPW 1     90 20   6004882.50848 2106257.62148 37.7636583150142 -122.426287928865 (37.7636583150142, -122.426287928865) 8 4 5 28859 3
1062 20065 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 STAIRWAY54 12 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
1174 259410 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 7 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
1493 264741 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 2040 Sutter St 2 Back Yard : Yard Tree Private 2           6002832.74822 2114456.05498 37.7860531044459 -122.433963466929 (37.7860531044459, -122.433963466929) 13 9 11 29490 27
1504 19794 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 STAIRWAY19 16 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
1611 247638 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 360 Bradford St 2 Sidewalk: Curb side : Yard Tree Private 2     15     6009465.98098 2096572.55437 37.7373232876386 -122.409751390215 (37.7373232876386, -122.409751390215) 10 7 7 28859 2
1681 132077 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1100x The Embarcadero 7 Median : Yard Tree DPW 1     23 Width 10ft   6012714.412 2120058.13658 37.8019909162964 -122.400168938451 (37.8019909162964, -122.400168938451) 3 1 10 28860 6
1977 132113 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1000x The Embarcadero 2 Median : Yard Tree DPW 1     21 Width 10ft   6013330.52243 2119204.92075 37.7996825238869 -122.397977001937 (37.7996825238869, -122.397977001937) 3 1 10 28860 6
2957 25027 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 740X Dolores St 2 Median : Cutout Tree DPW 1     80 20   6004958.5167563 2104022.9997464 37.7575268683213 -122.425865966748 (37.7575268683213, -122.425865966748) 2 4 5 28862 3
3088 261629 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 620x The Embarcadero 1 Sidewalk: Property side : Yard Tree DPW 1       3x3   6012640 2120258 37.8025355435841 -122.400440487668 (37.8025355435841, -122.400440487668) 3 1 10 28860 6
3537 18548 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 3 Median : Cutout Tree DPW 1     30 19   6014665.0129 2095058.69239 37.7334565140045 -122.391669970993 (37.7334565140045, -122.391669970993) 10 3 8 58 1
3603 247549 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 815 Buena Vista Ave West 6 Sidewalk: Property side : Yard Tree Private 2     32 Width 2ft   6000106.41756 2108406.30035 37.7692869261681 -122.442961199511 (37.7692869261681, -122.442961199511) 15 5 11 29492 9
4101 261179 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 205 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
4245 28231 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 399X King St 14 Sidewalk: Curb side : Cutout Tree DPW 1     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.396167417116 (37.7745060991794, -122.396167417116) 14 2 9 310 20
4408 234354 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 650x Dolores St 1 Median : Yard Tree DPW 1     23     6004979.81363 2104508.34972 37.7588607286626 -122.425826859935 (37.7588607286626, -122.425826859935) 2 4 5 28862 3
4436 194278 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1750 22nd St 7 Side Yard : Yard Tree Private 2     5     6012817.61072 2103799.38432 37.7573538722899 -122.398670182286 (37.7573538722899, -122.398670182286) 10 3 8 28856 29
4871 132103 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1400x The Embarcadero 1 Median : Yard Tree DPW 1     18 Width 10ft   6012095.78368 2120981.89347 37.8044928149639 -122.402374687645 (37.8044928149639, -122.402374687645) 3 1 10 28860 6
4941 186180 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984958.094 2103565.49 37.7551201057822 -122.495000731871 (37.7551201057822, -122.495000731871) 1 8 3 56 35
5116 25071 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1100X Dolores St 2 Median : Cutout Tree DPW 1     80 20   6005127.37654 2101840.69033 37.7515442968352 -122.42512670443 (37.7515442968352, -122.42512670443) 2 4 5 28862 22
6713 25016 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 710X Dolores St 1 Median : Cutout Tree DPW 1     70 20   6004949.2547318 2104210.5607703 37.7580413433618 -122.425911349448 (37.7580413433618, -122.425911349448) 2 4 5 28862 3
7075 25030 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 740X Dolores St 5 Median : Cutout Tree DPW 1     70 20   6004958.5167563 2104022.9997464 37.7575268683213 -122.425865966748 (37.7575268683213, -122.425865966748) 2 4 5 28862 3
7512 234395 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 599X Ogden Ave 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   6008504 2096098 37.7359663084052 -122.413043870385 (37.7359663084052, -122.413043870385) 10 7 7 28859 2
7561 178088 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201 Chicago Way 2 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 3ft   6003023.7628 2086943.78146 37.7105216991954 -122.431337972882 (37.7105216991954, -122.431337972882) 9 7 6 28861 5
8561 25119 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1500X Dolores St 6 Median : Cutout Tree DPW 1     30 20   6005258.69008 2099408.1764 37.7448725899054 -122.42449959639 (37.7448725899054, -122.42449959639) 2 7 5 63 22
9418 251108 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 2 Median : Yard Tree DPW 1                              
9423 25058 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1000X Dolores St 1 Median : Cutout Tree DPW 1     90 20   6005092.48697 2102458.1018 37.753237594342 -122.425291287561 (37.753237594342, -122.425291287561) 2 4 5 28862 22
9494 259411 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 1 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
9507 132129 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 500x The Embarcadero 9 Median : Yard Tree DPW 1     24 Width 10ft   6013671.61354 2118630.60451 37.7981245788406 -122.3967564088 (37.7981245788406, -122.3967564088) 3 1 10 28860 6
9676 194361 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380x The Embarcadero 8 Median : Yard Tree DPW 1     28 Width 8ft   6016114.70966 2114269.45463 37.7862855364823 -122.38799801482 (37.7862855364823, -122.38799801482) 6 2 9 28856 6
9755 194362 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380x The Embarcadero 9 Median : Yard Tree DPW 1     29 Width 8ft   6016123.07303 2114362.83881 37.786542411639 -122.387975598289 (37.786542411639, -122.387975598289) 6 2 9 28856 6
9943 25035 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 794X Dolores St 4 Median : Cutout Tree DPW 1     60 20   6004985.41588 2103704.6857762 37.7566543729812 -122.425750282521 (37.7566543729812, -122.425750282521) 2 4 5 28862 3
10155 251115 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 19 Median : Yard Tree DPW 1                              
11271 194293 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700x Quesada Ave 46 Median : Yard Tree DPW 1     28     6014318.79649 2095319.19207 37.7341525685742 -122.392885167337 (37.7341525685742, -122.392885167337) 10 3 8 58 1
11369 28185 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 299X King St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 6   6014324.7762427 2110655.258445 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457) 6 2 9 28856 20
12082 210917 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380 Kingston St 8 Sidewalk: Curb side : Yard Tree Private 2     37 Width 4ft   5994023.92221 2099259.09244 37.7438223849926 -122.463336219994 (37.7438223849926, -122.463336219994) 1 8 4 59 40
12278 259406 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 3 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
12845 259408 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 5 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
12943 246349 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2190x Market St 1 Median : Cutout Tree DPW 1     31 Width 0ft   6003723.2107 2107266.4094 37.7663626060268 -122.430369556243 (37.7663626060268, -122.430369556243) 8 4 5 28862 3
12966 251112 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 14 Median : Tree DPW 1                              
13313 251111 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 7 Median : Yard Tree DPW 1                              
13403 261178 Property Tree 8 Phoenix canariensis :: Canary Island Date Palm 160 205 Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
13831 251113 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 15 Median : Yard Tree DPW 1                              
14024 194292 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700x Quesada Ave 43 Median : Yard Tree DPW 1     38     6014354.24031 2095291.86255 37.7340794959614 -122.392760714642 (37.7340794959614, -122.392760714642) 10 3 8 58 1
14183 234399 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 319 Virginia Ave 5 Sidewalk: Curb side : Yard Tree Private 2     39 Width 3ft   6006918.01461 2098154.19018 37.7415229912067 -122.418673038125 (37.7415229912067, -122.418673038125) 2 7 7 28859 2
14706 118708 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 4201 Balboa St 5 Sidewalk: Property side : Yard Tree Private 2     18 Width 2ft   5982482.88801 2110969.6299 37.7753045397791 -122.504108985066 (37.7753045397791, -122.504108985066) 11 6 2 55 26
14999 233935 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 150x Dolores St 9 Median : Yard Tree DPW 1     30     6004826.52958 2107279.95522 37.7664622347806 -122.426554344032 (37.7664622347806, -122.426554344032) 8 4 5 28862 3
15348 264739 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 2040 Sutter St 1 Back Yard : Yard Tree Private 2           6002832.74822 2114456.05498 37.7860531044459 -122.433963466929 (37.7860531044459, -122.433963466929) 13 9 11 29490 27
15633 25139 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700X Dolores St 5 Median : Cutout Tree DPW 1     90 20   6005326.84877 2098252.91312 37.7417043484808 -122.424181770586 (37.7417043484808, -122.424181770586) 2 7 5 63 7
15958 251109 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 3 Median : Yard Tree DPW 1                              
15995 251116 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 20 Median : Yard Tree DPW 1                              
16115 194311 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380x The Embarcadero 3 Median : Yard Tree DPW 1     21 Width 7ft   6015171.22981 2116694.38601 37.7928915254696 -122.391431824244 (37.7928915254696, -122.391431824244) 12 2 9 28855 6
16199 259409 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 6 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
16208 194334 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 88x King St 10 Median : Yard Tree DPW 1     30 Width 8ft   6015942.04821 2112270.67914 37.7807877820727 -122.388455820993 (37.7807877820727, -122.388455820993) 6 2 9 28856 20
16574 25108 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1400 Dolores St 1 Median : Cutout Tree DPW 1     30 20   6005223.67149 2100130.84124 37.7468548845426 -122.424672082757 (37.7468548845426, -122.424672082757) 2 7 5 63 22
17335 24980 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 292 Dolores St 7 Median : Cutout Tree DPW 1     90 20   6004817.9533669 2106647.0197828 37.7647238606763 -122.426538934247 (37.7647238606763, -122.426538934247) 8 4 5 28862 3
17465 246342 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2020x Market St 4 Median : Cutout Tree DPW 1     30 Width 0ft   6004356.6072 2107872.2367 37.7680619198287 -122.428221935713 (37.7680619198287, -122.428221935713) 8 4 5 28862 3
18007 259314 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 2 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
18679 264760 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1501 Sunnydale Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007165 2087428 37.7120850908031 -122.417059211527 (37.7120850908031, -122.417059211527) 9 7 8 309 39
18870 259407 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 4 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
18928 25136 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700X Dolores St 2 Median : Cutout Tree DPW 1     90 20   6005320.97591 2098341.7574 37.7419479631307 -122.424208394127 (37.7419479631307, -122.424208394127) 2 7 5 63 7
18950 25113 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1400 Dolores St 6 Median : Cutout Tree DPW 1     30 20   6005228.94357 2100007.06865 37.7465153311328 -122.424645049125 (37.7465153311328, -122.424645049125) 2 7 5 63 22
19170 251114 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 16 Median : Yard Tree DPW 1                              
19478 251110 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 5 Median : Yard Tree DPW 1                              
19729 25157 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2X Dolores St 5 Median : Cutout Tree DPW 1     90 20   6004782.44605 2108032.94108 37.7685272607631 -122.426760449752 (37.7685272607631, -122.426760449752) 8 4 5 28862 3
19829 23674 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 319 Virginia Ave 3 Median : Cutout Tree DPW 1     3 12   6006936.2458165 2098250.5638735 37.741788638282 -122.418616833275 (37.741788638282, -122.418616833275) 2 7 7 28859 2
19989 234338 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 420 Dolores St 19 Sidewalk: Property side : Yard Tree Private 2     37 Width 3ft   6004867.72819 2105514.52686 37.7616171183661 -122.426286140092 (37.7616171183661, -122.426286140092) 8 4 5 28862 3
20118 173670 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 251x Lathrop Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012236 2086860 37.7108094381203 -122.399492405366 (37.7108094381203, -122.399492405366) 10 3 8 309 1
20141 132092 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1500x The Embarcadero 12 Median : Yard Tree DPW 1     20 Width 10ft   6011191.46105 2121714.36376 37.806453474602 -122.405555813649 (37.806453474602, -122.405555813649) 3 1 10 308 23
20323 210923 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1540 Plymouth Ave 2 Sidewalk: Curb side : Yard Tree Private 2     41 Width 3ft   5995839.22139 2094293.33064 37.7302920326405 -122.456700326779 (37.7302920326405, -122.456700326779) 9 7 4 28861 40
20670 24996 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 400X Dolores St 1 Median : Cutout Tree DPW 1     90 20   6004898.74738 2105973.30508 37.7628785677218 -122.42621152066 (37.7628785677218, -122.42621152066) 8 4 5 28859 3
20723 28232 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 399X King St 15 Sidewalk: Curb side : Cutout Tree DPW 1     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.396167417116 (37.7745060991794, -122.396167417116) 14 2 9 310 20
20887 210907 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1009 Kirkham St 1 Sidewalk: Curb side : Pot Tree Private 2     32 Width 3ft   5991740.69924 2105187.89339 37.7599695243799 -122.471662958305 (37.7599695243799, -122.471662958305) 1 8 4 56 12
20896 187504 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 Walbridge St 10 Front Yard : Yard Tree Private 2     9     6005101.69485 2086503.71935 37.7094309267755 -122.424124907354 (37.7094309267755, -122.424124907354) 9 7 6 309 5
21114 28183 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 299X King St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 6   6014324.7762427 2110655.258445 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457) 6 2 9 28856 20
21370 25043 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 892X Dolores St 8 Median : Cutout Tree DPW 1     90 20   6005007.5951373 2103153.9131268 37.7551433335372 -122.425634379859 (37.7551433335372, -122.425634379859) 2 4 5 28862 22
21377 210922 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380 Kingston St 1 Sidewalk: Curb side : Yard Tree Private 2     39 Width 4ft   5994038.37723 2099205.21989 37.7436752972852 -122.463282329909 (37.7436752972852, -122.463282329909) 1 8 4 59 40
21737 233937 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 230x Dolores St 3 Median : Yard Tree DPW 1     32     6004843.94175 2106947.59382 37.7655506342911 -122.426470450778 (37.7655506342911, -122.426470450778) 8 4 5 28862 3
21739 25033 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 700X Dolores St 1 Median : Cutout Tree DPW 1     70 20   6004995.41159 2104224.22732 37.7580814768833 -122.425752691957 (37.7580814768833, -122.425752691957) 2 4 5 28862 3
21756 28219 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 399X King St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.396167417116 (37.7745060991794, -122.396167417116) 14 2 9 310 20
21850 143058 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 426 GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 Width 0ft   6010776.1378 2120354.2833 37.8026957973236 -122.406897202115 (37.8026957973236, -122.406897202115) 3 1 10 308 23
22076 234356 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 650x Dolores St 3 Median : Yard Tree DPW 1     22     6004985.93046 2104422.99085 37.7586266989802 -122.425799629353 (37.7586266989802, -122.425799629353) 2 4 5 28862 3
22376 194392 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 860x Jamestown Ave 5 Median : Cutout Tree DPW 1     17 Width 5ft   6014755.05221 2089115.57759 37.7171429037943 -122.390943451878 (37.7171429037943, -122.390943451878) 10 3 8 58 1
22504 96822 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 610X Dolores St 2 Median : Cutout Tree DPW 1     24 20x225   6004926.4 2104659.4 37.7592724584905 -122.426022342006 (37.7592724584905, -122.426022342006) 2 4 5 28862 3
22545 28193 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 299X King St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 6   6014324.7762427 2110655.258445 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457) 6 2 9 28856 20
23067 100537 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2010X Market St 1 Median : Cutout Tree DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
23344 194391 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 828x Jamestown Ave 4 Median : Cutout Tree DPW 1     19 Width 5ft   6014866.8225 2088973.55401 37.7167591360948 -122.390547193499 (37.7167591360948, -122.390547193499) 10 3 8 58 1
23418 248619 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1801x Market St 1 Median : Cutout Tree DPW 1     25 Width 0ft   6005765.0052 2109117.0426 37.7715594473913 -122.423438937501 (37.7715594473913, -122.423438937501) 8 2 5 28853 19
23431 132080 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1100x The Embarcadero 13 Median : Yard Tree DPW 1     26 Width 10ft   6012562.54875 2120282.53748 37.802598598112 -122.400710234101 (37.802598598112, -122.400710234101) 3 1 10 28860 6
23782 194377 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 310x The Embarcadero 14 Median : Yard Tree DPW 1     28 Width 8ft   6016027.16358 2115370.7776 37.7893046685309 -122.388377800289 (37.7893046685309, -122.388377800289) 6 2 9 28855 6
23966 25090 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1250X Dolores St 5 Median : Cutout Tree DPW 1     90 20   6005182.99372 2100845.43458 37.7488146961375 -122.424863573617 (37.7488146961375, -122.424863573617) 2 4 5 28859 22
24405 210906 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1113 Kirkham St 3 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   5991529.16752 2105177.12145 37.7599277068135 -122.472393751863 (37.7599277068135, -122.472393751863) 1 8 4 56 12
25166 194288 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700x Quesada Ave 37 Median : Yard Tree DPW 1     34     6014411.93404 2095259.01392 37.7339925045513 -122.392558950849 (37.7339925045513, -122.392558950849) 10 3 8 58 1
25284 194337 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 88x King St 13 Median : Yard Tree DPW 1     29 Width 8ft   6015953.29851 2112409.57048 37.7811697700143 -122.388426597522 (37.7811697700143, -122.388426597522) 6 2 9 28856 20
25303 194388 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1031 Key Ave 3 Sidewalk: Curb side : Yard Tree Private 2     40     6013107.94825 2089911.65871 37.7192372512804 -122.396692522765 (37.7192372512804, -122.396692522765) 10 3 8 58 1
25464 18556 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 11 Median : Cutout Tree DPW 1     30 19   6014603.96741 2095108.67042 37.7335903547148 -122.391884517749 (37.7335903547148, -122.391884517749) 10 3 8 58 1
25582 25084 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1200X Dolores St 4 Median : Cutout Tree DPW 1     90 20   6005164.22411 2101175.53736 37.7497200220711 -122.424951961675 (37.7497200220711, -122.424951961675) 2 4 5 28859 22
26231 28190 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 299X King St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 6   6014324.7762427 2110655.258445 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457) 6 2 9 28856 20
26765 234393 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1557 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003994.29589 2099192.81462 37.7442097715744 -122.42885628561 (37.7442097715744, -122.42885628561) 2 7 5 63 22
27019 51202 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 567 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47573 6003673.55383836 2104968.22861825 37.7600495413778 -122.43037732339 (37.7600495413778, -122.43037732339) 2 4 5 28862 3
27236 194306 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 500 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6014568.03404 2117229.07965 37.7943261725661 -122.393556366426 (37.7943261725661, -122.393556366426) 12 2 10 28855 6

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