trees
968 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
194422 | 37823 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:49:00 AM | 3 | 3x3 | Permit Number 40134 | 6003922.69393 | 2090463.29382 | 37.7202364196636 | -122.428481771941 | (37.7202364196636, -122.428481771941) | 9 | 7 | 6 | 28861 | 5 |
194398 | 162836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/2020 12:00:00 AM | 0 | 4x6 | 5996489.45825 | 2090475.5577 | 37.7198466480955 | -122.454176740991 | (37.7198466480955, -122.454176740991) | 9 | 8 | 6 | 28861 | 24 | |
194395 | 183689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1351 42nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
194372 | 37826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003896.37457 | 2090444.78719 | 37.7201841150858 | -122.428571430748 | (37.7201841150858, -122.428571430748) | 9 | 7 | 6 | 28861 | 5 |
194199 | 118595 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | 11 | 6 | 2 | 55 | 26 | |||
194195 | 52070 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.51311 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | 3 | 1 | 10 | 28857 | 4 | ||
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 | |||
193752 | 184292 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1543 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 3x3 | 5983695 | 2104642 | 37.7580018774889 | -122.499448359455 | (37.7580018774889, -122.499448359455) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||
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 | ||
193269 | 95900 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 4 | 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 | |
193198 | 111714 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
193090 | 184126 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1643 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986219.0266 | 2104040.7857 | 37.7564988729574 | -122.490675089245 | (37.7564988729574, -122.490675089245) | 1 | 8 | 3 | 56 | 35 | |||
192907 | 255098 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 585 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 5987788 | 2112008 | 37.7784661663567 | -122.485833843864 | (37.7784661663567, -122.485833843864) | 11 | 6 | 2 | 55 | 26 | ||||
192805 | 115237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.7723677654738 | -122.502584200594 | (37.7723677654738, -122.502584200594) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
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 | |
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 | |
192015 | 108829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.74701 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | 10 | 3 | 8 | 309 | 1 | ||
191983 | 27161 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011020.5092245 | 2095004.7366116 | 37.7331053850338 | -122.40426632243 | (37.7331053850338, -122.40426632243) | 10 | 3 | 8 | 58 | 1 | ||
191846 | 182083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 12:33:00 PM | 3 | Width 0ft | 5989775.2775 | 2098997.3719 | 37.7428580801695 | -122.478007744126 | (37.7428580801695, -122.478007744126) | 1 | 8 | 3 | 29491 | 35 | ||
191490 | 60927 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1506 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1983 12:00:00 AM | 5 | Permit Number 20728 | 6010428.9415 | 2094674.96946 | 37.7321668403311 | -122.406288313254 | (37.7321668403311, -122.406288313254) | 10 | 3 | 7 | 309 | 28 | ||
190595 | 88188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 43-25 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51193 | 6008699.51281 | 2110034.52168 | 37.7742438193359 | -122.413353170509 | (37.7742438193359, -122.413353170509) | 8 | 2 | 9 | 28853 | 34 | |
190265 | 227118 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005870.45988 | 2099040.93392 | 37.7438987545141 | -122.422358119057 | (37.7438987545141, -122.422358119057) | 2 | 7 | 7 | 28859 | 2 | |||
190083 | 216655 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 161 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 02:49:00 PM | 3 | Width 3ft | 5995318.74701 | 2090961.58454 | 37.7211139601174 | -122.45825861266 | (37.7211139601174, -122.45825861266) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |
189609 | 227083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 770 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6008514.34527 | 2104071.33726 | 37.7578598992273 | -122.41357185686 | (37.7578598992273, -122.41357185686) | 2 | 4 | 7 | 28859 | 19 | |||
189393 | 162332 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 36 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:06:00 PM | 3 | Width 0ft | 5996526.7373 | 2090117.21242 | 37.7188648537082 | -122.45402201441 | (37.7188648537082, -122.45402201441) | 9 | 8 | 6 | 28861 | 24 | ||
189147 | 191218 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 477 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011234.32907 | 2106146.16371 | 37.7637092651804 | -122.404310998169 | (37.7637092651804, -122.404310998169) | 8 | 3 | 8 | 28856 | 29 | |||
188853 | 90742 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4435 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981815.15401 | 2110273.6149 | 37.7733541956697 | -122.506367165545 | (37.7733541956697, -122.506367165545) | 11 | 6 | 2 | 55 | 26 | ||
188729 | 227153 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008266.03922 | 2099383.96222 | 37.7449754768472 | -122.414098996293 | (37.7449754768472, -122.414098996293) | 2 | 7 | 7 | 28859 | 2 | |||
188623 | 90746 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982095.14058 | 2110285.66939 | 37.7734037737787 | -122.505399563205 | (37.7734037737787, -122.505399563205) | 11 | 6 | 2 | 55 | 26 | ||
188586 | 69101 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1672 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773502 | 5992502.12347703 | 2104077.04435662 | 37.7569634473758 | -122.468948742276 | (37.7569634473758, -122.468948742276) | 1 | 8 | 4 | 56 | 12 |
188309 | 50524 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2003 12:00:00 AM | Permit Number 47164 | 6005968.07304834 | 2104305.31315666 | 37.758359035924 | -122.422394568264 | (37.758359035924, -122.422394568264) | 2 | 4 | 5 | 28859 | 19 | ||
188002 | 88645 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2500x Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51618 | 6006882.7 | 2119972.1 | 37.8014277902223 | -122.420343352043 | (37.8014277902223, -122.420343352043) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |
187598 | 112025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
187299 | 27010 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1462 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010153.37045 | 2094576.28824 | 37.7318804638018 | -122.407234074496 | (37.7318804638018, -122.407234074496) | 10 | 3 | 7 | 309 | 28 | ||
187150 | 227568 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002743.27179 | 2104198.28781 | 37.7578827294299 | -122.433539694925 | (37.7578827294299, -122.433539694925) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
187092 | 227571 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002573.48599 | 2103832.36646 | 37.7568683624992 | -122.434100727063 | (37.7568683624992, -122.434100727063) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
186887 | 119083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | 11 | 6 | 2 | 55 | 26 | |||
186495 | 57147 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 578 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2012 12:00:00 AM | 6 | 4x4 | Permit Number 14422 | 6001353.29798 | 2090440.69811 | 37.7200286411902 | -122.4373616868 | (37.7200286411902, -122.4373616868) | 9 | 7 | 6 | 28861 | 5 |
186425 | 109577 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002290.3134 | 2092582.02308 | 37.72596146424 | -122.434275755847 | (37.72596146424, -122.434275755847) | 9 | 7 | 6 | 28861 | 25 |
185824 | 95108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 445 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54037 | 6002085.32525 | 2093826.71651 | 37.7293674729177 | -122.435073368138 | (37.7293674729177, -122.435073368138) | 9 | 7 | 6 | 28861 | 25 |
185808 | 183691 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.4226 | 2105931.5142 | 37.7615044445987 | -122.501786784798 | (37.7615044445987, -122.501786784798) | 1 | 8 | 3 | 56 | 35 | ||
185726 | 200836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013076.6871 | 2107039.6693 | 37.7662654119853 | -122.398001493496 | (37.7662654119853, -122.398001493496) | 14 | 3 | 8 | 28856 | 20 | |||
185386 | 83364 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 319 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52323 | 6002520.66221 | 2091711.14442 | 37.7235832988126 | -122.433417250421 | (37.7235832988126, -122.433417250421) | 9 | 7 | 6 | 28861 | 5 | |
185303 | 3513 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:31:00 AM | 3 | 3X3 | 6018063.30501 | 2098072.02964 | 37.7419185912736 | -122.380130317487 | (37.7419185912736, -122.380130317487) | 10 | 3 | 8 | 58 | 1 | ||
184989 | 207009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 451 Hearst Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998610.96321 | 2094365.8508 | 37.7306499124634 | -122.447123295197 | (37.7306499124634, -122.447123295197) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||
184192 | 113139 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
183981 | 256606 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
183432 | 227156 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3458 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007201.92693 | 2104423.13266 | 37.7587520662717 | -122.418135699498 | (37.7587520662717, -122.418135699498) | 2 | 4 | 7 | 28859 | 19 | |||
183256 | 88394 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 139 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.7867985724398 | -122.485322676521 | (37.7867985724398, -122.485322676521) | 11 | 6 | 1 | 55 | 33 | ||
182173 | 253114 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:55:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
182139 | 183687 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 33196 | 5983043.3769 | 2106010.2341 | 37.7617204082059 | -122.501803142928 | (37.7617204082059, -122.501803142928) | 1 | 8 | 3 | 56 | 35 | |
181931 | 102200 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769774 | 6002583.2 | 2103808 | 37.7568020093443 | -122.434065390673 | (37.7568020093443, -122.434065390673) | 2 | 4 | 5 | 28862 | 3 |
181692 | 182658 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2242 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987004.6631 | 2102364.6195 | 37.7519424365087 | -122.487834969288 | (37.7519424365087, -122.487834969288) | 1 | 8 | 3 | 56 | 35 | |||
180998 | 227573 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000184.94355 | 2105205.65777 | 37.7605032342671 | -122.442459762729 | (37.7605032342671, -122.442459762729) | 15 | 4 | 5 | 28862 | 3 | |||
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 | |||
179565 | 129387 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006679.63776 | 2119843.90732 | 37.8010643609816 | -122.421036932226 | (37.8010643609816, -122.421036932226) | 5 | 9 | 1 | 28858 | 32 | |||
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 | |
179045 | 19350 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 618 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781612 | 5992350.09465 | 2089866.75515 | 37.7179367902328 | -122.468440675709 | (37.7179367902328, -122.468440675709) | 9 | 8 | 6 | 64 | 24 | |
178982 | 95429 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1437 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767294 | 5988962.2823 | 2105532.8441 | 37.760755525792 | -122.481297307618 | (37.760755525792, -122.481297307618) | 1 | 8 | 3 | 56 | 35 |
178838 | 88733 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51668 | 6004334 | 2108794 | 37.7705915794801 | -122.428365836994 | (37.7705915794801, -122.428365836994) | 7 | 9 | 11 | 28852 | 10 | ||
178481 | 117431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776696 | 6004211.11578 | 2091567.32576 | 37.7232841663055 | -122.427563407639 | (37.7232841663055, -122.427563407639) | 9 | 7 | 6 | 28861 | 5 | ||
178384 | 120804 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 689 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989715.19561 | 2110680.27165 | 37.774932704327 | -122.479069875733 | (37.774932704327, -122.479069875733) | 11 | 6 | 2 | 55 | 26 | |||
178343 | 46893 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1383 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44948 | 5992692.47897134 | 2106059.86172468 | 37.7624187406256 | -122.468434681685 | (37.7624187406256, -122.468434681685) | 1 | 8 | 11 | 56 | 12 | ||
178337 | 227110 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008268.06848 | 2099378.06711 | 37.7449594041621 | -122.41409156248 | (37.7449594041621, -122.41409156248) | 2 | 7 | 7 | 28859 | 2 | |||
178195 | 227115 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007890.87999 | 2104550.47449 | 37.7591404717772 | -122.415761992927 | (37.7591404717772, -122.415761992927) | 2 | 4 | 7 | 28859 | 19 | |||
177940 | 50032 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 33 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 5 | Permit Number 46764 | 6007353.74197 | 2093754.84576 | 37.7294678795239 | -122.416854825683 | (37.7294678795239, -122.416854825683) | 9 | 3 | 7 | 309 | 28 | |
177874 | 42963 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 560 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42852 | 5981647.94996 | 2111905.75128 | 37.7778257173711 | -122.507066636025 | (37.7778257173711, -122.507066636025) | 11 | 6 | 2 | 55 | 26 | ||
177745 | 78252 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 541 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776648 | 6003018.57122 | 2090471.02112 | 37.7202064317688 | -122.431607573443 | (37.7202064317688, -122.431607573443) | 9 | 7 | 6 | 28861 | 5 | |
177211 | 102935 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 801X Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.7577742117678 | -122.427824502367 | (37.7577742117678, -122.427824502367) | 2 | 4 | 5 | 28862 | 3 | |||
177072 | 81730 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2346 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774950 | 5982707.54204511 | 2099147.52139682 | 37.7428575871403 | -122.502456702486 | (37.7428575871403, -122.502456702486) | 1 | 8 | 3 | 29491 | 35 | |
176834 | 37820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003945.80086 | 2090498.97809 | 37.7203357084188 | -122.428404441018 | (37.7203357084188, -122.428404441018) | 9 | 7 | 6 | 28861 | 5 |
176687 | 63095 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1314 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 1 | Permit Number 775034 | 5982157.61974918 | 2106142.20642168 | 37.7620306969809 | -122.504876348182 | (37.7620306969809, -122.504876348182) | 1 | 8 | 3 | 56 | 35 | ||
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 | |||
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 |
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 | ||
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 |
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) );