185 rows where Police Districts = 3 and qSpecies_id = 6

View and edit SQL

These facets timed out: Police Districts

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
887 60297 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1101 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1982 12:00:00 AM 7   Permit Number 19862 6013032.9382 2107035.865 37.7662525295396 -122.398152546702 (37.7662525295396, -122.398152546702) 14 3 8 28856 20
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
1417 88463 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 955X Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471) 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
12065 88481 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1221 Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 5 3x3 Permit Number 51432 6014818.59944 2096228.0421 37.7366758342199 -122.391220684988 (37.7366758342199, -122.391220684988) 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
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
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
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
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
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
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
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
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
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
44173 49818 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1300 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2003 12:00:00 AM 7 3x3 Permit Number 46609 6012222.38132 2102319.17957 37.7532563730854 -122.400624753529 (37.7532563730854, -122.400624753529) 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
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
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
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
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
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
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
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
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
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
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
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
94732 88465 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 955X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471) 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
96851 82945 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2009 12:00:00 AM 6 3x3 Permit Number 52470 6007551.81764 2093700.90463 37.7293309082802 -122.416166238177 (37.7293309082802, -122.416166238177) 9 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
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
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
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
107198 50036 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 73 University St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM 9   Permit Number 46766 6007832.62107 2093714.43935 37.7293838567558 -122.415196429982 (37.7293838567558, -122.415196429982) 9 3 7 309 28
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
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
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
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

Next page

Advanced export

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

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);