trees
185 rows where Police Districts = 3 and qSpecies_id = 6 sorted by PermitNotes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 9738 | 79640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 12096 | 83834 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6013045.53048 | 2096356.5558 | 37.7369301480983 | -122.397360003177 | (37.7369301480983, -122.397360003177) | 10 | 3 | 8 | 58 | 1 | |||
| 12282 | 83440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2230 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011076.92464 | 2105580.38381 | 37.7621469638337 | -122.404815578978 | (37.7621469638337, -122.404815578978) | 8 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 22726 | 191234 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6014153.11677 | 2095403.12134 | 37.7343738170818 | -122.393463850493 | (37.7343738170818, -122.393463850493) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 24569 | 176914 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1300 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009346.09367 | 2094283.90387 | 37.7310324255937 | -122.41000437762 | (37.7310324255937, -122.41000437762) | 9 | 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 40165 | 191226 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6011107.06002 | 2104648.42845 | 37.7595897074225 | -122.404645742032 | (37.7595897074225, -122.404645742032) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 60494 | 27052 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1016 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6007658.95865 | 2093571.88726 | 37.7289826781912 | -122.415786708996 | (37.7289826781912, -122.415786708996) | 9 | 3 | 7 | 309 | 5 | ||
| 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 | ||
| 65951 | 191221 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014015.89789 | 2106592.91783 | 37.7650909952748 | -122.394721628821 | (37.7650909952748, -122.394721628821) | 14 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 67683 | 191232 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2055 Silver Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.398826976382 | (37.7363832218132, -122.398826976382) | 10 | 3 | 8 | 58 | 1 | |||
| 68285 | 27051 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1008 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3x3 | 6007619.46607 | 2093557.16905 | 37.7289400449304 | -122.415922196353 | (37.7289400449304, -122.415922196353) | 9 | 3 | 7 | 309 | 5 | ||
| 68376 | 27287 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1036 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2008 12:00:00 AM | 6 | 3X3 | 6007731.14975 | 2093596.42391 | 37.729054108643 | -122.415538874723 | (37.729054108643, -122.415538874723) | 9 | 3 | 7 | 309 | 5 | ||
| 68993 | 27000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1236 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6008836.56983 | 2094066.26048 | 37.7304062528391 | -122.411750521985 | (37.7304062528391, -122.411750521985) | 9 | 3 | 7 | 309 | 28 | ||
| 70811 | 3516 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/1996 12:00:00 AM | 6 | 3X3 | 6018109.71439 | 2098036.73671 | 37.7418242442879 | -122.379967395395 | (37.7418242442879, -122.379967395395) | 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 | ||
| 75326 | 176909 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1038 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007759.63809 | 2093605.48677 | 37.7290805945829 | -122.415441029374 | (37.7290805945829, -122.415441029374) | 9 | 3 | 7 | 309 | 5 | |||
| 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 | |||
| 77325 | 26988 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1339 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 6 | 3X3 | 6009367.01038 | 2094339.14162 | 37.7311852689794 | -122.409935962601 | (37.7311852689794, -122.409935962601) | 9 | 3 | 7 | 309 | 28 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 87554 | 27125 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2095X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2011 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 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 | |||
| 96120 | 27315 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1330X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009430.10492 | 2094285.00827 | 37.7310401662886 | -122.409714013149 | (37.7310401662886, -122.409714013149) | 9 | 3 | 7 | 309 | 28 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 111468 | 27168 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2070X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 6 | 2X3 | 6012351.75792 | 2095958.07131 | 37.735797342091 | -122.399730727068 | (37.735797342091, -122.399730727068) | 10 | 3 | 8 | 58 | 1 | ||
| 112579 | 191230 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1251 Newhall St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014739.49892 | 2096121.87769 | 37.7363799383901 | -122.391486752132 | (37.7363799383901, -122.391486752132) | 10 | 3 | 8 | 58 | 1 | |||
| 115205 | 191229 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 901 Newhall St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6015272.35005 | 2096832.51763 | 37.7383607716336 | -122.389694066038 | (37.7383607716336, -122.389694066038) | 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 | |||
| 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 | |||
| 120653 | 200835 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | 14 | 3 | 8 | 28856 | 20 | |||
| 121429 | 191228 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 901 Newhall St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6015254.00871 | 2096807.91476 | 37.7382922001146 | -122.38975576401 | (37.7382922001146, -122.38975576401) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 132697 | 28817 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1075 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6008023.97139 | 2093752.95169 | 37.7295003553203 | -122.414537636128 | (37.7295003553203, -122.414537636128) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 135912 | 3538 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 48 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 10:28:00 AM | 3 | 3X3 | 6018470.22426 | 2097768.00954 | 37.7411062543397 | -122.37870220127 | (37.7411062543397, -122.37870220127) | 10 | 3 | 8 | 58 | 1 | ||
| 137916 | 27123 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2095X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2011 12:00:00 AM | 3 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 138661 | 27273 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2095X Silver Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2011 12:00:00 AM | 8 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 139170 | 27314 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 884 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | 3 | 3X3 | 6007123.27309 | 2093533.58449 | 37.7288473779044 | -122.417635904868 | (37.7288473779044, -122.417635904868) | 9 | 3 | 7 | 309 | 5 | ||
| 141397 | 3676 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 112 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:24:00 AM | 3 | 3X3 | 6016964.48751 | 2099042.50937 | 37.7445226475172 | -122.383997272761 | (37.7445226475172, -122.383997272761) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 147718 | 201819 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021071.50009 | 2093300.77069 | 37.7289831323462 | -122.369399226393 | (37.7289831323462, -122.369399226393) | 10 | 3 | 8 | 58 | 1 | ||
| 149415 | 201820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021056.53291 | 2093279.09213 | 37.7289227860515 | -122.369449472416 | (37.7289227860515, -122.369449472416) | 10 | 3 | 8 | 58 | 1 | ||
| 149658 | 189150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 351 Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:46:00 AM | 3 | Width 3ft | 6017356.8528 | 2098625.87133 | 37.7434003277556 | -122.382611554189 | (37.7434003277556, -122.382611554189) | 10 | 3 | 8 | 58 | 1 | ||
| 153170 | 191220 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2300 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010900.2167 | 2105543.22676 | 37.762035060293 | -122.405424130428 | (37.762035060293, -122.405424130428) | 8 | 3 | 8 | 28856 | 29 | |||
| 154862 | 26985 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1353 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6009441.55287 | 2094364.79553 | 37.7312598866239 | -122.409680064978 | (37.7312598866239, -122.409680064978) | 9 | 3 | 7 | 309 | 28 | ||
| 155786 | 3539 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 49 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2017 08:08:00 AM | 3 | 3X3 | 6018487.88793 | 2097755.11327 | 37.7410718175127 | -122.378640230766 | (37.7410718175127, -122.378640230766) | 10 | 3 | 8 | 58 | 1 | ||
| 156146 | 201814 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.369257791817 | (37.728943392223, -122.369257791817) | 10 | 3 | 8 | 58 | 1 | ||
| 156212 | 27014 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1518 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 6 | 3X3 | 6010461.99919 | 2094665.45469 | 37.7321425639198 | -122.40617335478 | (37.7321425639198, -122.40617335478) | 10 | 3 | 7 | 309 | 28 | ||
| 157196 | 27169 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2080 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 2x3 | 6012550.77406 | 2096074.99276 | 37.7361294762783 | -122.39905085002 | (37.7361294762783, -122.39905085002) | 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) );