400 rows where qSpecies_id = 43 sorted by Zip Codes 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)
149710 40034 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM     Permit Number 41276 6017092.11727915 2093635.28500983 37.7296825468656 -122.383179660981 (37.7296825468656, -122.383179660981) 10 3 8 58 1
150948 38598 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1329 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40549 6016511.31684241 2093304.91013991 37.7287432904596 -122.385164559023 (37.7287432904596, -122.385164559023) 10 3 8 58 1
151562 40060 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41292 6016382.10864513 2092767.10585329 37.7272594375757 -122.385573778693 (37.7272594375757, -122.385573778693) 10 3 8 58 1
152483 38621 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1998 12:00:00 AM     Permit Number 40560 6016538.96174012 2092935.06529127 37.7277292986583 -122.385043230392 (37.7277292986583, -122.385043230392) 10 3 8 58 1
153929 36822 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
155651 38627 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40563 6016028.15247737 2093380.70622124 37.7289246716671 -122.386840188027 (37.7289246716671, -122.386840188027) 10 3 8 58 1
160706 38628 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   09/17/1998 12:00:00 AM     Permit Number 40563 6016028.15247737 2093380.70622124 37.7289246716671 -122.386840188027 (37.7289246716671, -122.386840188027) 10 3 8 58 1
165786 38568 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
166378 38565 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
182131 40049 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1435 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41286 6015948.92421606 2093724.14562026 37.7298633009427 -122.38713803352 (37.7298633009427, -122.38713803352) 10 3 8 58 1
183262 38616 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
187434 36819 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
59370 68249 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3531 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32050 6001184.87724579 2120700.92595518 37.8031062325164 -122.440112611548 (37.8031062325164, -122.440112611548) 13 9 1 57 17
98159 34672 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3112 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/01/2005 12:00:00 AM     Permit Number 38340 6003381.0349361 2119134.6254032 37.7989303613953 -122.432400821612 (37.7989303613953, -122.432400821612) 13 9 1 57 17
108248 96988 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
122439 96990 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
135345 96989 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
161625 126462 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1990 Beach St 4 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6000762.32542 2120990.48851 37.8038772290062 -122.441595650935 (37.8038772290062, -122.441595650935) 13 9 1 57 17
172638 126461 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1990 Beach St 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6000743.63592 2120987.57838 37.8038681737437 -122.441660117946 (37.8038681737437, -122.441660117946) 13 9 1 57 17
3187 70368 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1442 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5983113.9936 2105313.3819 37.7598111971708 -122.501507359539 (37.7598111971708, -122.501507359539) 1 8 3 56 35
9023 38354 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1875 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1998 12:00:00 AM 0   Permit Number 40422 5981305.52143941 2102319.66652747 37.7514849260003 -122.507539731955 (37.7514849260003, -122.507539731955) 1 8 3 56 35
9754 82920 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1734 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5982872.9956 2103302.6049 37.7542760130661 -122.502192036803 (37.7542760130661, -122.502192036803) 1 8 3 56 35
10370 72596 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1551 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988056.3788 2104735.0481 37.7585122851486 -122.484371869742 (37.7585122851486, -122.484371869742) 1 8 3 56 35
13527 34657 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 4   Permit Number 38334 5988005.8211 2105120.9797 37.7595690044056 -122.48457502698 (37.7595690044056, -122.48457502698) 1 8 3 56 35
13763 72614 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1586 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5987797.3449 2104500.8291 37.7578540967372 -122.485250528016 (37.7578540967372, -122.485250528016) 1 8 3 56 35
17683 34648 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1591 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 5   Permit Number 38327 5987753.8097 2104490.816 37.7578240672557 -122.485400354271 (37.7578240672557, -122.485400354271) 1 8 3 56 35
19177 38121 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1332 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM     Permit Number 40285 5986502.93855263 2106173.76895003 37.7623720383861 -122.489850100877 (37.7623720383861, -122.489850100877) 1 8 3 56 35
29636 69317 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2122 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1994 12:00:00 AM 6   Permit Number 33397 5987643.2305 2104427.6901 37.7576442978234 -122.485778145282 (37.7576442978234, -122.485778145282) 1 8 3 56 35
31546 37131 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4234 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 6   Permit Number 39713 5981666.4542 2104905.7911 37.7586069464275 -122.506483373023 (37.7586069464275, -122.506483373023) 1 8 3 56 35
32817 37130 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4234 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 4   Permit Number 39713 5981688.5295 2104905.7911 37.758608246146 -122.506407027964 (37.758608246146, -122.506407027964) 1 8 3 56 35
35084 34650 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1743 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38329 5987786.63645622 2103431.59810771 37.7549176542517 -122.485209109036 (37.7549176542517, -122.485209109036) 1 8 3 56 35
36106 182248 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1454 34th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5985596.8527 2105324.6327 37.7599875985541 -122.492921320569 (37.7599875985541, -122.492921320569) 1 8 3 56 35
36266 41842 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1459 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42231 5992090.13126179 2105515.92983571 37.7608904365533 -122.470478344247 (37.7608904365533, -122.470478344247) 1 8 4 56 12
36381 37477 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1466 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39948 5991509.07030691 2105439.09012647 37.7606458402301 -122.472482356472 (37.7606458402301, -122.472482356472) 1 8 4 56 12
39789 34659 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 3   Permit Number 38334 5987972.9693 2105119.7321 37.7595636656584 -122.484688551924 (37.7595636656584, -122.484688551924) 1 8 3 56 35
46004 37213 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1443 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 6   Permit Number 39778 5985860.9109 2105407.8744 37.7602315957486 -122.492014212427 (37.7602315957486, -122.492014212427) 1 8 3 56 35
46689 37212 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1443 33rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 5   Permit Number 39778 5985860.9109 2105390.2338 37.760183159546 -122.492012913605 (37.760183159546, -122.492012913605) 1 8 3 56 35
49100 37124 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
59456 44816 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986280.5132 2105006.9468 37.7591552772781 -122.490533528729 (37.7591552772781, -122.490533528729) 1 8 3 56 35
65067 38860 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1549 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 0   Permit Number 40687 5989292.62615578 2104803.36922141 37.758771784472 -122.480101420695 (37.758771784472, -122.480101420695) 1 8 3 56 35
67140 37133 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1496 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39716 5980947.80639526 2104858.25790377 37.758434095357 -122.508965208548 (37.758434095357, -122.508965208548) 1 8 3 56 35
67851 34930 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1790 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/1997 12:00:00 AM     Permit Number 38522 5991259.7839455 2103214.98783119 37.7545246106445 -122.473182309921 (37.7545246106445, -122.473182309921) 1 8 4 56 12
69553 37195 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1742 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM     Permit Number 39762 5986908.61171996 2103401.39400305 37.7547835348007 -122.488243305818 (37.7547835348007, -122.488243305818) 1 8 3 56 35
71470 44817 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986315.8836 2105009.2662 37.7591637116246 -122.490411373273 (37.7591637116246, -122.490411373273) 1 8 3 56 35
72686 34658 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 2   Permit Number 38334 5987988.7714 2105120.9797 37.7595680115028 -122.484633992596 (37.7595680115028, -122.484633992596) 1 8 3 56 35
75263 42277 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1718 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM 7   Permit Number 42514 5986906.0637 2103542.512 37.7551708577637 -122.488262487214 (37.7551708577637, -122.488262487214) 1 8 3 56 35
77557 34660 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 5   Permit Number 38334 5987955.9197 2105118.4846 37.759559247409 -122.484747425675 (37.759559247409, -122.484747425675) 1 8 3 56 35
79954 44818 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986255.58 2105005.7872 37.7591506369625 -122.490619673159 (37.7591506369625, -122.490619673159) 1 8 3 56 35
82029 38347 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1567 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM     Permit Number 40414 5981854.03597748 2104432.31461127 37.757317957298 -122.5057995404 (37.757317957298, -122.5057995404) 1 8 3 56 35
85584 38345 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1859 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM 0   Permit Number 40412 5982231.73051381 2102455.52324126 37.7519124687384 -122.504346906094 (37.7519124687384, -122.504346906094) 1 8 3 56 35
86192 37106 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1495 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39704 5981217.84304819 2104908.99665532 37.7585893245545 -122.508035083937 (37.7585893245545, -122.508035083937) 1 8 3 56 35
97486 36111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1290 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39208 5992413.02593495 2106678.51938145 37.7641012654702 -122.469446232974 (37.7641012654702, -122.469446232974) 11 8 11 56 12
99205 37134 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1496 La Playa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39716 5980947.80639526 2104858.25790377 37.758434095357 -122.508965208548 (37.758434095357, -122.508965208548) 1 8 3 56 35
99430 184739 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1301 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984690.4501 2106251.0591 37.7624782581791 -122.496124432854 (37.7624782581791, -122.496124432854) 1 8 3 56 35
100442 37225 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1471 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM     Permit Number 39789 5985552.67131947 2105212.4791892 37.759677072307 -122.493065858593 (37.759677072307, -122.493065858593) 1 8 3 56 35
100897 68054 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1881 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1993 12:00:00 AM     Permit Number 31791 5993737.20481548 2102706.11474697 37.7532705090115 -122.46457785688 (37.7532705090115, -122.46457785688) 1 8 4 56 12
103016 34646 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1596 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM     Permit Number 38325 5987803.91965419 2104439.10360026 37.7576849982837 -122.48522326103 (37.7576849982837, -122.48522326103) 1 8 3 56 35
116814 41829 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1406 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42215 5991820.03879919 2105845.80564429 37.7617805674142 -122.471436503306 (37.7617805674142, -122.471436503306) 1 8 4 56 12
119260 38854 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1466 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 3   Permit Number 40681 5989630.3392 2105375.4166 37.7603620895733 -122.478975308071 (37.7603620895733, -122.478975308071) 1 8 3 56 35
126430 37123 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
139892 38864 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1442 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 4   Permit Number 40691 5989006.457 2105496.048 37.7606570618134 -122.481141834437 (37.7606570618134, -122.481141834437) 1 8 3 56 35
140509 34630 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1766 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 3   Permit Number 38311 5988776.9552 2103320.2277 37.7546695008183 -122.481776191509 (37.7546695008183, -122.481776191509) 1 8 3 56 35
141950 34656 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 2   Permit Number 38334 5988021.6232 2105120.5638 37.7595687826789 -122.484520345625 (37.7595687826789, -122.484520345625) 1 8 3 56 35
146257 37125 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
163727 184740 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1301 Sunset Blvd 6 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984699.9431 2106237.7689 37.7624423230543 -122.496090619994 (37.7624423230543, -122.496090619994) 1 8 3 56 35
171637 37105 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1495 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39704 5981217.84304819 2104908.99665532 37.7585893245545 -122.508035083937 (37.7585893245545, -122.508035083937) 1 8 3 56 35
173565 38123 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1200 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM 5   Permit Number 40287 5985851.366 2107007.0192 37.7646218448258 -122.492164972302 (37.7646218448258, -122.492164972302) 1 8 3 56 35
175884 37069 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1474 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 4   Permit Number 39671 5983120.2149 2105112.095 37.7592588855971 -122.501470953069 (37.7592588855971, -122.501470953069) 1 8 3 56 35
178201 68496 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1822 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32372 5993466.35859208 2103074.11595722 37.7542653280544 -122.465541223192 (37.7542653280544, -122.465541223192) 1 8 4 56 12
178986 38863 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1565 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 0   Permit Number 40690 5989296.21457943 2104699.06297943 37.7584855960627 -122.480081376814 (37.7584855960627, -122.480081376814) 1 8 3 56 35
190933 40610 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1234 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/1999 12:00:00 AM 5   Permit Number 41621 5983375.0645 2106732.8195 37.7637239007009 -122.500709422357 (37.7637239007009, -122.500709422357) 1 8 3 56 35
193773 34629 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1766 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 6   Permit Number 38311 5988774.7652 2103307.0873 37.7546332934455 -122.481782802584 (37.7546332934455, -122.481782802584) 1 8 3 56 35
41684 68560 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32450 5981950.36786377 2112213.67297772 37.7786889858471 -122.506043321809 (37.7786889858471, -122.506043321809) 11 6 2 55 26
67090 90956 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4645 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2008 12:00:00 AM 3 3x3   5981155.43871 2110931.20899 37.7751208933778 -122.508698002643 (37.7751208933778, -122.508698002643) 11 6 2 55 26
77362 42163 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4630 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42458 5989047.18920071 2109907.45432155 37.7727719459225 -122.481324019174 (37.7727719459225, -122.481324019174) 11 6 2 55 26
129953 42147 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 490 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM     Permit Number 42443 5990026.73861506 2112033.51240967 37.7786664170583 -122.478091152159 (37.7786664170583, -122.478091152159) 11 6 2 55 26
162238 68548 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 542 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32435 5982266.27393695 2112076.97528737 37.7783322447781 -122.504940366327 (37.7783322447781, -122.504940366327) 11 6 2 55 26
34181 68180 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 75 Rossi Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1993 12:00:00 AM     Permit Number 31952 5996329.36645327 2111693.70801186 37.7780972208044 -122.456263479509 (37.7780972208044, -122.456263479509) 11 6 2 54 16
61291 113491 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 366x 07TH AVE 1 Sidewalk: Property side : Cutout Tree Private 2   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712 2113143 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165) 11 6 2 54 11
64036 43694 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 750 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43338 5993218.66242977 2110366.15850001 37.7742730687673 -122.46692789928 (37.7742730687673, -122.46692789928) 11 6 2 54 11
70992 38813 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 343 11th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1998 12:00:00 AM     Permit Number 40648 5992447.48955931 2113145.89233921 37.7818609227719 -122.469797921948 (37.7818609227719, -122.469797921948) 11 6 2 54 11
79658 141253 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 45 PARKER AVE 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5996809.5439 2114265.4407 37.7851860717648 -122.454788237668 (37.7851860717648, -122.454788237668) 11 6 1 54 31
104093 36188 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 35 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1998 12:00:00 AM 7   Permit Number 39256 5996804.8059 2114366.2904 37.7854627064304 -122.454811918638 (37.7854627064304, -122.454811918638) 11 6 1 54 31
106945 140845 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 527 EUCLID AVE 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5996698.8799 2113809.925 37.7839289983891 -122.455138170133 (37.7839289983891, -122.455138170133) 11 6 1 54 31
108586 38812 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 343 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1998 12:00:00 AM     Permit Number 40648 5992447.48955931 2113145.89233921 37.7818609227719 -122.469797921948 (37.7818609227719, -122.469797921948) 11 6 2 54 11
140389 36187 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 35 Parker Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1998 12:00:00 AM 8   Permit Number 39256 5996805.8212 2114349.7078 37.7854172332631 -122.45480720749 (37.7854172332631, -122.45480720749) 11 6 1 54 31
155194 55092 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 535 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2017 12:00:00 AM 3   Permit Number 779353 5990916.44075 2111744.45268 37.7779243407011 -122.474992253786 (37.7779243407011, -122.474992253786) 11 6 2 54 26
162751 43695 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 754 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43339 5993219.60495236 2110339.98425191 37.7742012556984 -122.466922735732 (37.7742012556984, -122.466922735732) 11 6 2 54 11
180365 141254 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 45 PARKER AVE 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5996808.5286 2114260.026 37.7851711462005 -122.454791358921 (37.7851711462005, -122.454791358921) 11 6 1 54 31
18513 38167 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 315 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40305 6010555.26362325 2092792.3936381 37.7270047480515 -122.405719032848 (37.7270047480515, -122.405719032848) 10 3 7 309 28
20022 35741 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 231 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39015 6007788.68777846 2092857.60054619 37.7270286926321 -122.415287680245 (37.7270286926321, -122.415287680245) 9 3 7 309 28
23158 38196 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 730 Girard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40323 6011305.3220934 2091453.71988413 37.7233709423274 -122.403031960796 (37.7233709423274, -122.403031960796) 10 3 7 309 28
43878 38172 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 433 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40308 6010665.04465284 2092691.20819375 37.7267330524509 -122.405332397121 (37.7267330524509, -122.405332397121) 10 3 7 309 28
44351 37782 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 289 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM     Permit Number 40117 6009320.94225991 2092982.60267054 37.7274579192917 -122.409999500097 (37.7274579192917, -122.409999500097) 10 3 7 309 28
72189 38209 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 830 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40332 6010874.68113014 2090828.02861629 37.7216288654759 -122.40447659257 (37.7216288654759, -122.40447659257) 10 3 7 309 28
86025 38199 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 455 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40326 6010407.74547618 2092510.58020697 37.7262226967111 -122.406209156508 (37.7262226967111, -122.406209156508) 10 3 7 309 28
86559 38511 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 64 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1998 12:00:00 AM     Permit Number 40500 6008516.43042503 2087785.37039582 37.7131422875132 -122.412413505045 (37.7131422875132, -122.412413505045) 9 7 8 309 39
89187 251679 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 5 Dwight St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011495 2091622 37.7238435952898 -122.402388102511 (37.7238435952898, -122.402388102511) 10 3 7 309 28
111237 38179 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 36 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40312 6011464.3100447 2091682.81198966 37.7240088592297 -122.402498467389 (37.7240088592297, -122.402498467389) 10 3 7 309 28
116815 35745 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1005 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39018 6007884.66062501 2093417.72691387 37.728572072766 -122.414995531053 (37.728572072766, -122.414995531053) 9 3 7 309 5

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