1,121 rows where qSpecies_id = 6 sorted by rowid descending

View and edit SQL

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
194177 181017 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.438369065102 (37.7143700996689, -122.438369065102) 9 7 6 28861 5
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
193987 201809 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 237 Friedell St 1 : Tree Private 2     1 Width 6ft   6020945.51773 2093059.30039 37.7283131886973 -122.369818081152 (37.7283131886973, -122.369818081152) 10 3 8 58 1
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
193397 191237 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1600 Newhall St 6 : Tree Private 2     3 Width 2ft   6014127.4828 2095367.51286 37.7342746191851 -122.39354998485 (37.7342746191851, -122.39354998485) 10 3 8 58 1
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
192989 181010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 215 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.90059 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327) 9 7 6 28861 5
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
192824 227120 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6001486.23397 2099669.55813 37.7453765205103 -122.43756273743 (37.7453765205103, -122.43756273743) 2 7 5 63 22
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
192453 191245 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1675 Jerrold Ave 1 : Tree Private 2     12 Width 3ft   6014937.21218 2097262.06336 37.7395216264201 -122.3908828304 (37.7395216264201, -122.3908828304) 10 3 8 58 1
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
189866 37825 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 13 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003912.01731 2090448.66207 37.7201956398999 -122.428517635078 (37.7201956398999, -122.428517635078) 9 7 6 28861 5
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
189084 247053 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 507 Valley St 1 : Tree Private 2     3 Width 2ft   6002585.44242 2099146.18361 37.744001891474 -122.433724457916 (37.744001891474, -122.433724457916) 2 7 5 63 22
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
187202 183640 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1484 47th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5981572.1323 2104991.2828 37.7588361283195 -122.506815916291 (37.7588361283195, -122.506815916291) 1 8 3 56 35
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
186958 120000 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 818 30th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   5986676.70436 2110336.54693 37.7738120096448 -122.489555240793 (37.7738120096448, -122.489555240793) 11 6 2 55 26
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
185841 191236 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1600 Newhall St 4 : Tree Private 2     3 Width 2ft   6014135.07988 2095376.98841 37.7343010592291 -122.39352438204 (37.7343010592291, -122.39352438204) 10 3 8 58 1
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
185300 207030 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 835 Sargent St 2 : Tree Private 2     7 Width 3ft   5991738.49074 2089190.01168 37.7160432712657 -122.470505441771 (37.7160432712657, -122.470505441771) 9 8 6 64 24
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
184601 119241 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 50 Sutro Heights Ave 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5981435.03386 2111334.77238 37.776245435782 -122.5077607921 (37.776245435782, -122.5077607921) 11 6 2 55 26
184554 201822 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 6 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.02992 37.7288418326792 -122.369520189723 (37.7288418326792, -122.369520189723) 10 3 8 58 1
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
183672 250554 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 El Camino Del Mar 2 : Tree Private 2     5 Width 4ft   5988163.80572 2115366.95271 37.7877107901693 -122.484780278081 (37.7877107901693, -122.484780278081) 11 6 1 55 33
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
181974 227119 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022) 2 7 5 63 22
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
181063 182513 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1573 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   03/23/2018 12:00:00 AM 3 Width 0ft Permit Number 777985 5985578.9968 2104511.5721 37.7577541150318 -122.492923184352 (37.7577541150318, -122.492923184352) 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
177530 176905 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 68 Cambridge St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   6006453.00873 2094472.53688 37.7313877962987 -122.420019664972 (37.7313877962987, -122.420019664972) 9 7 7 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
176832 207039 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 270 Magellan Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994635.03268 2100302.9111 37.7467236374953 -122.461298810415 (37.7467236374953, -122.461298810415) 1 8 4 29491 40
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);