957 rows where qCaretaker_id = 2 and qSpecies_id = 6 sorted by PermitNotes

View and edit SQL

qCaretaker_id

  • Private · 957
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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                        
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
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
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
14207 176903 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 290 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6005283.95555 2093790.15237 37.7294481843731 -122.424012796049 (37.7294481843731, -122.424012796049) 9 7 6 28861 5
14410 170659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 6x4   6000830.95965 2092528.01217 37.7257302224446 -122.439316764384 (37.7257302224446, -122.439316764384) 9 7 6 28861 25
14976 160069 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:26:00 AM 3 Width 0ft   6000296.79811 2090527.78789 37.7202076512361 -122.441019880684 (37.7202076512361, -122.441019880684) 9 7 6 28861 25
15013 170657 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 Width 3ft   6000770.58972 2092571.08998 37.7258450685777 -122.439528544816 (37.7258450685777, -122.439528544816) 9 7 6 28861 25
15133 129382 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008704.56308 2112447.63135 37.7808699297471 -122.413506401504 (37.7808699297471, -122.413506401504) 7 10 9 28852 36
15310 262443 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 5 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
15346 262448 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 145 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/2019 12:00:00 AM 3 3x3   6001496 2093037 37.7271656105126 -122.43705419947 (37.7271656105126, -122.43705419947) 9 7 6 28861 25
15585 258769 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1633 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2019 12:00:00 AM 3 3x3   5988962.35654 2103065.4403 37.7539807026125 -122.481116375927 (37.7539807026125, -122.481116375927) 1 8 3 56 35
15599 262439 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 1 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
16149 244604 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4020 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6002870 2104782 37.7594926524767 -122.433143121723 (37.7594926524767, -122.433143121723) 2 4 5 28862 3
16319 258436 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4050 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002636 2104802 37.7595342910111 -122.433953838093 (37.7595342910111, -122.433953838093) 2 4 5 28862 3
16685 251006 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 348 Point Lobos Ave 1 Sidewalk: Property side : Cutout Tree Private 2     2 Width 4ft   5981660.38525 2112713.01394 37.7800429545487 -122.507083518802 (37.7800429545487, -122.507083518802) 11 6 2 55 26
16773 70408 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6006531.16259 2092699.03842 37.7265225593592 -122.419623688079 (37.7265225593592, -122.419623688079) 9 7 7 309 5
17284 81630 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 50 Paulding St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5999996.8419 2093367.66723 37.7279882186648 -122.44226048643 (37.7279882186648, -122.44226048643) 9 7 6 28861 25
17459 24778 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Point Lobos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5982415.49737 2112552.2939 37.7796461080741 -122.504459379242 (37.7796461080741, -122.504459379242) 11 6 2 55 26
17698 264705 Private 9 Lagunaria patersonii :: Primrose Tree 6 4345 Clement St 1 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
17874 170661 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 301X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 Width 3ft   6000920.86362 2092466.57168 37.7255666366796 -122.439001572678 (37.7255666366796, -122.439001572678) 9 7 6 28861 25
17906 219682 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 250 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2019 12:00:00 AM 3 3x3   6008245.78846 2097431.26822 37.7396126728914 -122.414030905009 (37.7396126728914, -122.414030905009) 2 7 7 28859 2
18371 27202 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 302 Silver Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM 6 3X3   6003502.33889 2093475.71167 37.7284840526724 -122.430149591636 (37.7284840526724, -122.430149591636) 9 7 6 28861 5
18909 262153 Private 9 Lagunaria patersonii :: Primrose Tree 6 1295 47th Ave 4 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
19579 71337 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 734 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5982620.59121 2110750.54443 37.7747110919712 -122.503616418137 (37.7747110919712, -122.503616418137) 11 6 2 55 26
19808 207047 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 654 Joost Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5997739.24902 2095008.66176 37.7323650733825 -122.450183245677 (37.7323650733825, -122.450183245677) 9 7 4 59 40
19865 227149 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 530 Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007719.36141 2095678.53729 37.7347704774588 -122.415726995823 (37.7347704774588, -122.415726995823) 2 7 7 28859 2
19993 182699 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1659 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5989088.7291 2103739.8915 37.7558399109499 -122.480728726959 (37.7558399109499, -122.480728726959) 1 8 3 56 35
20055 206989 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1304 11th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5992723.56277 2106565.73006 37.7638095171187 -122.468363979738 (37.7638095171187, -122.468363979738) 1 8 11 56 12
20319 106193 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 3040 TARAVAL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983698.2 2098878.7 37.742177638004 -122.499011481047 (37.742177638004, -122.499011481047) 1 8 3 29491 35
20503 129384 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008749.2926 2112454.62361 37.7808916402666 -122.413352154294 (37.7808916402666, -122.413352154294) 7 10 9 28852 36
20622 251003 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 250 Point Lobos Ave 2 : Tree Private 2     3 Width 3ft   5981957.64195 2112675.64357 37.7799578490271 -122.506052420011 (37.7799578490271, -122.506052420011) 11 6 2 55 26
21404 129375 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 454 Walnut St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5998637.858 2115126.26996 37.7876543864995 -122.448524881439 (37.7876543864995, -122.448524881439) 13 6 1 54 31
21439 227577 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 18 Dehon St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   6003773.27056 2106456.0684 37.7641404406581 -122.430138593823 (37.7641404406581, -122.430138593823) 8 4 5 28862 3
21462 201816 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Friedell St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 6ft   6021143.08428 2093327.21502 37.7290596700622 -122.369153577473 (37.7290596700622, -122.369153577473) 10 3 8 58 1
21599 129376 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2500 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6002240.59165 2116825.10443 37.7925242837291 -122.436181762774 (37.7925242837291, -122.436181762774) 13 9 1 29490 27
21651 27207 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 302 Silver Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM 6 3X3   6003623.95003 2093470.28644 37.7284760433174 -122.429728788952 (37.7284760433174, -122.429728788952) 9 7 6 28861 5
22543 227116 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 133 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6006472.0378 2105330.58155 37.761202600143 -122.420724416907 (37.761202600143, -122.420724416907) 2 4 7 28859 19
22726 191234 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1600 Newhall St 1 : Tree Private 2     4 Width 2ft   6014153.11677 2095403.12134 37.7343738170818 -122.393463850493 (37.7343738170818, -122.393463850493) 10 3 8 58 1
22775 27008 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1430 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1999 12:00:00 AM 3 3X3   6009940.18408 2094497.75014 37.7316528813564 -122.407965571349 (37.7316528813564, -122.407965571349) 10 3 7 309 28
23429 176881 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3303 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011991.79808 2090250.44255 37.7201052985 -122.400574440964 (37.7201052985, -122.400574440964) 10 7 8 309 28
24569 176914 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1300 Silver Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009346.09367 2094283.90387 37.7310324255937 -122.41000437762 (37.7310324255937, -122.41000437762) 9 3 7 309 28
24739 84659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 187 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5996845.0781 2111686.6666 37.7781074773999 -122.454478948332 (37.7781074773999, -122.454478948332) 15 6 2 54 16
24824 227123 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 483 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002011.92527 2100876.50462 37.7487203851357 -122.435831325762 (37.7487203851357, -122.435831325762) 2 4 5 28862 22
25262 227146 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Rivoli St 11 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5997461.46496 2105891.36034 37.7622303876487 -122.451928448466 (37.7622303876487, -122.451928448466) 15 5 11 29492 9
25340 176908 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1053 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6007885.16277 2093698.95374 37.7293442892945 -122.415013692231 (37.7293442892945, -122.415013692231) 9 3 7 309 28
25424 176901 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005600.43917 2092849.05844 37.7268820102711 -122.422851823466 (37.7268820102711, -122.422851823466) 9 7 7 309 5
25751 182700 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1651 Moraga St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5989102.9459 2103739.8915 37.7558407372502 -122.480679561224 (37.7558407372502, -122.480679561224) 1 8 3 56 35
26064 227132 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 200 Portola Dr 5 : Tree Private 2     3 Width 3ft   5999561.91472 2100471.96222 37.7474701323504 -122.444274349099 (37.7474701323504, -122.444274349099) 2 4 5 63 38
26675 207018 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 466 Staples Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5997114.73821 2093838.00202 37.7291149630685 -122.452257872798 (37.7291149630685, -122.452257872798) 9 7 4 28861 40
26995 227570 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 287 Hartford St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002738.3349 2104276.75984 37.7580979146911 -122.433562376711 (37.7580979146911, -122.433562376711) 2 4 5 28862 3
27719 250553 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 El Camino Del Mar 1 : Tree Private 2     8 Width 4ft   5988175.48547 2115367.76095 37.7877136895948 -122.484739928202 (37.7877136895948, -122.484739928202) 11 6 1 55 33

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