trees
508 rows where qSpecies_id = 25 sorted by Location descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142404 | 29761 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6008886.8317032 | 2121139.4877644 | 37.8047458740943 | -122.4134907456 | (37.8047458740943, -122.4134907456) | 3 | 1 | 10 | 308 | 23 | |||
154517 | 29760 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6008840.5335 | 2121127.883 | 37.8047114106213 | -122.413650144484 | (37.8047114106213, -122.413650144484) | 3 | 1 | 10 | 308 | 23 | |||
58362 | 142702 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008814.8812 | 2121126.1728 | 37.8047052743397 | -122.413738796098 | (37.8047052743397, -122.413738796098) | 3 | 1 | 10 | 308 | 23 | |||
100419 | 142692 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 590x Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008663 | 2121123 | 37.8046880323907 | -122.414264173266 | (37.8046880323907, -122.414264173266) | 3 | 1 | 10 | 308 | 23 | |||
173725 | 142691 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 590x Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008663 | 2121123 | 37.8046880323907 | -122.414264173266 | (37.8046880323907, -122.414264173266) | 3 | 1 | 10 | 308 | 23 | |||
27821 | 29763 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 530 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | |||
125841 | 26544 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 530 Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1997 12:00:00 AM | 3 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | ||
96423 | 142687 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 550 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008655.2673 | 2121104.5109 | 37.8046368316065 | -122.414289624157 | (37.8046368316065, -122.414289624157) | 3 | 1 | 10 | 308 | 23 | |||
176686 | 142688 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 552 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6008641.5861 | 2121102.2307 | 37.8046298022358 | -122.414336807992 | (37.8046298022358, -122.414336807992) | 3 | 1 | 10 | 308 | 23 | |||
88947 | 142690 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 560 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008610.8035 | 2121097.1003 | 37.8046139862257 | -122.414442971246 | (37.8046139862257, -122.414442971246) | 3 | 1 | 10 | 308 | 23 | |||
67816 | 29766 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 570 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | 3 | 1 | 10 | 308 | 23 | |||
169334 | 29765 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 570 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | 3 | 1 | 10 | 308 | 23 | |||
187086 | 26547 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 570 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1999 12:00:00 AM | 6 | 4X4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | 3 | 1 | 10 | 308 | 23 | ||
5319 | 26546 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 570 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2020 12:45:00 PM | 3 | 4X4 | 6008578.3106 | 2121094.8201 | 37.804605899968 | -122.414555254943 | (37.804605899968, -122.414555254943) | 3 | 1 | 10 | 308 | 23 | ||
13990 | 142563 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 555 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:42:00 PM | 3 | Width 0ft | 6008640.5494 | 2121060.0298 | 37.8045138709312 | -122.414337407838 | (37.8045138709312, -122.414337407838) | 3 | 1 | 10 | 308 | 23 | ||
133210 | 142723 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008387.4711 | 2121064.7168 | 37.8045125206489 | -122.415213542996 | (37.8045125206489, -122.415213542996) | 5 | 1 | 10 | 308 | 23 | |||
96307 | 142724 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008368.8817 | 2121063.6546 | 37.8045085593837 | -122.415277798263 | (37.8045085593837, -122.415277798263) | 5 | 1 | 10 | 308 | 23 | |||
101588 | 142725 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 620 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008308.3331 | 2121058.3433 | 37.8044905727941 | -122.41548695656 | (37.8044905727941, -122.41548695656) | 5 | 1 | 10 | 308 | 23 | |||
113210 | 29768 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 640 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1991 12:00:00 AM | 6 | 6x6 | 6008286.5569 | 2121053.032 | 37.8044747652934 | -122.415561939011 | (37.8044747652934, -122.415561939011) | 5 | 1 | 10 | 308 | 23 | ||
42399 | 7700 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.8044437236489 | -122.415905321467 | (37.8044437236489, -122.415905321467) | 5 | 1 | 10 | 308 | 23 | |||
38044 | 255484 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2147 Beach St | : | Tree | Private 2 | FUF | 05/30/2018 12:00:00 AM | 3 | Permit Number 781954 | 5999947.25363 | 2120887.03087 | 37.8035466909489 | -122.444408807729 | (37.8035466909489, -122.444408807729) | 13 | 9 | 1 | 57 | 17 | ||
120732 | 81925 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2316 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50640 | 6007582.8644 | 2120346.37282 | 37.8024948784062 | -122.417947010953 | (37.8024948784062, -122.417947010953) | 5 | 1 | 1 | 308 | 32 | |
46881 | 128878 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | 5 | 9 | 1 | 28858 | 32 | |||
13543 | 83275 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1639X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008740.14676 | 2118614.90766 | 37.7978057691893 | -122.413819676732 | (37.7978057691893, -122.413819676732) | 5 | 1 | 10 | 308 | 21 | |||
19143 | 83274 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1639X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008741.72565 | 2118600.65097 | 37.7977667125146 | -122.41381320433 | (37.7977667125146, -122.41381320433) | 5 | 1 | 10 | 308 | 21 | |||
64250 | 128879 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Balance St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6012011.13763 | 2118129.24016 | 37.7966553941982 | -122.402466903231 | (37.7966553941982, -122.402466903231) | 3 | 1 | 10 | 28860 | 4 | |||
23417 | 128877 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 6 | Median : Yard | Tree | DPW 1 | 3 | 6007635.08843 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | 5 | 1 | 10 | 28858 | 32 | ||||
121745 | 128876 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 5 | Median : Yard | Tree | DPW 1 | 3 | 6007635.33447 | 2118142.36056 | 37.7964461660197 | -122.417609134775 | (37.7964461660197, -122.417609134775) | 5 | 1 | 10 | 28858 | 32 | ||||
172661 | 128875 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 2 | Median : Yard | Tree | DPW 1 | 2 | 6007636.05536 | 2118136.67489 | 37.7964305951503 | -122.417606237154 | (37.7964305951503, -122.417606237154) | 5 | 1 | 10 | 28858 | 32 | ||||
182240 | 128872 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008617.8933 | 2116985.80522 | 37.7933257892186 | -122.414127394165 | (37.7933257892186, -122.414127394165) | 5 | 1 | 10 | 28857 | 21 | |||
92905 | 128873 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | 5 | 1 | 10 | 28857 | 21 | |||
34506 | 128874 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.414254814618 | (37.7933104368651, -122.414254814618) | 5 | 1 | 10 | 28857 | 21 | |||
25269 | 128865 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001864.71047 | 2116045.71849 | 37.7903629286659 | -122.437426485651 | (37.7903629286659, -122.437426485651) | 13 | 6 | 1 | 29490 | 27 | |||
53060 | 128866 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001800.9878 | 2116040.20004 | 37.7903441535036 | -122.43764656594 | (37.7903441535036, -122.43764656594) | 13 | 6 | 1 | 29490 | 27 | |||
119348 | 128867 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001756.03579 | 2116033.5731 | 37.7903234016642 | -122.437801621649 | (37.7903234016642, -122.437801621649) | 13 | 6 | 1 | 29490 | 27 | |||
186337 | 128868 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001720.521 | 2116028.9102 | 37.790308579028 | -122.437924165962 | (37.790308579028, -122.437924165962) | 13 | 6 | 1 | 29490 | 27 | |||
47916 | 128869 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | 13 | 6 | 1 | 29490 | 27 | |||
179715 | 128870 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6001597.99168 | 2116010.93406 | 37.7902522526915 | -122.438346819465 | (37.7902522526915, -122.438346819465) | 13 | 6 | 1 | 29490 | 27 | |||
149327 | 128871 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6001562.05606 | 2116003.40074 | 37.7902295241198 | -122.438470613846 | (37.7902295241198, -122.438470613846) | 13 | 6 | 1 | 29490 | 27 | |||
49712 | 47473 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2713 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45374 | 6001758.37714 | 2115982.95149 | 37.7901845409254 | -122.437789893616 | (37.7901845409254, -122.437789893616) | 13 | 6 | 1 | 29490 | 27 | |
9717 | 56360 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1973 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | 13 | 6 | 1 | 29490 | 27 | |
57319 | 65448 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 72 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/1989 12:00:00 AM | 9 | Permit Number 28322 | 5994279.76671 | 2115099.74179 | 37.7873314010144 | -122.463600988074 | (37.7873314010144, -122.463600988074) | 11 | 6 | 1 | 54 | 11 | ||
11961 | 115127 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
69946 | 115126 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
109240 | 115128 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
128761 | 115129 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
181947 | 115130 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
16772 | 113034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 251 06th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 2 | 3x3 | 5993975.1139 | 2113804.1265 | 37.7837564355183 | -122.464560902617 | (37.7837564355183, -122.464560902617) | 11 | 6 | 2 | 54 | 11 | |||
22267 | 82278 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50610 | 5992733.47806 | 2113805.1753 | 37.7836876598148 | -122.468856534024 | (37.7836876598148, -122.468856534024) | 11 | 6 | 2 | 54 | 11 | |
28535 | 41155 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 21 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1999 12:00:00 AM | Permit Number 41884 | 5997452.09163541 | 2113544.02640038 | 37.7832420947214 | -122.452513152989 | (37.7832420947214, -122.452513152989) | 15 | 6 | 1 | 54 | 31 | |||
171054 | 140348 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1314 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004545.774 | 2113311.1445 | 37.7830065306397 | -122.427955242977 | (37.7830065306397, -122.427955242977) | 7 | 9 | 11 | 29490 | 41 | |||
46410 | 6257 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | 7 | 9 | 11 | 29490 | 41 | |||
15349 | 122920 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 330 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2020 12:00:00 AM | 3 | Width 2ft | 5992493.10071 | 2113220.22773 | 37.7820676636923 | -122.469645543184 | (37.7820676636923, -122.469645543184) | 11 | 6 | 2 | 54 | 11 | ||
11255 | 70154 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 339 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5992446.53753 | 2113177.4125 | 37.7819474134806 | -122.469803511026 | (37.7819474134806, -122.469803511026) | 11 | 6 | 2 | 54 | 11 | |||
37585 | 105310 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 355 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3 x4 | 5990544.7 | 2113008.3 | 37.781372965217 | -122.476370566984 | (37.781372965217, -122.476370566984) | 11 | 6 | 2 | 55 | 26 | |||
31262 | 69447 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 479 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33557 | 5985917.32246977 | 2112668.61009419 | 37.7801708274431 | -122.492353790965 | (37.7801708274431, -122.492353790965) | 11 | 6 | 2 | 55 | 26 | ||
126766 | 22760 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1620 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6002287.3238 | 2112301.156 | 37.7801053300032 | -122.435696258637 | (37.7801053300032, -122.435696258637) | 15 | 5 | 11 | 29490 | 41 | |||
45794 | 108472 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | 11 | 6 | 2 | 54 | 11 | |||
179219 | 123212 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5993143.5323 | 2112325.5219 | 37.7796486158053 | -122.467330287378 | (37.7796486158053, -122.467330287378) | 11 | 6 | 2 | 54 | 11 | |||
63451 | 105311 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 455 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x3 | 5990571.2 | 2112282.7 | 37.7793822053088 | -122.476225875432 | (37.7793822053088, -122.476225875432) | 11 | 6 | 2 | 55 | 26 | |||
130161 | 122086 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 459 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990589.94258 | 2112248.552 | 37.7792895311955 | -122.476158542806 | (37.7792895311955, -122.476158542806) | 11 | 6 | 2 | 55 | 26 | |||
17383 | 258113 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Freelon St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6013235.08289 | 2111410.77261 | 37.7782762981131 | -122.397760259133 | (37.7782762981131, -122.397760259133) | 6 | 2 | 9 | 28856 | 34 | |||||
189829 | 141447 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 196 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5996894.8261 | 2111600.0306 | 37.7778724506652 | -122.454300593509 | (37.7778724506652, -122.454300593509) | 15 | 6 | 2 | 54 | 16 | |||
165027 | 81695 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 539 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52514 | 5990609.14307 | 2111709.86868 | 37.7778115687685 | -122.476052767078 | (37.7778115687685, -122.476052767078) | 11 | 6 | 2 | 55 | 26 | |
70921 | 33910 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1456 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1997 12:00:00 AM | Permit Number 37880 | 6000788.78339737 | 2111054.09529381 | 37.7765959861438 | -122.440790896143 | (37.7765959861438, -122.440790896143) | 15 | 5 | 11 | 29492 | 41 | |||
64629 | 142235 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | 7 | 9 | 11 | 28852 | 10 | |||
67621 | 128862 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 689 Hayes St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | 7 | 9 | 11 | 28852 | 10 | |||
95938 | 128864 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 628 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004541.11924 | 2110775.90598 | 37.7760451281037 | -122.427790646526 | (37.7760451281037, -122.427790646526) | 7 | 9 | 11 | 28852 | 10 | |||
48618 | 142233 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | 7 | 9 | 11 | 28852 | 10 | |||
92573 | 128863 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 628 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004545.79116 | 2110745.60377 | 37.7759621899439 | -122.427772325535 | (37.7759621899439, -122.427772325535) | 7 | 9 | 11 | 28852 | 10 | |||
53663 | 142232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.7759314506272 | -122.427749815271 | (37.7759314506272, -122.427749815271) | 7 | 9 | 11 | 28852 | 10 | |||
43636 | 94704 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 670 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53844 | 5992265.91007 | 2110887.94739 | 37.7756507238334 | -122.470261618584 | (37.7756507238334, -122.470261618584) | 11 | 6 | 2 | 54 | 11 |
186208 | 59942 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 625 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 13 | Permit Number 19416 | 5999638.7469 | 2110673.4971 | 37.7754853988158 | -122.444741829234 | (37.7754853988158, -122.444741829234) | 15 | 5 | 11 | 29492 | 16 | |
99856 | 48556 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 615 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/2002 12:00:00 AM | 3 | Permit Number 45872 | 5999645.29400405 | 2110579.50430317 | 37.7752276921804 | -122.444712423834 | (37.7752276921804, -122.444712423834) | 15 | 5 | 11 | 29492 | 16 | |
119640 | 10695 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001856.34415 | 2110522.16346 | 37.7751961745675 | -122.437059807317 | (37.7751961745675, -122.437059807317) | 15 | 5 | 11 | 29492 | 10 | |||
68217 | 10694 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001838.4236 | 2110502.6134 | 37.7751414763631 | -122.437120398394 | (37.7751414763631, -122.437120398394) | 15 | 5 | 11 | 29492 | 10 | |||
32550 | 59941 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1706 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 0 | Permit Number 19415 | 5999632.27517388 | 2110547.02087839 | 37.7751377580465 | -122.444755123369 | (37.7751377580465, -122.444755123369) | 15 | 5 | 11 | 29492 | 16 | |
27755 | 82843 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | 8 | 2 | 9 | 28853 | 34 | |
122480 | 38842 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1273 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40672 | 6001780.14804372 | 2110445.45784357 | 37.7749812288155 | -122.437317892677 | (37.7749812288155, -122.437317892677) | 15 | 5 | 11 | 29492 | 10 | ||||
119488 | 59933 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 9 | Permit Number 19406 | 5999664.8686 | 2110448.6759 | 37.7748695877317 | -122.444635305779 | (37.7748695877317, -122.444635305779) | 15 | 5 | 11 | 29492 | 16 | |
172040 | 51066 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | 8 | 2 | 9 | 28853 | 19 | |||
87972 | 112871 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5999666.6578 | 2110431.976 | 37.7748238361568 | -122.444627916028 | (37.7748238361568, -122.444627916028) | 15 | 5 | 11 | 29492 | 16 | |||
156454 | 32624 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 39 Boardman Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 7 | Permit Number 37079 | 6011697.70075 | 2110139.81067 | 37.7747007963356 | -122.402989243876 | (37.7747007963356, -122.402989243876) | 14 | 2 | 9 | 28853 | 34 | |
147726 | 114483 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x2 | 6009096 | 2110140 | 37.7745556909018 | -122.411989099957 | (37.7745556909018, -122.411989099957) | 8 | 2 | 9 | 28853 | 34 | |||
11951 | 142340 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.7745244442512 | -122.444402018718 | (37.7745244442512, -122.444402018718) | 15 | 5 | 11 | 29492 | 16 | |||
158358 | 59931 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 521 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 12 | Permit Number 19403 | 5999683.6559 | 2110322.5324 | 37.7745243018378 | -122.444561248652 | (37.7745243018378, -122.444561248652) | 15 | 5 | 11 | 29492 | 16 | |
192132 | 112711 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 782 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 1 | 6009126.82605 | 2110111.36785 | 37.774478803191 | -122.411880442527 | (37.774478803191, -122.411880442527) | 8 | 2 | 9 | 28853 | 34 | ||
91845 | 247455 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6003122.801 | 2110193.1484 | 37.7743646855214 | -122.432655343876 | (37.7743646855214, -122.432655343876) | 15 | 9 | 11 | 29492 | 10 | |||
139062 | 142338 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 510 Central Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5999738.5075 | 2110257.1017 | 37.7743477755014 | -122.444366803816 | (37.7743477755014, -122.444366803816) | 15 | 5 | 11 | 29492 | 16 | |||
35833 | 142337 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553 | -122.44434874809 | (37.774300725553, -122.44434874809) | 15 | 5 | 11 | 29492 | 16 | |||
137342 | 32627 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011835.14299 | 2109991.00563 | 37.774299885758 | -122.402503334756 | (37.774299885758, -122.402503334756) | 14 | 2 | 9 | 28853 | 34 | |
32236 | 32806 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1686 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943365 | (37.7742503589901, -122.44417943365) | 15 | 5 | 11 | 29492 | 16 | ||
79262 | 32807 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1686 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943365 | (37.7742503589901, -122.44417943365) | 15 | 5 | 11 | 29492 | 16 | ||
93399 | 32626 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 14 | Permit Number 37080 | 6011867.62207 | 2109962.18755 | 37.7742225710588 | -122.402388956281 | (37.7742225710588, -122.402388956281) | 14 | 2 | 9 | 28853 | 34 | |
83440 | 32625 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011878.08124 | 2109949.48586 | 37.7741882789872 | -122.402351882652 | (37.7741882789872, -122.402351882652) | 14 | 2 | 9 | 28853 | 34 | |
177554 | 59937 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1738 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 19410 | 5999529.55338039 | 2110184.14033447 | 37.7741355180618 | -122.445084365992 | (37.7741355180618, -122.445084365992) | 15 | 5 | 11 | 29492 | 16 | ||
93322 | 52137 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 4 | 3x3 | Permit Number 48316 | 6003127.26918681 | 2110108.47893411 | 37.7741324574889 | -122.432633838295 | (37.7741324574889, -122.432633838295) | 15 | 9 | 11 | 29492 | 10 | |
112936 | 142206 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1693 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999789.089 | 2110173.0386 | 37.7741198453954 | -122.444185791724 | (37.7741198453954, -122.444185791724) | 15 | 5 | 11 | 29492 | 16 | |||
131118 | 59938 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1774 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | Permit Number 19411 | 5999360.65261909 | 2110160.72458075 | 37.7740615827199 | -122.445666937047 | (37.7740615827199, -122.445666937047) | 15 | 5 | 11 | 29492 | 16 | ||
145759 | 59939 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1778 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 1 | Permit Number 19412 | 5999341.88585809 | 2110158.12282899 | 37.7740533674999 | -122.445731667127 | (37.7740533674999, -122.445731667127) | 15 | 5 | 11 | 29492 | 16 |
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) );