trees
1,121 rows where qSpecies_id = 6
This data as json, CSV (advanced)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14180 | 256094 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777292 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | |
| 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 | |||
| 14258 | 261352 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780859 | 5994172 | 2087374 | 37.7111973453091 | -122.461962532307 | (37.7111973453091, -122.461962532307) | 9 | 8 | 6 | 28861 | 24 | |
| 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 | ||
| 14691 | 69919 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.7286182461033 | -122.470591251084 | (37.7286182461033, -122.470591251084) | 9 | 8 | 4 | 59 | 40 | ||
| 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 | |||
| 15168 | 259102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 619 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010517.89431 | 2086850.21293 | 37.7106866494876 | -122.405429914879 | (37.7106866494876, -122.405429914879) | 9 | 7 | 8 | 309 | 39 | |||
| 15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | 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 | |
| 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 | |
| 15368 | 262300 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 2 | 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 | |
| 15370 | 50774 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47304 | |||||||||||||||
| 15444 | 89331 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201 | 2105201 | 37.7604913603716 | -122.4424038966 | (37.7604913603716, -122.4424038966) | 15 | 4 | 5 | 28862 | 3 | |||
| 15493 | 259346 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 106 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6011005.88556 | 2093460.4594 | 37.728864306632 | -122.404208230977 | (37.728864306632, -122.404208230977) | 10 | 3 | 7 | 309 | 28 | ||
| 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 | ||
| 16027 | 261349 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 4 | 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 | |
| 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 | |||
| 16248 | 264659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 971 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014920.44131 | 2089617.70445 | 37.7185308216427 | -122.390406839913 | (37.7185308216427, -122.390406839913) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 16338 | 261024 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 751 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989703 | 2110237 | 37.773714894321 | -122.479079631213 | (37.773714894321, -122.479079631213) | 11 | 6 | 2 | 55 | 26 | |||
| 16369 | 90706 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4332 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982115.66772 | 2110342.56784 | 37.7735612082427 | -122.505332776144 | (37.7735612082427, -122.505332776144) | 11 | 6 | 2 | 55 | 26 | ||
| 16581 | 258150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2485 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 5989205.22412 | 2098441.55094 | 37.7412988370865 | -122.479938140892 | (37.7412988370865, -122.479938140892) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 16718 | 262177 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | |||
| 17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17128 | 39895 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50795 | 6001095.73329197 | 2104700.06064199 | 37.7591668603211 | -122.439273525739 | (37.7591668603211, -122.439273525739) | 2 | 4 | 5 | 28862 | 3 | ||
| 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 | |||
| 17357 | 116552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 8 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | 9 | 7 | 6 | 28861 | 5 | |||
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 17639 | 260223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 17693 | 259347 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450x Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | ||
| 18289 | 88190 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1118 Harrison St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631 | 2110372 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | ||
| 18773 | 255529 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782018 | ||||||||||
| 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 | ||
| 19087 | 261350 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
| 19156 | 259400 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1649 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
| 19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
| 19297 | 58021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971657 | (37.7625717348083, -122.50121971657) | 1 | 8 | 3 | 56 | 35 | ||
| 19327 | 262176 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
| 19468 | 95897 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989075.8995 | 2103638.8826 | 37.7555618218669 | -122.480765700813 | (37.7555618218669, -122.480765700813) | 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 | |||
| 19677 | 39613 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 577 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42206 | 5996839.91957309 | 2107330.11638831 | 37.7661452244472 | -122.454182049235 | (37.7661452244472, -122.454182049235) | 15 | 5 | 11 | 29492 | 12 | ||
| 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 | |||
| 19897 | 102064 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52559 | 6007929.8 | 2098099.2 | 37.7414289135067 | -122.415170728099 | (37.7414289135067, -122.415170728099) | 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 | ||||
| 20394 | 48661 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1300 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2005 12:00:00 AM | Permit Number 45949 | 5992726.08644889 | 2106595.37916826 | 37.7638910715093 | -122.468357408335 | (37.7638910715093, -122.468357408335) | 1 | 8 | 11 | 56 | 12 | ||
| 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 | |||
| 20629 | 51532 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3155 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 2 | Permit Number 47834 | 5999712.30266 | 2115373.43094 | 37.78839440084 | -122.44482529806 | (37.78839440084, -122.44482529806) | 13 | 6 | 1 | 29490 | 27 | ||
| 20742 | 47826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4350 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/13/2002 12:00:00 AM | 2 | Permit Number 45588 | 5982100.44481 | 2110341.38072 | 37.7735570529717 | -122.505385345551 | (37.7735570529717, -122.505385345551) | 11 | 6 | 2 | 55 | 26 | |
| 21393 | 87031 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52524 | 5994278.21944 | 2115255.72364 | 37.7877595955023 | -122.463617666169 | (37.7877595955023, -122.463617666169) | 11 | 6 | 1 | 54 | 11 | |
| 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 | |||
| 21610 | 83554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003920.58239 | 2093359.59743 | 37.7281889086723 | -122.428695428367 | (37.7281889086723, -122.428695428367) | 9 | 7 | 6 | 28861 | 5 |
| 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 | ||
| 21675 | 50111 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 250 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46832 | 5992489.27392501 | 2099148.73533454 | 37.7434308389356 | -122.468634598074 | (37.7434308389356, -122.468634598074) | 1 | 8 | 4 | 29491 | 40 | ||
| 21976 | 26983 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1395 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6009622.93574 | 2094432.56882 | 37.7314561402837 | -122.409057769215 | (37.7314561402837, -122.409057769215) | 9 | 3 | 7 | 309 | 28 | ||
| 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 | |||
| 22554 | 88615 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 521 03rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51567 | 5994972.63478 | 2111950.42136 | 37.7787241118896 | -122.460975481067 | (37.7787241118896, -122.460975481067) | 11 | 6 | 2 | 54 | 11 | |
| 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 | ||
| 23031 | 88096 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.499127022602 | (37.7534794912156, -122.499127022602) | 1 | 8 | 3 | 56 | 35 | |||
| 23262 | 51411 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1578 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51340 | 5989038.1128 | 2104597.9638 | 37.7581930050331 | -122.480966595693 | (37.7581930050331, -122.480966595693) | 1 | 8 | 3 | 56 | 35 | |
| 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 | |||
| 23895 | 92663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 23899 | 95684 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 334 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767433 | 6006626.2 | 2092405.9 | 37.72572301772 | -122.419274361386 | (37.72572301772, -122.419274361386) | 9 | 7 | 7 | 309 | 5 | |
| 24082 | 88257 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536 | 2106665 | 37.76441609532 | -122.448267765661 | (37.76441609532, -122.448267765661) | 15 | 5 | 11 | 29492 | 9 | ||
| 24139 | 95719 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 4 | 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 | |
| 24170 | 41808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999945.6987 | 2112165.7027 | 37.7796001259133 | -122.443787242166 | (37.7796001259133, -122.443787242166) | 15 | 5 | 1 | 29490 | 16 | |
| 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 | |||
| 24639 | 43060 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 3054 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | Permit Number 53563 | 5983697 | 2098912 | 37.7422690003261 | -122.499018090006 | (37.7422690003261, -122.499018090006) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 24945 | 89565 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5001X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782749 | 5983089.78021 | 2111680.23644 | 37.777291329944 | -122.502062233879 | (37.777291329944, -122.502062233879) | 11 | 6 | 2 | 55 | 26 |
| 25141 | 95718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 3 | 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 | |
| 25168 | 83917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1484 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50173 | 5981576.71105327 | 2104986.37444115 | 37.7588229209977 | -122.506799717054 | (37.7588229209977, -122.506799717054) | 1 | 8 | 3 | 56 | 35 | |
| 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 | |||
| 25283 | 3523 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:28:00 AM | 3 | 3X3 | 6018216.35215 | 2097958.49501 | 37.7416152904271 | -122.379593238756 | (37.7416152904271, -122.379593238756) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 27064 | 182564 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2122 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | Permit Number 783239 | 5989402.8067 | 2098365.7306 | 37.7411021315374 | -122.479249432397 | (37.7411021315374, -122.479249432397) | 1 | 8 | 3 | 29491 | 35 | ||
| 27543 | 83558 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52321 | 6001949.50225 | 2090800.06366 | 37.7210492547906 | -122.435326507535 | (37.7210492547906, -122.435326507535) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );