1,121 rows where qSpecies_id = 6

View and edit SQL

Suggested facets: qLegalStatus_id, qSiteInfo, qCaretaker_id, PlotSize, Police Districts, Zip Codes

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)
8 264824 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
25 49783 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3   Permit Number 46568 6011944.29976 2088937.30454 37.7164970376796 -122.400646428989 (37.7164970376796, -122.400646428989) 10 7 8 309 39
334 162296 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 299 Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6010920.41592 2090984.45712 37.7220609417541 -122.40432950351 (37.7220609417541, -122.40432950351) 10 3 7 309 28
425 10157 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 995 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x7   6005745.76106 2103227.37374 37.7553867222415 -122.423086804612 (37.7553867222415, -122.423086804612) 2 4 5 28859 19
618 238270 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 4102 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002298.332 2104734.40291 37.7593295173753 -122.435116825204 (37.7593295173753, -122.435116825204) 2 4 5 28862 3
639 261347 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
664 262379 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 925 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2020 12:00:00 AM 3 3x3   5998032 2106999 37.7653043483693 -122.450035028723 (37.7653043483693, -122.450035028723) 15 5 11 29492 9
887 60297 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1101 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1982 12:00:00 AM 7   Permit Number 19862 6013032.9382 2107035.865 37.7662525295396 -122.398152546702 (37.7662525295396, -122.398152546702) 14 3 8 28856 20
1126 262542 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1260 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/18/2020 12:00:00 AM       6015016 2090665 37.7214117898675 -122.390149655616 (37.7214117898675, -122.390149655616) 10 3 8 58 1
1269 262440 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
1415 171287 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 339 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003711.94249 2092708.61039 37.7263896332495 -122.429370301207 (37.7263896332495, -122.429370301207) 9 7 6 28861 5
1417 88463 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 955X Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471) 10 3 8 58 1
1481 172310 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 63 Seville St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/23/2020 12:00:00 AM 3 Width 3ft   6001999.53893 2087418.49495 37.7117670587831 -122.434911834617 (37.7117670587831, -122.434911834617) 9 7 6 28861 5
1777 260927 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 354 Point Lobos Ave 1 Sidewalk: Property side : Cutout Tree Private 2       Width 4ft   5981645 2112753 37.7801518383055 -122.507139709579 (37.7801518383055, -122.507139709579) 11 6 2 55 26
1839 227130 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 200 Portola Dr 2 : Tree Private 2     3 Width 3ft   5999573.30223 2100550.73469 37.7476870722101 -122.444240631696 (37.7476870722101, -122.444240631696) 2 4 5 63 38
1882 170658 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 4x6   6000800.50336 2092551.29112 37.7257924078835 -122.439423717141 (37.7257924078835, -122.439423717141) 9 7 6 28861 25
1932 250999 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 206 Point Lobos Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5982160.80138 2112648.74636 37.7798959540729 -122.505347618625 (37.7798959540729, -122.505347618625) 11 6 2 55 26
1967 259348 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450x Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
1972 64568 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1888 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2008 12:00:00 AM 4 3x3 Permit Number 51776 6000584.4368 2111720.243 37.7784134187795 -122.441545602938 (37.7784134187795, -122.441545602938) 15 5 11 29490 41
2103 262299 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 209 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
2299 27284 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 636 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2009 12:00:00 AM 3 3X3   6005588.17954 2093528.26307 37.7287462653044 -122.422942457136 (37.7287462653044, -122.422942457136) 9 7 7 309 5
2314 227584 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 660 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002549.44678 2108867.98451 37.7706935809695 -122.434543909369 (37.7706935809695, -122.434543909369) 15 5 11 29492 9
2502 84554 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 804 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5986976.65331 2110412.96099 37.7740393278808 -122.488523300237 (37.7740393278808, -122.488523300237) 11 6 2 55 26
2654 108556 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 62 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/2019 12:00:00 AM 3 3x3 Permit Number 773715 6001062.72482 2093636.21513 37.7287862806562 -122.43859494063 (37.7287862806562, -122.43859494063) 9 7 6 28861 25
2780 79224 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3562 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5997807.39537 2115154.90167 37.7876854832564 -122.451400172276 (37.7876854832564, -122.451400172276) 11 6 1 54 31
2908 93406 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1408 Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/24/2015 11:15:00 AM 3 3x3   5988828.0589 2099030.2661 37.7428933746541 -122.48128533094 (37.7428933746541, -122.48128533094) 1 8 3 29491 35
2939 262442 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
3013 109184 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 5 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/2015 12:00:00 AM 3 3x3 Permit Number 774827 6002270 2092514.4 37.7257746335194 -122.434341145327 (37.7257746335194, -122.434341145327) 9 7 6 28861 25
3117 260221 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
3177 191238 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1600 Newhall St 8 : Tree Private 2     2 Width 2ft   6014118.19632 2095356.58877 37.7342441078693 -122.393581327137 (37.7342441078693, -122.393581327137) 10 3 8 58 1
3183 260224 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 20 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
3377 227135 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 200 Portola Dr 11 : Tree Private 2     2 Width 3ft   5999460.85655 2100362.14837 37.7471628438967 -122.444615908893 (37.7471628438967, -122.444615908893) 2 4 5 63 38
3613 227144 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Rivoli St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5997515.89511 2105898.72706 37.7622537322474 -122.451740727559 (37.7622537322474, -122.451740727559) 15 5 11 29492 9
3636 83176 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3301 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6 3x3   5985317.61354 2111082.30707 37.7757802155228 -122.494311467187 (37.7757802155228, -122.494311467187) 11 6 2 55 26
3652 248155 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 235 Rutledge St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010048.23979 2099492.44346 37.7453732829604 -122.40794409015 (37.7453732829604, -122.40794409015) 2 7 7 28859 2
4231 261663 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 1099x Broadway   Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3   6008393 2118190 37.7966195766837 -122.414990814528 (37.7966195766837, -122.414990814528) 5 1 10 308 21
4801 125249 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1077 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 Width 3ft   6008457.69643 2118247.71377 37.7967816796858 -122.414771036277 (37.7967816796858, -122.414771036277) 5 1 10 308 21
4850 262150 Private 9 Lagunaria patersonii :: Primrose Tree 6 1295 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
5588 227150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 808 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008185.20329 2095640.92661 37.7346933830922 -122.414113755053 (37.7346933830922, -122.414113755053) 2 7 7 28859 2
5614 259341 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Bacon St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
5680 227559 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 84 Seward St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6000741.27617 2104538.3206 37.7587025846742 -122.44048780488 (37.7587025846742, -122.44048780488) 2 4 5 28862 38
5784 260220 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
6009 89545 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 5328 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/26/2008 12:00:00 AM 3 3x3   5982088.22815 2111702.21274 37.7772927805161 -122.505528495685 (37.7772927805161, -122.505528495685) 11 6 2 55 26
6021 260882 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 810 33rd Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5985734.50152 2110356.92333 37.7738129057539 -122.492815926544 (37.7738129057539, -122.492815926544) 11 6 2 55 26
6051 207048 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 658 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 Width 2ft Permit Number 772511 5997718.79866 2095007.66028 37.7323611532403 -122.450253874818 (37.7323611532403, -122.450253874818) 9 7 4 59 40
6137 82588 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 675 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:00:00 AM 4 3x3 Permit Number 52676 5983177.86359 2111217.50955 37.7760259908371 -122.501723286949 (37.7760259908371, -122.501723286949) 11 6 2 55 26
6290 259344 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Somerset St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3     6009725.84271 2093690.47402 37.7294242696948 -122.408649667073 (37.7294242696948, -122.408649667073) 10 3 7 309 28
6557 264929 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 4725 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 12:00:00 AM 3 3x3 Permit Number 784398 5981118.81181 2106198.14775 37.7621231273763 -122.508473270866 (37.7621231273763, -122.508473270866) 1 8 3 56 35
6683 262152 Private 9 Lagunaria patersonii :: Primrose Tree 6 1295 47th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
6798 125247 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1085 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3 Permit Number 782055 6008420.1565 2118241.89629 37.796763597016 -122.414900521554 (37.796763597016, -122.414900521554) 5 1 10 308 21
7092 118587 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 134 Point Lobos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5982351 2112664 37.7799490263229 -122.504690778822 (37.7799490263229, -122.504690778822) 11 6 2 55 26
7686 116544 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 7 Median : Yard Tree DPW 1     5 3x3   6001586.02621 2088182.95127 37.7138425996209 -122.436395723209 (37.7138425996209, -122.436395723209) 9 7 6 28861 5
8142 262151 Private 9 Lagunaria patersonii :: Primrose Tree 6 1295 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
8242 264706 Private 9 Lagunaria patersonii :: Primrose Tree 6 4345 Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2020 12:00:00 AM 3     5982064.28374 2113052.50483 37.7809988756405 -122.505711450059 (37.7809988756405, -122.505711450059) 11 6 2 55 26
8275 123462 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 620 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5995351.08305 2111296.01241 37.7769490481008 -122.459618879478 (37.7769490481008, -122.459618879478) 11 6 2 54 11
8363 238269 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 4102 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002324.68279 2104735.52248 37.7593340877084 -122.435025771543 (37.7593340877084, -122.435025771543) 2 4 5 28862 3
8715 260222 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
8734 227141 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Rivoli St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5997670.57496 2105917.36363 37.7623137611024 -122.451207095032 (37.7623137611024, -122.451207095032) 15 5 11 29492 9
9404 176900 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005606.72127 2092829.97134 37.7268299557374 -122.422828750447 (37.7268299557374, -122.422828750447) 9 7 7 309 5
9408 259103 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 625 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010501.76504 2086856.29359 37.7107024439005 -122.405486089504 (37.7107024439005, -122.405486089504) 9 7 8 309 39
9616 92857 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1101 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2009 12:00:00 AM     Permit Number 53074 6001966 2100891 37.7487575771252 -122.435991171851 (37.7487575771252, -122.435991171851) 2 4 5 28862 22
9692 183446 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2511 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   10/08/2020 12:00:00 AM 3 Width 0ft   5988279.6214 2098205.3016 37.7405963382743 -122.483121197886 (37.7405963382743, -122.483121197886) 1 8 3 29491 35
9738 79640 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 168 Orsi Cir 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6012982.50067 2092948.34875 37.727568405236 -122.397338990501 (37.727568405236, -122.397338990501) 10 3 8 58 1
9840 256599 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 26 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
9949 162295 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 299 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6010903.85659 2090979.54911 37.7220465400048 -122.404386400036 (37.7220465400048, -122.404386400036) 10 3 7 309 28
10037 183693 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983046.6569 2105897.5428 37.7614111825323 -122.501783460946 (37.7614111825323, -122.501783460946) 1 8 3 56 35
10101 180653 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 245 Chicago Way 1 Sidewalk: Curb side : Yard Tree Private 2   10/11/2017 07:56:00 AM 3 Width 6ft   6002847.75966 2086772.69306 37.7100419513527 -122.431934068713 (37.7100419513527, -122.431934068713) 9 7 6 28861 5
10151 146941 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 763 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5982269.93422 2110578.75305 37.7742187803997 -122.504816658869 (37.7742187803997, -122.504816658869) 11 6 2 55 26
10365 256095 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982503.90034 2112800.93962 37.7803340153983 -122.504171983842 (37.7803340153983, -122.504171983842) 11 6 2 55 26
10383 264872 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2426 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/2020 06:03:00 PM 3 4x6   5985846 2098694 37.7417962544182 -122.491571569344 (37.7417962544182, -122.491571569344) 1 8 3 29491 35
10393 3666 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 102 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:06:00 PM 3 3X3   6017134.48475 2098914.37607 37.7441802162386 -122.383400533034 (37.7441802162386, -122.383400533034) 10 3 8 58 1
10461 170660 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 301X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2020 12:00:00 AM 3 Width 3ft   6000886.10189 2092489.73569 37.7256282618212 -122.439123400224 (37.7256282618212, -122.439123400224) 9 7 6 28861 25
10786 95722 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
11368 259340 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Bacon St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
11481 3673 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 109 Sidewalk: Curb side : Cutout Tree Port 6   04/10/2017 10:21:00 AM 3 3X3   6017015.17172 2099002.62034 37.7444159222737 -122.383819238476 (37.7444159222737, -122.383819238476) 10 3 8 58 1
11900 3534 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 44 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:10:00 AM 3 3X3   6018402.12937 2097818.41667 37.7412409080406 -122.378941151133 (37.7412409080406, -122.378941151133) 10 3 8 58 1
12065 88481 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1221 Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 5 3x3 Permit Number 51432 6014818.59944 2096228.0421 37.7366758342199 -122.391220684988 (37.7366758342199, -122.391220684988) 10 3 8 58 1
12096 83834 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2300X Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6013045.53048 2096356.5558 37.7369301480983 -122.397360003177 (37.7369301480983, -122.397360003177) 10 3 8 58 1
12204 164659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 150 Granville Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 Width 4ft Permit Number 785596 5994533.58351 2098539.8464 37.7418768645301 -122.461521809887 (37.7418768645301, -122.461521809887) 1 8 4 59 40
12222 31158 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 600 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/2020 12:00:00 AM 3   Permit Number 785248 5993522.80361 2089878.90243 37.7180378119737 -122.464388049089 (37.7180378119737, -122.464388049089) 9 8 6 64 24
12282 83440 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2230 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011076.92464 2105580.38381 37.7621469638337 -122.404815578978 (37.7621469638337, -122.404815578978) 8 3 8 28856 29
12542 262149 Private 9 Lagunaria patersonii :: Primrose Tree 6 4600 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3                        
12651 261028 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 743 20th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM 3 3x3   5989712 2110287 37.7738527032106 -122.479052157213 (37.7738527032106, -122.479052157213) 11 6 2 55 26
12652 89597 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4425 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5984898.50732 2111748.34415 37.7775844268692 -122.495810381718 (37.7775844268692, -122.495810381718) 11 6 2 55 26
12664 45661 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 315 London St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/2001 12:00:00 AM 6   Permit Number 44357 6002302.86118 2091870.52112 37.7240085522374 -122.434181537449 (37.7240085522374, -122.434181537449) 9 7 6 28861 5
12682 260425 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 508 Dwight St   Unaccepted Street : Yard Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3     6010099.90949 2091269.80828 37.7227985719868 -122.407185909529 (37.7227985719868, -122.407185909529) 10 3 7 309 28
12813 207010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 305 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5999351.3193 2094355.62728 37.7306641145479 -122.444563045861 (37.7306641145479, -122.444563045861) 9 7 4 28861 40
12847 171236 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 39 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003761.27522 2093172.4115 37.7276659205371 -122.429232817353 (37.7276659205371, -122.429232817353) 9 7 6 28861 5
12906 27193 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 284 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2009 12:00:00 AM 6 3X3   6003096.09594 2093601.65823 37.7288068562446 -122.431562981455 (37.7288068562446, -122.431562981455) 9 7 6 28861 25
12985 229829 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1472 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2020 12:00:00 AM 3 Width 6ft   6010097.10021 2100699.13339 37.7486893243481 -122.407860213076 (37.7486893243481, -122.407860213076) 2 4 7 28859 19
13074 264871 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2430 36th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/15/2020 12:00:00 AM 3 4x6   5985228 2098648 37.7416338152793 -122.493704989969 (37.7416338152793, -122.493704989969) 1 8 3 29491 35
13199 261348 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
13391 119240 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 50 Sutro Heights Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5981455.34518 2111336.83463 37.776252294734 -122.507690683983 (37.776252294734, -122.507690683983) 11 6 2 55 26
13541 60816 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2110 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/1983 12:00:00 AM 4   Permit Number 20494 5989779.2235 2100978.3623 37.7482975910503 -122.478138904702 (37.7482975910503, -122.478138904702) 1 8 3 29491 35
13551 10193 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1170 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 2x2   6005736.25987 2102154.58599 37.7524405594089 -122.423043415947 (37.7524405594089, -122.423043415947) 2 4 5 28859 19
13622 207003 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2380 Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5992355.41935 2099194.17897 37.7435478822362 -122.469100735806 (37.7435478822362, -122.469100735806) 1 8 4 29491 40
13676 262543 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1260 Egbert Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/18/2020 12:00:00 AM       6015062.6163 2090599.75011 37.7212352119804 -122.389983958896 (37.7212352119804, -122.389983958896) 10 3 8 58 1
13726 80104 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 425 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 52309 6003144.80516 2091503.70271 37.7230491006299 -122.43124489935 (37.7230491006299, -122.43124489935) 9 7 6 28861 5
13775 68397 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 88 Lyell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2020 12:00:00 AM 3   Permit Number 785230 6003105.95459 2094517.30646 37.7313215783119 -122.43159424368 (37.7313215783119, -122.43159424368) 9 7 5 28861 25
13960 27162 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1700X Silver Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1   07/28/2011 12:00:00 AM 3 3x3   6011270.31088 2095195.56425 37.7336433130742 -122.40341610708 (37.7336433130742, -122.40341610708) 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)
);