1,650 rows where qSpecies_id = 64 sorted by Neighborhoods (old) descending

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) ▲
1454 247689 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 4 : Tree Private 2     24 Width 4ft   5999999.2126 2108392.11953 37.7692418764422 -122.443330996248 (37.7692418764422, -122.443330996248) 15 5 11 29492 9
20241 247240 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 921 Buena Vista Ave West 1 : Tree Private 2     17 Width 3ft   6000040.78347 2108630.81284 37.7698996387736 -122.443204350999 (37.7698996387736, -122.443204350999) 15 5 11 29492 9
32003 59294 Permitted Site 7 Cordyline australis :: Dracena Palm 64 357 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/1980 12:00:00 AM     Permit Number 18631 5998269.35755712 2107529.98911826 37.7667758890994 -122.449252327047 (37.7667758890994, -122.449252327047) 15 5 11 29492 9
34186 245516 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 488 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5998580.17807 2106366.47399 37.7635989435521 -122.448093470362 (37.7635989435521, -122.448093470362) 15 5 11 29492 9
38121 245751 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 84 Potomac St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003098.63011 2108852.25726 37.7706815579485 -122.432643153555 (37.7706815579485, -122.432643153555) 15 5 5 29492 9
38273 111768 Undocumented 4 Cordyline australis :: Dracena Palm 64 4966 17th St 3 Sidewalk: Curb side : Pot Tree Private 2           5997580.2349427 2105651.04183436 37.7615773358373 -122.45150033551 (37.7615773358373, -122.45150033551) 15 5 11 29492 9
39472 247680 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 7 : Tree Private 2     20 Width 4ft   6000003.68623 2108741.82746 37.7702023415965 -122.443340644169 (37.7702023415965, -122.443340644169) 15 5 11 29492 9
39606 245601 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 864 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5999180.01188 2107317.83808 37.7662454217138 -122.446087276202 (37.7662454217138, -122.446087276202) 15 5 5 29492 9
42359 245523 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 905 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 4ft   5998705.66701 2106880.52171 37.7650175620334 -122.44769645293 (37.7650175620334, -122.44769645293) 15 5 11 29492 9
46824 245515 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 531 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   5998577.32035 2106117.70473 37.7629157223037 -122.448085441202 (37.7629157223037, -122.448085441202) 15 5 11 29492 9
47817 247687 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 2 : Tree Private 2     8 Width 4ft   6000002.20037 2108368.10077 37.7691760973366 -122.443318936326 (37.7691760973366, -122.443318936326) 15 5 11 29492 9
48403 245513 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 540 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5998620.5619 2106053.28646 37.7627413176776 -122.447931246146 (37.7627413176776, -122.447931246146) 15 5 11 29492 9
53117 247686 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 935 Buena Vista Ave West 4 : Tree Private 2     22 Width 4ft   6000019.72764 2108674.83291 37.7700193061664 -122.443280344631 (37.7700193061664, -122.443280344631) 15 5 11 29492 9
62801 247683 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 935 Buena Vista Ave West 1 : Tree Private 2     18 Width 3ft   6000009.45593 2108709.0713 37.7701127304395 -122.443318333778 (37.7701127304395, -122.443318333778) 15 5 11 29492 9
66227 247684 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 935 Buena Vista Ave West 2 : Tree Private 2     22 Width 3ft   6000012.39067 2108699.28919 37.7700860385779 -122.443307479866 (37.7700860385779, -122.443307479866) 15 5 11 29492 9
67033 245517 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 451 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5998521.27369 2106537.96789 37.764066455229 -122.448309551351 (37.764066455229, -122.448309551351) 15 5 11 29492 9
67423 247681 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 8 : Tree Private 2     20 Width 4ft   5999993.42938 2108726.41685 37.7701594430376 -122.443375015343 (37.7701594430376, -122.443375015343) 15 5 11 29492 9
67733 245518 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 71 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5998295.5906 2106843.13591 37.7648914644932 -122.449112105467 (37.7648914644932, -122.449112105467) 15 5 11 29492 9
71269 245521 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 5 Parnassus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5998664.3758 2106893.76883 37.7650515752896 -122.447840222145 (37.7650515752896, -122.447840222145) 15 5 11 29492 9
73911 254536 Significant Tree 6 Cordyline australis :: Dracena Palm 64 737 Buena Vista Ave West 2 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
78651 246184 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 789 Buena Vista Ave West 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5999946.1417 2108227.6327 37.7687872104282 -122.443502747941 (37.7687872104282, -122.443502747941) 15 5 11 29492 9
82323 247676 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 3 : Tree Private 2     10 Width 4ft   5999996.82032 2108772.17609 37.7702852797644 -122.443366573435 (37.7702852797644, -122.443366573435) 15 5 11 29492 9
85716 246168 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 783 Buena Vista Ave West 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5999937.6625 2108201.5894 37.7687152184948 -122.443530205739 (37.7687152184948, -122.443530205739) 15 5 11 29492 9
87282 247688 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 3 : Tree Private 2     10 Width 4ft   6000001.52357 2108377.48913 37.769201836821 -122.443321951756 (37.769201836821, -122.443321951756) 15 5 11 29492 9
89746 58598 Undocumented 4 Cordyline australis :: Dracena Palm 64 4966 17th St 1 Sidewalk: Curb side : Pot Tree Private 2   04/19/1979 12:00:00 AM     Permit Number 17804 5997580.2349427 2105651.04183436 37.7615773358373 -122.45150033551 (37.7615773358373, -122.45150033551) 15 5 11 29492 9
96035 247682 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 9 : Tree Private 2     22 Width 4ft   6000006.57165 2108721.28332 37.7701460970988 -122.443329187717 (37.7701460970988, -122.443329187717) 15 5 11 29492 9
103559 247691 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 6 : Tree Private 2     22 Width 4ft   5999995.4075 2108418.75948 37.7693148060665 -122.443346071586 (37.7693148060665, -122.443346071586) 15 5 11 29492 9
104255 245522 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 5 Parnassus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   5998685.66796 2106896.34677 37.7650598706385 -122.447766763732 (37.7650598706385, -122.447766763732) 15 5 11 29492 9
106249 247692 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 7 : Tree Private 2     14 Width 4ft   5999993.89921 2108430.07463 37.7693457886147 -122.443352101522 (37.7693457886147, -122.443352101522) 15 5 11 29492 9
109221 247675 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 2 : Tree Private 2     21 Width 4ft   5999994.72677 2108788.88509 37.7703310390855 -122.443375015355 (37.7703310390855, -122.443375015355) 15 5 11 29492 9
109694 245519 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 5 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5998639.42536 2106890.36045 37.7650407906107 -122.447926273781 (37.7650407906107, -122.447926273781) 15 5 11 29492 9
109929 254537 Significant Tree 6 Cordyline australis :: Dracena Palm 64 737 Buena Vista Ave West 3 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
111048 113744 Significant Tree 6 Cordyline australis :: Dracena Palm 64 909 ASHBURY ST 1 Front Yard : Cutout Tree Private 2       3x3   5999156 2107025 37.7654399906909 -122.44614926226 (37.7654399906909, -122.44614926226) 15 5 11 29492 9
112179 246927 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 357 Frederick St 2 : Tree Private 2     12 Width 3ft   5998272.3562 2107533.69147 37.7667862263357 -122.449242222052 (37.7667862263357, -122.449242222052) 15 5 11 29492 9
114553 247693 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 8 : Tree Private 2     13 Width 4ft   5999992.61936 2108443.98924 37.7693839216533 -122.443357528041 (37.7693839216533, -122.443357528041) 15 5 11 29492 9
119443 51417 Permitted Site 7 Cordyline australis :: Dracena Palm 64 5 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2004 12:00:00 AM     Permit Number 47742 5998697.89125775 2106894.30410502 37.7650549606092 -122.447724339473 (37.7650549606092, -122.447724339473) 15 5 11 29492 9
120767 245605 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 635 Buena Vista Ave West 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   5999820.90849 2107684.64891 37.7672891703973 -122.443896901848 (37.7672891703973, -122.443896901848) 15 5 5 29492 9
123682 247668 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 140 Divisadero St 2 : Tree Private 2     16 Width 3ft   6001938.07018 2108499.86475 37.7696480903062 -122.436632313225 (37.7696480903062, -122.436632313225) 15 5 5 29492 9
128534 247690 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 5 : Tree Private 2     21 Width 4ft   5999997.25349 2108406.91621 37.7692823926903 -122.443338835633 (37.7692823926903, -122.443338835633) 15 5 11 29492 9
130876 245604 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 635 Buena Vista Ave West 3 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5999823.64022 2107668.65868 37.767245421054 -122.443886304235 (37.767245421054, -122.443886304235) 15 5 5 29492 9
135611 245753 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 103 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003340.66664 2108610.48396 37.7700314308381 -122.431788680712 (37.7700314308381, -122.431788680712) 15 9 5 29492 9
136802 245602 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 946 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5999242.60522 2106861.47972 37.7649959504386 -122.44583795447 (37.7649959504386, -122.44583795447) 15 5 5 29492 9
136818 247685 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 935 Buena Vista Ave West 3 : Tree Private 2     13 Width 3ft   6000015.91456 2108684.28641 37.7700450456643 -122.443294213074 (37.7700450456643, -122.443294213074) 15 5 11 29492 9
145033 247679 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 6 : Tree Private 2     16 Width 4ft   6000001.9279 2108749.50236 37.7702233146713 -122.443347277551 (37.7702233146713, -122.443347277551) 15 5 11 29492 9
145298 247674 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 1 : Tree Private 2     21 Width 4ft   5999993.18967 2108798.81177 37.7703582075947 -122.443381045292 (37.7703582075947, -122.443381045292) 15 5 11 29492 9
146216 247558 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 1 : Tree Private 2     6 Width 4ft   6000004.98799 2108349.41741 37.7691249564843 -122.443307952002 (37.7691249564843, -122.443307952002) 15 5 11 29492 9
149839 245514 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 515 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5998567.3864 2106190.93853 37.7631162360541 -122.448125072537 (37.7631162360541, -122.448125072537) 15 5 11 29492 9
155406 247237 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 923 Buena Vista Ave West 1 : Tree Private 2     14 Width 3ft   6000029.91762 2108654.05945 37.7699628485306 -122.44324360552 (37.7699628485306, -122.44324360552) 15 5 11 29492 9
156594 245525 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 905 Clayton St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   5998712.46938 2106842.9153 37.7649146930734 -122.447670217929 (37.7649146930734, -122.447670217929) 15 5 11 29492 9
156859 247238 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 923 Buena Vista Ave West 2 : Tree Private 2     14 Width 3ft   6000033.92777 2108644.76792 37.7699375649926 -122.443229067086 (37.7699375649926, -122.443229067086) 15 5 11 29492 9
158699 245520 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 5 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5998659.49199 2106892.35959 37.765047426726 -122.447857012502 (37.765047426726, -122.447857012502) 15 5 11 29492 9
161533 247241 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 921 Buena Vista Ave West 2 : Tree Private 2     27 Width 3ft   6000047.51607 2108621.04619 37.7698732059058 -122.443180361598 (37.7698732059058, -122.443180361598) 15 5 11 29492 9
169532 94139 Permitted Site 7 Cordyline australis :: Dracena Palm 64 864 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53506 5999177 2107299 37.7661935250869 -122.446096338546 (37.7661935250869, -122.446096338546) 15 5 5 29492 9
176440 252990 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 52 Pierce St 1 Sidewalk: Property side : Cutout Tree Private 2       2x8   6002925 2108585 37.7699378868501 -122.433224642796 (37.7699378868501, -122.433224642796) 15 5 5 29492 9
177510 245524 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 905 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   5998710.43294 2106861.68994 37.7649661271206 -122.447678613073 (37.7649661271206, -122.447678613073) 15 5 11 29492 9
178258 245754 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 103 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003339.23771 2108603.67132 37.7700126439943 -122.43179313686 (37.7700126439943, -122.43179313686) 15 9 5 29492 9
180374 247678 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 5 : Tree Private 2     13 Width 4ft   6000000.32593 2108756.30606 37.7702419045662 -122.443353307504 (37.7702419045662, -122.443353307504) 15 5 11 29492 9
182480 245603 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1 Ashbury Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5999514.86648 2106994.77368 37.7653774842084 -122.44490585663 (37.7653774842084, -122.44490585663) 15 5 5 29492 9
184832 245526 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1555 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     43 Width 3ft   5999748.31712 2107152.74362 37.7658245506788 -122.444109759657 (37.7658245506788, -122.444109759657) 15 5 5 29492 9
188266 247677 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 969 Buena Vista Ave West 4 : Tree Private 2     24 Width 4ft   5999999.41375 2108762.74792 37.7702595402749 -122.443356925493 (37.7702595402749, -122.443356925493) 15 5 11 29492 9
2481 245485 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1300 San Jose Ave 72 Front Yard : Yard Tree Private 2     4 Width 5ft   6003516.63487 2095667.30987 37.7345024965788 -122.430256461687 (37.7345024965788, -122.430256461687) 2 7 5 63 7
7266 245758 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 220 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 Width 2ft   6004895.76368 2096843.93184 37.7378112552963 -122.425572065806 (37.7378112552963, -122.425572065806) 2 7 5 63 7
8032 245760 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 127 Farnum St 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6002444.1806 2097361.0891 37.7390924204823 -122.43408532709 (37.7390924204823, -122.43408532709) 2 7 5 63 7
10829 245757 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1884 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004576.62382 2097711.65254 37.7401757815964 -122.426737263435 (37.7401757815964, -122.426737263435) 2 7 5 63 7
13700 104171 Undocumented 4 Cordyline australis :: Dracena Palm 64 2607 DIAMOND ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     28 3x3   6002306 2096613 37.7370304975493 -122.434509617625 (37.7370304975493, -122.434509617625) 2 7 5 63 7
14709 5008 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 5300 Diamond Heights Blvd 25 Median : Cutout Tree DPW 1     12 12   6001419.5409281 2098992.5811716 37.7435139095193 -122.437744874344 (37.7435139095193, -122.437744874344) 2 7 5 63 7
15107 245765 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 205 Beacon St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6003079.9408 2097633.46199 37.7398763550104 -122.431906602506 (37.7398763550104, -122.431906602506) 2 7 5 63 7
16372 96327 Significant Tree 6 Cordyline australis :: Dracena Palm 64 296 Randall St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 767829 6003708 2097940 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294) 2 7 5 63 7
18575 245781 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 21 Addison St 6 Back Yard : Yard Tree Private 2     17 Width 8ft   6003587.5616 2096850.22083 37.7377545179491 -122.430095602638 (37.7377545179491, -122.430095602638) 2 7 5 63 7
20448 245794 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 601 30th St 6 Front Yard : Yard Tree Private 2     2     6002837.91517 2098354.25557 37.7418417639992 -122.432794903371 (37.7418417639992, -122.432794903371) 2 7 5 63 7
26166 245779 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 21 Addison St 4 Back Yard : Yard Tree Private 2     4 Width 8ft   6003578.06847 2096849.22804 37.73775125431 -122.430128354157 (37.73775125431, -122.430128354157) 2 7 5 63 7
29943 245759 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 95 Thor Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002384.19841 2095793.19336 37.7347839358309 -122.43418066153 (37.7347839358309, -122.43418066153) 2 7 5 63 7
30038 245598 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 205 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001673.40182 2096391.59136 37.7363866302454 -122.436680945886 (37.7363866302454, -122.436680945886) 2 7 5 63 7
32663 111520 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 800x BOSWORTH ST 15 Front Yard : Yard Tree DPW 1     7     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
37010 5006 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 5300 Diamond Heights Blvd 23 Median : Cutout Tree DPW 1     12 12   6001419.5409281 2098992.5811716 37.7435139095193 -122.437744874344 (37.7435139095193, -122.437744874344) 2 7 5 63 7
43426 245762 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 159 Laidley St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004015.75468 2097400.41053 37.7392894556549 -122.428654341035 (37.7392894556549, -122.428654341035) 2 7 5 63 7
44149 245786 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 21 Addison St 13 Back Yard : Yard Tree Private 2     2 Width 3ft   6003641.81586 2096850.294 37.7377577914922 -122.429908024732 (37.7377577914922, -122.429908024732) 2 7 5 63 7
48459 245795 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 601 30th St 7 Front Yard : Yard Tree Private 2     3     6002841.82377 2098354.17483 37.7418417639849 -122.432781382956 (37.7418417639849, -122.432781382956) 2 7 5 63 7
52136 245772 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 395 Addison St 2 Sidewalk: Property side : Yard Tree Private 2     2     6002120.14451 2097689.53055 37.7399758488049 -122.435229181078 (37.7399758488049, -122.435229181078) 2 7 5 63 7
55718 245784 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 21 Addison St 11 Back Yard : Yard Tree Private 2     4 Width 4ft   6003626.79774 2096849.74169 37.7377554244689 -122.429959910226 (37.7377554244689, -122.429959910226) 2 7 5 63 7
56221 245789 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 13 Penny Ln 1 Back Yard : Yard Tree Private 2     23 Width 2ft   6002510.68516 2096313.64967 37.7362201675144 -122.433780540537 (37.7362201675144, -122.433780540537) 2 7 5 63 7
61124 245787 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 26 Harry St 5 Sidewalk: Property side : Yard Tree Private 2     61     6003360.59602 2097764.52803 37.7402521385234 -122.430945566306 (37.7402521385234, -122.430945566306) 2 7 5 63 7
61327 245790 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 601 30th St 2 Front Yard : Yard Tree Private 2     2     6002818.16213 2098366.55064 37.7418744030785 -122.432864081016 (37.7418744030785, -122.432864081016) 2 7 5 63 7
68809 205409 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 47 Chilton Ave 2 Sidewalk: Property side : Yard Tree Private 2     14     6001682.76522 2095616.45632 37.7342588207884 -122.436593107305 (37.7342588207884, -122.436593107305) 2 7 5 63 7
70082 4979 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 5200X Diamond Heights Blvd 15 Median : Cutout Tree DPW 1     12 12   6000724.3855206 2099633.2111664 37.7452333754909 -122.440194472866 (37.7452333754909, -122.440194472866) 2 7 5 63 7
71187 34375 Permitted Site 7 Cordyline australis :: Dracena Palm 64 157 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38127 6003918.97921609 2097483.80532691 37.7395129612854 -122.428994891637 (37.7395129612854, -122.428994891637) 2 7 5 63 7
74512 245780 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 21 Addison St 5 Back Yard : Yard Tree Private 2     2 Width 8ft   6003583.61188 2096848.84807 37.7377505249636 -122.430109160821 (37.7377505249636, -122.430109160821) 2 7 5 63 7
80647 245776 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 339 Addison St 8 Sidewalk: Property side : Yard Tree Private 2     3 Width 8ft   6002249.41782 2097701.04161 37.7400147957413 -122.434783031019 (37.7400147957413, -122.434783031019) 2 7 5 63 7
82571 245770 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 50 Digby St 11 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6002871.37625 2097642.58356 37.7398895750355 -122.43262838222 (37.7398895750355, -122.43262838222) 2 7 5 63 7
82618 245769 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 50 Digby St 10 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   6002874.10892 2097638.15263 37.739877563697 -122.432618617374 (37.739877563697, -122.432618617374) 2 7 5 63 7
82783 245785 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 21 Addison St 12 Back Yard : Yard Tree Private 2     2 Width 4ft   6003634.59217 2096849.86817 37.7377562131711 -122.429932970144 (37.7377562131711, -122.429932970144) 2 7 5 63 7
84091 245792 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 601 30th St 4 Front Yard : Yard Tree Private 2     1     6002825.04242 2098363.5292 37.7418664971384 -122.432840075435 (37.7418664971384, -122.432840075435) 2 7 5 63 7
84971 245778 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 21 Addison St 1 Back Yard : Yard Tree Private 2     11 Width 8ft   6003567.00592 2096851.64348 37.7377572599929 -122.430166774989 (37.7377572599929, -122.430166774989) 2 7 5 63 7
85495 245788 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 59 Poppy Ln 1 Back Yard : Yard Tree Private 2     8 Width 2ft   6002650.36065 2096519.59952 37.7367935833586 -122.433312337306 (37.7367935833586, -122.433312337306) 2 7 5 63 7
91271 245783 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 21 Addison St 10 Back Yard : Yard Tree Private 2     6 Width 8ft   6003607.92987 2096849.51084 37.73775372205 -122.430025129081 (37.73775372205, -122.430025129081) 2 7 5 63 7
103931 34376 Permitted Site 7 Cordyline australis :: Dracena Palm 64 159 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38128 6003933.5588278 2097472.84374368 37.7394836885423 -122.42894370039 (37.7394836885423, -122.42894370039) 2 7 5 63 7
112686 245793 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 601 30th St 5 Front Yard : Yard Tree Private 2     1     6002836.40816 2098357.0124 37.7418492481435 -122.432800311009 (37.7418492481435, -122.432800311009) 2 7 5 63 7
123858 245756 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 9 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6004886.19345 2098294.25593 37.7417929757745 -122.42570835268 (37.7417929757745, -122.42570835268) 2 7 5 63 7
124382 245773 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 395 Addison St 3 Sidewalk: Property side : Yard Tree Private 2     2     6002120.80599 2097681.006 37.7399524799363 -122.435226284376 (37.7399524799363, -122.435226284376) 2 7 5 63 7
130959 245763 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 159 Laidley St 4 Sidewalk: Curb side : Cutout Tree Private 2     48 Width 3ft   6004008.78784 2097405.40943 37.7393027872065 -122.428678785515 (37.7393027872065, -122.428678785515) 2 7 5 63 7

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