trees
183 rows where qLegalStatus_id = 7 and qSpecies_id = 6 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15370 | 50774 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47304 | |||||||||||||||
| 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 | ||||||||||
| 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 | |
| 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 | |
| 108222 | 108764 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 3 | 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 | |
| 117917 | 108778 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 17 | 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 | |
| 134524 | 108772 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 11 | 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 | |
| 174505 | 108825 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | |
| 76984 | 176882 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781358 | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | 9 | 7 | 8 | 309 | 39 |
| 72790 | 40470 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 43 Lakeview Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
| 132281 | 254353 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2 Ankeny St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011131.69741 | 2089639.6721 | 37.7183802415409 | -122.403504586485 | (37.7183802415409, -122.403504586485) | 10 | 7 | 8 | 309 | 28 | |
| 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 |
| 174741 | 38921 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.7181598049858 | -122.460857119734 | (37.7181598049858, -122.460857119734) | 9 | 8 | 6 | 28861 | 24 | ||
| 194470 | 254768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 415 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781626 | 5993212 | 2089957 | 37.7182343284954 | -122.4654680237 | (37.7182343284954, -122.4654680237) | 9 | 8 | 6 | 64 | 24 |
| 101905 | 43742 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 107401 | 43741 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 139435 | 43740 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 144972 | 43739 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 91359 | 103118 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 443 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2013 12:00:00 AM | Permit Number 769638 | 5992399.1 | 2090786.9 | 37.72046611452 | -122.468338191478 | (37.72046611452, -122.468338191478) | 9 | 8 | 6 | 64 | 24 | |||
| 134136 | 84680 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49721 | 5996259.49937321 | 2091420.61840977 | 37.722428372357 | -122.45503987717 | (37.722428372357, -122.45503987717) | 9 | 8 | 4 | 28861 | 24 | ||
| 89273 | 38913 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 154355 | 38914 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 84749 | 95721 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 6 | 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 | |
| 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 | |
| 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 |
| 148517 | 109183 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 1 | 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 |
| 50859 | 114691 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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 | |||
| 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 | ||
| 194121 | 52944 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 20 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2006 12:00:00 AM | Permit Number 48931 | 6000207.27773758 | 2093260.71462594 | 37.727706542786 | -122.441525334084 | (37.727706542786, -122.441525334084) | 9 | 7 | 6 | 28861 | 25 | |||
| 169270 | 27286 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 682 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6005885.56477 | 2093523.1174 | 37.7287489124796 | -122.421914010506 | (37.7287489124796, -122.421914010506) | 9 | 7 | 7 | 309 | 5 | ||
| 31662 | 27080 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 156893 | 27081 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 114989 | 50035 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46766 | 6007848.45417861 | 2093691.5625558 | 37.7293219318135 | -122.415140074598 | (37.7293219318135, -122.415140074598) | 9 | 3 | 7 | 309 | 28 | ||
| 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 | ||
| 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 | ||
| 167406 | 176915 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 143 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778564 | 6009701.03874 | 2093769.75693 | 37.7296405745301 | -122.408741008189 | (37.7296405745301, -122.408741008189) | 10 | 3 | 7 | 309 | 28 |
| 31876 | 88495 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 27 Reddy St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51437 | 6013659 | 2094063 | 37.7306666521666 | -122.395078350002 | (37.7306666521666, -122.395078350002) | 10 | 3 | 8 | 58 | 1 | |||
| 96120 | 27315 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1330X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009430.10492 | 2094285.00827 | 37.7310401662886 | -122.409714013149 | (37.7310401662886, -122.409714013149) | 9 | 3 | 7 | 309 | 28 | ||
| 163948 | 42105 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51455 | 5999382.77994639 | 2094344.80390055 | 37.730636191214 | -122.444453504412 | (37.730636191214, -122.444453504412) | 9 | 7 | 4 | 28861 | 40 | ||
| 33564 | 27026 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1380X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009629.1666 | 2094382.20254 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | 10 | 3 | 7 | 309 | 28 | ||
| 108067 | 27003 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1380X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6009629.1666 | 2094382.20254 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | 10 | 3 | 7 | 309 | 28 | ||
| 158730 | 27025 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1380X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 12 | 3X3 | 6009629.1666 | 2094382.20254 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | 10 | 3 | 7 | 309 | 28 | ||
| 156212 | 27014 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1518 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 6 | 3X3 | 6010461.99919 | 2094665.45469 | 37.7321425639198 | -122.40617335478 | (37.7321425639198, -122.40617335478) | 10 | 3 | 7 | 309 | 28 | ||
| 164972 | 59404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 770892 | 6003547.68037437 | 2095024.45734525 | 37.7327391275899 | -122.430103282559 | (37.7327391275899, -122.430103282559) | 9 | 7 | 5 | 28861 | 25 | |||
| 109198 | 94671 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
| 189614 | 94670 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
| 79056 | 94672 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53808 | 5997731.1 | 2095032.6 | 37.732430335747 | -122.450213143469 | (37.732430335747, -122.450213143469) | 9 | 7 | 4 | 59 | 40 | |
| 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 | |
| 187907 | 44279 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1588 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767652 | 6014189.45600011 | 2095460.4720274 | 37.7345333093335 | -122.393342225003 | (37.7345333093335, -122.393342225003) | 10 | 3 | 8 | 58 | 1 | |
| 144492 | 116789 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 530 CRESCENT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007719 | 2095661 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | 2 | 7 | 7 | 28859 | 2 | ||||
| 148992 | 94654 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53793 | 6003689 | 2095884 | 37.7351072400417 | -122.429675988088 | (37.7351072400417, -122.429675988088) | 2 | 7 | 5 | 63 | 7 | |
| 111468 | 27168 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2070X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 6 | 2X3 | 6012351.75792 | 2095958.07131 | 37.735797342091 | -122.399730727068 | (37.735797342091, -122.399730727068) | 10 | 3 | 8 | 58 | 1 | ||
| 167882 | 94679 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 218 Roanoke St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53815 | 6003547 | 2096007 | 37.7354369283878 | -122.430175705062 | (37.7354369283878, -122.430175705062) | 2 | 7 | 5 | 63 | 7 | |
| 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 | |
| 120971 | 95999 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 2 | 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 | |
| 192118 | 96065 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 168 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767690 | 6005459.8 | 2096128.8 | 37.7358795176789 | -122.423571087421 | (37.7358795176789, -122.423571087421) | 2 | 7 | 7 | 28859 | 2 | |
| 145329 | 110718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 201x OGDEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 7 | 7 | 28859 | 2 | ||||
| 193291 | 45368 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 201x OGDEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2001 12:00:00 AM | Permit Number 44193 | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 7 | 7 | 28859 | 2 | ||
| 117513 | 88483 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014835.95113 | 2096251.52849 | 37.7367412859786 | -122.391162333372 | (37.7367412859786, -122.391162333372) | 10 | 3 | 8 | 58 | 1 | |
| 137235 | 88480 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51432 | 6014837 | 2096254 | 37.7367481304458 | -122.391158879645 | (37.7367481304458, -122.391158879645) | 10 | 3 | 8 | 58 | 1 | ||
| 122458 | 87640 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | 6012975.96285 | 2096322.27153 | 37.7368321371284 | -122.397598127165 | (37.7368321371284, -122.397598127165) | 10 | 3 | 8 | 58 | 1 | |||
| 171342 | 47598 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 184322 | 47592 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | |
| 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 |
| 94732 | 88465 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 3 | 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 |
| 45123 | 107987 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 233 Laidley St | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | 2 | 7 | 5 | 63 | 7 | |||
| 66000 | 88139 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 523 Teresita Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51168 | 5998937.5 | 2097522.9 | 37.7393370734625 | -122.446221422912 | (37.7393370734625, -122.446221422912) | 9 | 7 | 4 | 59 | 40 | |||
| 117931 | 74157 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 195 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768269 | 6008310.54477322 | 2097714.64471242 | 37.740394399357 | -122.413827044611 | (37.740394399357, -122.413827044611) | 2 | 7 | 7 | 28859 | 2 | ||
| 150135 | 50120 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | Permit Number 769150 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |
| 171991 | 47551 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45415 | 6003395.23441175 | 2098403.20907691 | 37.7420077721371 | -122.430871369414 | (37.7420077721371, -122.430871369414) | 2 | 7 | 5 | 63 | 22 | ||
| 166701 | 254575 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2446 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781489 | 5983035.61421 | 2098477.14413 | 37.7410361869592 | -122.501272763587 | (37.7410361869592, -122.501272763587) | 1 | 8 | 3 | 29491 | 35 | |
| 134165 | 258203 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2422 41st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781120 | 5983650.02463 | 2098655.15546 | 37.741561019666 | -122.499161539913 | (37.741561019666, -122.499161539913) | 1 | 8 | 3 | 29491 | 35 | |
| 171435 | 258215 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2400 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/2019 12:00:00 AM | 3 | Permit Number 783182 | 5983025.27936 | 2098776.48804 | 37.7418574964013 | -122.501330634264 | (37.7418574964013, -122.501330634264) | 1 | 8 | 3 | 29491 | 35 | ||
| 97607 | 43061 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 3050 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 53563 | 5983775.74745702 | 2098849.58098564 | 37.7421022336559 | -122.498741199638 | (37.7421022336559, -122.498741199638) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 141188 | 83302 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2366 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50740 | 5982401.73888916 | 2099005.47811571 | 37.7424496018256 | -122.503503550435 | (37.7424496018256, -122.503503550435) | 1 | 8 | 3 | 29491 | 35 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 104233 | 102092 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 167721 | 102093 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 41225 | 82433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50249 | 6010057.43217179 | 2099484.04645755 | 37.745350741274 | -122.407911712216 | (37.745350741274, -122.407911712216) | 2 | 7 | 7 | 28859 | 2 | ||
| 154918 | 52292 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48451 | 6006201.82590602 | 2099532.89904471 | 37.7452682661505 | -122.421247257698 | (37.7452682661505, -122.421247257698) | 2 | 7 | 5 | 28859 | 2 | ||
| 125722 | 82079 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1648 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50227 | 6009276.07844564 | 2099765.78028808 | 37.7460805446245 | -122.410633408071 | (37.7460805446245, -122.410633408071) | 2 | 7 | 7 | 28859 | 2 | ||
| 179141 | 104731 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 440X Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.54792 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | 1 | 8 | 4 | 29491 | 40 | |
| 192443 | 104730 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 440X Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.54792 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | 1 | 8 | 4 | 29491 | 40 | |
| 134804 | 82755 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50226 | 6009275.52393785 | 2099776.98643755 | 37.746111283151 | -122.410636116717 | (37.746111283151, -122.410636116717) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |
| 86000 | 37052 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 156 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49822 | 6005524.96145532 | 2099948.44891125 | 37.7463710884027 | -122.423617283508 | (37.7463710884027, -122.423617283508) | 2 | 7 | 5 | 28859 | 22 | ||
| 175025 | 115381 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1657X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
| 149039 | 83301 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2194 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
| 110666 | 254576 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2138 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781492 | 5982342.68444 | 2100548.37441 | 37.7466824957237 | -122.50382198427 | (37.7466824957237, -122.50382198427) | 1 | 8 | 3 | 29491 | 35 | |
| 32952 | 37416 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51465 | 6001976.15825924 | 2100785.18555 | 37.7484676127991 | -122.435948474317 | (37.7484676127991, -122.435948474317) | 2 | 4 | 5 | 28862 | 22 | ||
| 9616 | 92857 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 |
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) );