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