trees
1,121 rows where qSpecies_id = 6 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176365 | 68842 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.393375500204 | (37.7588942535933, -122.393375500204) | 10 | 3 | 8 | 28856 | 29 |
| 175919 | 201807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 273 Friedell St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6020893.11722 | 2092989.08595 | 37.7281175177998 | -122.369994383343 | (37.7281175177998, -122.369994383343) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 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 | |||
| 175521 | 41812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | 15 | 5 | 1 | 29490 | 16 | |
| 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 | |
| 175408 | 95911 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1845 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767612 | 5989071.1412 | 2105102.6181 | 37.7595805696676 | -122.480889318141 | (37.7595805696676, -122.480889318141) | 1 | 8 | 3 | 56 | 35 |
| 175351 | 27251 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X3 | 6005015.49022 | 2093543.05731 | 37.7287545552706 | -122.424923334442 | (37.7287545552706, -122.424923334442) | 9 | 7 | 6 | 28861 | 5 | |||
| 175350 | 191223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1112 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012178.19052 | 2103217.19746 | 37.7557196692435 | -122.400840661869 | (37.7557196692435, -122.400840661869) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 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 | ||
| 174893 | 191225 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011119.4005 | 2104649.28038 | 37.7595927363317 | -122.404603122242 | (37.7595927363317, -122.404603122242) | 10 | 3 | 8 | 28856 | 29 | ||||
| 174884 | 191222 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1143 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013778.51486 | 2106149.81223 | 37.7638611238173 | -122.39551163825 | (37.7638611238173, -122.39551163825) | 14 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 174553 | 115183 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3610 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2016 12:00:00 AM | Permit Number 774488 | 5982230.3 | 2100857.8 | 37.7475254834273 | -122.50423350924 | (37.7475254834273, -122.50423350924) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |
| 174485 | 201834 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020718.56969 | 2092826.63123 | 37.7276618681873 | -122.37058658062 | (37.7276618681873, -122.37058658062) | 10 | 3 | 8 | 58 | 1 | |
| 173911 | 207046 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997758.19926 | 2095006.4821 | 37.7323601729864 | -122.450117573561 | (37.7323601729864, -122.450117573561) | 9 | 7 | 4 | 59 | 40 | |||
| 173908 | 251743 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 143 Cordova St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001773 | 2087479 | 37.7119203272299 | -122.43569914015 | (37.7119203272299, -122.43569914015) | 9 | 7 | 6 | 28861 | 5 | |||||
| 173829 | 227084 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1217 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010060.56336 | 2102014.94468 | 37.7523002058063 | -122.408079341009 | (37.7523002058063, -122.408079341009) | 2 | 4 | 7 | 28859 | 19 | |||
| 173524 | 253112 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 172804 | 31938 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1335 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50210 | 5981495.7067 | 2105969.8095 | 37.761518381611 | -122.507152818801 | (37.761518381611, -122.507152818801) | 1 | 8 | 3 | 56 | 35 | |
| 172760 | 253118 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 01:35:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 172497 | 227124 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002026.8924 | 2100876.99711 | 37.7487225875918 | -122.435779604843 | (37.7487225875918, -122.435779604843) | 2 | 4 | 5 | 28862 | 22 | |||
| 172462 | 206985 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1498 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990877.17813 | 2105275.09317 | 37.7601589539866 | -122.474655794123 | (37.7601589539866, -122.474655794123) | 1 | 8 | 4 | 56 | 12 | |||
| 172352 | 227550 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003307.61262 | 2104748.70742 | 37.7594260532954 | -122.431627264983 | (37.7594260532954, -122.431627264983) | 2 | 4 | 5 | 28862 | 3 | |||
| 172292 | 176884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.403646486396 | (37.7145850034576, -122.403646486396) | 9 | 7 | 8 | 309 | 39 | ||||
| 172275 | 227111 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.7450521251663 | -122.414033173096 | (37.7450521251663, -122.414033173096) | 2 | 7 | 7 | 28859 | 2 | |||
| 172005 | 227579 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 77 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004499.29505 | 2107353.29779 | 37.7666451110058 | -122.427691415339 | (37.7666451110058, -122.427691415339) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | ||
| 171990 | 90740 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4451X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981760.6962 | 2110270.81896 | 37.7733433125278 | -122.506555332031 | (37.7733433125278, -122.506555332031) | 11 | 6 | 2 | 55 | 26 | ||
| 171958 | 159348 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:44:00 AM | 3 | Width 0ft | 5998312.68186 | 2087372.36678 | 37.7114303786888 | -122.447651252104 | (37.7114303786888, -122.447651252104) | 9 | 7 | 6 | 28861 | 25 | ||
| 171605 | 83555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003936.82497 | 2093347.62291 | 37.7281569485605 | -122.428638423918 | (37.7281569485605, -122.428638423918) | 9 | 7 | 6 | 28861 | 5 |
| 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 | ||
| 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 | ||
| 170818 | 120009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5986962.57059 | 2110820.51914 | 37.775157546008 | -122.488601975561 | (37.775157546008, -122.488601975561) | 11 | 6 | 2 | 55 | 26 | |||
| 170704 | 255422 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
| 170413 | 191224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011129.67031 | 2104650.44992 | 37.7595965215873 | -122.404567686256 | (37.7595965215873, -122.404567686256) | 10 | 3 | 8 | 28856 | 29 | ||||
| 170364 | 88187 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 43 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51193 | 6008740.44285 | 2109989.37217 | 37.7741221473478 | -122.413208392271 | (37.7741221473478, -122.413208392271) | 8 | 2 | 9 | 28853 | 34 | |
| 169948 | 176911 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1390 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009574.07755 | 2094366.6897 | 37.7312725131133 | -122.409222034865 | (37.7312725131133, -122.409222034865) | 10 | 3 | 7 | 309 | 28 | |||
| 169832 | 65853 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3415 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51130 | 6000770.44597 | 2120073.90569 | 37.8013609996628 | -122.441501736515 | (37.8013609996628, -122.441501736515) | 13 | 9 | 1 | 57 | 17 | |
| 169785 | 201830 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020827.60649 | 2092975.44043 | 37.7280764547545 | -122.370219916224 | (37.7280764547545, -122.370219916224) | 10 | 3 | 8 | 58 | 1 | |
| 169734 | 201826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020898.42083 | 2093071.04954 | 37.7283428654122 | -122.369981710984 | (37.7283428654122, -122.369981710984) | 10 | 3 | 8 | 58 | 1 | |
| 169615 | 109265 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1970 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773567 | 5983260 | 2101732.7 | 37.7499882212347 | -122.500737615767 | (37.7499882212347, -122.500737615767) | 1 | 8 | 3 | 29491 | 35 |
| 169433 | 115802 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1218 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774518 | 5981226.5 | 2106751.9 | 37.7636499175412 | -122.50814192749 | (37.7636499175412, -122.50814192749) | 1 | 8 | 3 | 56 | 35 | |
| 169305 | 176877 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.7099103976217 | -122.396487432357 | (37.7099103976217, -122.396487432357) | 10 | 3 | 8 | 309 | 1 | |||
| 169302 | 118589 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982275.32502 | 2112634.79146 | 37.779864376411 | -122.50495040284 | (37.779864376411, -122.50495040284) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | ||
| 169137 | 98848 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | ||
| 169035 | 47267 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1386 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45208 | 5988680.1995 | 2105896.4201 | 37.7617374028544 | -122.48229953296 | (37.7617374028544, -122.48229953296) | 1 | 8 | 3 | 56 | 35 | |
| 168920 | 201823 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 7 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021023.85438 | 2093233.10906 | 37.7287947324852 | -122.369559269737 | (37.7287947324852, -122.369559269737) | 10 | 3 | 8 | 58 | 1 | ||
| 168808 | 227549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3663 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003979.9607 | 2103616.2837 | 37.7563547731686 | -122.429221207098 | (37.7563547731686, -122.429221207098) | 2 | 4 | 5 | 28862 | 22 | |||
| 168688 | 227572 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 841 Church St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004362.06253 | 2104151.54801 | 37.7578461063327 | -122.427937906015 | (37.7578461063327, -122.427937906015) | 2 | 4 | 5 | 28862 | 3 | |||
| 168229 | 90283 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4508 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981566.01243 | 2111001.75609 | 37.7753387866897 | -122.507282997083 | (37.7753387866897, -122.507282997083) | 11 | 6 | 2 | 55 | 26 | ||
| 168187 | 836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1396X 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:52:00 AM | 3 | 3X3 | 5981241.3128 | 2105622.3145 | 37.7605492737866 | -122.508006856179 | (37.7605492737866, -122.508006856179) | 1 | 8 | 3 | 56 | 35 | ||
| 168066 | 181011 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 207 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:21:00 AM | 3 | Width 4ft | 6001121.31583 | 2088326.00254 | 37.7142089699327 | -122.438012171843 | (37.7142089699327, -122.438012171843) | 9 | 7 | 6 | 28861 | 5 | ||
| 168020 | 118692 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4549 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5981428.28301 | 2110941.30275 | 37.7751646862289 | -122.507754939589 | (37.7751646862289, -122.507754939589) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |
| 167819 | 176886 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 119 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002169.33644 | 2093633.71931 | 37.7288423165165 | -122.434769138285 | (37.7288423165165, -122.434769138285) | 9 | 7 | 6 | 28861 | 25 | |||
| 167767 | 88087 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1254 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51087 | 5984334.6 | 2106629.9 | 37.7634975987144 | -122.497383137852 | (37.7634975987144, -122.497383137852) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |
| 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 |
| 167096 | 98557 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/07/2012 12:00:00 AM | 3 | 5982438 | 2105598 | 37.7605529521075 | -122.503866330302 | (37.7605529521075, -122.503866330302) | 1 | 8 | 3 | 56 | 35 | |||
| 166863 | 140780 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.443550757384 | (37.7796937331341, -122.443550757384) | 15 | 5 | 1 | 29490 | 16 | |||
| 166705 | 92392 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2506 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52796 | 5986151.5297 | 2098152.0694 | 37.7403261082431 | -122.490475302823 | (37.7403261082431, -122.490475302823) | 1 | 8 | 3 | 29491 | 35 |
| 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 | |
| 166220 | 90719 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4616 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981255.79709 | 2110310.22456 | 37.7734217675099 | -122.508304742671 | (37.7734217675099, -122.508304742671) | 11 | 6 | 2 | 55 | 26 | ||
| 166093 | 88438 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1248 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52242 | 6009421 | 2117567 | 37.7949666840821 | -122.411389656386 | (37.7949666840821, -122.411389656386) | 3 | 1 | 10 | 28857 | 4 | |||
| 165946 | 207007 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 127 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993382.10868 | 2093854.31743 | 37.7289452232334 | -122.465162955333 | (37.7289452232334, -122.465162955333) | 9 | 8 | 4 | 59 | 40 | |||
| 165833 | 27035 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1300X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009326.50967 | 2094276.52484 | 37.7310110667009 | -122.410071562372 | (37.7310110667009, -122.410071562372) | 9 | 3 | 7 | 309 | 28 | ||
| 165323 | 160071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:31:00 AM | 3 | Width 0ft | 6000209.4859 | 2090450.10808 | 37.7199893866688 | -122.44131611827 | (37.7199893866688, -122.44131611827) | 9 | 7 | 6 | 28861 | 25 | ||
| 165167 | 95901 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767603 | 5989092 | 2103686.6 | 37.7556937768723 | -122.480713514054 | (37.7556937768723, -122.480713514054) | 1 | 8 | 3 | 56 | 35 | |
| 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 | |||
| 164870 | 87861 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 96 Caselli Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000485.4 | 2104954.1 | 37.7598296396585 | -122.441402573572 | (37.7598296396585, -122.441402573572) | 2 | 4 | 5 | 28862 | 3 | ||
| 164479 | 88270 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 288 States St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51256 | 6000346 | 2106829 | 37.7649697094425 | -122.442019266807 | (37.7649697094425, -122.442019266807) | 15 | 5 | 5 | 28862 | 3 | ||
| 164477 | 227094 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6009153.63089 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | 10 | 7 | 7 | 28859 | 2 | ||||
| 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 | |||
| 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 | ||
| 163710 | 108371 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.7196058887813 | -122.43642558878 | (37.7196058887813, -122.43642558878) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 163253 | 191231 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1251 Newhall St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014752.47592 | 2096139.27661 | 37.7364284325307 | -122.391443100815 | (37.7364284325307, -122.391443100815) | 10 | 3 | 8 | 58 | 1 | |||
| 163097 | 129372 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999985.51807 | 2120890.75849 | 37.8035591091338 | -122.444276660352 | (37.8035591091338, -122.444276660352) | 13 | 9 | 1 | 57 | 17 | |||
| 162961 | 69182 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1371 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50160 | 5982122.5039 | 2105769.199 | 37.7610044592096 | -122.504970155565 | (37.7610044592096, -122.504970155565) | 1 | 8 | 3 | 56 | 35 | |
| 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 | |||
| 162715 | 227569 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002739.75043 | 2104260.6213 | 37.7580536824469 | -122.433556327872 | (37.7580536824469, -122.433556327872) | 2 | 4 | 5 | 28862 | 3 | |||
| 162564 | 118108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3585 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 5984519.42575 | 2111051.46948 | 37.7756488017479 | -122.497070281467 | (37.7756488017479, -122.497070281467) | 11 | 6 | 2 | 55 | 26 | ||
| 162447 | 88066 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2055 Silver Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012463.39117 | 2096075.79817 | 37.736126817888 | -122.399353026719 | (37.736126817888, -122.399353026719) | 10 | 3 | 8 | 58 | 1 | |
| 162239 | 94098 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 7 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2010 12:00:00 AM | 4 | Permit Number 53474 | 6007925.01702 | 2094192.51392 | 37.7307017385741 | -122.414910830466 | (37.7307017385741, -122.414910830466) | 9 | 3 | 7 | 309 | 28 | ||
| 162045 | 24747 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1999 12:00:00 AM | 3 | 3X3 | 5982215.35166 | 2112638.47493 | 37.7798709615679 | -122.505158146759 | (37.7798709615679, -122.505158146759) | 11 | 6 | 2 | 55 | 26 | ||
| 162043 | 227159 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 156 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005558.07312 | 2099948.5227 | 37.7463731599945 | -122.423502792335 | (37.7463731599945, -122.423502792335) | 2 | 7 | 5 | 28859 | 22 | |||
| 161792 | 216723 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:05:00 AM | 3 | Width 2ft | 5995305.86266 | 2090248.98741 | 37.7191565973781 | -122.458251599737 | (37.7191565973781, -122.458251599737) | 9 | 8 | 6 | 28861 | 24 | ||
| 161683 | 207045 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 607 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998977.59415 | 2096753.43976 | 37.7372266087217 | -122.446027465895 | (37.7372266087217, -122.446027465895) | 9 | 7 | 4 | 59 | 40 | |||
| 161401 | 37831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.35388 | 37.7200688687581 | -122.428658848427 | (37.7200688687581, -122.428658848427) | 9 | 7 | 6 | 28861 | 5 |
| 161397 | 24739 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2004 12:00:00 AM | 3 | 3X3 | 5982782.27657 | 2112574.64249 | 37.7797290371816 | -122.503192207591 | (37.7797290371816, -122.503192207591) | 11 | 6 | 2 | 55 | 26 | ||
| 161367 | 182659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2252 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986985.3742 | 2102363.8158 | 37.7519391046129 | -122.487901613135 | (37.7519391046129, -122.487901613135) | 1 | 8 | 3 | 56 | 35 | |||
| 161307 | 176916 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 380 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001888.93185 | 2087835.89796 | 37.7129068748214 | -122.435323960636 | (37.7129068748214, -122.435323960636) | 9 | 7 | 6 | 28861 | 5 | |||
| 161062 | 203010 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 351 Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:48:00 AM | 3 | Width 3ft | 6017339.6558 | 2098641.75454 | 37.743442989794 | -122.382672122634 | (37.743442989794, -122.382672122634) | 10 | 3 | 8 | 58 | 1 | ||
| 160845 | 227580 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 23 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003811.04552 | 2108200.21185 | 37.7689315761679 | -122.430132375016 | (37.7689315761679, -122.430132375016) | 7 | 9 | 5 | 28862 | 3 | |||
| 160467 | 27283 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 630 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/2008 12:00:00 AM | 6 | 3X3 | 6005560.76907 | 2093525.90712 | 37.7287382496569 | -122.423037049614 | (37.7287382496569, -122.423037049614) | 9 | 7 | 7 | 309 | 5 | ||
| 160238 | 256575 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 |
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) );