trees
56 rows where Zip Codes = 29492 and 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 28853 | 88712 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51654 | 6004166 | 2109783 | 37.7732976245409 | -122.429017475211 | (37.7732976245409, -122.429017475211) | 7 | 9 | 11 | 29492 | 10 | ||
| 29694 | 248531 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997658.268 | 2107761.8815 | 37.7673776340728 | -122.451382700243 | (37.7673776340728, -122.451382700243) | 15 | 5 | 11 | 29492 | 9 | |||
| 32912 | 94410 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 63 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2010 12:00:00 AM | 3x3 | Permit Number 53650 | 6001682.9 | 2108449.6 | 37.7694955715896 | -122.437511336741 | (37.7694955715896, -122.437511336741) | 15 | 5 | 5 | 29492 | 9 | ||
| 34441 | 227139 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 280 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997445.29759 | 2106455.57152 | 37.7637786424842 | -122.452025073424 | (37.7637786424842, -122.452025073424) | 15 | 5 | 11 | 29492 | 9 | |||
| 35869 | 140696 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 162 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997358.0622 | 2109907.9029 | 37.7732528619693 | -122.452575957146 | (37.7732528619693, -122.452575957146) | 15 | 5 | 11 | 29492 | 16 | |||
| 37187 | 227140 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997729.62744 | 2105927.06337 | 37.7623437750648 | -122.451003555094 | (37.7623437750648, -122.451003555094) | 15 | 5 | 11 | 29492 | 9 | |||
| 40176 | 254849 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 4x4 | 5998281 | 2110435 | 37.7747529724027 | -122.449421390814 | (37.7747529724027, -122.449421390814) | 15 | 5 | 11 | 29492 | 16 | ||
| 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 |
| 41803 | 48448 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 238 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | 7 | Permit Number 45820 | 5997868.1487 | 2109737.2703 | 37.7728135614974 | -122.45079920227 | (37.7728135614974, -122.45079920227) | 15 | 5 | 11 | 29492 | 16 | ||
| 50352 | 227104 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 35 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998773.50017 | 2105374.28879 | 37.7608857006352 | -122.447353415547 | (37.7608857006352, -122.447353415547) | 15 | 5 | 11 | 29492 | 12 | |||
| 60778 | 227145 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997490.50245 | 2105894.70205 | 37.7622412262784 | -122.451828260367 | (37.7622412262784, -122.451828260367) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||
| 65509 | 247762 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 61 Alpine Ter | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6001652.09386 | 2108463.90123 | 37.7695330877219 | -122.437618918075 | (37.7695330877219, -122.437618918075) | 15 | 5 | 5 | 29492 | 9 | |||
| 77162 | 102385 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
| 77482 | 248399 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 115 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998223.6499 | 2108104.3812 | 37.7683504092774 | -122.449451812394 | (37.7683504092774, -122.449451812394) | 15 | 5 | 11 | 29492 | 9 | |||
| 85418 | 227105 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998543.73083 | 2106633.91182 | 37.7643311769734 | -122.448238788212 | (37.7643311769734, -122.448238788212) | 15 | 5 | 11 | 29492 | 9 | |||
| 87404 | 88256 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 1 | 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 | ||
| 99415 | 51233 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.7637059584567 | -122.452316160446 | (37.7637059584567, -122.452316160446) | 15 | 5 | 11 | 29492 | 9 | |||
| 100769 | 254857 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1353 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 5x5 | 6001388 | 2110371 | 37.7747544855289 | -122.438669077925 | (37.7747544855289, -122.438669077925) | 15 | 5 | 11 | 29492 | 10 | |
| 103947 | 51230 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.7637059584567 | -122.452316160446 | (37.7637059584567, -122.452316160446) | 15 | 5 | 11 | 29492 | 9 | |||
| 106631 | 51232 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.7637059584567 | -122.452316160446 | (37.7637059584567, -122.452316160446) | 15 | 5 | 11 | 29492 | 9 | |||
| 112736 | 227106 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998542.97606 | 2106650.29925 | 37.7643761295797 | -122.448242578852 | (37.7643761295797, -122.448242578852) | 15 | 5 | 11 | 29492 | 9 | |||
| 114382 | 102384 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
| 116939 | 67239 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 3x9 | Permit Number 30703 | 6003792.49486353 | 2108815.33294247 | 37.770619498227 | -122.430240430849 | (37.770619498227, -122.430240430849) | 15 | 9 | 11 | 29492 | 10 | |
| 117490 | 227576 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 31 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001461.49083 | 2108058.43392 | 37.768408936048 | -122.438249153978 | (37.768408936048, -122.438249153978) | 15 | 5 | 5 | 29492 | 3 | |||
| 121708 | 227138 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 280 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997418.34488 | 2106450.27883 | 37.7637625662163 | -122.452117912216 | (37.7637625662163, -122.452117912216) | 15 | 5 | 11 | 29492 | 9 | |||
| 124185 | 227585 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003798.52213 | 2108785.73673 | 37.7705385756322 | -122.430217470683 | (37.7705385756322, -122.430217470683) | 15 | 9 | 11 | 29492 | 10 | |||
| 125420 | 245893 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001728.4463 | 2109399.5631 | 37.772106523732 | -122.437421829009 | (37.772106523732, -122.437421829009) | 15 | 5 | 11 | 29492 | 9 | |||
| 129850 | 244513 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 500 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004128.882 | 2109777.8057 | 37.7732812611379 | -122.429145501014 | (37.7732812611379, -122.429145501014) | 7 | 9 | 11 | 29492 | 10 | |||
| 134071 | 227103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998021.55452 | 2105968.74453 | 37.7624749295086 | -122.449996897152 | (37.7624749295086, -122.449996897152) | 15 | 5 | 11 | 29492 | 9 | |||
| 139732 | 88255 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 115 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51240 | 5998220 | 2108137 | 37.7684397634087 | -122.44946678759 | (37.7684397634087, -122.44946678759) | 15 | 5 | 11 | 29492 | 9 | |||
| 142495 | 88724 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1009 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742 | 2109408 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | 15 | 5 | 11 | 29492 | 9 | ||
| 145798 | 140302 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 143 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997780.8586 | 2110053.3207 | 37.773676357183 | -122.451123943319 | (37.773676357183, -122.451123943319) | 15 | 5 | 11 | 29492 | 16 | |||
| 146189 | 227583 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002133.89525 | 2108814.30402 | 37.7705225892763 | -122.435977464701 | (37.7705225892763, -122.435977464701) | 15 | 5 | 11 | 29492 | 9 | |||
| 149331 | 227142 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997609.1285 | 2105909.8393 | 37.7622895828302 | -122.451419071551 | (37.7622895828302, -122.451419071551) | 15 | 5 | 11 | 29492 | 9 | |||
| 155024 | 83961 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 180 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50859 | 5997460.19616594 | 2106774.33360384 | 37.7646547355545 | -122.451996543237 | (37.7646547355545, -122.451996543237) | 15 | 5 | 11 | 29492 | 9 | ||
| 159564 | 247309 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 220 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002790.9139 | 2109368.8454 | 37.7720825259473 | -122.433744475031 | (37.7720825259473, -122.433744475031) | 15 | 5 | 11 | 29492 | 9 | |||
| 162838 | 227575 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001460.70601 | 2108045.90078 | 37.7683744785129 | -122.43825097062 | (37.7683744785129, -122.43825097062) | 15 | 5 | 5 | 29492 | 3 | |||
| 163537 | 227137 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 180 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997464.66679 | 2106771.33887 | 37.7646467688489 | -122.451980864539 | (37.7646467688489, -122.451980864539) | 15 | 5 | 11 | 29492 | 9 | |||
| 163976 | 140699 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 224 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998816.4363 | 2109919.7991 | 37.7733689769062 | -122.447532121663 | (37.7733689769062, -122.447532121663) | 15 | 5 | 11 | 29492 | 16 | |||
| 175230 | 59241 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | Permit Number 18570 | 5998056.20401336 | 2105984.36092392 | 37.7625197907884 | -122.449878183328 | (37.7625197907884, -122.449878183328) | 15 | 5 | 11 | 29492 | 9 | ||
| 175496 | 64570 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1624 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51014 | 6000044.787 | 2110256.6597 | 37.7743640319269 | -122.443307297711 | (37.7743640319269, -122.443307297711) | 15 | 5 | 11 | 29492 | 16 | |
| 175735 | 247385 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 355 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002203.8017 | 2109776.7723 | 37.7731692596784 | -122.435804531936 | (37.7731692596784, -122.435804531936) | 15 | 5 | 11 | 29492 | 9 | |||
| 175874 | 52129 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 220 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51660 | 6002806.0471416 | 2109304.34219127 | 37.7719062747483 | -122.433687517115 | (37.7719062747483, -122.433687517115) | 15 | 5 | 11 | 29492 | 9 | ||
| 176426 | 227107 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 39 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998391.27095 | 2106242.70654 | 37.7632483086886 | -122.448737922716 | (37.7632483086886, -122.448737922716) | 15 | 5 | 11 | 29492 | 9 | |||
| 180314 | 227143 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997579.79251 | 2105906.80731 | 37.7622795778675 | -122.45152031451 | (37.7622795778675, -122.45152031451) | 15 | 5 | 11 | 29492 | 9 | |||
| 187106 | 227136 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1536 Willard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996925.1738 | 2105904.39227 | 37.7622354382362 | -122.453784207601 | (37.7622354382362, -122.453784207601) | 15 | 5 | 11 | 29492 | 12 | |||
| 192746 | 88723 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001771 | 2109412 | 37.7721430915073 | -122.437275523238 | (37.7721430915073, -122.437275523238) | 15 | 5 | 11 | 29492 | 9 | ||
| 193498 | 47037 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | Permit Number 776491 | 6002280.60768666 | 2108833.96933031 | 37.7705849188534 | -122.435471392977 | (37.7705849188534, -122.435471392977) | 15 | 5 | 11 | 29492 | 9 |
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) );