trees
185 rows where Police Districts = 3 and qSpecies_id = 6 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1126 | 262542 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015016 | 2090665 | 37.7214117898675 | -122.390149655616 | (37.7214117898675, -122.390149655616) | 10 | 3 | 8 | 58 | 1 | |||
| 13676 | 262543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015062.6163 | 2090599.75011 | 37.7212352119804 | -122.389983958896 | (37.7212352119804, -122.389983958896) | 10 | 3 | 8 | 58 | 1 | |||
| 16248 | 264659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 971 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014920.44131 | 2089617.70445 | 37.7185308216427 | -122.390406839913 | (37.7185308216427, -122.390406839913) | 10 | 3 | 8 | 58 | 1 | |||
| 23895 | 92663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 29816 | 95998 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054684 | (37.7362914700729, -122.39132054684) | 10 | 3 | 8 | 58 | 1 | |
| 31876 | 88495 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 27 Reddy St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51437 | 6013659 | 2094063 | 37.7306666521666 | -122.395078350002 | (37.7306666521666, -122.395078350002) | 10 | 3 | 8 | 58 | 1 | |||
| 50859 | 114691 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | |||
| 73269 | 92664 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 114989 | 50035 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46766 | 6007848.45417861 | 2093691.5625558 | 37.7293219318135 | -122.415140074598 | (37.7293219318135, -122.415140074598) | 9 | 3 | 7 | 309 | 28 | ||
| 120971 | 95999 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054684 | (37.7362914700729, -122.39132054684) | 10 | 3 | 8 | 58 | 1 | |
| 122415 | 92665 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 122458 | 87640 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | 6012975.96285 | 2096322.27153 | 37.7368321371284 | -122.397598127165 | (37.7368321371284, -122.397598127165) | 10 | 3 | 8 | 58 | 1 | |||
| 137235 | 88480 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51432 | 6014837 | 2096254 | 37.7367481304458 | -122.391158879645 | (37.7367481304458, -122.391158879645) | 10 | 3 | 8 | 58 | 1 | ||
| 138944 | 114692 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | ||
| 148668 | 49802 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 101 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46598 | 6014071 | 2106574 | 37.765042114519 | -122.394529717904 | (37.765042114519, -122.394529717904) | 14 | 3 | 8 | 28856 | 29 | ||
| 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 | |
| 31921 | 191247 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1453 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6016461.47366 | 2096825.22247 | 37.7384066073881 | -122.385582111127 | (37.7384066073881, -122.385582111127) | 10 | 3 | 8 | 58 | 1 | |||
| 46503 | 201810 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6021035.70856 | 2093179.80399 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | 10 | 3 | 8 | 58 | 1 | |||
| 54445 | 201812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 3 | : | Tree | Private 2 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.7287741263267 | -122.369414113788 | (37.7287741263267, -122.369414113788) | 10 | 3 | 8 | 58 | 1 | |||
| 56826 | 176874 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | 10 | 3 | 8 | 309 | 1 | |||
| 57255 | 176878 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.7098626625021 | -122.396290845073 | (37.7098626625021, -122.396290845073) | 10 | 3 | 8 | 309 | 1 | |||
| 84471 | 27064 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 801 Silver Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 1 | 4 | 6007054.44286 | 2093598.36831 | 37.7290213868102 | -122.417878446659 | (37.7290213868102, -122.417878446659) | 9 | 3 | 7 | 309 | 28 | ||
| 125237 | 201811 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | 10 | 3 | 8 | 58 | 1 | |||
| 135455 | 201808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 247 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 34639 | 93188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53196 | 6014934.44131 | 2097265.12572 | 37.7395298812852 | -122.39089262491 | (37.7395298812852, -122.39089262491) | 10 | 3 | 8 | 58 | 1 | |
| 102170 | 39552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013009.1617 | 2107035.865 | 37.7662512051775 | -122.398234785624 | (37.7662512051775, -122.398234785624) | 14 | 3 | 8 | 28856 | 20 | ||
| 145694 | 40073 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014207.29735 | 2094114.30982 | 37.7308380137496 | -122.393186376362 | (37.7308380137496, -122.393186376362) | 10 | 3 | 8 | 58 | 1 | |
| 152733 | 40072 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014219.27435 | 2094112.15212 | 37.7308327545053 | -122.393144818701 | (37.7308327545053, -122.393144818701) | 10 | 3 | 8 | 58 | 1 | |
| 25340 | 176908 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1053 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007885.16277 | 2093698.95374 | 37.7293442892945 | -122.415013692231 | (37.7293442892945, -122.415013692231) | 9 | 3 | 7 | 309 | 28 | |||
| 145844 | 26986 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1349 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009414.0618 | 2094354.93302 | 37.7312312656966 | -122.409774411069 | (37.7312312656966, -122.409774411069) | 9 | 3 | 7 | 309 | 28 | |||
| 158730 | 27025 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1380X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 12 | 3X3 | 6009629.1666 | 2094382.20254 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | 10 | 3 | 7 | 309 | 28 | ||
| 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 | |||
| 3177 | 191238 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 8 | : | Tree | Private 2 | 2 | Width 2ft | 6014118.19632 | 2095356.58877 | 37.7342441078693 | -122.393581327137 | (37.7342441078693, -122.393581327137) | 10 | 3 | 8 | 58 | 1 | |||
| 101851 | 176875 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012929.76757 | 2086570.3757 | 37.7100528322548 | -122.397074274178 | (37.7100528322548, -122.397074274178) | 10 | 3 | 8 | 309 | 1 | |||
| 118890 | 176879 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 140 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010956.3364 | 2092967.77816 | 37.7275087379234 | -122.404344863032 | (37.7275087379234, -122.404344863032) | 10 | 3 | 7 | 309 | 28 | |||
| 127629 | 176876 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013031.56753 | 2086536.06642 | 37.7099642921874 | -122.396720027609 | (37.7099642921874, -122.396720027609) | 10 | 3 | 8 | 309 | 1 | |||
| 169305 | 176877 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.7099103976217 | -122.396487432357 | (37.7099103976217, -122.396487432357) | 10 | 3 | 8 | 309 | 1 | |||
| 175919 | 201807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 273 Friedell St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6020893.11722 | 2092989.08595 | 37.7281175177998 | -122.369994383343 | (37.7281175177998, -122.369994383343) | 10 | 3 | 8 | 58 | 1 | |||
| 334 | 162296 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010920.41592 | 2090984.45712 | 37.7220609417541 | -122.40432950351 | (37.7220609417541, -122.40432950351) | 10 | 3 | 7 | 309 | 28 | ||
| 6290 | 259344 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6009725.84271 | 2093690.47402 | 37.7294242696948 | -122.408649667073 | (37.7294242696948, -122.408649667073) | 10 | 3 | 7 | 309 | 28 | ||
| 9949 | 162295 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010903.85659 | 2090979.54911 | 37.7220465400048 | -122.404386400036 | (37.7220465400048, -122.404386400036) | 10 | 3 | 7 | 309 | 28 | ||
| 10393 | 3666 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 102 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:06:00 PM | 3 | 3X3 | 6017134.48475 | 2098914.37607 | 37.7441802162386 | -122.383400533034 | (37.7441802162386, -122.383400533034) | 10 | 3 | 8 | 58 | 1 | ||
| 11481 | 3673 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 109 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:21:00 AM | 3 | 3X3 | 6017015.17172 | 2099002.62034 | 37.7444159222737 | -122.383819238476 | (37.7444159222737, -122.383819238476) | 10 | 3 | 8 | 58 | 1 | ||
| 11900 | 3534 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:10:00 AM | 3 | 3X3 | 6018402.12937 | 2097818.41667 | 37.7412409080406 | -122.378941151133 | (37.7412409080406, -122.378941151133) | 10 | 3 | 8 | 58 | 1 | ||
| 12682 | 260425 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 508 Dwight St | Unaccepted Street : Yard | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010099.90949 | 2091269.80828 | 37.7227985719868 | -122.407185909529 | (37.7227985719868, -122.407185909529) | 10 | 3 | 7 | 309 | 28 | |||
| 13960 | 27162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011270.31088 | 2095195.56425 | 37.7336433130742 | -122.40341610708 | (37.7336433130742, -122.40341610708) | 10 | 3 | 8 | 58 | 1 | ||
| 15493 | 259346 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 106 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6011005.88556 | 2093460.4594 | 37.728864306632 | -122.404208230977 | (37.728864306632, -122.404208230977) | 10 | 3 | 7 | 309 | 28 | ||
| 17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | 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 | ||
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | 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 | ||
| 21462 | 201816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.7290596700622 | -122.369153577473 | (37.7290596700622, -122.369153577473) | 10 | 3 | 8 | 58 | 1 | ||
| 21976 | 26983 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1395 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6009622.93574 | 2094432.56882 | 37.7314561402837 | -122.409057769215 | (37.7314561402837, -122.409057769215) | 9 | 3 | 7 | 309 | 28 | ||
| 22775 | 27008 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1430 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009940.18408 | 2094497.75014 | 37.7316528813564 | -122.407965571349 | (37.7316528813564, -122.407965571349) | 10 | 3 | 7 | 309 | 28 | ||
| 25283 | 3523 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:28:00 AM | 3 | 3X3 | 6018216.35215 | 2097958.49501 | 37.7416152904271 | -122.379593238756 | (37.7416152904271, -122.379593238756) | 10 | 3 | 8 | 58 | 1 | ||
| 28445 | 3667 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 103 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:19:00 PM | 3 | 3X3 | 6017116.62756 | 2098928.27448 | 37.7442173915214 | -122.383463247242 | (37.7442173915214, -122.383463247242) | 10 | 3 | 8 | 58 | 1 | ||
| 31518 | 201833 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.87799 | 37.7277210345753 | -122.370535976659 | (37.7277210345753, -122.370535976659) | 10 | 3 | 8 | 58 | 1 | |
| 33310 | 27006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1420 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/1999 12:00:00 AM | 3 | 3X3 | 6009885.43307 | 2094479.90043 | 37.73160080432 | -122.408153598922 | (37.73160080432, -122.408153598922) | 10 | 3 | 7 | 309 | 28 | ||
| 33446 | 191235 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6014141.54444 | 2095385.83675 | 37.7343257141509 | -122.393502650848 | (37.7343257141509, -122.393502650848) | 10 | 3 | 8 | 58 | 1 | |||
| 33564 | 27026 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1380X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009629.1666 | 2094382.20254 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | 10 | 3 | 7 | 309 | 28 | ||
| 37255 | 108775 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 46442 | 3681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 117 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:27:00 PM | 3 | 3X3 | 6016866.95731 | 2099120.49255 | 37.7447313810499 | -122.384339945926 | (37.7447313810499, -122.384339945926) | 10 | 3 | 8 | 58 | 1 | ||
| 52248 | 201838 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020663.4716 | 2092744.71005 | 37.7274339035298 | -122.370771395785 | (37.7274339035298, -122.370771395785) | 10 | 3 | 8 | 58 | 1 | |
| 52628 | 176910 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1390 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009561.38521 | 2094361.93193 | 37.7312587382014 | -122.409265579153 | (37.7312587382014, -122.409265579153) | 10 | 3 | 7 | 309 | 28 | |||
| 53926 | 201827 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020879.65439 | 2093047.83852 | 37.7282781025329 | -122.370044984594 | (37.7282781025329, -122.370044984594) | 10 | 3 | 8 | 58 | 1 | |
| 54619 | 108768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 57077 | 201825 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.19247 | 37.7284547293849 | -122.369881218949 | (37.7284547293849, -122.369881218949) | 10 | 3 | 8 | 58 | 1 | |
| 59083 | 88474 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51428 | 6011695.42869 | 2099760.86607 | 37.7462023967426 | -122.402267215055 | (37.7462023967426, -122.402267215055) | 10 | 3 | 8 | 58 | 1 | |
| 59846 | 201831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.88429 | 37.7278602487283 | -122.370419366967 | (37.7278602487283, -122.370419366967) | 10 | 3 | 8 | 58 | 1 | |
| 62270 | 176912 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1390 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009589.47798 | 2094371.19963 | 37.7312857592085 | -122.409169110679 | (37.7312857592085, -122.409169110679) | 10 | 3 | 7 | 309 | 28 | |||
| 63555 | 201813 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.7288565518864 | -122.369345258092 | (37.7288565518864, -122.369345258092) | 10 | 3 | 8 | 58 | 1 | ||
| 66747 | 27158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011192.58379 | 2095136.52795 | 37.7334768701528 | -122.403680681311 | (37.7334768701528, -122.403680681311) | 10 | 3 | 8 | 58 | 1 | ||
| 72608 | 201817 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 1 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.369296441991 | (37.7290887577236, -122.369296441991) | 10 | 3 | 8 | 58 | 1 | ||
| 75496 | 191243 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1620 Newhall St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6014061.56884 | 2095278.41625 | 37.7340263154591 | -122.393771638049 | (37.7340263154591, -122.393771638049) | 10 | 3 | 8 | 58 | 1 | |||
| 76376 | 191242 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1620 Newhall St | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6014072.32553 | 2095292.84785 | 37.73406653943 | -122.393735458343 | (37.73406653943, -122.393735458343) | 10 | 3 | 8 | 58 | 1 | |||
| 76682 | 201818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 2 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021088.08179 | 2093322.41734 | 37.7290434795636 | -122.369343396492 | (37.7290434795636, -122.369343396492) | 10 | 3 | 8 | 58 | 1 | ||
| 77318 | 191240 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1620 Newhall St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6014102.75792 | 2095335.27393 | 37.734184723833 | -122.393633211698 | (37.734184723833, -122.393633211698) | 10 | 3 | 8 | 58 | 1 | |||
| 80049 | 3674 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 110 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:22:00 AM | 3 | 3X3 | 6016998.30504 | 2099015.89853 | 37.7444514490906 | -122.383878484902 | (37.7444514490906, -122.383878484902) | 10 | 3 | 8 | 58 | 1 | ||
| 80797 | 201815 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | 10 | 3 | 8 | 58 | 1 | ||
| 82173 | 201824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 8 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021004.60368 | 2093212.58809 | 37.7287373296405 | -122.369624404053 | (37.7287373296405, -122.369624404053) | 10 | 3 | 8 | 58 | 1 | ||
| 86466 | 191233 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2055 Silver Ave | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6012545.71972 | 2096123.80654 | 37.7362632270542 | -122.399071750278 | (37.7362632270542, -122.399071750278) | 10 | 3 | 8 | 58 | 1 | |||
| 88331 | 176913 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1390 Silver Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009673.25426 | 2094402.87309 | 37.7313774208194 | -122.40888171342 | (37.7313774208194, -122.40888171342) | 10 | 3 | 7 | 309 | 28 | |||
| 89153 | 27009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1446 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 3 | 3X3 | 6010020.23018 | 2094527.09535 | 37.7317379383331 | -122.407690903133 | (37.7317379383331, -122.407690903133) | 10 | 3 | 7 | 309 | 28 | ||
| 92176 | 191244 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1620 Newhall St | 5 | : | Tree | Private 2 | 3 | Width 2ft | 6014050.66054 | 2095263.98772 | 37.7339860914812 | -122.393808342098 | (37.7339860914812, -122.393808342098) | 10 | 3 | 8 | 58 | 1 | |||
| 96434 | 27007 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1424 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009909.30958 | 2094487.23688 | 37.7316222855427 | -122.408071569962 | (37.7316222855427, -122.408071569962) | 10 | 3 | 7 | 309 | 28 | ||
| 97627 | 27156 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011160.21022 | 2095112.55455 | 37.7334092357479 | -122.403790920224 | (37.7334092357479, -122.403790920224) | 10 | 3 | 8 | 58 | 1 | ||
| 100533 | 27048 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 896 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6007189.55023 | 2093517.44233 | 37.7288067843062 | -122.417405636178 | (37.7288067843062, -122.417405636178) | 9 | 3 | 7 | 309 | 5 | ||
| 102075 | 201832 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020752.62591 | 2092874.74971 | 37.7277958617862 | -122.370472171548 | (37.7277958617862, -122.370472171548) | 10 | 3 | 8 | 58 | 1 | |
| 103320 | 27036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1328 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009383.50137 | 2094296.42093 | 37.7310688913025 | -122.409875935553 | (37.7310688913025, -122.409875935553) | 9 | 3 | 7 | 309 | 28 | ||
| 106294 | 191227 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201 Texas St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013759.688 | 2106121.42545 | 37.7637821327587 | -122.395574766182 | (37.7637821327587, -122.395574766182) | 14 | 3 | 8 | 28856 | 29 | |||
| 108067 | 27003 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1380X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6009629.1666 | 2094382.20254 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | 10 | 3 | 7 | 309 | 28 | ||
| 108222 | 108764 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 108420 | 201836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020688.4191 | 2092782.87071 | 37.7275400550072 | -122.370687788509 | (37.7275400550072, -122.370687788509) | 10 | 3 | 8 | 58 | 1 | |
| 116827 | 191241 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1620 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6014082.94285 | 2095307.88657 | 37.7341084226719 | -122.393699802926 | (37.7341084226719, -122.393699802926) | 10 | 3 | 8 | 58 | 1 | |||
| 117917 | 108778 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 121234 | 201829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 284 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020846.41585 | 2093000.79454 | 37.7281471046068 | -122.370156642634 | (37.7281471046068, -122.370156642634) | 10 | 3 | 8 | 58 | 1 | |
| 125720 | 27527 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1114 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2015 07:52:00 AM | 3 | 3X3 | 6008222.66754 | 2093785.3034 | 37.7296003469798 | -122.413853009211 | (37.7296003469798, -122.413853009211) | 9 | 3 | 7 | 309 | 28 | ||
| 127080 | 112029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 129793 | 201837 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020676.58787 | 2092764.09442 | 37.7274878493838 | -122.370727391967 | (37.7274878493838, -122.370727391967) | 10 | 3 | 8 | 58 | 1 | |
| 133595 | 88475 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51428 | 6011686.38123 | 2099767.14104 | 37.7462191214225 | -122.402298941348 | (37.7462191214225, -122.402298941348) | 10 | 3 | 8 | 58 | 1 |
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) );