trees
1,121 rows where qSpecies_id = 6 sorted by qCareAssistant descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30044 | 254525 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/07/2012 12:00:00 AM | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | ||
| 40337 | 254524 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/10/2015 07:56:00 AM | 3 | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |
| 98805 | 254526 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |||
| 138944 | 114692 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | ||
| 149723 | 254437 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1408 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:04:00 PM | 3x3 | 5981264 | 2105479 | 37.7601571100533 | -122.507917756824 | (37.7601571100533, -122.507917756824) | 1 | 8 | 3 | 56 | 35 | ||
| 186945 | 254438 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:14:00 PM | 3x3 | 5981265 | 2105453 | 37.7600857804311 | -122.507912368787 | (37.7600857804311, -122.507912368787) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |
| 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 | |||
| 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 |
| 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 | ||||||||||||
| 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 | |||
| 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 | ||||||||||||
| 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 | ||||||||||||
| 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 | ||
| 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 | ||||||||||||
| 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 | ||||||||||||
| 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 | |||
| 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 | ||
| 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 | ||||||||||||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | ||||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||||||||||
| 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 | ||||||||||
| 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 | ||||||||||||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | |
| 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 |
| 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 | ||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |
| 29381 | 94673 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53809 | 5997706.3 | 2095032.9 | 37.7324297402139 | -122.450298904109 | (37.7324297402139, -122.450298904109) | 9 | 7 | 4 | 59 | 40 | |
| 29816 | 95998 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054684 | (37.7362914700729, -122.39132054684) | 10 | 3 | 8 | 58 | 1 | |
| 31883 | 84000 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 440X Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 771053 | 5991504.89622125 | 2099785.75892313 | 37.7451230278663 | -122.472084716598 | (37.7451230278663, -122.472084716598) | 1 | 8 | 4 | 29491 | 40 | |
| 32050 | 92441 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1368 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52832 | 5982163.8853 | 2105798.2136 | 37.7610865595393 | -122.504829187778 | (37.7610865595393, -122.504829187778) | 1 | 8 | 3 | 56 | 35 |
| 34355 | 80237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.493852234736 | (37.7558298048279, -122.493852234736) | 1 | 8 | 3 | 56 | 35 | |||
| 35535 | 106607 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 36596 | 50110 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 250 Taraval St | 1 | 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 | ||
| 36793 | 95431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1938 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767296 | 5988810.2856 | 2102122.1786 | 37.7513819161329 | -122.481573187512 | (37.7513819161329, -122.481573187512) | 1 | 8 | 3 | 29491 | 35 |
| 37255 | 108775 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 37491 | 95899 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989072.0669 | 2103701.2996 | 37.7557329794721 | -122.480783524363 | (37.7557329794721, -122.480783524363) | 1 | 8 | 3 | 56 | 35 |
| 41094 | 51607 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) | 15 | 5 | 11 | 29492 | 9 |
| 44173 | 49818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1300 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46609 | 6012222.38132 | 2102319.17957 | 37.7532563730854 | -122.400624753529 | (37.7532563730854, -122.400624753529) | 10 | 3 | 8 | 28856 | 29 |
| 44272 | 92401 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1215 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52801 | 5985169.7 | 2106911.6 | 37.7643199783579 | -122.494515603708 | (37.7643199783579, -122.494515603708) | 1 | 8 | 3 | 56 | 35 |
| 47209 | 165132 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995776.8676 | 2094560.79185 | 37.7310228361347 | -122.456935228771 | (37.7310228361347, -122.456935228771) | 9 | 7 | 4 | 28861 | 40 |
| 48782 | 83518 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003951.4498 | 2093338.17621 | 37.7281318376981 | -122.428587192249 | (37.7281318376981, -122.428587192249) | 9 | 7 | 6 | 28861 | 5 |
| 49016 | 257890 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1266 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782773 | 5983690.81524 | 2106537.44734 | 37.7632059962022 | -122.499602915235 | (37.7632059962022, -122.499602915235) | 1 | 8 | 3 | 56 | 35 | |
| 49657 | 46433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011103.47209 | 2089684.58226 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | 10 | 7 | 8 | 309 | 28 |
| 49974 | 73594 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.7875805296608 | -122.414547298434 | (37.7875805296608, -122.414547298434) | 5 | 1 | 10 | 28858 | 21 | |
| 50062 | 254193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1265 Monterey Blvd | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 01/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781221 | 5994091.43615 | 2094320.67109 | 37.7302665946388 | -122.462744594485 | (37.7302665946388, -122.462744594485) | 9 | 8 | 4 | 59 | 40 |
| 50370 | 109275 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) | 1 | 8 | 3 | 56 | 35 |
| 51502 | 94694 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
| 53141 | 71841 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 1 | 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 | ||
| 53300 | 95720 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 5 | 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 | |
| 54619 | 108768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 57001 | 36152 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | 4 | Permit Number 39237 | 5996489.9045 | 2114249.7041 | 37.7851245233187 | -122.455892946486 | (37.7851245233187, -122.455892946486) | 11 | 6 | 1 | 54 | 31 | |
| 59014 | 95404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | 2 | 7 | 5 | 63 | 22 | |
| 60329 | 255502 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 248 Arlington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781971 | 6004730.8147 | 2096705.01729 | 37.7374205056678 | -122.426132488181 | (37.7374205056678, -122.426132488181) | 2 | 7 | 5 | 63 | 7 | |
| 61823 | 109689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.73547 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) | 9 | 7 | 6 | 28861 | 5 |
| 63992 | 39614 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 577 Frederick St | 2 | 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 | ||
| 64938 | 256897 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 67418 | 255648 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2834 Polk St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779253 | 6006100.90264 | 2120497.78973 | 37.8028271147622 | -122.423086110708 | (37.8028271147622, -122.423086110708) | 5 | 9 | 1 | 28858 | 32 | |
| 67542 | 95712 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) | 9 | 7 | 6 | 28861 | 5 |
| 68030 | 68546 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 707 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767769 | 5982568.02637 | 2110928.64305 | 37.7751970082773 | -122.503811440592 | (37.7751970082773, -122.503811440592) | 11 | 6 | 2 | 55 | 26 |
| 68252 | 106608 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 68598 | 109688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.93373 | 2090069.72294 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) | 9 | 7 | 6 | 28861 | 5 |
| 76025 | 47840 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4400 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 4 | Permit Number 45601 | 5981916.04684 | 2110333.39441 | 37.7735242722092 | -122.506022602317 | (37.7735242722092, -122.506022602317) | 11 | 6 | 2 | 55 | 26 |
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) );