trees
400 rows where qSpecies_id = 43 sorted by Location
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170691 | 37458 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39930 | 6010305.7989409 | 2099791.60340169 | 37.7462091274065 | -122.407074571233 | (37.7462091274065, -122.407074571233) | 2 | 7 | 7 | 28859 | 2 | ||
10411 | 47385 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45301 | 6001377.58877778 | 2100188.59270033 | 37.7467954887327 | -122.437975585037 | (37.7467954887327, -122.437975585037) | 2 | 4 | 5 | 63 | 22 | |||
37916 | 233997 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1027 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001336.17311 | 2100800.0445 | 37.7484720346532 | -122.438162590655 | (37.7484720346532, -122.438162590655) | 2 | 4 | 5 | 28862 | 22 | |||
68189 | 68517 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32397 | 5993053.91795071 | 2101210.30087773 | 37.7491239746497 | -122.466832052807 | (37.7491239746497, -122.466832052807) | 1 | 8 | 4 | 29491 | 12 | ||
165109 | 39139 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
168287 | 39138 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
19915 | 37424 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
110816 | 37426 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
125708 | 37427 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
126600 | 37423 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
115816 | 67467 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4078 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 30982 | 6003350.50488606 | 2101289.69360575 | 37.7499308522406 | -122.431232018452 | (37.7499308522406, -122.431232018452) | 2 | 4 | 5 | 28862 | 22 | ||
183661 | 79350 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1946 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767118 | 5983237.8759 | 2101878.6369 | 37.7503876245198 | -122.500824911735 | (37.7503876245198, -122.500824911735) | 1 | 8 | 3 | 29491 | 35 |
74396 | 121619 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 1465 Rhode Island St | 1 | Front Yard : Yard | Tree | Private 2 | 6012073 | 2101555 | 37.7511497699027 | -122.401087656443 | (37.7511497699027, -122.401087656443) | 10 | 3 | 8 | 28856 | 29 | |||||
172670 | 39490 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4054 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40948 | 6002823.01095214 | 2101848.4791437 | 37.7514352381886 | -122.433096036215 | (37.7514352381886, -122.433096036215) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |
184586 | 37749 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1271 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1999 12:00:00 AM | Permit Number 40096 | 6009537.93489258 | 2101780.18844977 | 37.7516263413346 | -122.409870111191 | (37.7516263413346, -122.409870111191) | 2 | 4 | 7 | 28859 | 19 | ||
93886 | 68599 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.473171429533 | (37.7517787113613, -122.473171429533) | 1 | 8 | 4 | 29491 | 12 | ||
190034 | 69279 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1935 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33350 | 5991240.95366227 | 2102241.42925325 | 37.7518503834746 | -122.473176432428 | (37.7518503834746, -122.473176432428) | 1 | 8 | 4 | 29491 | 12 | ||
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 | |
75146 | 42256 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1451 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42500 | 6014382.14951701 | 2101979.25998884 | 37.7524432441755 | -122.39313199334 | (37.7524432441755, -122.39313199334) | 10 | 3 | 8 | 28856 | 1 | |||
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 | ||
151337 | 36907 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40695 | 6000695.68812692 | 2102606.86536781 | 37.7533966824522 | -122.440506941015 | (37.7533966824522, -122.440506941015) | 2 | 4 | 5 | 28862 | 22 | ||
155234 | 39134 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 810 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2000 12:00:00 AM | Permit Number 40813 | 6007325.69907761 | 2102579.12781976 | 37.7536958179011 | -122.417576944272 | (37.7536958179011, -122.417576944272) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||
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 | |||
137219 | 35519 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 90 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38920 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
173663 | 37275 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3894 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39816 | 6002513.25180394 | 2102998.13185029 | 37.754574335137 | -122.434249400487 | (37.754574335137, -122.434249400487) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |
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 | |
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 | ||
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 | ||
163982 | 35510 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3478 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38912 | 6005194.49677521 | 2103146.93967049 | 37.7551347452856 | -122.424987522768 | (37.7551347452856, -122.424987522768) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |
36835 | 37313 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 485 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39829 | 6003203.23907746 | 2103274.86360864 | 37.7553733132886 | -122.431883001431 | (37.7553733132886, -122.431883001431) | 2 | 4 | 5 | 28862 | 22 | ||
154775 | 37314 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 485 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39829 | 6003203.23907746 | 2103274.86360864 | 37.7553733132886 | -122.431883001431 | (37.7553733132886, -122.431883001431) | 2 | 4 | 5 | 28862 | 22 | ||
148447 | 35550 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 50 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.424455886685 | (37.7558983622011, -122.424455886685) | 2 | 4 | 5 | 28859 | 19 | ||
183856 | 35549 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 50 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.424455886685 | (37.7558983622011, -122.424455886685) | 2 | 4 | 5 | 28859 | 19 | ||
80984 | 36908 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 394 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39556 | 6001774.84404362 | 2103557.93464621 | 37.7560694803843 | -122.436843078117 | (37.7560694803843, -122.436843078117) | 2 | 4 | 5 | 28862 | 3 | ||
114946 | 35548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38924 | 6005398.06539258 | 2103564.19233402 | 37.7562919206066 | -122.424313197508 | (37.7562919206066, -122.424313197508) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
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 | |
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 | |||
72751 | 37286 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 699 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2002 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |
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 | |||
98168 | 37716 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 943 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40086 | 6007607.04837726 | 2104169.37424002 | 37.7580780981898 | -122.416716622543 | (37.7580780981898, -122.416716622543) | 2 | 4 | 7 | 28859 | 19 | ||
180479 | 35494 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3763 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38905 | 6005241.37948762 | 2104264.99377415 | 37.758207308358 | -122.424904929122 | (37.758207308358, -122.424904929122) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
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 | ||
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 | |
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 | |||
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 | ||
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 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
3588 | 37560 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 39999 | 6000466.36495931 | 2104620.54811441 | 37.758912703603 | -122.44144447135 | (37.758912703603, -122.44144447135) | 2 | 4 | 5 | 28862 | 38 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | |||
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 | |||
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 | |
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 | |
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 | |
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 | ||
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 | |
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 | ||
42365 | 39173 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 7461 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.417196465004 | (37.7612079095392, -122.417196465004) | 2 | 4 | 7 | 28859 | 19 | ||
87797 | 39174 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 7461 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.417196465004 | (37.7612079095392, -122.417196465004) | 2 | 4 | 7 | 28859 | 19 | ||
39432 | 37587 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
62613 | 37588 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
65609 | 37589 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
79487 | 37590 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
79486 | 37707 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
166564 | 37709 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
168179 | 37708 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||
32928 | 37704 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
96433 | 37701 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
124119 | 37706 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
128039 | 37702 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
168833 | 37703 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
174203 | 37705 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
183814 | 37700 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||
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 | |||
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 | |||
152141 | 40299 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );