1,650 rows where qSpecies_id = 64 sorted by qSpecies_id

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)
137 189330 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 23 Median : Yard Tree DPW 1     15     6016163.75351 2096735.77367 37.7381445215441 -122.386605256348 (37.7381445215441, -122.386605256348) 10 3 8 58 1
150 247856 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 80 Bradford St 5 Side Yard : Yard Tree Private 2     32     6009566.84713 2098148.32022 37.7416556510973 -122.409513828008 (37.7416556510973, -122.409513828008) 10 7 7 28859 2
393 182533 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1581 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5985582.1491 2104457.0825 37.7576046859901 -122.492908268983 (37.7576046859901, -122.492908268983) 1 8 3 56 35
512 126120 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2843 Larkin St 9 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   6006458.53093 2121044.25925 37.8043477551992 -122.421887372509 (37.8043477551992, -122.421887372509) 5 9 1 28858 32
577 205386 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1 Rosewood Dr 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   5994512.47364 2095959.37509 37.7347903147287 -122.461407773158 (37.7347903147287, -122.461407773158) 9 8 4 59 40
603 245637 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 111 Manchester St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6008273.00792 2099308.43984 37.7447685005688 -122.414069557873 (37.7447685005688, -122.414069557873) 2 7 7 28859 2
683 38304 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2000 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
804 175950 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 326 Avalon Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6003638.04232 2092697.69928 37.7263554895976 -122.42962499282 (37.7263554895976, -122.42962499282) 9 7 6 28861 5
990 245607 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 263 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007571 2097463 37.7396618784985 -122.416366286166 (37.7396618784985, -122.416366286166) 2 7 7 28859 2
1193 63195 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 492 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1986 12:00:00 AM 7   Permit Number 23736 5984412.04288 2112531.45624 37.7797061246547 -122.497551031954 (37.7797061246547, -122.497551031954) 11 6 2 55 26
1443 68991 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1882 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1994 12:00:00 AM 2   Permit Number 32984 5981356.0199 2102264.6652 37.7513368825607 -122.507361024926 (37.7513368825607, -122.507361024926) 1 8 3 56 35
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
1646 19899 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY33 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
1650 126124 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1055 Lombard St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   6007293.98833 2120181.06921 37.8020247344007 -122.418934936917 (37.8020247344007, -122.418934936917) 5 1 1 28858 32
1739 189348 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1151 Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017793.1763 2096477.15047 37.7375244650907 -122.380953492111 (37.7375244650907, -122.380953492111) 10 3 8 58 1
1819 259562 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 200 Public Park 1 Unaccepted Street : Cutout Tree Private 2       5x10   5994204 2098512 37.741781429361 -122.462659374294 (37.741781429361, -122.462659374294) 1 8 4 59 40
1926 205350 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1500 Ulloa St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991278.78749 2098428.09247 37.7413821375847 -122.47276757848 (37.7413821375847, -122.47276757848) 1 8 4 29491 40
1960 189303 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1345 20th St 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6013928.16034 2104751.39428 37.7600296962246 -122.394896108974 (37.7600296962246, -122.394896108974) 10 3 8 28856 29
1995 87953 Permitted Site 7 Cordyline australis :: Dracena Palm 64 495 Harkness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010151 2089645.9 37.7183425147467 -122.406894902171 (37.7183425147467, -122.406894902171) 10 7 8 309 39
2085 261253 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 245 Euclid Ave 1 Sidewalk: Property side : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3     5998181.06314 2113969.03195 37.7844507871641 -122.450021856673 (37.7844507871641, -122.450021856673) 15 6 1 54 31
2127 205363 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 250 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5994757.66633 2100420.78741 37.7470543532783 -122.460883300235 (37.7470543532783, -122.460883300235) 1 8 4 29491 40
2193 182215 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2998 Lawton St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5985108.0649 2104343.6089 37.7572653833543 -122.494539455696 (37.7572653833543, -122.494539455696) 1 8 3 56 35
2365 97086 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4550 Balboa St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2020 12:00:00 AM 3 3x3   5981457.56361 2110998.49669 37.7753234489943 -122.507657898162 (37.7753234489943, -122.507657898162) 11 6 2 55 26
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
2492 205476 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 98 Judson Ave 8 Sidewalk: Property side : Yard Tree Private 2     3     5999461.7393 2093534.48294 37.7284157437829 -122.444122326784 (37.7284157437829, -122.444122326784) 9 7 4 63 40
3002 43637 Permitted Site 7 Cordyline australis :: Dracena Palm 64 464 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2000 12:00:00 AM     Permit Number 43287 6006770.36235207 2101076.15554315 37.7495377351989 -122.419390811234 (37.7495377351989, -122.419390811234) 2 4 7 28859 19
3030 205255 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1948 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 1ft   5991290.8698 2102154.62063 37.7516149197081 -122.47299748747 (37.7516149197081, -122.47299748747) 1 8 4 29491 12
3163 245541 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 499X Ogden Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6008320.69019 2096092.37783 37.7359405790823 -122.413677250212 (37.7359405790823, -122.413677250212) 2 7 7 28859 2
3234 41216 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1920 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/10/2019 12:00:00 AM 3   Permit Number 41924 5999991.94061 2121282.68763 37.8046356075044 -122.444282616557 (37.8046356075044, -122.444282616557) 13 9 1 57 17
3380 261217 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3400 Vicente St   : Cutout Tree Private 2 FUF     3x3   5982420.06104 2097439.60235 37.738151214353 -122.503324281602 (37.738151214353, -122.503324281602) 1 8 3 29491 35
3410 47847 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
3460 20048 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY52 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
3547 71714 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3725 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9 3x6 Permit Number 771233 5984016.25098 2111031.53375 37.7755645644081 -122.498809386612 (37.7755645644081, -122.498809386612) 11 6 2 55 26
3550 80000 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 8250 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5981404.80446 2112378.67743 37.7791099097712 -122.507942852748 (37.7791099097712, -122.507942852748) 11 6 2 55 26
3731 175896 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 529 Lisbon St 7 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6002023.9515 2090409.71529 37.7199816731933 -122.435041255167 (37.7199816731933, -122.435041255167) 9 7 6 28861 5
3918 71637 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3735 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5983967.42692 2111030.60647 37.7755591545959 -122.498978209698 (37.7755591545959, -122.498978209698) 11 6 2 55 26
3945 70009 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1815 Felton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6005608.75345 2092244.69483 37.725223029103 -122.422780149308 (37.725223029103, -122.422780149308) 9 7 7 309 5
3946 52915 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3017th ST Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/26/2006 12:00:00 AM     Permit Number 48903 6000815.25066305 2106175.88788155 37.7632031545323 -122.440349407902 (37.7632031545323, -122.440349407902) 15 5 5 28862 3
4138 175926 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 207 San Juan Ave 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 2ft   6001151.19668 2092294.37303 37.7251069212337 -122.438193002116 (37.7251069212337, -122.438193002116) 9 7 6 28861 25
4272 47849 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
4344 245567 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 916 Elizabeth St 10 Sidewalk: Curb side : Cutout Tree Private 2     39 Width 4ft   6000500.80489 2102003.5265 37.7517289609205 -122.441137602835 (37.7517289609205, -122.441137602835) 2 4 5 28862 22
4394 261156 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4221 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/13/2020 12:00:00 AM 3 3x3   5981166 2103448 37.7545747897022 -122.508105942328 (37.7545747897022, -122.508105942328) 1 8 3 56 35
4396 260248 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 Copper Aly 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999810 2103933 37.7569874509855 -122.443665087987 (37.7569874509855, -122.443665087987) 2 5 5 28862 3
4501 81295 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2274 45th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5982376.5473 2099668.9758 37.7442699020827 -122.503639778557 (37.7442699020827, -122.503639778557) 1 8 3 29491 35
4511 245571 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4220 Cesar Chavez St 2 Sidewalk: Property side : Yard Tree Private 2     10     6002399.35344 2100348.21593 37.7472918291588 -122.43445383688 (37.7472918291588, -122.43445383688) 2 4 5 63 22
4755 245512 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 106 Chattanooga St 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 4ft   6004701.89686 2103004.13948 37.7547148117622 -122.426680909207 (37.7547148117622, -122.426680909207) 2 4 5 28862 22
4894 182443 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1530 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5985305.1982 2104772.3112 37.7584540168422 -122.493889294148 (37.7584540168422, -122.493889294148) 1 8 3 56 35
5331 236694 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4515 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6000927.42532 2101109.44897 37.7492983299761 -122.439598207206 (37.7492983299761, -122.439598207206) 2 4 5 28862 22
5334 83255 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 790 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/2020 12:00:00 AM 3     5983253.61867 2110435.38712 37.7738829587872 -122.501403365431 (37.7738829587872, -122.501403365431) 11 6 2 55 26
5453 189384 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 31 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017757.64488 2096623.78425 37.737925131039 -122.381086534243 (37.737925131039, -122.381086534243) 10 3 8 58 1
5542 117796 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3739 Balboa St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5983953.06795 2111029.92822 37.7755564500477 -122.49902782995 (37.7755564500477, -122.49902782995) 11 6 2 55 26
5738 78347 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3301 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5985324.51094 2111082.60279 37.7757814311217 -122.49428762949 (37.7757814311217, -122.49428762949) 11 6 2 55 26
6119 245606 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 269 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6007569 2097440 37.7395986131129 -122.416371572654 (37.7395986131129, -122.416371572654) 2 7 7 28859 2
6124 72278 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 716 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5983237.15085 2110912.93675 37.7751932045665 -122.501495663732 (37.7751932045665, -122.501495663732) 11 6 2 55 26
6229 54527 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4550 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2020 12:00:00 AM 3 3x5 Permit Number 10322 5981462.67511 2111006.65453 37.775346149152 -122.507640822085 (37.775346149152, -122.507640822085) 11 6 2 55 26
6700 118852 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 518 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5981326.91116 2112159.50224 37.7785035297781 -122.508196040224 (37.7785035297781, -122.508196040224) 11 6 2 55 26
6872 245755 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1116 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6002482.91407 2102267.39959 37.7525661964955 -122.434302077201 (37.7525661964955, -122.434302077201) 2 4 5 28862 22
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
7328 182420 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1550 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5985930.8682 2104662.5204 37.7581891485667 -122.491717396551 (37.7581891485667, -122.491717396551) 1 8 3 56 35
7749 118166 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3232 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5985500.8537 2111144.01692 37.7759603747412 -122.493682150646 (37.7759603747412, -122.493682150646) 11 6 2 55 26
7917 253285 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 8245 Geary Blvd 1 Sidewalk: Curb side : Yard Tree Private 2   08/15/2017 12:00:00 AM 3     5981372 2112274 37.7788205636315 -122.508048563649 (37.7788205636315, -122.508048563649) 11 6 2 55 26
7958 258015 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1267 39th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   5983961.07451 2106546.41289 37.7632464670432 -122.498668855343 (37.7632464670432, -122.498668855343) 1 8 3 56 35
7959 205335 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 134 Monticello St 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 10ft   5991702.38493 2089452.42364 37.7167617027762 -122.470649341406 (37.7167617027762, -122.470649341406) 9 8 6 64 24
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
8100 60138 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3643 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/19/1982 12:00:00 AM 4   Permit Number 19668 5984225.13965 2111041.08493 37.7756030388028 -122.498087506758 (37.7756030388028, -122.498087506758) 11 6 2 55 26
8141 54006 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3300 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/05/1972 12:00:00 AM 2   Permit Number 9725 5985332.63941 2111140.64831 37.7759412831996 -122.494263790905 (37.7759412831996, -122.494263790905) 11 6 2 55 26
8187 37494 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1050 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39963 5991661.12122197 2105245.54821547 37.7601232248942 -122.471942379719 (37.7601232248942, -122.471942379719) 1 8 4 56 12
8350 47846 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
8355 115419 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4219 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 772533 5981156.8 2104128.1 37.7564416084773 -122.508188234142 (37.7564416084773, -122.508188234142) 1 8 3 56 35
8653 254419 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3400X Moraga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2018 12:00:00 AM 3 3x3 Permit Number 781063                    
8902 89579 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4801X Anza St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2008 12:00:00 AM 3 3x3   5983739.98456 2111706.68293 37.777402120963 -122.499814958061 (37.777402120963, -122.499814958061) 11 6 2 55 26
9042 122353 Undocumented 4 Cordyline australis :: Dracena Palm 64 155 Appleton Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006071 2097171 37.7387756468895 -122.421531918974 (37.7387756468895, -122.421531918974) 2 7 7 28859 2
9061 245544 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2020 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6008037.51998 2106722.39009 37.7651122930328 -122.415408600746 (37.7651122930328, -122.415408600746) 8 4 7 28859 19
9111 29980 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1622X Guerrero St 1 Median : Cutout Tree DPW 1   03/24/2007 12:00:00 AM 3 3x3   6005918.53507 2099515.50587 37.7452045332674 -122.422225595834 (37.7452045332674, -122.422225595834) 2 7 5 28859 2
9188 250134 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2550x Lyon St 2 Median : Yard Tree DPW 1     15     5999224.86929 2117537.18532 37.7943076699218 -122.446667476532 (37.7943076699218, -122.446667476532) 13 9 1 57 27
9201 205370 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 251 Wildwood Way 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5995666.31716 2093292.13058 37.7275330492907 -122.457225677447 (37.7275330492907, -122.457225677447) 9 7 4 28861 40
9317 69488 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 425 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/24/1994 12:00:00 AM 20   Permit Number 33610 6002125.08495 2093879.83517 37.7295155822594 -122.434939712705 (37.7295155822594, -122.434939712705) 9 7 6 28861 25
9532 261191 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 599x Benton Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007159 2095436 37.7340730065148 -122.41764717788 (37.7340730065148, -122.41764717788) 2 7 7 28859 2
9818 47845 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
10077 264701 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 88 Entrada Ct 1 Sidewalk: Property side : Yard Tree Private 2       8x20   5992483 2092113 37.724112106281 -122.468144593972 (37.724112106281, -122.468144593972) 9 8 4 59 40
10351 71636 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3710 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11 3x6 Permit Number 771232 5984058.85171 2111091.8464 37.7757326640871 -122.498666479041 (37.7757326640871, -122.498666479041) 11 6 2 55 26
10665 70444 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3933 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5982611.2212 2104882.7837 37.758599355062 -122.503214291779 (37.758599355062, -122.503214291779) 1 8 3 56 35
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
10877 205247 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1436 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2002 12:00:00 AM 7 Width 3ft Permit Number 45929 5990862.22967 2105614.49151 37.7610899852431 -122.474732265294 (37.7610899852431, -122.474732265294) 1 8 4 56 12
10994 189372 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017835.15635 2096405.7352 37.7373306899522 -122.380803382685 (37.7373306899522, -122.380803382685) 10 3 8 58 1
11153 205453 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 142 Monterey Blvd 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6001121.86387 2094702.03359 37.7317161369712 -122.438466824999 (37.7317161369712, -122.438466824999) 9 7 4 63 40
11155 71173 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2275 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5987604.645 2099825.288 37.7450050904406 -122.485573834432 (37.7450050904406, -122.485573834432) 1 8 3 29491 35
11211 256751 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1858 36th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 3x5   5985068.08912 2102552.26769 37.7523445150231 -122.494545652262 (37.7523445150231, -122.494545652262) 1 8 3 56 35
11234 205417 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 198 Mangels Ave 6 Sidewalk: Property side : Yard Tree Private 2     3     6000139.85205 2095251.72944 37.7331695655238 -122.441901267552 (37.7331695655238, -122.441901267552) 9 7 5 63 40
11556 253426 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 09th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2018 12:00:00 AM 3 3x3 Permit Number 780637 5993083 2114893 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285) 11 6 1 54 11
11609 245630 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 53 Appleton Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6005628.85756 2097048.73767 37.7384150016563 -122.42305195408 (37.7384150016563, -122.42305195408) 2 7 7 28859 2
11802 261531 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 601 44th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 4ft   5982234.0104 2111588.65058 37.7769895502595 -122.505015778681 (37.7769895502595, -122.505015778681) 11 6 2 55 26
11847 118142 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3404 Balboa St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5985014.87745 2111125.50759 37.7758811108771 -122.495361878931 (37.7758811108771, -122.495361878931) 11 6 2 55 26
12007 205264 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1050 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5991629.32312 2105245.37395 37.7601209063813 -122.472052340447 (37.7601209063813, -122.472052340447) 1 8 4 56 12
12123 189376 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017838.12886 2096499.84024 37.7375892477372 -122.380799645108 (37.7375892477372, -122.380799645108) 10 3 8 58 1
12196 175980 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 967 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001586.84738 2086770.85375 37.7099653381068 -122.436291887471 (37.7099653381068, -122.436291887471) 9 7 6 28861 5
12337 89570 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4935 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2008 12:00:00 AM 3 3x3   5983308.7395 2111690.55403 37.77733251999 -122.501305558655 (37.77733251999, -122.501305558655) 11 6 2 55 26
12456 205316 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 112 Marston Ave 3 Sidewalk: Property side : Yard Tree Private 2     9     5998697.99683 2093223.72686 37.7275188804882 -122.44674026046 (37.7275188804882, -122.44674026046) 9 7 4 28861 40
12509 260552 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1822 42nd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/27/2019 12:00:00 AM 3     5983200.28736 2102724.03033 37.752706632515 -122.501017410169 (37.752706632515, -122.501017410169) 1 8 3 56 35
12789 109729 Permitted Site 7 Cordyline australis :: Dracena Palm 64 4534 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2015 12:00:00 AM 3 3x3 Permit Number 774273 6000926.1 2104675 37.7590883953394 -122.439858400707 (37.7590883953394, -122.439858400707) 2 4 5 28862 3

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