1,121 rows where qSpecies_id = 6 sorted by Supervisor Districts descending

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts ▲ Zip Codes Neighborhoods (old)
9840 256599 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 26 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
15133 129382 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008704.56308 2112447.63135 37.7808699297471 -122.413506401504 (37.7808699297471, -122.413506401504) 7 10 9 28852 36
18289 88190 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1118 Harrison St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51195 6010631 2110372 37.7752787109316 -122.406695562022 (37.7752787109316, -122.406695562022) 8 2 9 28853 34
20503 129384 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008749.2926 2112454.62361 37.7808916402666 -122.413352154294 (37.7808916402666, -122.413352154294) 7 10 9 28852 36
29256 256605 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 32 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
32904 256600 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 27 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
48121 227587 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 77 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6006751.41341 2109490.52204 37.7726405574578 -122.420053398542 (37.7726405574578, -122.420053398542) 8 2 9 28853 19
51877 256607 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 34 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
54965 191246 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 22 Rausch St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009574.51886 2111002.08454 37.776949608681 -122.410394686976 (37.776949608681, -122.410394686976) 8 2 9 28853 34
61590 256576 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
70541 256574 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
80264 105013 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
92191 105012 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
92562 256604 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 31 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
107310 88186 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 43 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 5 3x3 Permit Number 51193 6008751.52799 2109978.60624 37.7740932089612 -122.41316928526 (37.7740932089612, -122.41316928526) 8 2 9 28853 34
107699 129383 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008721.10925 2112450.33412 37.7808782799549 -122.413449351208 (37.7808782799549, -122.413449351208) 7 10 9 28852 36
121138 95828 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 174 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM 6 3x3 Permit Number 767563 6010564.55165 2110346.83579 37.775205897855 -122.406923649213 (37.775205897855, -122.406923649213) 8 2 9 28853 34
134706 256601 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 28 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
136349 105014 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
148373 129381 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 555 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008630.87446 2114175.52263 37.7856101663154 -122.413883591577 (37.7856101663154, -122.413883591577) 7 10 9 28852 36
149522 106431 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 747 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008848.75367 2110684.34026 37.7760364460542 -122.412882870049 (37.7760364460542, -122.412882870049) 8 2 9 28853 34
160238 256575 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
170364 88187 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 43 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 6 3x3 Permit Number 51193 6008740.44285 2109989.37217 37.7741221473478 -122.413208392271 (37.7741221473478, -122.413208392271) 8 2 9 28853 34
183981 256606 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 33 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
190595 88188 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 43-25 Dore St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 6 3x3 Permit Number 51193 6008699.51281 2110034.52168 37.7742438193359 -122.413353170509 (37.7742438193359, -122.413353170509) 8 2 9 28853 34
8 264824 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
25 49783 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3   Permit Number 46568 6011944.29976 2088937.30454 37.7164970376796 -122.400646428989 (37.7164970376796, -122.400646428989) 10 7 8 309 39
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
9408 259103 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 625 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010501.76504 2086856.29359 37.7107024439005 -122.405486089504 (37.7107024439005, -122.405486089504) 9 7 8 309 39
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
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
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
15168 259102 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 619 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010517.89431 2086850.21293 37.7106866494876 -122.405429914879 (37.7106866494876, -122.405429914879) 9 7 8 309 39
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
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
23429 176881 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3303 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011991.79808 2090250.44255 37.7201052985 -122.400574440964 (37.7201052985, -122.400574440964) 10 7 8 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
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
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
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
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
49657 46433 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011103.47209 2089684.58226 37.718501979072 -122.403605308234 (37.718501979072, -122.403605308234) 10 7 8 309 28
51610 176885 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rey St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6008580.05361 2087004.56736 37.7110019335603 -122.412138452652 (37.7110019335603, -122.412138452652) 9 7 8 309 39
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
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
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
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
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
76984 176882 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 371 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/2018 12:00:00 AM 3 3x3 Permit Number 781358 6010924.50069 2089093.90072 37.7168700890604 -122.404182392406 (37.7168700890604, -122.404182392406) 9 7 8 309 39
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
82669 46431 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2002 12:00:00 AM 1   Permit Number 44652 6011089.42189 2089718.35805 37.7185939356546 -122.403656249429 (37.7185939356546, -122.403656249429) 10 7 8 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
86891 41786 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 11   Permit Number 42194 6011862.44614 2107450.91483 37.7673268978362 -122.402230262809 (37.7673268978362, -122.402230262809) 8 2 8 28853 20
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
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
95475 46434 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174) 10 7 8 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
97730 41784 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 15th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 13   Permit Number 42194 6011899.9957 2107451.97946 37.7673319169733 -122.40210045827 (37.7673319169733, -122.40210045827) 8 2 8 28853 20
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

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