1,121 rows where qSpecies_id = 6 sorted by qAddress 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)
425 10157 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 995 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x7   6005745.76106 2103227.37374 37.7553867222415 -122.423086804612 (37.7553867222415, -122.423086804612) 2 4 5 28859 19
1269 262440 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
2939 262442 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
15310 262443 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
15599 262439 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
72364 216718 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 978 Capitol Ave 2 Sidewalk: Curb side : Yard Tree Private 2   10/13/2017 11:36:00 AM 3 Width 3ft   5995057.03199 2090421.24862 37.7196152839906 -122.459124173263 (37.7196152839906, -122.459124173263) 9 8 6 28861 24
131707 52954 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 975 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM 5   Permit Number 48941 6000767.51384 2091342.11633 37.7224704120511 -122.439451120374 (37.7224704120511, -122.439451120374) 9 7 6 28861 25
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
164870 87861 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 96 Caselli Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2008 12:00:00 AM   3x3 Permit Number 50803 6000485.4 2104954.1 37.7598296396585 -122.441402573572 (37.7598296396585, -122.441402573572) 2 4 5 28862 3
151427 176883 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 96 Alpha St 4 Front Yard : Yard Tree Private 2     1     6011048.63475 2088252.82193 37.7145675926038 -122.403694172945 (37.7145675926038, -122.403694172945) 9 7 8 309 39
172292 176884 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 96 Alpha St 2 Front Yard : Yard Tree Private 2     1     6011062.55449 2088258.87965 37.7145850034576 -122.403646486396 (37.7145850034576, -122.403646486396) 9 7 8 309 39
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
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
10786 95722 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
24139 95719 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
25141 95718 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
53300 95720 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
84749 95721 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 950 Avalon Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047) 9 7 6 28861 5
31711 227556 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Seward St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6000674.34081 2104608.13246 37.7588904593411 -122.440724304978 (37.7588904593411, -122.440724304978) 2 4 5 28862 38
39381 181028 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.46766 37.7151323074928 -122.440070279342 (37.7151323074928, -122.440070279342) 9 7 6 28861 5
133452 181027 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.24811 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188) 9 7 6 28861 5
14691 69919 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 95 Mercedes Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.7286182461033 -122.470591251084 (37.7286182461033, -122.470591251084) 9 8 4 59 40
53141 71841 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 95 Mercedes Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.7286182461033 -122.470591251084 (37.7286182461033, -122.470591251084) 9 8 4 59 40
194398 162836 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/2020 12:00:00 AM 0 4x6   5996489.45825 2090475.5577 37.7198466480955 -122.454176740991 (37.7198466480955, -122.454176740991) 9 8 6 28861 24
127633 52071 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 939 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009677.58908 2117754.14875 37.7954949369081 -122.410515038747 (37.7954949369081, -122.410515038747) 3 1 10 28857 4
194195 52070 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 939 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009656.25559 2117750.51311 37.7954837583147 -122.410588599703 (37.7954837583147, -122.410588599703) 3 1 10 28857 4
74010 129386 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009490.7484 2116033.66261 37.7907604245028 -122.411039958651 (37.7907604245028, -122.411039958651) 5 1 10 28857 21
47209 165132 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 781230 5995776.8676 2094560.79185 37.7310228361347 -122.456935228771 (37.7310228361347, -122.456935228771) 9 7 4 28861 40
92269 165133 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 781230 5995820.38989 2094571.40487 37.731054476063 -122.456785533051 (37.731054476063, -122.456785533051) 9 7 4 28861 40
664 262379 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 925 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2020 12:00:00 AM 3 3x3   5998032 2106999 37.7653043483693 -122.450035028723 (37.7653043483693, -122.450035028723) 15 5 11 29492 9
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
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
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
109623 227566 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 Clover Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6000468.02748 2104951.63177 37.7598218728073 -122.441462479323 (37.7598218728073, -122.441462479323) 2 4 5 28862 3
150091 129390 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 902 Vallejo St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6009192.86484 2118752.75452 37.798209676283 -122.412262888224 (37.798209676283, -122.412262888224) 3 1 10 308 21
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
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
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
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
83077 119164 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 883 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5981372.52859 2109725.62562 37.7718235084184 -122.507857566702 (37.7718235084184, -122.507857566702) 11 6 2 55 26
13775 68397 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 88 Lyell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2020 12:00:00 AM 3   Permit Number 785230 6003105.95459 2094517.30646 37.7313215783119 -122.43159424368 (37.7313215783119, -122.43159424368) 9 7 5 28861 25
132775 180842 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 87 Laura St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 03:54:00 PM 3 Width 2ft   5997291.8877 2087045.22216 37.710473721248 -122.451155786013 (37.710473721248, -122.451155786013) 9 7 6 28861 25
113649 117934 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 867 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5982916.92515 2109877.96567 37.7723326617078 -122.502526759002 (37.7723326617078, -122.502526759002) 11 6 2 55 26
192805 115237 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 867 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM     Permit Number 775536 5982900.6 2109891.1 37.7723677654738 -122.502584200594 (37.7723677654738, -122.502584200594) 11 6 2 55 26
63206 115239 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 863 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM     Permit Number 775147 5981970.6 2109880.3 37.7722834181785 -122.505800301349 (37.7722834181785, -122.505800301349) 11 6 2 55 26
186887 119083 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 863 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5981985.30992 2109867.54201 37.7722492542332 -122.505748473333 (37.7722492542332, -122.505748473333) 11 6 2 55 26
140514 95742 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 86 Ina Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767488 6004830.44311 2091416.58174 37.7229052675357 -122.425411786848 (37.7229052675357, -122.425411786848) 9 7 6 28861 5
34235 207024 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 85 Williar Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997067.34432 2090557.59428 37.7201050223995 -122.452185117661 (37.7201050223995, -122.452185117661) 9 8 6 28861 24
112582 207022 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 85 Williar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997053.5846 2090532.92812 37.7200365066592 -122.452230901246 (37.7200365066592, -122.452230901246) 9 8 6 28861 24
120285 207025 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 85 Williar Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5997075.91635 2090573.81293 37.7201500460637 -122.452156656813 (37.7201500460637, -122.452156656813) 9 8 6 28861 24
151234 207023 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 85 Williar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5997061.02366 2090546.31892 37.7200737008175 -122.452206152789 (37.7200737008175, -122.452206152789) 9 8 6 28861 24
190265 227118 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 85 29th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005870.45988 2099040.93392 37.7438987545141 -122.422358119057 (37.7438987545141, -122.422358119057) 2 7 7 28859 2
168688 227572 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 841 Church St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6004362.06253 2104151.54801 37.7578461063327 -122.427937906015 (37.7578461063327, -122.427937906015) 2 4 5 28862 3
101905 43742 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 840 Mount Vernon Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.452139826069 (37.7199634590291, -122.452139826069) 9 8 6 28861 24
107401 43741 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 840 Mount Vernon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.452139826069 (37.7199634590291, -122.452139826069) 9 8 6 28861 24
139435 43740 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 840 Mount Vernon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.452139826069 (37.7199634590291, -122.452139826069) 9 8 6 28861 24
144972 43739 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 840 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.452139826069 (37.7199634590291, -122.452139826069) 9 8 6 28861 24
5680 227559 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 84 Seward St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6000741.27617 2104538.3206 37.7587025846742 -122.44048780488 (37.7587025846742, -122.44048780488) 2 4 5 28862 38
71720 227560 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 84 Seward St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6000737.03493 2104555.7602 37.7587502280493 -122.440503723791 (37.7587502280493, -122.440503723791) 2 4 5 28862 38
144465 227561 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 84 Seward St 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6000738.66154 2104570.78605 37.7587915779822 -122.44049917592 (37.7587915779822, -122.44049917592) 2 4 5 28862 38
61823 109689 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 836 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774161 6003406.50306 2089728.73547 37.7181902596385 -122.430213694415 (37.7181902596385, -122.430213694415) 9 7 6 28861 5
56885 207029 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 835 Sargent St 1 : Tree Private 2     7 Width 3ft   5991723.94975 2089189.17612 37.7160401362134 -122.470555641023 (37.7160401362134, -122.470555641023) 9 8 6 64 24
185300 207030 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 835 Sargent St 2 : Tree Private 2     7 Width 3ft   5991738.49074 2089190.01168 37.7160432712657 -122.470505441771 (37.7160432712657, -122.470505441771) 9 8 6 64 24
43518 114818 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 825 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/14/2018 12:00:00 AM 3   Permit Number 774480 5986555.6 2110296.1 37.773693882861 -122.489971179067 (37.773693882861, -122.489971179067) 11 6 2 55 26
69435 114895 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 820 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2015 12:00:00 AM     Permit Number 775427 5986664.4 2110325.3 37.7737804103986 -122.489596975753 (37.7737804103986, -122.489596975753) 11 6 2 55 26
45396 227112 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 82 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6007863.71848 2099963.32211 37.7465436642568 -122.41553116305 (37.7465436642568, -122.41553116305) 2 7 7 28859 2
186958 120000 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 818 30th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   5986676.70436 2110336.54693 37.7738120096448 -122.489555240793 (37.7738120096448, -122.489555240793) 11 6 2 55 26
6021 260882 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 810 33rd Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5985734.50152 2110356.92333 37.7738129057539 -122.492815926544 (37.7738129057539, -122.492815926544) 11 6 2 55 26
5588 227150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 808 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008185.20329 2095640.92661 37.7346933830922 -122.414113755053 (37.7346933830922, -122.414113755053) 2 7 7 28859 2
2502 84554 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 804 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5986976.65331 2110412.96099 37.7740393278808 -122.488523300237 (37.7740393278808, -122.488523300237) 11 6 2 55 26
146035 84332 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 804 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51851 5986981.94009984 2110441.32651783 37.7741175201244 -122.488507097746 (37.7741175201244, -122.488507097746) 11 6 2 55 26
177211 102935 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 801X Church St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6004394.3 2104124.7 37.7577742117678 -122.427824502367 (37.7577742117678, -122.427824502367) 2 4 5 28862 3
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
29694 248531 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 800 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5997658.268 2107761.8815 37.7673776340728 -122.451382700243 (37.7673776340728, -122.451382700243) 15 5 11 29492 9
41094 51607 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 800 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/2005 12:00:00 AM 5 3x3 Permit Number 47904 5997656.30420255 2107807.08178851 37.7675016300781 -122.45139275313 (37.7675016300781, -122.45139275313) 15 5 11 29492 9
31662 27080 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 799X Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 6 2X3   6006577.59669 2093640.72947 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915) 9 7 7 309 5
156893 27081 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 799X Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM 3 2X3   6006577.59669 2093640.72947 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915) 9 7 7 309 5
181974 227119 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022) 2 7 5 63 22
192824 227120 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6001486.23397 2099669.55813 37.7453765205103 -122.43756273743 (37.7453765205103, -122.43756273743) 2 7 5 63 22
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
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
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
72338 227121 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 791 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001433.87774 2099966.59062 37.7461891245209 -122.437765046244 (37.7461891245209, -122.437765046244) 2 7 5 63 22
106660 27046 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 790 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 6 3X3   6006496.08217 2093583.10222 37.7289480300179 -122.419807663316 (37.7289480300179, -122.419807663316) 9 7 7 309 5
49974 73594 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2014 12:00:00 AM 3   Permit Number 772812 6008453.79298 2114896.74793 37.7875805296608 -122.414547298434 (37.7875805296608, -122.414547298434) 5 1 10 28858 21
131191 71549 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 780 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/2015 12:00:00 AM 3 3x3 Permit Number 772812 6008431.05429 2114892.38013 37.7875672592553 -122.414625660841 (37.7875672592553, -122.414625660841) 5 1 10 28858 21
158967 79726 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50955 6008416.19534554 2114892.53002417 37.7875668360064 -122.414677080613 (37.7875668360064, -122.414677080613) 5 1 10 28858 21
154133 227547 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 780 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001390.11593 2102052.79607 37.7519148588942 -122.438065782205 (37.7519148588942, -122.438065782205) 2 4 5 28862 22
109581 27083 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 773 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/21/2007 12:00:00 AM 3 2X3   6006444.73415 2093622.02758 37.7290520177348 -122.419987938702 (37.7290520177348, -122.419987938702) 9 7 7 309 5
189609 227083 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 770 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6008514.34527 2104071.33726 37.7578598992273 -122.41357185686 (37.7578598992273, -122.41357185686) 2 4 7 28859 19
106563 95938 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 770 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767634 5986967.37973 2110670.26469 37.7747452702656 -122.488574294001 (37.7747452702656, -122.488574294001) 11 6 2 55 26
172005 227579 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 77 Landers St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004499.29505 2107353.29779 37.7666451110058 -122.427691415339 (37.7666451110058, -122.427691415339) 8 4 5 28862 3
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
29761 176907 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 769 Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006492.03782 2093629.408 37.7290749477448 -122.419824929392 (37.7290749477448, -122.419824929392) 9 7 7 309 5
137268 176906 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 769 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006512.6379 2093630.87617 37.7290801395131 -122.419753817278 (37.7290801395131, -122.419753817278) 9 7 7 309 5
10151 146941 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 763 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5982269.93422 2110578.75305 37.7742187803997 -122.504816658869 (37.7742187803997, -122.504816658869) 11 6 2 55 26
35644 117055 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 762 34th Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/18/2016 12:00:00 AM 3   Permit Number 778404 5985439.6 2110687.7 37.7747038750392 -122.493860404631 (37.7747038750392, -122.493860404631) 11 6 2 55 26
139164 118188 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 762 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5985415.78787 2110692.34221 37.7747152280145 -122.493943116599 (37.7747152280145, -122.493943116599) 11 6 2 55 26
155044 52456 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 757 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/2013 12:00:00 AM 1   Permit Number 770898 5992550.20906 2110320.92766 37.7741102732547 -122.469236887906 (37.7741102732547, -122.469236887906) 11 6 2 54 11
29952 137671 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 756 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000049.6788 2111547.4906 37.7779086039439 -122.443383113797 (37.7779086039439, -122.443383113797) 15 5 11 29490 16

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