1,746 rows where qSpecies_id = 10

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)
10267 255196 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 201 Burrows St 7 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
10448 202192 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1928 Armstrong Ave 1 Sidewalk: Property side : Yard Tree Private 2     7     6013154.16149 2093432.67733 37.7289078285177 -122.396779493476 (37.7289078285177, -122.396779493476) 10 3 8 58 1
10606 46465 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 2098 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2002 12:00:00 AM     Permit Number 44668 6002328.64862435 2119517.88465055 37.7999229605029 -122.436069860968 (37.7999229605029, -122.436069860968) 13 9 1 57 17
10641 232039 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 50 Scott St 12 : Tree Private 2     9 Width 3ft   6002403.60195 2108716.39098 37.7702690623006 -122.435037544552 (37.7702690623006, -122.435037544552) 15 5 5 29492 9
10809 82390 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1783 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6001502.3544 2112144.9743 37.7796318765871 -122.438400625768 (37.7796318765871, -122.438400625768) 15 5 11 29490 41
10925 249073 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 78 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6012976.71638 2090666.07234 37.721301414799 -122.397199017345 (37.721301414799, -122.397199017345) 10 3 8 58 1
10949 66447 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1717 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 13   Permit Number 32898 6009150.19031 2119198.20098 37.7994303674837 -122.41244205838 (37.7994303674837, -122.41244205838) 3 1 10 308 32
11091 210155 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 351 Judson Ave 32 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   5997888.33072 2093517.91432 37.728280364322 -122.449560457971 (37.728280364322, -122.449560457971) 9 7 4 28861 40
11121 78902 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1443 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5989581.2299 2105525.1155 37.7607702705418 -122.479156103143 (37.7607702705418, -122.479156103143) 1 8 3 56 35
11421 255616 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 334 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006694 2104159 37.7579982171346 -122.419873605129 (37.7579982171346, -122.419873605129) 2 4 7 28859 19
11661 73117 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 170 Rome St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5998798.49436 2089027.53111 37.7160028368265 -122.446091142417 (37.7160028368265, -122.446091142417) 9 7 6 28861 25
11957 260232 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 28 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
12130 210150 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 351 Judson Ave 27 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 1ft   5997817.44041 2093518.24047 37.7282772041107 -122.44980555111 (37.7282772041107, -122.44980555111) 9 7 4 28861 40
12198 260226 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 22 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
12220 43101 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 44 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM 14   Permit Number 42932 6008904.81369 2112529.72749 37.7811065881247 -122.412819439978 (37.7811065881247, -122.412819439978) 7 10 9 28852 36
12256 78779 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 50 Farragut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     5997572.00322 2087132.19247 37.7107285558476 -122.450193916137 (37.7107285558476, -122.450193916137) 9 7 6 28861 25
12261 177534 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 502 Wayland St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010094.64304 2092221.19547 37.7254105881115 -122.407271149051 (37.7254105881115, -122.407271149051) 10 3 7 309 28
12325 42608 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 1775 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42675 6004555.83509625 2118398.4069888 37.796975439849 -122.428283124742 (37.796975439849, -122.428283124742) 13 9 1 57 17
12383 118387 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 5640 Anza St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5981104.69221 2111668.01683 37.7771409589636 -122.508928263307 (37.7771409589636, -122.508928263307) 11 6 2 55 26
12500 255191 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 201 Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
12525 119938 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2500 Balboa St 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5987749.91083 2111234.09886 37.7763390320182 -122.485908787714 (37.7763390320182, -122.485908787714) 11 6 2 55 26
12563 46339 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 3724 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50545 6005683.95677825 2100834.56351367 37.7488131299105 -122.423130469903 (37.7488131299105, -122.423130469903) 2 4 5 28859 19
12673 70698 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 591 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6003529.56495 2089763.19093 37.7182918362743 -122.429790778347 (37.7182918362743, -122.429790778347) 9 7 6 28861 5
12912 50271 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 46 Saint Mary's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/2003 12:00:00 AM     Permit Number 46975 6003961.77190842 2095882.86717576 37.7351195713487 -122.428732836762 (37.7351195713487, -122.428732836762) 2 7 5 28861 7
13054 201281 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 38 Lydia Ave 1 : Tree Private 2     9 Width 2ft   6012822.1573 2092867.77977 37.7273382507444 -122.397887653412 (37.7273382507444, -122.397887653412) 10 3 8 58 1
13092 261764 Significant Tree 6 Melaleuca quinquenervia :: Cajeput 10 130 Bartlett St 2 Front Yard : Cutout Tree Private 2       4x4   6006663 2102839 37.7543720553146 -122.419887150249 (37.7543720553146, -122.419887150249) 2 4 7 28859 19
13119 42922 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42829                    
13127 32202 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1600 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/1995 12:00:00 AM 9 3x3 Permit Number 35526 6009258.02214 2100018.34894 37.7467730300449 -122.410713678287 (37.7467730300449, -122.410713678287) 2 7 7 28859 2
13173 25969 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 2121 Oakdale Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1997 12:00:00 AM 3 2x3   6012170.05975 2097512.80398 37.7400561799102 -122.400468107084 (37.7400561799102, -122.400468107084) 10 3 8 58 1
13175 30752 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1507 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM 11 3x3 Permit Number 34633 6015383.6793 2093790.5859 37.73001441519 -122.389096804708 (37.73001441519, -122.389096804708) 10 3 8 58 1
13400 81931 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 234X Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6009287.21527 2113626.45246 37.7841393898643 -122.411574026434 (37.7841393898643, -122.411574026434) 14 10 9 28852 36
13482 72809 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 118X Lowell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10 3x3   5998733.92072 2087172.14442 37.7109046790814 -122.446180954109 (37.7109046790814, -122.446180954109) 9 7 6 28861 5
13627 78732 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 53 Foote Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     5998972.2526 2087962.75673 37.7130891296288 -122.44541403745 (37.7130891296288, -122.44541403745) 9 7 6 28861 25
13681 27548 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 1301X Illinois St 6 Sidewalk: Curb side : Cutout Tree Port 6   01/05/2001 12:00:00 AM 8 3X3   6016173.411126 2103023.95301 37.7554110972717 -122.387010312465 (37.7554110972717, -122.387010312465) 10 3 8 28856 29
13695 39699 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 360 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41085 5995865.64470652 2094899.35552532 37.7319575477065 -122.456652788497 (37.7319575477065, -122.456652788497) 9 7 4 59 40
13719 264662 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1070 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/10/2020 12:00:00 AM   3x3   6014517.40872 2089968.05117 37.7194704392608 -122.391824453064 (37.7194704392608, -122.391824453064) 10 3 8 58 1
13782 50191 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 347 Richard Av 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2003 12:00:00 AM     Permit Number 46897                    
13817 78590 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 440 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6008293.184 2113486.29357 37.7836987391503 -122.415003105409 (37.7836987391503, -122.415003105409) 7 10 9 28858 36
14035 159355 Planning Code 138.1 required 2 Melaleuca quinquenervia :: Cajeput 10 417 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998509.88268 2087558.19074 37.7119518775514 -122.44698304145 (37.7119518775514, -122.44698304145) 9 7 6 28861 25
14095 262078 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1201 Naples St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001148 2087377 37.7116047371551 -122.437852010648 (37.7116047371551, -122.437852010648) 9 7 6 28861 5
14252 76445 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 118X Lowell St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10 3x3   5998808.02641 2086988.08444 37.710403523785 -122.445911599067 (37.710403523785, -122.445911599067) 9 7 6 28861 5
14298 18879 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2315 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/1998 12:00:00 AM 3 3X3   6003607.44812 2115913.14135 37.790097828305 -122.431387267427 (37.790097828305, -122.431387267427) 13 9 1 29490 27
14517 81930 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 234X Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6009272.01277 2113623.31708 37.7841299280977 -122.411626400234 (37.7841299280977, -122.411626400234) 14 10 9 28852 36
14828 82804 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 46 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000854.60594 2092857.18319 37.7266353963958 -122.4392586043 (37.7266353963958, -122.4392586043) 9 7 6 28861 25
14989 37365 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 125 Street 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39871                    
14990 260236 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 32 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
15074 61794 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2112 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/24/1985 12:00:00 AM 11   Permit Number 21817 6012105.79225 2102838.47853 37.7546757515047 -122.401064430306 (37.7546757515047, -122.401064430306) 10 3 8 28856 29
15383 260234 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 30 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
15406 255194 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 201 Burrows St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
15471 27568 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 1299X Illinois St 19 Sidewalk: Curb side : Cutout Tree Port 6   12/10/1999 12:00:00 AM 12 3X3   6016181.753398 2103053.032112 37.7554914042846 -122.386983490089 (37.7554914042846, -122.386983490089) 10 3 8 28856 29
15475 148112 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 509 Woolsey St 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 4x5   6010229.36415 2091734.22439 37.7240810061078 -122.406771124199 (37.7240810061078, -122.406771124199) 10 3 7 309 28
15829 182637 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1634 Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5988859.5989 2102431.4519 37.7522339655322 -122.481425305484 (37.7522339655322, -122.481425305484) 1 8 3 56 35
16035 184914 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1990 41st Ave 33 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5983535.9639 2102008.3107 37.7507611695923 -122.499803702352 (37.7507611695923, -122.499803702352) 1 8 3 29491 35
16036 247980 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 501 Peralta Ave 4 Side Yard : Yard Tree Private 2     5     6009795.98268 2099453.55621 37.7452523808083 -122.408813614968 (37.7452523808083, -122.408813614968) 2 7 7 28859 2
16089 35760 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 1312 Natoma St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/20/1998 12:00:00 AM 11 3x3 Permit Number 39024 6007125.06235959 2107895.69286433 37.7682825792913 -122.418647786971 (37.7682825792913, -122.418647786971) 8 4 7 28853 19
16295 69167 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1357 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1994 12:00:00 AM 8   Permit Number 33204 5982738.1126 2105902.9753 37.7614079699737 -122.502850971641 (37.7614079699737, -122.502850971641) 1 8 3 56 35
16307 254265 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 85X Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/2018 12:00:00 AM 3 3x3 Permit Number 778120                    
16397 200789 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1614 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6015325 2096036 37.7361766159661 -122.389456416811 (37.7361766159661, -122.389456416811) 10 3 8 58 1
16476 260228 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 24 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
16479 193722 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1500 Owen St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013875.94265 2107923.76341 37.7687374206141 -122.395298938712 (37.7687374206141, -122.395298938712) 14 3 9 310 20
16501 255192 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 201 Burrows St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
16512 72518 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1385 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     5999282.60736 2089782.01796 37.718102119793 -122.444472018286 (37.718102119793, -122.444472018286) 9 7 6 28861 25
16625 259862 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1300x Brussels St 1 Side Yard : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
16807 255193 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 201 Burrows St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
16910 85922 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1750 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/19/2006 12:00:00 AM 3 3x3   5988150.1283 2103379.9075 37.7547968937654 -122.483948277297 (37.7547968937654, -122.483948277297) 1 8 3 56 35
17100 156687 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 699x Shotwell St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007926.21888 2103995.6336 37.7576189924373 -122.415600489977 (37.7576189924373, -122.415600489977) 2 4 7 28859 19
17329 42509 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 163 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42623 5999007.81241244 2093762.41150779 37.7290156761066 -122.445707952741 (37.7290156761066, -122.445707952741) 9 7 4 28861 40
17408 72787 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 125 Morse St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6000842.13872 2087917.52073 37.7130714894434 -122.438947857962 (37.7130714894434, -122.438947857962) 9 7 6 28861 5
17795 144230 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 696 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:47:00 PM 0 Width 4ft   5982610.26029 2111073.90375 37.7755983350405 -122.503676106264 (37.7755983350405, -122.503676106264) 11 6 2 55 26
17891 201310 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 9 Lydia Ave 1 : Tree Private 2     5 Width 2ft   6012935.48709 2092735.05755 37.7269801335046 -122.397486565679 (37.7269801335046, -122.397486565679) 10 3 8 58 1
18135 193744 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 106 Whitney Young Cir 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6016631.20601 2095628.77258 37.7351307863641 -122.384911922862 (37.7351307863641, -122.384911922862) 10 3 8 58 1
18315 261539 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 723 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 4ft   5981936 2110809 37.7748313206063 -122.505988851899 (37.7748313206063, -122.505988851899) 11 6 2 55 26
18335 44721 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 1996 21st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2001 12:00:00 AM     Permit Number 43840 5989758.20628326 2101785.10530384 37.7505114749608 -122.478270559665 (37.7505114749608, -122.478270559665) 1 8 3 29491 35
18390 78903 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2078 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5989460.8159 2101226.1598 37.7489594901873 -122.479258062134 (37.7489594901873, -122.479258062134) 1 8 3 29491 35
18477 260227 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 23 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
18586 1979 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 96 Bertha Ln 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/17/1995 12:00:00 AM 6 3X4   6017818.3743209 2094812.8777717 37.7329560922326 -122.380750713036 (37.7329560922326, -122.380750713036) 10 3 8 58 1
18688 70201 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1811 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5987499.4352 2102910.1581 37.7534691863201 -122.486164042507 (37.7534691863201, -122.486164042507) 1 8 3 56 35
18691 78242 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 767 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6001367.70534 2092560.86013 37.725850945661 -122.437463630336 (37.725850945661, -122.437463630336) 9 7 6 28861 25
18708 74162 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1450 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5988352.2909 2099691.0788 37.7446801201935 -122.482978806105 (37.7446801201935, -122.482978806105) 1 8 3 29491 35
18912 85921 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1758 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/19/2006 12:00:00 AM 3 3x3   5988172 2103340 37.7546885917873 -122.483869713816 (37.7546885917873, -122.483869713816) 1 8 3 56 35
19341 260229 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 25 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
19462 41404 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1252 Sunnydale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/17/2000 12:00:00 AM 7   Permit Number 42021 6008157.91792 2087132.40574 37.7113292562177 -122.413606495143 (37.7113292562177, -122.413606495143) 9 7 8 309 39
19473 261023 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 631 32nd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5985931 2111585 37.7771963436428 -122.492226661995 (37.7771963436428, -122.492226661995) 11 6 2 55 26
19508 262456 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 784 Cayuga Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 02/09/2019 12:00:00 AM 3     6001253 2092432 37.7254906030662 -122.437850932396 (37.7254906030662, -122.437850932396) 9 7 6 28861 25
19612 260233 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 29 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
19627 217751 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 441 West Portal Ave 2 : Tree Private 2     2 Width 3ft   5991805.88488 2096457.39841 37.7360016106807 -122.470801561553 (37.7360016106807, -122.470801561553) 1 8 4 59 40
19648 114286 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 1801X 16TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       2x4   5991146 2103109 37.7542270070727 -122.473568070103 (37.7542270070727, -122.473568070103) 1 8 4 56 12
19954 86412 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1837X 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/19/2006 12:00:00 AM 3 3x3   5988124.549971 2102801.454812 37.7532071291716 -122.483994317971 (37.7532071291716, -122.483994317971) 1 8 3 56 35
19965 42912 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 2624 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42823 6010365.23344045 2103432.32493154 37.756209071018 -122.40712563844 (37.756209071018, -122.40712563844) 10 4 7 28859 19
19988 85916 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1838 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/19/2006 12:00:00 AM 3 3x3   5988170.1375 2102775.399 37.7531382408152 -122.483834758682 (37.7531382408152, -122.483834758682) 1 8 3 56 35
20103 210188 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 511 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5998607.30137 2094965.41627 37.7322959685703 -122.447179088249 (37.7322959685703, -122.447179088249) 9 7 4 59 40
20188 25908 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1744 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/1997 12:00:00 AM 6 3X3   6014300.07795 2096067.04044 37.7362049671689 -122.393002190722 (37.7362049671689, -122.393002190722) 10 3 8 58 1
20237 42318 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 301 Edna St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42532 5998734.92164885 2093801.38025355 37.7291070907004 -122.446654155848 (37.7291070907004, -122.446654155848) 9 7 4 28861 40
20247 41013 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 1200 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/1999 12:00:00 AM     Permit Number 41817 6016113.76612701 2103352.32554079 37.7563094360414 -122.387239488996 (37.7563094360414, -122.387239488996) 10 3 8 28856 29
20495 210102 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1375 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5991112.23533 2106068.30241 37.7623505127853 -122.47390072154 (37.7623505127853, -122.47390072154) 1 8 11 56 12
20585 185794 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1636 Pacheco St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5989817.1639 2101782.2212 37.7505069782885 -122.478066471132 (37.7505069782885, -122.478066471132) 1 8 3 29491 35
20726 193574 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1101 Illinois St 15 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6016138.78787 2103882.6002 37.7577668436722 -122.387189940687 (37.7577668436722, -122.387189940687) 10 3 8 28856 29
20888 141868 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1224 TURK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004136.2776 2112564.142 37.7809322725586 -122.429318647091 (37.7809322725586, -122.429318647091) 7 9 11 29490 41
21035 56920 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1215 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM 6   Permit Number 775369 5987049.1527 2106973.4458 37.764599608453 -122.488019735539 (37.764599608453, -122.488019735539) 1 8 3 56 35
21054 202253 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1 Kalmanovitz St 45 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6013211.00283 2093308.76677 37.7285707590106 -122.396574305077 (37.7285707590106, -122.396574305077) 10 3 8 58 1

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